[postgis-users] ST_TRANSFORM function problem

Nicolas Ribot nicolas.ribot at gmail.com
Wed Nov 4 11:20:43 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
>

Would it be possible that your initial data (or some of them) are
stored as lat-lon, instead of lon-lat as it is expected by Postgis?
Could you isolate the points in error and send them to the list ?

Nicolas



More information about the postgis-users mailing list