Changes between Version 5 and Version 6 of PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test


Ignore:
Timestamp:
Aug 28, 2012, 10:37:24 AM (12 years ago)
Author:
qliu
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test

    v5 v6  
    1 == Test 0 ==:
     1== Test 0: ==
    22CREATE TABLE test_source_raster_0 AS SELECT 1 AS rid,rast FROM (SELECT ST_MakeEmptyRaster(10,10,0,0,1,1,0,0,4326) AS rast)foo;
    33CREATE TABLE test_source_geometry_0 AS SELECT generate_series(1,10) AS id,ST_RandomPoints(the_geom,10) AS the_geom FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry),4326) AS the_geom FROM test_source_raster_0)foo;
    44CREATE TABLE test_ref_raster_0 AS SELECT 1 AS rid,rast FROM (SELECT ST_MakeEmptyRaster(10,10,0,0,1,1,0,0,4326) AS rast)foo;
    55
    6 '''0-a: Test NULL Raster. Should be true.'''
    7 SELECT ST_EuclideanDistance(NULL,NULL,'public','test_source_geometry_0','the_geom',False) IS NULL FROM test_ref_raster_0;
    8 
    9 '''0-b: Test Empty Raster. Should be true.'''
    10 SELECT ST_IsEmpty(ST_EuclideanDistance(0,10,0,0,1,1,0,0,4326,-999,'32BF','public','test_source_geometry_0','the_geom',False));
     6 0-a: Test NULL Raster. Should be true.
     7 SELECT ST_EuclideanDistance(NULL,NULL,'public','test_source_geometry_0','the_geom',False) IS NULL FROM test_ref_raster_0;
     8
     9 0-b: Test Empty Raster. Should be true.
     10 SELECT ST_IsEmpty(ST_EuclideanDistance(0,10,0,0,1,1,0,0,4326,-999,'32BF','public','test_source_geometry_0','the_geom',False));
    1111
    1212== Test 1: Small number of sources vs low resolution raster: (Source: 10 points, Raster: 10x10) ==
    13 '''1-a: Source geometry within the extent of the desired raster:'''
    14 CREATE TABLE test_source_raster_1 AS SELECT 1 AS rid,rast FROM (SELECT ST_MakeEmptyRaster(10,10,0,0,1,1,0,0,4326) AS rast)foo;
    15 CREATE TABLE test_source_geometry_1 AS SELECT generate_series(1,10) AS id,ST_RandomPoints(the_geom,10) AS the_geom FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry),4326) AS the_geom FROM test_source_raster_1)foo;
    16 CREATE TABLE test_ref_raster_1 AS SELECT 1 AS rid,rast FROM (SELECT ST_MakeEmptyRaster(10,10,0,0,1,1,0,0,4326) AS rast)foo;
    17  1-a-i: Generate Euclidean Distance from a one-band reference raster
    18   1-a-i-1: Snap is True; Max distance NOT specified:
    19    CREATE TABLE test_eudist_1_a_i_1 AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_1','the_geom',True) AS rast FROM test_ref_raster_1);[[BR]]
    20    result:[[BR]]
    21    [[Image(test_eudist_1_a_i_1.gif)]][[BR]]
     13 1-a: Source geometry within the extent of the desired raster:
     14 CREATE TABLE test_source_raster_1 AS SELECT 1 AS rid,rast FROM (SELECT ST_MakeEmptyRaster(10,10,0,0,1,1,0,0,4326) AS rast)foo;
     15 CREATE TABLE test_source_geometry_1 AS SELECT generate_series(1,10) AS id,ST_RandomPoints(the_geom,10) AS the_geom FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry),4326) AS the_geom FROM test_source_raster_1)foo;
     16 CREATE TABLE test_ref_raster_1 AS SELECT 1 AS rid,rast FROM (SELECT ST_MakeEmptyRaster(10,10,0,0,1,1,0,0,4326) AS rast)foo;
     17  1-a-i: Generate Euclidean Distance from a one-band reference raster
     18   1-a-i-1: Snap is True; Max distance NOT specified:
     19    CREATE TABLE test_eudist_1_a_i_1 AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_1','the_geom',True) AS rast FROM test_ref_raster_1);[[BR]]
     20    '''result:'''[[BR]]
     21    [[Image(test_eudist_1_a_i_1.gif)]][[BR]]
    2222-------- 1-a-i-2: Snap is False; Max distance NOT specified:
    2323-------- 1-a-i-3: Snap is True; Max distance is specified: