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

Timestamp:

Jul 8, 2010 4:56:42 PM (15 years ago)

Author:

celine

Comment:

--

Ecological region Download and load

@@ -39 +39 @@
 }}}
 
-    * Changement du type de projection : RGF93_Lambert_93 (srid 2154) --> ETRS1989-LAEA (srid 3035)
+    * Changement du type de projection : LAEA (srid 2163) --> ETRS1989-LAEA (srid 3035)
 {{{
 ALTER TABLE dmeer.ecologicalregion_arc DROP CONSTRAINT enforce_srid_the_geom;
 UPDATE dmeer.ecologicalregion_arc SET the_geom = ST_transform(the_geom, 3035); 
 ALTER TABLE dmeer.ecologicalregion_arc ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+ALTER TABLE dmeer.ecologicalregion_label DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE dmeer.ecologicalregion_label SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE dmeer.ecologicalregion_label ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+ALTER TABLE dmeer.ecologicalregion_polygon DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE dmeer.ecologicalregion_polygon SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE dmeer.ecologicalregion_tic ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+ALTER TABLE dmeer.ecologicalregion_tic DROP CONSTRAINT enforce_srid_the_geom;
+UPDATE dmeer.ecologicalregion_polygon SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE dmeer.ecologicalregion_tic ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
 }}}