Changes between Version 41 and Version 42 of CookBook join Temperature_CCM

Timestamp:

Jun 15, 2010 3:50:08 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook join Temperature_CCM

@@ -17 +17 @@
 
 CREATE TABLE temperature.tmp_ccm as(
-SELECT  distinct on(gid) gid, gridid, winter, summer, min(distance) as distance, the_geom FROM (
-SELECT gridid, winter, 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, 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
 INNER JOIN ccm21.riversegments c ON ST_DWithin(c.the_geom,t.the_geom,70000)
 ) AS sub