Changes between Version 46 and Version 47 of WKTRasterTutorial01


Ignore:
Timestamp:
Jun 11, 2010, 12:51:45 PM (14 years ago)
Author:
pracine
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • WKTRasterTutorial01

    v46 v47  
    218218{{{
    219219    CREATE TABLE cariboupoints AS
    220     SELECT generate_series(1,1000) id,
    221            ST_RandomPoints(the_geom, 1000) the_geom
    222     FROM (SELECT ST_Transform(ST_SetSRID(ST_Extent(rast::geometry), 3426), 32198) the_geom
     220    SELECT generate_series(1, 814) id,
     221           ST_Transform(ST_RandomPoints(the_geom, 814), 32198) the_geom
     222    FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry), 4326) the_geom
    223223          FROM srtm_tiled
    224          ) foo;
    225 }}}
     224         ) foo;}}}
    226225
    227226Similarly you can visualise your own caribou point layer with this OpenJUMP query: