ST_TRANSFORM function problem

[Rafael Almeida Fernandez Soto-2]

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

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Nicolas Ribot-2]

> 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
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users