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:12.468801",
n
22
  "metadata_modified": "2025-09-04T15:14:13.048529",
            
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 
            
29
published.  The initial upload is for February and July 2025, with the 
29
published.  The initial upload is for February and July 2025, with the 
            
30
intention to update this on a monthly basis.\r\n\r\nFor data products 
30
intention to update this on a monthly basis.\r\n\r\nFor data products 
            
31
aggregating this data between Network operators, watch this space!",
31
aggregating this data between Network operators, watch this space!",
            
32
  "num_resources": 1,
32
  "num_resources": 1,
            
33
  "num_tags": 2,
33
  "num_tags": 2,
            
34
  "organization": {
34
  "organization": {
            
35
    "approval_status": "approved",
35
    "approval_status": "approved",
            
36
    "created": "2025-07-10T14:52:53.643658",
36
    "created": "2025-07-10T14:52:53.643658",
            
37
    "description": "## Accelerating Net Zero energy 
37
    "description": "## Accelerating Net Zero energy 
            
38
innovation\r\n\r\nWe use a \u2018whole energy\u2019 system capability 
38
innovation\r\n\r\nWe use a \u2018whole energy\u2019 system capability 
            
39
to support innovative companies \u2014 small and large \u2013 to test, 
39
to support innovative companies \u2014 small and large \u2013 to test, 
            
40
trial and scale their new products and services. Our impact comes when 
40
trial and scale their new products and services. Our impact comes when 
            
41
those innovators attract new customers, new investment and new grants 
41
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 
42
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 
43
2015 by Innovate UK, the Catapult has built a team of more than 250 
            
44
people, with a range of technical, engineering, consumer, commercial, 
44
people, with a range of technical, engineering, consumer, commercial, 
            
45
incubation, digital and policy expertise. They draw on sector-leading 
45
incubation, digital and policy expertise. They draw on sector-leading 
            
46
test facilities, modelling tools, and data collected from our back 
46
test facilities, modelling tools, and data collected from our back 
            
47
catalogue of more than 500 research projects.\r\n\r\nBased in 
47
catalogue of more than 500 research projects.\r\n\r\nBased in 
            
48
Birmingham, Energy Systems Catapult is part of a network of nine 
48
Birmingham, Energy Systems Catapult is part of a network of nine 
            
49
world-leading technology and innovation centres, established by 
49
world-leading technology and innovation centres, established by 
            
50
Innovate UK. The Catapult Network fosters collaboration between 
50
Innovate UK. The Catapult Network fosters collaboration between 
            
51
industry, government, research organisations, academia, and many 
51
industry, government, research organisations, academia, and many 
            
52
others to transform great ideas into valuable products and services.",
52
others to transform great ideas into valuable products and services.",
            
53
    "id": "c2fc38c2-0d7a-4fec-b43d-135889f396ff",
53
    "id": "c2fc38c2-0d7a-4fec-b43d-135889f396ff",
            
54
    "image_url": "2025-08-28-143222.016007ESC-LOGO-RGB-pink-1.png",
54
    "image_url": "2025-08-28-143222.016007ESC-LOGO-RGB-pink-1.png",
            
55
    "is_organization": true,
55
    "is_organization": true,
            
56
    "name": "catapult",
56
    "name": "catapult",
            
57
    "state": "active",
57
    "state": "active",
            
58
    "title": "Catapult",
58
    "title": "Catapult",
            
59
    "type": "organization"
59
    "type": "organization"
            
60
  },
60
  },
            
61
  "owner_org": "c2fc38c2-0d7a-4fec-b43d-135889f396ff",
61
  "owner_org": "c2fc38c2-0d7a-4fec-b43d-135889f396ff",
            
62
  "private": false,
62
  "private": false,
            
63
  "relationships_as_object": [],
63
  "relationships_as_object": [],
            
64
  "relationships_as_subject": [],
64
  "relationships_as_subject": [],
            
65
  "resources": [
65
  "resources": [
            
66
    {
66
    {
            
67
      "cache_last_updated": null,
67
      "cache_last_updated": null,
            
68
      "cache_url": null,
68
      "cache_url": null,
            
69
      "cloud_storage_key": 
69
      "cloud_storage_key": 
            
70
n-level-smart-meter-data/ukpn_july_25_substation_smart_meter.parquet",
70
n-level-smart-meter-data/ukpn_july_25_substation_smart_meter.parquet",
            
71
      "created": "2025-09-04T15:13:59.431061",
71
      "created": "2025-09-04T15:13:59.431061",
            
72
      "datastore_active": false,
72
      "datastore_active": false,
            
73
      "description": "Data Schema:\r\n\r\n``` 
73
      "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 
74
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 
75
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 
76
atureCollection\"\r\n}\r\n]\r\n},\r\n\"bbox\":{\r\n\"description\":\"A 
            
77
bounding box as defined by 
77
bounding box as defined by 
            
78
"\r\n}\r\n},\r\n\"crs\":{\r\n\"title\":\"crs\",\r\n\"description\":\"a 
78
"\r\n}\r\n},\r\n\"crs\":{\r\n\"title\":\"crs\",\r\n\"description\":\"a 
            
79
Coordinate Reference System 
79
Coordinate Reference System 
            
80
,\r\n\"type\":{\r\n\"type\":\"string\",\r\n\"description\":\"Suggested 
80
,\r\n\"type\":{\r\n\"type\":\"string\",\r\n\"description\":\"Suggested 
            
81
values: proj4, ogjwkt, 
81
values: proj4, ogjwkt, 
            
82
ection\":{\r\n\"title\":\"GeometryCollection\",\r\n\"description\":\"A 
82
ection\":{\r\n\"title\":\"GeometryCollection\",\r\n\"description\":\"A 
            
83
collection of geometry 
83
collection of geometry 
            
84
\n},\r\n\"feature\":{\r\n\"title\":\"Feature\",\r\n\"description\":\"A 
84
\n},\r\n\"feature\":{\r\n\"title\":\"Feature\",\r\n\"description\":\"A 
            
85
Geo JSON feature 
85
Geo JSON feature 
            
86
lection\":{\r\n\"title\":\"FeatureCollection\",\r\n\"description\":\"A 
86
lection\":{\r\n\"title\":\"FeatureCollection\",\r\n\"description\":\"A 
            
87
Geo JSON feature 
87
Geo JSON feature 
            
88
\r\n\"geometry\":{\r\n\"title\":\"geometry\",\r\n\"description\":\"One 
88
\r\n\"geometry\":{\r\n\"title\":\"geometry\",\r\n\"description\":\"One 
            
89
geometry as defined by 
89
geometry as defined by 
            
90
n\"\r\n}\r\n}\r\n}\r\n}\r\n],\r\n\"position\":{\r\n\"description\":\"A 
90
n\"\r\n}\r\n}\r\n}\r\n}\r\n],\r\n\"position\":{\r\n\"description\":\"A 
            
91
single 
91
single 
            
92
onalItems\":false\r\n},\r\n\"positionArray\":{\r\n\"description\":\"An 
92
onalItems\":false\r\n},\r\n\"positionArray\":{\r\n\"description\":\"An 
            
93
array of 
93
array of 
            
94
ions/position\"\r\n}\r\n},\r\n\"lineString\":{\r\n\"description\":\"An 
94
ions/position\"\r\n}\r\n},\r\n\"lineString\":{\r\n\"description\":\"An 
            
95
array of two or more 
95
array of two or more 
            
96
nItems\":2\r\n}\r\n]\r\n},\r\n\"linearRing\":{\r\n\"description\":\"An 
96
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 
97
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 
98
"minItems\":4\r\n}\r\n]\r\n},\r\n\"polygon\":{\r\n\"description\":\"An 
            
99
array of linear 
99
array of linear 
            
100
":\"string\",\r\n\"title\":\"dataset_id\",\r\n\"description\":\"Unique 
100
":\"string\",\r\n\"title\":\"dataset_id\",\r\n\"description\":\"Unique 
            
101
dataset 
101
dataset 
            
102
\":\"string\",\r\n\"title\":\"dno\",\r\n\"description\":\"Distribution 
102
\":\"string\",\r\n\"title\":\"dno\",\r\n\"description\":\"Distribution 
            
103
Network 
103
Network 
            
104
tring\",\r\n\"title\":\"dno_alias\",\r\n\"description\":\"Distribution 
104
tring\",\r\n\"title\":\"dno_alias\",\r\n\"description\":\"Distribution 
            
105
Network Operator and Licence 
105
Network Operator and Licence 
            
106
",\r\n\"title\":\"secondary_substation_id\",\r\n\"description\":\"Site 
106
",\r\n\"title\":\"secondary_substation_id\",\r\n\"description\":\"Site 
            
107
":\"number\"\r\n},\r\n\"title\":\"geopoint\",\r\n\"description\":\"Geo 
107
":\"number\"\r\n},\r\n\"title\":\"geopoint\",\r\n\"description\":\"Geo 
            
108
point (Latitude and Longitude) of secondary substation 
108
point (Latitude and Longitude) of secondary substation 
            
109
itle\":\"aggregated_device_count_active\",\r\n\"description\":\"Number 
109
itle\":\"aggregated_device_count_active\",\r\n\"description\":\"Number 
            
110
of Active Smart 
110
of Active Smart 
            
111
e\":\"primary_consumption_active_import\",\r\n\"description\":\"Single 
111
e\":\"primary_consumption_active_import\",\r\n\"description\":\"Single 
            
112
Element meter aggregated value 
112
Element meter aggregated value 
            
113
e\":\"secondary_consumption_active_import\",\r\n\"description\":\"Twin 
113
e\":\"secondary_consumption_active_import\",\r\n\"description\":\"Twin 
            
114
or Dual Tariff meters where we have a secondary measurement - 
114
or Dual Tariff meters where we have a secondary measurement - 
            
115
aggregated value 
115
aggregated value 
            
116
"title\":\"total_consumption_active_import\",\r\n\"description\":\"Sum 
116
"title\":\"total_consumption_active_import\",\r\n\"description\":\"Sum 
            
117
of Primary and Secondary Consumption 
117
of Primary and Secondary Consumption 
            
118
itle\":\"total_consumption_reactive_import\",\r\n\"description\":\"Sum 
118
itle\":\"total_consumption_reactive_import\",\r\n\"description\":\"Sum 
            
119
of Primary and Secondary Consumption 
119
of Primary and Secondary Consumption 
            
120
tle\":\"data_collection_log_timestamp\",\r\n\"description\":\"Interval 
120
tle\":\"data_collection_log_timestamp\",\r\n\"description\":\"Interval 
            
121
read 
121
read 
            
122
date-time\",\r\n\"title\":\"insert_time\",\r\n\"description\":\"Record 
122
date-time\",\r\n\"title\":\"insert_time\",\r\n\"description\":\"Record 
            
123
insertion 
123
insertion 
            
124
time\",\r\n\"title\":\"last_modified_time\",\r\n\"description\":\"Last 
124
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",
125
update of the record\"\r\n}\r\n}\r\n}\r\n}\r\n}\r\n}\r\n}```\r\n",
            
126
      "format": "",
126
      "format": "",
            
127
      "hash": "",
127
      "hash": "",
            
128
      "id": "c4b98876-2b46-4675-babd-e7cb59342ecb",
128
      "id": "c4b98876-2b46-4675-babd-e7cb59342ecb",
            
129
      "last_modified": null,
129
      "last_modified": null,
            
n
130
      "metadata_modified": "2025-09-04T15:14:00.873830",
n
130
      "metadata_modified": "2025-09-04T15:14:13.053308",
            
131
      "mimetype": null,
131
      "mimetype": null,
            
132
      "mimetype_inner": null,
132
      "mimetype_inner": null,
            
133
      "name": "ukpn_july_25_substation_smart_meter.parquet",
133
      "name": "ukpn_july_25_substation_smart_meter.parquet",
            
134
      "package_id": "63897b5b-ea83-401f-be49-402c3caa74e1",
134
      "package_id": "63897b5b-ea83-401f-be49-402c3caa74e1",
            
135
      "position": 0,
135
      "position": 0,
            
136
      "resource_type": null,
136
      "resource_type": null,
            
137
      "size": 22389290,
137
      "size": 22389290,
            
138
      "state": "active",
138
      "state": "active",
            
139
      "tags": "Energy",
139
      "tags": "Energy",
            
t
140
      "upload_in_progress": true,
t

            
141
      "url": 
140
      "url": 
            
142
bd-e7cb59342ecb/download/ukpn_july_25_substation_smart_meter.parquet",
141
bd-e7cb59342ecb/download/ukpn_july_25_substation_smart_meter.parquet",
            
143
      "url_type": "upload"
142
      "url_type": "upload"
            
144
    }
143
    }
            
145
  ],
144
  ],
            
146
  "state": "active",
145
  "state": "active",
            
147
  "tags": [
146
  "tags": [
            
148
    {
147
    {
            
149
      "display_name": "Energy",
148
      "display_name": "Energy",
            
150
      "id": "b4d64da6-0ac1-4346-a9af-44add070dd28",
149
      "id": "b4d64da6-0ac1-4346-a9af-44add070dd28",
            
151
      "name": "Energy",
150
      "name": "Energy",
            
152
      "state": "active",
151
      "state": "active",
            
153
      "vocabulary_id": "0a37a2fa-a9df-4e4a-a3f9-b88db224084b"
152
      "vocabulary_id": "0a37a2fa-a9df-4e4a-a3f9-b88db224084b"
            
154
    },
153
    },
            
155
    {
154
    {
            
156
      "display_name": "Energy",
155
      "display_name": "Energy",
            
157
      "id": "44e0baeb-83ab-4bda-831a-3df4689c70d8",
156
      "id": "44e0baeb-83ab-4bda-831a-3df4689c70d8",
            
158
      "name": "Energy",
157
      "name": "Energy",
            
159
      "state": "active",
158
      "state": "active",
            
160
      "vocabulary_id": null
159
      "vocabulary_id": null
            
161
    },
160
    },
            
162
    {
161
    {
            
163
      "name": "Energy",
162
      "name": "Energy",
            
164
      "vocabulary_id": "0a37a2fa-a9df-4e4a-a3f9-b88db224084b"
163
      "vocabulary_id": "0a37a2fa-a9df-4e4a-a3f9-b88db224084b"
            
165
    }
164
    }
            
166
  ],
165
  ],
            
167
  "title": "UKPN substation level smart meter data",
166
  "title": "UKPN substation level smart meter data",
            
168
  "type": "dataset",
167
  "type": "dataset",
            
169
  "url": 
168
  "url": 
            
170
explore/dataset/ukpn-smart-meter-consumption-substation/information/",
169
explore/dataset/ukpn-smart-meter-consumption-substation/information/",
            
171
  "version": "1.0"
170
  "version": "1.0"
            
172
}
171
}