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

Timestamp:

Jul 8, 2010 4:54:47 PM (15 years ago)

Author:

celine

Comment:

--

Ecological region Download and load

@@ -32 +32 @@
 {{{
 --- In sql editor 
-CREATE SCHEMA ecologicalregion;
-ALTER TABLE ecologicalregion_arc SET SCHEMA ecologicalregion;
-ALTER TABLE ecologicalregion_label SET SCHEMA ecologicalregion;
-ALTER TABLE ecologicalregion_polygon SET SCHEMA ecologicalregion;
-ALTER TABLE ecologicalregion_tic SET SCHEMA ecologicalregion;
+CREATE SCHEMA dmeer;
+ALTER TABLE ecologicalregion_arc SET SCHEMA dmeer;
+ALTER TABLE ecologicalregion_label SET SCHEMA dmeer;
+ALTER TABLE ecologicalregion_polygon SET SCHEMA dmeer;
+ALTER TABLE ecologicalregion_tic SET SCHEMA dmeer;
 }}}
 
     * Changement du type de projection : RGF93_Lambert_93 (srid 2154) --> ETRS1989-LAEA (srid 3035)
 {{{
-ALTER TABLE uga2010.uga DROP CONSTRAINT enforce_srid_the_geom;
-UPDATE uga2010.uga SET the_geom = ST_transform(the_geom, 3035); 
-ALTER TABLE uga2010.uga ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 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);
 }}}