Changes between Version 60 and Version 61 of CCM2 download and load


Ignore:
Timestamp:
Apr 5, 2010 6:34:58 PM (15 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • CCM2 download and load

    v60 v61  
    371371}}} 
    372372=== Plpgsql function which returns the riversegments upstream from the riversegment selected === 
    373 Note : It is necessary to create a table as the pfafstetter along an axis can have a shorter length upstream than the length of the selected segment [[BR]] 
     373Note : It is necessary to create a table called ccm21.upstream_segments. Indeed, the pfafstetter along an axis can have a shorter length upstream than the length of the selected segment [[BR]] 
    374374The maximum length for a pfafstetter is 14 in the ccm. Transforming the database to store a column number with 14 number would increase the size of the database. [[BR]] 
    375375It is also not possible to create a variable in plpgsql storing more than one line. For these two reasons, a table upstream_segments is created and is filled with the segments of the basin, and further reduced to the segments upstream from the segment passed as parameter to the function. The function returns a resultset of integer values (gid)