Changes between Version 9 and Version 10 of Lakes


Ignore:
Timestamp:
Oct 19, 2010 1:05:06 PM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Lakes

    v9 v10  
    1515select r.wso_id, r.wso1_id, cont_pixel, upstream_a, l.wso_id from ccm21.riversegments as r inner join ccm21.lakes as l on r.cont_pixel=l.upstream_a and r.wso_id=l.wso_id where r.wso_id=291112 order by cont_pixel 
    1616}}} 
     17{{{ 
     18select r.wso_id, r.wso1_id, l.gid, cont_pixel, upstream_a, l.wso_id from ccm21.riversegments as r inner join ccm21.lakes as l on r.cont_pixel=l.upstream_a and r.wso_id=l.wso_id and r.pfafstette=l.pfafstette where r.wso_id=291112 order by l.gid 
     19}}} 
    1720 
    1821 * Some are on the same river segement --> one cont_pixel in riversegments = one upstream_a