SET NAMES 'UTF8';
--
--
start transaction;
-- "Plus petite subdivision du territoire, administrée par un maire, des ad:joints etun conseil municipal.":
--
create table COMMUNE (gid SERIAL not null, ID varchar(24) not null, PREC_PLANI decimal(6,1) not null, NOM varchar(45) default 'NR', CODE_INSEE varchar(5) default 'NR', STATUT varchar(22) default 'NR', ARRONDISST varchar(45) default 'NR', DEPART varchar(30) default 'NR', REGION varchar(35) default 'NR', POPUL integer default '0', constraint COMMUNE_pkey primary key (gid));
select AddGeometryColumn('','commune','the_geom','2972','MULTIPOLYGON',2);
create index COMMUNE_geoidx on COMMUNE using gist (the_geom);
--
commit;
--
-- COMMUNE
start transaction;
copy COMMUNE (gid, ID , PREC_PLANI , NOM , CODE_INSEE , STATUT , ARRONDISST , DEPART , REGION , POPUL , the_geom) from STDIN ;
23	SURFCOMM0000001369988716	  30.0	Cayenne	97302	Préfecture de région	CAYENNE	GUYANE	GUYANE	57614	[encoded data, 134502 characters]
24	SURFCOMM0000001369988712	  30.0	Saint-Laurent-du-Maroni	97311	Sous-préfecture	SAINT-LAURENT-DU-MARONI	GUYANE	GUYANE	43600	[encoded data, 302740 characters]
25	SURFCOMM0000001369988714	  30.0	Montsinéry-Tonnegrande	97313	Commune simple	CAYENNE	GUYANE	GUYANE	2473	[encoded data, 94516 characters]
26	SURFCOMM0000001369988725	  30.0	Sinnamary	97312	Commune simple	CAYENNE	GUYANE	GUYANE	2957	[encoded data, 269256 characters]
27	SURFCOMM0000001369988704	  30.0	Camopi	97356	Commune simple	CAYENNE	GUYANE	GUYANE	1769	[encoded data, 186548 characters]
28	SURFCOMM0000001369988722	  30.0	Awala-Yalimapo	97361	Commune simple	SAINT-LAURENT-DU-MARONI	GUYANE	GUYANE	1379	[encoded data, 51592 characters]
29	SURFCOMM0000001369988721	  30.0	Iracoubo	97303	Commune simple	CAYENNE	GUYANE	GUYANE	1878	[encoded data, 244436 characters]
30	SURFCOMM0000001369988720	  30.0	Mana	97306	Commune simple	SAINT-LAURENT-DU-MARONI	GUYANE	GUYANE	10241	[encoded data, 468526 characters]
31	SURFCOMM0000001369988709	  30.0	Apatou	97360	Commune simple	SAINT-LAURENT-DU-MARONI	GUYANE	GUYANE	8431	[encoded data, 170932 characters]
32	SURFCOMM0000001371230812	  30.0	Régina	97301	Commune simple	CAYENNE	GUYANE	GUYANE	946	[encoded data, 281852 characters]
33	SURFCOMM0000001369988715	  30.0	Remire-Montjoly	97309	Commune simple	CAYENNE	GUYANE	GUYANE	23976	[encoded data, 77396 characters]
34	SURFCOMM0000001369988713	  30.0	Matoury	97307	Commune simple	CAYENNE	GUYANE	GUYANE	32427	[encoded data, 41044 characters]
35	SURFCOMM0000001369988723	  30.0	Kourou	97304	Commune simple	CAYENNE	GUYANE	GUYANE	26221	[encoded data, 172558 characters]
36	SURFCOMM0000001369988706	  30.0	Saül	97352	Commune simple	SAINT-LAURENT-DU-MARONI	GUYANE	GUYANE	150	[encoded data, 141012 characters]
37	SURFCOMM0000001369988717	  30.0	Roura	97310	Commune simple	CAYENNE	GUYANE	GUYANE	3713	[encoded data, 164628 characters]
38	SURFCOMM0000001369988708	  30.0	Saint-Georges	97308	Commune simple	CAYENNE	GUYANE	GUYANE	4020	[encoded data, 105332 characters]
39	SURFCOMM0000001369988705	  30.0	Maripasoula	97353	Commune simple	SAINT-LAURENT-DU-MARONI	GUYANE	GUYANE	11856	[encoded data, 346836 characters]
40	SURFCOMM0000001369988710	  30.0	Grand-Santi	97357	Commune simple	SAINT-LAURENT-DU-MARONI	GUYANE	GUYANE	6969	[encoded data, 166388 characters]
41	SURFCOMM0000001369988718	  30.0	Saint-Élie	97358	Commune simple	CAYENNE	GUYANE	GUYANE	95	[encoded data, 144020 characters]
42	SURFCOMM0000001369988719	  30.0	Ouanary	97314	Commune simple	CAYENNE	GUYANE	GUYANE	165	[encoded data, 115284 characters]
43	SURFCOMM0000001369988711	  30.0	Papaichton	97362	Commune simple	SAINT-LAURENT-DU-MARONI	GUYANE	GUYANE	7266	[encoded data, 134036 characters]
44	SURFCOMM0000001369988724	  30.0	Macouria	97305	Commune simple	CAYENNE	GUYANE	GUYANE	11719	[encoded data, 106926 characters]
\.
commit;
--
