Changes between Version 55 and Version 56 of CookBook join ROE_CCM
- Timestamp:
- Mar 24, 2010 10:34:37 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
CookBook join ROE_CCM
v55 v56 125 125 FROM geobs.obstacle_referentiel As b 126 126 INNER JOIN riversegments r ON ST_DWithin(r.the_geom, b.ref_position_etrs89,1000) 127 WHERE b.goodproj IS TRUE 127 -- WHERE b.goodproj IS TRUE -- Attention c'est faux 128 128 ORDER BY ref_id) AS sub 129 129 GROUP BY ref_id, gid, the_geom