Data migration
Move legacy spatial, address or service data into an agreed platform, repository or workflow.
- ETL workflows
- Migration
- Data cleansing
- Scheduled exchange
- Gazetteers
- Reporting extracts
- Public portal feeds
Connecting spatial data across council systems
Local authority spatial data often needs to move between GIS layers, gazetteers, address systems, case-management modules, public portals, reporting tools, databases, files, extracts and third-party services.
Integration work is rarely just a file conversion. The data needs to be understood in context: who owns it, how often it changes, which service depends on it, how it should be checked and what the destination system expects.
What integration work can support
ETL workflows
Extract, transform and load data between agreed sources and destinations where configured.
Data cleansing and transformation
Restructure fields, clean values, convert formats and prepare records for use.
Scheduled imports and exports
Support regular data exchange where the source, destination and timing have been agreed.
File and database exchange
Work with files, extracts, databases and services according to project requirements.
Spatial data validation
Check geometry, attributes and business rules where validation rules are configured.
Gazetteer and address data flows
Connect LLPG, LSG, UPRN and address-led data with GIS and service workflows where licensed.
Reporting extracts
Prepare datasets for reporting, dashboards or operational review.
Third-party system integration
Plan data exchange with other systems where suitable access and interfaces are available.
Public portal data feeds
Prepare appropriate published data for public-facing search or portal services where implemented.
DataPump ETL
DataPump ETL is StatMap's extract, transform and load capability for configured data movement and preparation work. It can help move spatial data into StatMap platforms, prepare extracts for connected systems and support repeatable data workflows where that is part of the implementation.
The exact sources, destinations, schedules, formats and validation rules should be agreed for the project. Real-time or near-real-time data exchange should only be assumed where the source systems, interfaces and support model are designed for it.
Data quality and validation
Data quality checks can help identify issues before or after migration, import or integration activity, depending on the datasets and configured rules.
Spatial validation
Check geometry and spatial relationships where appropriate rules are configured.
Geometry checks
Identify missing, invalid or unexpected geometry before data is relied on.
Attribute checks
Review required values, formats, ranges and coded fields.
Business rules
Apply project-specific rules that reflect service requirements and data ownership.
Import checks
Test loaded data against agreed acceptance criteria.
Reports for review
Create outputs that help data owners review and resolve issues.
Addressing and gazetteer integration
Address data, LLPG, LSG, UPRN and AddressBase-style datasets often need to connect with GIS, case-management systems, reporting datasets and public-facing services. Licensing, data-source availability and update arrangements should be confirmed for the project before implementation decisions are made.
Where integration helps
Local Government Reorganisation
Plan data consolidation across gazetteers, GIS platforms, case-management systems and public portals.
Data Services
Use integration work as part of a wider spatial data audit, migration or consolidation plan.
Corporate GIS
Prepare spatial layers and data access for browser-based GIS.
Gazetteer Management
Connect address and street data with downstream services.
Planning & Building Control
Prepare application, inspection, document and spatial data flows.
Public Portal
Support published datasets, search data and public-facing workflows where implemented.
Discuss your data integration project
Talk to StatMap if you are migrating data, connecting GIS and case-management systems, preparing reporting datasets or reviewing spatial data flows.