Changes between Version 43 and Version 44 of CookBook join Temperature_CCM

Timestamp:

Jun 16, 2010 4:06:13 PM (15 years ago)

Author:

celine

Comment:

--

CookBook join Temperature_CCM

@@ -20 +20 @@
 
 CREATE TABLE temperature.tmp_ccm as(
-SELECT  distinct on(gid) gid, gridid, sub.winter, sub.summer, min(distance) as distance, the_geom FROM (
-SELECT gridid,t.winter, t.summer,gid, CAST(distance(c.the_geom,t.the_geom) as decimal(15,1)) as distance, t.the_geom FROM temperature.tmp AS t
+SELECT  distinct on(gid) gid, gridid, sub.winter, sub.summer, sub.winter1977, min(distance) as distance, the_geom FROM (
+SELECT gridid,t.winter, t.summer, t.winter1977, gid, CAST(distance(c.the_geom,t.the_geom) as decimal(15,1)) as distance, t.the_geom FROM temperature.tmp AS t
 INNER JOIN ccm21.riversegments c ON ST_DWithin(c.the_geom,t.the_geom,70000)
 ) AS sub
-GROUP BY gid, distance, gridid, winter, summer,the_geom
+GROUP BY gid, distance, gridid, winter, summer,winter1977, the_geom
 );