Changes between Version 3 and Version 4 of PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test
- Timestamp:
- Aug 28, 2012, 10:35:51 AM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test
v3 v4 1 -- Test 0:1 == Test 0 ==: 2 2 CREATE 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; 3 3 CREATE 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; 4 4 CREATE 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; 5 5 6 -- 0-a: Test NULL Raster. Should be true. 6 '''0-a: Test NULL Raster. Should be true.''' 7 7 SELECT ST_EuclideanDistance(NULL,NULL,'public','test_source_geometry_0','the_geom',False) IS NULL FROM test_ref_raster_0; 8 8 9 -- 0-b: Test Empty Raster. Should be true. 9 '''0-b: Test Empty Raster. Should be true.''' 10 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)); 11 11 12 -- 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: 12 == 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 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 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 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 raster18 --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);20 --result:21 --[[Image(test_eudist_1_a_i_1.gif)]]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); 20 result: 21 [[Image(test_eudist_1_a_i_1.gif)]] 22 22 -------- 1-a-i-2: Snap is False; Max distance NOT specified: 23 23 -------- 1-a-i-3: Snap is True; Max distance is specified: