Changes between Version 26 and Version 27 of PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test

Timestamp:

Aug 29, 2012, 12:03:49 PM (12 years ago)

Author:

qliu

Comment:

—

PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test

@@ -237 +237 @@
 }}}
     result:[[BR]][[BR]]
-    [[Image(test_eudist_2_a.gif)]][[BR]]
+    [[Image(test_eudist_2_a_3.gif)]][[BR]]
   2-a-4: Snap is False; Max distance is specified:
 {{{
@@ -244 +244 @@
 }}}
     result:[[BR]][[BR]]
-    [[Image(test_eudist_2_a.gif)]][[BR]]
+    [[Image(test_eudist_2_a_4.gif)]][[BR]]
+ 2-b: Generate Euclidean Distance from a set of raster specifications:
+  2-b-1: Snap is True; Max distance NOT specified:
+{{{
+#!sql
+CREATE TABLE test_eudist_2_b_1 AS (SELECT 1 AS rid,ST_EuclideanDistance(300,300,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_2','the_geom',True) AS rast);
+}}}
+    result: same as test_eudist_2_a.gif[[BR]]
+  2-b-2: Snap is True; Max distance is specified:
+{{{
+#!sql
+CREATE TABLE test_eudist_2_b_2 AS (SELECT 1 AS rid,ST_EuclideanDistance(300,300,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_2','the_geom',True,125) AS rast);
+}}}
+    result: same as test_eudist_2_a_2.gif[[BR]]
+  2-b-3: Snap is False; Max distance NOT specified:
+{{{
+#!sql
+CREATE TABLE test_eudist_2_b_3 AS (SELECT 1 AS rid,ST_EuclideanDistance(300,300,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_2','the_geom',False) AS rast);
+}}}
+    result: same as test_eudist_2_a_3.gif[[BR]]
+  2-b-4: Snap is False; Max distance is specified:
+{{{
+#!sql
+CREATE TABLE test_eudist_2_b_4 AS (SELECT 1 AS rid,ST_EuclideanDistance(300,300,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_2','the_geom',False,125) AS rast);
+}}}
+    result: same as test_eudist_2_a_4.gif[[BR]]
+[[BR]]
+== Test 3: Large number of sources vs high resolution raster:(Source: 1000 points, Raster: 300x300) ==
+{{{
+#!sql
+CREATE TABLE test_ref_raster_3 AS SELECT 1 AS rid,rast FROM (SELECT ST_MakeEmptyRaster(300,300,0,0,1,1,0,0,4326) AS rast)foo;
+CREATE TABLE test_source_geometry_3 AS SELECT generate_series(1,1000) AS id,ST_RandomPoints(the_geom,1000) AS the_geom FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry),4326) AS the_geom FROM test_ref_raster_3)foo;
+CREATE INDEX test_source_geometry_3_gist_idx ON test_source_geometry_3 USING GIST (the_geom);
+ 3-a: Generate Euclidean Distance from a one-band reference raster:
+  3-a-1: Snap is True; Max distance NOT specified:
+{{{
+#!sql
+CREATE TABLE test_eudist_3_a_1 AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_3','the_geom',True) AS rast FROM test_ref_raster_3);
+}}}
+    result:[[BR]][[BR]]
+    [[Image(test_eudist_3_a_1.gif)]]  result zoom in:[[Image(test_eudist_3_a_1_zoomin.gif)]][[BR]]
+------ 3-a-2: Snap is True; Max distance is specified:
+--CREATE TABLE test_eudist_3_a_2 AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_3','the_geom',True,12) AS rast FROM test_ref_raster_3);
+---135707 ms execution time.
+------ 3-a-3: Snap is False; Max distance NOT specified:
+--CREATE TABLE test_eudist_3_a_3 AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_3','the_geom',False) AS rast FROM test_ref_raster_3);
+---86246 ms execution time.
+------ 3-a-4: Snap is False; Max distance is specified:
+--CREATE TABLE test_eudist_3_a_4 AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_3','the_geom',False,12) AS rast FROM test_ref_raster_3);
+---85263 ms execution time.
+
+---- 3-b: Generate Euclidean Distance from a set of raster specifications:
+------ 3-b-1: Snap is True; Max distance NOT specified:
+--CREATE TABLE test_eudist_3_b_1 AS (SELECT 1 AS rid,ST_EuclideanDistance(300,300,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_3','the_geom',True) AS rast FROM test_ref_raster_3);
+---128044 ms execution time.
+------ 3-b-2: Snap is True; Max distance is specified:
+--CREATE TABLE test_eudist_3_b_2 AS (SELECT 1 AS rid,ST_EuclideanDistance(300,300,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_3','the_geom',True,12) AS rast FROM test_ref_raster_3);
+---138114 ms execution time.
+------ 3-b-3: Snap is False; Max distance NOT specified:
+--CREATE TABLE test_eudist_3_b_3 AS (SELECT 1 AS rid,ST_EuclideanDistance(300,300,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_3','the_geom',False) AS rast FROM test_ref_raster_3);
+---76005 ms execution time.
+------ 3-b-4: Snap is False; Max distance is specified:
+--CREATE TABLE test_eudist_3_b_4 AS (SELECT 1 AS rid,ST_EuclideanDistance(300,300,0,0,1,1,0,0,4326,NULL,'32BF','public','test_source_geometry_3','the_geom',False,12) AS rast FROM test_ref_raster_3);
+---88137 ms execution time.