Changes

              
    

          
          
        
        

            
f
1
{
f
1
{
            
2
  "author": "",
2
  "author": "",
            
3
  "author_email": "",
3
  "author_email": "",
            
4
  "cloud_storage_key_segment": 
4
  "cloud_storage_key_segment": 
            
5
"ukpn-substation-level-smart-meter-data",
5
"ukpn-substation-level-smart-meter-data",
            
6
  "creator_user_id": "c56c870b-5347-490c-b52a-e19c774222a9",
6
  "creator_user_id": "c56c870b-5347-490c-b52a-e19c774222a9",
            
7
  "extras": [
7
  "extras": [
            
8
    {
8
    {
            
9
      "key": "Processing_level",
9
      "key": "Processing_level",
            
10
      "value": "raw"
10
      "value": "raw"
            
11
    }
11
    }
            
12
  ],
12
  ],
            
13
  "groups": [],
13
  "groups": [],
            
14
  "id": "63897b5b-ea83-401f-be49-402c3caa74e1",
14
  "id": "63897b5b-ea83-401f-be49-402c3caa74e1",
            
15
  "isopen": true,
15
  "isopen": true,
            
16
  "license_id": "cc-by",
16
  "license_id": "cc-by",
            
17
  "license_title": "Creative Commons Attribution",
17
  "license_title": "Creative Commons Attribution",
            
18
  "license_url": "http://www.opendefinition.org/licenses/cc-by",
18
  "license_url": "http://www.opendefinition.org/licenses/cc-by",
            
19
  "maintainer": "Richard Snape",
19
  "maintainer": "Richard Snape",
            
20
  "maintainer_email": "richard.snape@es.catapult.org.uk",
20
  "maintainer_email": "richard.snape@es.catapult.org.uk",
            
21
  "metadata_created": "2025-09-04T15:10:28.972774",
21
  "metadata_created": "2025-09-04T15:10:28.972774",
            
n
22
  "metadata_modified": "2025-09-04T15:14:13.731088",
n
22
  "metadata_modified": "2025-09-04T15:22:09.773852",
            
23
  "name": "catapult--ukpn-substation-level-smart-meter-data",
23
  "name": "catapult--ukpn-substation-level-smart-meter-data",
            
24
  "notes": "This data mirrors the substation level smart meter data 
24
  "notes": "This data mirrors the substation level smart meter data 
            
25
published by UKPN as mandated by Ofgem.  The data here is aggregated 
25
published by UKPN as mandated by Ofgem.  The data here is aggregated 
            
26
to substation level, with half hourly time granularity.  There are 
26
to substation level, with half hourly time granularity.  There are 
            
27
some restrictions on data publication - one of the main ones being 
27
some restrictions on data publication - one of the main ones being 
            
28
that only aggregations containing 5 or more smart meters are 
28
that only aggregations containing 5 or more smart meters are 
            
t
29
published.  The initial upload is for February and July 2025, with the 
t
29
published.  The initial upload is for February 2024 and July 2025, 
            
30
intention to update this on a monthly basis.\r\n\r\nFor data products 
30
with the intention to update this on a monthly basis.\r\n\r\nFor data 
            
31
aggregating this data between Network operators, watch this space!",
31
products aggregating this data between Network operators, watch this 
            
32
space!",
            
32
  "num_resources": 1,
33
  "num_resources": 1,
            
33
  "num_tags": 2,
34
  "num_tags": 2,
            
34
  "organization": {
35
  "organization": {
            
35
    "approval_status": "approved",
36
    "approval_status": "approved",
            
36
    "created": "2025-07-10T14:52:53.643658",
37
    "created": "2025-07-10T14:52:53.643658",
            
37
    "description": "## Accelerating Net Zero energy 
38
    "description": "## Accelerating Net Zero energy 
            
38
innovation\r\n\r\nWe use a \u2018whole energy\u2019 system capability 
39
innovation\r\n\r\nWe use a \u2018whole energy\u2019 system capability 
            
39
to support innovative companies \u2014 small and large \u2013 to test, 
40
to support innovative companies \u2014 small and large \u2013 to test, 
            
40
trial and scale their new products and services. Our impact comes when 
41
trial and scale their new products and services. Our impact comes when 
            
41
those innovators attract new customers, new investment and new grants 
42
those innovators attract new customers, new investment and new grants 
            
42
so they can thrive in the future energy system.\r\n\r\nLaunched in 
43
so they can thrive in the future energy system.\r\n\r\nLaunched in 
            
43
2015 by Innovate UK, the Catapult has built a team of more than 250 
44
2015 by Innovate UK, the Catapult has built a team of more than 250 
            
44
people, with a range of technical, engineering, consumer, commercial, 
45
people, with a range of technical, engineering, consumer, commercial, 
            
45
incubation, digital and policy expertise. They draw on sector-leading 
46
incubation, digital and policy expertise. They draw on sector-leading 
            
46
test facilities, modelling tools, and data collected from our back 
47
test facilities, modelling tools, and data collected from our back 
            
47
catalogue of more than 500 research projects.\r\n\r\nBased in 
48
catalogue of more than 500 research projects.\r\n\r\nBased in 
            
48
Birmingham, Energy Systems Catapult is part of a network of nine 
49
Birmingham, Energy Systems Catapult is part of a network of nine 
            
49
world-leading technology and innovation centres, established by 
50
world-leading technology and innovation centres, established by 
            
50
Innovate UK. The Catapult Network fosters collaboration between 
51
Innovate UK. The Catapult Network fosters collaboration between 
            
51
industry, government, research organisations, academia, and many 
52
industry, government, research organisations, academia, and many 
            
52
others to transform great ideas into valuable products and services.",
53
others to transform great ideas into valuable products and services.",
            
53
    "id": "c2fc38c2-0d7a-4fec-b43d-135889f396ff",
54
    "id": "c2fc38c2-0d7a-4fec-b43d-135889f396ff",
            
54
    "image_url": "2025-08-28-143222.016007ESC-LOGO-RGB-pink-1.png",
55
    "image_url": "2025-08-28-143222.016007ESC-LOGO-RGB-pink-1.png",
            
55
    "is_organization": true,
56
    "is_organization": true,
            
56
    "name": "catapult",
57
    "name": "catapult",
            
57
    "state": "active",
58
    "state": "active",
            
58
    "title": "Catapult",
59
    "title": "Catapult",
            
59
    "type": "organization"
60
    "type": "organization"
            
60
  },
61
  },
            
61
  "owner_org": "c2fc38c2-0d7a-4fec-b43d-135889f396ff",
62
  "owner_org": "c2fc38c2-0d7a-4fec-b43d-135889f396ff",
            
62
  "private": false,
63
  "private": false,
            
63
  "relationships_as_object": [],
64
  "relationships_as_object": [],
            
64
  "relationships_as_subject": [],
65
  "relationships_as_subject": [],
            
65
  "resources": [
66
  "resources": [
            
66
    {
67
    {
            
67
      "cache_last_updated": null,
68
      "cache_last_updated": null,
            
68
      "cache_url": null,
69
      "cache_url": null,
            
69
      "cloud_storage_key": 
70
      "cloud_storage_key": 
            
70
n-level-smart-meter-data/ukpn_july_25_substation_smart_meter.parquet",
71
n-level-smart-meter-data/ukpn_july_25_substation_smart_meter.parquet",
            
71
      "created": "2025-09-04T15:13:59.431061",
72
      "created": "2025-09-04T15:13:59.431061",
            
72
      "datastore_active": false,
73
      "datastore_active": false,
            
73
      "description": "Data Schema:\r\n\r\n``` 
74
      "description": "Data Schema:\r\n\r\n``` 
            
74
ion_records\"\r\n}\r\n}\r\n}\r\n},\r\n\"geoJSON\":{\r\n\"title\":\"Geo 
75
ion_records\"\r\n}\r\n}\r\n}\r\n},\r\n\"geoJSON\":{\r\n\"title\":\"Geo 
            
75
JSON object\",\r\n\"description\":\"Schema for a Geo JSON 
76
JSON object\",\r\n\"description\":\"Schema for a Geo JSON 
            
76
atureCollection\"\r\n}\r\n]\r\n},\r\n\"bbox\":{\r\n\"description\":\"A 
77
atureCollection\"\r\n}\r\n]\r\n},\r\n\"bbox\":{\r\n\"description\":\"A 
            
77
bounding box as defined by 
78
bounding box as defined by 
            
78
"\r\n}\r\n},\r\n\"crs\":{\r\n\"title\":\"crs\",\r\n\"description\":\"a 
79
"\r\n}\r\n},\r\n\"crs\":{\r\n\"title\":\"crs\",\r\n\"description\":\"a 
            
79
Coordinate Reference System 
80
Coordinate Reference System 
            
80
,\r\n\"type\":{\r\n\"type\":\"string\",\r\n\"description\":\"Suggested 
81
,\r\n\"type\":{\r\n\"type\":\"string\",\r\n\"description\":\"Suggested 
            
81
values: proj4, ogjwkt, 
82
values: proj4, ogjwkt, 
            
82
ection\":{\r\n\"title\":\"GeometryCollection\",\r\n\"description\":\"A 
83
ection\":{\r\n\"title\":\"GeometryCollection\",\r\n\"description\":\"A 
            
83
collection of geometry 
84
collection of geometry 
            
84
\n},\r\n\"feature\":{\r\n\"title\":\"Feature\",\r\n\"description\":\"A 
85
\n},\r\n\"feature\":{\r\n\"title\":\"Feature\",\r\n\"description\":\"A 
            
85
Geo JSON feature 
86
Geo JSON feature 
            
86
lection\":{\r\n\"title\":\"FeatureCollection\",\r\n\"description\":\"A 
87
lection\":{\r\n\"title\":\"FeatureCollection\",\r\n\"description\":\"A 
            
87
Geo JSON feature 
88
Geo JSON feature 
            
88
\r\n\"geometry\":{\r\n\"title\":\"geometry\",\r\n\"description\":\"One 
89
\r\n\"geometry\":{\r\n\"title\":\"geometry\",\r\n\"description\":\"One 
            
89
geometry as defined by 
90
geometry as defined by 
            
90
n\"\r\n}\r\n}\r\n}\r\n}\r\n],\r\n\"position\":{\r\n\"description\":\"A 
91
n\"\r\n}\r\n}\r\n}\r\n}\r\n],\r\n\"position\":{\r\n\"description\":\"A 
            
91
single 
92
single 
            
92
onalItems\":false\r\n},\r\n\"positionArray\":{\r\n\"description\":\"An 
93
onalItems\":false\r\n},\r\n\"positionArray\":{\r\n\"description\":\"An 
            
93
array of 
94
array of 
            
94
ions/position\"\r\n}\r\n},\r\n\"lineString\":{\r\n\"description\":\"An 
95
ions/position\"\r\n}\r\n},\r\n\"lineString\":{\r\n\"description\":\"An 
            
95
array of two or more 
96
array of two or more 
            
96
nItems\":2\r\n}\r\n]\r\n},\r\n\"linearRing\":{\r\n\"description\":\"An 
97
nItems\":2\r\n}\r\n]\r\n},\r\n\"linearRing\":{\r\n\"description\":\"An 
            
97
array of four positions where the first equals the 
98
array of four positions where the first equals the 
            
98
"minItems\":4\r\n}\r\n]\r\n},\r\n\"polygon\":{\r\n\"description\":\"An 
99
"minItems\":4\r\n}\r\n]\r\n},\r\n\"polygon\":{\r\n\"description\":\"An 
            
99
array of linear 
100
array of linear 
            
100
":\"string\",\r\n\"title\":\"dataset_id\",\r\n\"description\":\"Unique 
101
":\"string\",\r\n\"title\":\"dataset_id\",\r\n\"description\":\"Unique 
            
101
dataset 
102
dataset 
            
102
\":\"string\",\r\n\"title\":\"dno\",\r\n\"description\":\"Distribution 
103
\":\"string\",\r\n\"title\":\"dno\",\r\n\"description\":\"Distribution 
            
103
Network 
104
Network 
            
104
tring\",\r\n\"title\":\"dno_alias\",\r\n\"description\":\"Distribution 
105
tring\",\r\n\"title\":\"dno_alias\",\r\n\"description\":\"Distribution 
            
105
Network Operator and Licence 
106
Network Operator and Licence 
            
106
",\r\n\"title\":\"secondary_substation_id\",\r\n\"description\":\"Site 
107
",\r\n\"title\":\"secondary_substation_id\",\r\n\"description\":\"Site 
            
107
":\"number\"\r\n},\r\n\"title\":\"geopoint\",\r\n\"description\":\"Geo 
108
":\"number\"\r\n},\r\n\"title\":\"geopoint\",\r\n\"description\":\"Geo 
            
108
point (Latitude and Longitude) of secondary substation 
109
point (Latitude and Longitude) of secondary substation 
            
109
itle\":\"aggregated_device_count_active\",\r\n\"description\":\"Number 
110
itle\":\"aggregated_device_count_active\",\r\n\"description\":\"Number 
            
110
of Active Smart 
111
of Active Smart 
            
111
e\":\"primary_consumption_active_import\",\r\n\"description\":\"Single 
112
e\":\"primary_consumption_active_import\",\r\n\"description\":\"Single 
            
112
Element meter aggregated value 
113
Element meter aggregated value 
            
113
e\":\"secondary_consumption_active_import\",\r\n\"description\":\"Twin 
114
e\":\"secondary_consumption_active_import\",\r\n\"description\":\"Twin 
            
114
or Dual Tariff meters where we have a secondary measurement - 
115
or Dual Tariff meters where we have a secondary measurement - 
            
115
aggregated value 
116
aggregated value 
            
116
"title\":\"total_consumption_active_import\",\r\n\"description\":\"Sum 
117
"title\":\"total_consumption_active_import\",\r\n\"description\":\"Sum 
            
117
of Primary and Secondary Consumption 
118
of Primary and Secondary Consumption 
            
118
itle\":\"total_consumption_reactive_import\",\r\n\"description\":\"Sum 
119
itle\":\"total_consumption_reactive_import\",\r\n\"description\":\"Sum 
            
119
of Primary and Secondary Consumption 
120
of Primary and Secondary Consumption 
            
120
tle\":\"data_collection_log_timestamp\",\r\n\"description\":\"Interval 
121
tle\":\"data_collection_log_timestamp\",\r\n\"description\":\"Interval 
            
121
read 
122
read 
            
122
date-time\",\r\n\"title\":\"insert_time\",\r\n\"description\":\"Record 
123
date-time\",\r\n\"title\":\"insert_time\",\r\n\"description\":\"Record 
            
123
insertion 
124
insertion 
            
124
time\",\r\n\"title\":\"last_modified_time\",\r\n\"description\":\"Last 
125
time\",\r\n\"title\":\"last_modified_time\",\r\n\"description\":\"Last 
            
125
update of the record\"\r\n}\r\n}\r\n}\r\n}\r\n}\r\n}\r\n}```\r\n",
126
update of the record\"\r\n}\r\n}\r\n}\r\n}\r\n}\r\n}\r\n}```\r\n",
            
126
      "format": "",
127
      "format": "",
            
127
      "hash": "",
128
      "hash": "",
            
128
      "id": "c4b98876-2b46-4675-babd-e7cb59342ecb",
129
      "id": "c4b98876-2b46-4675-babd-e7cb59342ecb",
            
129
      "last_modified": null,
130
      "last_modified": null,
            
130
      "metadata_modified": "2025-09-04T15:14:13.053308",
131
      "metadata_modified": "2025-09-04T15:14:13.053308",
            
131
      "mimetype": null,
132
      "mimetype": null,
            
132
      "mimetype_inner": null,
133
      "mimetype_inner": null,
            
133
      "name": "ukpn_july_25_substation_smart_meter.parquet",
134
      "name": "ukpn_july_25_substation_smart_meter.parquet",
            
134
      "package_id": "63897b5b-ea83-401f-be49-402c3caa74e1",
135
      "package_id": "63897b5b-ea83-401f-be49-402c3caa74e1",
            
135
      "position": 0,
136
      "position": 0,
            
136
      "resource_type": null,
137
      "resource_type": null,
            
137
      "size": 22389290,
138
      "size": 22389290,
            
138
      "state": "active",
139
      "state": "active",
            
139
      "tags": "Energy",
140
      "tags": "Energy",
            
140
      "url": 
141
      "url": 
            
141
bd-e7cb59342ecb/download/ukpn_july_25_substation_smart_meter.parquet",
142
bd-e7cb59342ecb/download/ukpn_july_25_substation_smart_meter.parquet",
            
142
      "url_type": "upload"
143
      "url_type": "upload"
            
143
    }
144
    }
            
144
  ],
145
  ],
            
145
  "state": "active",
146
  "state": "active",
            
146
  "tags": [
147
  "tags": [
            
147
    {
148
    {
            
148
      "display_name": "Energy",
149
      "display_name": "Energy",
            
149
      "id": "b4d64da6-0ac1-4346-a9af-44add070dd28",
150
      "id": "b4d64da6-0ac1-4346-a9af-44add070dd28",
            
150
      "name": "Energy",
151
      "name": "Energy",
            
151
      "state": "active",
152
      "state": "active",
            
152
      "vocabulary_id": "0a37a2fa-a9df-4e4a-a3f9-b88db224084b"
153
      "vocabulary_id": "0a37a2fa-a9df-4e4a-a3f9-b88db224084b"
            
153
    },
154
    },
            
154
    {
155
    {
            
155
      "display_name": "Energy",
156
      "display_name": "Energy",
            
156
      "id": "44e0baeb-83ab-4bda-831a-3df4689c70d8",
157
      "id": "44e0baeb-83ab-4bda-831a-3df4689c70d8",
            
157
      "name": "Energy",
158
      "name": "Energy",
            
158
      "state": "active",
159
      "state": "active",
            
159
      "vocabulary_id": null
160
      "vocabulary_id": null
            
160
    },
161
    },
            
161
    {
162
    {
            
162
      "name": "Energy",
163
      "name": "Energy",
            
163
      "vocabulary_id": "0a37a2fa-a9df-4e4a-a3f9-b88db224084b"
164
      "vocabulary_id": "0a37a2fa-a9df-4e4a-a3f9-b88db224084b"
            
164
    }
165
    }
            
165
  ],
166
  ],
            
166
  "title": "UKPN substation level smart meter data",
167
  "title": "UKPN substation level smart meter data",
            
167
  "type": "dataset",
168
  "type": "dataset",
            
168
  "url": 
169
  "url": 
            
169
explore/dataset/ukpn-smart-meter-consumption-substation/information/",
170
explore/dataset/ukpn-smart-meter-consumption-substation/information/",
            
170
  "version": "1.0"
171
  "version": "1.0"
            
171
}
172
}