Hi Is there any way in postgis to convert the lat and long from degree system to decimal system. I have the data in the format as below 17.21.00S 145.30.00W Thanks in advance. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.refractions.net/pipermail/postgis-users/attachments/20061121/7d0ecda0/attachment.html