Changes between Version 21 and Version 22 of Ecological region Download and load


Ignore:
Timestamp:
Jul 19, 2010 10:32:26 AM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Ecological region Download and load

    v21 v22  
    5050}}} 
    5151 
    52     * Changement du type de projection : LAEA (srid 2163) --> ETRS1989-LAEA (srid 3035) 
    53 {{{ 
    54 #!sql 
    55 ALTER TABLE dmeer2003.ecologicalregion_arc DROP CONSTRAINT enforce_srid_the_geom; 
    56 UPDATE dmeer2003.ecologicalregion_arc SET the_geom = ST_transform(the_geom, 3035);  
    57 ALTER TABLE dmeer2003.ecologicalregion_arc ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035); 
    58 ALTER TABLE dmeer2003.ecologicalregion_label DROP CONSTRAINT enforce_srid_the_geom; 
    59 UPDATE dmeer2003.ecologicalregion_label SET the_geom = ST_transform(the_geom, 3035);  
    60 ALTER TABLE dmeer2003.ecologicalregion_label ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035); 
    61 ALTER TABLE dmeer2003.ecologicalregion_polygon DROP CONSTRAINT enforce_srid_the_geom; 
    62 UPDATE dmeer2003.ecologicalregion_polygon SET the_geom = ST_transform(the_geom, 3035);  
    63 ALTER TABLE dmeer2003.ecologicalregion_tic ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035); 
    64 ALTER TABLE dmeer2003.ecologicalregion_tic DROP CONSTRAINT enforce_srid_the_geom; 
    65 UPDATE dmeer2003.ecologicalregion_polygon SET the_geom = ST_transform(the_geom, 3035);  
    66 ALTER TABLE dmeer2003.ecologicalregion_tic ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035); 
    67 }}}  
     52~~    * Changement du type de projection : LAEA (srid 2163) --> ETRS1989-LAEA (srid 3035) 
    6853 
    6954{{{ 
    7055#!sql 
     56INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type") 
     57SELECT '', 'dmeer2003', 'ecologicalregion_arc', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom) 
     58FROM dmeer2003.ecologicalregion_arc LIMIT 1; 
     59 
    7160INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type") 
    7261SELECT '', 'dmeer2003', 'ecologicalregion_label', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)