Register record·DATASET·GB·GOVERNMENTVERIFIED · checked 66m ago
B
Brownfield Register 2021
A register of previously developed (brownfield) land maintained by Leicester City Council, published in line with the UK government's brownfield land data standard. The dataset lists identified sites, including those that have been completed or have expired; such sites are not removed from the register but can be filtered out using the 'ENDDATE' column. Users are advised to consult the government data standard before use to avoid misinterpretation of the dataset's fields and status codes.Register of previously developed (brownfield) land. NB. Completed/expired sites are NOT removed but can be filtered out by 'ENDDATE' column. To avoid misuse please read government data standard.
Trust score
How is this computed?36
poor
Weighted across five axes. Tap a ring for what it measures.
Data schema (26 fields)
Click a field to see example values.
| Field | Type | Description |
|---|---|---|
| ORGANISATIONURI | text | URI identifying the local authority responsible for the register.URI identifying the local authority responsible for the register. |
| ORGANISATIONLABEL | text | Name of the local authority responsible for the register.Name of the local authority responsible for the register. |
| SITEREFERENCE | text | Unique reference code identifying the brownfield site.Unique reference code identifying the brownfield site. |
| SITENAMEADDRESS | text | Name and/or address of the brownfield site.Name and/or address of the brownfield site. |
| GEOX | number | Easting coordinate of the site location.Easting coordinate of the site location. |
| GEOY | number | Northing coordinate of the site location.Northing coordinate of the site location. |
| SITEPLANURL | text | Web link to a map or plan of the site.Web link to a map or plan of the site. |
| COORDINATEREFERENCESYSTEM | text | Coordinate system used for the site's GEOX/GEOY values.Coordinate system used for the site's GEOX/GEOY values. |
| HECTARES | number | Area of the site in hectares.Area of the site in hectares. |
| OWNERSHIPSTATUS | text | Indicates whether the site is owned by a public authority.Indicates whether the site is owned by a public authority. |
| PLANNINGSTATUS | text | Current planning permission status of the site.Current planning permission status of the site. |
| PERMISSIONTYPE | text | Type of planning permission granted for the site.Type of planning permission granted for the site. |
| PERMISSIONDATE | date | Date planning permission was granted.Date planning permission was granted. |
| PLANNINGHISTORY | text | Link to the site's planning application history.Link to the site's planning application history. |
| DELIVERABLE | boolean | Indicates whether the site is considered deliverable for housing.Indicates whether the site is considered deliverable for housing. |
| NETDWELLINGSRANGEFROM | int | Lower estimate of net additional dwellings the site could provide.Lower estimate of net additional dwellings the site could provide. |
| NETDWELLINGSRANGETO | int | Upper estimate of net additional dwellings the site could provide.Upper estimate of net additional dwellings the site could provide. |
| PART2 | text | Indicates whether the site is included in Part 2 of the register.Indicates whether the site is included in Part 2 of the register. |
| HAZARDOUSSUBSTANCES | text | Details of any hazardous substances present on the site.Details of any hazardous substances present on the site. |
| NOTES | text | Additional notes or comments about the site.Additional notes or comments about the site. |
| FIRSTADDEDDATE | date | Date the site was first added to the register.Date the site was first added to the register. |
| LASTUPDATEDDATE | date | Date the site's record was last updated.Date the site's record was last updated. |
| ENDDATE | date | Date the site was removed or expired from the register.Date the site was removed or expired from the register. |
| SHELAA_REFShelaa ref | int | Reference number linking to the Strategic Housing Land Availability Assessment.Reference number linking to the Strategic Housing Land Availability Assessment. |
| APPLICATION_NUMBERApplication number | int | Planning application number associated with the site.Planning application number associated with the site. |
| PPRN | text | Previously Permitted/Registered site reference number.Previously Permitted/Registered site reference number. |
Schema inferred from the distribution file's first records 27 days ago. Column types are sampled estimates, not source-declared.
Query the data
Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.
=
Sample data (5 records)
Record 1GEOX: 458698.0 · GEOY: 303877.0
{
"GEOX": "458698.0",
"GEOY": "303877.0",
"PPRN": "MOH1794",
"NOTES": "",
"PART2": "",
"ENDDATE": "",
"HECTARES": "0.45",
"SHELAA_REF": "20251",
"DELIVERABLE": "",
"SITEPLANURL": "",
"SITEREFERENCE": "MOH1794_20221990",
"FIRSTADDEDDATE": "2021-12-31",
"PERMISSIONDATE": "",
"PERMISSIONTYPE": "",
"PLANNINGSTATUS": "pending decision",
"LASTUPDATEDDATE": "",
"ORGANISATIONURI": "http://opendatacommunities.org/id/unitary-authority/leicester",
"OWNERSHIPSTATUS": "not owned by a public authority",
"PLANNINGHISTORY": "https://planning.leicester.gov.uk/search/Standard?PlanningWhereClause=pprn=%22MOH1794%22",
"SITENAMEADDRESS": "James House, 55 Welford Road",
"ORGANISATIONLABEL": "Leicester City Council",
"APPLICATION_NUMBER": "20221990",
"HAZARDOUSSUBSTANCES": "",
"NETDWELLINGSRANGETO": "247",
"NETDWELLINGSRANGEFROM": "19",
"COORDINATEREFERENCESYSTEM": "OSGB36"
}Record 2GEOX: 459178.0 · GEOY: 304987.0
{
"GEOX": "459178.0",
"GEOY": "304987.0",
"PPRN": "NMB8286",
"NOTES": "",
"PART2": "",
"ENDDATE": "2021-12-31",
"HECTARES": "0.06",
"SHELAA_REF": "187",
"DELIVERABLE": "",
"SITEPLANURL": "",
"SITEREFERENCE": "NMB8286",
"FIRSTADDEDDATE": "2017-12-31",
"PERMISSIONDATE": "",
"PERMISSIONTYPE": "",
"PLANNINGSTATUS": "not permissioned",
"LASTUPDATEDDATE": "2021-12-31",
"ORGANISATIONURI": "http://opendatacommunities.org/id/unitary-authority/leicester",
"OWNERSHIPSTATUS": "not owned by a public authority",
"PLANNINGHISTORY": "https://planning.leicester.gov.uk/search/Standard?PlanningWhereClause=pprn=%22NMB8286%22",
"SITENAMEADDRESS": "4 Wheat Street",
"ORGANISATIONLABEL": "Leicester City Council",
"APPLICATION_NUMBER": "",
"HAZARDOUSSUBSTANCES": "",
"NETDWELLINGSRANGETO": "",
"NETDWELLINGSRANGEFROM": "",
"COORDINATEREFERENCESYSTEM": "OSGB36"
}Record 3GEOX: 458.147 · GEOY: 305.724
{
"GEOX": "458.147",
"GEOY": "305.724",
"PPRN": "LKB1912",
"NOTES": "",
"PART2": "",
"ENDDATE": "",
"HECTARES": "1.25",
"SHELAA_REF": "1038",
"DELIVERABLE": "",
"SITEPLANURL": "",
"SITEREFERENCE": "LKB1912",
"FIRSTADDEDDATE": "2021-12-31",
"PERMISSIONDATE": "",
"PERMISSIONTYPE": "",
"PLANNINGSTATUS": "not permissioned",
"LASTUPDATEDDATE": "",
"ORGANISATIONURI": "http://opendatacommunities.org/id/unitary-authority/leicester",
"OWNERSHIPSTATUS": "not owned by a public authority",
"PLANNINGHISTORY": "https://planning.leicester.gov.uk/search/Standard?PlanningWhereClause=pprn=%22LKB1912%22",
"SITENAMEADDRESS": "Devonshire Road",
"ORGANISATIONLABEL": "Leicester City Council",
"APPLICATION_NUMBER": "",
"HAZARDOUSSUBSTANCES": "",
"NETDWELLINGSRANGETO": "31",
"NETDWELLINGSRANGEFROM": "31",
"COORDINATEREFERENCESYSTEM": "OSGB36"
}Record 4GEOX: 456749.0 · GEOY: 299946.0
{
"GEOX": "456749.0",
"GEOY": "299946.0",
"PPRN": "IWC7676",
"NOTES": "",
"PART2": "",
"ENDDATE": "",
"HECTARES": "0.26",
"SHELAA_REF": "1051",
"DELIVERABLE": "",
"SITEPLANURL": "",
"SITEREFERENCE": "IWC7676",
"FIRSTADDEDDATE": "2021-12-31",
"PERMISSIONDATE": "",
"PERMISSIONTYPE": "",
"PLANNINGSTATUS": "not permissioned",
"LASTUPDATEDDATE": "",
"ORGANISATIONURI": "http://opendatacommunities.org/id/unitary-authority/leicester",
"OWNERSHIPSTATUS": "Owned by a public authority",
"PLANNINGHISTORY": "https://planning.leicester.gov.uk/search/Standard?PlanningWhereClause=pprn=%22IWC7676%22",
"SITENAMEADDRESS": "Gilmorton Community Rooms/Hopyard Close shops",
"ORGANISATIONLABEL": "Leicester City Council",
"APPLICATION_NUMBER": "",
"HAZARDOUSSUBSTANCES": "",
"NETDWELLINGSRANGETO": "8",
"NETDWELLINGSRANGEFROM": "8",
"COORDINATEREFERENCESYSTEM": "OSGB36"
}Record 5GEOX: 458873.0 · GEOY: 304938.0
{
"GEOX": "458873.0",
"GEOY": "304938.0",
"PPRN": "MLW1221",
"NOTES": "",
"PART2": "",
"ENDDATE": "",
"HECTARES": "6.17",
"SHELAA_REF": "609",
"DELIVERABLE": "",
"SITEPLANURL": "",
"SITEREFERENCE": "MLW1221",
"FIRSTADDEDDATE": "2021-12-31",
"PERMISSIONDATE": "",
"PERMISSIONTYPE": "",
"PLANNINGSTATUS": "not permissioned",
"LASTUPDATEDDATE": "",
"ORGANISATIONURI": "http://opendatacommunities.org/id/unitary-authority/leicester",
"OWNERSHIPSTATUS": "mixed ownership",
"PLANNINGHISTORY": "https://planning.leicester.gov.uk/search/Standard?PlanningWhereClause=pprn=%22MLW1221%22",
"SITENAMEADDRESS": "Mansfield Street",
"ORGANISATIONLABEL": "Leicester City Council",
"APPLICATION_NUMBER": "",
"HAZARDOUSSUBSTANCES": "",
"NETDWELLINGSRANGETO": "309",
"NETDWELLINGSRANGEFROM": "309",
"COORDINATEREFERENCESYSTEM": "OSGB36"
}Live sample captured at profiling time — values may have changed upstream.
Verification Status
Using the API
Query examples
curl -sL 'https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/brownfield-register-2021/exports/csv?use_labels=true' -o data.csvFull csv file download — the schema shown was inferred from the file's first records.
Dataset
Volume & freshness
Data size
63 KB
License
No license declared upstream.
○ Documentation○ Data dictionary○ Versioning
Distributions (9)
brownfield-register-2021.rdf
https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/brownfield-register-2021/exports/rdfxml●
brownfield-register-2021.parquet
https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/brownfield-register-2021/exports/parquetParquet●
brownfield-register-2021.csv
https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/brownfield-register-2021/exports/csv?use_labels=trueCSV
brownfield-register-2021.n3
https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/brownfield-register-2021/exports/n3N3
brownfield-register-2021.jsonl
https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/brownfield-register-2021/exports/jsonlJSON
brownfield-register-2021.json
https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/brownfield-register-2021/exports/jsonJSON
brownfield-register-2021.jsonld
https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/brownfield-register-2021/exports/jsonldbrownfield-register-2021.ttl
https://data.leicester.gov.uk/api/explore/v2.1/catalog/datasets/brownfield-register-2021/exports/turtle