substation_types: 24
This data as json
| rowid | location | type | licence | source | substation_ids | voltages | transformers | substation_type_id | latitude | longitude | source_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 24 | apcm swanscombe | primary | lpn | ukpn | [
"bbb05d28-e888-4312-8340-b494bec5e0f6"
] |
[
3.3,
33.0
] |
[
{
"transformer_name": "t3",
"transformer_id": "a5368d35-5c38-41d0-bb0f-4680a0e4b5c2",
"node_1": "terminal(1)",
"node_id_1": "f3c3d15d-025b-4d48-8091-f00648dc91d2",
"voltage_1": 33.0,
"node_2": "terminal(3)",
"node_id_2": "05044165-aaa7-4a55-9151-005e00264427",
"voltage_2": 3.3,
"nom_rating": 5.0,
"gsp_group_id": "835a484d-ebf5-4f1e-9dcd-cf585a66db46",
"gsp_group_name": "11 - littlebrook 132kv gsp",
"bsp_group_id": "bbb05d28-e888-4312-8340-b494bec5e0f6",
"bsp_group_name": "apcm swanscombe",
"substation_id": "bbb05d28-e888-4312-8340-b494bec5e0f6",
"substation_name": "apcm swanscombe"
},
{
"transformer_name": "t2",
"transformer_id": "ba4d9994-fb27-49b1-abac-a35ee9aa1a21",
"node_1": "terminal",
"node_id_1": "e2f23193-d5a0-4a13-a2e7-7576b53e89dd",
"voltage_1": 33.0,
"node_2": "terminal(2)",
"node_id_2": "61b92099-f7a5-4c6d-975f-7ca9e0d15837",
"voltage_2": 3.3,
"nom_rating": 5.0,
"gsp_group_id": "835a484d-ebf5-4f1e-9dcd-cf585a66db46",
"gsp_group_name": "11 - littlebrook 132kv gsp",
"bsp_group_id": "bbb05d28-e888-4312-8340-b494bec5e0f6",
"bsp_group_name": "apcm swanscombe",
"substation_id": "bbb05d28-e888-4312-8340-b494bec5e0f6",
"substation_name": "apcm swanscombe"
}
] |
ukpn_lpn_primary_apcm_swanscombe | 0.0 | 0.0 | 0 |