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

Timestamp:

May 11, 2010 3:00:17 PM (15 years ago)

Author:

celine

Comment:

--

Temperature download and load

@@ -95 +95 @@
 UPDATE temperature.tmn SET the_geom = transform(setsrid(makepoint(longitude, latitude),4326), 3035);
 }}}
+
+== Create a GIST index to increase a query speed ==
+   - ''' Transform geometry for the temperature tmp'''
+{{{
+CREATE INDEX indextmp ON temperature.tmp
+  USING GIST ( the_geom GIST_GEOMETRY_OPS );
+}}}
+
+   - ''' Transform geometry for the temperature tmx'''
+{{{
+CREATE INDEX indextmx ON temperature.tmx
+  USING GIST ( the_geom GIST_GEOMETRY_OPS );
+}}}
+
+   - ''' Transform geometry for the temperature tmn'''
+{{{
+CREATE INDEX indextmn ON temperature.tmn
+  USING GIST ( the_geom GIST_GEOMETRY_OPS );
+}}}