SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "troncon_de_voie_ferree" CASCADE;
BEGIN;
CREATE TABLE "troncon_de_voie_ferree"();
SELECT AddGeometryColumn('troncon_de_voie_ferree','geometrie',5490,'GEOMETRY',3);
CREATE INDEX "troncon_de_voie_ferree_geometrie_geom_idx" ON "troncon_de_voie_ferree" USING GIST ("geometrie");
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "cleabs" VARCHAR(24);
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "nature" VARCHAR;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "position_par_rapport_au_sol" VARCHAR;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "etat_de_l_objet" VARCHAR;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "date_creation" timestamp with time zone;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "date_modification" timestamp with time zone;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "date_d_apparition" date;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "date_de_confirmation" date;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "sources" VARCHAR(127);
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "identifiants_sources" VARCHAR(255);
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "precision_planimetrique" NUMERIC(5,1);
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "precision_altimetrique" NUMERIC(5,1);
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "electrifie" BOOLEAN;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "largeur" VARCHAR;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "nombre_de_voies" INTEGER;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "usage" VARCHAR;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "vitesse_maximale" INTEGER;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "liens_vers_voie_ferree_nommee" VARCHAR;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "cpx_toponyme" VARCHAR;
COMMIT;
SET standard_conforming_strings = OFF;
BEGIN;
COPY "troncon_de_voie_ferree" ("geometrie", "cleabs", "nature", "position_par_rapport_au_sol", "etat_de_l_objet", "date_creation", "date_modification", "date_d_apparition", "date_de_confirmation", "sources", "identifiants_sources", "precision_planimetrique", "precision_altimetrique", "electrifie", "largeur", "nombre_de_voies", "usage", "vitesse_maximale", "liens_vers_voie_ferree_nommee", "cpx_toponyme") FROM STDIN;
01020000A07215000002000000CDCCCCCC882724419A9999194CAF3B410000000000408FC09A999999C9272441CDCCCCCC37AF3B410000000000408FC0	TRONFERR0000001171499770	Voie ferrée principale	1	En service	2012/06/21 11:30:58.576	\N	\N	\N	\N		3.0	9999.0	0	Etroite	1	\N	\N	\N	\N
01020000A0721500001D000000CDCCCCCCAD172441CDCCCCCCBAB43B410000000000408FC09A999999961724419A9999199FB43B410000000000408FC033333333811724410000008085B43B410000000000408FC033333333721724410000000070B43B410000000000408FC06666666663172441000000805AB43B410000000000408FC09A9999995D172441CDCCCCCC45B43B410000000000408FC0CDCCCCCC5C172441666666E62FB43B410000000000408FC03333333369172441666666E61CB43B410000000000408FC09A9999998C172441CDCCCCCC00B43B410000000000408FC033333333BE17244100000080DEB33B410000000000408FC09A999999DB172441333333B3CDB33B410000000000408FC0CDCCCCCC0F18244100000000B2B33B410000000000408FC033333333A61824413333333381B33B410000000000408FC0333333336E192441666666E644B33B410000000000408FC066666666B31A24419A999999E0B23B410000000000408FC09A999999AA1B2441666666E692B23B410000000000408FC033333333B51C2441333333333FB23B410000000000408FC0CDCCCCCC011E24419A999999D5B13B410000000000408FC0333333334C1E2441CDCCCCCCC1B13B410000000000408FC0666666664F202441000000004DB13B410000000000408FC066666666D0212441CDCCCC4CF4B03B410000000000408FC000000000872224419A999919CDB03B410000000000408FC0CDCCCCCC67232441333333B395B03B410000000000408FC000000000F4232441666666666AB03B410000000000408FC09A999999A62424419A99991933B03B410000000000408FC0333333332D252441333333B307B03B410000000000408FC000000000BB262441000000808CAF3B416666666666661640CDCCCCCC5A272441000000805AAF3B410000000000408FC0CDCCCCCC882724419A9999194CAF3B410000000000408FC0	TRONFERR0000001171499771	Voie ferrée principale	0	En service	2012/06/21 11:30:58.576	2018/01/09 22:24:19.336	\N	\N	\N		3.0	9999.0	0	Etroite	1	\N	\N		\N
01020000A072150000090000009A999999C9272441CDCCCCCC37AF3B410000000000408FC000000000E6272441666666E62EAF3B419A9999999999154066666666652824419A99999906AF3B4133333333333317403333333383282441333333B3FBAE3B410000000000408FC09A999999CA28244100000000E1AE3B410000000000408FC09A999999752924419A99991992AE3B410000000000408FC033333333F82924419A99999956AE3B410000000000408FC066666666B82A24419A999919FFAD3B410000000000408FC033333333552B244166666666B9AD3B410000000000408FC0	TRONFERR0000002012538766	Voie ferrée principale	0	En service	2018/08/23 18:57:11.858	\N	\N	\N	\N		3.0	9999.0	0	Etroite	1	\N	\N		\N
01020000A0721500000400000033333333552B244166666666B9AD3B41CDCCCCCCCCCC204033333333822B24419A999999ABAD3B41CDCCCCCCCCCC204000000000A22B2441333333B39FAD3B41CDCCCCCCCCCC204033333333182C2441CDCCCCCC69AD3B416666666666662040	TRONFERR0000002012538767	Voie ferrée principale	0	En service	2018/08/23 18:57:11.858	2019/03/14 20:41:48.479	\N	2017/07/01	\N	\N	2.5	1.5	0	Etroite	1	Sans objet	\N	\N	\N
\.
END;
COMMIT;
