Changes between Version 6 and Version 7 of Cookbook CCM21_France

Timestamp:

May 4, 2010 4:59:37 PM (15 years ago)

Author:

cedric

Comment:

--

Cookbook CCM21_France

@@ -7 +7 @@
 Geometry A contains Geometry B 
 */
-
-
 -- first trial..
 /*
@@ -17 +15 @@
 */
  -- we try to get the vector of seaoutlets that are within the geographical area
-select * from ccm21.riversegments r where wso_id in (
+}}}
+ -- a table containing three columns 
+{{{
+ drop table  if exists france.wso;
+ CREATE TABLE france.wso (
+ id serial PRIMARY KEY,
+ wso_id integer,
+ area varchar(12)
+ )
+}}}
+{{{
+insert into france.wso(wso_id) 
 select distinct on (wso_id)  wso_id from ccm21.riversegments r
 join (SELECT ST_Union(f.the_geom) as singlegeom
     FROM france.departement As f) as sub
-ON ST_Contains(sub.singlegeom,r.the_geom)); --170703 lines
+ON ST_Contains(sub.singlegeom,r.the_geom); --170703 lines
+UPDATE france.wso set area='France' where area IS NULL
+
+select * from ccm21.riversegments where wso_id in (select wso_id from france.wso where area='France')--170703 lines
 }}}