Changes between Version 30 and Version 31 of PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test
- Timestamp:
- Aug 29, 2012, 1:27:02 PM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test
v30 v31 1 == Test 0: == 1 = ST_EuclideanDistance() TEST = 2 3 {{{ 4 #!html 5 <div style='background-color: #F4F4F4; border: 1px solid gray; width:400px;' > 6 <br> 7 <UL> 8 <LI><A href=http://trac.osgeo.org/postgis/wiki/PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test#TestingEnvironment>Testing Environment</A></LI> 9 <LI><A href=http://trac.osgeo.org/postgis/wiki/PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test#Test0>Test 0: NULL raster; Empty raster Test</A></LI> 10 <LI><A href=http://trac.osgeo.org/postgis/wiki/PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test#Test1>Test 1: Small number of sources vs low resolution raster: (Source: 10 points, Raster: 10x10)</A></LI> 11 <LI><A href=http://trac.osgeo.org/postgis/wiki/PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test#Test2>Test 2: Small number of sources vs high resolution raster:(Source: 10 points, Raster: 300x300)</A></LI> 12 <LI><A href=http://trac.osgeo.org/postgis/wiki/PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test#Test3>Test 3: Large number of sources vs high resolution raster:(Source: 1000 points, Raster: 300x300)</A></LI> 13 <LI><A href=http://trac.osgeo.org/postgis/wiki/PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test#Test4>Test 4: Performance test</A></LI> 14 <LI><A href=http://trac.osgeo.org/postgis/wiki/PostGIS_Raster_SoC_Idea_2012/Distance_Analysis_Tools/test#Test5>Test 5: Scalability test</A></LI> 15 </UL> 16 <br> 17 </div> 18 }}} 19 [[BR]] 20 ---- 21 [[BR]] 22 == Testing Environment == 23 CPU: Intel Pentium 4, 3.00GHz 24 RAM: 2.00G 25 OS: MS Windows XP Professional 2002 SP 3 26 PostgreSQL 9.1 27 PostGIS 2.1.0SVN 28 [[BR]] 29 ---- 30 [[BR]] 31 == Test 0 == 2 32 {{{ 3 33 #!sql … … 19 49 }}} 20 50 21 == Test 1: Small number of sources vs low resolution raster: (Source: 10 points, Raster: 10x10) == 51 == Test 1 == 52 === Small number of sources vs low resolution raster: (Source: 10 points, Raster: 10x10) === 22 53 1-a: Source geometry within the extent of the desired raster:[[BR]] 23 54 {{{ … … 209 240 '''Cases of source point geometries OUTSIDE of the extent of the desired raster will NOT be tested for the following tests''' 210 241 ---- 211 == Test 2: Small number of sources vs high resolution raster:(Source: 10 points, Raster: 300x300) == 242 == Test 2 == 243 === Small number of sources vs high resolution raster:(Source: 10 points, Raster: 300x300) === 212 244 {{{ 213 245 #!sql … … 271 303 result: same as test_eudist_2_a_4.gif[[BR]] 272 304 [[BR]] 273 == Test 3: Large number of sources vs high resolution raster:(Source: 1000 points, Raster: 300x300) == 305 == Test 3 == 306 === Large number of sources vs high resolution raster:(Source: 1000 points, Raster: 300x300) === 274 307 {{{ 275 308 #!sql … … 316 349 {{{ 317 350 #!sql 318 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); 351 CREATE TABLE test_eudist_3_b_2 AS ( 352 ..........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); 319 353 }}} 320 354 3-b-3: Snap is False; Max distance NOT specified: … … 329 363 }}} 330 364 [[BR]] 331 == Test 4: Performance test: == 365 == Test 4 == 366 === Performance Test === 332 367 {{{ 333 368 #!sql … … 422 457 }}} 423 458 * 204460 ms execution time. 424 result:[[BR]][[BR]] 425 [[Image(test_eudist_4_i.gif)]][[BR]][[BR]] 459 result: too many source point, picture doesn't make too much sense.[[BR]][[BR]] 426 460 4-j: Source: 640,000 points; Raster: 300x300 427 461 {{{ … … 432 466 }}} 433 467 * 168992 ms execution time. 434 result:[[BR]][[BR]] 435 [[Image(test_eudist_4_j.gif)]][[BR]][[BR]] 436 [[BR]] 437 == Test 5: Scalability test:== 468 result: too many source point, picture doesn't make too much sense.[[BR]][[BR]] 469 [[BR]] 470 == Test 5 == 471 === Scalability test === 472 Very large size source points vs very high resolution raster: 438 473 5-a: Source: 10,000 points; Raster: 1000x1000 439 474 {{{ … … 447 482 result:[[BR]][[BR]] 448 483 [[Image(test_eudist_5_a.gif)]][[BR]][[BR]] 484 [[BR]]