Changes between Version 61 and Version 62 of WKTRasterTutorial01

Timestamp:

Jun 15, 2010, 12:30:25 PM (14 years ago)

Author:

pracine

Comment:

—

WKTRasterTutorial01

@@ -134 +134 @@
 {{{
     SELECT (md).*, (bmd).* 
-    FROM (SELECT ST_Metadata(rast) md, 
-                 ST_BandMetadata(rast) bmd 
+    FROM (SELECT ST_Metadata(rast) AS md, 
+                 ST_BandMetadata(rast) AS bmd 
           FROM srtm_tiled LIMIT 1
          ) foo;
@@ -242 +242 @@
 {{{
     CREATE TABLE cariboupoints AS
-    SELECT generate_series(1, 814) id, 
-           ST_Transform(ST_RandomPoints(the_geom, 814), 32198) the_geom
-    FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry), 4326) the_geom
+    SELECT generate_series(1, 814) AS id, 
+           ST_Transform(ST_RandomPoints(the_geom, 814), 32198) AS the_geom
+    FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry), 4326) AS the_geom
           FROM srtm_tiled
          ) foo;
@@ -266 +266 @@
 {{{
     CREATE TABLE cariboupoint_buffers AS 
-    SELECT id, ST_Buffer(the_geom, 1000) the_geom
+    SELECT id, ST_Buffer(the_geom, 1000) AS the_geom
     FROM cariboupoints;
 }}}
@@ -281 +281 @@
 {{{
     CREATE TABLE cariboupoint_buffers_wgs AS 
-    SELECT id, ST_Transform(the_geom, 4326) the_geom
+    SELECT id, ST_Transform(the_geom, 4326) AS the_geom
     FROM cariboupoint_buffers;
 }}}
@@ -296 +296 @@
 {{{
     CREATE TABLE cariboupoint_buffers_wgs AS 
-    SELECT id, ST_Transform(ST_Buffer(the_geom, 1000), 4326) the_geom
+    SELECT id, ST_Transform(ST_Buffer(the_geom, 1000), 4326) AS the_geom
     FROM cariboupoints;
 }}}
@@ -313 +313 @@
     CREATE TABLE caribou_srtm_inter AS
     SELECT id, 
-        (st_intersection(rast, the_geom)).geom the_geom, 
+        (st_intersection(rast, the_geom)).geom AS the_geom, 
         (st_intersection(rast, the_geom)).val
     FROM cariboupoint_buffers_wgs, 
@@ -325 +325 @@
     CREATE TABLE caribou_srtm_inter AS
     SELECT id, 
-           (gv).geom the_geom, 
+           (gv).geom AS the_geom, 
            (gv).val
     FROM (SELECT id, 
-                 st_intersection(rast, the_geom) gv
+                 ST_Intersection(rast, the_geom) AS gv
           FROM srtm_tiled,
                cariboupoint_buffers_wgs
@@ -354 +354 @@
     CREATE TABLE result01 AS
     SELECT id, 
-           sum(st_area(ST_Transform(the_geom, 32198)) * val) / sum(st_area(ST_Transform(the_geom, 32198))) as meanelev
+           sum(st_area(ST_Transform(the_geom, 32198)) * val) / sum(st_area(ST_Transform(the_geom, 32198))) AS meanelev
     FROM caribou_srtm_inter
     GROUP BY id