SET client_encoding = 'utf-8';
SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "bassin_versant_topographique" CASCADE;
BEGIN;
CREATE TABLE "bassin_versant_topographique"();
SELECT AddGeometryColumn('bassin_versant_topographique','geometrie',4471,'GEOMETRY',2);
CREATE INDEX "bassin_versant_topographique_geometrie_geom_idx" ON "bassin_versant_topographique" USING GIST ("geometrie");
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "liens_vers_cours_d_eau_principal" VARCHAR;
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "code_bdcarthage" VARCHAR(4);
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "code_du_bassin_hydrographique" VARCHAR(2);
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "commentaire_sur_l_objet_hydro" VARCHAR;
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "origine" VARCHAR;
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "bassin_fluvial" VARCHAR(30);
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "statut" VARCHAR;
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "mode_d_obtention_des_coordonnees" VARCHAR;
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "precision_planimetrique" NUMERIC(5,1);
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "methode_d_acquisition_planimetrique" VARCHAR;
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "identifiants_sources" VARCHAR;
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "sources" VARCHAR;
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "date_de_confirmation" date;
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "date_d_apparition" date;
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "date_modification" timestamp with time zone;
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "date_creation" timestamp with time zone;
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "libelle_du_bassin_hydrographique" VARCHAR(30);
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "toponyme" VARCHAR;
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "code_hydrographique" VARCHAR(19);
ALTER TABLE "bassin_versant_topographique" ADD COLUMN "cleabs" VARCHAR(24);
COMMIT;
SET standard_conforming_strings = OFF;
BEGIN;
COPY "bassin_versant_topographique" ("geometrie", "liens_vers_cours_d_eau_principal", "code_bdcarthage", "code_du_bassin_hydrographique", "commentaire_sur_l_objet_hydro", "origine", "bassin_fluvial", "statut", "mode_d_obtention_des_coordonnees", "precision_planimetrique", "methode_d_acquisition_planimetrique", "identifiants_sources", "sources", "date_de_confirmation", "date_d_apparition", "date_modification", "date_creation", "libelle_du_bassin_hydrographique", "toponyme", "code_hydrographique", "cleabs") FROM STDIN;
[encoded data, 129364 characters]	COURDEAU0000002215708624	3073	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Mroni Antanana	11B0000002244042883	BASSVERS0000002244042883
[encoded data, 49524 characters]	COURDEAU0000002215748183	3075	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Sazilé Sud	11B0000002244042884	BASSVERS0000002244042884
[encoded data, 123374 characters]	COURDEAU0000002215708595	3074	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Mroni Bé	11B0000002244042885	BASSVERS0000002244042885
[encoded data, 143604 characters]	COURDEAU0000002215708588	3072	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Mroni Djialimou	11B0000002244042886	BASSVERS0000002244042886
[encoded data, 172814 characters]	COURDEAU0000002215748251	3082	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Anse Bambo	11B0000002244042887	BASSVERS0000002244042887
[encoded data, 132084 characters]	COURDEAU0000002215748101	3071	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Baie de Mzouazia	11B0000002244042889	BASSVERS0000002244042889
[encoded data, 104052 characters]	COURDEAU0000002215748085	3063	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Baie de Bouéni Ouest	11B0000002244042890	BASSVERS0000002244042890
[encoded data, 88180 characters]	COURDEAU0000002215748028	3061	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Baie de Bouéni Nord	11B0000002244042893	BASSVERS0000002244042893
[encoded data, 61948 characters]	COURDEAU0000002215747472	3001	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Petite-Terre	11B0000002244042899	BASSVERS0000002244042899
[encoded data, 110100 characters]	COURDEAU0000002215708592	3052	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Mro Walé	11B0000002244042901	BASSVERS0000002244042901
[encoded data, 83316 characters]	COURDEAU0000002215708635	3043	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Mroni Massimoni	11B0000002244042905	BASSVERS0000002244042905
[encoded data, 77108 characters]	COURDEAU0000002215747864	3047	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Mroni Batrini	11B0000002244042907	BASSVERS0000002244042907
[encoded data, 69716 characters]	COURDEAU0000002215708620	3046	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Mroni Béja	11B0000002244042908	BASSVERS0000002244042908
[encoded data, 81454 characters]	COURDEAU0000002215747618	3023	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Majikavo	11B0000002244042909	BASSVERS0000002244042909
[encoded data, 68564 characters]	COURDEAU0000002215708626	3045	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Mroni Boungoumouhé	11B0000002244042910	BASSVERS0000002244042910
[encoded data, 60404 characters]	COURDEAU0000002215708628	3042	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Mroni M'Tsanga Vili	11B0000002244042911	BASSVERS0000002244042911
[encoded data, 91028 characters]	COURDEAU0000002215708612	3044	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Mroni Adrianabé	11B0000002244042916	BASSVERS0000002244042916
[encoded data, 80116 characters]	COURDEAU0000002215708608	3041	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Mroni Kavani	11B0000002244042918	BASSVERS0000002244042918
[encoded data, 151924 characters]	COURDEAU0000002215747666	3031	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	M'Tsamboro	11B0000002244042919	BASSVERS0000002244042919
[encoded data, 107316 characters]	COURDEAU0000002215747681	3032	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Handréma	11B0000002244042920	BASSVERS0000002244042920
[encoded data, 164610 characters]	COURDEAU0000002215708604	3033	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Dzoumogné	11B0000002244042921	BASSVERS0000002244042921
[encoded data, 197268 characters]	COURDEAU0000002215708590	3062	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	\N	2021/05/20 08:35:34.034	Mayotte	Baie de Bouéni Centre	11B0000002244042922	BASSVERS0000002244042922
[encoded data, 136532 characters]	COURDEAU0000002215708569	3035	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Bouyouni	11B0000002244042912	BASSVERS0000002244042912
[encoded data, 72404 characters]	COURDEAU0000002215708614	3034	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Maouéni	11B0000002244042913	BASSVERS0000002244042913
[encoded data, 98644 characters]	COURDEAU0000002215708615	3022	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Kangani	11B0000002244042914	BASSVERS0000002244042914
[encoded data, 109748 characters]	COURDEAU0000002215708641	3036	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Longoni	11B0000002244042915	BASSVERS0000002244042915
[encoded data, 74420 characters]	COURDEAU0000002215708596	3021	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa M'Gombani	11B0000002244042917	BASSVERS0000002244042917
[encoded data, 173716 characters]	COURDEAU0000002215708577	3054	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Coconi	11B0000002244042894	BASSVERS0000002244042894
[encoded data, 132014 characters]	COURDEAU0000002215708576	3014	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Kwalé	11B0000002244042895	BASSVERS0000002244042895
[encoded data, 158964 characters]	COURDEAU0000002215708637	3092	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Dembéni	11B0000002244042896	BASSVERS0000002244042896
[encoded data, 66644 characters]	COURDEAU0000002215708570	3091	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Ironi Bé	11B0000002244042897	BASSVERS0000002244042897
[encoded data, 208276 characters]	COURDEAU0000002215708580	3053	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Ourovéni	11B0000002244042898	BASSVERS0000002244042898
[encoded data, 73748 characters]	COURDEAU0000002215708599	3012	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Doujani	11B0000002244042900	BASSVERS0000002244042900
[encoded data, 118484 characters]	COURDEAU0000002215708587	3011	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Majimbini	11B0000002244042902	BASSVERS0000002244042902
[encoded data, 105268 characters]	COURDEAU0000002215708591	3013	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Gouloué	11B0000002244042903	BASSVERS0000002244042903
[encoded data, 96276 characters]	COURDEAU0000002215708622	3051	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Chirini	11B0000002244042904	BASSVERS0000002244042904
[encoded data, 127956 characters]	COURDEAU0000002215708602	3024	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Kawénilajoli	11B0000002244042906	BASSVERS0000002244042906
[encoded data, 137768 characters]	COURDEAU0000002215708632	3081	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Dagoni	11B0000002244042888	BASSVERS0000002244042888
[encoded data, 85524 characters]	COURDEAU0000002215708574	3094	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Salim Bé	11B0000002244042891	BASSVERS0000002244042891
[encoded data, 85076 characters]	COURDEAU0000002215708597	3093	11	\N	\N	\N	\N	\N	20.0	BDCarto	\N	\N	\N	\N	2021/12/09 15:56:16.470	2021/05/20 08:35:34.034	Mayotte	Mro wa Hajangoua	11B0000002244042892	BASSVERS0000002244042892
\.
END;
COMMIT;
