Changes between Version 17 and Version 18 of BDCarthage2011 into eda2.0_RHT

Timestamp:

Sep 28, 2011 4:47:11 PM (14 years ago)

Author:

celine

Comment:

--

BDCarthage2011 into eda2.0_RHT

@@ -131 +131 @@
 C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 -c -g the_geom -W LATIN1 -I clip_troncon.shp clip_troncon > clip_troncon.sql 
 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0_RHT -h localhost -U postgres -p 5432 -f clip_troncon.sql 
-alter table clip_troncon set schema rht;
 
+Alter table clip_troncon set schema rht;
+DROP TABLE IF EXISTS bd_carthage2011.troncon_bv;   
+CREATE TABLE  bd_carthage2011.troncon_bv AS
+    select bdc.* from bd_carthage2011.troncon_hydrographique bdc, rht.clip_troncon as clip where st_contains(clip.the_geom,bdc.the_geom)=true;
+ALTER TABLE bd_carthage2011.troncon_bv ADD CONSTRAINT pk_id_bdcarth_bv PRIMARY KEY  (gid);
+INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
+SELECT '', 'bd_carthage2011', 'troncon_bv', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
+FROM bd_carthage2011.troncon_bv LIMIT 1;
 
+DROP TABLE IF EXISTS rht.rht_bv;   
+CREATE TABLE  rht.rht_bv AS
+    SELECT r.* FROM rht.rht r, rht.clip_troncon as clip where st_contains(clip.the_geom,r.the_geom)=true;
+ALTER TABLE rht.rht_bv ADD CONSTRAINT pk_id_drain_rht_bv PRIMARY KEY  (id_drain);
+INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
+SELECT '', 'rht', 'rht_bv', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
+FROM rht.rht_bv LIMIT 1;
 
 }}}