substation_types: 40
This data as json
| rowid | location | type | licence | source | substation_ids | voltages | transformers | substation_type_id | latitude | longitude | source_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40 | bloomfield place | primary | lpn | ukpn | [
"9f796eab-89fc-41b7-afd2-904285c804d8"
] |
[
6.8,
66.0
] |
[
{
"transformer_name": "t3",
"transformer_id": "10932311-ba4f-4e74-a11a-6c9fbe987f5b",
"node_1": "blop63",
"node_id_1": "be4b03fa-5a4f-48c8-a58c-4e6cd714782a",
"voltage_1": 66.0,
"node_2": "blop72 r bb2(1)",
"node_id_2": "a2d1d1cb-e3e1-486e-a56a-10ea12699032",
"voltage_2": 6.8,
"nom_rating": 12.0,
"gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
"gsp_group_name": "12 - lodge road b 66kv gsp",
"bsp_group_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
"bsp_group_name": "bloomfield place",
"substation_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
"substation_name": "bloomfield place"
},
{
"transformer_name": "ft1",
"transformer_id": "1b911554-07d0-4650-873e-154970f971bd",
"node_1": "blop61",
"node_id_1": "69416061-64de-4817-bcba-5db0cec3bed7",
"voltage_1": 66.0,
"node_2": "blop72 r bb1(1)",
"node_id_2": "fc7de079-9103-475b-8bd5-a20a0993743e",
"voltage_2": 6.8,
"nom_rating": 12.0,
"gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
"gsp_group_name": "12 - lodge road b 66kv gsp",
"bsp_group_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
"bsp_group_name": "bloomfield place",
"substation_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
"substation_name": "bloomfield place"
},
{
"transformer_name": "ft2",
"transformer_id": "2ecdf959-814e-4514-93bc-c2d779c138e2",
"node_1": "blop62",
"node_id_1": "bcabd608-9d84-4311-9e9b-2ec0faa1e6fc",
"voltage_1": 66.0,
"node_2": "blop71 f bb1(1)",
"node_id_2": "e5c23fcb-c675-41b2-8af5-2727983b0174",
"voltage_2": 6.8,
"nom_rating": 12.0,
"gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
"gsp_group_name": "12 - lodge road b 66kv gsp",
"bsp_group_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
"bsp_group_name": "bloomfield place",
"substation_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
"substation_name": "bloomfield place"
},
{
"transformer_name": "t4",
"transformer_id": "b79da6d1-b311-45e9-b7d2-2b77d4259ea4",
"node_1": "blop64",
"node_id_1": "b028a29d-1187-4a2d-bcad-85cb85d3aac3",
"voltage_1": 66.0,
"node_2": "blop71 f bb2(1)",
"node_id_2": "a3ca2a71-7d79-4232-8485-5461450a8958",
"voltage_2": 6.8,
"nom_rating": 12.0,
"gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
"gsp_group_name": "12 - lodge road b 66kv gsp",
"bsp_group_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
"bsp_group_name": "bloomfield place",
"substation_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
"substation_name": "bloomfield place"
}
] |
ukpn_lpn_primary_bloomfield_place | 51.5115765277992 | -0.144515414150925 | lpn-s000000000313 |