[postgis-users] ST_TRANSFORM function problem

Rafael Soto rafael at opengeo.com.br
Wed Nov 4 10:54:38 PST 2009


Hi Folks,

I'm having a problems with the transform process at present some records in
my database.
I try to transform my geometry in a 4326(EPSG:4326) projection to
900913(google mercator) projection uses a ST_TRANSFORM postgis function.
In some geometries in same table(relation) it's work but in others postgis
show me this erro.

********** Error **********
ERROR: transform: couldn't project point: -14 (latitude or longitude
exceeded limits)
SQL state: XX000
Context: SQL statement "SELECT  ST_TRANSFORM( $1 ,900913)"

What could be wrong since the geometry is valid and postgis
metadata(spatial_ref_sys and geometry_columns) is correct?

Environment description

PostgreSQL 8.3.5 on x86_64-centOS-linux-gnu, compiled by GCC gcc (GCC) 4.1.2
20071124 (Red Hat 4.1.2-42)
PostGIS 1.3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
PROJ Rel. 4.6.1, 21 August 2008
GEOS 3.0.3-CAPI-1.4.2

Hopes for help!

Rafael Soto
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091104/bea6bb8b/attachment.html>


More information about the postgis-users mailing list