Changes between Version 78 and Version 79 of CookBook join ROE_CCM

Timestamp:

May 4, 2010 11:38:29 AM (15 years ago)

Author:

cedric

Comment:

--

CookBook join ROE_CCM

@@ -141 +141 @@
                SELECT ref_id, gid ,CAST(distance(r.the_geom, b.ref_position_etrs89) as  decimal(15,1)) as distance ,b.ref_position_etrs89
                FROM geobs2010.obstacle_referentiel As b
-               INNER JOIN  ccm21.riversegments r ON ST_DWithin(r.the_geom, b.ref_position_etrs89,1000)
+               INNER JOIN  ccm21.riversegments r ON ST_DWithin(r.the_geom, b.ref_position_etrs89,300)
 --             WHERE b.goodproj IS TRUE -- Attention c'est faux
                ORDER BY ref_id) AS sub