Changes between Version 10 and Version 11 of Temperature download and load

Timestamp:

May 11, 2010 2:53:36 PM (15 years ago)

Author:

celine

Comment:

--

Temperature download and load

@@ -77 +77 @@
 == Transforming to Another spatial reference system ==
    - ''' Transform geometry for the temperature tmp'''
+{{{
+ALTER TABLE temperature.tmp DROP COLUMN the_geom CASCADE;
+SELECT AddGeometryColumn('temperature','tmp','the_geom',3035,'POINT',2);
+UPDATE temperature.tmp SET the_geom = transform(setsrid(makepoint(longitude, latitude),4326), 3035);
+}}}
 
    - ''' Transform geometry for the temperature tmx'''
-
+{{{
+ALTER TABLE temperature.tmx DROP COLUMN the_geom CASCADE;
+SELECT AddGeometryColumn('temperature','tmx','the_geom',3035,'POINT',2);
+UPDATE temperature.tmx SET the_geom = transform(setsrid(makepoint(longitude, latitude),4326), 3035);
+}}}
    - ''' Transform geometry for the temperature tmn'''
-
-
-
+{{{
+ALTER TABLE temperature.tmn DROP COLUMN the_geom CASCADE;
+SELECT AddGeometryColumn('temperature','tmn','the_geom',3035,'POINT',2);
+UPDATE temperature.tmn SET the_geom = transform(setsrid(makepoint(longitude, latitude),4326), 3035);
+}}}