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
jim


this

SELECT astext( address_loc ) FROM `address`;

returns

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


Subject
Views
Written By
Posted
Re: How to un-convert GeomFromText()
2622
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.