Changes between Version 29 and Version 30 of PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test

Timestamp:

Aug 29, 2012, 12:18:12 PM (12 years ago)

Author:

qliu

Comment:

—

PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test

@@ -285 +285 @@
 }}}
     result:[[BR]][[BR]]
-    [[Image(test_eudist_3_a_1.gif)]][[BR]]
+    [[Image(test_eudist_3_a_1.gif)]][[BR]][[BR]]
     result zoom in:[[BR]][[BR]]
     [[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.
+  3-a-2: Snap is True; Max distance is specified:
+{{{
+#!sql
+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);
+}}}
+  3-a-3: Snap is False; Max distance NOT specified:
+{{{
+#!sql
+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);
+}}}
+    result:[[BR]][[BR]]
+    [[Image(test_eudist_3_a_3.gif)]][[BR]][[BR]]
+    result zoom in:[[BR]][[BR]]
+    [[Image(test_eudist_3_a_3_zoomin.gif)]][[BR]]
+  3-a-4: Snap is False; Max distance is specified:
+{{{
+#!sql
+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);
+}}}
+ 3-b: Generate Euclidean Distance from a set of raster specifications:
+  3-b-1: Snap is True; Max distance NOT specified:
+{{{
+#!sql
+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);
+}}}
+  3-b-2: Snap is True; Max distance is specified:
+{{{
+#!sql
+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);
+}}}
+  3-b-3: Snap is False; Max distance NOT specified:
+{{{
+#!sql
+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);
+}}}
+  3-b-4: Snap is False; Max distance is specified:
+{{{
+#!sql
+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);
+}}}
+[[BR]]
+== Test 4: Performance test: ==
+{{{
+#!sql
+CREATE TABLE test_ref_raster_4 AS SELECT 1 AS rid,rast FROM (SELECT ST_MakeEmptyRaster(300,300,0,0,1,1,0,0,4326) AS rast)foo;
+}}}
+ 4-a: Source: 100 points; Raster: 300x300
+{{{
+#!sql
+CREATE TABLE test_source_geometry_4_a AS SELECT generate_series(1,100) AS id,ST_RandomPoints(the_geom,100) AS the_geom FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry),4326) AS the_geom FROM test_ref_raster_4)foo;
+CREATE INDEX test_source_geometry_4_a_gist_idx ON test_source_geometry_4_a USING GIST (the_geom);
+CREATE TABLE test_eudist_4_a AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_4_a','the_geom',True) AS rast FROM test_ref_raster_4);
+}}}
+  * 122325 ms execution time.
+    result:[[BR]][[BR]]
+    [[Image(test_eudist_4_a.gif)]][[BR]]
+ 4-b: Source: 1,000 points; Raster: 300x300
+{{{
+#!sql
+CREATE TABLE test_source_geometry_4_b 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_4)foo;
+CREATE INDEX test_source_geometry_4_b_gist_idx ON test_source_geometry_4_b USING GIST (the_geom);
+CREATE TABLE test_eudist_4_b AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_4_b','the_geom',True) AS rast FROM test_ref_raster_4);
+}}}
+  * 132139 ms execution time.
+    result:[[BR]][[BR]]
+    [[Image(test_eudist_4_b.gif)]][[BR]][[BR]]
+ 4-c: Source: 5,000 points; Raster: 300x300
+{{{
+#!sql
+CREATE TABLE test_source_geometry_4_c AS SELECT generate_series(1,5000) AS id,ST_RandomPoints(the_geom,5000) AS the_geom FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry),4326) AS the_geom FROM test_ref_raster_4)foo;
+CREATE INDEX test_source_geometry_4_c_gist_idx ON test_source_geometry_4_c USING GIST (the_geom);
+CREATE TABLE test_eudist_4_c AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_4_c','the_geom',True) AS rast FROM test_ref_raster_4);
+}}}
+  * 126652 ms execution time.
+    result:[[BR]][[BR]]
+    [[Image(test_eudist_4_c.gif)]][[BR]][[BR]]
+ 4-d: Source: 10,000 points; Raster: 300x300
+{{{
+#!sql
+CREATE TABLE test_source_geometry_4_d AS SELECT generate_series(1,10000) AS id,ST_RandomPoints(the_geom,10000) AS the_geom FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry),4326) AS the_geom FROM test_ref_raster_4)foo;
+CREATE INDEX test_source_geometry_4_d_gist_idx ON test_source_geometry_4_d USING GIST (the_geom);
+CREATE TABLE test_eudist_4_d AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_4_d','the_geom',True) AS rast FROM test_ref_raster_4);
+}}}
+  * 143764 ms execution time.
+    result:[[BR]][[BR]]
+    [[Image(test_eudist_4_d.gif)]][[BR]][[BR]]
+ 4-e: Source: 20,000 points; Raster: 300x300
+{{{
+#!sql
+CREATE TABLE test_source_geometry_4_e AS SELECT generate_series(1,20000) AS id,ST_RandomPoints(the_geom,20000) AS the_geom FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry),4326) AS the_geom FROM test_ref_raster_4)foo;
+CREATE INDEX test_source_geometry_4_e_gist_idx ON test_source_geometry_4_e USING GIST (the_geom);
+CREATE TABLE test_eudist_4_e AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_4_e','the_geom',True) AS rast FROM test_ref_raster_4);
+}}}
+  * 120016 ms execution time.
+    result:[[BR]][[BR]]
+    [[Image(test_eudist_4_e.gif)]][[BR]][[BR]]
+ 4-f: Source: 40,000 points; Raster: 300x300
+{{{
+#!sql
+CREATE TABLE test_source_geometry_4_f AS SELECT generate_series(1,40000) AS id,ST_RandomPoints(the_geom,40000) AS the_geom FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry),4326) AS the_geom FROM test_ref_raster_4)foo;
+CREATE INDEX test_source_geometry_4_f_gist_idx ON test_source_geometry_4_f USING GIST (the_geom);
+CREATE TABLE test_eudist_4_f AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_4_f','the_geom',True) AS rast FROM test_ref_raster_4);
+}}}
+  * 169386 ms execution time.
+    result:[[BR]][[BR]]
+    [[Image(test_eudist_4_f.gif)]][[BR]][[BR]]
+ 4-g: Source: 80,000 points; Raster: 300x300
+{{{
+#!sql
+CREATE TABLE test_source_geometry_4_g AS SELECT generate_series(1,80000) AS id,ST_RandomPoints(the_geom,80000) AS the_geom FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry),4326) AS the_geom FROM test_ref_raster_4)foo;
+CREATE INDEX test_source_geometry_4_g_gist_idx ON test_source_geometry_4_g USING GIST (the_geom);
+CREATE TABLE test_eudist_4_g AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_4_g','the_geom',True) AS rast FROM test_ref_raster_4);
+}}}
+  * 164385 ms execution time.
+    result:[[BR]][[BR]]
+    [[Image(test_eudist_4_g.gif)]][[BR]][[BR]]
+ 4-h: Source: 160,000 points; Raster: 300x300
+{{{
+#!sql
+CREATE TABLE test_source_geometry_4_h AS SELECT generate_series(1,160000) AS id,ST_RandomPoints(the_geom,160000) AS the_geom FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry),4326) AS the_geom FROM test_ref_raster_4)foo;
+CREATE INDEX test_source_geometry_4_h_gist_idx ON test_source_geometry_4_h USING GIST (the_geom);
+CREATE TABLE test_eudist_4_h AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_4_h','the_geom',True) AS rast FROM test_ref_raster_4);
+}}}
+  * 160800 ms execution time.
+    result:[[BR]][[BR]]
+    [[Image(test_eudist_4_h.gif)]][[BR]][[BR]]
+ 4-i: Source: 320,000 points; Raster: 300x300
+{{{
+#!sql
+CREATE TABLE test_source_geometry_4_i AS SELECT generate_series(1,320000) AS id,ST_RandomPoints(the_geom,320000) AS the_geom FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry),4326) AS the_geom FROM test_ref_raster_4)foo;
+CREATE INDEX test_source_geometry_4_i_gist_idx ON test_source_geometry_4_i USING GIST (the_geom);
+CREATE TABLE test_eudist_4_i AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_4_i','the_geom',True) AS rast FROM test_ref_raster_4);
+}}}
+  * 204460 ms execution time.
+    result:[[BR]][[BR]]
+    [[Image(test_eudist_4_i.gif)]][[BR]][[BR]]
+ 4-j: Source: 640,000 points; Raster: 300x300
+{{{
+#!sql
+CREATE TABLE test_source_geometry_4_j AS SELECT generate_series(1,640000) AS id,ST_RandomPoints(the_geom,640000) AS the_geom FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry),4326) AS the_geom FROM test_ref_raster_4)foo;
+CREATE INDEX test_source_geometry_4_j_gist_idx ON test_source_geometry_4_j USING GIST (the_geom);
+CREATE TABLE test_eudist_4_j AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_4_j','the_geom',True) AS rast FROM test_ref_raster_4);
+}}}
+  * 168992 ms execution time.
+    result:[[BR]][[BR]]
+    [[Image(test_eudist_4_j.gif)]][[BR]][[BR]]
+[[BR]]
+== Test 5: Scalability test:==
+ 5-a: Source: 10,000 points; Raster: 1000x1000
+{{{
+#!sql
+CREATE TABLE test_ref_raster_5 AS SELECT 1 AS rid,rast FROM (SELECT ST_MakeEmptyRaster(1000,1000,0,0,1,1,0,0,4326) AS rast)foo;
+CREATE TABLE test_source_geometry_5_a AS SELECT generate_series(1,10000) AS id,ST_RandomPoints(the_geom,10000) AS the_geom FROM (SELECT ST_SetSRID(ST_Extent(rast::geometry),4326) AS the_geom FROM test_ref_raster_5)foo;
+CREATE INDEX test_source_geometry_5_a_gist_idx ON test_source_geometry_5_a USING GIST (the_geom);
+CREATE TABLE test_eudist_5_a AS (SELECT 1 AS rid,ST_EuclideanDistance(rast,'32BF','public','test_source_geometry_5_a','the_geom',True) AS rast FROM test_ref_raster_5);
+}}}
+  * 1576434 ms execution time.
+    result:[[BR]][[BR]]
+    [[Image(test_eudist_5_a.gif)]][[BR]][[BR]]