Changes between Version 4 and Version 5 of Ecological region Download and load


Ignore:
Timestamp:
Jul 8, 2010 5:07:49 PM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Ecological region Download and load

    v4 v5  
    44= Download and load = 
    55Digital map of European ecological regions : http://www.eea.europa.eu/data-and-maps/data/digital-map-of-european-ecological-regions 
     6version 2003 
    67 
    78Projection in Lambert Azimuthal Equal Area (LAEA) srid=2163 --> transformed into ETRS LAEA srid=3035[[BR]] 
    … …  
    1011D: 
    1112CD D:\Celine Jouanin\Ecological regions 
    12 C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_arc dmeereea4074i_arc > ecologicalregion_arc.sql 
    13 C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_label dmeereea4074i_label > ecologicalregion_label.sql 
    14 C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_polygon dmeereea4074i_polygon > ecologicalregion_polygon.sql 
    15 C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_tic dmeereea4074i_tic > ecologicalregion_tic.sql 
     13C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_arc ecologicalregion_arc > ecologicalregion_arc.sql 
     14C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_label ecologicalregion_label > ecologicalregion_label.sql 
     15C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_polygon ecologicalregion_polygon > ecologicalregion_polygon.sql 
     16C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 2163 -W LATIN1 dmeereea4074i_tic ecologicalregion_tic > ecologicalregion_tic.sql 
    1617}}} 
    1718 
    … …  
    2930}}} 
    3031 
    31     * Create schema ecologicalregion et changement de schéma des tables (qui sont sous public) 
     32    * Create schema dmeer2003 et changement de schéma des tables (qui sont sous public) 
    3233{{{ 
    3334--- In sql editor  
    34 CREATE SCHEMA dmeer; 
    35 ALTER TABLE ecologicalregion_arc SET SCHEMA dmeer; 
    36 ALTER TABLE ecologicalregion_label SET SCHEMA dmeer; 
    37 ALTER TABLE ecologicalregion_polygon SET SCHEMA dmeer; 
    38 ALTER TABLE ecologicalregion_tic SET SCHEMA dmeer; 
     35CREATE SCHEMA dmeer2003; 
     36ALTER TABLE ecologicalregion_arc SET SCHEMA dmeer2003; 
     37ALTER TABLE ecologicalregion_label SET SCHEMA dmeer2003; 
     38ALTER TABLE ecologicalregion_polygon SET SCHEMA dmeer2003; 
     39ALTER TABLE ecologicalregion_tic SET SCHEMA dmeer2003; 
    3940}}} 
    4041 
    4142    * Changement du type de projection : LAEA (srid 2163) --> ETRS1989-LAEA (srid 3035) 
    4243{{{ 
    43 ALTER TABLE dmeer.ecologicalregion_arc DROP CONSTRAINT enforce_srid_the_geom; 
    44 UPDATE dmeer.ecologicalregion_arc SET the_geom = ST_transform(the_geom, 3035);  
    45 ALTER TABLE dmeer.ecologicalregion_arc ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035); 
    46 ALTER TABLE dmeer.ecologicalregion_label DROP CONSTRAINT enforce_srid_the_geom; 
    47 UPDATE dmeer.ecologicalregion_label SET the_geom = ST_transform(the_geom, 3035);  
    48 ALTER TABLE dmeer.ecologicalregion_label ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035); 
    49 ALTER TABLE dmeer.ecologicalregion_polygon DROP CONSTRAINT enforce_srid_the_geom; 
    50 UPDATE dmeer.ecologicalregion_polygon SET the_geom = ST_transform(the_geom, 3035);  
    51 ALTER TABLE dmeer.ecologicalregion_tic ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035); 
    52 ALTER TABLE dmeer.ecologicalregion_tic DROP CONSTRAINT enforce_srid_the_geom; 
    53 UPDATE dmeer.ecologicalregion_polygon SET the_geom = ST_transform(the_geom, 3035);  
    54 ALTER TABLE dmeer.ecologicalregion_tic ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035); 
     44ALTER TABLE dmeer2003.ecologicalregion_arc DROP CONSTRAINT enforce_srid_the_geom; 
     45UPDATE dmeer2003.ecologicalregion_arc SET the_geom = ST_transform(the_geom, 3035);  
     46ALTER TABLE dmeer2003.ecologicalregion_arc ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035); 
     47ALTER TABLE dmeer2003.ecologicalregion_label DROP CONSTRAINT enforce_srid_the_geom; 
     48UPDATE dmeer2003.ecologicalregion_label SET the_geom = ST_transform(the_geom, 3035);  
     49ALTER TABLE dmeer2003.ecologicalregion_label ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035); 
     50ALTER TABLE dmeer2003.ecologicalregion_polygon DROP CONSTRAINT enforce_srid_the_geom; 
     51UPDATE dmeer2003.ecologicalregion_polygon SET the_geom = ST_transform(the_geom, 3035);  
     52ALTER TABLE dmeer2003.ecologicalregion_tic ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035); 
     53ALTER TABLE dmeer2003.ecologicalregion_tic DROP CONSTRAINT enforce_srid_the_geom; 
     54UPDATE dmeer2003.ecologicalregion_polygon SET the_geom = ST_transform(the_geom, 3035);  
     55ALTER TABLE dmeer2003.ecologicalregion_tic ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035); 
    5556}}}