substation_types: 32
This data as json
| rowid | location | type | licence | source | substation_ids | voltages | transformers | substation_type_id | latitude | longitude | source_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 32 | barnes | primary | lpn | ukpn | [
"6c774275-644b-4ede-943e-0caa8f5af005"
] |
[
6.9,
66.0
] |
[
{
"transformer_name": "t3b",
"transformer_id": "03b08c0c-1fd2-4968-8e15-ba5f7569a8b9",
"node_1": "bnsb61",
"node_id_1": "1c5ff5cb-4aaf-4a56-8655-040f5190c551",
"voltage_1": 66.0,
"node_2": "bnsb7a",
"node_id_2": "65e57cb6-8547-4b9a-8386-527363aa17ba",
"voltage_2": 6.9,
"nom_rating": 30.0,
"gsp_group_id": "dcf403f4-5966-477d-ad33-ca6a38c4be15",
"gsp_group_name": "21 - wimbledon 3&4 132kv gsp",
"bsp_group_id": "6c774275-644b-4ede-943e-0caa8f5af005",
"bsp_group_name": "barnes",
"substation_id": "6c774275-644b-4ede-943e-0caa8f5af005",
"substation_name": "barnes"
},
{
"transformer_name": "t4b",
"transformer_id": "4db114bc-a47b-41bc-8e39-9c096416bbe9",
"node_1": "bnsb62",
"node_id_1": "133c87c7-b2c3-43a7-9f7b-58f9b98b8295",
"voltage_1": 66.0,
"node_2": "bnsb7b",
"node_id_2": "2ecbbda2-1ec2-4079-afee-bdae89588214",
"voltage_2": 6.9,
"nom_rating": 30.0,
"gsp_group_id": "dcf403f4-5966-477d-ad33-ca6a38c4be15",
"gsp_group_name": "21 - wimbledon 3&4 132kv gsp",
"bsp_group_id": "6c774275-644b-4ede-943e-0caa8f5af005",
"bsp_group_name": "barnes",
"substation_id": "6c774275-644b-4ede-943e-0caa8f5af005",
"substation_name": "barnes"
}
] |
ukpn_lpn_primary_barnes | 51.4701811475145 | -0.258660815801242 | lpn-s000000001008 |