Changes between Version 15 and Version 16 of CookBook RHT_UGA


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

--

Legend:

Unmodified
Added
Removed
Modified

  • CookBook RHT_UGA

    v15 v16  
    2323    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    2424 
    25     UPDATE uga2010.id_drain set uga='Bretagne' where uga IS NULL --6468 lignes 
     25    UPDATE uga2010.id_drain set uga='Bretagne' where uga IS NULL --6468 lines 
    2626 
    2727 
    … …  
    3333    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    3434 
    35     UPDATE uga2010.id_drain set uga='Loire' where uga IS NULL --27746 lignes 
     35    UPDATE uga2010.id_drain set uga='Loire' where uga IS NULL --27746 lines 
    3636 
    3737 --Garonne 
    … …  
    4242    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    4343 
    44     UPDATE uga2010.id_drain set uga='Garonne' where uga IS NULL --19651 lignes 
     44    UPDATE uga2010.id_drain set uga='Garonne' where uga IS NULL --19651 lines 
    4545 
    4646 
    … …  
    5252    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    5353 
    54     UPDATE uga2010.id_drain set uga='Adour' where uga IS NULL --3891 lignes 
     54    UPDATE uga2010.id_drain set uga='Adour' where uga IS NULL --3891 lines 
    5555 
    5656 --Artois-Picardie 
    … …  
    6161    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    6262 
    63     UPDATE uga2010.id_drain set uga='Artois-Picardie' where uga IS NULL --4061 lignes 
     63    UPDATE uga2010.id_drain set uga='Artois-Picardie' where uga IS NULL --4061 lines 
    6464 
    6565 --Rhône-Méditerranée 
    … …  
    7070    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    7171 
    72     UPDATE uga2010.id_drain set uga='RhoneMediterranee' where uga IS NULL --24999 lignes 
     72    UPDATE uga2010.id_drain set uga='RhoneMediterranee' where uga IS NULL --24999 lines 
    7373 
    7474 --Corse 
    … …  
    7979    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    8080 
    81     UPDATE uga2010.id_drain set uga='Corse' where uga IS NULL --1772 lignes 
     81    UPDATE uga2010.id_drain set uga='Corse' where uga IS NULL --1772 lines 
    8282 
    8383 
    … …  
    8989    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    9090 
    91     UPDATE uga2010.id_drain set uga='Seine-Normandie' where uga IS NULL --19525 lignes 
     91    UPDATE uga2010.id_drain set uga='Seine-Normandie' where uga IS NULL --19525 lines 
    9292 
    9393 --Rhin 
    … …  
    9898    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    9999 
    100     UPDATE uga2010.id_drain set uga='Rhin' where uga IS NULL --4773 lignes 
     100    UPDATE uga2010.id_drain set uga='Rhin' where uga IS NULL --4773 lines 
    101101 
    102102 --Meuse 
    … …  
    107107    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    108108 
    109     UPDATE uga2010.id_drain set uga='Meuse' where uga IS NULL --1630 lignes 
     109    UPDATE uga2010.id_drain set uga='Meuse' where uga IS NULL --1630 lines 
    110110 
    111111CREATE INDEX indexugaid_drain 
    … …  
    116116{{{ 
    117117#!sql 
    118 insert into uga2010.id_drain(gid,id_drain,uga) values ('3067','3224','Rhone-Mediterranee'),('11638','11467','Rhone-Mediterranee'),('22455','22419','Rhone-Mediterranee'),('24629','24470','Corse'),('26919','26772','Corse'),('71671','501772','Rhin');   -- 6 lignes 
     118insert into uga2010.id_drain(gid,id_drain,uga) values ('3067','3224','Rhone-Mediterranee'),('11638','11467','Rhone-Mediterranee'),('22455','22419','Rhone-Mediterranee'),('24629','24470','Corse'),('26919','26772','Corse'),('71671','501772','Rhin');   -- 6 lines 
    119119insert into uga2010.id_drain(gid,id_drain) values ('51479','301049'),('53501','303129'),('53521','303155'),('53471','303111'),('53481','303125'),('53531','303174'),('53571','303204'),('53695','303128'),('53710','303381'),('54108','303716'),('55321','304896'),('56267','305902'),('56268','305940'),('57509','307077'),('57623','307258'),('57860','307371'),('61605','311335'),('61606','311248'),('61639','311340'),('61759','311471'),('61766','311476'),('61767','311394'),('61885','311500'),('61904','311604'),('61922','311676'),('61924','311490'),('61925','311640'),('61939','311667'); 
    120 UPDATE uga2010.id_drain set uga='Seine-Normandie' where uga IS NULL; --28 lignes 
    121  
    122 delete from uga2010.id_drain where id_drain in ('30032','30036','30035','30040','6019','5959','2246');  -- 7 lignes 
     120UPDATE uga2010.id_drain set uga='Seine-Normandie' where uga IS NULL; --28 lines 
     121 
     122delete from uga2010.id_drain where id_drain in ('30032','30036','30035','30040','6019','5959','2246');  -- 7 lines 
    123123 
    124124alter table uga2010.id_drain rename to id_drain_uga