Changes between Version 24 and Version 25 of Cookbook CCM21_Europe
- Timestamp:
- May 25, 2012 1:32:35 PM (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Cookbook CCM21_Europe
v24 v25 6 6 Pour la France mettre : France (gid=11)+Andorre (gid=2) +Monaco (gid=27) ?[[BR]] 7 7 {{{ 8 #!sql 8 9 create schema europe; 9 10 drop table if exists europe.wso; … … 93 94 94 95 {{{ 96 #!sql 95 97 ---Spain-Atl 96 98 insert into europe.wso(wso_id) … … 150 152 Comparaison europe.wso et rbd_f1v3.bassin_pose 151 153 {{{ 154 #!sql 152 155 select cum_len_sea, up_area, shree, scheid, distance_relative, c_area, distance_source, catchment_area from ccm21.riversegments r inner join europe.wso e on e.wso_id=r.wso_id where e.area='Sardinia' 153 156 select cum_len_sea, up_area, shree, scheid, distance_relative, c_area, distance_source, catchment_area from ccm21.riversegments r inner join rbd_f1v3.bassin_pose e on e.wso_id=r.wso_id where e.emu='Sardinia' … … 161 164 ---63 wso_id qui notés Anglian et UK dans europe.wso --> OK 162 165 {{{ 166 #!sql 163 167 select * from rbd_f1v3.bassin_pose b right join europe.wso w on b.wso_id=w.wso_id where emu='Anglian' and area='UK' 164 168 }}} … … 166 170 ---6 wso_id qui doivent être rajouté dans europe.wso pour l'Elbe 167 171 {{{ 172 #!sql 168 173 select * from rbd_f1v3.bassin_pose b right join europe.wso w on b.wso_id=w.wso_id where emu='Elbe' 169 174 }}} 170 175 {{{ 176 #!sql 171 177 insert into europe.wso(wso_id) values ('383'),('2005'),('8639'),('38619'),('38481'),('2020'); 172 178 UPDATE europe.wso set area='Elbe' where area IS NULL; … … 181 187 ||!SeineNormandie||7415||7413|| 182 188 {{{ 189 #!sql 183 190 select * from uga2010.wso b left join europe.wso w on b.wso_id=w.wso_id where uga='SeineNormandie' 184 191 select count(b.wso_id), b.wso_id from uga2010.wso b left join europe.wso w on b.wso_id=w.wso_id where uga='SeineNormandie' group by b.wso_id order by count(b.wso_id) … … 187 194 188 195 {{{ 196 #!sql 189 197 ---SeineNormandie 190 198 insert into europe.wso(wso_id) values ('332670'),('337665'),('342310'); … … 205 213 206 214 {{{ 215 #!sql 207 216 delete from europe.wso where wso_id='291126' and area='Spain'; 208 217 delete from europe.wso where wso_id='442494' and area='Spain';
