Changes between Version 34 and Version 35 of CookBook join Temperature_CCM

Timestamp:

May 21, 2010 10:58:56 AM (15 years ago)

Author:

cedric

Comment:

--

CookBook join Temperature_CCM

@@ -23 +23 @@
 GROUP BY gridid, distance, gid, winter, summer,the_geom
 ); 
+-- to extract only the min distance you need a join
 
+select * from(
+select min(distance),gid,pk from temperature.tmp_ccm
+group by distance, gid,pk) as sub1
+join temperature.tmp_ccm t on sub1.pk=t.pk;
+
+-- if no column in geometry column add it using
 INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
 SELECT '', 'temperature', 'tmp_ccm', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)