Changes between Version 51 and Version 52 of Cookbook CCM21_UGA
- Timestamp:
- Oct 3, 2012 4:48:17 PM (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Cookbook CCM21_UGA
v51 v52 22 22 ON ST_Intersects(sub.singlegeom,r.the_geom); 23 23 24 UPDATE uga2010.wso set uga='Bretagne' where uga IS NULL --166 li gnes24 UPDATE uga2010.wso set uga='Bretagne' where uga IS NULL --166 lines 25 25 26 26 --Loire … … 31 31 ON ST_Intersects(sub.singlegeom,r.the_geom); 32 32 33 UPDATE uga2010.wso set uga='Loire' where uga IS NULL; -- 39 li gnes33 UPDATE uga2010.wso set uga='Loire' where uga IS NULL; -- 39 lines 34 34 35 35 --Garonne … … 40 40 ON ST_Intersects(sub.singlegeom,r.the_geom); 41 41 42 UPDATE uga2010.wso set uga='Garonne' where uga IS NULL; --60 li gnes42 UPDATE uga2010.wso set uga='Garonne' where uga IS NULL; --60 lines 43 43 44 44 --Adour … … 49 49 ON ST_Intersects(sub.singlegeom,r.the_geom); 50 50 51 UPDATE uga2010.wso set uga='Adour' where uga IS NULL; --19 li gnes51 UPDATE uga2010.wso set uga='Adour' where uga IS NULL; --19 lines 52 52 53 53 --Artois-Picardie … … 58 58 ON ST_Intersects(sub.singlegeom,r.the_geom); 59 59 60 UPDATE uga2010.wso set uga='ArtoisPicardie' where uga IS NULL; --26 li gnes60 UPDATE uga2010.wso set uga='ArtoisPicardie' where uga IS NULL; --26 lines 61 61 62 62 --Rhône-Méditerranée … … 67 67 ON ST_Intersects(sub.singlegeom,r.the_geom); 68 68 69 UPDATE uga2010.wso set uga='RhoneMediterranee' where uga IS NULL; --133 li gnes69 UPDATE uga2010.wso set uga='RhoneMediterranee' where uga IS NULL; --133 lines 70 70 71 71 --Corse … … 76 76 ON ST_Intersects(sub.singlegeom,r.the_geom); 77 77 78 UPDATE uga2010.wso set uga='Corse' where uga IS NULL; --177 li gnes78 UPDATE uga2010.wso set uga='Corse' where uga IS NULL; --177 lines 79 79 80 80 --Seine-Normandie … … 85 85 ON ST_Intersects(sub.singlegeom,r.the_geom); 86 86 87 UPDATE uga2010.wso set uga='SeineNormandie' where uga IS NULL;--89 li gnes87 UPDATE uga2010.wso set uga='SeineNormandie' where uga IS NULL;--89 lines 88 88 89 89 --Rhin … … 94 94 ON ST_Intersects(sub.singlegeom,r.the_geom); 95 95 96 UPDATE uga2010.wso set uga='Rhin' where uga IS NULL; --2 li gnes96 UPDATE uga2010.wso set uga='Rhin' where uga IS NULL; --2 lines 97 97 98 98 --Meuse … … 104 104 ON ST_Intersects(sub.singlegeom,r.the_geom); 105 105 106 UPDATE uga2010.wso set uga='Meuse' where uga IS NULL; --3 li gnes106 UPDATE uga2010.wso set uga='Meuse' where uga IS NULL; --3 lines 107 107 }}} 108 108