Changes between Version 58 and Version 59 of CookBook join ROE_CCM

Timestamp:

Apr 16, 2010 9:46:24 AM (15 years ago)

Author:

celine

Comment:

--

CookBook join ROE_CCM

@@ -124 +124 @@
                SELECT ref_id, gid ,CAST(distance(r.the_geom, b.ref_position_etrs89) as  decimal(15,1)) as distance ,b.ref_position_etrs89
                FROM geobs.obstacle_referentiel As b
-               INNER JOIN  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,1000)
 --             WHERE b.goodproj IS TRUE -- Attention c'est faux
                ORDER BY ref_id) AS sub