[postgis-users] Geometry problems

Agustin Ignacio Genoves agustingenoves at gmail.com
Wed Oct 10 06:07:20 PDT 2018


Hi, I have a "PostgreSQL 9.3.7 on x86_64-unknown-linux-gnu, compiled by gcc
(Debian 4.7.2-5) 4.7.2, 64-bit POSTGIS="2.1.4 r12966"
GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.7.1, 23 September 2009" GDAL="GDAL
1.9.0, released 2011/12/29" LIBXML="2.8.0" LIBJSON="UNKNOWN" RASTER"

when I compared two identical geometries with the function st_equals () it
returns false. I give details of the geometries and the query.

"MULTIPOLYGON(((5630819.53 6195089.21,5630826.21 6195080.71,5630839.12
6195064.3,5630926.29 6195132.6,5630907.33 6195157.29,5630819.64
6195089.07,5630819.53 6195089.21)))"
"MULTIPOLYGON(((5630819.53 6195089.21,5630826.21 6195080.71,5630839.12
6195064.3,5630926.29 6195132.6,5630907.33 6195157.29,5630819.64
6195089.07,5630819.53 6195089.21)))"

select st_equals(ST_GeometryFromText('MULTIPOLYGON(((5630819.53
6195089.21,5630826.21 6195080.71,5630839.12 6195064.3,5630926.29
6195132.6,5630907.33 6195157.29,5630819.64 6195089.07,5630819.53
6195089.21)))',22185),
ST_GeometryFromText('MULTIPOLYGON(((5630819.53 6195089.21,5630826.21
6195080.71,5630839.12 6195064.3,5630926.29 6195132.6,5630907.33
6195157.29,5630819.64 6195089.07,5630819.53 6195089.21)))',22185))

Thanks in advance
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181010/835b54d6/attachment.html>


More information about the postgis-users mailing list