I would suggest that first you check your data has a consistent format, i.e.
"zero" is represented as 0000, 12.3 degrees is represented as 1230 and 1.23
degrees is represented as 0123.
Otherwise you need to do a little preparation work...
HTH,
Michael
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of John
Callahan
Sent: Tuesday, July 12, 2011 9:13 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] converting to lat long
Looks like you already have lat/long coordinates and don't need to use
ST_Transform. Make sure you know if the original values are in 'decimal
degrees' or 'degrees minutes seconds'. If in DD, just divide your values by
100 which should be easy in SQL. If in DMS, then you need to parse the data
first. I'm not sure how to do that in SQL but sure it's possible.
- John
On Tue, Jul 12, 2011 at 8:58 AM, Yamini Singh
<yaminijsi...@live.com<mailto:yaminijsi...@live.com>> wrote:
Hi All,
I have a column 'geocode' in a table which has attributes like 2329/4727 now I
would like to convert these attributes in another column to 'lat' and 'long'.
For example, 'Lat' column will have attribute '23.29' and 'long' column will
have attribute '47.27'.
Is there a way through which this can be converted automatically by a query or
so.
Looking fwd..
Thanks
YJ
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net<mailto:postgis-users@postgis.refractions.net>
http://postgis.refractions.net/mailman/listinfo/postgis-users
The information contained in this transmission is to be considered CONFIDENTIAL
and PROPRIETARY to Consortium Health Plans, Inc. and intended for the use of
the Individual or Entity named above. If the reader of this message is not the
Intended Recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is Strictly Prohibited. If you
have received this transmission in error, please notify us immediately by
telephone at 410-772-2900 or return email to sender immediately. Thank You.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
