Changes between Version 30 and Version 31 of Cookbook CCM21_France

Timestamp:

Jul 27, 2010 3:30:01 PM (15 years ago)

Author:

cedric

Comment:

--

Cookbook CCM21_France

@@ -120 +120 @@
 CREATE TABLE  ccm21.catchments_france AS
 SELECT * FROM ccm21.catchments
-WHERE wso_id IN (SELECT wso_id FROM france.wso WHERE area='france'); 
+WHERE wso_id IN (SELECT wso_id FROM france.wso WHERE area='France'); 
                
 ALTER TABLE ccm21.catchments_france ADD CONSTRAINT c_pk_gid_catchments_france PRIMARY KEY  (gid);
@@ -132 +132 @@
 CREATE INDEX index_catchments_france ON ccm21.catchments_france
   USING GIST ( the_geom GIST_GEOMETRY_OPS ); 
+
 CREATE INDEX indexcatchmentsfrance_wso1_id
-  ON ccm21.catchments
+  ON ccm21.catchments_france
   USING btree
   (wso1_id);
+
 }}}