Back to Recent Schemas

Schema Information

http://schemas.esd.org.uk/planningapplications/PlanningApplications.json

Download schema

Fields

Index Column Heading Required Unique Type Value Constraints Title/Description
1 ExtractDate Yes No String Pattern: (^([0-2]\d|[3][0-1])\/([0]\d|[1][0-2])\/[1-2]\d{3}((\s([0-1]\d|[2][0-3]):[0-5]\d(:[0-5]\d)?)?)|)$
Extract Date
The date that the data was last extracted from its source database
2 PublisherURI Yes No URI Publisher URI
URI from ODC of publishing organisation
3 PublisherLabel Yes No String Publisher Label
Label of publishing organisation
4 OrganisationURI Yes No URI Organisation URI
URI from ODC of planning authority
5 OrganisationLabel Yes No String Organisation Label
Label of planning authority. If empty uses this will be the same as the publishing organisation
6 CaseReference Yes No String Case Reference
Reference given to an application on submission. Unique within the planning authority
7 CaseURL Yes No URI Case URL
URL to Web Page giving information about the application. Should be present because of council duty to publish
8 CaseDate Yes No String Pattern: (^([0-2]\d|[3][0-1])\/([0]\d|[1][0-2])\/[1-2]\d{3}((\s([0-1]\d|[2][0-3]):[0-5]\d(:[0-5]\d)?)?)|)$
Case Date
Date on which a valid application was received (even if the validity check was later). This is the date from which the target decision date is set.
9 ServiceTypeURI Yes No URI Service Type URI
Service URI from http://id.esd.org.uk/list/services
10 ServiceTypeLabel Yes No String Service Type Label
Label of the Service Type URI
11 ClassificationURI Yes No String Classification URI
‘Q’ and ‘R’ codes are associated with applications so that data can be ‘returned’ to DCLG. Examples include: Q3 General Industry / storage / warehousing Q4 Retail distribution and servicing Q5 Gypsy and Traveller pitches which also group into ‘Major Developments’ and ‘Minor Developments’. It is possible that this information is NOT recorded with the application. The Department for Communities and Local Government will publish a list of ‘Categories’ as a SKOS list.
12 ClassificationLabel Yes No String Classification Label
Label of the Classification URI
13 CaseText Yes No String Case Text
Text from the applicant on the proposal
14 LocationText Yes No String Location Text
The location of the application as described by the applicant. Will have new lines
15 DecisionTargetDate Yes No String Pattern: (^([0-2]\d|[3][0-1])\/([0]\d|[1][0-2])\/[1-2]\d{3}((\s([0-1]\d|[2][0-3]):[0-5]\d(:[0-5]\d)?)?)|)$
Decision Target Date
The date the application should be determined by. Optional because not relevant once an application is complete
16 Status Yes No String Pattern: (Pending|Withdrawn|Decided|Appealed|)
Status
The status at the extracted date
17 CoordinateReferenceSystem Yes No String Pattern: (WGS84|OSGB36|)
Co-ordinate Reference System
‘WGS84’ (http://en.wikipedia.org/wiki/WGS84) or ‘OSGB36’ (http://en.wikipedia.org/wiki/Ordnance_Survey_National_Grid). WGS84 is the default.
18 GeoX Yes No Float Geo X
Longitude or east grid reference for centroid of application boundary
19 GeoY Yes No Float Geo Y
Latitude or north grid reference for centroid of application boundary
20 GeoPointLicensingURL Yes No URI Geo Point Licensing URL
URL of any page that describes any licensing restrictions on using the northing and easting.
21 DecisionDate Yes No String Pattern: (^([0-2]\d|[3][0-1])\/([0]\d|[1][0-2])\/[1-2]\d{3}((\s([0-1]\d|[2][0-3]):[0-5]\d(:[0-5]\d)?)?)|)$
Decision Date
The date on which the decision was made by the authority on the application. Different from target decision date!
22 Decision Yes No String Pattern: (Approve|Refuse|Split|Withdrawn|Prior not required|Prior granted|Prior refused|Prior refused permission required|)
Decision
The decision of the planning authority on the application
23 DecisionType Yes No String Pattern: (Delegated powers|Case officer|Planning committee|)
Decision Type
To indicate how the decision will be (or was) made
24 DecisionNoticeDate Yes No String Pattern: (^([0-2]\d|[3][0-1])\/([0]\d|[1][0-2])\/[1-2]\d{3}((\s([0-1]\d|[2][0-3]):[0-5]\d(:[0-5]\d)?)?)|)$
Decision Notice Date
Decision Notice Date
25 AppealRef Yes No String Appeal Reference
Planning inspectorate reference. Should be unique nationally. This probably comes from another body and so may not be known
26 AppealDecisionDate Yes No String Pattern: (^([0-2]\d|[3][0-1])\/([0]\d|[1][0-2])\/[1-2]\d{3}((\s([0-1]\d|[2][0-3]):[0-5]\d(:[0-5]\d)?)?)|)$
Appeal Decision Date
The date of the decision from the appeal process. Should only be present if the status indicates an appeal.
27 AppealDecision Yes No String Pattern: (Dismissed|Enforcement notice modified|Upheld|Withdrawn|)
Appeal Decision
The decision of an appeal. Should only be present if the status indicates an appeal. MUST NOT overwrite council's original decision.
28 GeoAreaURI Yes No String Geo Area URI
A predefined spatial area that the application is contained in. Note that these can be derived from X/Y co-ordinates. Comma delimit in spreadsheet where there is more than one
29 GeoAreaLabel Yes No String Geo Area Label
Labels of the Geo Area URI. Comma delimit in spreadsheet where there is more than one
30 GroundArea Yes No Float Ground Area
The ground area of the boundary in square meters
31 UPRN Yes No String UPRN
Unique Property Reference Number. Reference to the land or property which is the subject of the application
32 Agent Yes No String Agent
Agent
33 PublicConsultationStartDate Yes No String Pattern: (^([0-2]\d|[3][0-1])\/([0]\d|[1][0-2])\/[1-2]\d{3}((\s([0-1]\d|[2][0-3]):[0-5]\d(:[0-5]\d)?)?)|)$
Public Consultation Start Date
The date from which the public can make representations about the application
34 PublicConsultationEndDate Yes No String Pattern: (^([0-2]\d|[3][0-1])\/([0]\d|[1][0-2])\/[1-2]\d{3}((\s([0-1]\d|[2][0-3]):[0-5]\d(:[0-5]\d)?)?)|)$
Public Consultation End Date
The date up to which the public can make representations about the application
35 ResponsesFor Yes No Non-Negative Integer Responses For
The number of representations received during the public consultation period which were supportive
36 ResponsesAgainst Yes No Non-Negative Integer Responses Against
The number of representations received during the public consultation period which were unsupportive
Download Example CSV File