[postgis-tickets] [PostGIS] #3355: ST_Intersects() return no result with ST_Segmentize()

PostGIS trac at osgeo.org
Sun Nov 1 20:33:41 PST 2015


#3355: ST_Intersects() return no result with ST_Segmentize()
---------------------+---------------------------
 Reporter:  sdiz     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  high     |  Milestone:  PostGIS 2.2.1
Component:  postgis  |    Version:  2.2.x
 Keywords:           |
---------------------+---------------------------
 The same linestring return 't' when intersects directly, but 'f' when
 mixed with ST_Segmentize()


 {{{
 db=>  select
       ST_Intersects(
         'LINESTRING(124.983539 1.419224,91.181596 29.647798)'::geography
       , 'LINESTRING(124.983539 1.419224,91.181596 29.647798)'::geography);
  st_intersects
 ---------------
  t
 (1 row)
 }}}

 {{{
 db=>   select
        ST_Intersects(
          'LINESTRING(124.983539 1.419224,91.181596 29.647798)'::geography
        , ST_Segmentize('LINESTRING(124.983539 1.419224,91.181596
 29.647798)'::geography, 47487290)::geography);
  st_intersects
 ---------------
  f
 (1 row)
 }}}

 The segmented line should be same as input:

 {{{
 db=> select st_astext(ST_Segmentize('LINESTRING(124.983539
 1.419224,91.181596 29.647798)'::geography, 47487290)::geography);
                       st_astext
 -----------------------------------------------------
  LINESTRING(124.983539 1.419224,91.181596 29.647798)
 (1 row)
 }}}



 Version:
 {{{
  PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
 5.2.1-21) 5.2.1 20151003, 64-bit POSTGIS="2.1.8 r13780"
 GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2, 08 September 2015"
 GDAL="GDAL 1.11.3, released 2015/09/16" LIBXML="2.9.1" LIBJSON="UNKNOWN"
 RASTER


 Versions of packages postgis depends on:
 ii  postgis          2.1.8+dfsg-4
 ii  libc6            2.19-22
 ii  libgdal1i        1.11.3+dfsg-2
 ii  libgeos-c1v5     3.5.0-1
 ii  libglib2.0-0     2.46.1-1
 ii  libgtk2.0-0      2.24.28-1
 ii  libjson-c2       0.11-4
 ii  liblwgeom-2.1.8  2.1.8+dfsg-4
 ii  libpq5           9.4.5-1
 ii  libproj9         4.9.2-1
 }}}

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3355>
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