From 1981ff1d1542724259507f4f9c39604e9b9843d0 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Thu, 10 Sep 2009 05:27:19 +0000 Subject: [PATCH] first attempt at figure for st_linecrossingdirection. Also query correction. git-svn-id: http://svn.osgeo.org/postgis/trunk@4470 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/html/image_src/Makefile.in | 1 + doc/html/image_src/st_linecrossingdirection01.wkt | 6 ++++++ doc/reference.xml | 15 ++++++++++++--- 3 files changed, 19 insertions(+), 3 deletions(-) create mode 100644 doc/html/image_src/st_linecrossingdirection01.wkt diff --git a/doc/html/image_src/Makefile.in b/doc/html/image_src/Makefile.in index 957f02655..0df875203 100644 --- a/doc/html/image_src/Makefile.in +++ b/doc/html/image_src/Makefile.in @@ -58,6 +58,7 @@ IMAGES= \ ../images/st_isvalid06.png \ ../images/st_isvalid07.png \ ../images/st_isvalid08.png \ + ../images/st_line_crossingdirection01.png \ ../images/st_line_interpolate_point01.png \ ../images/st_line_substring01.png \ ../images/st_minimumboundingcircle01.png \ diff --git a/doc/html/image_src/st_linecrossingdirection01.wkt b/doc/html/image_src/st_linecrossingdirection01.wkt new file mode 100644 index 000000000..9b6f98eb7 --- /dev/null +++ b/doc/html/image_src/st_linecrossingdirection01.wkt @@ -0,0 +1,6 @@ +Style2;LINESTRING (49.55 194.88, 49.85 194.24, 50.25 194.31) +Style2;POINT(49.55 194.88) +Style2;POLYGON((50.253329086454286 194.24232297330548, 50.24206897193198 194.38332142018575, 50.36088698569539 194.32123285218572, 50.253329086454286 194.24232297330548)) +Style1-thinline;LINESTRING (49.61 193.88, 50.25 194.82) +Style1-thinline;POINT(49.61 193.88) +Style1-thinline;POLYGON((50.267397967078914 194.71401807841175, 50.16331710842844 194.80980182997902, 50.29267606288439 194.84500085799175, 50.267397967078914 194.71401807841175)) diff --git a/doc/reference.xml b/doc/reference.xml index 9098920d0..3ee885d0c 100644 --- a/doc/reference.xml +++ b/doc/reference.xml @@ -9677,9 +9677,18 @@ WHERE ST_Crosses(roads.the_geom, highways.the_geom); Examples - SELECT ST_LineCrossingDirection(foo.line1, foo.line2) As linecrossleft , ST_CrossingDirection(foo.line2, foo.line1) As linecrossright -FROM (SELECT ST_GeomFromText('LINESTRING(744589 2923929,744521 2923861)') As line1, -ST_GeomFromText('LINESTRING(744753 2924117,744563 2923902)') As line2) As foo; + + + + + + Line 1 fat line, Line 2 thin line, point is start point, + triangle are end points. Query below. + + + SELECT ST_LineCrossingDirection(foo.line1, foo.line2) As linecrossleft , ST_LineCrossingDirection(foo.line2, foo.line1) As linecrossright +FROM (SELECT ST_GeomFromText('LINESTRING (49.55 194.88, 49.85 194.24, 50.25 194.31)') As line1, +ST_GeomFromText('LINESTRING (49.61 193.88, 50.25 194.82)') As line2) As foo; linecrossleft | linecrossright ---------------+---------------- -- 2.50.0