substation_types: 44

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
44 broadway primary lpn ukpn 
[
    "ccea4c2c-2b99-4c7f-ad61-c9879bd46c7a"
]
 
[
    11.0,
    33.0
]
 
[
    {
        "transformer_name": "t2",
        "transformer_id": "28af3cfd-9796-41a0-80ec-7cc6de0b9943",
        "node_1": "broa33",
        "node_id_1": "5dfd1f01-c085-42e0-821d-1c7f1ea40ab1",
        "voltage_1": 33.0,
        "node_2": "broa51 f bb1(1)",
        "node_id_2": "f2bbd815-1088-4863-93f7-0f942276e183",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "835a484d-ebf5-4f1e-9dcd-cf585a66db46",
        "gsp_group_name": "11 - littlebrook 132kv gsp",
        "bsp_group_id": "ccea4c2c-2b99-4c7f-ad61-c9879bd46c7a",
        "bsp_group_name": "broadway",
        "substation_id": "ccea4c2c-2b99-4c7f-ad61-c9879bd46c7a",
        "substation_name": "broadway"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "3a867f11-7198-4bdc-9cc8-68707003457f",
        "node_1": "broa34",
        "node_id_1": "a42cda95-a4c4-4ac8-8656-4b412763518b",
        "voltage_1": 33.0,
        "node_2": "broa51 m bb2(1)",
        "node_id_2": "7fc14d9a-f2b1-4e7b-b136-a59fb36ed321",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "835a484d-ebf5-4f1e-9dcd-cf585a66db46",
        "gsp_group_name": "11 - littlebrook 132kv gsp",
        "bsp_group_id": "ccea4c2c-2b99-4c7f-ad61-c9879bd46c7a",
        "bsp_group_name": "broadway",
        "substation_id": "ccea4c2c-2b99-4c7f-ad61-c9879bd46c7a",
        "substation_name": "broadway"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "b5df0708-33fc-4f6c-a9d8-d6758b0d3da1",
        "node_1": "broa31",
        "node_id_1": "6e15fc38-6e26-4d93-9670-15b134564ccd",
        "voltage_1": 33.0,
        "node_2": "broa51 r bb1(1)",
        "node_id_2": "94c5fe26-9b79-4e19-ad27-68d0c93f4899",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "835a484d-ebf5-4f1e-9dcd-cf585a66db46",
        "gsp_group_name": "11 - littlebrook 132kv gsp",
        "bsp_group_id": "ccea4c2c-2b99-4c7f-ad61-c9879bd46c7a",
        "bsp_group_name": "broadway",
        "substation_id": "ccea4c2c-2b99-4c7f-ad61-c9879bd46c7a",
        "substation_name": "broadway"
    },
    {
        "transformer_name": "t4",
        "transformer_id": "cb19ecb9-3280-4645-9614-6274ec60f86d",
        "node_1": "broa32",
        "node_id_1": "7d372fa4-f469-4740-aa01-2bb3ac3efecb",
        "voltage_1": 33.0,
        "node_2": "broa51 r bb2(1)",
        "node_id_2": "7ed92fe8-fe84-469d-a9cb-d2f42d4aacfa",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "835a484d-ebf5-4f1e-9dcd-cf585a66db46",
        "gsp_group_name": "11 - littlebrook 132kv gsp",
        "bsp_group_id": "ccea4c2c-2b99-4c7f-ad61-c9879bd46c7a",
        "bsp_group_name": "broadway",
        "substation_id": "ccea4c2c-2b99-4c7f-ad61-c9879bd46c7a",
        "substation_name": "broadway"
    }
]
 ukpn_lpn_primary_broadway 51.4569801319857 0.136612148212005 lpn-s000000000705