What’s the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?

by

Fair Warning! Before taking the advice to use the GEOGRAPHY type, make sure you are not planning on using Linq or Entity Framework to access the data because it’s not supported (as of November 2010) and you will be sad!

Update Jul 2017

For those reading this answer now, it is obsolete as it refers to backdated technology stack. See comments for more details.

More Related Contents:

  1. SQL Server 2008 Spatial: find a point in polygon
  2. If condition in SQL Server 2008
  3. Comma separated results in SQL
  4. Understanding PIVOT function in T-SQL
  5. Which are more performant, CTE or temporary tables?
  6. Using RegEx in SQL Server
  7. How Can I Log and Find the Most Expensive Queries?
  8. Import Excel spreadsheet columns into SQL Server database
  9. SqlServer: Login failed for user
  10. SQL Server 2008 Empty String vs. Space
  11. How do I use the CONCAT function in SQL Server 2008 R2?
  12. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  13. Is it possible to force row level locking in SQL Server?
  14. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  15. How do I get date/time information from a TIMESTAMP column?
  16. How to drop column with constraint?
  17. SQL Server: combining multiple rows into one row
  18. How to add xml encoding to xml Output in SQL Server
  19. SQL Server GUID sort algorithm. Why?
  20. Bulk insert with text qualifier in SQL Server
  21. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  22. Sort Bullets in Database
  23. Unable to login to SQL Server + SQL Server Authentication + Error: 18456
  24. How Can I Detect and Bound Changes Between Row Values in a SQL Table?
  25. In SQL Server, how can I find everywhere a column is referenced?
  26. ‘Incorrect SET Options’ Error When Building Database Project
  27. Table Valued Function Killing My Query Performance
  28. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  29. Why insert-select to variable table from XML variable so slow?
  30. Generate MD5 hash string with T-SQL

Leave a Comment