Data · dataset · 2026
UK Power Networks Secondary Sites
Listed in ukpowernetworks
Introduction 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.
Description
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.
There is a site classification as follows: GMT: Ground Mounted Transformer; and PMT: Pole Mounted Transformer. 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.
Read the rest (3 more)
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.
Methodological Approach Data Extraction: This dataset is extracted from Azure Databricks; Combination: Various data columns are joined in Azure Databricks based on the FLOC. This includes Grid Reference, connectivity and the number of customers; and Processing: There are some processing, such as conversion of Grid Reference into longitude and latitude. Quality Control Statement Quality Control Measures include: Verification steps to match features only with confirmed functional locations; Manual review and correct of data inconsistencies; and Use of additional verification steps to ensure accuracy in the methodology.
Assurance Statement The Open Data Team checked to ensure data accuracy and consistency. Other Download dataset information: Metadata (JSON) Definitions of key terms related to this dataset can be found in the Open Data Portal Glossary: ukpowernetworks.opendatasoft.com/pages/glossary/ To view this data please register and login.
Links
Get the data
- CSV export ukpowernetworks.opendatasoft.com/api/explore/v2.1/catalog/datasets/ukpn-secondary-sites/exports… ↗
download · from ukpowernetworks opendatasoft com
Where it is published
- ukpowernetworks dataset page ukpowernetworks.opendatasoft.com/explore/dataset/ukpn-secondary-sites ↗
landing page · from ukpowernetworks opendatasoft com
Catalogue records · 1
- Explore API ukpowernetworks.opendatasoft.com/api/explore/v2.1/catalog/datasets/ukpn-secondary-sites ↗
metadata API · from ukpowernetworks opendatasoft com
Topics
- Stated by source
- Network Infrastructure
- From keywords
- Engineering
- Inferred from text
- Tabular 65%
Provenance · 1 source records, 9 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| ukpowernetworks | ukpn-secondary-sites | 11 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| access_level | source · ukpowernetworks opendatasoft com | connector:ukpowernetworks_opendatasoft_com@1.0.0 | |
| concepts[field].local:field:engineering | mapping · ukpowernetworks opendatasoft com | connector:ukpowernetworks_opendatasoft_com@1.0.0 | |
| concepts[modality].local:modality:tabular | enrichment · ukpowernetworks opendatasoft com | keyword-concept-rules@1.0.0 | title+description (65%) |
| concepts[topic].ods_theme:ukpowernetworks_opendatasoft_com:network-infrastructure | source · ukpowernetworks opendatasoft com | connector:ukpowernetworks_opendatasoft_com@1.0.0 | |
| description | source · ukpowernetworks opendatasoft com | connector:ukpowernetworks_opendatasoft_com@1.0.0 | /metas/default/description |
| license | source · ukpowernetworks opendatasoft com | connector:ukpowernetworks_opendatasoft_com@1.0.0 | |
| publication_date | source · ukpowernetworks opendatasoft com | connector:ukpowernetworks_opendatasoft_com@1.0.0 | |
| title | source · ukpowernetworks opendatasoft com | connector:ukpowernetworks_opendatasoft_com@1.0.0 | /metas/default/title |
| updated_date | source · ukpowernetworks opendatasoft com | connector:ukpowernetworks_opendatasoft_com@1.0.0 |