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
• Addresses: View
• Local Authorities: A local authority or council
• Local Authorities: View
• Planning Applications: The main planning application data, containing the decision, reviewer, etc, with a link to local authorities
• Planning Applications: View
• Planning Applications Properties: The properties associated with the planning application
• Planning Applications Properties: View
• Properties: A list of properties, indexed by a UPRN
• Properties: View