Changes between Version 70 and Version 71 of CookBook join ROE_CCM


Ignore:
Timestamp:
May 4, 2010 10:59:21 AM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • CookBook join ROE_CCM

    v70 v71  
    104104The following does not work and it makes sense, we should only have one geom of france 
    105105{{{ 
    106 SELECT  count(ref_id) from geobs2010.obstacle_referentiel o 
     106SELECT  count(ref_id) from geobs.obstacle_referentiel o 
    107107 join france.departement f ON ST_DWithin(f.the_geom, o.ref_position_etrs89, 2000); --49468 
    108108}}}