Changes between Version 46 and Version 47 of WKTRasterTutorial01

Timestamp:

06/11/10 12:51:45 (15 years ago)

Author:

pracine

Comment:

—

WKTRasterTutorial01

@@ -218 +218 @@
 {{{
     CREATE TABLE cariboupoints AS
-    SELECT generate_series(1,1000) id, 
-           ST_RandomPoints(the_geom, 1000) the_geom
-    FROM (SELECT ST_Transform(ST_SetSRID(ST_Extent(rast::geometry), 3426), 32198) the_geom
+    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
           FROM srtm_tiled
-         ) foo;
-}}}
+         ) foo;}}}
 
 Similarly you can visualise your own caribou point layer with this OpenJUMP query: