Changes between Version 3 and Version 4 of CookBook join Temperature_CCM


Ignore:
Timestamp:
May 11, 2010 5:23:16 PM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • CookBook join Temperature_CCM

    v3 v4  
    1010{{{ 
    1111DROP TABLE IF EXISTS temperature.tmp_ccm; 
     12 
    1213CREATE TABLE temperature.tmp_ccm as( 
    1314SELECT gridid, gid, min(distance) as distance, the_geom FROM ( 
     
    3132{{{ 
    3233DROP TABLE IF EXISTS temperature.tmx_ccm; 
     34 
    3335CREATE TABLE temperature.tmx_ccm as( 
    3436SELECT gridid, gid, min(distance) as distance, the_geom FROM ( 
     
    5254{{{ 
    5355DROP TABLE IF EXISTS temperature.tmn_ccm; 
     56 
    5457CREATE TABLE temperature.tmn_ccm as( 
    5558SELECT gridid, gid, min(distance) as distance, the_geom FROM (