MySQL Forums
Forum List  »  GIS

Re: How to un-convert GeomFromText()
Posted by: jimbo pruett
Date: May 21, 2010 06:24AM

ok, it looks like I just needed the astext() function.
Q: How do I get lat, lon? or do I just strip it off somehow?
Q: Is there a function to strip the word POINT?
thanks for any replys


SELECT astext( address_loc ) FROM `address`;


astext( address_loc )
POINT(2671 2500)
POINT(2971 2520)
POINT(3171 2510)
POINT(-114.877871869233 36.3310176346906)

^^^^ how do I get rid of the word POINT above? ^^^^^

Options: ReplyQuote

Written By
Re: How to un-convert GeomFromText()
May 21, 2010 06:24AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.