[postgis-users] ST_RemoveRepeatedPoints failing to work?
Lee Goddard
leegee at gmail.com
Tue Feb 11 06:03:14 PST 2014
Please forgive what may be a silly question, I am new to PostGIS.
I have the following:
SELECT ST_AsKML(
ST_RemoveRepeatedPoints(
ST_Union(wkb_geometry)
), 0
)
The beginning of the returned value looks like this:
<MultiGeometry><Polygon><outerBoundaryIs><LinearRing><coordinates>-156,20 -156,20
-156,20 -156,20 -156,20 -156,20 -156,20 -156,20 -156,20 ...
The repeated points occur several hundred times.
The docs [1] say it can be safely called with any kind of geometry.
Does anyone know what I might be doing wrong? Or of another way to
approach the problem of producing a smaller KML file (I compress to KMZ
later) with perhaps less detail?
My version info is below [2].
Thanks in anticipation
Lee
[1] http://postgis.org/docs/ST_RemoveRepeatedPoints.html
<http://postgis.org/docs/ST_RemoveRepeatedPoints.html>
[2]
SELECT PostGIS_full_version();
postgis_full_version
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POSTGIS="2.1.1 r12113" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0,
6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.7.3"
LIBJSON="UNKNOWN" TOPOLOGY RASTER
(1 row)
More information about the postgis-users
mailing list