loading addressbase products
DESCRIPTION
This presentation demonstrations how to load the series of GeoPlace and Ordnance Survey AddressPlace products using GO Loader. The first loading tool to support AddressBase.TRANSCRIPT
Loading AddressBase Products
Address Base is supplied in GML 3.2.1
Supported by GO Loader
Loading into Oracle, SQL Server 2008 or PostGIS.
Includes the best parts of:
What is the Address Base Product Suite?
National Land and Property Gazetteer (NLPG)
OS MasterMap Address Layer 2
Royal Mail Postcode Address File (PAF)
• Create a New Project to load Address Base
Project Management
• Add Project Description and Notes as required
• Add the AddressBase Schema
• Click Parse Schema – GO Loader will quickly parse the GML schema.
Parse the GML Schema
Filter the GML
Ability to filter Feature Types
Or filter Properties
Tanslation Policy
Use Join Tables to link Complex Properties
Translate gml to your database
Expand GML Elements to Translate them to your DatabaseE.g. Basic Land & Property Unit (BLPU) Elements
Joined Tables: E.g. LPIs, Classifications, Delivery point addresses, Organisations, XREFs etc...
Maintain Integrity using Joined Tables...
e.g. Land & Property Identifier (LPI)
LPI Joined TableTranslates GML features to Table columns
Enter the Database Connection Details
Test the Database Connection
Loader Configuration
Spatial Reference
Select from a wide range of spatial reference systems
Tablespace & Partitions
Database Management:Select Tablespaces and Partitions as required
Review Loading Options
Create Tables
Creates tables in your database in preparation for data load
Load Data
Load Progress
Data Load Complete!
Create Indices
Creates indices in your database after your data has loaded
AddressBaseContains Royal Mail PAF Residential and Commercial properties linked to UPRN
AddressBase Plus Sourced from local authorities, Ordnance Survey and Royal Mail Contains OWPA – for example, subdivided properties, places of worship and community centres.
AddressBase PremiumComprehensive dataset detailing property lifecycle
1.
Includes Land Property Identifier
AddressBase PremiumComprehensive dataset detailing property lifecycle
2.
Includes Classification Info
AddressBase PremiumComprehensive dataset detailing property lifecycle
3.
Includes Delivery Point Info
AddressBase PremiumComprehensive dataset detailing property lifecycle
4.
Includes Application XREF Info
AddressBase Premium includes LifecycleProperty Lifecycle
Follow us
www.snowflakesoftware.com
www.youtube.com/snowflakesoftware
www.linkedin.com (GML-group)
twitter.com/sflakesoftware
www.flickr.com/photos/snowflakesoftware/