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

Paul Ramsey pramsey at opengeo.org
Tue Aug 17 12:17:19 EDT 2010


It should be, our spatial_ref_sys is generated from gdal which
generates from epsg. You have a pretty recent postgis, so I'm
surprised it's missing.
P

On Tue, Aug 17, 2010 at 1:57 AM, Erik Rehn <erik at slagkryssaren.com> wrote:
> Thank you guys! You were right, I had flipped the coordinates in the test I
> made.
>
> But that didn't explain the error I got in the KML. The solution to that
> was to add "+towgs84=414.1,41.3,603.1,-0.855,2.141,-7.023,0" to the
> spatial_ref_sys table for srid 3021. Why isn't that in there by default?
>
> erik
>
> On 2010-08-12 17:05, Ricardo Bayley wrote:
>>
>> very nice explanation Mike
>>
>> On Thu, Aug 12, 2010 at 11:39 AM, Mike Toews <mwtoews at gmail.com
>> <mailto:mwtoews at gmail.com>> wrote:
>>
>>    Hi,
>>
>>    Your coordinates may be flipped. Was it 59N 18E? If so, use x,y
>>    notation: 'POINT(18 59)', which results in 'POINT(18.0000000000006
>>    58.9999999999905)', which is close enough.
>>
>>    Also keep in mind that you are outside the projection bounds:
>>    http://spatialreference.org/ref/epsg/3021/ (just a bit too far east).
>>    Whenever you are outside the projection bounds, the likelihood of
>>    storage precision errors increase. To understand why this is, you can
>>    think of taking the tangent of a two angles that are nearly a
>>    right-angle (89.9991 and 89.9992) which have very different results
>>    due to nature of the geometry.
>>
>>    -Mike
>>
>>    On 11 August 2010 13:10, Erik Rehn <erik at slagkryssaren.com
>>    <mailto: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 <mailto:erik at slagkryssaren.com>
>>     > www.slagkryssaren.com <http://www.slagkryssaren.com>
>>     > _______________________________________________
>>     > postgis-users mailing list
>>     > postgis-users at postgis.refractions.net
>>    <mailto:postgis-users at postgis.refractions.net>
>>     > http://postgis.refractions.net/mailman/listinfo/postgis-users
>>     >
>>    _______________________________________________
>>    postgis-users mailing list
>>    postgis-users at postgis.refractions.net
>>    <mailto:postgis-users at postgis.refractions.net>
>>    http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
> --
> 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