[MetaCRS] Re: [postgis-users] st_transform, irreversible?

Paul Ramsey pramsey at opengeo.org
Wed Aug 11 16:35:46 EDT 2010


Seems to be an underlying problem with proj4:

echo "59 21" | proj "+init=epsg:3021" | invproj "+init=epsg:3021"

58d49'47.733"E	21d2'54.745"N

And that's without doing the datum shift part.

P

On Wed, Aug 11, 2010 at 1:10 PM, Erik Rehn <erik at slagkryssaren.com> wrote:
> Hello Postgis Users!
>
> This is my first post on this list so I will start by asking
> a simple (and probably stupid) question. :)
>
> While using ST_AsKml() to produce an overlay for Google Earth I
> noticed that all my geometries where shifted slightly south-east.
> I figured this had something to do with the transformation between
> the projection that my geometries are stored in (SRID 3021) and WGS84 (4326)
> that is outputted by ST_AsKml()
>
> Just to test I ran this:
>
> SELECT ST_AsText(
>    ST_Transform(
>        ST_Transform(
>            ST_GeomFromText('POINT(59 18)',4326),
>        3021),
>    4326));
>
> I input a point in WGS84 (59,18), transforms it to 3021 and then back to
> WGS84. The result I get is:
> POINT(58.8672757036296 18.0394763349359)
>
> Can anyone explain this? Am I missing something regarding ST_Transform()?
>
> Im running Postgis 1.5 on Windows.
>
> Thank you for any help!
> /Erik
>
> --
> Erik Rehn
> Slagkryssaren
> erik at slagkryssaren.com
> www.slagkryssaren.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


More information about the MetaCRS mailing list