Changes between Version 6 and Version 7 of Temperature download and load

Timestamp:

May 11, 2010 11:01:18 AM (15 years ago)

Author:

celine

Comment:

--

Temperature download and load

@@ -50 +50 @@
 == Create and Populate the geometry field ==
 The geometry field is populated using the Longitude and Latitude fields[[BR]]
-Problem : I haven't yet found the spatial reference (maybe the srid is : 4326 or 4269 or 3785 or 3395...)[[BR]]
+Problem : I haven't yet found the spatial reference (maybe the srid is : 4326 - WGS84)[[BR]]
    - '''Geometry for the temperature tmp'''
 {{{
-select AddGeometryColumn('temperature','tmp','the_geom',4269,'POINT',2);
+select AddGeometryColumn('temperature','tmp','the_geom',4326,'POINT',2);
 UPDATE temperature.tmp
-        SET the_geom = ST_SetSRID(ST_Point( longitude, latitude),4269);
+        SET the_geom = ST_SetSRID(ST_Point( longitude, latitude),4326);
 }}}
    - '''Geometry for the temperature tmx'''
 {{{
-select AddGeometryColumn('temperature','tmx','the_geom',4269,'POINT',2);
+select AddGeometryColumn('temperature','tmx','the_geom',4326,'POINT',2);
 UPDATE temperature.tmx
-        SET the_geom = ST_SetSRID(ST_Point( longitude, latitude),4269);
+        SET the_geom = ST_SetSRID(ST_Point( longitude, latitude),4326);
 }}}
    - '''Geometry for the temperature tmn'''
 {{{
-select AddGeometryColumn('temperature','tmn','the_geom',4269,'POINT',2);
+select AddGeometryColumn('temperature','tmn','the_geom',4326,'POINT',2);
 UPDATE temperature.tmn
-        SET the_geom = ST_SetSRID(ST_Point( longitude, latitude),4269);
+        SET the_geom = ST_SetSRID(ST_Point( longitude, latitude),4326);
 }}}