Changes between Version 11 and Version 12 of BDCarthage2011 into eda2.0_RHT

Timestamp:

Sep 27, 2011 5:47:04 PM (14 years ago)

Author:

celine

Comment:

--

BDCarthage2011 into eda2.0_RHT

@@ -93 +93 @@
 
 
+DROP TABLE IF EXISTS bd_carthage2011.troncon_Bretagne;   
+CREATE TABLE  bd_carthage2011.troncon_Bretagne AS
+    SELECT * FROM bd_carthage2011.troncon_hydrographique
+        WHERE id_bdcarth IN (SELECT id_bdcarth FROM uga2010.id_bdcarthage WHERE uga='Bretagne');
+ALTER TABLE bd_carthage2011.troncon_Bretagne ADD CONSTRAINT pk_id_bdcarth_Bretagne PRIMARY KEY  (id_bdcarth);
+INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
+SELECT '', 'bd_carthage2011', 'troncon_Bretagne', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
+FROM bd_carthage2011.troncon_Bretagne LIMIT 1;
+
 }}}