Changes between Version 29 and Version 30 of Joining dams ROE on CCM

Timestamp:

Mar 23, 2011 2:18:34 PM (14 years ago)

Author:

celine

Comment:

--

Joining dams ROE on CCM

@@ -132 +132 @@
 Le seuil de distance est à modifier (10-30-50m plus ?)
 {{{
-SELECT s.ref_id, s.gid , s.id_trhyd, CAST(distance(r.the_geom, s.the_geom) as  decimal(15,1)) as distance, s.the_geom 
+SELECT s.ref_id, s.gid ,s.dist_sea_ccm, s.id_trhyd, CAST(distance(r.the_geom, s.the_geom) as  decimal(15,1)) as distance, s.the_geom 
 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) order by distance
+inner join ccm21.rivernodes_france r on ST_DWithin(r.the_geom, s.the_geom,50) order by s.dist_sea_ccm, distance
 }}}