Back to Recent Schemas

Schema Information

https://raw.githubusercontent.com/iStandUK/BrownfieldLandRegister/master/schema/brownfieldlandregister2017.json

Download schema

Fields

Index Column Heading Required Unique Type Value Constraints Title/Description
1 OrganisationURI Yes No URI Pattern: ^http:\/\/opendatacommunities.org\/id\/
OrganisationURI
To identify the Local Authority within whose area the parcel of land lies.
2 OrganisationLabel Yes No String Maximum Length: 100
OrganisationLabel
The name of the local authority that is identified using the OrganisationURI.
3 SiteReference Yes No String Maximum Length: 50
SiteReference
A reference applied by the local authority to identify a site.
4 PreviouslyPartOf Yes No String Maximum Length: 50
PreviouslyPartOf
The SiteReference that this site was previously a part of when reported on an earlier register.
5 SiteNameAddress Yes No String Maximum Length: 255
SiteNameAddress
The name and address of a site, which should be sufficient to describe its location.
6 SiteplanURL Yes No URI Pattern: ^(http|https):\/\/
SiteplanURL
A URL to a web page giving a site plan for the site.
7 CoordinateReferenceSystem Yes No String Pattern: ^(WGS84|OSGB36|ETRS89)$
CoordinateReferenceSystem
The Coordinate Reference System that is used for the fields GeoX and GeoY.
8 GeoX Yes No Float Pattern: ^[+-]?\d*\.?\d*$
GeoX
Longitude or east grid reference for the visual centroid of the site boundary.
9 GeoY Yes No Float Pattern: ^[+-]?\d*\.?\d*$
GeoY
Latitude or north grid reference for visual of application boundary.
10 Hectares Yes No Float Pattern: ^\d*(\.\d{1,2})?$
Hectares
The size of the land in hectares.
11 OwnershipStatus Yes No String Pattern: ^(owned by a public authority|not owned by a public authority|unknown ownership|mixed ownership)$
OwnershipStatus
The ownership status of the land.
12 Deliverable Yes No String Pattern: ^$|^(yes)$
Deliverable
To indicate if the land is 'Deliverable'.
13 PlanningStatus Yes No String Pattern: ^(permissioned|not permissioned|pending decision)$
PlanningStatus
To indicate the stage, if any, that has been reached in the planning process for the site.
14 PermissionType Yes No String Pattern: ^$|^(full planning permission|outline planning permission|reserved matters approval|permission in principle|technical details consent|planning permission granted under an order|other)$
PermissionType
The latest type of permission that has been granted on the site.
15 PermissionDate Yes No Date
Pattern: ^$|^(?:(?:1[6-9]|[2]\d)\d{2})-(?:(?:0[1-9])|(?:1[0-2]))-(?:0[1-9]|1\d|2[0-8])$|^(?:(?:1[6-9]|[2]\d)\d{2})-(?:(?:(?:(?:0[13578]|1[02]))-31)|(?:(?:0[1,3-9]|1[0-2])-(?:29|30)))$|^(?:(?:(?:1[6-9]|2\d)(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|2[048])00))-02-29)$
PermissionDate
The date permission was granted for the permission set out in the field PermissionType.
16 PlanningHistory Yes No URI Pattern: ^$|^(http|https):\/\/[^\| ]+(\|(http|https):\/\/[^\| ]+)*$
PlanningHistory
Links to webpages giving information about the planning history of the site.
17 ProposedForPIP Yes No String Pattern: ^$|^(yes)$
ProposedForPIP
To indicate if the site has been proposed for residential development (permission in principle).
18 MinNetDwellings Yes No Float MinNetDwellings
The minimum net number of dwellings that the local authority estimates the site should support.
19 DevelopmentDescription Yes No String Maximum Length: 4000
DevelopmentDescription
A description of any proposed housing development.
20 NonHousingDevelopment Yes No String Maximum Length: 4000
NonHousingDevelopment
A description of any proposed non-housing development
21 Part2 Yes No String Pattern: ^$|^(yes)$
Part2
To indicate that a site is in Part 2 of the register.
22 NetDwellingsRangeFrom Yes No Float NetDwellingsRangeFrom
The minimum net number of dwellings which, in the authority’s opinion, the land is capable of supporting.
23 NetDwellingsRangeTo Yes No Float NetDwellingsRangeTo
The maximum net number of dwellings which, in the authority’s opinion, the land is capable of supporting.
24 HazardousSubstances Yes No String Pattern: ^$|^(yes)$
HazardousSubstances
To indicate the presence of certain characteristics of the site.
25 SiteInformation Yes No URI Pattern: ^$|^(http|https):\/\/[^\| ]+(\|(http|https):\/\/[^\| ]+)*$
SiteInformation
Links to webpages giving further information about the site.
26 Notes Yes No String Maximum Length: 4000
Notes
General information about a site and its entry on the register.
27 FirstAddedDate Yes No Date
Pattern: ^$|^(?:(?:1[6-9]|[2]\d)\d{2})-(?:(?:0[1-9])|(?:1[0-2]))-(?:0[1-9]|1\d|2[0-8])$|^(?:(?:1[6-9]|[2]\d)\d{2})-(?:(?:(?:(?:0[13578]|1[02]))-31)|(?:(?:0[1,3-9]|1[0-2])-(?:29|30)))$|^(?:(?:(?:1[6-9]|2\d)(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|2[048])00))-02-29)$
FirstAddedDate
The date that the site was first added to the register.
28 LastUpdatedDate Yes No Date
Pattern: ^$|^(?:(?:1[6-9]|[2]\d)\d{2})-(?:(?:0[1-9])|(?:1[0-2]))-(?:0[1-9]|1\d|2[0-8])$|^(?:(?:1[6-9]|[2]\d)\d{2})-(?:(?:(?:(?:0[13578]|1[02]))-31)|(?:(?:0[1,3-9]|1[0-2])-(?:29|30)))$|^(?:(?:(?:1[6-9]|2\d)(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|2[048])00))-02-29)$
LastUpdatedDate
The date that information about the site was last updated.
Download Example CSV File