substation_types: 50
This data as json
| rowid | location | type | licence | source | substation_ids | voltages | transformers | substation_type_id | latitude | longitude | source_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 50 | bulwer | primary | lpn | ukpn | [
"d9caf5ee-8d4a-464f-9541-91df02423319"
] |
[
11.275,
66.0
] |
[
{
"transformer_name": "ft2",
"transformer_id": "5aca0d62-1c41-409e-8496-bc43b76cf3d3",
"node_1": "buls64",
"node_id_1": "46ed04c8-41ee-48be-bef1-e1f78f4fb290",
"voltage_1": 66.0,
"node_2": "buls52 f bb1(1)",
"node_id_2": "1bb6e331-a1eb-46d0-806f-bfd12fa1e989",
"voltage_2": 11.275,
"nom_rating": 15.0,
"gsp_group_id": "c0660d2f-251c-47ef-a51e-13776757f14f",
"gsp_group_name": "18 - wilesden grid 66kv gsp",
"bsp_group_id": "d9caf5ee-8d4a-464f-9541-91df02423319",
"bsp_group_name": "bulwer st",
"substation_id": "d9caf5ee-8d4a-464f-9541-91df02423319",
"substation_name": "bulwer st"
},
{
"transformer_name": "ft3",
"transformer_id": "773db211-7123-4564-9c29-71acc46c4856",
"node_1": "buls63",
"node_id_1": "0786dd4f-5b59-48cb-8d39-9f30a0fa7dff",
"voltage_1": 66.0,
"node_2": "buls51 r bb2(1)",
"node_id_2": "86350f69-2fdc-493d-a7af-ff99cb3fc3a6",
"voltage_2": 11.275,
"nom_rating": 15.0,
"gsp_group_id": "c0660d2f-251c-47ef-a51e-13776757f14f",
"gsp_group_name": "18 - wilesden grid 66kv gsp",
"bsp_group_id": "d9caf5ee-8d4a-464f-9541-91df02423319",
"bsp_group_name": "bulwer st",
"substation_id": "d9caf5ee-8d4a-464f-9541-91df02423319",
"substation_name": "bulwer st"
},
{
"transformer_name": "ft1",
"transformer_id": "77982143-f77d-40d5-8e3f-1dab2fc1173f",
"node_1": "buls62",
"node_id_1": "5b1746bc-fa9f-457e-954b-df2989295e3b",
"voltage_1": 66.0,
"node_2": "buls51 r bb1(1)",
"node_id_2": "f9d17432-a97c-4a65-9a96-8d4e4506b3e4",
"voltage_2": 11.275,
"nom_rating": 15.0,
"gsp_group_id": "c0660d2f-251c-47ef-a51e-13776757f14f",
"gsp_group_name": "18 - wilesden grid 66kv gsp",
"bsp_group_id": "d9caf5ee-8d4a-464f-9541-91df02423319",
"bsp_group_name": "bulwer st",
"substation_id": "d9caf5ee-8d4a-464f-9541-91df02423319",
"substation_name": "bulwer st"
},
{
"transformer_name": "ft4",
"transformer_id": "f9f92396-0eeb-49d1-97e1-e2d7a7a569e0",
"node_1": "buls61",
"node_id_1": "ac9a2bb0-ce2c-44eb-a536-55d2e6569f1b",
"voltage_1": 66.0,
"node_2": "buls52 f bb2(1)",
"node_id_2": "c3ea7f82-d8b6-476b-9573-306db3aaf195",
"voltage_2": 11.275,
"nom_rating": 15.0,
"gsp_group_id": "c0660d2f-251c-47ef-a51e-13776757f14f",
"gsp_group_name": "18 - wilesden grid 66kv gsp",
"bsp_group_id": "d9caf5ee-8d4a-464f-9541-91df02423319",
"bsp_group_name": "bulwer st",
"substation_id": "d9caf5ee-8d4a-464f-9541-91df02423319",
"substation_name": "bulwer st"
}
] |
ukpn_lpn_primary_bulwer | 51.5055865356577 | -0.223434837802431 | lpn-s000000000109 |