substation_types: 68
This data as json
| rowid | location | type | licence | source | substation_ids | voltages | transformers | substation_type_id | latitude | longitude | source_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 68 | devonshire square | bsp | lpn | ukpn | [
"2206ce32-54ff-4ff5-84b9-287b9e78451e"
] |
[
11.11,
132.0
] |
[
{
"transformer_name": "gt1",
"transformer_id": "4da9ae3c-27f0-4c33-b73f-d9d278cafa75",
"node_1": "devo11",
"node_id_1": "5fb723bb-c6bf-4efe-ab8f-0c3f13ee22e7",
"voltage_1": 132.0,
"node_2": "devo5a",
"node_id_2": "86907a9e-0ba0-4773-b8c6-eaa1dad78620",
"voltage_2": 11.11,
"node_3": "devo5b",
"node_id_3": "d181b266-b80c-4fc5-9b66-12913a49d79c",
"voltage_3": 11.11,
"nom_rating": 60.6,
"gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
"gsp_group_name": "06 - city road 132 kv gsp",
"substation_id": "2206ce32-54ff-4ff5-84b9-287b9e78451e",
"substation_name": "devonshire square"
},
{
"transformer_name": "gt2",
"transformer_id": "dcf1abbe-efbe-41c4-a720-32eec6693b88",
"node_1": "devo12",
"node_id_1": "b01ce0ef-238f-4437-82b8-6a37a2fed093",
"voltage_1": 132.0,
"node_2": "devo5c",
"node_id_2": "e57495f8-903a-4333-a41d-092f516ced90",
"voltage_2": 11.11,
"node_3": "devo5d",
"node_id_3": "72014d2f-5b6b-43a5-9ca8-6a444b6dc904",
"voltage_3": 11.11,
"nom_rating": 60.6,
"gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
"gsp_group_name": "06 - city road 132 kv gsp",
"substation_id": "2206ce32-54ff-4ff5-84b9-287b9e78451e",
"substation_name": "devonshire square"
},
{
"transformer_name": "gt3",
"transformer_id": "f68a6e97-34a8-4ec7-8d48-da246d9acbcc",
"node_1": "devo13",
"node_id_1": "3f650e22-d5a7-44b7-bdf1-36066462557b",
"voltage_1": 132.0,
"node_2": "devo5e",
"node_id_2": "5e507863-f8bd-41ad-a158-5a5e63a141bf",
"voltage_2": 11.11,
"node_3": "devo5f",
"node_id_3": "9705da57-5eb8-4ea7-986f-1f6bf9c31f2a",
"voltage_3": 11.11,
"nom_rating": 60.6,
"gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
"gsp_group_name": "06 - city road 132 kv gsp",
"substation_id": "2206ce32-54ff-4ff5-84b9-287b9e78451e",
"substation_name": "devonshire square"
}
] |
ukpn_lpn_bsp_devonshire_square | 51.5163799124923 | -0.0797928643756813 | lpn-s000000000418 |