Changes between Version 9 and Version 10 of Cookbook CCM21_EcologicalRegion
- Timestamp:
- May 18, 2011 11:23:09 AM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Cookbook CCM21_EcologicalRegion
v9 v10 65 65 ON ST_Intersects(sub.singlegeom,r.the_geom); 66 66 67 UPDATE ecoregion2003.wso1 set ecoregion='Cantabrian mixed forests' where ecoregion IS NULL -- lignes67 UPDATE ecoregion2003.wso1 set ecoregion='Cantabrian mixed forests' where ecoregion IS NULL -- 26327 lignes 68 68 69 69 --North Atlantic moist mixed forests … … 74 74 ON ST_Intersects(sub.singlegeom,r.the_geom); 75 75 76 UPDATE ecoregion2003.wso1 set ecoregion='North Atlantic moist mixed forests' where ecoregion IS NULL -- lignes76 UPDATE ecoregion2003.wso1 set ecoregion='North Atlantic moist mixed forests' where ecoregion IS NULL -- 1649 lignes 77 77 78 78 --Celtic broadleaf forests … … 83 83 ON ST_Intersects(sub.singlegeom,r.the_geom); 84 84 85 UPDATE ecoregion2003.wso1 set ecoregion='Celtic broadleaf forests' where ecoregion IS NULL -- lignes85 UPDATE ecoregion2003.wso1 set ecoregion='Celtic broadleaf forests' where ecoregion IS NULL -- 7186 lignes 86 86 87 87 --Corsican montane broadleaf and mixed forests … … 92 92 ON ST_Intersects(sub.singlegeom,r.the_geom); 93 93 94 UPDATE ecoregion2003.wso1 set ecoregion='Corsican montane broadleaf and mixed forests' where ecoregion IS NULL -- lignes94 UPDATE ecoregion2003.wso1 set ecoregion='Corsican montane broadleaf and mixed forests' where ecoregion IS NULL -- 2848 lignes 95 95 96 96 --Appenine deciduous montane forests … … 101 101 ON ST_Intersects(sub.singlegeom,r.the_geom); 102 102 103 UPDATE ecoregion2003.wso1 set ecoregion='Appenine deciduous montane forests' where ecoregion IS NULL -- lignes103 UPDATE ecoregion2003.wso1 set ecoregion='Appenine deciduous montane forests' where ecoregion IS NULL -- 27 lignes 104 104 105 105 --Appenine deciduous montane forests … … 110 110 ON ST_Intersects(sub.singlegeom,r.the_geom); 111 111 112 UPDATE ecoregion2003.wso1 set ecoregion='Appenine deciduous montane forests' where ecoregion IS NULL -- lignes112 UPDATE ecoregion2003.wso1 set ecoregion='Appenine deciduous montane forests' where ecoregion IS NULL -- 46 lignes 113 113 114 114 --Tyrrhenian-Adriatic sclerophyllous and mixed forests … … 119 119 ON ST_Intersects(sub.singlegeom,r.the_geom); 120 120 121 UPDATE ecoregion2003.wso1 set ecoregion='Tyrrhenian-Adriatic sclerophyllous and mixed forests' where ecoregion IS NULL -- lignes121 UPDATE ecoregion2003.wso1 set ecoregion='Tyrrhenian-Adriatic sclerophyllous and mixed forests' where ecoregion IS NULL -- 2079 lignes 122 122 123 123 --Pyrenees conifer and mixed forests … … 128 128 ON ST_Intersects(sub.singlegeom,r.the_geom); 129 129 130 UPDATE ecoregion2003.wso1 set ecoregion='Pyrenees conifer and mixed forests' where ecoregion IS NULL -- lignes130 UPDATE ecoregion2003.wso1 set ecoregion='Pyrenees conifer and mixed forests' where ecoregion IS NULL -- 15222 lignes 131 131 132 132 --Alps conifer and mixed forests … … 137 137 ON ST_Intersects(sub.singlegeom,r.the_geom); 138 138 139 UPDATE ecoregion2003.wso1 set ecoregion='Alps conifer and mixed forests' where ecoregion IS NULL -- lignes139 UPDATE ecoregion2003.wso1 set ecoregion='Alps conifer and mixed forests' where ecoregion IS NULL -- 69641 lignes 140 140 141 141 --Italian sclerophyllous and semi-deciduous forests … … 146 146 ON ST_Intersects(sub.singlegeom,r.the_geom); 147 147 148 UPDATE ecoregion2003.wso1 set ecoregion='Italian sclerophyllous and semi-deciduous forests' where ecoregion IS NULL -- lignes148 UPDATE ecoregion2003.wso1 set ecoregion='Italian sclerophyllous and semi-deciduous forests' where ecoregion IS NULL -- 27451 lignes 149 149 }}}
