Changes between Version 17 and Version 18 of Cookbook CCM21_EcologicalRegion


Ignore:
Timestamp:
Oct 3, 2012 4:47:10 PM (13 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Cookbook CCM21_EcologicalRegion

    v17 v18  
    4848    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    4949 
    50     UPDATE ecoregion2003.wso1 set ecoregion='Southern Temperate Atlantic' where ecoregion IS NULL -- 20485 lignes 
     50    UPDATE ecoregion2003.wso1 set ecoregion='Southern Temperate Atlantic' where ecoregion IS NULL -- 20485 lines 
    5151 
    5252 
    … …  
    5858    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    5959 
    60     UPDATE ecoregion2003.wso1 set ecoregion='Western European broadleaf forests' where ecoregion IS NULL -- 58387 lignes 
     60    UPDATE ecoregion2003.wso1 set ecoregion='Western European broadleaf forests' where ecoregion IS NULL -- 58387 lines 
    6161 
    6262 --Northeastern Spain & Southern France Mediterranean 
    … …  
    6767    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    6868 
    69     UPDATE ecoregion2003.wso1 set ecoregion='Northeastern Spain & Southern France Mediterranean' where ecoregion IS NULL -- 20813 lignes 
     69    UPDATE ecoregion2003.wso1 set ecoregion='Northeastern Spain & Southern France Mediterranean' where ecoregion IS NULL -- 20813 lines 
    7070 
    7171 
    … …  
    7777    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    7878 
    79     UPDATE ecoregion2003.wso1 set ecoregion='Cantabrian mixed forests' where ecoregion IS NULL -- 26327 lignes 
     79    UPDATE ecoregion2003.wso1 set ecoregion='Cantabrian mixed forests' where ecoregion IS NULL -- 26327 lines 
    8080 
    8181 --North Atlantic moist mixed forests 
    … …  
    8686    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    8787 
    88     UPDATE ecoregion2003.wso1 set ecoregion='North Atlantic moist mixed forests' where ecoregion IS NULL -- 1649 lignes 
     88    UPDATE ecoregion2003.wso1 set ecoregion='North Atlantic moist mixed forests' where ecoregion IS NULL -- 1649 lines 
    8989 
    9090 --Celtic broadleaf forests 
    … …  
    9595    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    9696 
    97     UPDATE ecoregion2003.wso1 set ecoregion='Celtic broadleaf forests' where ecoregion IS NULL -- 7186 lignes 
     97    UPDATE ecoregion2003.wso1 set ecoregion='Celtic broadleaf forests' where ecoregion IS NULL -- 7186 lines 
    9898 
    9999 --Corsican montane broadleaf and mixed forests 
    … …  
    104104    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    105105 
    106     UPDATE ecoregion2003.wso1 set ecoregion='Corsican montane broadleaf and mixed forests' where ecoregion IS NULL -- 2848 lignes 
     106    UPDATE ecoregion2003.wso1 set ecoregion='Corsican montane broadleaf and mixed forests' where ecoregion IS NULL -- 2848 lines 
    107107 
    108108 --Appenine deciduous montane forests 
    … …  
    113113    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    114114 
    115     UPDATE ecoregion2003.wso1 set ecoregion='Appenine deciduous montane forests' where ecoregion IS NULL -- 27 lignes 
     115    UPDATE ecoregion2003.wso1 set ecoregion='Appenine deciduous montane forests' where ecoregion IS NULL -- 27 lines 
    116116 
    117117 --Appenine deciduous montane forests 
    … …  
    122122    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    123123 
    124     UPDATE ecoregion2003.wso1 set ecoregion='Appenine deciduous montane forests' where ecoregion IS NULL -- 46 lignes 
     124    UPDATE ecoregion2003.wso1 set ecoregion='Appenine deciduous montane forests' where ecoregion IS NULL -- 46 lines 
    125125 
    126126 --Tyrrhenian-Adriatic sclerophyllous and mixed forests 
    … …  
    131131    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    132132 
    133     UPDATE ecoregion2003.wso1 set ecoregion='Tyrrhenian-Adriatic sclerophyllous and mixed forests' where ecoregion IS NULL -- 2079 lignes 
     133    UPDATE ecoregion2003.wso1 set ecoregion='Tyrrhenian-Adriatic sclerophyllous and mixed forests' where ecoregion IS NULL -- 2079 lines 
    134134 
    135135 --Pyrenees conifer and mixed forests 
    … …  
    140140    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    141141 
    142     UPDATE ecoregion2003.wso1 set ecoregion='Pyrenees conifer and mixed forests' where ecoregion IS NULL -- 15222 lignes 
     142    UPDATE ecoregion2003.wso1 set ecoregion='Pyrenees conifer and mixed forests' where ecoregion IS NULL -- 15222 lines 
    143143 
    144144 --Alps conifer and mixed forests 
    … …  
    149149    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    150150 
    151     UPDATE ecoregion2003.wso1 set ecoregion='Alps conifer and mixed forests' where ecoregion IS NULL -- 69641 lignes 
     151    UPDATE ecoregion2003.wso1 set ecoregion='Alps conifer and mixed forests' where ecoregion IS NULL -- 69641 lines 
    152152 
    153153 --Italian sclerophyllous and semi-deciduous forests 
    … …  
    158158    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    159159 
    160     UPDATE ecoregion2003.wso1 set ecoregion='Italian sclerophyllous and semi-deciduous forests' where ecoregion IS NULL -- 27451 lignes 
     160    UPDATE ecoregion2003.wso1 set ecoregion='Italian sclerophyllous and semi-deciduous forests' where ecoregion IS NULL -- 27451 lines 
    161161 
    162162 --Celtic broadleaf forests 
    … …  
    167167    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    168168 
    169     UPDATE ecoregion2003.wso1 set ecoregion='Celtic broadleaf forests' where ecoregion IS NULL -- 11407 lignes 
     169    UPDATE ecoregion2003.wso1 set ecoregion='Celtic broadleaf forests' where ecoregion IS NULL -- 11407 lines 
    170170 
    171171 --Tyrrhenian-Adriatic sclerophyllous and mixed forests 
    … …  
    176176    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    177177 
    178     UPDATE ecoregion2003.wso1 set ecoregion='Tyrrhenian-Adriatic sclerophyllous and mixed forests' where ecoregion IS NULL -- 3797 lignes 
     178    UPDATE ecoregion2003.wso1 set ecoregion='Tyrrhenian-Adriatic sclerophyllous and mixed forests' where ecoregion IS NULL -- 3797 lines 
    179179 
    180180 --English Lowlands beech forests 
    … …  
    185185    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    186186 
    187     UPDATE ecoregion2003.wso1 set ecoregion='English Lowlands beech forests' where ecoregion IS NULL -- 2822 lignes 
     187    UPDATE ecoregion2003.wso1 set ecoregion='English Lowlands beech forests' where ecoregion IS NULL -- 2822 lines 
    188188 
    189189 --Northen Temperate Atlantic 
    … …  
    194194    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    195195 
    196     UPDATE ecoregion2003.wso1 set ecoregion='Northen Temperate Atlantic' where ecoregion IS NULL -- 3878 lignes 
     196    UPDATE ecoregion2003.wso1 set ecoregion='Northen Temperate Atlantic' where ecoregion IS NULL -- 3878 lines 
    197197 
    198198 --Central European mixed forests 
    … …  
    203203    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    204204 
    205     UPDATE ecoregion2003.wso1 set ecoregion='Central European mixed forests' where ecoregion IS NULL -- 26863 lignes 
     205    UPDATE ecoregion2003.wso1 set ecoregion='Central European mixed forests' where ecoregion IS NULL -- 26863 lines 
    206206 
    207207 --Northen Temperate Atlantic 
    … …  
    212212    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    213213 
    214     UPDATE ecoregion2003.wso1 set ecoregion='Northen Temperate Atlantic' where ecoregion IS NULL -- 63 lignes 
     214    UPDATE ecoregion2003.wso1 set ecoregion='Northen Temperate Atlantic' where ecoregion IS NULL -- 63 lines 
    215215 
    216216 --Southern Temperate Atlantic 
    … …  
    221221    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    222222 
    223     UPDATE ecoregion2003.wso1 set ecoregion='Southern Temperate Atlantic' where ecoregion IS NULL -- 265 lignes 
     223    UPDATE ecoregion2003.wso1 set ecoregion='Southern Temperate Atlantic' where ecoregion IS NULL -- 265 lines 
    224224 
    225225}}}