Changes between Version 34 and Version 35 of Cookbook CCM21_UGA
- Timestamp:
- Sep 3, 2010 4:56:22 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Cookbook CCM21_UGA
v34 v35 19 19 ON ST_Intersects(sub.singlegeom,r.the_geom); 20 20 21 UPDATE uga2010.wso set uga='Loire' where uga IS NULL -- 40 sea nodes21 UPDATE uga2010.wso set uga='Loire' where uga IS NULL --60 lignes 22 22 23 23 --Garonne … … 28 28 ON ST_Intersects(sub.singlegeom,r.the_geom); 29 29 30 UPDATE uga2010.wso set uga='Garonne' where uga IS NULL -- 60 sea nodes30 UPDATE uga2010.wso set uga='Garonne' where uga IS NULL --19 lignes 31 31 32 32 --Adour … … 37 37 ON ST_Intersects(sub.singlegeom,r.the_geom); 38 38 39 UPDATE uga2010.wso set uga='Adour' where uga IS NULL -- 19 sea nodes40 39 UPDATE uga2010.wso set uga='Adour' where uga IS NULL --26 lignes 40 41 41 --Artois-Picardie 42 42 insert into uga2010.wso(wso_id) … … 46 46 ON ST_Intersects(sub.singlegeom,r.the_geom); 47 47 48 UPDATE uga2010.wso set uga='ArtoisPicardie' where uga IS NULL -- 26 sea nodes48 UPDATE uga2010.wso set uga='ArtoisPicardie' where uga IS NULL --133 lignes 49 49 50 50 --Rhône-M‚diterranée … … 55 55 ON ST_Intersects(sub.singlegeom,r.the_geom); 56 56 57 UPDATE uga2010.wso set uga='RhoneMediterranee' where uga IS NULL --1 33 sea nodes57 UPDATE uga2010.wso set uga='RhoneMediterranee' where uga IS NULL --177 lignes 58 58 59 59 --Corse … … 64 64 ON ST_Intersects(sub.singlegeom,r.the_geom); 65 65 66 UPDATE uga2010.wso set uga='Corse' where uga IS NULL -- 177 sea nodes66 UPDATE uga2010.wso set uga='Corse' where uga IS NULL --89 lignes 67 67 68 68 --Seine-Normandie … … 73 73 ON ST_Intersects(sub.singlegeom,r.the_geom); 74 74 75 UPDATE uga2010.wso set uga='SeineNormandie' where uga IS NULL -- 89 sea nodes75 UPDATE uga2010.wso set uga='SeineNormandie' where uga IS NULL --166 lignes 76 76 77 77 --Bretagne … … 82 82 ON ST_Intersects(sub.singlegeom,r.the_geom); 83 83 84 UPDATE uga2010.wso set uga='Bretagne' where uga IS NULL -- 166 sea nodes84 UPDATE uga2010.wso set uga='Bretagne' where uga IS NULL --2 lignes 85 85 86 86 --Rhin … … 91 91 ON ST_Intersects(sub.singlegeom,r.the_geom); 92 92 93 UPDATE uga2010.wso set uga='Rhin' where uga IS NULL -- 2 sea nodes93 UPDATE uga2010.wso set uga='Rhin' where uga IS NULL --3 lignes 94 94 95 95 --Meuse … … 101 101 ON ST_Intersects(sub.singlegeom,r.the_geom); 102 102 103 UPDATE uga2010.wso set uga='Meuse' where uga IS NULL --3 sea nodes103 UPDATE uga2010.wso set uga='Meuse' where uga IS NULL --39 lignes 104 104 }}} 105 105
