SET client_encoding = 'utf-8';
SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "epci" CASCADE;
BEGIN;
CREATE TABLE "epci"();
SELECT AddGeometryColumn('epci','geometrie',5490,'MULTIPOLYGON',2);
CREATE INDEX "epci_geometrie_geom_idx" ON "epci" USING GIST ("geometrie");
ALTER TABLE "epci" ADD COLUMN "cleabs" VARCHAR(24);
ALTER TABLE "epci" ADD CONSTRAINT "epci_cleabs_pkey" PRIMARY KEY ("cleabs");
ALTER TABLE "epci" ADD COLUMN "code_siren" VARCHAR(9);
ALTER TABLE "epci" ADD COLUMN "nature" VARCHAR;
ALTER TABLE "epci" ADD COLUMN "nom_officiel" VARCHAR;
ALTER TABLE "epci" ADD COLUMN "date_creation" timestamp with time zone;
ALTER TABLE "epci" ADD COLUMN "date_modification" timestamp with time zone;
ALTER TABLE "epci" ADD COLUMN "date_d_apparition" date;
ALTER TABLE "epci" ADD COLUMN "date_de_confirmation" date;
ALTER TABLE "epci" ADD COLUMN "liens_vers_autorite_administrative" VARCHAR;
COMMIT;
SET standard_conforming_strings = OFF;
BEGIN;
COPY "epci" ("geometrie", "cleabs", "code_siren", "nature", "nom_officiel", "date_creation", "date_modification", "date_d_apparition", "date_de_confirmation", "liens_vers_autorite_administrative") FROM STDIN;
[encoded data, 531552 characters]	EPCI____0000002150235977	200018653	Communauté d'agglomération	CA Cap Excellence	2018/11/24 00:00:00	2024/03/15 23:34:12.164	\N	\N	SURFACTI0000001171936265
[encoded data, 677220 characters]	EPCI____0000002150237200	249710070	Communauté d'agglomération	CA Grand Sud Caraïbe	2018/11/24 00:00:00	2024/03/15 23:34:12.164	\N	\N	SURFACTI0000001171439988
[encoded data, 819740 characters]	EPCI____0000002150236151	200041507	Communauté d'agglomération	CA La Riviera du Levant	2018/11/24 00:00:00	2024/03/15 23:34:12.164	\N	\N	SURFACTI0000002007748818
[encoded data, 644456 characters]	EPCI____0000002150237199	249710062	Communauté d'agglomération	CA du Nord Basse-Terre	2018/11/24 00:00:00	2024/02/12 18:17:52.079	\N	\N	SURFACTI0000001171996350
[encoded data, 316820 characters]	EPCI____0000002150237198	249710047	Communauté de communes	CC de Marie-Galante	2018/11/24 00:00:00	2024/02/09 11:33:33.618	\N	\N	SURFACTI0000001171495308
[encoded data, 661276 characters]	EPCI____0000002150236214	200044691	Communauté d'agglomération	CA du Nord Grande Terre	2018/11/24 00:00:00	2024/02/09 11:33:33.618	\N	\N	SURFACTI0000001171494182
\.
END;
COMMIT;
