How accurately should I store latitude and longitude?

by

Accuracy versus decimal places at the equator

decimal  degrees    distance
places
-------------------------------  
0        1.0        111 km
1        0.1        11.1 km
2        0.01       1.11 km
3        0.001      111 m
4        0.0001     11.1 m
5        0.00001    1.11 m
6        0.000001   0.111 m
7        0.0000001  1.11 cm
8        0.00000001 1.11 mm

ref : https://en.wikipedia.org/wiki/Decimal_degrees#Precision

More Related Contents:

  1. Delete the entire content of all table in a Database [closed]
  2. MyISAM versus InnoDB [closed]
  3. Calculate a running total in MySQL
  4. How do MySQL indexes work?
  5. How to change MySQL data directory?
  6. MySQL Syntax error message “Operand should contain 1 column(s)”
  7. How to use mysql JOIN without ON condition?
  8. Format number to 2 decimal places
  9. How to remove all non-alpha numeric characters from a string in MySQL?
  10. INSERT … ON DUPLICATE KEY (do nothing)
  11. Define a variable within select and use it within the same select
  12. How to remove new line characters from data rows in mysql?
  13. Merge two tables in one SQL query and make the date values unique
  14. mySQL subquery limit
  15. Making changes to multiple records based on change of single record with SQL
  16. How to increase MySQL connections(max_connections)?
  17. MySQL/SQL: Update with correlated subquery from the updated table itself
  18. COUNT(*) from multiple tables in MySQL
  19. Why the rows returns by “explain” is not equal to count()?
  20. How do I get SUM function in MySQL to return ‘0’ if no values are found?
  21. MySQL LOAD_FILE() loads null values
  22. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  23. MySQL Select ID’s which occur on different rows with multiple specific values for a column
  24. How to compare timestamp dates with date-only parameter in MySQL?
  25. How to sort a MYSQL table in a permanent way?
  26. UPDATE with ORDER BY and LIMIT not working in MYSQL
  27. How do you force mysql LIKE to be case sensitive? [duplicate]
  28. MySQL Alter table causes Error: Invalid use of NULL value
  29. Delete all rows with timestamp older than x days
  30. In what order are MySQL JOINs evaluated?

Leave a Comment