Changes
On November 22, 2023 at 2:13:37 PM UTC,
-
Updated description of Smart Meter Primary Substation Usage from
A Smart Meter prototype dataset
toSmart Meter Half Hourly Usage by Primary Substation including a lookup of Substation Name against NRN. This data set is provided by SSEN's smart meter adapter and cross referenced with SSEN's Network Reference Number (NRN). Both these data sets provide the Primary Substation NRN along with the aggregated consumption data in kWh and the relevant half hour time period for each day.
-
Added the following tags to Smart Meter Primary Substation Usage
-
Changed value of field
language
toEN
in Smart Meter Primary Substation Usage
| f | 1 | { | f | 1 | { |
| 2 | "author": "Shailesh Kumar", | 2 | "author": "Shailesh Kumar", | ||
| 3 | "author_email": "", | 3 | "author_email": "", | ||
| 4 | "conforms_to": "", | 4 | "conforms_to": "", | ||
| 5 | "contact_point": "", | 5 | "contact_point": "", | ||
| n | n | 6 | "contributor": "", | ||
| 7 | "coverage": [ | ||||
| 8 | { | ||||
| 9 | "location_name": "SEPD and SHEPD", | ||||
| 10 | "name": "SEPD and SHEPD Licence Areas", | ||||
| 11 | "type": "spatial" | ||||
| 12 | } | ||||
| 13 | ], | ||||
| 6 | "creator_user_id": "8241b01f-2466-4d1c-ade4-d9a918c4386a", | 14 | "creator_user_id": "8241b01f-2466-4d1c-ade4-d9a918c4386a", | ||
| 7 | "groups": [ | 15 | "groups": [ | ||
| 8 | { | 16 | { | ||
| 9 | "description": "", | 17 | "description": "", | ||
| 10 | "display_name": "Network Capacity", | 18 | "display_name": "Network Capacity", | ||
| 11 | "id": "dfdceb5e-40a1-47ce-bcf0-26bb2a438dc7", | 19 | "id": "dfdceb5e-40a1-47ce-bcf0-26bb2a438dc7", | ||
| 12 | "image_display_url": | 20 | "image_display_url": | ||
| 13 | /group/2023-09-29-174801.604291collections-network-capacity-icon.svg", | 21 | /group/2023-09-29-174801.604291collections-network-capacity-icon.svg", | ||
| 14 | "name": "network-capacity", | 22 | "name": "network-capacity", | ||
| 15 | "title": "Network Capacity" | 23 | "title": "Network Capacity" | ||
| 16 | } | 24 | } | ||
| 17 | ], | 25 | ], | ||
| 18 | "has_version": "", | 26 | "has_version": "", | ||
| 19 | "ib1_access": "", | 27 | "ib1_access": "", | ||
| 20 | "id": "4353aeaf-7d42-4e11-ad29-b6583e34b2e3", | 28 | "id": "4353aeaf-7d42-4e11-ad29-b6583e34b2e3", | ||
| 21 | "is_version_of": "", | 29 | "is_version_of": "", | ||
| 22 | "isopen": true, | 30 | "isopen": true, | ||
| n | 23 | "language": "", | n | 31 | "language": "EN", |
| 24 | "license_id": "CC-BY-4.0", | 32 | "license_id": "CC-BY-4.0", | ||
| 25 | "license_title": "Creative Commons Attribution 4.0", | 33 | "license_title": "Creative Commons Attribution 4.0", | ||
| 26 | "license_url": "https://creativecommons.org/licenses/by/4.0/", | 34 | "license_url": "https://creativecommons.org/licenses/by/4.0/", | ||
| 27 | "maintainer": "", | 35 | "maintainer": "", | ||
| 28 | "maintainer_email": "", | 36 | "maintainer_email": "", | ||
| 29 | "metadata_created": "2023-10-03T12:11:17.838892", | 37 | "metadata_created": "2023-10-03T12:11:17.838892", | ||
| n | 30 | "metadata_modified": "2023-11-22T13:50:54.458277", | n | 38 | "metadata_modified": "2023-11-22T14:13:37.034172", |
| 31 | "name": "smart-meter-primary-usage", | 39 | "name": "smart-meter-primary-usage", | ||
| n | 32 | "notes": "A Smart Meter prototype dataset", | n | 40 | "notes": "Smart Meter Half Hourly Usage by Primary Substation |
| 41 | including a lookup of Substation Name against NRN. This data set is | ||||
| 42 | provided by SSEN's smart meter adapter and cross referenced with | ||||
| 43 | SSEN's Network Reference Number (NRN). Both these data sets provide | ||||
| 44 | the Primary Substation NRN along with the aggregated consumption data | ||||
| 45 | in kWh and the relevant half hour time period for each day.", | ||||
| 33 | "num_resources": 2, | 46 | "num_resources": 2, | ||
| n | 34 | "num_tags": 1, | n | 47 | "num_tags": 3, |
| 35 | "organization": { | 48 | "organization": { | ||
| 36 | "approval_status": "approved", | 49 | "approval_status": "approved", | ||
| 37 | "created": "2023-08-01T09:55:16.285620", | 50 | "created": "2023-08-01T09:55:16.285620", | ||
| 38 | "description": "We are the electricity Distribution Network | 51 | "description": "We are the electricity Distribution Network | ||
| 39 | Operator (DNO) responsible for delivering power to over 3.8 million | 52 | Operator (DNO) responsible for delivering power to over 3.8 million | ||
| 40 | homes and businesses across central southern England and the north of | 53 | homes and businesses across central southern England and the north of | ||
| 41 | Scotland. We serve some of the most diverse and unique geographies | 54 | Scotland. We serve some of the most diverse and unique geographies | ||
| 42 | across the UK, and keep customers and communities connected whilst | 55 | across the UK, and keep customers and communities connected whilst | ||
| 43 | developing the flexible electricity network vital to achieving net | 56 | developing the flexible electricity network vital to achieving net | ||
| 44 | zero.\r\n\r\nOur skilled teams are based right across the regions we | 57 | zero.\r\n\r\nOur skilled teams are based right across the regions we | ||
| 45 | serve, from the bustle of West London to the smallest villages in the | 58 | serve, from the bustle of West London to the smallest villages in the | ||
| 46 | Highlands and Islands of Scotland. They are supported by engineering | 59 | Highlands and Islands of Scotland. They are supported by engineering | ||
| 47 | and customer service teams based in major offices and depots in | 60 | and customer service teams based in major offices and depots in | ||
| 48 | centres like Reading, Portsmouth, Perth and Inverness.", | 61 | centres like Reading, Portsmouth, Perth and Inverness.", | ||
| 49 | "id": "94936d51-7ac5-4be9-8b70-7afc372c50bf", | 62 | "id": "94936d51-7ac5-4be9-8b70-7afc372c50bf", | ||
| 50 | "image_url": "2023-08-01-095516.272590ssendistributionlogo-1.jpg", | 63 | "image_url": "2023-08-01-095516.272590ssendistributionlogo-1.jpg", | ||
| 51 | "is_organization": true, | 64 | "is_organization": true, | ||
| 52 | "name": "ssen-distribution", | 65 | "name": "ssen-distribution", | ||
| 53 | "state": "active", | 66 | "state": "active", | ||
| 54 | "title": "SSEN Distribution", | 67 | "title": "SSEN Distribution", | ||
| 55 | "type": "organization" | 68 | "type": "organization" | ||
| 56 | }, | 69 | }, | ||
| 57 | "owner_org": "94936d51-7ac5-4be9-8b70-7afc372c50bf", | 70 | "owner_org": "94936d51-7ac5-4be9-8b70-7afc372c50bf", | ||
| 58 | "private": false, | 71 | "private": false, | ||
| n | n | 72 | "relation": "", | ||
| 59 | "relationships_as_object": [], | 73 | "relationships_as_object": [], | ||
| 60 | "relationships_as_subject": [], | 74 | "relationships_as_subject": [], | ||
| 61 | "resources": [ | 75 | "resources": [ | ||
| 62 | { | 76 | { | ||
| 63 | "cache_last_updated": null, | 77 | "cache_last_updated": null, | ||
| 64 | "cache_url": null, | 78 | "cache_url": null, | ||
| 65 | "created": "2023-10-03T12:11:19.065741", | 79 | "created": "2023-10-03T12:11:19.065741", | ||
| 66 | "datastore_active": true, | 80 | "datastore_active": true, | ||
| 67 | "description": "Half Hourly Usage for each Primary Substation", | 81 | "description": "Half Hourly Usage for each Primary Substation", | ||
| 68 | "format": "CSV", | 82 | "format": "CSV", | ||
| 69 | "hash": "", | 83 | "hash": "", | ||
| 70 | "id": "96176e4b-a907-4281-86b0-67122e184527", | 84 | "id": "96176e4b-a907-4281-86b0-67122e184527", | ||
| 71 | "last_modified": "2023-10-03T12:11:19.042656", | 85 | "last_modified": "2023-10-03T12:11:19.042656", | ||
| 72 | "metadata_modified": "2023-11-22T13:50:54.469157", | 86 | "metadata_modified": "2023-11-22T13:50:54.469157", | ||
| 73 | "mimetype": null, | 87 | "mimetype": null, | ||
| 74 | "mimetype_inner": null, | 88 | "mimetype_inner": null, | ||
| 75 | "name": "primary-usage", | 89 | "name": "primary-usage", | ||
| 76 | "package_id": "4353aeaf-7d42-4e11-ad29-b6583e34b2e3", | 90 | "package_id": "4353aeaf-7d42-4e11-ad29-b6583e34b2e3", | ||
| 77 | "position": 0, | 91 | "position": 0, | ||
| 78 | "resource_type": "regular", | 92 | "resource_type": "regular", | ||
| 79 | "schema": { | 93 | "schema": { | ||
| 80 | "fields": [ | 94 | "fields": [ | ||
| 81 | { | 95 | { | ||
| 82 | "description": "The Primary Substation Network Reference | 96 | "description": "The Primary Substation Network Reference | ||
| 83 | Number, a 4-digit number in SSEN that uniquely identifies the Primary | 97 | Number, a 4-digit number in SSEN that uniquely identifies the Primary | ||
| 84 | Substation.", | 98 | Substation.", | ||
| 85 | "example": "1234", | 99 | "example": "1234", | ||
| 86 | "name": "NRN", | 100 | "name": "NRN", | ||
| 87 | "title": "Primary Substation NRN", | 101 | "title": "Primary Substation NRN", | ||
| 88 | "type": "string" | 102 | "type": "string" | ||
| 89 | }, | 103 | }, | ||
| 90 | { | 104 | { | ||
| 91 | "description": "The Usage Date: day, month and year, | 105 | "description": "The Usage Date: day, month and year, | ||
| 92 | relating to the accompanying half-hour period", | 106 | relating to the accompanying half-hour period", | ||
| 93 | "example": "February 28, 2023", | 107 | "example": "February 28, 2023", | ||
| 94 | "name": "UsageDate", | 108 | "name": "UsageDate", | ||
| 95 | "title": "Usage Date", | 109 | "title": "Usage Date", | ||
| 96 | "type": "string" | 110 | "type": "string" | ||
| 97 | }, | 111 | }, | ||
| 98 | { | 112 | { | ||
| 99 | "description": "Start Time of the half-hour usage period, | 113 | "description": "Start Time of the half-hour usage period, | ||
| 100 | one of 48 30-minute periods during a metering day", | 114 | one of 48 30-minute periods during a metering day", | ||
| 101 | "example": "18:00", | 115 | "example": "18:00", | ||
| 102 | "name": "StartTime", | 116 | "name": "StartTime", | ||
| 103 | "title": "Start Time", | 117 | "title": "Start Time", | ||
| 104 | "type": "string" | 118 | "type": "string" | ||
| 105 | }, | 119 | }, | ||
| 106 | { | 120 | { | ||
| 107 | "description": "End Time of the half-hour usage period, | 121 | "description": "End Time of the half-hour usage period, | ||
| 108 | one of 48 30-minute periods during a metering day", | 122 | one of 48 30-minute periods during a metering day", | ||
| 109 | "example": "18:30", | 123 | "example": "18:30", | ||
| 110 | "name": "EndTime", | 124 | "name": "EndTime", | ||
| 111 | "title": "End Time", | 125 | "title": "End Time", | ||
| 112 | "type": "string" | 126 | "type": "string" | ||
| 113 | }, | 127 | }, | ||
| 114 | { | 128 | { | ||
| 115 | "description": "The Smart Meter Usage in kWh for the | 129 | "description": "The Smart Meter Usage in kWh for the | ||
| 116 | half-hour period, aggregated up to the Primary Substation", | 130 | half-hour period, aggregated up to the Primary Substation", | ||
| 117 | "example": "1,234.56", | 131 | "example": "1,234.56", | ||
| 118 | "name": "UsageKWH", | 132 | "name": "UsageKWH", | ||
| 119 | "title": "Smart Meter Usage kWh", | 133 | "title": "Smart Meter Usage kWh", | ||
| 120 | "type": "number" | 134 | "type": "number" | ||
| 121 | }, | 135 | }, | ||
| 122 | { | 136 | { | ||
| 123 | "description": "Domestic and Non-Domestic Smart Meter MPAN | 137 | "description": "Domestic and Non-Domestic Smart Meter MPAN | ||
| 124 | Count, aggregated up to the Primary Substation.", | 138 | Count, aggregated up to the Primary Substation.", | ||
| 125 | "example": "123", | 139 | "example": "123", | ||
| 126 | "name": "CustomerCount", | 140 | "name": "CustomerCount", | ||
| 127 | "title": "Smart Meter MPAN Count", | 141 | "title": "Smart Meter MPAN Count", | ||
| 128 | "type": "number" | 142 | "type": "number" | ||
| 129 | } | 143 | } | ||
| 130 | ] | 144 | ] | ||
| 131 | }, | 145 | }, | ||
| 132 | "size": 38798, | 146 | "size": 38798, | ||
| 133 | "state": "active", | 147 | "state": "active", | ||
| 134 | "url": | 148 | "url": | ||
| 135 | 90488586644588438-5ed1c30a-e1db-43f8-bdd7-d60a9594fa93-52-1-c000.csv", | 149 | 90488586644588438-5ed1c30a-e1db-43f8-bdd7-d60a9594fa93-52-1-c000.csv", | ||
| 136 | "url_type": "upload" | 150 | "url_type": "upload" | ||
| 137 | }, | 151 | }, | ||
| 138 | { | 152 | { | ||
| 139 | "cache_last_updated": null, | 153 | "cache_last_updated": null, | ||
| 140 | "cache_url": null, | 154 | "cache_url": null, | ||
| 141 | "created": "2023-10-03T12:11:20.145550", | 155 | "created": "2023-10-03T12:11:20.145550", | ||
| 142 | "datastore_active": true, | 156 | "datastore_active": true, | ||
| 143 | "description": "Primary Substation Lookup data", | 157 | "description": "Primary Substation Lookup data", | ||
| 144 | "format": "CSV", | 158 | "format": "CSV", | ||
| 145 | "hash": "", | 159 | "hash": "", | ||
| 146 | "id": "d8814bee-6193-4412-b216-c0c93ecc3400", | 160 | "id": "d8814bee-6193-4412-b216-c0c93ecc3400", | ||
| 147 | "last_modified": "2023-10-03T12:11:20.118894", | 161 | "last_modified": "2023-10-03T12:11:20.118894", | ||
| 148 | "metadata_modified": "2023-11-22T13:50:54.469453", | 162 | "metadata_modified": "2023-11-22T13:50:54.469453", | ||
| 149 | "mimetype": null, | 163 | "mimetype": null, | ||
| 150 | "mimetype_inner": null, | 164 | "mimetype_inner": null, | ||
| 151 | "name": "primary-nrn", | 165 | "name": "primary-nrn", | ||
| 152 | "package_id": "4353aeaf-7d42-4e11-ad29-b6583e34b2e3", | 166 | "package_id": "4353aeaf-7d42-4e11-ad29-b6583e34b2e3", | ||
| 153 | "position": 1, | 167 | "position": 1, | ||
| 154 | "resource_type": "regular", | 168 | "resource_type": "regular", | ||
| 155 | "schema": { | 169 | "schema": { | ||
| 156 | "fields": [ | 170 | "fields": [ | ||
| 157 | { | 171 | { | ||
| 158 | "description": "The Primary Substation Network Reference | 172 | "description": "The Primary Substation Network Reference | ||
| 159 | Number, a 4-digit number in SSEN that uniquely identifies the Primary | 173 | Number, a 4-digit number in SSEN that uniquely identifies the Primary | ||
| 160 | Substation.", | 174 | Substation.", | ||
| 161 | "example": "1234", | 175 | "example": "1234", | ||
| 162 | "name": "NRN", | 176 | "name": "NRN", | ||
| 163 | "title": "Primary Substation NRN", | 177 | "title": "Primary Substation NRN", | ||
| 164 | "type": "string" | 178 | "type": "string" | ||
| 165 | }, | 179 | }, | ||
| 166 | { | 180 | { | ||
| 167 | "description": "The SSEN name of the Primary Substation.", | 181 | "description": "The SSEN name of the Primary Substation.", | ||
| 168 | "example": "KINGS NORTON", | 182 | "example": "KINGS NORTON", | ||
| 169 | "name": "PRIMARY_NAME", | 183 | "name": "PRIMARY_NAME", | ||
| 170 | "title": "The Primary Substation name", | 184 | "title": "The Primary Substation name", | ||
| 171 | "type": "string" | 185 | "type": "string" | ||
| 172 | } | 186 | } | ||
| 173 | ] | 187 | ] | ||
| 174 | }, | 188 | }, | ||
| 175 | "size": 29897, | 189 | "size": 29897, | ||
| 176 | "state": "active", | 190 | "state": "active", | ||
| 177 | "url": | 191 | "url": | ||
| 178 | 38321194656813232-72459ea4-1833-46ab-b13c-e659f454979a-58-1-c000.csv", | 192 | 38321194656813232-72459ea4-1833-46ab-b13c-e659f454979a-58-1-c000.csv", | ||
| 179 | "url_type": "upload" | 193 | "url_type": "upload" | ||
| 180 | } | 194 | } | ||
| 181 | ], | 195 | ], | ||
| 182 | "source": "", | 196 | "source": "", | ||
| 183 | "state": "active", | 197 | "state": "active", | ||
| 184 | "tags": [ | 198 | "tags": [ | ||
| 185 | { | 199 | { | ||
| n | n | 200 | "display_name": "Energy Data", | ||
| 201 | "id": "7e8a4486-1f9c-4fb9-8224-c76b96501f71", | ||||
| 202 | "name": "Energy Data", | ||||
| 203 | "state": "active", | ||||
| 204 | "vocabulary_id": null | ||||
| 205 | }, | ||||
| 206 | { | ||||
| 186 | "display_name": "Network Planning", | 207 | "display_name": "Network Planning", | ||
| 187 | "id": "8d6b9c93-18b2-4bce-a4fc-1a017a88d39c", | 208 | "id": "8d6b9c93-18b2-4bce-a4fc-1a017a88d39c", | ||
| 188 | "name": "Network Planning", | 209 | "name": "Network Planning", | ||
| t | t | 210 | "state": "active", | ||
| 211 | "vocabulary_id": null | ||||
| 212 | }, | ||||
| 213 | { | ||||
| 214 | "display_name": "Smart Metering", | ||||
| 215 | "id": "3df28d71-039b-4332-b621-bdcb1941ec86", | ||||
| 216 | "name": "Smart Metering", | ||||
| 189 | "state": "active", | 217 | "state": "active", | ||
| 190 | "vocabulary_id": null | 218 | "vocabulary_id": null | ||
| 191 | } | 219 | } | ||
| 192 | ], | 220 | ], | ||
| 193 | "title": "Smart Meter Primary Substation Usage", | 221 | "title": "Smart Meter Primary Substation Usage", | ||
| 194 | "type": "dataset", | 222 | "type": "dataset", | ||
| 195 | "url": | 223 | "url": | ||
| 196 | al-dev.sse.datopian.com/@ssen-distribution/smart-meter-primary-usage", | 224 | al-dev.sse.datopian.com/@ssen-distribution/smart-meter-primary-usage", | ||
| 197 | "version": "" | 225 | "version": "" | ||
| 198 | } | 226 | } |