> 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
