Changes between Version 15 and Version 16 of Ecological region Download and load

Timestamp:

Jul 10, 2010 8:37:30 AM (15 years ago)

Author:

cedric

Comment:

--

Ecological region Download and load

@@ -48 +48 @@
     * Changement du type de projection : LAEA (srid 2163) --> ETRS1989-LAEA (srid 3035)
 {{{
+#!sql
 ALTER TABLE dmeer2003.ecologicalregion_arc DROP CONSTRAINT enforce_srid_the_geom;
 UPDATE dmeer2003.ecologicalregion_arc SET the_geom = ST_transform(the_geom, 3035); 
@@ -64 +65 @@
 {{{
 #!sql
-
-
 INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
 SELECT '', 'dmeer2003', 'ecologicalregion_label', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)