SET client_encoding = 'utf-8';
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,'MULTIPOLYGON',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 CONSTRAINT "piste_d_aerodrome_cleabs_pkey" PRIMARY KEY ("cleabs");
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;
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "identifiants_sources" VARCHAR;
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "methode_d_acquisition_planimetrique" VARCHAR;
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "precision_planimetrique" NUMERIC(5,1);
ALTER TABLE "piste_d_aerodrome" ADD COLUMN "methode_d_acquisition_altimetrique" VARCHAR;
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", "methode_d_acquisition_planimetrique", "precision_planimetrique", "methode_d_acquisition_altimetrique", "precision_altimetrique") FROM STDIN;
[encoded data, 8500 characters]	PISTAERO0000001600043723	Piste en dur	\N	En service	2007/10/25 14:46:09.337	2022/05/16 12:49:33.800	\N	2008/07/01	\N	\N	Photogrammétrie	2.5	Photogrammétrie	1.5
\.
END;
COMMIT;
