Changes
On November 22, 2023 at 2:42:15 PM UTC,
-
Added resource SSEN Data Triage record for Smart Meter Aggregated Consumption Data to 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": "", | ||
| 6 | "contributor": "", | 6 | "contributor": "", | ||
| 7 | "coverage": [ | 7 | "coverage": [ | ||
| 8 | { | 8 | { | ||
| 9 | "location_name": "SEPD and SHEPD", | 9 | "location_name": "SEPD and SHEPD", | ||
| 10 | "name": "SEPD and SHEPD Licence Areas", | 10 | "name": "SEPD and SHEPD Licence Areas", | ||
| 11 | "type": "spatial" | 11 | "type": "spatial" | ||
| 12 | } | 12 | } | ||
| 13 | ], | 13 | ], | ||
| 14 | "creator_user_id": "8241b01f-2466-4d1c-ade4-d9a918c4386a", | 14 | "creator_user_id": "8241b01f-2466-4d1c-ade4-d9a918c4386a", | ||
| 15 | "groups": [ | 15 | "groups": [ | ||
| 16 | { | 16 | { | ||
| 17 | "description": "", | 17 | "description": "", | ||
| 18 | "display_name": "Network Capacity", | 18 | "display_name": "Network Capacity", | ||
| 19 | "id": "dfdceb5e-40a1-47ce-bcf0-26bb2a438dc7", | 19 | "id": "dfdceb5e-40a1-47ce-bcf0-26bb2a438dc7", | ||
| 20 | "image_display_url": | 20 | "image_display_url": | ||
| 21 | /group/2023-09-29-174801.604291collections-network-capacity-icon.svg", | 21 | /group/2023-09-29-174801.604291collections-network-capacity-icon.svg", | ||
| 22 | "name": "network-capacity", | 22 | "name": "network-capacity", | ||
| 23 | "title": "Network Capacity" | 23 | "title": "Network Capacity" | ||
| 24 | } | 24 | } | ||
| 25 | ], | 25 | ], | ||
| 26 | "has_version": "", | 26 | "has_version": "", | ||
| 27 | "ib1_access": "", | 27 | "ib1_access": "", | ||
| 28 | "id": "9f1ec812-c428-49d0-bc5d-9518df53adc7", | 28 | "id": "9f1ec812-c428-49d0-bc5d-9518df53adc7", | ||
| 29 | "is_version_of": "", | 29 | "is_version_of": "", | ||
| 30 | "isopen": true, | 30 | "isopen": true, | ||
| 31 | "language": "EN", | 31 | "language": "EN", | ||
| 32 | "license_id": "CC-BY-4.0", | 32 | "license_id": "CC-BY-4.0", | ||
| 33 | "license_title": "Creative Commons Attribution 4.0", | 33 | "license_title": "Creative Commons Attribution 4.0", | ||
| 34 | "license_url": "https://creativecommons.org/licenses/by/4.0/", | 34 | "license_url": "https://creativecommons.org/licenses/by/4.0/", | ||
| 35 | "maintainer": "", | 35 | "maintainer": "", | ||
| 36 | "maintainer_email": "", | 36 | "maintainer_email": "", | ||
| 37 | "metadata_created": "2023-10-03T10:14:07.638755", | 37 | "metadata_created": "2023-10-03T10:14:07.638755", | ||
| n | 38 | "metadata_modified": "2023-11-22T14:23:43.105154", | n | 38 | "metadata_modified": "2023-11-22T14:42:15.168723", |
| 39 | "name": "smart-meter-transformer-usage", | 39 | "name": "smart-meter-transformer-usage", | ||
| 40 | "notes": "Smart Meter Half Hourly Usage by Distribution Transformer | 40 | "notes": "Smart Meter Half Hourly Usage by Distribution Transformer | ||
| 41 | including a lookup of Transformer Name against NRN. This data set is | 41 | including a lookup of Transformer Name against NRN. This data set is | ||
| 42 | provided by SSEN's smart meter adapter and provides the NRN along with | 42 | provided by SSEN's smart meter adapter and provides the NRN along with | ||
| 43 | the aggregated consumption data in kWh, a customer count aggregated to | 43 | the aggregated consumption data in kWh, a customer count aggregated to | ||
| 44 | the Transformer, and the relevant half hour time period for each | 44 | the Transformer, and the relevant half hour time period for each | ||
| 45 | day.", | 45 | day.", | ||
| n | 46 | "num_resources": 2, | n | 46 | "num_resources": 3, |
| 47 | "num_tags": 3, | 47 | "num_tags": 3, | ||
| 48 | "organization": { | 48 | "organization": { | ||
| 49 | "approval_status": "approved", | 49 | "approval_status": "approved", | ||
| 50 | "created": "2023-08-01T09:55:16.285620", | 50 | "created": "2023-08-01T09:55:16.285620", | ||
| 51 | "description": "We are the electricity Distribution Network | 51 | "description": "We are the electricity Distribution Network | ||
| 52 | Operator (DNO) responsible for delivering power to over 3.8 million | 52 | Operator (DNO) responsible for delivering power to over 3.8 million | ||
| 53 | homes and businesses across central southern England and the north of | 53 | homes and businesses across central southern England and the north of | ||
| 54 | Scotland. We serve some of the most diverse and unique geographies | 54 | Scotland. We serve some of the most diverse and unique geographies | ||
| 55 | across the UK, and keep customers and communities connected whilst | 55 | across the UK, and keep customers and communities connected whilst | ||
| 56 | developing the flexible electricity network vital to achieving net | 56 | developing the flexible electricity network vital to achieving net | ||
| 57 | 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 | ||
| 58 | 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 | ||
| 59 | Highlands and Islands of Scotland. They are supported by engineering | 59 | Highlands and Islands of Scotland. They are supported by engineering | ||
| 60 | and customer service teams based in major offices and depots in | 60 | and customer service teams based in major offices and depots in | ||
| 61 | centres like Reading, Portsmouth, Perth and Inverness.", | 61 | centres like Reading, Portsmouth, Perth and Inverness.", | ||
| 62 | "id": "94936d51-7ac5-4be9-8b70-7afc372c50bf", | 62 | "id": "94936d51-7ac5-4be9-8b70-7afc372c50bf", | ||
| 63 | "image_url": "2023-08-01-095516.272590ssendistributionlogo-1.jpg", | 63 | "image_url": "2023-08-01-095516.272590ssendistributionlogo-1.jpg", | ||
| 64 | "is_organization": true, | 64 | "is_organization": true, | ||
| 65 | "name": "ssen-distribution", | 65 | "name": "ssen-distribution", | ||
| 66 | "state": "active", | 66 | "state": "active", | ||
| 67 | "title": "SSEN Distribution", | 67 | "title": "SSEN Distribution", | ||
| 68 | "type": "organization" | 68 | "type": "organization" | ||
| 69 | }, | 69 | }, | ||
| 70 | "owner_org": "94936d51-7ac5-4be9-8b70-7afc372c50bf", | 70 | "owner_org": "94936d51-7ac5-4be9-8b70-7afc372c50bf", | ||
| 71 | "private": false, | 71 | "private": false, | ||
| 72 | "relation": "", | 72 | "relation": "", | ||
| 73 | "relationships_as_object": [], | 73 | "relationships_as_object": [], | ||
| 74 | "relationships_as_subject": [], | 74 | "relationships_as_subject": [], | ||
| 75 | "resources": [ | 75 | "resources": [ | ||
| 76 | { | 76 | { | ||
| 77 | "cache_last_updated": null, | 77 | "cache_last_updated": null, | ||
| 78 | "cache_url": null, | 78 | "cache_url": null, | ||
| 79 | "created": "2023-10-03T10:14:16.315760", | 79 | "created": "2023-10-03T10:14:16.315760", | ||
| 80 | "datastore_active": true, | 80 | "datastore_active": true, | ||
| 81 | "description": "Half Hourly Usage for each Transformer", | 81 | "description": "Half Hourly Usage for each Transformer", | ||
| 82 | "format": "CSV", | 82 | "format": "CSV", | ||
| 83 | "hash": "", | 83 | "hash": "", | ||
| 84 | "id": "64dbe4f3-ca6b-47e8-a0d8-cd61b454efe1", | 84 | "id": "64dbe4f3-ca6b-47e8-a0d8-cd61b454efe1", | ||
| 85 | "last_modified": "2023-10-03T10:14:16.285912", | 85 | "last_modified": "2023-10-03T10:14:16.285912", | ||
| 86 | "metadata_modified": "2023-11-22T13:55:06.128312", | 86 | "metadata_modified": "2023-11-22T13:55:06.128312", | ||
| 87 | "mimetype": null, | 87 | "mimetype": null, | ||
| 88 | "mimetype_inner": null, | 88 | "mimetype_inner": null, | ||
| 89 | "name": "transformer-usage", | 89 | "name": "transformer-usage", | ||
| 90 | "package_id": "9f1ec812-c428-49d0-bc5d-9518df53adc7", | 90 | "package_id": "9f1ec812-c428-49d0-bc5d-9518df53adc7", | ||
| 91 | "position": 0, | 91 | "position": 0, | ||
| 92 | "resource_type": "regular", | 92 | "resource_type": "regular", | ||
| 93 | "schema": { | 93 | "schema": { | ||
| 94 | "fields": [ | 94 | "fields": [ | ||
| 95 | { | 95 | { | ||
| 96 | "description": "The Transformer Network Reference Number, | 96 | "description": "The Transformer Network Reference Number, | ||
| 97 | a sequence of numbers in SSEN that uniquely identifies the | 97 | a sequence of numbers in SSEN that uniquely identifies the | ||
| 98 | Distribution Transformer. The Transformer NRN is comprised of 3 | 98 | Distribution Transformer. The Transformer NRN is comprised of 3 | ||
| 99 | groups: Primary Substation Circuit Number, HV Feeder number and the | 99 | groups: Primary Substation Circuit Number, HV Feeder number and the | ||
| 100 | Transformer NRN.", | 100 | Transformer NRN.", | ||
| 101 | "example": "0001_301_423", | 101 | "example": "0001_301_423", | ||
| 102 | "name": "NRN", | 102 | "name": "NRN", | ||
| 103 | "title": "Transformer NRN", | 103 | "title": "Transformer NRN", | ||
| 104 | "type": "string" | 104 | "type": "string" | ||
| 105 | }, | 105 | }, | ||
| 106 | { | 106 | { | ||
| 107 | "description": "The Usage Date: day, month and year, | 107 | "description": "The Usage Date: day, month and year, | ||
| 108 | relating to the accompanying half-hour period", | 108 | relating to the accompanying half-hour period", | ||
| 109 | "example": "February 28, 2023", | 109 | "example": "February 28, 2023", | ||
| 110 | "name": "UsageDate", | 110 | "name": "UsageDate", | ||
| 111 | "title": "Usage Date", | 111 | "title": "Usage Date", | ||
| 112 | "type": "string" | 112 | "type": "string" | ||
| 113 | }, | 113 | }, | ||
| 114 | { | 114 | { | ||
| 115 | "description": "Start Time of the half-hour usage period, | 115 | "description": "Start Time of the half-hour usage period, | ||
| 116 | one of 48 30-minute periods during a metering day", | 116 | one of 48 30-minute periods during a metering day", | ||
| 117 | "example": "18:00", | 117 | "example": "18:00", | ||
| 118 | "name": "StartTime", | 118 | "name": "StartTime", | ||
| 119 | "title": "Start Time", | 119 | "title": "Start Time", | ||
| 120 | "type": "string" | 120 | "type": "string" | ||
| 121 | }, | 121 | }, | ||
| 122 | { | 122 | { | ||
| 123 | "description": "End Time of the half-hour usage period, | 123 | "description": "End Time of the half-hour usage period, | ||
| 124 | one of 48 30-minute periods during a metering day", | 124 | one of 48 30-minute periods during a metering day", | ||
| 125 | "example": "18:30", | 125 | "example": "18:30", | ||
| 126 | "name": "EndTime", | 126 | "name": "EndTime", | ||
| 127 | "title": "End Time", | 127 | "title": "End Time", | ||
| 128 | "type": "string" | 128 | "type": "string" | ||
| 129 | }, | 129 | }, | ||
| 130 | { | 130 | { | ||
| 131 | "description": "The Smart Meter Usage in kWh for the | 131 | "description": "The Smart Meter Usage in kWh for the | ||
| 132 | half-hour period, aggregated up to the Distribution Transformer", | 132 | half-hour period, aggregated up to the Distribution Transformer", | ||
| 133 | "example": "1,234.56", | 133 | "example": "1,234.56", | ||
| 134 | "name": "UsageKWH", | 134 | "name": "UsageKWH", | ||
| 135 | "title": "Smart Meter Usage kWh", | 135 | "title": "Smart Meter Usage kWh", | ||
| 136 | "type": "number" | 136 | "type": "number" | ||
| 137 | }, | 137 | }, | ||
| 138 | { | 138 | { | ||
| 139 | "description": "Domestic and Non-Domestic Smart Meter MPAN | 139 | "description": "Domestic and Non-Domestic Smart Meter MPAN | ||
| 140 | Count, aggregated up to the Distribution Transformer.", | 140 | Count, aggregated up to the Distribution Transformer.", | ||
| 141 | "example": "123", | 141 | "example": "123", | ||
| 142 | "name": "CustomerCount", | 142 | "name": "CustomerCount", | ||
| 143 | "title": "Smart Meter MPAN Count", | 143 | "title": "Smart Meter MPAN Count", | ||
| 144 | "type": "number" | 144 | "type": "number" | ||
| 145 | } | 145 | } | ||
| 146 | ] | 146 | ] | ||
| 147 | }, | 147 | }, | ||
| 148 | "size": 46776, | 148 | "size": 46776, | ||
| 149 | "state": "active", | 149 | "state": "active", | ||
| 150 | "url": | 150 | "url": | ||
| 151 | 03921683192426146-60c50055-ff46-44ff-83cb-74815f458fea-40-1-c000.csv", | 151 | 03921683192426146-60c50055-ff46-44ff-83cb-74815f458fea-40-1-c000.csv", | ||
| 152 | "url_type": "upload" | 152 | "url_type": "upload" | ||
| 153 | }, | 153 | }, | ||
| 154 | { | 154 | { | ||
| 155 | "cache_last_updated": null, | 155 | "cache_last_updated": null, | ||
| 156 | "cache_url": null, | 156 | "cache_url": null, | ||
| 157 | "created": "2023-10-03T10:14:20.581831", | 157 | "created": "2023-10-03T10:14:20.581831", | ||
| 158 | "datastore_active": true, | 158 | "datastore_active": true, | ||
| 159 | "description": "Transformer Lookup data", | 159 | "description": "Transformer Lookup data", | ||
| 160 | "format": "CSV", | 160 | "format": "CSV", | ||
| 161 | "hash": "", | 161 | "hash": "", | ||
| 162 | "id": "2fa4168b-a1cc-4fc7-a552-7bcad3f0e1d5", | 162 | "id": "2fa4168b-a1cc-4fc7-a552-7bcad3f0e1d5", | ||
| 163 | "last_modified": "2023-10-03T10:14:20.554781", | 163 | "last_modified": "2023-10-03T10:14:20.554781", | ||
| n | 164 | "metadata_modified": "2023-11-22T13:55:06.128475", | n | 164 | "metadata_modified": "2023-11-22T14:42:15.179188", |
| 165 | "mimetype": null, | 165 | "mimetype": null, | ||
| 166 | "mimetype_inner": null, | 166 | "mimetype_inner": null, | ||
| 167 | "name": "transformer-nrn", | 167 | "name": "transformer-nrn", | ||
| 168 | "package_id": "9f1ec812-c428-49d0-bc5d-9518df53adc7", | 168 | "package_id": "9f1ec812-c428-49d0-bc5d-9518df53adc7", | ||
| 169 | "position": 1, | 169 | "position": 1, | ||
| 170 | "resource_type": "regular", | 170 | "resource_type": "regular", | ||
| 171 | "schema": { | 171 | "schema": { | ||
| 172 | "fields": [ | 172 | "fields": [ | ||
| 173 | { | 173 | { | ||
| 174 | "description": "The Transformer Network Reference Number, | 174 | "description": "The Transformer Network Reference Number, | ||
| 175 | a sequence of numbers in SSEN that uniquely identifies the | 175 | a sequence of numbers in SSEN that uniquely identifies the | ||
| 176 | Distribution Transformer. The Transformer NRN is comprised of 3 | 176 | Distribution Transformer. The Transformer NRN is comprised of 3 | ||
| 177 | groups: Primary Substation Circuit Number, HV Feeder number and the | 177 | groups: Primary Substation Circuit Number, HV Feeder number and the | ||
| 178 | Transformer NRN.", | 178 | Transformer NRN.", | ||
| 179 | "example": "0001_301_423", | 179 | "example": "0001_301_423", | ||
| 180 | "name": "NRN", | 180 | "name": "NRN", | ||
| 181 | "title": "Transformer NRN", | 181 | "title": "Transformer NRN", | ||
| 182 | "type": "string" | 182 | "type": "string" | ||
| 183 | }, | 183 | }, | ||
| 184 | { | 184 | { | ||
| 185 | "description": "The SSEN name of the Distribution | 185 | "description": "The SSEN name of the Distribution | ||
| 186 | Transformer.", | 186 | Transformer.", | ||
| 187 | "example": "DUNCRAIG ROAD", | 187 | "example": "DUNCRAIG ROAD", | ||
| 188 | "name": "TRANSFORMER_NAME", | 188 | "name": "TRANSFORMER_NAME", | ||
| 189 | "title": "The Transformer name", | 189 | "title": "The Transformer name", | ||
| 190 | "type": "string" | 190 | "type": "string" | ||
| 191 | } | 191 | } | ||
| 192 | ] | 192 | ] | ||
| 193 | }, | 193 | }, | ||
| 194 | "size": 3376611, | 194 | "size": 3376611, | ||
| 195 | "state": "active", | 195 | "state": "active", | ||
| 196 | "url": | 196 | "url": | ||
| 197 | 88020244495218923-8f22f345-bf97-4a04-89cc-86a92c5c6973-42-1-c000.csv", | 197 | 88020244495218923-8f22f345-bf97-4a04-89cc-86a92c5c6973-42-1-c000.csv", | ||
| 198 | "url_type": "upload" | 198 | "url_type": "upload" | ||
| t | t | 199 | }, | ||
| 200 | { | ||||
| 201 | "cache_last_updated": null, | ||||
| 202 | "cache_url": null, | ||||
| 203 | "created": "2023-11-22T14:42:15.200750", | ||||
| 204 | "datastore_active": false, | ||||
| 205 | "description": "SSEN Data Triage record for Smart Meter | ||||
| 206 | Aggregated Consumption Data ", | ||||
| 207 | "format": "PDF", | ||||
| 208 | "hash": "", | ||||
| 209 | "id": "bd1f8d83-b267-4284-b8cc-d29cba97b709", | ||||
| 210 | "last_modified": "2023-11-22T14:42:15.106406", | ||||
| 211 | "metadata_modified": "2023-11-22T14:42:15.179446", | ||||
| 212 | "mimetype": "application/pdf", | ||||
| 213 | "mimetype_inner": null, | ||||
| 214 | "name": "SSEN Data Triage record for Smart Meter Aggregated | ||||
| 215 | Consumption Data ", | ||||
| 216 | "package_id": "9f1ec812-c428-49d0-bc5d-9518df53adc7", | ||||
| 217 | "position": 2, | ||||
| 218 | "resource_type": "documentation", | ||||
| 219 | "size": 242374, | ||||
| 220 | "state": "active", | ||||
| 221 | "url": | ||||
| 222 | -d29cba97b709/download/smart-meter-external-data-triage-artefact.pdf", | ||||
| 223 | "url_type": "upload" | ||||
| 199 | } | 224 | } | ||
| 200 | ], | 225 | ], | ||
| 201 | "source": "", | 226 | "source": "", | ||
| 202 | "state": "active", | 227 | "state": "active", | ||
| 203 | "tags": [ | 228 | "tags": [ | ||
| 204 | { | 229 | { | ||
| 205 | "display_name": "Energy Data", | 230 | "display_name": "Energy Data", | ||
| 206 | "id": "7e8a4486-1f9c-4fb9-8224-c76b96501f71", | 231 | "id": "7e8a4486-1f9c-4fb9-8224-c76b96501f71", | ||
| 207 | "name": "Energy Data", | 232 | "name": "Energy Data", | ||
| 208 | "state": "active", | 233 | "state": "active", | ||
| 209 | "vocabulary_id": null | 234 | "vocabulary_id": null | ||
| 210 | }, | 235 | }, | ||
| 211 | { | 236 | { | ||
| 212 | "display_name": "Network Planning", | 237 | "display_name": "Network Planning", | ||
| 213 | "id": "8d6b9c93-18b2-4bce-a4fc-1a017a88d39c", | 238 | "id": "8d6b9c93-18b2-4bce-a4fc-1a017a88d39c", | ||
| 214 | "name": "Network Planning", | 239 | "name": "Network Planning", | ||
| 215 | "state": "active", | 240 | "state": "active", | ||
| 216 | "vocabulary_id": null | 241 | "vocabulary_id": null | ||
| 217 | }, | 242 | }, | ||
| 218 | { | 243 | { | ||
| 219 | "display_name": "Smart Metering", | 244 | "display_name": "Smart Metering", | ||
| 220 | "id": "3df28d71-039b-4332-b621-bdcb1941ec86", | 245 | "id": "3df28d71-039b-4332-b621-bdcb1941ec86", | ||
| 221 | "name": "Smart Metering", | 246 | "name": "Smart Metering", | ||
| 222 | "state": "active", | 247 | "state": "active", | ||
| 223 | "vocabulary_id": null | 248 | "vocabulary_id": null | ||
| 224 | } | 249 | } | ||
| 225 | ], | 250 | ], | ||
| 226 | "title": "Smart Meter Transformer Usage", | 251 | "title": "Smart Meter Transformer Usage", | ||
| 227 | "type": "dataset", | 252 | "type": "dataset", | ||
| 228 | "url": | 253 | "url": | ||
| 229 | ev.sse.datopian.com/@ssen-distribution/smart-meter-transformer-usage", | 254 | ev.sse.datopian.com/@ssen-distribution/smart-meter-transformer-usage", | ||
| 230 | "version": "" | 255 | "version": "" | ||
| 231 | } | 256 | } |