From: Michael Fuhr <mike@fuhr.org>
To: Nemo Terry <ntuser155@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Which function transform x,y to latitude/longitude?
Date: Wed, 25 Apr 2007 08:16:56 -0600
Message-ID: <20070425141655.GA5472@winnie.fuhr.org> (raw)
In-Reply-To: <BAY19-F9735E07E622CE8C977DA8F5490@phx.gbl>
References: <BAY19-F9735E07E622CE8C977DA8F5490@phx.gbl>
On Wed, Apr 25, 2007 at 05:02:02PM +0800, Nemo Terry wrote:
> For example x= 38356.62 y= 42365.19.how to transform it to latitude
> 1.399948, longitude 193.92644?
Do you mean longitude 103.92644? In what datum are the lat/lon
coordinates? Where did you get the transformation in your example?
> Which function I could use? I don’t know the algorithm.
>
> Initial data is: ("+proj=cass +a=6378137.0 +rf=298.257223563
> +lat_0=1.287639n +lon_0=103.8516e +x_0=30000 +y_0=30000").
What's the source of these parameters?
You can perform transformations outside the database with PROJ.4
or inside the database with the PostGIS transform() function (which
uses PROJ.4).
http://proj.maptools.org/http://postgis.refractions.net/
I don't see any exact matches in the PostGIS spatial_ref_sys table
for the parameters you posted you so if you use PostGIS then you
might have to insert a row to create your own spatial reference
system. However, I did a few tests with your parameters and various
datums for the lat/lon and couldn't get the exact transformed values
in your example.
You might get more help on the PROJ.4 and PostGIS mailing lists.
--
Michael Fuhr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, ntuser155@hotmail.com
Subject: Re: Which function transform x,y to latitude/longitude?
In-Reply-To: <20070425141655.GA5472@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox