Changes between Version 36 and Version 37 of CookBook join Temperature_CCM

Timestamp:

May 21, 2010 11:11:20 AM (15 years ago)

Author:

cedric

Comment:

--

CookBook join Temperature_CCM

@@ -29 +29 @@
 group by distance, gid,pk) as sub1
 join temperature.tmp_ccm t on sub1.pk=t.pk;
+
+-- final query used in R (loaddb method for riversegmentstemp)
+
+SELECT j.gid, j.winter, j.summer FROM( SELECT min(distance), gid, pk FROM temperature.tmp_ccm group by distance, gid, pk) as sub1  
+JOIN temperature.tmp_ccm j ON sub1.pk=j.pk  
+RIGHT JOIN ccm21.riversegments r ON r.gid=j.gid 
+where wso_id in (select wso_id from france.wso where area='France') 
+  ORDER BY r.gid ;
 
 -- if no column in geometry column add it using