SET NAMES 'UTF8';
--
--
start transaction;
-- "Transport par câble. Moyen de transport constitué d'un ou plusieurs c^:ables porteurs":
--
create table TRANSPORT_CABLE (gid SERIAL not null, ID varchar(24) not null, PREC_PLANI decimal(6,1) not null, PREC_ALTI decimal(7,1) not null, NATURE varchar(19) default 'NR', Z_MIN float, Z_MAX float, Z_INI float, Z_FIN float, constraint TRANSPORT_CABLE_pkey primary key (gid));
select AddGeometryColumn('','transport_cable','the_geom','4471','MULTILINESTRING',3);
create index TRANSPORT_CABLE_geoidx on TRANSPORT_CABLE using gist (the_geom);
--
commit;
--
-- TRANSPORT_CABLE
start transaction;
copy TRANSPORT_CABLE (gid, ID , PREC_PLANI , PREC_ALTI , NATURE , Z_MIN, Z_MAX, Z_INI, Z_FIN, the_geom) from STDIN ;
1	TRANCABL0000001600001447	   1.5	    1.0	Câble transporteur	378.3	484.0	484.0	378.3	01050000A07711000001000000010200008004000000CDCCCCCC8A871F41CDCCCC1CA75F60410000000000407E400000000034881F4166666636AB5F60419A99999999E17D40333333339B891F4166666656B45F60419A9999999981784033333333198A1F4100000080B75F6041CDCCCCCCCCA47740
\.
commit;
--
