Author:UK Power NetworksCreation date:August 2022Date of source data harvest:December 2024 Temporal coverage of source data:Up to November 2024 (last modified date, when harvested)Spatial Resolution:Secondary substation locationGeometry:PointSource data URL:UK Power Networks Secondary Sites — UK Power Networks (opendatasoft.com)Data terms of use:CC BY 4.0.Data attribution:- UK Power Networks, Secondary sites, UK Power Networks Secondary Sites — UK Power Networks (opendatasoft.com), November 2024.Workflow Diagram:Not available.Comments:The data and analysis developed for the sub-regional LAEP was undertaken using data available at the time and will need to be refined for a full Phase 2 LAEP. Please check here for more detailed background on the data.Whilst every effort has been made to ensure the quality and accuracy of the data, the Greater London Authority is not responsible for any inaccuracies and/or mistakes in the information provided.Definitions of key terms related to this dataset can be found in the UKPN Open Data Portal Glossary.

IntroductionThis 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; andPMT: 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:

Verification steps to match features only with confirmed functional locations. Manual review and correct of data inconsistencies 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:https://ukpowernetworks.opendatasoft.com/pages/glossary/To view this data please register and login.

Introduction This dataset is a geospatial view of the areas fed by primary substations. The aim is to create an indicative map showing the extent to which individual primary substations feed areas based on MPAN data.

Methodological Approach

  Data Extraction: MPAN data is downloaded from the geographical system. The system searches with a geographical window and assigns it to the nearest supply point.
  Connectivity. Data is taken from the connectivity model and mapped to the relevant MPAN.
  Data Filtering: Any coordinates that are more than 500m from the nearest secondary site are removed.
  Primary Assignment: Postcodes of the MPANs are assigned to a primary substation based on the number of MPANs fed.
  Polygon Creation: Primary Feed Polygons are created and cleaned up to remove holes and inclusions.
  Hierarchy Construction: Grid Supply Point polygons are produced from schematics and merged based on hierarchical relationships.
  FLOC Matching: Functional Location Codes (FLOC) are matched to the respective sites.Based on the functional location (FLOC), firm capacity, season of constraint and % unutilised capacity data is taken from Long Term Development Statement (LTDS) Table 3a Observed Peak Demand 


Quality Control Statement
Quality control measures include:

  Verification steps to match features only with confirmed FLOCs.
  Manual review and correction of data inconsistencies.
  Use of additional verification steps to ensure accuracy in the methodology.
  Regular updates and reviews documented in the version history.


Assurance Statement
The Open Data team, worked with the Geospatial Data Engineering team 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/To view this data please register and login.

Author:UK Power NetworksCreation date:October 2021Date of source data harvest:December 2024 Temporal coverage of source data:Up to August 2024 (last modified date, when harvested)Spatial Resolution:Primary substation locationGeometry:PointSource data URL:https://ukpowernetworks.opendatasoft.com/explore/dataset/grid-and-primary-sites/informationData terms of use:CC BY 4.0Data attribution:- UK Power Networks, Key characteristics of active Grid and Primary sites, https://ukpowernetworks.opendatasoft.com/explore/dataset/grid-and-primary-sites/information, August 2024.Workflow Diagram:Not available.Comments:The data and analysis developed for the sub-regional LAEP was undertaken using data available at the time and will need to be refined for a full Phase 2 LAEP. Please check here for more detailed background on the data.Whilst every effort has been made to ensure the quality and accuracy of the data, the Greater London Authority is not responsible for any inaccuracies and/or mistakes in the information provided.Definitions of key terms related to this dataset can be found in the UKPN Open Data Portal Glossary.

IntroductionA shapefile containing the postcode areas supplied by secondary substations.

Methodological approach The dataset is generalised using our GIS customer connectivity model. Each Secondary Substation's connected LV Network is traced out to its electrical extents, including all connected customers. Using the geographic position of customer connections and key network points of both the Substation being traced and surrounding Substation's network, a Voronoi diagram is created. Each Voronoi polygon that intersects with the traced network is joined together to produce a single polygon, depicting the Supply Zone.

Quality Control Statement
The data is provided "as is". 

Assurance Statement
The Open Data team has checked the data against source to ensure data accuracy and consistency. The data domain owners have checked their respective data aspects.

This dataset is redacted in that any secondary sites with less than five customers will not be included to protect privacy.

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/To view this data please register and login.

IntroductionThis dataset is a geospatial view of the areas fed by grid substations. The aim is to create an indicative map showing the extent to which individual grid substations feed areas based on MPAN data.

Methodology

Data Extraction and Cleaning: MPAN data is queried from SQL Server and saved as a CSV. Invalid values and incorrectly formatted postcodes are removed using a Test Filter in FME.

Data Filtering and Assignment: MPAN data is categorized into EPN, LPN, and SPN based on the first two digits. Postcodes are assigned a Primary based on the highest number of MPANs fed from different Primary Sites.

Polygon Creation and Cleaning: Primary Feed Polygons are created and cleaned to remove holes and inclusions. Donut Polygons (holes) are identified, assigned to the nearest Primary, and merged.

Grid Supply Point Integration: Primaries are merged into larger polygons based on Grid Site relationships. ny Primaries not fed from a Grid Site are marked as NULL and labeled.

  Functional Location Codes (FLOC) Matching: FLOC codes are extracted and matched to Primaries, Grid Sites and Grid Supply Points. Confirmed FLOCs are used to ensure accuracy, with any unmatched sites reviewed by the Open Data Team.

Quality Control Statement

Quality Control Measures include:

Verification steps to match features only with confirmed functional locations. Manual review and correct of data inconsistencies Use of additional verification steps to ensure accuracy in the methodology Regular updates and reviews documented in the version history

Assurance Statement The Open Data Team and Network Data Team worked with the Geospatial Data Engineering Team 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/To view this data please register and login.

List of active Grid and Primary Sites with key characteristics including spatial coordinates, year commissioned and asset counts against the site.

Definitions of key terms related to this dataset can be found in the Open Data Portal Glossary: https://ukpowernetworks.opendatasoft.com/pages/glossary/

IntroductionThis dataset shows the utilisation band of our secondary sites across our three networks, over 1 April 2024 to 31 March 2025. This dataset is a redacted version of an annual regulatory submission to Ofgem. The data consists of a single utilisation value over a year for each of UK Power Networks secondary substation. This dataset is redacted in that any secondary sites with five or less customers will not be included to protect privacy. This dataset is a mixture of actual utilisation data and analytics based on transformer profile. 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.If you notice any errors, please let us know by feedbacking against the record in the table tab.

Methodological Approach UK Power Networks worked with other DNOs and the Energy Networks Association (ENA), to agree a methodology to calculating transformer utilisation.

It considered the following:

Transformer rating; Current peak loading; Year demand growth; Year ahead peak demand; and Utilisation calculation.

Quality Control Statement This dataset is provided "as is".

Assurance Statement The Open Data Team and DSO Network Strategy Team worked 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/To view this data please register and login.

Author:Arup (dataset derived from UK Power Networks)Creation date:2023Date of source data harvest:2023Temporal coverage:2030 to 2050Spatial Resolution:Primary Substation locationGeometry:PointSource data URL:Distribution Future Energy Scenarios Network Scenario Headroom Report (DFES NSHR) — UK Power NetworksData terms of use:CC BY 4.0Data attribution:- Dataset processed by Arup in 2023 as part of the West London sub-regional LAEP.- UK Power Networks, UK Power Networks Distribution Future Energy Scenarios Network Scenario Headroom Report (DFES NSHR), https://ukpowernetworks.opendatasoft.com/explore/dataset/dfes-network-headroom-report/information/, 2023.- UK Power Networks, Key characteristics of active Grid and Primary sites, https://ukpowernetworks.opendatasoft.com/explore/dataset/grid-and-primary-sites/information/, 2023.Workflow Diagram:Available: pngComments:Please note, the UKPN network headroom reports and demand headroom forecasts have been updated since this dataset was created.The data and analysis developed for the sub-regional LAEP was undertaken using data available at the time and will need to be refined for a full Phase 2 LAEP.Whilst every effort has been made to ensure the quality and accuracy of the data, the Greater London Authority is not responsible for any inaccuracies and/or mistakes in the information provided.

The earthing fault level dataset includes the three-phase and single-phase to earth fault levels for all Grid (132kV, 66kV, 33kV) and Primary (33kV, 20kV, 11kV, 6.6kV) substations based on the

UK Power Networks Long Term Development Statement (LTDS).

This data can be used in substation earthing system design and assessment. For further information on earthing refer to UK Power Networks' earthing standard EDS 06-0001 available from our website https://g81.ukpowernetworks.co.uk/. Please send any enquiries related to the dataset to earthingenquiries@ukpowernetworks.co.uk

Methodological Approach

Fault level data is uploaded from UK Power Networks' data warehouse.
Site Functional Locations (FLOCs) are used to associate soil data to Key characteristics of active Grid and Primary sites — UK Power Networks

Quality Control Statement
Quality Control Measures include:

  Verification steps to match features only with confirmed functional locations.
  Manual review and correction of data inconsistencies.
  Use of additional verification steps to ensure accuracy in the methodology.


Assurance Statement
The Open Data Team has 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/To view this data please register and login.

🇬🇧 영국

Author:UK Power NetworksCreation date:October 2023Date of source data harvest:December 2024Temporal coverage of source data:1 April 2022 to 31 March 2023 (demand headroom data) Spatial Resolution:Secondary substation distribution areaGeometry:PointSource data URL:UK Power Networks Secondary Substation Distribution Areas — UK Power Networks (opendatasoft.com) Data terms of use:CC BY 4.0.Data attribution:UK Power Networks, UK Power Networks secondary substation distribution areas, https://ukpowernetworks.opendatasoft.com/explore/dataset/ukpn_secondary_postcode_area/information/, October 2023. Workflow Diagram: Not avaliable.Comments: The data and analysis developed for the sub-regional LAEP was undertaken using data available at the time and will need to be refined for a full Phase 2 LAEP. Please check here for more detailed background on the data.Whilst every effort has been made to ensure the quality and accuracy of the data, the Greater London Authority is not responsible for any inaccuracies and/or mistakes in the information provided.Definitions of key terms related to this dataset can be found in the UKPN Open Data Portal Glossary.

This geospatial data is a combination of Great Britain's 4436 primary substation service areas which have been parsed into a single shapefile for energy systems analysis. The original component datasets were provided by the six distribution network operator (DNO) companies in Great Britain (National Grid Electricity Distribution, Electricity North West Ltd, Scottish and Southern Electricity Networks, UK Power Networks, Scottish Power Energy Networks and Northern Power Grid). Attribution is given to the original data owners at each of these six DNOs and the resulting dataset from this work has been created and published under an open licence with each DNO's permission. The data is available to download as two geojson files in the WGS84 coordinate system. One is a streamlined version which just contains the polygons along with a unique primary identifier (UPID), primary substation name, DNO licence area and local authority. The other contains the polygons along with richer energy data which was aggregated to the primary substation level from publicly available Department for Energy Security and Net Zero, Office for National Statistics and National Grid ESO datasets. This data is also available to download in tabular form as a csv file. The meter numbers and consumption values are the means of those reported from 2015-2020. The substation polygons were those as received or publicly available as of the time period of this study (2021-22). The pre-print manuscript of the methodology used to create this dataset can be found on arXiv at: https://doi.org/10.48550/arXiv.2311.03324 Funding to support this work was received from the Engineering and Physical Sciences Research Council (EP/W008726/1) under the Gas Net New project and the Alan Turing Institute's Science of Cities and Regions Programme. Thanks are also given to the contributors of QGIS and the Geopandas Python library, both of which were used in this analysis.

The data consists of names, types, voltages, constraint status and national grid references for 56,865 electricity substations (33 kV or larger) in Great Britain in 2018. It was compiled from information on individual transmission or distribution network operator websites and interpreted to produce a classification of constraint status (where applicable). The data set was compiled from information on individual transmission or distribution network operator websites. The work was funded by the Natural Environment Research Council Award NE/M019713/1.

🇬🇧 영국 English A shapefile containing the postcode areas supplied by secondary substations. The dataset is generalised using our GIS customer connectivity model. Each Secondary Substation's connected LV Network is traced out to its electrical extents, including all connected customers. Using the geographic position of customer connections and key network points of both the Substation being traced and surrounding Substation's network, a Voronoi diagram is created. Each Voronoi polygon that intersects with the traced network is joined together to produce a single polygon, depicting the Supply Zone. This dataset is redacted in that any secondary sites with less than five customers will not be included to protect privacy.

Introduction The Long Term Development Statement (LTDS) report on a 0-5 year period, describing a forecast of load on the network and envisioned network developments. The LTDS is published at the end of May and November each year. This is Table 1 from our current LTDS report (published 30 May 2025), showing the circuit associated with each Grid and Primary substation. More information and full reports are available from the landing page below: Long Term Development Statement and Network Development Plan Landing Page — UK Power Networks (opendatasoft.com)

Methodological Approach

Site Functional Locations (FLOCs) are used to associate the From Substation to Key characteristics of active Grid and Primary sites — UK Power Networks ID field added to identify row number for reference purposes

Quality Control Statement Quality Control Measures include:

Verification steps to match features only with confirmed functional locations. Manual review and correction of data inconsistencies Use of additional verification steps to ensure accuracy in the methodology

Assurance Statement The Open Data Team and Network Insights Team worked together 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: Open Data Portal GlossaryTo view this data please register and login.

This dataset contains voltage, current, power, energy, and weather data from low-voltage substations and domestic premises with high uptake of solar photovoltaic (PV) embedded generation. Data collected as part of the project run by UK Power Networks. Validation of Photovoltaic Connection Assessment Tool https://www.ofgem.gov.uk/ofgem-publications/93938/pvtoolcdrfinal-pdf The project collected a rich dataset at domestic sites with Solar Panels. The data set comprises of 25,775 days-worth of data, and over 171 million individual measurements. Key stats about the dataset: 20 substations and 10 domestic premises Collected over 480 days - 27 July 2013 to 19 November 2014 10 minute intervals over all time recorded, 1 minute intervals in summer 2014 10-minute measurements prior to 10 June 2014, aggregated to hourly minima and maxima Several important findings are presented in the final project report (link above). For any further queries please email innovation@ukpowernetworks.co.uk

Volume of Low Carbon Technologies (LCT) for both generation and demand (under 1MW) connected to UK Power Networks by Primary Substation. Includes primary site spatial coordinates and covers LCT types: EV Charging Point; Heat Pump; Hydro; Combined Heat and Power; Solar, Wind; and Battery Storage among others.

Definitions of key terms related to this dataset can be found in the Open Data Portal Glossary: https://ukpowernetworks.opendatasoft.com/pages/glossary/

IntroductionThe earth potential rise (EPR) dataset includes the fault current, ground return current, EPR and site classification at various voltages (132kV, 66kV, 33kV, 25kV, 20kV, 11kV, 6.6kV) for all Grid and Primary substations. This data can be used in substation earthing system design and assessment.

For further information on earthing refer to UK Power Networks' earthing standard EDS 06-0001 available from our website https://g81.ukpowernetworks.co.uk/. Please send any enquiries related to the dataset to earthingenquiries@ukpowernetworks.co.uk.

Methodological Approach

EPR data is uploaded from UK Power Networks' data warehouse.
Site Functional Locations (FLOCs) are used to associate soil data to Key characteristics of active Grid and Primary sites — UK Power Networks

Quality Control Statement
Quality Control Measures include:

  Verification steps to match features only with confirmed functional locations.
  Manual review and correction of data inconsistencies.
  Use of additional verification steps to ensure accuracy in the methodology.


Assurance Statement
The Open Data Team has 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/To view this data please register and login.

🇬🇧 영국 English A shapefile containing the postcode areas supplied by primary substations. Definitions of key terms related to this dataset can be found in the Open Data Portal Glossary: https://ukpowernetworks.opendatasoft.com/pages/glossary/