Changes
On November 22, 2023 at 2:12:25 PM UTC,
-
Updated description of Smart Meter Transformer Usage from
A Smart Meter prototype dataset
toSmart Meter Half Hourly Usage by Transformer including a lookup of Transformer 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 Transformer 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 Transformer Usage
-
Changed value of field
language
toEN
in Smart Meter Transformer 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": "9f1ec812-c428-49d0-bc5d-9518df53adc7", | 28 | "id": "9f1ec812-c428-49d0-bc5d-9518df53adc7", | ||
| 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-03T10:14:07.638755", | 37 | "metadata_created": "2023-10-03T10:14:07.638755", | ||
| n | 30 | "metadata_modified": "2023-11-22T13:55:06.114975", | n | 38 | "metadata_modified": "2023-11-22T14:12:25.032263", |
| 31 | "name": "smart-meter-transformer-usage", | 39 | "name": "smart-meter-transformer-usage", | ||
| n | 32 | "notes": "A Smart Meter prototype dataset", | n | 40 | "notes": "Smart Meter Half Hourly Usage by Transformer including a |
| 41 | lookup of Transformer Name against NRN. This data set is provided by | ||||
| 42 | SSEN's smart meter adapter and cross referenced with SSEN's Network | ||||
| 43 | Reference Number (NRN). Both these data sets provide the Transformer | ||||
| 44 | NRN along with the aggregated consumption data in kWh and the relevant | ||||
| 45 | 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-03T10:14:16.315760", | 79 | "created": "2023-10-03T10:14:16.315760", | ||
| 66 | "datastore_active": true, | 80 | "datastore_active": true, | ||
| 67 | "description": "Half Hourly Usage for each Transformer", | 81 | "description": "Half Hourly Usage for each Transformer", | ||
| 68 | "format": "CSV", | 82 | "format": "CSV", | ||
| 69 | "hash": "", | 83 | "hash": "", | ||
| 70 | "id": "64dbe4f3-ca6b-47e8-a0d8-cd61b454efe1", | 84 | "id": "64dbe4f3-ca6b-47e8-a0d8-cd61b454efe1", | ||
| 71 | "last_modified": "2023-10-03T10:14:16.285912", | 85 | "last_modified": "2023-10-03T10:14:16.285912", | ||
| 72 | "metadata_modified": "2023-11-22T13:55:06.128312", | 86 | "metadata_modified": "2023-11-22T13:55:06.128312", | ||
| 73 | "mimetype": null, | 87 | "mimetype": null, | ||
| 74 | "mimetype_inner": null, | 88 | "mimetype_inner": null, | ||
| 75 | "name": "transformer-usage", | 89 | "name": "transformer-usage", | ||
| 76 | "package_id": "9f1ec812-c428-49d0-bc5d-9518df53adc7", | 90 | "package_id": "9f1ec812-c428-49d0-bc5d-9518df53adc7", | ||
| 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 Transformer Network Reference Number, | 96 | "description": "The Transformer Network Reference Number, | ||
| 83 | a sequence of numbers in SSEN that uniquely identifies the | 97 | a sequence of numbers in SSEN that uniquely identifies the | ||
| 84 | Distribution Transformer. The Transformer NRN is comprised of 3 | 98 | Distribution Transformer. The Transformer NRN is comprised of 3 | ||
| 85 | groups: Primary Substation Circuit Number, HV Feeder number and the | 99 | groups: Primary Substation Circuit Number, HV Feeder number and the | ||
| 86 | Transformer NRN.", | 100 | Transformer NRN.", | ||
| 87 | "example": "0001_301_423", | 101 | "example": "0001_301_423", | ||
| 88 | "name": "NRN", | 102 | "name": "NRN", | ||
| 89 | "title": "Transformer NRN", | 103 | "title": "Transformer NRN", | ||
| 90 | "type": "string" | 104 | "type": "string" | ||
| 91 | }, | 105 | }, | ||
| 92 | { | 106 | { | ||
| 93 | "description": "The Usage Date: day, month and year, | 107 | "description": "The Usage Date: day, month and year, | ||
| 94 | relating to the accompanying half-hour period", | 108 | relating to the accompanying half-hour period", | ||
| 95 | "example": "February 28, 2023", | 109 | "example": "February 28, 2023", | ||
| 96 | "name": "UsageDate", | 110 | "name": "UsageDate", | ||
| 97 | "title": "Usage Date", | 111 | "title": "Usage Date", | ||
| 98 | "type": "string" | 112 | "type": "string" | ||
| 99 | }, | 113 | }, | ||
| 100 | { | 114 | { | ||
| 101 | "description": "Start Time of the half-hour usage period, | 115 | "description": "Start Time of the half-hour usage period, | ||
| 102 | one of 48 30-minute periods during a metering day", | 116 | one of 48 30-minute periods during a metering day", | ||
| 103 | "example": "18:00", | 117 | "example": "18:00", | ||
| 104 | "name": "StartTime", | 118 | "name": "StartTime", | ||
| 105 | "title": "Start Time", | 119 | "title": "Start Time", | ||
| 106 | "type": "string" | 120 | "type": "string" | ||
| 107 | }, | 121 | }, | ||
| 108 | { | 122 | { | ||
| 109 | "description": "End Time of the half-hour usage period, | 123 | "description": "End Time of the half-hour usage period, | ||
| 110 | one of 48 30-minute periods during a metering day", | 124 | one of 48 30-minute periods during a metering day", | ||
| 111 | "example": "18:30", | 125 | "example": "18:30", | ||
| 112 | "name": "EndTime", | 126 | "name": "EndTime", | ||
| 113 | "title": "End Time", | 127 | "title": "End Time", | ||
| 114 | "type": "string" | 128 | "type": "string" | ||
| 115 | }, | 129 | }, | ||
| 116 | { | 130 | { | ||
| 117 | "description": "The Smart Meter Usage in kWh for the | 131 | "description": "The Smart Meter Usage in kWh for the | ||
| 118 | half-hour period, aggregated up to the Distribution Transformer", | 132 | half-hour period, aggregated up to the Distribution Transformer", | ||
| 119 | "example": "1,234.56", | 133 | "example": "1,234.56", | ||
| 120 | "name": "UsageKWH", | 134 | "name": "UsageKWH", | ||
| 121 | "title": "Smart Meter Usage kWh", | 135 | "title": "Smart Meter Usage kWh", | ||
| 122 | "type": "number" | 136 | "type": "number" | ||
| 123 | }, | 137 | }, | ||
| 124 | { | 138 | { | ||
| 125 | "description": "Domestic and Non-Domestic Smart Meter MPAN | 139 | "description": "Domestic and Non-Domestic Smart Meter MPAN | ||
| 126 | Count, aggregated up to the Distribution Transformer.", | 140 | Count, aggregated up to the Distribution Transformer.", | ||
| 127 | "example": "123", | 141 | "example": "123", | ||
| 128 | "name": "CustomerCount", | 142 | "name": "CustomerCount", | ||
| 129 | "title": "Smart Meter MPAN Count", | 143 | "title": "Smart Meter MPAN Count", | ||
| 130 | "type": "number" | 144 | "type": "number" | ||
| 131 | } | 145 | } | ||
| 132 | ] | 146 | ] | ||
| 133 | }, | 147 | }, | ||
| 134 | "size": 46776, | 148 | "size": 46776, | ||
| 135 | "state": "active", | 149 | "state": "active", | ||
| 136 | "url": | 150 | "url": | ||
| 137 | 03921683192426146-60c50055-ff46-44ff-83cb-74815f458fea-40-1-c000.csv", | 151 | 03921683192426146-60c50055-ff46-44ff-83cb-74815f458fea-40-1-c000.csv", | ||
| 138 | "url_type": "upload" | 152 | "url_type": "upload" | ||
| 139 | }, | 153 | }, | ||
| 140 | { | 154 | { | ||
| 141 | "cache_last_updated": null, | 155 | "cache_last_updated": null, | ||
| 142 | "cache_url": null, | 156 | "cache_url": null, | ||
| 143 | "created": "2023-10-03T10:14:20.581831", | 157 | "created": "2023-10-03T10:14:20.581831", | ||
| 144 | "datastore_active": true, | 158 | "datastore_active": true, | ||
| 145 | "description": "Transformer Lookup data", | 159 | "description": "Transformer Lookup data", | ||
| 146 | "format": "CSV", | 160 | "format": "CSV", | ||
| 147 | "hash": "", | 161 | "hash": "", | ||
| 148 | "id": "2fa4168b-a1cc-4fc7-a552-7bcad3f0e1d5", | 162 | "id": "2fa4168b-a1cc-4fc7-a552-7bcad3f0e1d5", | ||
| 149 | "last_modified": "2023-10-03T10:14:20.554781", | 163 | "last_modified": "2023-10-03T10:14:20.554781", | ||
| 150 | "metadata_modified": "2023-11-22T13:55:06.128475", | 164 | "metadata_modified": "2023-11-22T13:55:06.128475", | ||
| 151 | "mimetype": null, | 165 | "mimetype": null, | ||
| 152 | "mimetype_inner": null, | 166 | "mimetype_inner": null, | ||
| 153 | "name": "transformer-nrn", | 167 | "name": "transformer-nrn", | ||
| 154 | "package_id": "9f1ec812-c428-49d0-bc5d-9518df53adc7", | 168 | "package_id": "9f1ec812-c428-49d0-bc5d-9518df53adc7", | ||
| 155 | "position": 1, | 169 | "position": 1, | ||
| 156 | "resource_type": "regular", | 170 | "resource_type": "regular", | ||
| 157 | "schema": { | 171 | "schema": { | ||
| 158 | "fields": [ | 172 | "fields": [ | ||
| 159 | { | 173 | { | ||
| 160 | "description": "The Transformer Network Reference Number, | 174 | "description": "The Transformer Network Reference Number, | ||
| 161 | a sequence of numbers in SSEN that uniquely identifies the | 175 | a sequence of numbers in SSEN that uniquely identifies the | ||
| 162 | Distribution Transformer. The Transformer NRN is comprised of 3 | 176 | Distribution Transformer. The Transformer NRN is comprised of 3 | ||
| 163 | groups: Primary Substation Circuit Number, HV Feeder number and the | 177 | groups: Primary Substation Circuit Number, HV Feeder number and the | ||
| 164 | Transformer NRN.", | 178 | Transformer NRN.", | ||
| 165 | "example": "0001_301_423", | 179 | "example": "0001_301_423", | ||
| 166 | "name": "NRN", | 180 | "name": "NRN", | ||
| 167 | "title": "Transformer NRN", | 181 | "title": "Transformer NRN", | ||
| 168 | "type": "string" | 182 | "type": "string" | ||
| 169 | }, | 183 | }, | ||
| 170 | { | 184 | { | ||
| 171 | "description": "The SSEN name of the Distribution | 185 | "description": "The SSEN name of the Distribution | ||
| 172 | Transformer.", | 186 | Transformer.", | ||
| 173 | "example": "DUNCRAIG ROAD", | 187 | "example": "DUNCRAIG ROAD", | ||
| 174 | "name": "TRANSFORMER_NAME", | 188 | "name": "TRANSFORMER_NAME", | ||
| 175 | "title": "The Transformer name", | 189 | "title": "The Transformer name", | ||
| 176 | "type": "string" | 190 | "type": "string" | ||
| 177 | } | 191 | } | ||
| 178 | ] | 192 | ] | ||
| 179 | }, | 193 | }, | ||
| 180 | "size": 3376611, | 194 | "size": 3376611, | ||
| 181 | "state": "active", | 195 | "state": "active", | ||
| 182 | "url": | 196 | "url": | ||
| 183 | 88020244495218923-8f22f345-bf97-4a04-89cc-86a92c5c6973-42-1-c000.csv", | 197 | 88020244495218923-8f22f345-bf97-4a04-89cc-86a92c5c6973-42-1-c000.csv", | ||
| 184 | "url_type": "upload" | 198 | "url_type": "upload" | ||
| 185 | } | 199 | } | ||
| 186 | ], | 200 | ], | ||
| 187 | "source": "", | 201 | "source": "", | ||
| 188 | "state": "active", | 202 | "state": "active", | ||
| 189 | "tags": [ | 203 | "tags": [ | ||
| 190 | { | 204 | { | ||
| n | n | 205 | "display_name": "Energy Data", | ||
| 206 | "id": "7e8a4486-1f9c-4fb9-8224-c76b96501f71", | ||||
| 207 | "name": "Energy Data", | ||||
| 208 | "state": "active", | ||||
| 209 | "vocabulary_id": null | ||||
| 210 | }, | ||||
| 211 | { | ||||
| 191 | "display_name": "Network Planning", | 212 | "display_name": "Network Planning", | ||
| 192 | "id": "8d6b9c93-18b2-4bce-a4fc-1a017a88d39c", | 213 | "id": "8d6b9c93-18b2-4bce-a4fc-1a017a88d39c", | ||
| 193 | "name": "Network Planning", | 214 | "name": "Network Planning", | ||
| t | t | 215 | "state": "active", | ||
| 216 | "vocabulary_id": null | ||||
| 217 | }, | ||||
| 218 | { | ||||
| 219 | "display_name": "Smart Metering", | ||||
| 220 | "id": "3df28d71-039b-4332-b621-bdcb1941ec86", | ||||
| 221 | "name": "Smart Metering", | ||||
| 194 | "state": "active", | 222 | "state": "active", | ||
| 195 | "vocabulary_id": null | 223 | "vocabulary_id": null | ||
| 196 | } | 224 | } | ||
| 197 | ], | 225 | ], | ||
| 198 | "title": "Smart Meter Transformer Usage", | 226 | "title": "Smart Meter Transformer Usage", | ||
| 199 | "type": "dataset", | 227 | "type": "dataset", | ||
| 200 | "url": | 228 | "url": | ||
| 201 | ev.sse.datopian.com/@ssen-distribution/smart-meter-transformer-usage", | 229 | ev.sse.datopian.com/@ssen-distribution/smart-meter-transformer-usage", | ||
| 202 | "version": "" | 230 | "version": "" | ||
| 203 | } | 231 | } |