Changes between Version 27 and Version 28 of Ecological region Download and load

Timestamp:

May 17, 2011 4:57:23 PM (14 years ago)

Author:

celine

Comment:

--

Ecological region Download and load

@@ -75 +75 @@
 [[Image(source:data/Docs/trac/Ecological regions/ecological regions.png,700px)]][[BR]]
 In blue : CCM, In red : Ecological regions
+
+Change the srid
+{{{
+--4326 into 3035
+ALTER TABLE dmeer2003.ecologicalregion_polygon DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE dmeer2003.ecologicalregion_polygon SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE dmeer2003.ecologicalregion_polygon ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+}}}