SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "plan_d_eau" CASCADE;
BEGIN;
CREATE TABLE "plan_d_eau"();
SELECT AddGeometryColumn('plan_d_eau','geometrie',5490,'GEOMETRY',2);
CREATE INDEX "plan_d_eau_geometrie_geom_idx" ON "plan_d_eau" USING GIST ("geometrie");
ALTER TABLE "plan_d_eau" ADD COLUMN "cleabs" VARCHAR(24);
ALTER TABLE "plan_d_eau" ADD COLUMN "code_hydrographique" VARCHAR(19);
ALTER TABLE "plan_d_eau" ADD COLUMN "nature" VARCHAR;
ALTER TABLE "plan_d_eau" ADD COLUMN "toponyme" VARCHAR;
ALTER TABLE "plan_d_eau" ADD COLUMN "statut_du_toponyme" VARCHAR;
ALTER TABLE "plan_d_eau" ADD COLUMN "importance" VARCHAR;
ALTER TABLE "plan_d_eau" ADD COLUMN "date_creation" timestamp with time zone;
ALTER TABLE "plan_d_eau" ADD COLUMN "date_modification" timestamp with time zone;
ALTER TABLE "plan_d_eau" ADD COLUMN "date_d_apparition" date;
ALTER TABLE "plan_d_eau" ADD COLUMN "date_de_confirmation" date;
ALTER TABLE "plan_d_eau" ADD COLUMN "sources" VARCHAR(127);
ALTER TABLE "plan_d_eau" ADD COLUMN "identifiants_sources" VARCHAR(255);
ALTER TABLE "plan_d_eau" ADD COLUMN "statut" VARCHAR;
ALTER TABLE "plan_d_eau" ADD COLUMN "influence_de_la_maree" BOOLEAN;
ALTER TABLE "plan_d_eau" ADD COLUMN "caractere_permanent" BOOLEAN;
ALTER TABLE "plan_d_eau" ADD COLUMN "altitude_moyenne" NUMERIC(7,2);
ALTER TABLE "plan_d_eau" ADD COLUMN "referentiel_de_l_altitude_moyenne" VARCHAR(30);
ALTER TABLE "plan_d_eau" ADD COLUMN "mode_d_obtention_de_l_altitude_moy" VARCHAR;
ALTER TABLE "plan_d_eau" ADD COLUMN "precision_de_l_altitude_moyenne" VARCHAR;
ALTER TABLE "plan_d_eau" ADD COLUMN "hauteur_d_eau_maximale" NUMERIC(7,1);
ALTER TABLE "plan_d_eau" ADD COLUMN "mode_d_obtention_de_la_hauteur" VARCHAR;
ALTER TABLE "plan_d_eau" ADD COLUMN "commentaire_sur_l_objet_hydro" VARCHAR(70);
COMMIT;
SET standard_conforming_strings = OFF;
BEGIN;
COPY "plan_d_eau" ("geometrie", "cleabs", "code_hydrographique", "nature", "toponyme", "statut_du_toponyme", "importance", "date_creation", "date_modification", "date_d_apparition", "date_de_confirmation", "sources", "identifiants_sources", "statut", "influence_de_la_maree", "caractere_permanent", "altitude_moyenne", "referentiel_de_l_altitude_moyenne", "mode_d_obtention_de_l_altitude_moy", "precision_de_l_altitude_moyenne", "hauteur_d_eau_maximale", "mode_d_obtention_de_la_hauteur", "commentaire_sur_l_objet_hydro") FROM STDIN;
010600002072150000010000000103000000010000000D000000333333339CA425419A999999D7733841666666669CA4254133333333D27338419A9999999CA42541666666E6CC73384133333333A3A4254100000000CA73384100000000ABA42541CDCCCCCCC77338419A999999BCA42541CDCCCCCCC9733841CDCCCCCCC5A42541666666E6CA73384100000000CBA4254100000000CE7338419A999999CBA4254100000080D273384166666666C9A4254100000080D67338419A999999C5A42541666666E6D873384100000000BCA4254166666666DB733841333333339CA425419A999999D7733841	PLANDEAU0000001269986068	08P0000001269986068	Lac	Mare Ferrant	Validé	5	2008/04/09 10:59:20.841	2018/06/15 10:54:04.158	\N	\N	\N	\N	Validé	\N	1	\N	\N	\N	\N	\N	\N	\N
[encoded data, 11924 characters]	PLANDEAU0000001269986108	08P0000001269986108	Lac	Étang des Salines	Validé	4	2008/04/09 10:59:20.841	2018/06/15 10:54:04.158	\N	\N	\N	\N	Validé	\N	1	\N	\N	\N	\N	\N	\N	\N
\.
END;
COMMIT;
