Changes between Version 21 and Version 22 of PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test


Ignore:
Timestamp:
Aug 28, 2012, 2:35:10 PM (12 years ago)
Author:
qliu
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test

    v21 v22  
    126126#!
    127127sql
    128 CREATE TABLE test_eudist_1_b_ii_1 AS (SELECT 1 AS rid,ST_EuclideanDistance(10,10,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_1_b','the_geom',True) AS rast FROM test_ref_raster_1);
     128CREATE TABLE test_eudist_1_b_ii_1 AS (SELECT 1 AS rid,ST_EuclideanDistance(10,10,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_1_b','the_geom',True) AS rast);
    129129}}}
    130130    result: same as test_eudist_1_b_i_1.gif[BR]][[BR]]
    … …  
    133133#!
    134134sql
    135 CREATE TABLE test_eudist_1_b_ii_2 AS (SELECT 1 AS rid,ST_EuclideanDistance(10,10,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_1_b','the_geom',True,15) AS rast FROM test_ref_raster_1);
     135CREATE TABLE test_eudist_1_b_ii_2 AS (SELECT 1 AS rid,ST_EuclideanDistance(10,10,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_1_b','the_geom',True,15) AS rast);
    136136}}}
    137137    result: same as test_eudist_1_b_i_2.gif[BR]][[BR]]
    … …  
    140140#!
    141141sql
    142 CREATE TABLE test_eudist_1_b_ii_3 AS (SELECT 1 AS rid,ST_EuclideanDistance(10,10,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_1_b','the_geom',False) AS rast FROM test_ref_raster_1);
     142CREATE TABLE test_eudist_1_b_ii_3 AS (SELECT 1 AS rid,ST_EuclideanDistance(10,10,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_1_b','the_geom',False) AS rast);
    143143}}}
    144144    result: same as test_eudist_1_b_i_3.gif[BR]][[BR]]
    … …  
    147147#!
    148148sql
    149 CREATE TABLE test_eudist_1_b_ii_4 AS (SELECT 1 AS rid,ST_EuclideanDistance(10,10,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_1_b','the_geom',False,15) AS rast FROM test_ref_raster_1);
     149CREATE TABLE test_eudist_1_b_ii_4 AS (SELECT 1 AS rid,ST_EuclideanDistance(10,10,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_1_b','the_geom',False,15) AS rast);
    150150}}}
    151151    result: same as test_eudist_1_b_i_4.gif[BR]][[BR]]
    … …  
    190190    [[Image(test_eudist_1_c_i_4.gif)]][[BR]]
    191191
    192 
    193 ------ 1-c-ii: Generate Euclidean Distance from a set of raster specifications:
    194 -------- 1-c-ii-1: Snap is True; Max distance NOT specified:
    195 -------- 1-c-ii-2: Snap is False; Max distance NOT specified:
    196 -------- 1-c-ii-3: Snap is True; Max distance is specified:
    197 -------- 1-c-ii-4: Snap is False; Max distance is specified:
    198 
    199 -- Test 2: Small number of sources vs high resolution raster:(Source: 10 points, Raster: 300x300)
     192  1-c-ii: Generate Euclidean Distance from a set of raster specifications:
     193   1-c-ii-1: Snap is True; Max distance NOT specified:
     194{{{
     195#!
     196sql
     197CREATE TABLE test_eudist_1_c_ii_1 AS (SELECT 1 AS rid,ST_EuclideanDistance(10,10,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_1_c','the_geom',True) AS rast);
     198}}}
     199    result: same as test_eudist_1_c_i_1.gif[BR]][[BR]]
     200   1-c-ii-2: Snap is True; Max distance is specified:
     201{{{
     202#!
     203sql
     204CREATE TABLE test_eudist_1_c_ii_2 AS (SELECT 1 AS rid,ST_EuclideanDistance(10,10,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_1_c','the_geom',True,6) AS rast);
     205}}}
     206    result: same as test_eudist_1_c_i_2.gif[BR]][[BR]]
     207   1-c-ii-3: Snap is False; Max distance NOT specified:
     208{{{
     209#!
     210sql
     211CREATE TABLE test_eudist_1_c_ii_3 AS (SELECT 1 AS rid,ST_EuclideanDistance(10,10,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_1_c','the_geom',False) AS rast);
     212}}}
     213    result: same as test_eudist_1_c_i_3.gif[BR]][[BR]]
     214   1-c-ii-4: Snap is False; Max distance is specified:
     215{{{
     216#!
     217sql
     218CREATE TABLE test_eudist_1_c_ii_4 AS (SELECT 1 AS rid,ST_EuclideanDistance(10,10,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_1_c','the_geom',False,6) AS rast);
     219}}}
     220    result: same as test_eudist_1_c_i_4.gif[BR]][[BR]]
     221[[BR]][[BR]]
     222== Test 2: Small number of sources vs high resolution raster:(Source: 10 points, Raster: 300x300) ==
    200223---- 2-a: Source geometry within the extent of the desired raster:
    201224------ 2-a-i: Generate Euclidean Distance from a one-band reference raster