SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "piste_d_aerodrome" CASCADE;
BEGIN;
CREATE TABLE "piste_d_aerodrome"();
SELECT AddGeometryColumn('piste_d_aerodrome','geometrie',4471,'GEOMETRY',3);
CREATE INDEX "piste_d_aerodrome_geometrie_geom_idx" ON "piste_d_aerodrome" USING GIST ("geometrie");
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "cleabs" VARCHAR(24);
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "nature" VARCHAR;
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "fonction" VARCHAR;
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "etat_de_l_objet" VARCHAR;
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "date_creation" timestamp with time zone;
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "date_modification" timestamp with time zone;
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "date_d_apparition" date;
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "date_de_confirmation" date;
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "sources" VARCHAR(127);
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "identifiants_sources" VARCHAR(255);
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "precision_planimetrique" NUMERIC(5,1);
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "precision_altimetrique" NUMERIC(5,1);
COMMIT;
SET standard_conforming_strings = OFF;
BEGIN;
COPY "piste_d_aerodrome" ("geometrie", "cleabs", "nature", "fonction", "etat_de_l_objet", "date_creation", "date_modification", "date_d_apparition", "date_de_confirmation", "sources", "identifiants_sources", "precision_planimetrique", "precision_altimetrique") FROM STDIN;
01060000A0771100000100000001030000800100000012000000CDCCCCCC78901F419A999959BB5660410000000000408FC09A999999B58F1F41666666E6B95660410000000000408FC09A999999B18F1F4100000050B15660416666666666662B4033333333F78F1F419A9999A9B25660416666666666662B409A99999921901F4133333353B05660416666666666662B40000000003A901F41CDCCCCACB05660410000000000408FC06666666658901F4166666666AE5660410000000000001840CDCCCCCC6A901F41CDCCCC0CAD5660410000000000408FC066666666BC901F41CDCCCC7CAD5660410000000000408FC0666666669A911F4133333383A05660413333333333331540000000002C921F41000000309856604133333333333313409A999999F5921F41666666168D5660410000000000408FC0CDCCCCCC62931F41CDCCCC0C8F5660410000000000408FC06666666626931F41CDCCCCBC915660410000000000408FC03333333305931F419A9999099756604133333333333313409A999999E5911F41333333F3A6566041CDCCCCCCCCCC1640000000004C911F419A9999E9AE5660413333333333331540CDCCCCCC78901F419A999959BB5660410000000000408FC0	PISTAERO0000001600110630	Piste en herbe	\N	En service	2010/06/10 10:46:08.044	\N	\N	\N	\N		3.0	9999.0
[encoded data, 9124 characters]	PISTAERO0000001600043723	Piste en dur	\N	En service	2007/10/25 14:46:09.337	2017/07/31 16:20:26.864	\N	2008/07/01	\N		2.5	1.5
\.
END;
COMMIT;
