Skip to content

Instantly share code, notes, and snippets.

@brazilnut2000

brazilnut2000/GeolocationFromLatLon.sql

Created August 23, 2013 21:27
Show Gist options
  • Save brazilnut2000/6324209 to your computer and use it in GitHub Desktop.
Save brazilnut2000/6324209 to your computer and use it in GitHub Desktop.
Download ZIP
SQL: Populate GeoLocation table from Latitude and Longitude
Raw
GeolocationFromLatLon.sql
/*
Assumes table has populated Latitude and Longitude columns
Populates the GeoLocation column from Lat ad Lon
*/
UPDATE [dbo].[TableX]
SET [GeoLocation] = geography::Parse('POINT(' + CAST([Longitude] AS VARCHAR(20)) + ' ' +
CAST([Latitude] AS VARCHAR(20)) + ')')
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment