Changes between Version 18 and Version 19 of WKTRasterTutorial01


Ignore:
Timestamp:
Jun 11, 2010, 7:28:54 AM (12 years ago)
Author:
pracine
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • WKTRasterTutorial01

    v18 v19  
    318318    CREATE TABLE result01 AS
    319319    SELECT id,
    320                sum(st_area(ST_Transform(the_geom, 32198)) * val) / sum(st_area(ST_Transform(the_geom, 32198))) as meanelev
     320           sum(st_area(ST_Transform(the_geom, 32198)) * val) / sum(st_area(ST_Transform(the_geom, 32198))) as meanelev
    321321    FROM caribou_srtm_inter1
    322322    GROUP BY id