Changes between Version 4 and Version 5 of EMU Download and load


Ignore:
Timestamp:
Sep 14, 2010 4:20:24 PM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • EMU Download and load

    v4 v5  
    6868SELECT  DISTINCT bassin.wso_id, 'Britanny' as EMU FROM ccm21.riversegments as bassin, (SELECT *, ST_Transform(the_geom,3035) as the_geom2 FROM uga2010.uga  WHERE libelle='Bretagne') as rbd_selection WHERE bassin.the_geom && rbd_selection.the_geom2 AND (within(bassin.the_geom, rbd_selection.the_geom2)) AND NOT bassin.wso_id =291111; -- 164 lines 
    6969}}} 
     70 
     71Nombre de ligne pour la Bretagne différent de celui des UGA : 164 au lieu de 166 lignes.[[BR]] 
     72Il manque deux wso_id : 353376 et 354061 which are on a island  --> ok [[BR]] 
     73