Changes between Version 34 and Version 35 of Joining dams ROE on CCM

Timestamp:

Mar 23, 2011 5:23:47 PM (14 years ago)

Author:

celine

Comment:

--

Joining dams ROE on CCM

@@ -211 +211 @@
 FROM geobs2010.roe_ccm_500_final_gid as s inner join ccm21.rivernodes_france r on ST_DWithin(r.the_geom, s.the_geom,50) 
 where dist_sea_ccm<30 and CAST(distance(r.the_geom, s.the_geom) as  decimal(15,1))>15);
-}}}
+
+update geobs2010.roe_ccm_500_final_gid SET verificationccm='t' where ref_id in (12205,13518);
+}}}