substation_types: 31

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
31 barking west primary lpn ukpn 
[
    "ddd3edf2-4466-4760-8e01-8e5334901773"
]
 
[
    11.5,
    33.0
]
 
[
    {
        "transformer_name": "ft2",
        "transformer_id": "68c07f53-5339-49cd-8112-eb03f29c9906",
        "node_1": "barw3b",
        "node_id_1": "e6566dc5-0205-4fb9-9ca0-81d7f282d494",
        "voltage_1": 33.0,
        "node_2": "barw51 bb2(3)",
        "node_id_2": "40b7fac8-08c4-4802-be7b-b278562e59fb",
        "voltage_2": 11.5,
        "nom_rating": 18.0,
        "gsp_group_id": "d0f6c531-f4b3-4d78-8d32-19762ce467ee",
        "gsp_group_name": "03 - barking west 33kv gsp",
        "bsp_group_id": "ddd3edf2-4466-4760-8e01-8e5334901773",
        "bsp_group_name": "barking west",
        "substation_id": "ddd3edf2-4466-4760-8e01-8e5334901773",
        "substation_name": "barking west"
    },
    {
        "transformer_name": "ft1",
        "transformer_id": "73810a3a-f61b-4b8c-8594-a484bad585a5",
        "node_1": "barw3a",
        "node_id_1": "cf1f1736-4d7c-4858-b847-661fb2a862f2",
        "voltage_1": 33.0,
        "node_2": "barw51 bb2(1)",
        "node_id_2": "d803760c-f66f-49c2-81fb-5b1ba9e64be5",
        "voltage_2": 11.5,
        "nom_rating": 18.0,
        "gsp_group_id": "d0f6c531-f4b3-4d78-8d32-19762ce467ee",
        "gsp_group_name": "03 - barking west 33kv gsp",
        "bsp_group_id": "ddd3edf2-4466-4760-8e01-8e5334901773",
        "bsp_group_name": "barking west",
        "substation_id": "ddd3edf2-4466-4760-8e01-8e5334901773",
        "substation_name": "barking west"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "be4314da-bd94-4c26-9133-5266d1bc7a1b",
        "node_1": "barw3c",
        "node_id_1": "b21d5116-e02f-4e01-b92d-228bb4fa7382",
        "voltage_1": 33.0,
        "node_2": "barw51 bb2(2)",
        "node_id_2": "0d4846ad-c055-4983-a995-b6fadc4056fc",
        "voltage_2": 11.5,
        "nom_rating": 18.0,
        "gsp_group_id": "d0f6c531-f4b3-4d78-8d32-19762ce467ee",
        "gsp_group_name": "03 - barking west 33kv gsp",
        "bsp_group_id": "ddd3edf2-4466-4760-8e01-8e5334901773",
        "bsp_group_name": "barking west",
        "substation_id": "ddd3edf2-4466-4760-8e01-8e5334901773",
        "substation_name": "barking west"
    }
]
 ukpn_lpn_primary_barking_west 51.516456922651 0.106906450233802 lpn-s000000003609