my detail are:
Debian Etch stable.
select postgis_full_version();
postgis_full_version
----------------------------------------------------------------------------------
POSTGIS="1.1.6" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.5.0, 22 Oct 2006"
USE_STATS
(1 row)
but the same problem was when I tried the newest version of postgis.
########################################################
BUT ->
when I try
select simplify('MULTIPOLYGON(((-333399.63 -1270249.25,-333416.78
-1270247.43,-333415.54 -1270231.88,-333411.49 -1270209.38)),((-333408.1
-1270235.32,-333408.8 -1270244.32,-333401.1 -1270245.02,-333400.5
-1270236.12,-333408.1 -1270235.32)),((-333397.27
-1270210.4)),((-333397.58 -1270214.37)))', 500);
ERROR: geometry contains non-closed rings
result is the same as Yours
##########################################################
but when i try to
select simplify(the_geom,1000) from kataster where icutjcpa =
'8601232244003'; server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>
############################################################
icutjcpa = '8601232244003' is that object
select astext(the_geom) from kataster where icutjcpa =
'8601232244003';
astext
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MULTIPOLYGON(((-333399.63 -1270249.25,-333416.78 -1270247.43,-333415.54
-1270231.88,-333411.49 -1270209.38)),((-333408.1 -1270235.32,-333408.8
-1270244.32,-333401.1 -1270245.02,-333400.5 -1270236.12,-333408.1
-1270235.32)),((-333397.27 -1270210.4)),((-333397.58 -1270214.37)))
(1 row)
#############################################################
Mark Cave-Ayland wrote:
On Mon, 2007-10-29 at 18:20 +0100, ivan minčík wrote:
thanks, I just wanted to submit bug described in this thread
http://postgis.refractions.net/pipermail/postgis-users/2007-October/017365.html
this is one of the objects which was the reason
MULTIPOLYGON(((-333399.63 -1270249.25,-333416.78 -1270247.43,-333415.54
-1270231.88,-333411.49 -1270209.38)),((-333408.1 -1270235.32,-333408.8
-1270244.32,-333401.1
-1270245.02,-333400.5 -1270236.12,-333408.1 -1270235.32)),((-333397.27
-1270210.4)),((-333397.58 -1270214.37)))
ivan
Strange. Works for me here:
postgis=# select version();
version
---------------------------------------------------------------------------------------------------
PostgreSQL 8.3beta2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
4.0.3 (Ubuntu 4.0.3-1ubuntu5)
(1 row)
postgis=# select postgis_full_version();
postgis_full_version
-------------------------------------------------------------------------------------
POSTGIS="1.3.2" GEOS="3.0.0rc4-CAPI-1.3.3" PROJ="Rel. 4.5.0, 22 Oct
2006" USE_STATS
(1 row)
postgis=# select ST_simplify('MULTIPOLYGON(((-333399.63
-1270249.25,-333416.78 -1270247.43,-333415.54 -1270231.88,-333411.49
-1270209.38)),((-333408.1 -1270235.32,-333408.8 -1270244.32,-333401.1
-1270245.02,-333400.5 -1270236.12,-333408.1 -1270235.32)),((-333397.27
-1270210.4)),((-333397.58 -1270214.37)))', 500);ERROR: geometry
contains non-closed rings
postgis=#
Does the above work for you? If not, what does SELECT version() and
SELECT postgis_full_version() return?
ATB,
Mark.
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
