Changes between Initial Version and Version 1 of Meuse distancesource


Ignore:
Timestamp:
Jun 20, 2014 10:03:01 AM (11 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Meuse distancesource

    v1 v1  
     1 
     2 
     3{{{ 
     4#!sql 
     5update ccm21.riversegments set distance_source=shape_leng where gid in( 
     6select distinct on (rs.gid) rs.gid from ccm21.riversegments rs 
     7where rs.wso_id in (select wso_id from europe.wso where area='Meuse') 
     8except (         
     9select distinct on (rs.gid) rs.gid  from ccm21.riversegments rs 
     10        inner join ccm21.riversegments rup on rup.tonode=rs.fromnode 
     11        where rs.wso_id in (select wso_id from europe.wso where area='Meuse')) 
     12        order by gid) 
     13}}}