If you’re like me, you’ve probably stored latitude and longitude data in decimal columns for a long time. I know SQL Server has a geography type as of a few years ago, but I never really played with it much. Anyway, I finally tried it, and so far it’s great – and no individual decimal columns – and I can do calculations right in SQL.

To get started, use the geography type in a table like this?:

CREATE TABLE [dbo].[MattressStoreLocations](	
[Mattress Store Name] [nvarchar](50) NULL,	
[Location] [geography] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Continue reading “Using SQL Server for Latitude & Longitude Calculations” →