Problem Description
I'm working with map data, and the `Latitude/Longitude` extends to 8 decimal places. For example:
Latitude 40.71727401
Longitude -74.00898606
I saw in the [Google document][1]
which uses:
lat FLOAT( 10, 6 ) NOT NULL,
lng FLOAT( 10, 6 ) NOT NULL
however, their decimal places only go to 6.
Should I use `FLOAT(10, 8)` or is there another method to consider for storing this data so it's precise. It will be used with map calculations. Thanks!
[1]: https://developers.google.com/maps/articles/phpsqlsearch_v3#createtable "Google Document"
AI-Generated Solution
Powered by LMSouq AI · GPT-4.1-mini
Analyzing problem and generating solution…
Was this solution helpful?