SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "point_du_reseau" CASCADE;
BEGIN;
CREATE TABLE "point_du_reseau"();
SELECT AddGeometryColumn('point_du_reseau','geometrie',4471,'GEOMETRY',3);
CREATE INDEX "point_du_reseau_geometrie_geom_idx" ON "point_du_reseau" USING GIST ("geometrie");
ALTER TABLE "point_du_reseau" ADD COLUMN "cleabs" VARCHAR(24);
ALTER TABLE "point_du_reseau" ADD COLUMN "nature" VARCHAR;
ALTER TABLE "point_du_reseau" ADD COLUMN "nature_detaillee" VARCHAR;
ALTER TABLE "point_du_reseau" ADD COLUMN "toponyme" VARCHAR;
ALTER TABLE "point_du_reseau" ADD COLUMN "statut_du_toponyme" VARCHAR;
ALTER TABLE "point_du_reseau" ADD COLUMN "etat_de_l_objet" VARCHAR;
ALTER TABLE "point_du_reseau" ADD COLUMN "date_creation" timestamp with time zone;
ALTER TABLE "point_du_reseau" ADD COLUMN "date_modification" timestamp with time zone;
ALTER TABLE "point_du_reseau" ADD COLUMN "date_d_apparition" date;
ALTER TABLE "point_du_reseau" ADD COLUMN "date_de_confirmation" date;
ALTER TABLE "point_du_reseau" ADD COLUMN "sources" VARCHAR(127);
ALTER TABLE "point_du_reseau" ADD COLUMN "identifiants_sources" VARCHAR(255);
ALTER TABLE "point_du_reseau" ADD COLUMN "precision_planimetrique" NUMERIC(5,1);
ALTER TABLE "point_du_reseau" ADD COLUMN "precision_altimetrique" NUMERIC(5,1);
COMMIT;
SET standard_conforming_strings = OFF;
BEGIN;
COPY "point_du_reseau" ("geometrie", "cleabs", "nature", "nature_detaillee", "toponyme", "statut_du_toponyme", "etat_de_l_objet", "date_creation", "date_modification", "date_d_apparition", "date_de_confirmation", "sources", "identifiants_sources", "precision_planimetrique", "precision_altimetrique") FROM STDIN;
01010000A077110000CDCCCCCC530520419A9999A9B06160410000000000408FC0	PT_RESEA0000001600341325	Barrière	\N	\N	\N	En service	2015/02/02 13:30:28.824	\N	\N	\N	\N		5.0	999.0
01010000A077110000CDCCCCCCA904204166666656286160410000000000408FC0	PT_RESEA0000001600341324	Barrière	\N	\N	\N	En service	2015/02/02 13:30:28.824	\N	\N	\N	\N		5.0	999.0
01010000A07711000000000000101B20419A999959CB6060410000000000408FC0	PT_RESEA0000001600341323	Barrière	\N	\N	\N	En service	2015/02/02 13:30:28.824	\N	\N	\N	\N		5.0	999.0
01010000A07711000000000000A51B2041CDCCCC4CD36060410000000000408FC0	PT_RESEA0000001600341322	Barrière	\N	\N	\N	En service	2015/02/02 13:30:28.824	\N	\N	\N	\N		5.0	999.0
01010000A07711000000000000D21A204100000000D36060410000000000408FC0	PT_RESEA0000001600341321	Barrière	\N	\N	\N	En service	2015/02/02 13:30:28.824	\N	\N	\N	\N		5.0	999.0
01010000A07711000000000000D11A2041CDCCCC2CD76060410000000000408FC0	PT_RESEA0000001600341320	Barrière	\N	\N	\N	En service	2015/02/02 13:30:28.824	\N	\N	\N	\N		5.0	999.0
01010000A07711000066666666281B2041666666A6D96060410000000000408FC0	PT_RESEA0000001600341319	Barrière	\N	\N	\N	En service	2015/02/02 13:30:28.824	\N	\N	\N	\N		5.0	999.0
01010000A0771100009A999999E1931F41000000D03C5860410000000000408FC0	PT_RESEA0000001600342598	Barrière	\N	\N	\N	En service	2015/02/09 10:34:18.499	\N	\N	\N	\N		5.0	999.0
01010000A077110000CDCCCCCC6C2F204133333343A96060410000000000408FC0	PT_RESEA0000001600340293	Barrière	\N	\N	\N	En service	2015/02/02 12:43:42.627	2015/02/09 11:00:04.058	\N	\N	\N		5.0	999.0
01010000A077110000333333338BCB1F41666666162B5E60410000000000408FC0	PT_RESEA0000001600342650	Barrière	\N	\N	\N	En service	2015/02/09 11:26:16.860	\N	\N	\N	\N		5.0	999.0
01010000A077110000CDCCCCCCA4661F41CDCCCC5C215B60410000000000408FC0	PT_RESEA0000001600342663	Barrière	\N	\N	\N	En service	2015/02/09 11:29:40.198	\N	\N	\N	\N		5.0	999.0
01010000A077110000CDCCCCCC26F81F4133333363746160410000000000408FC0	PT_RESEA0000001600342668	Barrière	\N	\N	\N	En service	2015/02/09 11:32:40.548	\N	\N	\N	\N		5.0	999.0
01010000A07711000033333333002E204100000070866160410000000000408FC0	PT_RESEA0000002102077014	Barrière	\N	\N	\N	En service	2018/11/21 19:09:38.283	\N	\N	\N	\N		3.0	999.0
\.
END;
COMMIT;
