SET NAMES 'UTF8';
--
--
start transaction;
-- "Canalisation ou tapis roulant":
--
create table CANALISATION_EAU (gid SERIAL not null, ID varchar(24) not null, PREC_PLANI decimal(6,1) not null, PREC_ALTI decimal(7,1) not null, POS_SOL integer not null, constraint CANALISATION_EAU_pkey primary key (gid));
select AddGeometryColumn('','canalisation_eau','the_geom','32620','MULTILINESTRING',3);
create index CANALISATION_EAU_geoidx on CANALISATION_EAU using gist (the_geom);
--
commit;
--
-- CANALISATION_EAU
start transaction;
copy CANALISATION_EAU (gid, ID , PREC_PLANI , PREC_ALTI , POS_SOL , the_geom) from STDIN ;
1	CANALISA0000001169870847	  10.0	 9999.0	-1	[encoded data, 14060 characters]
\.
commit;
--
