substation_types: 39
This data as json
| rowid | location | type | licence | source | substation_ids | voltages | transformers | substation_type_id | latitude | longitude | source_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 39 | blackwall way | bsp | lpn | ukpn | [
"101fee46-c11a-4dcb-b6b6-4269180bf7bc"
] |
[
11.11,
132.0
] |
[
{
"transformer_name": "gt1a",
"transformer_id": "1e56236e-55b9-4828-b66e-212a4bbf99e6",
"node_1": "bkwy11",
"node_id_1": "0c4a37bb-a548-4502-a51d-ee30e2860e53",
"voltage_1": 132.0,
"node_2": "bkwy51 u bb1(1)",
"node_id_2": "7736a278-80ab-48c2-b1ef-2b2fd96394e6",
"voltage_2": 11.11,
"node_3": "bkwy51 u bb2(1)",
"node_id_3": "3d4df323-d4c8-47eb-bf4c-819132a84cf1",
"voltage_3": 11.11,
"nom_rating": 66.66,
"gsp_group_id": "18985509-f571-4feb-a570-3bb1fe521ec0",
"gsp_group_name": "17 - west ham 132 kv gsp",
"substation_id": "101fee46-c11a-4dcb-b6b6-4269180bf7bc",
"substation_name": "blackwall way"
},
{
"transformer_name": "gt2a",
"transformer_id": "915f3f7a-a796-4f5b-ada4-d4d6daa1bad4",
"node_1": "bkwy12",
"node_id_1": "00fe3ba9-fb36-4205-8ef0-0455af16ba7e",
"voltage_1": 132.0,
"node_2": "bkwy52 l bb1(1)",
"node_id_2": "8b6071c7-cf20-47bf-9de2-aceddcc18cab",
"voltage_2": 11.11,
"node_3": "bkwy52 l bb2(1)",
"node_id_3": "8e455a68-4e9a-4760-8b6f-6839b4ad360f",
"voltage_3": 11.11,
"nom_rating": 66.66,
"gsp_group_id": "18985509-f571-4feb-a570-3bb1fe521ec0",
"gsp_group_name": "17 - west ham 132 kv gsp",
"substation_id": "101fee46-c11a-4dcb-b6b6-4269180bf7bc",
"substation_name": "blackwall way"
}
] |
ukpn_lpn_bsp_blackwall_way | 51.507129604829 | -0.00350464748068387 | lpn-s000000000640 |