Changes between Version 8 and Version 9 of Cookbook CCM21_Region


Ignore:
Timestamp:
Sep 4, 2010 1:45:50 PM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Cookbook CCM21_Region

    v8 v9  
    33 
    44 
    5 {{{ 
     5 
    66drop table  if exists france.wsoreg; 
    77 CREATE TABLE france.wsoreg ( 
    … …  
    1616join (SELECT the_geom 
    1717    FROM france.region where code_reg='11') as sub 
    18 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     18ON ST_Contains(sub.the_geom,r.the_geom); --1 lines 
    1919 
    2020UPDATE france.wsoreg set area='IleDeFrance' where area IS NULL 
    … …  
    2525join (SELECT the_geom 
    2626    FROM france.region where code_reg='21') as sub 
    27 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     27ON ST_Contains(sub.the_geom,r.the_geom); --3 lines 
    2828 
    2929UPDATE france.wsoreg set area='ChampagneArdenne' where area IS NULL 
    … …  
    3434join (SELECT the_geom 
    3535    FROM france.region where code_reg='22') as sub 
    36 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     36ON ST_Contains(sub.the_geom,r.the_geom); --11 lines 
    3737 
    3838UPDATE france.wsoreg set area='Picardie' where area IS NULL 
    … …  
    4343join (SELECT the_geom 
    4444    FROM france.region where code_reg='23') as sub 
    45 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     45ON ST_Contains(sub.the_geom,r.the_geom); --23 lines 
    4646 
    4747UPDATE france.wsoreg set area='HauteNormandie' where area IS NULL 
    … …  
    5252join (SELECT the_geom 
    5353    FROM france.region where code_reg='24') as sub 
    54 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     54ON ST_Contains(sub.the_geom,r.the_geom); --2 lines 
    5555 
    5656UPDATE france.wsoreg set area='Centre' where area IS NULL 
    … …  
    6161join (SELECT the_geom 
    6262    FROM france.region where code_reg='25') as sub 
    63 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     63ON ST_Contains(sub.the_geom,r.the_geom); --60 lines 
    6464 
    6565UPDATE france.wsoreg set area='BasseNormandie' where area IS NULL 
    … …  
    7070join (SELECT the_geom 
    7171    FROM france.region where code_reg='26') as sub 
    72 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     72ON ST_Contains(sub.the_geom,r.the_geom); --3 lines 
    7373 
    7474UPDATE france.wsoreg set area='Bourgogne' where area IS NULL 
    … …  
    7979join (SELECT the_geom 
    8080    FROM france.region where code_reg='31') as sub 
    81 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     81ON ST_Contains(sub.the_geom,r.the_geom); --19 lines 
    8282 
    8383UPDATE france.wsoreg set area='NordPasdeCalais' where area IS NULL 
    … …  
    8888join (SELECT the_geom 
    8989    FROM france.region where code_reg='41') as sub 
    90 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     90ON ST_Contains(sub.the_geom,r.the_geom); --8 lines 
    9191 
    9292UPDATE france.wsoreg set area='Lorraine' where area IS NULL 
    … …  
    9898join (SELECT the_geom 
    9999    FROM france.region where code_reg='42') as sub 
    100 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     100ON ST_Contains(sub.the_geom,r.the_geom); --2 lines 
    101101 
    102102UPDATE france.wsoreg set area='Alsace' where area IS NULL 
    … …  
    107107join (SELECT the_geom 
    108108    FROM france.region where code_reg='43') as sub 
    109 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     109ON ST_Contains(sub.the_geom,r.the_geom); --2 lines 
    110110 
    111111UPDATE france.wsoreg set area='FrancheComte' where area IS NULL 
    … …  
    116116join (SELECT the_geom 
    117117    FROM france.region where code_reg='52') as sub 
    118 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     118ON ST_Contains(sub.the_geom,r.the_geom); --34 lines 
    119119 
    120120UPDATE france.wsoreg set area='PaysdelaLoire' where area IS NULL 
    … …  
    125125join (SELECT the_geom 
    126126    FROM france.region where code_reg='53') as sub 
    127 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     127ON ST_Contains(sub.the_geom,r.the_geom); --139 lines 
    128128 
    129129UPDATE france.wsoreg set area='Bretagne' where area IS NULL 
    … …  
    134134join (SELECT the_geom 
    135135    FROM france.region where code_reg='54') as sub 
    136 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     136ON ST_Contains(sub.the_geom,r.the_geom); --27 lines 
    137137 
    138138UPDATE france.wsoreg set area='PoitouCharentes' where area IS NULL 
    … …  
    143143join (SELECT the_geom 
    144144    FROM france.region where code_reg='72') as sub 
    145 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     145ON ST_Contains(sub.the_geom,r.the_geom); --49 lines 
    146146 
    147147UPDATE france.wsoreg set area='Aquitaine' where area IS NULL 
    … …  
    152152join (SELECT the_geom 
    153153    FROM france.region where code_reg='73') as sub 
    154 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     154ON ST_Contains(sub.the_geom,r.the_geom); --6 lines 
    155155 
    156156UPDATE france.wsoreg set area='MidiPyrenees' where area IS NULL 
    … …  
    161161join (SELECT the_geom 
    162162    FROM france.region where code_reg='74') as sub 
    163 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     163ON ST_Contains(sub.the_geom,r.the_geom); --3 lines 
    164164 
    165165UPDATE france.wsoreg set area='Limousin' where area IS NULL 
    … …  
    170170join (SELECT the_geom 
    171171    FROM france.region where code_reg='82') as sub 
    172 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     172ON ST_Contains(sub.the_geom,r.the_geom); --3 lines 
    173173 
    174174UPDATE france.wsoreg set area='RhoneAlpes' where area IS NULL 
    … …  
    179179join (SELECT the_geom 
    180180    FROM france.region where code_reg='83') as sub 
    181 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     181ON ST_Contains(sub.the_geom,r.the_geom); --4 lines 
    182182 
    183183UPDATE france.wsoreg set area='Auvergne' where area IS NULL 
    … …  
    188188join (SELECT the_geom 
    189189    FROM france.region where code_reg='91') as sub 
    190 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     190ON ST_Contains(sub.the_geom,r.the_geom); --58 lines 
    191191 
    192192UPDATE france.wsoreg set area='Languedoc-Roussillon' where area IS NULL 
    … …  
    197197join (SELECT the_geom 
    198198    FROM france.region where code_reg='93') as sub 
    199 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     199ON ST_Contains(sub.the_geom,r.the_geom); --71 lines 
    200200 
    201201UPDATE france.wsoreg set area='PACA' where area IS NULL 
    … …  
    206206join (SELECT the_geom 
    207207    FROM france.region where code_reg='94') as sub 
    208 ON ST_Contains(sub.the_geom,r.the_geom); --170703 lines 
     208ON ST_Contains(sub.the_geom,r.the_geom); --175 lines 
    209209 
    210210UPDATE france.wsoreg set area='Corse' where area IS NULL 
    211211}}} 
    212212 
    213 Et c'est qu'une fois fini que tu te rends compte qu'il y avait un moyen plus rapide[[BR]] 
    214213 
    215214Certains riversegments n'ont pas été affectés à des régions