C# Class OSCodePointDataImport.ScaleGazetteerDataImporter

Functionality to load Ordnance Survey 1:50000 Scale Gazetteer data files to SQL Server. The data files are available for download from: https://www.ordnancesurvey.co.uk/opendatadownload/products.html

Inheritance: OSDataImporter

Mostra file Open project: AdaTheDev/Ordnance-Survey-Code-Point-Data-Importer Class Usage Examples

Public Methods

Method	Description
LoadData ( ScaleGazetteerOptions options ) : int	Loads Scale Gazetteer CSV data file into a new table in SQL Server, creating 2 related lookup tables also for the county codes and feature codes
LoadData ( string serverName, string databaseName, string schemaName, string tableName, string dataFile, string countyLookupTableName, string featureLookupTableName ) : int

Private Methods

Method	Description
PrepareTable ( SqlConnection connection, string schemaName, string tableName, string countyTableName, string featureTableName ) : void	Creates a new table in the database ready to receive the Code-Point data.
ReadDataFromFile ( string dataFile ) : DataSet	Reads the data in from the Scale Gazetteer data file into a DataSet containing 3 datatables: 1) main point data 2) county lookup data 3) feature lookup data

Method Details

LoadData() public method

Loads Scale Gazetteer CSV data file into a new table in SQL Server, creating 2 related lookup tables also for the county codes and feature codes

public LoadData ( ScaleGazetteerOptions options ) : int
options	ScaleGazetteerOptions	options
return	int

LoadData() public method

public LoadData ( string serverName, string databaseName, string schemaName, string tableName, string dataFile, string countyLookupTableName, string featureLookupTableName ) : int
serverName	string
databaseName	string
schemaName	string
tableName	string
dataFile	string
countyLookupTableName	string
featureLookupTableName	string
return	int