Schema

We are opening up our intended database schema to try to capture all of the relevant available historical and related data. Please note we have not included document metadata or planning conditions and their relations - we are working on including this. We are welcoming comments on this schema on the ODP slack channel #group-planning-register-data or via email.

Addresses
A physical address, including lat/lng, postcode, which links to a property
View
Local Authorities
A local authority or council
View
Planning Applications
The main planning application data, containing the decision, reviewer, etc, with a link to local authorities
View
Planning Applications Properties
The properties associated with the planning application
View
Properties
A list of properties, indexed by a UPRN
View