I’ve just pushed some updates to GitHub for the Ordnance Survey Data Importer .NET app I’ve been working on every now and then (see my previous posts: GB Post Code Geographic Data Load to SQL Server using .NET and OS CodePoint Data Geography Load Update).
Aside from a little re-jigging to potentially pave the way to load more Ordnance Survey data files to SQL Server in the future, it now supports importing the 1:50000 Scale Gazetteer data file to SQL Server (available to download from here). To quote the Ordnance Survey site:
The 1:50 000 Scale Gazetteer is a reference tool or location finder, similiar to the index in a road atlas. It can be used as a simple list to find out relevant coordinates and six-figure grid references for a town or area.
At the time of this post this data file contains 259,113 locations taken from the OS Landranger Map series.
To load the 1:50000 scale gazetteer data file that has been downloaded and extracted to C:\OSGazetteerData\50kgaz2010.txt, into dbo.Gazetteer table in MyDatabase on server SQLServerA, and load county codes into table: County and feature codes into table: Feature, run the following from the command prompt:
OSCodePointDataImport.exe GAZETTEER SQLServerA MyDatabase dbo Gazetteer County Feature "C:\OSGazetteerData\50kgaz2010.txt"
The Gazetteer database table will consist of the following columns:
SeqNo INTEGER PRIMARY KEY PlaceName VARCHAR(60) CountyCode CHAR(2) FK to County.Code FeatureCode VARCHAR(3) FK to Feature.Code Longitude FLOAT Latitude FLOAT GeoLocation GEOGRAPHY
The County lookup table will consist of the following columns:
Code CHAR(2) PRIMARY KEY Name VARCHAR(60)
The Feature lookup table will consist of the following columns:
Code VARCHAR(3) PRIMARY KEY Description VARCHAR(50)
The source is on GitHub here: https://github.com/AdaTheDev/Ordnance-Survey-Code-Point-Data-Importer