SET client_encoding = 'utf-8';
SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "canalisation" CASCADE;
BEGIN;
CREATE TABLE "canalisation"();
SELECT AddGeometryColumn('canalisation','geometrie',4471,'LINESTRING',3);
CREATE INDEX "canalisation_geometrie_geom_idx" ON "canalisation" USING GIST ("geometrie");
ALTER TABLE "canalisation" ADD COLUMN "cleabs" VARCHAR(24);
ALTER TABLE "canalisation" ADD CONSTRAINT "canalisation_cleabs_pkey" PRIMARY KEY ("cleabs");
ALTER TABLE "canalisation" ADD COLUMN "nature" VARCHAR;
ALTER TABLE "canalisation" ADD COLUMN "position_par_rapport_au_sol" VARCHAR;
ALTER TABLE "canalisation" ADD COLUMN "etat_de_l_objet" VARCHAR;
ALTER TABLE "canalisation" ADD COLUMN "date_creation" timestamp with time zone;
ALTER TABLE "canalisation" ADD COLUMN "date_modification" timestamp with time zone;
ALTER TABLE "canalisation" ADD COLUMN "date_d_apparition" date;
ALTER TABLE "canalisation" ADD COLUMN "date_de_confirmation" date;
ALTER TABLE "canalisation" ADD COLUMN "sources" VARCHAR;
ALTER TABLE "canalisation" ADD COLUMN "identifiants_sources" VARCHAR;
ALTER TABLE "canalisation" ADD COLUMN "methode_d_acquisition_planimetrique" VARCHAR;
ALTER TABLE "canalisation" ADD COLUMN "precision_planimetrique" NUMERIC(5,1);
ALTER TABLE "canalisation" ADD COLUMN "methode_d_acquisition_altimetrique" VARCHAR;
ALTER TABLE "canalisation" ADD COLUMN "precision_altimetrique" NUMERIC(5,1);
COMMIT;
SET standard_conforming_strings = OFF;
BEGIN;
COPY "canalisation" ("geometrie", "cleabs", "nature", "position_par_rapport_au_sol", "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;
01020000A07711000010000000666666660C9D1F41666666F6536460410000000000408FC0CDCCCCCC329D1F419A9999D9526460410000000000408FC066666666449D1F4100000060536460410000000000408FC0CDCCCCCC8A9D1F4133333333516460410000000000408FC033333333FD9D1F4133333313536460410000000000408FC0000000002C9E1F4133333313536460410000000000408FC033333333359E1F41333333A3526460410000000000408FC0CDCCCCCC349E1F41CDCCCC7C506460410000000000408FC0333333331F9E1F41CDCCCC2C4B6460410000000000408FC0CDCCCCCC029E1F41333333A3466460410000000000408FC09A999999059E1F419A9999F9426460410000000000408FC0666666660A9E1F41CDCCCC0C426460410000000000408FC0333333330D9E1F41666666F6406460410000000000408FC033333333BB9D1F419A9999F93F6460410000000000408FC0666666669E9D1F4133333393436460410000000000408FC000000000709D1F4100000030436460410000000000408FC0	CANALISA0000002330465817	Hydrocarbures	0	En service	2023/03/06 17:46:24.254	\N	\N	\N	\N	\N	Orthophotographie	3.0	Pas de Z	9999.0
01020000A077110000050000006666666664302041CDCCCCFCAC6160410000000000408FC066666666F82F20419A9999A9B76160410000000000408FC066666666F22F2041CDCCCCACB76160410000000000408FC09A9999994F2F204100000070AD6160410000000000408FC033333333F42E204100000020A66160410000000000408FC0	CANALISA0000002333225308	Hydrocarbures	0	En service	2023/06/05 19:47:33.584	\N	\N	\N	\N	\N	Orthophotographie	3.0	Pas de Z	9999.0
01020000A077110000040000009A999999ABBF1F4166666636445E60410000000000408FC09A999999E7C01F41CDCCCCFC475E60410000000000408FC000000000CEC11F41000000A0455E60410000000000408FC000000000D2C11F41CDCCCCAC445E60410000000000408FC0	CANALISA0000002333971729	Autres matières premières	1	En service	2023/07/28 12:47:52.020	\N	\N	\N	\N	\N	Orthophotographie	3.0	Pas de Z	9999.0
01020000A077110000020000009A999999E7C01F41CDCCCCFC475E60410000000000408FC0CDCCCCCCFCC01F41000000104B5E60410000000000408FC0	CANALISA0000002333971730	Autres matières premières	1	En service	2023/07/28 12:47:52.020	\N	\N	\N	\N	\N	Orthophotographie	3.0	Pas de Z	9999.0
01020000A07711000008000000666666666EC11F41333333833E5E60410000000000408FC09A99999985C11F419A9999893E5E60410000000000408FC09A999999F1C11F419A9999893C5E60410000000000408FC06666666642C21F41333333C33C5E60410000000000408FC09A99999997C21F41CDCCCC0C3D5E60410000000000408FC066666666DEC21F41CDCCCC7C3A5E60410000000000408FC0666666667AC31F41CDCCCC6C3B5E60410000000000408FC033333333B1C31F41666666763B5E60410000000000408FC0	CANALISA0000002333971731	Autres matières premières	1	En service	2023/07/28 12:47:52.020	\N	\N	\N	\N	\N	Orthophotographie	3.0	Pas de Z	9999.0
\.
END;
COMMIT;
