{"links": [{"rel": "self", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ukpn-secondary-sites"}, {"rel": "datasets", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets"}, {"rel": "attachments", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ukpn-secondary-sites/attachments"}, {"rel": "reuses", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ukpn-secondary-sites/reuses"}, {"rel": "static_exports", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ukpn-secondary-sites/static_exports"}], "dataset": {"visibility": "domain", "dataset_id": "ukpn-secondary-sites", "dataset_uid": "da_r31wbk", "has_records": true, "features": ["geo", "analyze"], "attachments": [{"id": "data_triage_secondary_sitesxlsx", "title": "Data Triage - Secondary sites.xlsx", "mimetype": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "url": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ukpn-secondary-sites/attachments/data_triage_secondary_sitesxlsx"}], "alternative_exports": [], "data_visible": false, "fields": [{"name": "localauthority", "description": "Local Authority where the site resides\n", "annotations": {"facet": true, "facetsort": "alphanum"}, "label": "localauthority", "type": "text"}, {"name": "functionallocation", "description": "This is the Secondary Site or Pole System alias in both the Network Control and Asset Management System.", "annotations": {"facet": true}, "label": "functionallocation", "type": "text"}, {"name": "dno", "description": "This holds the Licence Area or DNO (Distribution Network Operator) name", "annotations": {"facet": true}, "label": "DNO", "type": "text"}, {"name": "substationalias", "description": "Site or Overhead Site reference\n", "annotations": {"facet": true}, "label": "substationalias", "type": "text"}, {"name": "substationdesign", "description": "Type of substation.  Pole Mounted Transformer (PMT), Ground Mounted Transformer (GMT), Ground Mounted Site (GMS).", "annotations": {"facet": true, "disjunctive": true}, "label": "substationdesign", "type": "text"}, {"name": "substationvoltage", "description": "Highest voltage on the site", "annotations": {"facet": true, "unit": "kV", "disjunctive": true, "sortable": true, "facetsort": "-count"}, "label": "SubstationVoltage", "type": "text"}, {"name": "numberoftransformers", "description": "Number of transformers on the site", "annotations": {"facet": true}, "label": "numberoftransformers", "type": "int"}, {"name": "utilisation_band", "description": null, "annotations": {}, "label": "Utilisation Band", "type": "text"}, {"name": "demand_headroom", "description": "This is 1 minus the Utilisation Band", "annotations": {"facet": true}, "label": "demand_headroom", "type": "text"}, {"name": "onanrating", "description": "Total kVA rating of the site", "annotations": {"unit": "kVA"}, "label": "onanrating", "type": "text"}, {"name": "source", "description": "This column indicated whether the data was sourced from physical monitoring or modelling powered by real-time data from monitoring, smart meter data and third-party data.", "annotations": {"facet": true}, "label": "Source", "type": "text"}, {"name": "primaryfeeder", "description": "Primary Substation Name", "annotations": {}, "label": "primaryfeeder", "type": "text"}, {"name": "confinedspace", "description": null, "annotations": {}, "label": "confinedspace", "type": "text"}, {"name": "customer_count", "description": null, "annotations": {}, "label": "CustomerCount", "type": "int"}, {"name": "companyarea", "description": "UK Power Networks Operational Area", "annotations": {}, "label": "companyarea", "type": "text"}, {"name": "localauthoritycode", "description": "Local Authority Code where the site resides", "annotations": {}, "label": "localauthoritycode", "type": "text"}, {"name": "llsoaname", "description": "Lower Later Super Output Area (LLSOA) boundary name", "annotations": {"sortable": true}, "label": "llsoaname", "type": "text"}, {"name": "llsoacode", "description": "Lower Later Super Output Area (LLSOA) boundary code", "annotations": {}, "label": "llsoacode", "type": "text"}, {"name": "parishname", "description": "Village name or part of the town where the substation resides.", "annotations": {"sortable": true}, "label": "parishname", "type": "text"}, {"name": "parishcode", "description": "Village code or part of the town where the substation resides.", "annotations": {}, "label": "parishcode", "type": "text"}, {"name": "postcode", "description": "Postcode location of the site.", "annotations": {}, "label": "postcode", "type": "text"}, {"name": "latitude", "description": "Site Latitude", "annotations": {"decimals": 8, "facetsort": "-count"}, "label": "Latitude", "type": "text"}, {"name": "longitude", "description": "Site Longitude", "annotations": {"decimals": 8}, "label": "Longitude", "type": "double"}, {"name": "indooroutdoor", "description": "'Indoor' is calculated as the substation geometry intersecting with an Ordnance Survey Master Map building area geometry (feature code 10021) otherwise 'outdoor'", "annotations": {"facet": true}, "label": "indooroutdoor", "type": "text"}, {"name": "buildinguprn", "description": "Where the site is contained within a building, this is the Unique Property Reference Number (UPRN)", "annotations": {}, "label": "buildinguprn", "type": "text"}, {"name": "buildingaddress", "description": "Where the site is contained within a building, this is the Address", "annotations": {}, "label": "buildingaddress", "type": "text"}, {"name": "buildingpostcode", "description": "Where the site is contained within a building, this is the postcode", "annotations": {}, "label": "buildingpostcode", "type": "text"}, {"name": "gridref", "description": "Site Grid reference.", "annotations": {}, "label": "gridref", "type": "text"}, {"name": "geopoint", "description": "Spatial coordinates of the site.\n", "annotations": {}, "label": "geopoint", "type": "geo_point_2d"}, {"name": "what3words", "description": null, "annotations": {}, "label": "what3words", "type": "text"}, {"name": "predicted_year_of_reinforcement", "description": null, "annotations": {}, "label": "Predicted year of reinforcement", "type": "text"}, {"name": "accessstreet", "description": "The street that contains the access point to the site.", "annotations": {}, "label": "accessstreet", "type": "text"}, {"name": "primaryfeederfunctionallocation", "description": "Functional Location of the primary feeding substation", "annotations": {}, "label": "primaryfeederfunctionallocation", "type": "text"}], "metas": {"dcat": {"created": null, "issued": null, "creator": null, "contributor": null, "contact_name": null, "contact_email": null, "accrualperiodicity": null, "spatial": null, "temporal": null, "granularity": null, "dataquality": null, "publisher_type": null, "conforms_to": null, "temporal_coverage_start": null, "temporal_coverage_end": null, "accessRights": null, "relation": null}, "inspire": {"theme": null, "type": null, "file_identifier": null, "hierarchy_level": null, "hierarchy_level_name": null, "spatial_resolution": null, "topologic_consistency": null, "contact_individual_name": null, "contact_position": null, "contact_address": null, "contact_email": null, "identification_purpose": null, "extend_description": null, "extend_bounding_box_westbound_longitude": null, "extend_bounding_box_eastbound_longitude": null, "extend_bounding_box_southbound_latitude": null, "extend_bounding_box_northbound_latitude": null}, "default": {"title": "UK Power Networks Secondary Sites", "description": "<h2 class=\"\">Introduction</h2><p>This dataset shows our secondary sites and a number of attributes including oil natural air natural (ONAN) ratings, spatial coordinates, customer counts, whether a site is indoor/outdoor, the address, substation name, alias and its primary feeder.</p>\n\n<p><span>Note: as of 18 April 2024, we have included an additional column showing the utilisation band of the site. The utilisation bands do not indicate contractually committed capacity e.g. capacity on our network may be unused now but expected to be used by a connection in a future year, recent acceptances which will be covered in next year's data.</span></p>\n\n<p><span>There is a site classification as follows:</span></p>\n\n<ul><li>GMT: Ground Mounted Transformer; and</li><li>PMT: Pole Mounted Transformer.</li></ul>\n\n<p>As per the attached triage document, we have redacted sites from this dataset where a transformer serves five or less customers. This is in the interest of protecting customer privacy. Further, we are aware that for a small number of records there are null values, this is primarily for the rare cases where sites have more than one transformer. There is an ongoing review into how this is recorded, which will be reflected in the data once resolved. If you notice any errors, please let us know by feedbacking against the record in the table tab.</p>\n\n<h2>Methodological Approach</h2>\n    <ul>\n        <li>Data Extraction: This dataset is extracted from Azure Databricks.</li>\n        <li>Combination: Various data columns are joined in Azure Databricks based on the FLOC. This includes Grid Reference, connectivity and the number of customers.</li>\n<li>Processing: There are some processing, such as conversion of Grid Reference into longitude and latitude.</li>\n    </ul>\n\n<h2>Quality Control Statement</h2>\n<p>\nQuality Control Measures include:\n<ul>\n<li>Verification steps to match features only with confirmed functional locations. </li>\n<li>Manual review and correct of data inconsistencies</li>\n<li>Use of additional verification steps to ensure accuracy in the methodology</li>\n</ul>\n</p>\n\n<h2>Assurance Statement</h2>\n<p>The Open Data Team checked to ensure data accuracy and consistency.</p>\n\n<h2>Other</h2>\n<p>Download dataset information: <a href=\"https://ukpowernetworks.opendatasoft.com/explore/dataset/domain-dataset0/download/?format=json&amp;refine.identifier=ukpn-secondary-sites\">Metadata (JSON)</a></p>\n\n<p><span>Definitions of key terms related to this dataset can be found in the Open Data Portal Glossary:</span><a href=\"https://ukpowernetworks.opendatasoft.com/pages/glossary/\" target=\"_blank\">https://ukpowernetworks.opendatasoft.com/pages/glossary/</a><a href=\"https://ukpowernetworks.opendatasoft.com/pages/glossary/\" target=\"_blank\"></a></p><p>To view this data please register and login.</p>", "theme": ["Network Infrastructure"], "keyword": null, "license": "CC BY 4.0", "license_url": "https://creativecommons.org/licenses/by/4.0/", "language": "en", "metadata_languages": ["en"], "timezone": null, "modified": "2025-12-09T15:34:19.013000+00:00", "modified_updates_on_metadata_change": false, "modified_updates_on_data_change": true, "data_processed": "2025-12-09T15:34:19.013000+00:00", "metadata_processed": "2025-12-09T15:34:19.081000+00:00", "geographic_reference": null, "geographic_reference_auto": false, "territory": null, "geometry_types": ["Point"], "bbox": {"type": "Feature", "geometry": {"coordinates": [[[1.7583219520747662, 52.965555978007615], [-1.1072020512074232, 52.965555978007615], [-1.1072020512074232, 50.74359596706927], [1.7583219520747662, 50.74359596706927], [1.7583219520747662, 52.965555978007615]]], "type": "Polygon"}, "properties": {}}, "publisher": "UK Power Networks, Company number 3870728", "references": null, "records_count": 72750, "attributions": ["Office for National Statistics licensed under the Open Government Licence v.3.0 Contains OS data \u00a9 Crown copyright and database right [2019-]"], "source_domain": null, "source_domain_title": null, "source_domain_address": null, "source_dataset": null, "shared_catalog": null, "federated": false, "parent_domain": null, "update_frequency": ["ANNUAL"]}, "dublin-core": {"title": "UK Power Networks Secondary Sites", "alternative": null, "subject": ["Secondary Substation", "Transformers", "Geospatial"], "description": "<h2 class=\"\">Introduction</h2><p>This dataset shows our secondary sites and a number of attributes including oil natural air natural (ONAN) ratings, spatial coordinates, customer counts, whether a site is indoor/outdoor, the address, substation name, alias and its primary feeder.</p>\n\n<p><span>Note: as of 18 April 2024, we have included an additional column showing the utilisation band of the site. The utilisation bands do not indicate contractually committed capacity e.g. capacity on our network may be unused now but expected to be used by a connection in a future year, recent acceptances which will be covered in next year's data.</span></p>\n\n<p><span>There is a site classification as follows:</span></p>\n\n<ul><li>GMT: Ground Mounted Transformer; and</li><li>PMT: Pole Mounted Transformer.</li></ul>\n\n<p>As per the attached triage document, we have redacted sites from this dataset where a transformer serves five or less customers. This is in the interest of protecting customer privacy. Further, we are aware that for a small number of records there are null values, this is primarily for the rare cases where sites have more than one transformer. There is an ongoing review into how this is recorded, which will be reflected in the data once resolved. If you notice any errors, please let us know by feedbacking against the record in the table tab.</p>\n\n<h2>Methodological Approach</h2>\n    <ul>\n        <li>Data Extraction: This dataset is extracted from Azure Databricks.</li>\n        <li>Combination: Various data columns are joined in Azure Databricks based on the FLOC. This includes Grid Reference, connectivity and the number of customers.</li>\n<li>Processing: There are some processing, such as conversion of Grid Reference into longitude and latitude.</li>\n    </ul>\n\n<h2>Quality Control Statement</h2>\n<p>\nQuality Control Measures include:\n<ul>\n<li>Verification steps to match features only with confirmed functional locations. </li>\n<li>Manual review and correct of data inconsistencies</li>\n<li>Use of additional verification steps to ensure accuracy in the methodology</li>\n</ul>\n</p>\n\n<h2>Assurance Statement</h2>\n<p>The Open Data Team checked to ensure data accuracy and consistency.</p>\n\n<h2>Other</h2>\n<p>Download dataset information: <a href=\"https://ukpowernetworks.opendatasoft.com/explore/dataset/domain-dataset0/download/?format=json&amp;refine.identifier=ukpn-secondary-sites\">Metadata (JSON)</a></p>\n\n<p><span>Definitions of key terms related to this dataset can be found in the Open Data Portal Glossary:</span><a href=\"https://ukpowernetworks.opendatasoft.com/pages/glossary/\" target=\"_blank\">https://ukpowernetworks.opendatasoft.com/pages/glossary/</a><a href=\"https://ukpowernetworks.opendatasoft.com/pages/glossary/\" target=\"_blank\"></a></p><p>To view this data please register and login.</p>", "abstract": null, "tableOfContent": null, "type": ["Collection"], "language": ["eng"], "coverage": null, "spatial": "EPN= Eastern Power Networks;SPN= South Eastern Power Networks;LPN= London Power Networks", "temporal_start": null, "temporal_end": null, "relation": "https://ukpowernetworks.opendatasoft.com/explore/dataset/ukpn-secondary-site-transformers/information/; https://ukpowernetworks.opendatasoft.com/explore/dataset/ukpn-low-carbon-technologies-secondary/information/; https://ukpowernetworks.opendatasoft.com/explore/dataset/ukpn-secondary-site-utilisation/information/; https://ukpowernetworks.opendatasoft.com/explore/dataset/ukpn_secondary_postcode_area/information/; https://ukpowernetworks.opendatasoft.com/explore/dataset/ukpn-low-voltage-dnoa/information/?disjunctive.area&disjunctive.dnoa_result&disjunctive.secondary_site_functional_location", "source": "https://ukpowernetworks.opendatasoft.com", "replaces": null, "references": null, "requires": null, "conformsTo": null, "hasFormat": null, "hasPart": null, "hasVersion": null, "isFormatOf": null, "isPartOf": null, "isVersionOf": null, "isReferencedBy": null, "isReplacedBy": null, "isRequiredBy": null, "contributor": null, "creator": "UK Power Networks, Company number 3870728", "publisher": "UK Power Networks, Company number 3870728", "rights": null, "accessRights": ["Open"], "license": "CC BY 4.0", "date_start": null, "date_end": null, "available_start": null, "available_end": null, "created": null, "dateAccepted": null, "dateCopyrighted": null, "dateSubmitted": null, "issued": "2022-08-24T00:00:00+00:00", "modified": "2025-12-09T15:34:19.013000+00:00", "valid_start": null, "valid_end": null, "format": ["application/json", "text/csv", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"], "extent": null, "medium": null, "identifier": null, "bibliographicCitation": null, "rightsHolder": null, "accrualMethod": null, "accrualPeriodicity": null, "accrualPolicy": null, "audience": null, "educationLevel": null, "instructionalMethod": null, "mediator": null, "provenance": null}}}}