back to first page [..][[BR]]
back to ["CookBook Eda"][[BR]]
back to ["UGA"][[BR]]
back to ["Ecological regions"][[BR]]

{{{
drop table  if exists dmeer2003.wso1;
     CREATE TABLE dmeer2003.wso1 (
     id serial PRIMARY KEY,
     wso_id integer,
     wso1_id integer,
     ecoregion varchar(99)
     );


 --Southern Temperate Atlantic
    insert into dmeer2003.wso1(wso_id, wso1_id) 
    select distinct on (wso1_id, wso_id) wso_id, wso1_id from ccm21.riversegments r
    join (SELECT ST_Union(f.the_geom) as singlegeom
        FROM dmeer2003.ecologicalregion_polygon As f where eco_code='11') as sub
    ON ST_Intersects(sub.singlegeom,r.the_geom);

    UPDATE dmeer2003.wso1 set ecoregion='Southern Temperate Atlantic' where ecoregion IS NULL -- lignes



}}}