SET client_encoding = 'utf-8';
SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "toponymie_transport" CASCADE;
BEGIN;
CREATE TABLE "toponymie_transport"();
SELECT AddGeometryColumn('toponymie_transport','geometrie',4471,'GEOMETRY',2);
CREATE INDEX "toponymie_transport_geometrie_geom_idx" ON "toponymie_transport" USING GIST ("geometrie");
ALTER TABLE "toponymie_transport" ADD COLUMN "cleabs_de_l_objet" VARCHAR(24);
ALTER TABLE "toponymie_transport" ADD COLUMN "classe_de_l_objet" VARCHAR;
ALTER TABLE "toponymie_transport" ADD COLUMN "nature_de_l_objet" VARCHAR;
ALTER TABLE "toponymie_transport" ADD COLUMN "graphie_du_toponyme" VARCHAR;
ALTER TABLE "toponymie_transport" ADD COLUMN "source_du_toponyme" VARCHAR;
ALTER TABLE "toponymie_transport" ADD COLUMN "statut_du_toponyme" VARCHAR;
ALTER TABLE "toponymie_transport" ADD COLUMN "date_du_toponyme" date;
ALTER TABLE "toponymie_transport" ADD COLUMN "langue_du_toponyme" VARCHAR;
COMMIT;
SET standard_conforming_strings = OFF;
BEGIN;
COPY "toponymie_transport" ("geometrie", "cleabs_de_l_objet", "classe_de_l_objet", "nature_de_l_objet", "graphie_du_toponyme", "source_du_toponyme", "statut_du_toponyme", "date_du_toponyme", "langue_du_toponyme") FROM STDIN;
010100002077110000000000008A0820419A99991901616041	EQ_RESEA0000001600339214	Equipement de transport	Port	port de plaisance de mamoudzou	Internet	Collecté	1900/01/01	\N
01010000207711000066666666BE002041666666F62F616041	EQ_RESEA0000002203347712	Equipement de transport	Carrefour	rond point el farouk	CDT	Collecté	2019/07/04	\N
010100002077110000CDCCCCCCC62F20419A9999194D606041	EQ_RESEA0000002203732261	Equipement de transport	Carrefour	rond-point des amoureux	Mairie	Collecté	2019/08/01	\N
010100002077110000CDCCCCCCC2841F419A999999B0586041	EQ_RESEA0000002203436166	Equipement de transport	Carrefour	carrefour madame aziz	EPCI	Collecté	2019/07/16	\N
01010000207711000066666666469B1F419A9999C912646041	EQ_RESEA0000001600044073	Equipement de transport	Port	port de longoni	Terrain	Validé	2005/08/05	\N
01010000207711000033333333B3941F416666661678586041	EQ_RESEA0000002203436164	Equipement de transport	Carrefour	carrefour nyambani	EPCI	Collecté	2019/07/16	\N
010100002077110000333333338B252041CDCCCC1C6D606041	EQ_RESEA0000001600001432	Equipement de transport	Carrefour	rond-point du four à chaux	IGN	Validé	2003/09/15	\N
01010000207711000066666666CF0120419A9999D9A8606041	EQ_RESEA0000001600001436	Equipement de transport	Carrefour	carrefour du baobab	IGN	Validé	2003/09/15	\N
010100002077110000333333337A0320419A9999A9AE606041	EQ_RESEA0000001600312065	Equipement de transport	Carrefour	rond-point du manguier	SGA	Collecté	1900/01/01	\N
010100002077110000333333337A0320419A9999A9AE606041	EQ_RESEA0000001600312065	Equipement de transport	Carrefour	rpt du manguier	Cadastre	Collecté	1900/01/01	\N
0101000020771100009A9999990F1A204133333343D0606041	EQ_RESEA0000001600341308	Equipement de transport	Gare maritime	gare maritime internationale de mayotte	Terrain	Collecté	1900/01/01	\N
0101000020771100000000000062341F41666666D6F9656041	EQ_RESEA0000001600001431	Equipement de transport	Carrefour	carrefour de handréma	IGN	Validé	2003/09/12	\N
010100002077110000666666668C551F4166666666E4636041	EQ_RESEA0000001600001437	Equipement de transport	Carrefour	carrefour de dzoumonyé	IGN	Validé	2003/09/12	\N
0101000020771100009A999999EB351F41000000B007596041	EQ_RESEA0000001600342733	Equipement de transport	Carrefour	carrefour de mzouazia	SGA	Collecté	1900/01/01	\N
0101000020771100003333333301B11F419A999999E65D6041	EQ_RESEA0000001600001438	Equipement de transport	Carrefour	carrefour de tsararano	IGN	Validé	2003/09/16	\N
01010000207711000066666666A8361F4100000040C7616041	EQ_RESEA0000001600001439	Equipement de transport	Carrefour	carrefour de soulou	IGN	Validé	2003/09/15	\N
010100002077110000666666666C521F41333333D3B05D6041	EQ_RESEA0000001600001440	Equipement de transport	Carrefour	carrefour de chiconi	IGN	Validé	2003/09/15	\N
010100002077110000019E3E259E1D204100000000D5606041	EQ_RESEA0000002275316441	Equipement de transport	Port	port de dzaoudzi	IGN	Collecté	2021/12/03	\N
010100002077110000407A4F4EC33120413333331B675F6041	AERODROM0000001600001434	Aérodrome	Aérodrome	aéroport de dzaoudzi-pamandzi	IGN	Validé	2003/09/15	\N
010100002077110000CDCCCCCC8C072041000000A00C616041	ROUTNOMM0000002150482502	Route	Bac	mamoudzou : dzaoudzi (barge)	IGN	Collecté	2020/03/02	\N
010100002077110000666666666A082041CDCCCC3C2A616041	ROUTNOMM0000002150482500	Route	Bac	mamoudzou : dzaoudzi (amphidrome)	IGN	Collecté	2020/03/02	\N
01010000207711000000000000742D20419A9999C9D7606041	ROUTNOMM0000001600117924	Route	Route nommée	route des badamiers	IGN	Validé	2003/09/15	\N
01010000207711000000000000BE31204100000030CC606041	ROUTNOMM0000001600117923	Route	Route nommée	route de moya	IGN	Validé	2003/09/15	\N
\.
END;
COMMIT;
