[postgis-users] converting to lat long

[MarkW]

Just to add to the other good advice you've already received:

If the data are in the format with an actual slash, as a single string (not
sure from your email), then string functions can help you get to the point
where you can divide, or create geometry, if that's where you're at:
http://www.postgresql.org/docs/8.4/interactive/functions-string.html

Mark

On Tue, Jul 12, 2011 at 8:58 AM, Yamini Singh <yaminijsingh at 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*
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110712/991289b1/attachment.html>