Changes between Version 11 and Version 12 of CLC download and load


Ignore:
Timestamp:
May 27, 2010 1:29:11 PM (15 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • CLC download and load

    v11 v12  
    2424cd C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\CLC\CLC00_v2_Europe_mai_2010 
    2525 
    26 C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -c -g the_geom -I clc00_v2_code_521.shp clc00_v2_europe> clc00_v2_europe_521.sql 
    27 C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_522.shp clc00_v2_europe> clc00_v2_europe_522.sql 
    28 C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_111.shp clc00_v2_europe> clc00_v2_europe_111.sql 
    2926 
     27C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -c -g the_geom -I clc00_v2_code_111.shp clc00_v2_europe> clc00_v2_europe_111.sql 
    3028C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_112.shp clc00_v2_europe> clc00_v2_europe_112.sql 
     29 
    3130C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_121.shp clc00_v2_europe> clc00_v2_europe_121.sql 
     31C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_122.shp clc00_v2_europe> clc00_v2_europe_122.sql 
     32C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_123.shp clc00_v2_europe> clc00_v2_europe_123.sql 
     33C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_124.shp clc00_v2_europe> clc00_v2_europe_124.sql 
     34 
    3235C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_131.shp clc00_v2_europe> clc00_v2_europe_131.sql 
     36C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_132.shp clc00_v2_europe> clc00_v2_europe_132.sql 
     37C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_133.shp clc00_v2_europe> clc00_v2_europe_133.sql 
     38 
     39C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_141.shp clc00_v2_europe> clc00_v2_europe_141.sql 
    3340C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_142.shp clc00_v2_europe> clc00_v2_europe_142.sql 
     41 
    3442C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_211.shp clc00_v2_europe> clc00_v2_europe_211.sql 
    3543C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_212.shp clc00_v2_europe> clc00_v2_europe_212.sql 
    3644C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_213.shp clc00_v2_europe> clc00_v2_europe_213.sql 
     45 
    3746C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_221.shp clc00_v2_europe> clc00_v2_europe_221.sql 
     47C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_222.shp clc00_v2_europe> clc00_v2_europe_222.sql 
    3848C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_223.shp clc00_v2_europe> clc00_v2_europe_223.sql 
    3949C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_231.shp clc00_v2_europe> clc00_v2_europe_231.sql 
     50 
    4051C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_241.shp clc00_v2_europe> clc00_v2_europe_241.sql 
     52C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_242.shp clc00_v2_europe> clc00_v2_europe_242.sql 
     53C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_243.shp clc00_v2_europe> clc00_v2_europe_243.sql 
    4154C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_244.shp clc00_v2_europe> clc00_v2_europe_244.sql 
     55 
     56C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_311.shp clc00_v2_europe> clc00_v2_europe_311.sql 
     57C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_312.shp clc00_v2_europe> clc00_v2_europe_312.sql 
     58C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_313.shp clc00_v2_europe> clc00_v2_europe_313.sql 
     59 
     60C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_321.shp clc00_v2_europe> clc00_v2_europe_321.sql 
     61C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_322.shp clc00_v2_europe> clc00_v2_europe_322.sql 
     62C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_323.shp clc00_v2_europe> clc00_v2_europe_323.sql 
     63C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_324.shp clc00_v2_europe> clc00_v2_europe_324.sql 
     64 
     65C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_331.shp clc00_v2_europe> clc00_v2_europe_331.sql 
     66C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_332.shp clc00_v2_europe> clc00_v2_europe_332.sql 
     67C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_333.shp clc00_v2_europe> clc00_v2_europe_333.sql 
     68C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_334.shp clc00_v2_europe> clc00_v2_europe_334.sql 
     69C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_335.shp clc00_v2_europe> clc00_v2_europe_335.sql 
     70 
     71C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_411.shp clc00_v2_europe> clc00_v2_europe_411.sql 
     72C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_412.shp clc00_v2_europe> clc00_v2_europe_412.sql 
     73 
     74C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_411.shp clc00_v2_europe> clc00_v2_europe_421.sql 
     75C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_412.shp clc00_v2_europe> clc00_v2_europe_422.sql 
     76C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_423.shp clc00_v2_europe> clc00_v2_europe_423.sql 
     77 
     78C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_511.shp clc00_v2_europe> clc00_v2_europe_511.sql 
     79C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_512.shp clc00_v2_europe> clc00_v2_europe_512.sql 
     80 
     81C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_521.shp clc00_v2_europe> clc00_v2_europe_521.sql 
     82C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_522.shp clc00_v2_europe> clc00_v2_europe_522.sql 
     83C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 4326 -a -g the_geom clc00_v2_code_523.shp clc00_v2_europe> clc00_v2_europe_523.sql 
    4284}}} 
    4385 
    4486 
    4587{{{ 
     88C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_111.sql  
     89C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_112.sql  
     90  
     91C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_121.sql  
     92C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_122.sql  
     93C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_123.sql  
     94C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_124.sql  
     95 
     96C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_131.sql  
     97C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_132.sql  
     98C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_133.sql  
     99  
     100C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_141.sql  
     101C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_142.sql  
     102 
     103C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_211.sql  
     104C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_212.sql  
     105C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_213.sql  
     106 
     107C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_221.sql  
     108C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_222.sql  
     109C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_223.sql  
     110 
     111C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_231.sql  
     112 
     113C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_241.sql  
     114C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_242.sql  
     115C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_243.sql  
     116C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_244.sql  
     117 
     118C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_311.sql  
     119C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_312.sql  
     120C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_313.sql 
     121 
     122C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_321.sql 
     123C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_322.sql 
     124C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_323.sql 
     125C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_324.sql 
     126 
     127C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_331.sql 
     128C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_332.sql 
     129C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_333.sql 
     130C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_334.sql 
     131C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_335.sql 
     132 
     133C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_411.sql 
     134C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_412.sql 
     135C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_421.sql 
     136C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_422.sql 
     137C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_423.sql 
     138 
     139C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_511.sql 
     140C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_512.sql 
     141 
     142C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_521.sql 
     143C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_522.sql 
     144C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_523.sql 
     145 
    46146C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_521.sql 
    47147C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_522.sql   
    48 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -h localhost -U postgres -p 5433 -f clc00_v2_europe_111.sql   
     148 
    49149}}} 
    50150