| 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 |