Changes between Version 11 and Version 12 of UGA


Ignore:
Timestamp:
Jul 20, 2010 5:28:11 PM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • UGA

    v11 v12  
    3030["Cookbook CCM21_UGA"] 
    3131 
    32 {{{ 
    33      drop table  if exists uga2010.wso; 
    34      CREATE TABLE uga2010.wso ( 
    35      id serial PRIMARY KEY, 
    36      wso_id integer, 
    37      uga varchar(25) 
    38      ) 
    3932 
    40 --Loire 
    41     insert into uga2010.wso(wso_id)  
    42     select distinct on (wso_id)  wso_id from ccm21.riversegments r 
    43     join (SELECT ST_Union(f.the_geom) as singlegeom 
    44         FROM uga2010.uga As f where gid='1') as sub 
    45     ON ST_Intersects(sub.singlegeom,r.the_geom); 
    4633 
    47     UPDATE uga2010.wso set uga='Loire' where uga IS NULL --40 sea nodes 
    48  
    49 --Garonne 
    50     insert into uga2010.wso(wso_id)  
    51     select distinct on (wso_id)  wso_id from ccm21.riversegments r 
    52     join (SELECT ST_Union(f.the_geom) as singlegeom 
    53         FROM uga2010.uga As f where gid='2') as sub 
    54     ON ST_Intersects(sub.singlegeom,r.the_geom); 
    55  
    56     UPDATE uga2010.wso set uga='Garonne' where uga IS NULL --60 sea nodes 
    57  
    58 --Adour 
    59     insert into uga2010.wso(wso_id)  
    60     select distinct on (wso_id)  wso_id from ccm21.riversegments r 
    61     join (SELECT ST_Union(f.the_geom) as singlegeom 
    62         FROM uga2010.uga As f where gid='3') as sub 
    63     ON ST_Intersects(sub.singlegeom,r.the_geom); 
    64  
    65     UPDATE uga2010.wso set uga='Adour' where uga IS NULL --19 sea nodes 
    66  
    67 --Artois-Picardie 
    68     insert into uga2010.wso(wso_id)  
    69     select distinct on (wso_id)  wso_id from ccm21.riversegments r 
    70     join (SELECT ST_Union(f.the_geom) as singlegeom 
    71         FROM uga2010.uga As f where gid='4') as sub 
    72     ON ST_Intersects(sub.singlegeom,r.the_geom); 
    73  
    74     UPDATE uga2010.wso set uga='ArtoisPicardie' where uga IS NULL -- sea nodes 
    75  
    76 --Rhône-M‚diterranée 
    77     insert into uga2010.wso(wso_id)  
    78     select distinct on (wso_id)  wso_id from ccm21.riversegments r 
    79     join (SELECT ST_Union(f.the_geom) as singlegeom 
    80         FROM uga2010.uga As f where gid='5') as sub 
    81     ON ST_Intersects(sub.singlegeom,r.the_geom); 
    82  
    83     UPDATE uga2010.wso set uga='RhoneMediterranee' where uga IS NULL -- sea nodes 
    84  
    85 --Corse 
    86     insert into uga2010.wso(wso_id)  
    87     select distinct on (wso_id)  wso_id from ccm21.riversegments r 
    88     join (SELECT ST_Union(f.the_geom) as singlegeom 
    89         FROM uga2010.uga As f where gid='6') as sub 
    90     ON ST_Intersects(sub.singlegeom,r.the_geom); 
    91  
    92     UPDATE uga2010.wso set uga='Corse' where uga IS NULL -- sea nodes 
    93  
    94 --Seine-Normandie 
    95     insert into uga2010.wso(wso_id)  
    96     select distinct on (wso_id)  wso_id from ccm21.riversegments r 
    97     join (SELECT ST_Union(f.the_geom) as singlegeom 
    98         FROM uga2010.uga As f where gid='7') as sub 
    99     ON ST_Intersects(sub.singlegeom,r.the_geom); 
    100  
    101     UPDATE uga2010.wso set uga='Seine-Normandie' where uga IS NULL -- sea nodes 
    102  
    103 --Bretagne 
    104     insert into uga2010.wso(wso_id)  
    105     select distinct on (wso_id)  wso_id from ccm21.riversegments r 
    106     join (SELECT ST_Union(f.the_geom) as singlegeom 
    107         FROM uga2010.uga As f where gid='8') as sub 
    108     ON ST_Intersects(sub.singlegeom,r.the_geom); 
    109  
    110     UPDATE uga2010.wso set uga='Bretagne' where uga IS NULL -- sea nodes 
    111  
    112 --Rhin 
    113     insert into uga2010.wso(wso_id)  
    114     select distinct on (wso_id)  wso_id from ccm21.riversegments r 
    115     join (SELECT ST_Union(f.the_geom) as singlegeom 
    116         FROM uga2010.uga As f where gid='9') as sub 
    117     ON ST_Intersects(sub.singlegeom,r.the_geom); 
    118  
    119     UPDATE uga2010.wso set uga='Rhin' where uga IS NULL -- sea nodes 
    120  
    121 --Meuse 
    122  
    123     insert into uga2010.wso(wso_id)  
    124     select distinct on (wso_id)  wso_id from ccm21.riversegments r 
    125     join (SELECT ST_Union(f.the_geom) as singlegeom 
    126         FROM uga2010.uga As f where gid='10') as sub 
    127     ON ST_Intersects(sub.singlegeom,r.the_geom); 
    128  
    129     UPDATE uga2010.wso set uga='Meuse' where uga IS NULL -- sea nodes 
    130 }}} 
    131