From abbbc690ef61aad7a8ae6de297989bf99f2702ab Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Mon, 21 Nov 2011 16:03:25 +0000 Subject: [PATCH] Numerate tests for line_substring git-svn-id: http://svn.osgeo.org/postgis/trunk@8210 b70326c6-7e19-0410-871a-916f4a2858ee --- regress/regress_lrs.sql | 28 ++++++++++++++-------------- regress/regress_lrs_expected | 24 ++++++++++++------------ 2 files changed, 26 insertions(+), 26 deletions(-) diff --git a/regress/regress_lrs.sql b/regress/regress_lrs.sql index 9bc1322d0..5e58afa22 100644 --- a/regress/regress_lrs.sql +++ b/regress/regress_lrs.sql @@ -35,20 +35,20 @@ select 'line_locate_point_3', ST_line_locate_point(ST_geomfromtext('LINESTRING(- --- line_substring / line_interpolate_point --- postgis-devel/2006-January/001951.html -select 'line_substring', ST_asewkt(ST_line_substring(ST_geomfromewkt('SRID=4326;LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2, 3 3 3 3, 4 4 4 4)'), 0.5, 0.8)); - -select 'line_substring', ST_asewkt(ST_line_substring('LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2, 3 3 3 3, 4 4 4 4)', 0.5, 0.75)); -select 'line_substring', ST_asewkt(ST_line_substring('LINESTRING(0 0, 1 1, 2 2)', 0, 0.5)); -select 'line_substring', ST_asewkt(ST_line_substring('LINESTRING(0 0, 1 1, 2 2)', 0.5, 1)); -select 'line_substring', ST_asewkt(ST_line_substring('LINESTRING(0 0, 2 2)', 0.5, 1)); -select 'line_substring', ST_asewkt(ST_line_substring('LINESTRING(0 0, 2 2)', 0, 0.5)); -select 'line_substring', ST_asewkt(ST_line_substring('LINESTRING(0 0, 4 4)', .25, 0.5)); -select 'line_substring', ST_asewkt(ST_line_substring('LINESTRINGM(0 0 0, 4 4 4)', .25, 0.5)); -select 'line_substring', ST_asewkt(ST_line_substring('LINESTRINGM(0 0 4, 4 4 0)', .25, 0.5)); -select 'line_substring', ST_asewkt(ST_line_substring('LINESTRING(0 0 4, 4 4 0)', .25, 0.5)); - -select 'line_substring', ST_asewkt(ST_line_substring('LINESTRING(0 0, 1 1)', 0, 0)); -select 'line_substring', ST_asewkt(ST_line_substring('LINESTRING(0 0 10, 1 1 5)', 0.5, .5)); +select 'line_substring_1', ST_asewkt(ST_line_substring(ST_geomfromewkt('SRID=4326;LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2, 3 3 3 3, 4 4 4 4)'), 0.5, 0.8)); + +select 'line_substring_2', ST_asewkt(ST_line_substring('LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2, 3 3 3 3, 4 4 4 4)', 0.5, 0.75)); +select 'line_substring_3', ST_asewkt(ST_line_substring('LINESTRING(0 0, 1 1, 2 2)', 0, 0.5)); +select 'line_substring_4', ST_asewkt(ST_line_substring('LINESTRING(0 0, 1 1, 2 2)', 0.5, 1)); +select 'line_substring_5', ST_asewkt(ST_line_substring('LINESTRING(0 0, 2 2)', 0.5, 1)); +select 'line_substring_6', ST_asewkt(ST_line_substring('LINESTRING(0 0, 2 2)', 0, 0.5)); +select 'line_substring_7', ST_asewkt(ST_line_substring('LINESTRING(0 0, 4 4)', .25, 0.5)); +select 'line_substring_8', ST_asewkt(ST_line_substring('LINESTRINGM(0 0 0, 4 4 4)', .25, 0.5)); +select 'line_substring_9', ST_asewkt(ST_line_substring('LINESTRINGM(0 0 4, 4 4 0)', .25, 0.5)); +select 'line_substring_10', ST_asewkt(ST_line_substring('LINESTRING(0 0 4, 4 4 0)', .25, 0.5)); + +select 'line_substring_11', ST_asewkt(ST_line_substring('LINESTRING(0 0, 1 1)', 0, 0)); +select 'line_substring_12', ST_asewkt(ST_line_substring('LINESTRING(0 0 10, 1 1 5)', 0.5, .5)); --- line_interpolate_point diff --git a/regress/regress_lrs_expected b/regress/regress_lrs_expected index 5647b6081..41a2668a6 100644 --- a/regress/regress_lrs_expected +++ b/regress/regress_lrs_expected @@ -18,17 +18,17 @@ LINEZM_6|POINT(9.5 0.5 0.5 2) line_locate_point_1|0.528602749909894 line_locate_point_2|1 line_locate_point_3|0 -line_substring|SRID=4326;LINESTRING(2 2 2 2,3 3 3 3,3.2 3.2 3.2 3.2) -line_substring|LINESTRING(2 2 2 2,3 3 3 3) -line_substring|LINESTRING(0 0,1 1) -line_substring|LINESTRING(1 1,2 2) -line_substring|LINESTRING(1 1,2 2) -line_substring|LINESTRING(0 0,1 1) -line_substring|LINESTRING(1 1,2 2) -line_substring|LINESTRINGM(1 1 1,2 2 2) -line_substring|LINESTRINGM(1 1 3,2 2 2) -line_substring|LINESTRING(1 1 3,2 2 2) -line_substring|POINT(0 0) -line_substring|POINT(0.5 0.5 7.5) +line_substring_1|SRID=4326;LINESTRING(2 2 2 2,3 3 3 3,3.2 3.2 3.2 3.2) +line_substring_2|LINESTRING(2 2 2 2,3 3 3 3) +line_substring_3|LINESTRING(0 0,1 1) +line_substring_4|LINESTRING(1 1,2 2) +line_substring_5|LINESTRING(1 1,2 2) +line_substring_6|LINESTRING(0 0,1 1) +line_substring_7|LINESTRING(1 1,2 2) +line_substring_8|LINESTRINGM(1 1 1,2 2 2) +line_substring_9|LINESTRINGM(1 1 3,2 2 2) +line_substring_10|LINESTRING(1 1 3,2 2 2) +line_substring_11|POINT(0 0) +line_substring_12|POINT(0.5 0.5 7.5) line_interpolate_point|POINT(0 0) line_interpolate_point|POINT(0.5 0.5 7.5) -- 2.40.0