Changes between Version 10 and Version 11 of Cookbook CCM21_France

Timestamp:

May 27, 2010 4:39:20 PM (15 years ago)

Author:

cedric

Comment:

--

Cookbook CCM21_France

@@ -46 +46 @@
 
 [[Image(source:data/Docs/trac/riversegmentsfrance.jpg)]] 
+{{{
+#!sql
+-- pour des essais sélection de la Bretagne
+insert into france.wso(wso_id) 
+select distinct on (wso_id)  wso_id from ccm21.riversegments r
+join (SELECT the_geom
+    FROM france.region where code_reg='53') as sub
+ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines
+
+UPDATE france.wso set area='Bretagne' where area IS NULL
+}}}