Changes between Version 56 and Version 57 of CCM2 download and load

Timestamp:

Apr 4, 2010 9:52:09 PM (15 years ago)

Author:

cedric

Comment:

--

CCM2 download and load

@@ -207 +207 @@
 -- In the function I tried to create a wso type to simplify the text. Pb you need to specify 
 -- a tablename.columname%TYPE which will have to change along with the column, hence the big ugly script below...
-DROP  FUNCTION IF EXISTS ccm21.pricatch_from_catch(gid_ numeric);
-CREATE OR REPLACE FUNCTION ccm21.pricatch_from_catch(gid_ numeric) RETURNS setof int AS $$
+DROP  FUNCTION IF EXISTS ccm21.mycatchment(gid_ numeric);
+CREATE OR REPLACE FUNCTION ccm21.mycatchment(gid_ numeric) RETURNS setof int AS $$
         DECLARE
         result RECORD;
@@ -357 +357 @@
         $$
 LANGUAGE 'plpgsql' ;
-COMMENT ON FUNCTION ccm21.pricatch_from_catch (gid_ numeric) IS 'Uses the gid from ccm21.riversegments, checks strahler, and select the catchment accordingly, then returns all primary catchments from this larger catchment';
+COMMENT ON FUNCTION ccm21.mycatchment (gid_ numeric) IS 'Uses the gid from ccm21.riversegments, checks strahler, and select the catchment accordingly, then returns all primary catchments from this larger catchment';
 }}}
 {{{
 --examples of use
 
-SELECT  ccm21.pricatch_from_catch(234706); --la vilaine dans son ensemble
+SELECT  ccm21.mycatchment(234706); --la vilaine dans son ensemble
 -- NOTICE:  result is (6)
 -- NOTICE:  WSO_6 used
@@ -368 +368 @@
 -- durée=2s
 --
-SELECT * from ccm21.catchments where wso1_id in (SELECT  ccm21.pricatch_from_catch(234706));
+SELECT * from ccm21.catchments where wso1_id in (SELECT  ccm21.mycatchment(234706));
 }}}
 === Plpgsql function which returns the riversegments upstream from the riversegment selected ===
@@ -392 +392 @@
         -- loop
         for gid_riversegments in select gid from ccm21.riversegments
-                where wso1_id in (SELECT  ccm21.pricatch_from_catch(gid_))
+                where wso1_id in (SELECT  ccm21.mycatchment(gid_))
                 and CAST(
                         substring(CAST(round(pfafstette) AS TEXT),1,pfafstette_chain_length)
@@ -403 +403 @@
 $$
 LANGUAGE 'plpgsql' ;
-COMMENT ON FUNCTION ccm21.upstream_segments(gid_ numeric) IS 'This function uses ccm21.pricatch_from_catch to get all the segments from a catchment and searches all segments with a pfafstetter higher than the segment in the bassin. The pfafstette are trucated to the level of the segment used as input in the function';
+COMMENT ON FUNCTION ccm21.upstream_segments(gid_ numeric) IS 'This function uses ccm21.mycatchment to get all the segments from a catchment and searches all segments with a pfafstetter higher than the segment in the bassin. The pfafstette are trucated to the level of the segment used as input in the function';
 }}}
 Usage example