Changes between Version 61 and Version 62 of CookBook join ROE_CCM


Ignore:
Timestamp:
Apr 16, 2010 3:21:43 PM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • CookBook join ROE_CCM

    v61 v62  
    109109 join france.departement f ON ST_DWithin(f.the_geom, o.ref_position_etrs89, 2000); --49468 
    110110}}} 
     111{{{ 
     112SELECT  count(ref_id) from geobs2010.obstacle_referentiel o 
     113 join france.departement f ON ST_DWithin(f.the_geom, o.ref_position_etrs89, 2000); --52986 
     114}}} 
    111115I first aggregate all departements and then join this glued layer with the dam layer, the distance is 2000 
    112116{{{