Adrian Hills 1/24/2011

GB Post Code Geographic Data Load to SQL Server using .NET

Read Original

This 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.

GB Post Code Geographic Data Load to SQL Server using .NET

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week