[postgis-users] 900913 bbox conversion problem

[Paul Ramsey]

This appears to be an open issue on 1.5 as well, I have ticketed it.

http://trac.osgeo.org/postgis/ticket/318

P

On Wed, Nov 25, 2009 at 9:39 AM, Andy Harrison <andyh at alh.me.uk> wrote:
> Hi all,
>
> I'm working on a simple select statement that converts a 900913 SRID
> bounding box to 4326 and uses the result in a where clause. Everything works
> fine on my local machine, but on the remote linux machine the conversion
> throws out some unexpected values. Anyone any ideas? Both 3857 and 900913
> were missing from spatial_ref_sys on the remote machine, so i've put the
> 900913 definition in there myself, copied from my local machine. Funny thing
> is the first coordinate of the returned bounding box is correct but the rest
> is garbage.
>
> any ideas?
>
> thanks,
> Andy
>
> *******
>
> Test query:
> SELECT ASTEXT(ST_Transform(ST_SetSRID(ST_MakeBox2D(
> ST_Point(-633510.090428,7506727.67383),
> ST_Point(-305748.113141,7834489.65112)),900913),4326));
>
> Results:
> WINDOWS (works perfectly)
> POSTGIS: POSTGIS="1.4.0" GEOS="3.1.1-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21 August
> 2008" USE_STATS
>
> POLYGON((
> -5.69091771787263 55.7394808196103,
> -5.69091771787263 57.3620891294052,
> -2.74658213778386 57.3620891294052,
> -2.74658213778386 55.7394808196103,
> -5.69091771787263 55.7394808196103))
>
> LINUX (returns odd values with negative exponents)
> POSTGIS: POSTGIS="1.3.6" GEOS="3.1.1-CAPI-1.6.0" PROJ="Rel. 4.7.1, 23
> September 2009" USE_STATS
>
> POLYGON((
> -5.69091771787263 55.7394808196103,
> -8.9225391644498e-07 8.99354923458109e-06,
> -4.3062451273528e-07 8.99354923458109e-06,
> -4.3062451273528e-07 8.73914761944114e-06,
> -8.9225391644498e-07 8.73914761944114e-06))
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>