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


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

—

Legend:

Unmodified
Added
Removed
Modified

  • PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test

    v22 v23  
    9191   1-b-i-1: Snap is True; Max distance NOT specified:
    9292{{{
    93 #!
    94 sql
     93#!sql
    9594CREATE TABLE test_eudist_1_b_i_1 AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_1_b','the_geom',True) AS rast FROM test_ref_raster_1);
    9695}}}
    … …  
    9998   1-b-i-2: Snap is True; Max distance is specified:
    10099{{{
    101 #!
    102 sql
     100#!sql
    103101CREATE TABLE test_eudist_1_b_i_2 AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_1_b','the_geom',True,15) AS rast FROM test_ref_raster_1);
    104102}}}
    … …  
    107105   1-b-i-3: Snap is False; Max distance NOT specified:
    108106{{{
    109 #!
    110 sql
     107#!sql
    111108CREATE TABLE test_eudist_1_b_i_3 AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_1_b','the_geom',False) AS rast FROM test_ref_raster_1);
    112109}}}
    … …  
    115112   1-b-i-4: Snap is False; Max distance is specified:
    116113{{{
    117 #!
    118 sql
     114#!sql
    119115CREATE TABLE test_eudist_1_b_i_4 AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_1_b','the_geom',False,15) AS rast FROM test_ref_raster_1);
    120116}}}
    … …  
    124120   1-b-ii-1: Snap is True; Max distance NOT specified:
    125121{{{
    126 #!
    127 sql
     122#!sql
    128123CREATE 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);
    129124}}}
    … …  
    131126   1-b-ii-2: Snap is True; Max distance is specified:
    132127{{{
    133 #!
    134 sql
     128#!sql
    135129CREATE 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);
    136130}}}
    … …  
    138132   1-b-ii-3: Snap is False; Max distance NOT specified:
    139133{{{
    140 #!
    141 sql
     134#!sql
    142135CREATE 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);
    143136}}}
    … …  
    145138   1-b-ii-4: Snap is False; Max distance is specified:
    146139{{{
    147 #!
    148 sql
     140#!sql
    149141CREATE 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);
    150142}}}
    … …  
    159151   1-c-i: Generate Euclidean Distance from a one-band reference raster:
    160152{{{
    161 #!
    162 sql
     153#!sql
    163154CREATE TABLE test_eudist_1_c_i_1 AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_1_c','the_geom',True) AS rast FROM test_ref_raster_1);
    164155}}}
    … …  
    167158   1-c-i-2: Snap is True; Max distance is specified:
    168159{{{
    169 #!
    170 sql
     160#!sql
    171161CREATE TABLE test_eudist_1_c_i_2 AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_1_c','the_geom',True,6) AS rast FROM test_ref_raster_1);
    172162}}}
    … …  
    175165   1-c-i-3: Snap is False; Max distance NOT specified:
    176166{{{
    177 #!
    178 sql
     167#!sql
    179168CREATE TABLE test_eudist_1_c_i_3 AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_1_c','the_geom',False) AS rast FROM test_ref_raster_1);
    180169}}}
    … …  
    183172   1-c-i-4: Snap is False; Max distance is specified:
    184173{{{
    185 #!
    186 sql
     174#!sql
    187175CREATE TABLE test_eudist_1_c_i_4 AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_1_c','the_geom',False,6) AS rast FROM test_ref_raster_1);
    188176}}}
    … …  
    193181   1-c-ii-1: Snap is True; Max distance NOT specified:
    194182{{{
    195 #!
    196 sql
     183#!sql
    197184CREATE 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);
    198185}}}
    … …  
    200187   1-c-ii-2: Snap is True; Max distance is specified:
    201188{{{
    202 #!
    203 sql
     189#!sql
    204190CREATE 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);
    205191}}}
    … …  
    207193   1-c-ii-3: Snap is False; Max distance NOT specified:
    208194{{{
    209 #!
    210 sql
     195#!sql
    211196CREATE 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);
    212197}}}
    … …  
    214199   1-c-ii-4: Snap is False; Max distance is specified:
    215200{{{
    216 #!
    217 sql
     201#!sql
    218202CREATE 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);
    219203}}}