LMSouq
database Open

What MySQL data type should be used for Latitude/Longitude with 8 decimal places?

ED
Edward
1 month ago
3 views
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

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base