From 0d1cf1ad58bdecd29b4eac5d2030b80fdfafbf1f Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Thu, 10 Sep 2009 04:10:44 +0000 Subject: [PATCH] figure for st_line_substring git-svn-id: http://svn.osgeo.org/postgis/trunk@4468 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/html/image_src/Makefile.in | 1 + doc/html/image_src/st_line_substring01.wkt | 2 ++ doc/reference.xml | 13 ++++++++++--- 3 files changed, 13 insertions(+), 3 deletions(-) create mode 100644 doc/html/image_src/st_line_substring01.wkt diff --git a/doc/html/image_src/Makefile.in b/doc/html/image_src/Makefile.in index cd3c1c699..957f02655 100644 --- a/doc/html/image_src/Makefile.in +++ b/doc/html/image_src/Makefile.in @@ -59,6 +59,7 @@ IMAGES= \ ../images/st_isvalid07.png \ ../images/st_isvalid08.png \ ../images/st_line_interpolate_point01.png \ + ../images/st_line_substring01.png \ ../images/st_minimumboundingcircle01.png \ ../images/st_symdifference01.png \ ../images/st_symdifference02.png \ diff --git a/doc/html/image_src/st_line_substring01.wkt b/doc/html/image_src/st_line_substring01.wkt new file mode 100644 index 000000000..1f1d120b6 --- /dev/null +++ b/doc/html/image_src/st_line_substring01.wkt @@ -0,0 +1,2 @@ +Style2;LINESTRING(25 50, 100 125, 150 190) +Style1-thinline;LINESTRING(69.2846934853974 94.2846934853974,100 125,111.700356260683 140.210463138888) diff --git a/doc/reference.xml b/doc/reference.xml index 5d8e792e4..9098920d0 100644 --- a/doc/reference.xml +++ b/doc/reference.xml @@ -13607,14 +13607,21 @@ FROM (SELECT ST_GeomFromText('LINESTRING(1 2, 4 5, 6 7)') As the_line) As foo; Examples + + + + + + A linestring seen with 1/3 midrange overlaid (0.333, 0.666) + + --Return the approximate 1/3 mid-range part of a linestring -SELECT ST_AsText(ST_Line_SubString(ST_GeomFromText('LINESTRING(748130 2919491, - 747979 2919630,747895 2919705)'), 0.333, 0.666)); +SELECT ST_AsText(ST_Line_SubString(ST_GeomFromText('LINESTRING(25 50, 100 125, 150 190)'), 0.333, 0.666)); st_astext ------------------------------------------------------------------------------------------------ - LINESTRING(748052.127524758 2919562.68393416,747979 2919630,747974.189261348 2919634.29530237) +LINESTRING(69.2846934853974 94.2846934853974,100 125,111.700356260683 140.210463138888) --The below example simulates a while loop in --SQL using PostgreSQL generate_series() to cut all -- 2.40.0