Home > postgis > Transform 900913 to 4326

Transform 900913 to 4326

September 4th, 2008 rupert Leave a comment Go to comments

Stumbled upon an error in reprojecting data from 900913 (Google Speherical Mercator) to 4326 (WGS84). I’m recalling this from my head now, the error was something related to “NAD sth”. Workaround was to convert it as follows:

1. 900913
2. 32650 (UTM for your area)
3. 4326

I’ll get the SQL from my ofcmate and paste it here…

Categories: postgis Tags:
  1. Rex
    October 13th, 2008 at 14:07 | #1
    Reply | Quote

    SELECT
    AsText(
    Transform(
    Transform(
    GeomFromText( ‘POINT( 12946153.81080 4849895.22611 )’, 900913),
    32650
    ),
    4326
    )
    )

You must be logged in to post a comment.