SET client_encoding = 'utf-8';
SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "commune" CASCADE;
BEGIN;
CREATE TABLE "commune"();
SELECT AddGeometryColumn('commune','geometrie',2972,'GEOMETRY',2);
CREATE INDEX "commune_geometrie_geom_idx" ON "commune" USING GIST ("geometrie");
ALTER TABLE "commune" ADD COLUMN "cleabs" VARCHAR(24);
ALTER TABLE "commune" ADD COLUMN "code_insee" VARCHAR(5);
ALTER TABLE "commune" ADD COLUMN "code_insee_de_l_arrondissement" VARCHAR(5);
ALTER TABLE "commune" ADD COLUMN "code_insee_de_la_collectivite_terr" VARCHAR(5);
ALTER TABLE "commune" ADD COLUMN "code_insee_du_departement" VARCHAR(5);
ALTER TABLE "commune" ADD COLUMN "code_insee_de_la_region" VARCHAR(5);
ALTER TABLE "commune" ADD COLUMN "population" INTEGER;
ALTER TABLE "commune" ADD COLUMN "surface_en_ha" INTEGER;
ALTER TABLE "commune" ADD COLUMN "code_postal" VARCHAR(5);
ALTER TABLE "commune" ADD COLUMN "nom_officiel" VARCHAR;
ALTER TABLE "commune" ADD COLUMN "chef_lieu_d_arrondissement" BOOLEAN;
ALTER TABLE "commune" ADD COLUMN "chef_lieu_de_collectivite_terr" BOOLEAN;
ALTER TABLE "commune" ADD COLUMN "chef_lieu_de_departement" BOOLEAN;
ALTER TABLE "commune" ADD COLUMN "chef_lieu_de_region" BOOLEAN;
ALTER TABLE "commune" ADD COLUMN "capitale_d_etat" BOOLEAN;
ALTER TABLE "commune" ADD COLUMN "date_du_recensement" date;
ALTER TABLE "commune" ADD COLUMN "organisme_recenseur" VARCHAR(16);
ALTER TABLE "commune" ADD COLUMN "lien_vers_chef_lieu" VARCHAR(24);
ALTER TABLE "commune" ADD COLUMN "code_siren" VARCHAR(9);
COMMIT;
SET standard_conforming_strings = OFF;
BEGIN;
COPY "commune" ("geometrie", "cleabs", "code_insee", "code_insee_de_l_arrondissement", "code_insee_de_la_collectivite_terr", "code_insee_du_departement", "code_insee_de_la_region", "population", "surface_en_ha", "code_postal", "nom_officiel", "chef_lieu_d_arrondissement", "chef_lieu_de_collectivite_terr", "chef_lieu_de_departement", "chef_lieu_de_region", "capitale_d_etat", "date_du_recensement", "organisme_recenseur", "lien_vers_chef_lieu", "code_siren") FROM STDIN;
[encoded data, 48276 characters]	COMMUNE_0000001369858496	97313	1	973R	973	03	2957	60000	97356	Montsinéry-Tonnegrande	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369914155	219733136
[encoded data, 119164 characters]	COMMUNE_0000001369858499	97312	1	973R	973	03	2875	134000	97315	Sinnamary	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369913901	219733128
[encoded data, 103668 characters]	COMMUNE_0000001369858493	97358	1	973R	973	03	247	568000	97312	Saint-Élie	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369914167	219733581
[encoded data, 13844 characters]	COMMUNE_0000001369858494	97307	1	973R	973	03	33458	13719	97351	Matoury	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369914119	219733078
[encoded data, 32558 characters]	COMMUNE_0000001369858495	97305	1	973R	973	03	16219	37750	97355	Macouria	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369913939	219733052
[encoded data, 33730 characters]	COMMUNE_0000001369858500	97302	1	973R	973	03	65493	2360	97300	Cayenne	1	1	1	1	0	2018/01/01	INSEE	PAIHABIT0000001369914120	219733029
[encoded data, 15220 characters]	COMMUNE_0000001369858497	97309	1	973R	973	03	26358	4611	97354	Remire-Montjoly	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369988753	219733094
[encoded data, 110132 characters]	COMMUNE_0000001369858512	97356	1	973R	973	03	1864	1003000	97330	Camopi	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369914457	219733565
[encoded data, 10638 characters]	COMMUNE_0000001369858505	97361	2	973R	973	03	1449	18740	97319	Awala-Yalimapo	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369913826	219733615
[encoded data, 104948 characters]	COMMUNE_0000001369858509	97360	2	973R	973	03	9482	202000	97317	Apatou	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369988726	219733607
[encoded data, 215636 characters]	COMMUNE_0000001369858514	97353	2	973R	973	03	11842	1836000	97370	Maripasoula	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369914427	219733532
[encoded data, 103604 characters]	COMMUNE_0000001369858507	97357	2	973R	973	03	8779	211200	97340	Grand-Santi	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369914357	219733573
[encoded data, 154902 characters]	COMMUNE_0000001369858513	97301	1	973R	973	03	854	1213000	97390	Régina	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369914246	219733011
[encoded data, 92308 characters]	COMMUNE_0000001369858515	97352	2	973R	973	03	152	447500	97314	Saül	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369914386	219733524
[encoded data, 99124 characters]	COMMUNE_0000001369858506	97303	1	973R	973	03	1748	276200	97350	Iracoubo	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369913833	219733037
[encoded data, 181300 characters]	COMMUNE_0000001369858503	97311	2	973R	973	03	47621	483000	97320	Saint-Laurent-du-Maroni	1	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369913892	219733110
[encoded data, 112948 characters]	COMMUNE_0000001369858498	97310	1	973R	973	03	3458	390250	97311	Roura	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369914207	219733102
[encoded data, 231182 characters]	COMMUNE_0000001369858504	97306	2	973R	973	03	11675	633260	97360	Mana	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369913859	219733060
[encoded data, 70196 characters]	COMMUNE_0000001369858490	97314	1	973R	973	03	242	108000	97380	Ouanary	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369988727	219733144
[encoded data, 63700 characters]	COMMUNE_0000001369858510	97308	1	973R	973	03	4245	232000	97313	Saint-Georges	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369914361	219733086
[encoded data, 85492 characters]	COMMUNE_0000001369858502	97362	2	973R	973	03	5757	262800	97316	Papaichton	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369914426	219733623
[encoded data, 91860 characters]	COMMUNE_0000001369858501	97304	1	973R	973	03	24903	216000	97310	Kourou	0	0	0	0	0	2018/01/01	INSEE	PAIHABIT0000001369913960	219733045
\.
END;
COMMIT;
