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: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.

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. Full details about this dataset can be found at https://doi.org/10.5285/0eed5c99-f409-4329-a98e-47f496bb88a2

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.

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.

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.

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/

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.

11kV substations for all NGED areas can be downloaded from dataportal2.westernpower.co.uk the following formats: AutoCAD DWG format

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.

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.

This page contains data on NGED’s distribution substations. It is comprised of the following 4 datasets: • Substation Demand: details of the transformers used in each substations including their make, model, rating, day and night max demand values (kVA) • Asset Types: details of all physical equipment within a substation including their make, model, role number and description • Customers: details the customer demand on feeder within a substation including information such as max demand day and night per feeder (kVA) • IDNO Connections: details the total agreed import and export capacity (kVA) for IDNOs supplied by each distribution substation In addition to these datasets, you may also find useful the Distribution Substations dataset (also available on the Connected Data Portal), which provides details on network structure including information on the HV feeder and the Primary substation which feeds each distribution substation and number of customers served by a distribution substation. The four datasets within this package and the Distribution Substations dataset can be joined together through using the substation number field which exists in all datasets. For further guidance on how to join these datasets please see the attached Entity Relationship Diagram. To protect customer privacy, data related to substations serving five or fewer customers has been redacted from this dataset. This approach ensures that individual customers cannot be identified through publicly available information. We understand that in certain cases, specific use cases may require access to redacted substation data. If you have a legitimate need for this information, please contact us at nged.data@nationalgrid.co.uk to discuss your requirements. Access may be granted on a case-by-case basis, subject to a formal review process and the signing of a Non-Disclosure Agreement (NDA). Disclaimer Whilst we use reasonable endeavours to ensure that the data contained within these datasets is accurate, we do not accept any responsibility or liability for, the accuracy or the completeness of the content, or any loss which may arise from reliance on this data and related information.

The growing demand for electrified heating, electrified transportation, and power-intensive data centres challenge distribution networks. If electrification projects are carried out without considering electrical distribution infrastructure, there could be unexpected blackouts and financial losses. Datasets containing real-world distribution network information are required to address this. On the other hand, social data, such as household heating composition, are closely coupled with people’s lives. Studying the coupling between the energy system and society is important in promoting social welfare. To fill these gaps, this paper introduces two datasets. The first is the main dataset for the distribution networks in Great Britain (GB), collecting information on firm capacity, peak demands, locations, and parent transmission nodes (the Grid Supply Point, namely GSP) for all primary substations (PSs). PSs are a crucial part of the UK distribution network and are at the lowest voltage level (11 kV) with publicly available data for most UK Distribution Network Operators (DNOs). Substation firm capacity and peak demand facilitate an understanding of the remaining room of the existing network. The parent GSP information helps link the dataset of distribution networks to datasets of transmission networks. These datasets are collected, processed, and merged from various files published by the six DNOs in GB. There were inconsistencies among the PS names across files even for the same DNO. A Python script and manual validation are performed to carefully process and merge the corresponding PS information. The second dataset extends the main network dataset, linking each PS to information about the number of households that use different types of central heating recorded in census data (Census in year 2021 for England and Wales, and Census 2011 for Scotland as the most recent Scotland Census 2022 data has not yet been fully released). The derivation of the second dataset is based on locations of PSs collected in the main dataset with appropriate assumptions. The derivation process may also be replicated to integrate other social datasets.

If you are interested and would like to use this dataset. Please cite our paper:

Zhou, Yihong, Chaimaa Essayeh, and Thomas Morstyn. "Datasets of Great Britain Primary Substations Integrated with Household Heating Information." Data in Brief (2024): 110483. https://doi.org/10.1016/j.dib.2024.110483.

The paper encloses a detailed description of all the files and methods for processing and deriving our data. The paper above also describes the values, applications, possible extensions, and limitations of the released datasets.

🇬🇧 영국

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

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 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.

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/

Introduction UK Power Network maintains the 132kV voltage level network and below. An important part of the distribution network is distributing this electricity across our regions through circuits. Electricity enters our network through Super Grid Transformers at substations shared with National Grid we call Grid Supply Points. It is then sent at across our 132 kV Circuits towards our grid substations and primary substations. These circuits can be viewed on the single line diagrams in our Long-Term Development Statements (LTDS) and the underlying data is then found in the LTDS tables .
Care is taken to protect the private affairs of companies connected to the 132 kV network, resulting in the redaction of certain circuits. Where redacted, we provide monthly statistics to continue to add value where possible. Where monthly statistics exist but half-hourly is absent, this data has been redacted. This dataset provides monthly statistics across these named circuits from 2021 through to the previous month across our license areas. The data is aligned with the same naming convention as the LTDS for improved interoperability. To find half-hourly current and power flow for the circuit you are looking for, use the ‘ltds_line_name’ that can be cross referenced in the 132kV Circuits Half Hourly Data. If you want to download all this data, it is perhaps more convenient from our public sharepoint: Sharepoint This dataset is part of a larger endeavour to share more operational data on UK Power Networks assets. Please visit our Network Operational Data Dashboard for more operational datasets.

Methodological Approach

The dataset is not derived, it is the measurements from our network stored in our historian. The measurement devices are taken from current transformers attached to the cable at the circuit breaker, and power is derived combining this with the data from voltage transformers physically attached to the busbar. The historian stores datasets based on a report-by-exception process, such that a certain deviation from the present value must be reached before logging a point measurement to the historian. We extract the data following a 30-min time weighted averaging method to get half-hourly values. Where there are no measurements logged in the period, the data provided is blank; due to the report-by-exception process, it may be appropriate to forward fill this data for shorter gaps. We developed a data redactions process to protect the privacy or companies according to the Utilities Act 2000 section 105.1.b, which requires UK Power Networks to not disclose information relating to the affairs of a business. For this reason, where the demand of a private customer is derivable from our data and that data is not already public information (e.g., data provided via Elexon on the Balancing Mechanism), we redact the half-hourly time series, and provide only the monthly averages. This redaction process considers the correlation of all the data, of only corresponding periods where the customer is active, the first order difference of all the data, and the first order difference of only corresponding periods where the customer is active. Should any of these four tests have a high linear correlation, the data is deemed redacted. This process is not simply applied to only the circuit of the customer, but of the surrounding circuits that would also reveal the signal of that customer. The directionality of the data is not consistent within this dataset. Where directionality was ascertainable, we arrange the power data in the direction of the LTDS "from node" to the LTDS "to node". Measurements of current do not indicate directionality and are instead positive regardless of direction. In some circumstances, the polarity can be negative, and depends on the data commissioner's decision on what the operators in the control room might find most helpful in ensuring reliable and secure network operation.

Quality Control Statement The data is provided "as is".
In the design and delivery process adopted by the DSO, customer feedback and guidance is considered at each phase of the project. One of the earliest steers was that raw data was preferable. This means that we do not perform prior quality control screening to our raw network data. The result of this decision is that network rearrangements and other periods of non-intact running of the network are present throughout the dataset, which has the potential to misconstrue the true utilisation of the network, which is determined regulatorily by considering only by in-tact running arrangements. Therefore, taking the maximum or minimum of these measurements are not a reliable method of correctly ascertaining the true utilisation. This does have the intended added benefit of giving a realistic view of how the network was operated. The critical feedback was that our customers have a desire to understand what would have been the impact to them under real operational conditions. As such, this dataset offers unique insight into that. Assurance Statement

Creating this dataset involved a lot of human data imputation. At UK Power Networks, we have differing software to run the network operationally (ADMS) and to plan and study the network (PowerFactory). The measurement devices are intended to primarily inform the network operators of the real time condition of the network, and importantly, the network drawings visible in the LTDS are a planning approach, which differs to the operational. To compile this dataset, we made the union between the two modes of operating manually. A team of data scientists, data engineers, and power system engineers manually identified the LTDS circuit from the single line diagram, identified the line name from LTDS Table 2a/b, then identified the same circuit in ADMS to identify the measurement data tags. This was then manually inputted to a spreadsheet. Any influential customers to that circuit were noted using ADMS and the single line diagrams. From there, a python code is used to perform the triage and compilation of the datasets.
There is potential for human error during the manual data processing. These issues can include missing circuits, incorrectly labelled circuits, incorrectly identified measurement data tags, incorrectly interpreted directionality. Whilst care has been taken to minimise the risk of these issues, they may persist in the provided dataset. Any uncertain behaviour observed by using this data should be reported to allow us to correct as fast as possible.

Additional Information Definitions of key terms related to this dataset can be found in the Open Data Portal Glossary. Download dataset information: Metadata (JSON) We would be grateful if you find this dataset useful to submit a “reuse” case study to tell us what you did and how you used it. This enables us to drive our direction and gain better understanding for how we improve our data offering in the future. For more information click here: Open Data Portal Reuses — UK Power NetworksTo view this data please register and login.

The net power flow through each GSP, BSP and primary substation. For each substation the data is presented against each relevant node in the network model to reflect the intact topology. Statistical data cleansing (identification and replacement of erroneous time-series values with imputed alternatives) is applied to the data to remove any erroneous outliers or populate any outage periods where necessary. The polarity of loadings is based on conventional power flow (HV to LV). Demand connected at the bus is expressed as a positive value and generation connected at the bus is expressed as a negative value.