substation_types: 88
This data as json
| rowid | location | type | licence | source | substation_ids | voltages | transformers | substation_type_id | latitude | longitude | source_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 88 | gibbons rd | bsp | lpn | ukpn | [
"ca2b68cd-f788-4837-a37b-19ae7201e859"
] |
[
11.11,
132.0
] |
[
{
"transformer_name": "gt1",
"transformer_id": "5e33c0ad-55f6-4f52-9da2-d2ffaf9b9791",
"node_1": "gibr11",
"node_id_1": "27d9e7f2-9562-44a5-a31e-eaa80137fcd9",
"voltage_1": 132.0,
"node_2": "gibr5e",
"node_id_2": "f1fdc963-0c11-49c5-8e17-acd9492a4de7",
"voltage_2": 11.11,
"node_3": "gibr5f",
"node_id_3": "244c18b7-3bb9-459b-830c-e6344725f8a2",
"voltage_3": 11.11,
"nom_rating": 60.6,
"gsp_group_id": "0194f412-d6f0-4859-aee3-21cb2557ed0b",
"gsp_group_name": "19 - willesden 132kv gsp",
"substation_id": "ca2b68cd-f788-4837-a37b-19ae7201e859",
"substation_name": "gibbons rd"
},
{
"transformer_name": "gt2",
"transformer_id": "baa0fe58-16f5-43f4-acfb-67317e205f8b",
"node_1": "4383 gibr1t2_",
"node_id_1": "39187951-067d-4b2a-b186-d63b08a4fb98",
"voltage_1": 132.0,
"node_2": "6383 gibr5t2a",
"node_id_2": "2e86f887-f842-4ae1-821f-1f02cb5b4756",
"voltage_2": 11.11,
"node_3": "5383 gibr5t2b",
"node_id_3": "1b643578-2e09-43fb-98ab-0bcfe05894b8",
"voltage_3": 11.11,
"nom_rating": 60.6,
"gsp_group_id": "0194f412-d6f0-4859-aee3-21cb2557ed0b",
"gsp_group_name": "19 - willesden 132kv gsp",
"substation_id": "ca2b68cd-f788-4837-a37b-19ae7201e859",
"substation_name": "gibbons rd"
},
{
"transformer_name": "gt3",
"transformer_id": "d387293f-6e14-4c4e-8b1a-effa8971e3df",
"node_1": "gibr13",
"node_id_1": "287fdba8-87b6-46f4-8397-354906386579",
"voltage_1": 132.0,
"node_2": "gibr5a",
"node_id_2": "e65b15b4-f352-4fbe-9ea2-0ae1d77ff761",
"voltage_2": 11.11,
"node_3": "gibr5b",
"node_id_3": "e14a25a4-3b00-44ef-a783-cade2d0937da",
"voltage_3": 11.11,
"nom_rating": 60.6,
"gsp_group_id": "0194f412-d6f0-4859-aee3-21cb2557ed0b",
"gsp_group_name": "19 - willesden 132kv gsp",
"substation_id": "ca2b68cd-f788-4837-a37b-19ae7201e859",
"substation_name": "gibbons rd"
}
] |
ukpn_lpn_bsp_gibbons_rd | 51.5463340961811 | -0.256605931549261 | lpn-s000000000240 |