back to first page ..
back to CookBook Eda
back to UGA
back to Ecological regions

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