id summary reporter owner description type status priority milestone component version resolution keywords cc 3355 ST_Intersects() return no result with ST_Segmentize() sdiz robe "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 }}}" defect closed blocker PostGIS 2.1.9 postgis 2.1.x fixed