Changes between Version 1 and Version 2 of CookBook BDCarthage_UGA


Ignore:
Timestamp:
Oct 3, 2011 11:36:36 AM (14 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • TabularUnified CookBook BDCarthage_UGA

    v1 v2  
    1717    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    1818 
    19     UPDATE uga2010.id_bdcarthage set uga='Bretagne' where uga IS NULL -- 27250 lignes 
     19    UPDATE uga2010.id_bdcarthage set uga='Bretagne' where uga IS NULL -- 27250 lines 
    2020 
    2121 --Adour 
    … …  
    2626    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    2727 
    28     UPDATE uga2010.id_bdcarthage set uga='Adour' where uga IS NULL -- 27250 lignes 
     28    UPDATE uga2010.id_bdcarthage set uga='Adour' where uga IS NULL -- 23181 lines 
    2929 
    3030 --Garonne 
    … …  
    3535    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    3636 
    37     UPDATE uga2010.id_bdcarthage set uga='Garonne' where uga IS NULL -- 27250 lignes 
     37    UPDATE uga2010.id_bdcarthage set uga='Garonne' where uga IS NULL -- 92831 lines 
    3838 
    3939 --Loire 
    … …  
    4444    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    4545 
    46     UPDATE uga2010.id_bdcarthage set uga='Loire' where uga IS NULL -- 27250 lignes 
     46    UPDATE uga2010.id_bdcarthage set uga='Loire' where uga IS NULL -- 109437 lines 
    4747 
    4848 --Seine-Normandie 
    … …  
    5353    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    5454 
    55     UPDATE uga2010.id_bdcarthage set uga='Seine-Normandie' where uga IS NULL -- 27250 lignes 
     55    UPDATE uga2010.id_bdcarthage set uga='Seine-Normandie' where uga IS NULL -- 55365 lines 
    5656 
    5757 
    … …  
    6363    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    6464 
    65     UPDATE uga2010.id_bdcarthage set uga='Corse' where uga IS NULL -- 27250 lignes 
     65    UPDATE uga2010.id_bdcarthage set uga='Corse' where uga IS NULL -- 12594 lines 
    6666 
    6767 --Artois-Picardie 
    … …  
    7272    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    7373 
    74     UPDATE uga2010.id_bdcarthage set uga='Artois-Picardie' where uga IS NULL -- 27250 lignes 
     74    UPDATE uga2010.id_bdcarthage set uga='Artois-Picardie' where uga IS NULL -- 12040  lines 
    7575 
    7676 --Rhone-Mediterranee 
    … …  
    8181    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    8282 
    83     UPDATE uga2010.id_bdcarthage set uga='Rhone-Mediterranee' where uga IS NULL -- 27250 lignes 
     83    UPDATE uga2010.id_bdcarthage set uga='Rhone-Mediterranee' where uga IS NULL -- 147091 lines 
    8484 
    8585 --Rhin 
    … …  
    9090    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    9191 
    92     UPDATE uga2010.id_bdcarthage set uga='Rhin' where uga IS NULL -- 27250 lignes 
     92    UPDATE uga2010.id_bdcarthage set uga='Rhin' where uga IS NULL -- 24355 lines 
    9393 
    9494--Meuse 
    … …  
    9999    ON ST_Intersects(sub.singlegeom,r.the_geom); 
    100100 
    101     UPDATE uga2010.id_bdcarthage set uga='Meuse' where uga IS NULL -- 27250 lignes 
     101    UPDATE uga2010.id_bdcarthage set uga='Meuse' where uga IS NULL -- 5539 lines 
    102102}}}