-
Notifications
You must be signed in to change notification settings - Fork 1
Home
Malcolm Slater edited this page Feb 16, 2017
·
4 revisions
This project loads a file in DTF7.3 format into a database.
DTF7.3 is the Data Transfer Format specification used by local councils to export their address data from their LLPG, in a format matching BS 7666:2006.
The data is loaded into a set of database tables - BLPUs, LPIs and Street Descriptors making it easy to list all the addresses and use sql to query them.
The code supports delta files, using DTF lines are marked as Insert, Update or Delete.
The project uses a command line Visual Studio 2015 project with .Net 4.5.2 and Sql Server 2008 R2 and has been designed to be easy to port to different versions/technologies.