Changes between Version 9 and Version 10 of CLC upstream

Timestamp:

Jul 1, 2010 12:02:28 PM (15 years ago)

Author:

cedric

Comment:

--

CLC upstream

@@ -46 +46 @@
 
 [[Image(source:data/Docs/trac/clc/percentage_art_.png,600px)]]
+
+{{{
+#!sql
+--the request with france had troubles in getting some of the riversegments, the short ones that were not fully
+-- france and were not part of a larger basin (the request was done on wso_id)
+-- here I'm searching for those missing gid
+select gid from ccm21.riversegments where wso_id in (select wso_id from france.wso where area='France')
+except select gid from ccm21.riversegments where wso_id in (
+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));
+}}}