GB Post Code Geographic Data Load to SQL Server using .NET
Read OriginalThis article details a process for downloading the free Ordnance Survey Code-Point Open dataset (GB postcodes with Easting/Northing coordinates), converting them to Latitude/Longitude using a specific .NET library (geocoordconversion), and bulk loading the data into SQL Server's GEOGRAPHY column. It includes C# code snippets, steps for creating a spatial index, and an example SQL query for performing proximity searches.
Comments
No comments yet
Be the first to share your thoughts!
Browser Extension
Get instant access to AllDevBlogs from your browser