SET client_encoding = 'utf-8';
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',2972,'LINESTRING',2);
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 CONSTRAINT "troncon_de_voie_ferree_cleabs_pkey" PRIMARY KEY ("cleabs");
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "etat_de_l_objet" VARCHAR;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "nature" VARCHAR;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "electrifie" BOOLEAN;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "nombre_de_voies" INTEGER;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "largeur" VARCHAR;
ALTER TABLE "troncon_de_voie_ferree" ADD COLUMN "position_par_rapport_au_sol" VARCHAR;
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", "etat_de_l_objet", "nature", "electrifie", "nombre_de_voies", "largeur", "position_par_rapport_au_sol", "liens_vers_voie_ferree_nommee", "cpx_toponyme") FROM STDIN;
01020000209C0B000003000000CDCCCCCC3243144166666666CD4820419A99999963411441666666668B49204100000000C2401441000000007F492041	TRONFERR0000002000665446	Non exploité	Sans objet	0	1	Etroite	0		\N
01020000209C0B00000E00000066666666F2811841CDCCCCCCA6A91941333333334D8218416666666634AB19410000000074831841CDCCCCCC9EAC1941000000002C8518416666666640AE194100000000D0881841666666664EB1194100000000268C1841CDCCCCCC6EB31941000000003A8E18419A99999983B4194166666666BE8E184100000000ACB4194166666666768F1841CDCCCCCC72B4194166666666F29118410000000044B3194166666666AA93184100000000D4B21941333333339394184166666666CEB2194133333333A7961841CDCCCCCC32B3194100000000FE9718419A9999993FB31941	TRONFERR0000002000727354	Non exploité	Sans objet	0	1	Etroite	0		\N
\.
END;
COMMIT;
