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

파일 보기 프로젝트 열기: AdaTheDev/Ordnance-Survey-Code-Point-Data-Importer 1 사용 예제들

공개 메소드들

메소드	설명
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