Changes between Version 58 and Version 59 of CCM2 download and load


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

--

Legend:

Unmodified
Added
Removed
Modified
  • CCM2 download and load

    v58 v59  
    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 selected 
    374 The 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. 
    375 It is also not possible to create a variable in PlSql storing more than one line. For these two reasons, a table upstream_segments is created and is filled with  
     373Note : 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]] 
     374The 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]] 
     375It is also not possible to create a variable in PlSql 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) 
    376376{{{ 
    377377DROP TYPE IF EXISTS gid;