UK Power Networks Secondary Sites

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.

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. 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.
• Processing: There are some processing, such as conversion of Grid Reference into longitude and latitude.

Quality Control Statement

Quality Control Measures include:

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:https://ukpowernetworks.opendatasoft.com/pages/glossary/