storing google map lat/long
Posted by:
Euclid Me
Date: April 09, 2009 11:35AM
hi,
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
thanks,
px
Subject
Views
Written By
Posted
storing google map lat/long
8330
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.