SET client_encoding = 'utf-8';
SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "aerodrome" CASCADE;
BEGIN;
CREATE TABLE "aerodrome"();
SELECT AddGeometryColumn('aerodrome','geometrie',5490,'MULTIPOLYGON',2);
CREATE INDEX "aerodrome_geometrie_geom_idx" ON "aerodrome" USING GIST ("geometrie");
ALTER TABLE "aerodrome" ADD COLUMN "cleabs" VARCHAR(24);
ALTER TABLE "aerodrome" ADD CONSTRAINT "aerodrome_cleabs_pkey" PRIMARY KEY ("cleabs");
ALTER TABLE "aerodrome" ADD COLUMN "categorie" VARCHAR;
ALTER TABLE "aerodrome" ADD COLUMN "nature" VARCHAR;
ALTER TABLE "aerodrome" ADD COLUMN "usage" VARCHAR;
ALTER TABLE "aerodrome" ADD COLUMN "toponyme" VARCHAR;
ALTER TABLE "aerodrome" ADD COLUMN "statut_du_toponyme" VARCHAR;
ALTER TABLE "aerodrome" ADD COLUMN "fictif" BOOLEAN;
ALTER TABLE "aerodrome" ADD COLUMN "etat_de_l_objet" VARCHAR;
ALTER TABLE "aerodrome" ADD COLUMN "date_creation" timestamp with time zone;
ALTER TABLE "aerodrome" ADD COLUMN "date_modification" timestamp with time zone;
ALTER TABLE "aerodrome" ADD COLUMN "date_d_apparition" date;
ALTER TABLE "aerodrome" ADD COLUMN "date_de_confirmation" date;
ALTER TABLE "aerodrome" ADD COLUMN "sources" VARCHAR;
ALTER TABLE "aerodrome" ADD COLUMN "identifiants_sources" VARCHAR;
ALTER TABLE "aerodrome" ADD COLUMN "methode_d_acquisition_planimetrique" VARCHAR;
ALTER TABLE "aerodrome" ADD COLUMN "precision_planimetrique" NUMERIC(5,1);
ALTER TABLE "aerodrome" ADD COLUMN "altitude" NUMERIC(7,2);
ALTER TABLE "aerodrome" ADD COLUMN "code_icao" VARCHAR(4);
ALTER TABLE "aerodrome" ADD COLUMN "code_iata" VARCHAR(3);
COMMIT;
SET standard_conforming_strings = OFF;
BEGIN;
COPY "aerodrome" ("geometrie", "cleabs", "categorie", "nature", "usage", "toponyme", "statut_du_toponyme", "fictif", "etat_de_l_objet", "date_creation", "date_modification", "date_d_apparition", "date_de_confirmation", "sources", "identifiants_sources", "methode_d_acquisition_planimetrique", "precision_planimetrique", "altitude", "code_icao", "code_iata") FROM STDIN;
01060000207215000001000000010300000001000000050000000000000075B52541333333339AB238410000000075B525413333333395B23841000000006BB525413333333395B23841000000006BB52541333333339AB238410000000075B52541333333339AB23841	AERODROM0000001271126832	Autre	Héliport	Civil	Héliport	Collecté	1	En service	2013/04/22 21:17:23.503	2023/03/28 16:14:55.575	\N	2023/03/02	SIA 2023	SIA:30067	Calculé	20.0	\N	\N	\N
[encoded data, 10580 characters]	AERODROM0000001269986170	Internationale	Aérodrome	Civil	Aéroport de Martinique-Aimé Césaire	Validé	0	En service	2008/04/09 10:59:20.841	2023/11/03 16:01:23.109	1950/01/01	2023/03/02	SIA 2023	OACI:TFFF	BDTopo	2.5	4.90	TFFF	FDF
\.
END;
COMMIT;
