[postgis-tickets] [PostGIS] #4151: ST_3DDwithin Errors on memcmp with pt_in_ring_3d
PostGIS
trac at osgeo.org
Thu Aug 16 05:57:29 PDT 2018
#4151: ST_3DDwithin Errors on memcmp with pt_in_ring_3d
----------------------+---------------------------
Reporter: tilt | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.5.0
Component: postgis | Version: trunk
Resolution: | Keywords:
----------------------+---------------------------
Comment (by Algunenano):
The first polygon you are using is invalid; the first and last point of
the polygon should be the same:
- First: {{{ 238122.872000001 576633.508999999 5.98677038142003 }}}
- Last: {{{ 238122.872000001 576633.508999999 5.98677038142796 }}}
The z coordinate is `5.98677038142003` vs `5.98677038142796`.
If you change it to the same value it outputs:
{{{
SELECT
ST_3DDwithin(ST_GeometryFromText('POLYGON Z ((
238122.872000001 576633.508999999 5.98677038142003,
238122.872 576633.509 5.98677038052055,
238121.623809392 576634.389879555 4.95792405791038,
238120.252000002 576635.357999998 3.82718245716979,
238120.252 576635.358 3.82718245541562,
238121.873 576637.738 3.8333125996467,
238121.873000001 576637.737999999 3.83331260027449,
238124.460390651 576635.62447975 6.0745417745131,
238122.991788134 576633.427399075 6.08439985368325,
238122.872000001 576633.508999999 5.98677038142003))'),
ST_GeometryFromText('POINT Z (238123 576634 0)')
,0.1)
st_3ddwithin
--------------
f
(1 row)
}}}
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4151#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list