Constarium
← Search

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

Topics

Stated by source
Network Infrastructure
From keywords
Engineering
Inferred from text
Tabular 65%
Provenance · 1 source records, 9 field assertions
SourceKeyLast seenRaw
ukpowernetworksukpn-secondary-sites11 d agoJSON v1
FieldAssertionExtractorEvidence
access_levelsource · ukpowernetworks opendatasoft comconnector:ukpowernetworks_opendatasoft_com@1.0.0
concepts[field].local:field:engineeringmapping · ukpowernetworks opendatasoft comconnector:ukpowernetworks_opendatasoft_com@1.0.0
concepts[modality].local:modality:tabularenrichment · ukpowernetworks opendatasoft comkeyword-concept-rules@1.0.0title+description (65%)
concepts[topic].ods_theme:ukpowernetworks_opendatasoft_com:network-infrastructuresource · ukpowernetworks opendatasoft comconnector:ukpowernetworks_opendatasoft_com@1.0.0
descriptionsource · ukpowernetworks opendatasoft comconnector:ukpowernetworks_opendatasoft_com@1.0.0/metas/default/description
licensesource · ukpowernetworks opendatasoft comconnector:ukpowernetworks_opendatasoft_com@1.0.0
publication_datesource · ukpowernetworks opendatasoft comconnector:ukpowernetworks_opendatasoft_com@1.0.0
titlesource · ukpowernetworks opendatasoft comconnector:ukpowernetworks_opendatasoft_com@1.0.0/metas/default/title
updated_datesource · ukpowernetworks opendatasoft comconnector:ukpowernetworks_opendatasoft_com@1.0.0