Smart Meter Consumption - LV Feeder

Information Comments (0)

Introduction

The dataset presented shows import consumption data at a low voltage (LV) feeder level, together with a count of smart meters contributing the aggregated half-hourly values. The data shown now includes values for both Active Energy import and Reactive. This dataset is currently from 40,000 smart meters in our Eastern Power Networks (EPN) region.

This will be gradually expanded during 2025 to include both import and export energy data from all smart meters within our three regions of EPN, London Power Networks (LPN), and South Eastern Power Networks (SPN).

Methodological Approach

Primary Consumption Active Import is aggregated from the number of active devices during a half hour period. Note: if a device was not contactable during a half period, its data is not aggregated.

Quality Control Statement

Please be aware that this data is being made available to provide an early insight of what we propose to publish from all smart meters within our regions. We continue to carry out data validation checks to improve data quality before publishing the full dataset - so suggest caution if you plan to utilize this currently available information. We will update this message once the full dataset that includes both import and export energy data is published.

Please provide any thoughts, comments, or suggestions here.

Assurance Statement

The Smart Metering Team has checked to ensure data accuracy and consistency.

Other

Definitions of key terms related to this dataset can be found in the Open Data Portal Glossary: Open Data Portal Glossary

Download dataset information: Metadata (JSON)

Attachments

Click to expand Click to collapse

Dataset schema

Click to expand Click to collapse
dataset_id
Unique dataset identifier

No description available for this field.

Name (identifier) 
dataset_id
Type 
text
Sample 
                       		                   
               
       
   
       
dno
       
           
               
Distribution Network Operator
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
dno
                       		                   
                   
                                                  Type                                                                         
text
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
dno_alias
       
           
               
Distribution Network Operator and Licence Area
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
dno_alias
                       		                   
                   
                                                  Type                                                                         
text
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
secondary_substation_id
       
           
               
Site reference
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
secondary_substation_id
                       		                   
                   
                                                  Type                                                                         
text
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
lv_feeder_id
       
           
               
Feeder ID Number
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
lv_feeder_id
                       		                   
                   
                                                  Type                                                                         
integer
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
substation_geo_location
       
           
               
Geo point (Latitude and Longitude) of secondary substation location.
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
geopoint
                       		                   
                   
                                                  Type                                                                         
geo point
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
aggregated_device_count_active
       
           
               
Number of Active Smart Meters
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
aggregated_device_count_active
                       		                   
                   
                                                  Type                                                                         
integer
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
primary_consumption_active_import
       
           
               
Single Element meter aggregated value (Wh)
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
primary_consumption_active_import
                       		                   
                   
                                                  Type                                                                         
integer
                       		                   
                   
                                                  Unit                                                                         
Wh
                       		                   
                   
                                                  Sample                                                                         
                       		                   
               
       
   
       
secondary_consumption_active_import
       
           
               
Twin or Dual Tariff meters where we have a secondary measurement - aggregated value (Wh)
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
secondary_consumption_active_import
                       		                   
                   
                                                  Type                                                                         
integer
                       		                   
                   
                                                  Unit                                                                         
Wh
                       		                   
                   
                                                  Sample                                                                         
                       		                   
               
       
   
       
total_consumption_active_import
       
           
               
Sum of Primary and Secondary Consumption (Wh)
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
total_consumption_active_import
                       		                   
                   
                                                  Type                                                                         
integer
                       		                   
                   
                                                  Unit                                                                         
Wh
                       		                   
                   
                                                  Sample                                                                         
                       		                   
               
       
   
       
aggregated_device_count_reactive
       
           
               
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
aggregated_device_count_reactive
                       		                   
                   
                                                  Type                                                                         
integer
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
total_consumption_reactive_import
       
           
               
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
total_consumption_reactive_import
                       		                   
                   
                                                  Type                                                                         
integer
                       		                   
                   
                                                  Unit                                                                         
Wh
                       		                   
                   
                                                  Sample                                                                         
                       		                   
               
       
   
       
data_collection_log_timestamp
       
           
               
Interval read time
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
data_collection_log_timestamp
                       		                   
                   
                                                  Type                                                                         
datetime
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
insert_time
       
           
               
Record insertion timestamp
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
insert_time
                       		                   
                   
                                                  Type                                                                         
datetime
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   
       
last_modified_time
       
           
               
Last update of the record
               
No description available for this field.
           
               
                   
                                                  Name (identifier)                                                                         
last_modified_time
                       		                   
                   
                                                  Type                                                                         
datetime
                       		                   
                                      
                                                  Sample                                                                         
                       		                   
               
       
   

                                
JSON Schema

                                

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

                                
   
{
  • "title":"ukpn-smart-meter-consumption-lv-feeder@ukpowernetworks",
  • "type":"object",
  • "oneOf":
    [
    • {
      • "$ref":"#/definitions/ukpn-smart-meter-consumption-lv-feeder@ukpowernetworks"
      }
    ]
    ,
  • "definitions":
    {
    • "ukpn-smart-meter-consumption-lv-feeder@ukpowernetworks":
      {
      • "properties":
        {
        • "records":
          {
          • "type":"array",
          • "items":
            {
            • "$ref":"#/definitions/ukpn-smart-meter-consumption-lv-feeder@ukpowernetworks_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"
            }
          }
        }
        ,
      • "ukpn-smart-meter-consumption-lv-feeder@ukpowernetworks_records":
        {
        • "properties":
          {
          • "fields":
            {
            • "type":"object",
            • "properties":
              {
              • "dataset_id":
                {
                • "type":"string",
                • "title":"dataset_id",
                • "description":"Unique dataset identifier"
                }
                ,
              • "dno":
                {
                • "type":"string",
                • "title":"dno",
                • "description":"Distribution Network Operator"
                }
                ,
              • "dno_alias":
                {
                • "type":"string",
                • "title":"dno_alias",
                • "description":"Distribution Network Operator and Licence Area"
                }
                ,
              • "secondary_substation_id":
                {
                • "type":"string",
                • "title":"secondary_substation_id",
                • "description":"Site reference"
                }
                ,
              • "lv_feeder_id":
                {
                • "type":"integer",
                • "title":"lv_feeder_id",
                • "description":"Feeder ID Number"
                }
                ,
              • "geopoint":
                {
                • "type":"array",
                • "minItems":2,
                • "maxItems":2,
                • "items":
                  {
                  • "type":"number"
                  }
                  ,
                • "title":"substation_geo_location",
                • "description":"Geo point (Latitude and Longitude) of secondary substation location."
                }
                ,
              • "aggregated_device_count_active":
                {
                • "type":"integer",
                • "title":"aggregated_device_count_active",
                • "description":"Number of Active Smart Meters"
                }
                ,
              • "primary_consumption_active_import":
                {
                • "type":"integer",
                • "title":"primary_consumption_active_import",
                • "description":"Single Element meter aggregated value (Wh)",
                • "unit":"Wh"
                }
                ,
              • "secondary_consumption_active_import":
                {
                • "type":"integer",
                • "title":"secondary_consumption_active_import",
                • "description":"Twin or Dual Tariff meters where we have a secondary measurement - aggregated value (Wh)",
                • "unit":"Wh"
                }
                ,
              • "total_consumption_active_import":
                {
                • "type":"integer",
                • "title":"total_consumption_active_import",
                • "description":"Sum of Primary and Secondary Consumption (Wh)",
                • "unit":"Wh"
                }
                ,
              • "aggregated_device_count_reactive":
                {
                • "type":"integer",
                • "title":"aggregated_device_count_reactive",
                • "description":""
                }
                ,
              • "total_consumption_reactive_import":
                {
                • "type":"integer",
                • "title":"total_consumption_reactive_import",
                • "description":"",
                • "unit":"Wh"
                }
                ,
              • "data_collection_log_timestamp":
                {
                • "type":"string",
                • "format":"date-time",
                • "title":"data_collection_log_timestamp",
                • "description":"Interval read time"
                }
                ,
              • "insert_time":
                {
                • "type":"string",
                • "format":"date-time",
                • "title":"insert_time",
                • "description":"Record insertion timestamp"
                }
                ,
              • "last_modified_time":
                {
                • "type":"string",
                • "format":"date-time",
                • "title":"last_modified_time",
                • "description":"Last update of the record"
                }
              }
            }
          }
        }
      }
    }
    

                            
    
                        
    


                        

                        
                            
       
    Similar datasets