Changes between Version 9 and Version 10 of BDCarthage2011 into eda2.0_RHT

Timestamp:

Sep 27, 2011 5:41:26 PM (14 years ago)

Author:

celine

Comment:

--

BDCarthage2011 into eda2.0_RHT

@@ -82 +82 @@
 
     UPDATE uga2010.id_bdcarthage set uga='Bretagne' where uga IS NULL -- 27250 lignes
+
+DROP TABLE IF EXISTS rht.rht_Bretagne;   
+CREATE TABLE  rht.rht_Bretagne AS
+    SELECT * FROM rht.rht
+        WHERE id_drain IN (SELECT id_drain FROM uga2010.id_drain WHERE area='Bretagne');
+ALTER TABLE rht.rht_Bretagne ADD CONSTRAINT c_pk_gid_rht_Bretagne 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_Bretagne', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
+FROM rht.rht_Bretagne LIMIT 1;
+
+
 }}}