Changes between Version 22 and Version 23 of Distance source

Timestamp:

May 25, 2012 1:53:11 PM (13 years ago)

Author:

celine

Comment:

--

Distance source

@@ -3 +3 @@
 
 {{{
+#!sql
 alter table ccm21.riversegments add column distance_source numeric;
 }}}
@@ -14 +15 @@
 In the ccm we find the cum_length which is the cumulated length of upstream riversegments but not the distance to the farthest source
 {{{
+#!sql
 select round(max(cum_len_sea+shape_leng) -(select cum_len_sea from ccm21.riversegments where gid =234706)) 
 as dist_source from ccm21.riversegments where gid in (select ccm21.upstream_segments(234706));
@@ -39 +41 @@
 Avec cette requête :--> le gid n'est pas dans la liste[[BR]]
 {{{
+#!sql
 select distinct on (rs.gid) rs.gid  from ccm21.riversegments rs 
 inner JOIN ccm21.riversegments rup on rup.tonode=rs.fromnode