MySQL Forums
Forum List  »  GIS

storing google map lat/long
Posted by: Euclid Me
Date: April 09, 2009 11:35AM


i am working on a loc based concept. stuck on a few issues.

how do we store the lat/lng decimals (google map api) to a "point" datatype in mysql.

example for paris
lat - 48.8372
lng - 2.33

do we store it as GEOMFROMTEXT('POINT(48.8372 2.33234)') or do
i need to convert to any specific format.

storing it as float column will not suffice as all the spatial quering fu

dont i do need to store them as point/linestring/polygon to use data query functions like glenght/exteriorring ?

eg given "n" mile radius from a base point finding matching locations


Options: ReplyQuote

Written By
storing google map lat/long
April 09, 2009 11:35AM

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.