What datatype to use when storing latitude and longitude data in SQL databases? [duplicate]

by

For latitudes use: Decimal(8,6), and longitudes use: Decimal(9,6)

If you’re not used to precision and scale parameters, here’s a format string visual:

Latitude and Longitude
##.###### and ###.######

To 6 decimal places should get you to around ~10cm of accuracy on a coordinate.

More Related Contents:

  1. How does database indexing work? [closed]
  2. Insert into … values ( SELECT … FROM … )
  3. Refactor a PL/pgSQL function to return the output of various SELECT queries
  4. What is the difference between Left, Right, Outer and Inner Joins? [duplicate]
  5. IN vs OR in the SQL WHERE Clause
  6. Where is |DataDirectory| defined?
  7. MySQL not using indexes with WHERE IN clause?
  8. When to use SQL Table Alias
  9. What is the difference between using a cross join and putting a comma between the two tables?
  10. PostgreSQL parameterized Order By / Limit in table function
  11. why is null not equal to null false
  12. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  13. What are the benefits of using database cursor?
  14. What is semi-join in database?
  15. Procedure or function !!! has too many arguments specified
  16. The backend version is not supported to design database diagrams or tables
  17. SQL query that gives distinct results that match multiple columns
  18. Android multiple databases open
  19. What is it exactly a BLOB in a DBMS context
  20. Composite Primary Keys : Good or Bad?
  21. Is there a version control system for database structure changes?
  22. Using a database table as a queue
  23. How do I change db schema to dbo
  24. What is the best way to implement soft deletion?
  25. PostgreSQL how to create a copy of a database or schema?
  26. Query a Table’s Foreign Key relationships
  27. Historical / auditable database
  28. Postgres: convert single row to multiple rows (unpivot)
  29. How to store a list in a db column
  30. Copy table structure to new table in sqlite3

Leave a Comment