LV Monitoring Aggregated Data

Information

Description

The published table provides a summary of the capacity utilisation of secondary substations with LV monitoring coverage on a monthly aggregated level in the SPEN SPD and SPM licence areas. One file will be published every month containing the aggregated capacity utilisation values per transformer of a secondary substation wherein LV monitors have been deployed. An additional .gpkg file is uploaded to provide mappin to the geopoints of each secondary substation location. The two files are joined using transformer enid's.

The dataset takes LV Monitoring data on a 10 minute cadence from the secondary substations and calculates at what average capacity every transformer runs on a monthly basis using metrics like apparent power and transformer rating. Furthermore, 5th, 50th and 95th percentile of capacity utilisation values per month, per transformer are also included in the dataset to give customers an insight into the variance of demand across any given month.

Each file gives the following information:

 1 - an unique identifier for each record in the form of the LV Transformer ENID. 

 2 - the month and year to which the capacity utilisation values of the transformer correspond with. 

 3 - the secondary substation name along with its location details. 

 4 - monthly aggregated capacity utilisation and power factor per transformer. 

The dataset is updated on a monthly basis.

Disclaimer

Whilst all reasonable care has been taken in the preparation of this data, SP Energy Networks does not accept any responsibility or liability for the accuracy or completeness of this data, and is not liable for any loss that may be attributed to the use of this data. For the avoidance of doubt, this data should not be used for safety critical purposes without the use of appropriate safety checks and services  e.g. LineSearchBeforeUDig etc. Please raise any potential issues with the data via the feedback form available at the Feedback tab above (must be logged in to see this). 

Note: the LV monitoring data is provided to share insights into the demand on our LV network, it does not follow network demand calculations & methodologies. For further information on LV Network Utilisation, please email the Open Data Team via opendata@spenergynetworks.co.uk

Example Use Cases

Modeling Utilisation Behaviours with LV Monitoring and Smart Meter Data

This dataset can be integrated with smart meter data to model and analyse utilisation behaviours, enabling more accurate predictions of energy demand and identifying patterns of under or over-utilisation across different substations in every district. Consumers can identify monthly energy load and peak usage time of year which can present opportunities to reduce energy costs.

Data Triage 

As part of our commitment to enhancing the transparency, and accessibility of the data we share, we publish the results of our Data Triage process.

Our Data Triage documentation includes our Risk Assessments; detailing any controls we have implemented to prevent exposure of sensitive information.  Click here to access the Data Triage documentation for the LV Monitoring Aggregated Data dataset. 

To access our full suite of Data Triage documentation, visit the SP Energy Networks Data & Information page.  

Download dataset metadata (JSON)

Attachments

Click to expand Click to collapse

Dataset schema

Click to expand Click to collapse
Year_Month
The year and month in which the capacity utilisation values were reported.

No description available for this field.

Name (identifier) 
year_month
Type 
text
Sample 
                       		                   
               
       
   
       
Licence Area
       
           
               
The licence area (SPD or SPM). 
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
licence_area
                       		                   
                   
                                                  Type                                                                         
text
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
Substation Name
       
           
               
The name of the secondary substation with LV monitoring coverage. 
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
substation_name
                       		                   
                   
                                                  Type                                                                         
text
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
Transformer ENID
       
           
               
Unique identifier of the transformer in the secondary substation. 
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
transformer_enid
                       		                   
                   
                                                  Type                                                                         
text
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
Geo Point
       
           
               
Geopoints to display the secondary substation's location on map.  
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
geopoint_2d
                       		                   
                   
                                                  Type                                                                         
geo point
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
District
       
           
               
District where the transformer is located. 
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
district
                       		                   
                   
                                                  Type                                                                         
text
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
Maximum Capacity Utilisation
       
           
               
The maximum percentage of capacity utilised for a transformer in that month of the year. 
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
maximum_capacity_utilisation
                       		                   
                   
                                                  Type                                                                         
decimal
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
Aggregated Power Factor
       
           
               
Average Power Factor in a month for a specific transformer. 
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
aggregated_power_factor
                       		                   
                   
                                                  Type                                                                         
decimal
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
5th Percentile Capacity Utilisation
       
           
               
Capacity utilisation value below which the bottom 5% of the values fall in. 
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
5th_percentile_capacity_utilisation
                       		                   
                   
                                                  Type                                                                         
decimal
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
50th Percentile Capacity Utilisation
       
           
               
Capacity utilisation value below which the bottom 50% of the values fall in. 
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
50th_percentile_capacity_utilisation
                       		                   
                   
                                                  Type                                                                         
decimal
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
95th Percentile Capacity Utilisation
       
           
               
Capacity utilisation value below which the bottom 95% of the values fall in. 
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
95th_percentile_capacity_utilisation
                       		                   
                   
                                                  Type                                                                         
decimal
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   

                                
JSON Schema

                                

                                    The following JSON object is a standardized description of your dataset's schema.
                                    More about JSON schema.
                                

                                
   
{
  • "title":"lv_monitor",
  • "type":"object",
  • "oneOf":
    [
    • {
      • "$ref":"#/definitions/lv_monitor"
      }
    ]
    ,
  • "definitions":
    {
    • "lv_monitor":
      {
      • "properties":
        {
        • "records":
          {
          • "type":"array",
          • "items":
            {
            • "$ref":"#/definitions/lv_monitor_records"
            }
          }
        }
      }
      ,
    • "geoJSON":
      {
      • "title":"Geo JSON object",
      • "description":"Schema for a Geo JSON object",
      • "type":"object",
      • "required":
        [
        • "type"
        ]
        ,
      • "properties":
        {
        • "crs":
          {
          • "$ref":"#/definitions/crs"
          }
          ,
        • "bbox":
          {
          • "$ref":"#/definitions/bbox"
          }
        }
        ,
      • "oneOf":
        [
        • {
          • "$ref":"#/definitions/geometry"
          }
          ,
        • {
          • "$ref":"#/definitions/geometryCollection"
          }
          ,
        • {
          • "$ref":"#/definitions/feature"
          }
          ,
        • {
          • "$ref":"#/definitions/featureCollection"
          }
        ]
      }
      ,
    • "bbox":
      {
      • "description":"A bounding box as defined by GeoJSON",
      • "type":"array",
      • "items":
        {
        • "type":"number"
        }
      }
      ,
    • "crs":
      {
      • "title":"crs",
      • "description":"a Coordinate Reference System object",
      • "type":
        [
        • "object",
        • "null"
        ]
        ,
      • "required":
        [
        • "type",
        • "properties"
        ]
        ,
      • "properties":
        {
        • "type":
          {
          • "type":"string"
          }
          ,
        • "properties":
          {
          • "type":"object"
          }
        }
        ,
      • "additionalProperties":false,
      • "oneOf":
        [
        • {
          • "$ref":"#/definitions/namedCrs"
          }
          ,
        • {
          • "$ref":"#/definitions/linkedCrs"
          }
        ]
      }
      ,
    • "namedCrs":
      {
      • "properties":
        {
        • "type":
          {
          • "enum":
            [
            • "name"
            ]
          }
          ,
        • "properties":
          {
          • "required":
            [
            • "name"
            ]
            ,
          • "additionalProperties":false,
          • "properties":
            {
            • "name":
              {
              • "type":"string"
              }
            }
          }
        }
      }
      ,
    • "linkedObject":
      {
      • "type":"object",
      • "required":
        [
        • "href"
        ]
        ,
      • "properties":
        {
        • "href":
          {
          • "type":"string",
          • "format":"uri"
          }
          ,
        • "type":
          {
          • "type":"string",
          • "description":"Suggested values: proj4, ogjwkt, esriwkt"
          }
        }
      }
      ,
    • "linkedCrs":
      {
      • "properties":
        {
        • "type":
          {
          • "enum":
            [
            • "link"
            ]
          }
          ,
        • "properties":
          {
          • "$ref":"#/definitions/linkedObject"
          }
        }
      }
      ,
    • "geometryCollection":
      {
      • "title":"GeometryCollection",
      • "description":"A collection of geometry objects",
      • "required":
        [
        • "geometries"
        ]
        ,
      • "properties":
        {
        • "type":
          {
          • "enum":
            [
            • "GeometryCollection"
            ]
          }
          ,
        • "geometries":
          {
          • "type":"array",
          • "items":
            {
            • "$ref":"http://json-schema.org/geojson/geometry.json#"
            }
          }
        }
      }
      ,
    • "feature":
      {
      • "title":"Feature",
      • "description":"A Geo JSON feature object",
      • "required":
        [
        • "geometry",
        • "properties"
        ]
        ,
      • "properties":
        {
        • "type":
          {
          • "enum":
            [
            • "Feature"
            ]
          }
          ,
        • "geometry":
          {
          • "oneOf":
            [
            • {
              • "type":"null"
              }
              ,
            • {
              • "$ref":"#/definitions/geometry"
              }
            ]
          }
          ,
        • "properties":
          {
          • "type":
            [
            • "object",
            • "null"
            ]
          }
          ,
        • "id":
          {
            }
          }
        }
        ,
      • "featureCollection":
        {
        • "title":"FeatureCollection",
        • "description":"A Geo JSON feature collection",
        • "required":
          [
          • "features"
          ]
          ,
        • "properties":
          {
          • "type":
            {
            • "enum":
              [
              • "FeatureCollection"
              ]
            }
            ,
          • "features":
            {
            • "type":"array",
            • "items":
              {
              • "$ref":"#/definitions/feature"
              }
            }
          }
        }
        ,
      • "geometry":
        {
        • "title":"geometry",
        • "description":"One geometry as defined by GeoJSON",
        • "type":"object",
        • "required":
          [
          • "type",
          • "coordinates"
          ]
          ,
        • "oneOf":
          [
          • {
            • "title":"Point",
            • "properties":
              {
              • "type":
                {
                • "enum":
                  [
                  • "Point"
                  ]
                }
                ,
              • "coordinates":
                {
                • "$ref":"#/definitions/position"
                }
              }
            }
            ,
          • {
            • "title":"MultiPoint",
            • "properties":
              {
              • "type":
                {
                • "enum":
                  [
                  • "MultiPoint"
                  ]
                }
                ,
              • "coordinates":
                {
                • "$ref":"#/definitions/positionArray"
                }
              }
            }
            ,
          • {
            • "title":"LineString",
            • "properties":
              {
              • "type":
                {
                • "enum":
                  [
                  • "LineString"
                  ]
                }
                ,
              • "coordinates":
                {
                • "$ref":"#/definitions/lineString"
                }
              }
            }
            ,
          • {
            • "title":"MultiLineString",
            • "properties":
              {
              • "type":
                {
                • "enum":
                  [
                  • "MultiLineString"
                  ]
                }
                ,
              • "coordinates":
                {
                • "type":"array",
                • "items":
                  {
                  • "$ref":"#/definitions/lineString"
                  }
                }
              }
            }
            ,
          • {
            • "title":"Polygon",
            • "properties":
              {
              • "type":
                {
                • "enum":
                  [
                  • "Polygon"
                  ]
                }
                ,
              • "coordinates":
                {
                • "$ref":"#/definitions/polygon"
                }
              }
            }
            ,
          • {
            • "title":"MultiPolygon",
            • "properties":
              {
              • "type":
                {
                • "enum":
                  [
                  • "MultiPolygon"
                  ]
                }
                ,
              • "coordinates":
                {
                • "type":"array",
                • "items":
                  {
                  • "$ref":"#/definitions/polygon"
                  }
                }
              }
            }
          ]
          ,
        • "position":
          {
          • "description":"A single position",
          • "type":"array",
          • "minItems":2,
          • "items":
            [
            • {
              • "type":"number"
              }
              ,
            • {
              • "type":"number"
              }
            ]
            ,
          • "additionalItems":false
          }
          ,
        • "positionArray":
          {
          • "description":"An array of positions",
          • "type":"array",
          • "items":
            {
            • "$ref":"#/definitions/position"
            }
          }
          ,
        • "lineString":
          {
          • "description":"An array of two or more positions",
          • "allOf":
            [
            • {
              • "$ref":"#/definitions/positionArray"
              }
              ,
            • {
              • "minItems":2
              }
            ]
          }
          ,
        • "linearRing":
          {
          • "description":"An array of four positions where the first equals the last",
          • "allOf":
            [
            • {
              • "$ref":"#/definitions/positionArray"
              }
              ,
            • {
              • "minItems":4
              }
            ]
          }
          ,
        • "polygon":
          {
          • "description":"An array of linear rings",
          • "type":"array",
          • "items":
            {
            • "$ref":"#/definitions/linearRing"
            }
          }
        }
        ,
      • "lv_monitor_records":
        {
        • "properties":
          {
          • "fields":
            {
            • "type":"object",
            • "properties":
              {
              • "year_month":
                {
                • "type":"string",
                • "title":"Year_Month",
                • "description":"The year and month in which the capacity utilisation values were reported. "
                }
                ,
              • "licence_area":
                {
                • "type":"string",
                • "title":"Licence Area",
                • "description":"The licence area (SPD or SPM). "
                }
                ,
              • "substation_name":
                {
                • "type":"string",
                • "title":"Substation Name",
                • "description":"The name of the secondary substation with LV monitoring coverage. "
                }
                ,
              • "transformer_enid":
                {
                • "type":"string",
                • "title":"Transformer ENID",
                • "description":"Unique identifier of the transformer in the secondary substation. "
                }
                ,
              • "geopoint_2d":
                {
                • "type":"array",
                • "minItems":2,
                • "maxItems":2,
                • "items":
                  {
                  • "type":"number"
                  }
                  ,
                • "title":"Geo Point",
                • "description":"Geopoints to display the secondary substation's location on map.  "
                }
                ,
              • "district":
                {
                • "type":"string",
                • "title":"District",
                • "description":"District where the transformer is located. "
                }
                ,
              • "maximum_capacity_utilisation":
                {
                • "type":"number",
                • "title":"Maximum Capacity Utilisation",
                • "description":"The maximum percentage of capacity utilised for a transformer in that month of the year. "
                }
                ,
              • "aggregated_power_factor":
                {
                • "type":"number",
                • "title":"Aggregated Power Factor",
                • "description":"Average Power Factor in a month for a specific transformer. "
                }
                ,
              • "5th_percentile_capacity_utilisation":
                {
                • "type":"number",
                • "title":"5th Percentile Capacity Utilisation",
                • "description":"Capacity utilisation value below which the bottom 5% of the values fall in. "
                }
                ,
              • "50th_percentile_capacity_utilisation":
                {
                • "type":"number",
                • "title":"50th Percentile Capacity Utilisation",
                • "description":"Capacity utilisation value below which the bottom 50% of the values fall in. "
                }
                ,
              • "95th_percentile_capacity_utilisation":
                {
                • "type":"number",
                • "title":"95th Percentile Capacity Utilisation",
                • "description":"Capacity utilisation value below which the bottom 95% of the values fall in. "
                }
              }
            }
          }
        }
      }
    }
    

                            
    
                        
    


                        
                            
                        

                        
                            
       
    Similar datasets