SET client_encoding = 'utf-8';
SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "poste_de_transformation" CASCADE;
BEGIN;
CREATE TABLE "poste_de_transformation"();
SELECT AddGeometryColumn('poste_de_transformation','geometrie',4471,'GEOMETRY',3);
CREATE INDEX "poste_de_transformation_geometrie_geom_idx" ON "poste_de_transformation" USING GIST ("geometrie");
ALTER TABLE "poste_de_transformation" ADD COLUMN "cleabs" VARCHAR(24);
ALTER TABLE "poste_de_transformation" ADD COLUMN "toponyme" VARCHAR;
ALTER TABLE "poste_de_transformation" ADD COLUMN "statut_du_toponyme" VARCHAR;
ALTER TABLE "poste_de_transformation" ADD COLUMN "importance" VARCHAR;
ALTER TABLE "poste_de_transformation" ADD COLUMN "etat_de_l_objet" VARCHAR;
ALTER TABLE "poste_de_transformation" ADD COLUMN "date_creation" timestamp with time zone;
ALTER TABLE "poste_de_transformation" ADD COLUMN "date_modification" timestamp with time zone;
ALTER TABLE "poste_de_transformation" ADD COLUMN "date_d_apparition" date;
ALTER TABLE "poste_de_transformation" ADD COLUMN "date_de_confirmation" date;
ALTER TABLE "poste_de_transformation" ADD COLUMN "sources" VARCHAR;
ALTER TABLE "poste_de_transformation" ADD COLUMN "identifiants_sources" VARCHAR;
ALTER TABLE "poste_de_transformation" ADD COLUMN "methode_d_acquisition_planimetrique" VARCHAR;
ALTER TABLE "poste_de_transformation" ADD COLUMN "precision_planimetrique" NUMERIC(5,1);
ALTER TABLE "poste_de_transformation" ADD COLUMN "methode_d_acquisition_altimetrique" VARCHAR;
ALTER TABLE "poste_de_transformation" ADD COLUMN "precision_altimetrique" NUMERIC(5,1);
COMMIT;
SET standard_conforming_strings = OFF;
BEGIN;
COPY "poste_de_transformation" ("geometrie", "cleabs", "toponyme", "statut_du_toponyme", "importance", "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;
01060000A077110000010000000103000080010000000D000000333333338E012041000000B0086260410000000000408FC09A99999980012041CDCCCC9C056260410000000000408FC033333333980120419A999929056260410000000000408FC033333333C1012041CDCCCC7C046260410000000000408FC0CDCCCCCCE6012041000000E0036260410000000000408FC0CDCCCCCC3A0220419A999979026260410000000000408FC0CDCCCCCC430220419A999959026260410000000000408FC06666666650022041CDCCCC3C056260410000000000408FC0CDCCCCCC5002204166666656056260410000000000408FC0333333331A0220419A999919066260410000000000408FC000000000EB012041CDCCCCDC066260410000000000408FC033333333EC012041CDCCCC2C076260410000000000408FC0333333338E012041000000B0086260410000000000408FC0	POSTRANS0000002009244064	\N	\N	5	En service	2018/03/15 16:32:00.200	\N	\N	\N	\N		Orthophotographie	3.0	Pas de Z	9999.0
01060000A077110000010000000103000080010000000F0000009A999999D3A11F41CDCCCCECA663604133333333333334409A999999AFA11F41CDCCCC1CA76360419A99999999992F4000000000BAA11F419A9999C9A86360419A99999999992F4000000000D0A11F419A9999A9A86360419A99999999992F4000000000D8A11F41000000C0A96360419A99999999992F4000000000DEA21F419A999909A86360419A99999999992F4066666666DAA21F4133333393A76360419A99999999992F40CDCCCCCCFEA21F419A999919A76360419A99999999992F4033333333D7A21F41CDCCCC8CA46360419A99999999992F409A999999A3A21F41000000F0A4636041CDCCCCCCCC4C35409A9999999FA21F41CDCCCC4CA4636041CDCCCCCCCC4C3540333333333DA21F41CDCCCCFCA4636041CDCCCCCCCC4C35400000000042A21F41666666B6A5636041CDCCCCCCCC4C3540CDCCCCCC44A21F4133333323A663604133333333333334409A999999D3A11F41CDCCCCECA66360413333333333333440	POSTRANS0000002009240436	\N	\N	5	En service	2018/03/15 12:16:47.781	\N	\N	2016/07/01	\N		Photogrammétrie	2.5	Photogrammétrie	1.5
\.
END;
COMMIT;
