SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "parc_ou_reserve" CASCADE;
BEGIN;
CREATE TABLE "parc_ou_reserve"();
SELECT AddGeometryColumn('parc_ou_reserve','geometrie',5490,'GEOMETRY',2);
CREATE INDEX "parc_ou_reserve_geometrie_geom_idx" ON "parc_ou_reserve" USING GIST ("geometrie");
ALTER TABLE "parc_ou_reserve" ADD COLUMN "cleabs" VARCHAR(24);
ALTER TABLE "parc_ou_reserve" ADD COLUMN "nature" VARCHAR;
ALTER TABLE "parc_ou_reserve" ADD COLUMN "nature_detaillee" VARCHAR;
ALTER TABLE "parc_ou_reserve" ADD COLUMN "toponyme" VARCHAR;
ALTER TABLE "parc_ou_reserve" ADD COLUMN "statut_du_toponyme" VARCHAR;
ALTER TABLE "parc_ou_reserve" ADD COLUMN "fictif" BOOLEAN;
ALTER TABLE "parc_ou_reserve" ADD COLUMN "etat_de_l_objet" VARCHAR;
ALTER TABLE "parc_ou_reserve" ADD COLUMN "date_creation" timestamp with time zone;
ALTER TABLE "parc_ou_reserve" ADD COLUMN "date_modification" timestamp with time zone;
ALTER TABLE "parc_ou_reserve" ADD COLUMN "date_d_apparition" date;
ALTER TABLE "parc_ou_reserve" ADD COLUMN "date_de_confirmation" date;
ALTER TABLE "parc_ou_reserve" ADD COLUMN "sources" VARCHAR(127);
ALTER TABLE "parc_ou_reserve" ADD COLUMN "identifiants_sources" VARCHAR(254);
ALTER TABLE "parc_ou_reserve" ADD COLUMN "precision_planimetrique" NUMERIC(5,1);
COMMIT;
SET standard_conforming_strings = OFF;
BEGIN;
COPY "parc_ou_reserve" ("geometrie", "cleabs", "nature", "nature_detaillee", "toponyme", "statut_du_toponyme", "fictif", "etat_de_l_objet", "date_creation", "date_modification", "date_d_apparition", "date_de_confirmation", "sources", "identifiants_sources", "precision_planimetrique") FROM STDIN;
[encoded data, 303280 characters]	SURFPARC0000002000058157	Parc national	\N	Parc National de la Guadeloupe (Cœur Marin)	Validé	0	En service	2016/09/21 15:09:36.174	2018/06/15 10:43:07.189	\N	\N	\N		2.5
[encoded data, 470398 characters]	SURFPARC0000001169868071	Parc national	\N	Parc National de la Guadeloupe (Cœur Terrestre)	Validé	0	En service	2008/01/11 05:44:42.776	2018/06/15 10:43:07.189	\N	\N	\N		20.0
[encoded data, 1074378 characters]	SURFPARC0000001171236644	Zone périphérique	\N	Aire d'Adhésion du Parc National de la Guadeloupe	Validé	0	En service	2011/12/16 07:20:51.840	2019/12/12 14:46:19.047	\N	\N	\N	\N	3.0
01060000207215000001000000010300000001000000070000000000000007522541333333B36D4D3B4100000000095A2541CDCCCCCC74443B41CDCCCCCC6D6F25419A999999F6473B4100000000897A254133333333E24F3B41CDCCCCCC4E792541CDCCCCCC02533B41666666665463254133333333E24F3B410000000007522541333333B36D4D3B41	SURFPARC0000001171497504	Réserve naturelle	Réserve naturelle nationale	Réserve Naturelle des Îles de la Petite Terre	Validé	0	En service	2012/06/04 17:10:26.286	2019/01/25 12:07:57.059	\N	\N	MNHN/RNF	MNHN:FR3600142/RNF:RNN142	2.5
\.
END;
COMMIT;
