substation_types: 34

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
34 beech primary lpn ukpn 
[
    "85c36b47-64ff-4939-8ab2-e7eb26211d70"
]
 
[
    11.0,
    33.0
]
 
[
    {
        "transformer_name": "t4",
        "transformer_id": "870c91bb-52a2-4f39-9368-2ed46b9c17f3",
        "node_1": "beea32",
        "node_id_1": "fb5bb350-c39c-4b21-a48f-bb9df45dad89",
        "voltage_1": 33.0,
        "node_2": "beea5b",
        "node_id_2": "bba1eb2f-618e-4053-abd9-40d471889426",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "bsp_group_id": "85c36b47-64ff-4939-8ab2-e7eb26211d70",
        "bsp_group_name": "beech st",
        "substation_id": "85c36b47-64ff-4939-8ab2-e7eb26211d70",
        "substation_name": "beech st"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "ce733acb-dc6f-490d-bf13-97a311843165",
        "node_1": "beea31",
        "node_id_1": "24c2a0ad-102d-4ecc-9e6e-813584a7bf12",
        "voltage_1": 33.0,
        "node_2": "beea5a",
        "node_id_2": "9783a4ab-1174-4fdb-bac2-f975ebdf9cb6",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "bsp_group_id": "85c36b47-64ff-4939-8ab2-e7eb26211d70",
        "bsp_group_name": "beech st",
        "substation_id": "85c36b47-64ff-4939-8ab2-e7eb26211d70",
        "substation_name": "beech st"
    }
]
 ukpn_lpn_primary_beech 51.520693136804 -0.093377275646604 lpn-s000000000407