C# Класс 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

Наследование: OSDataImporter

Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод	Описание
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

Приватные методы

Метод	Описание
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

Описание методов

LoadData() публичный Метод

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
Результат	int

LoadData() публичный Метод

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
Результат	int