substation_types: 33

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
33 beech bsp lpn ukpn 
[
    "85c36b47-64ff-4939-8ab2-e7eb26211d70"
]
 
[
    11.11,
    132.0
]
 
[
    {
        "transformer_name": "gt2",
        "transformer_id": "78a0a1cf-af17-43a1-a52e-f5ee642f5ae0",
        "node_1": "beeb11",
        "node_id_1": "d7ed00a6-3929-4e84-a386-7886e24ce1cc",
        "voltage_1": 132.0,
        "node_2": "beeb5c",
        "node_id_2": "6859f773-e640-46d5-96e5-6e5e8f3e5702",
        "voltage_2": 11.11,
        "node_3": "beeb5d",
        "node_id_3": "df5b438c-7edd-4564-a958-e4927f4d0f57",
        "voltage_3": 11.11,
        "nom_rating": 60.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "85c36b47-64ff-4939-8ab2-e7eb26211d70",
        "substation_name": "beech st"
    },
    {
        "transformer_name": "gt1",
        "transformer_id": "d20b13c8-34b5-42a4-b8ce-7b3fd51a5933",
        "node_1": "beeb13",
        "node_id_1": "cb707e1a-5f6c-4982-9b13-8c95d7dac06d",
        "voltage_1": 132.0,
        "node_2": "beeb5a",
        "node_id_2": "7e55406f-25b1-448b-8271-081ac5baa920",
        "voltage_2": 11.11,
        "node_3": "beeb5b",
        "node_id_3": "097c97cd-fd93-45d4-a41b-554a00556246",
        "voltage_3": 11.11,
        "nom_rating": 60.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "85c36b47-64ff-4939-8ab2-e7eb26211d70",
        "substation_name": "beech st"
    },
    {
        "transformer_name": "gt3",
        "transformer_id": "fc7fb12f-447f-4f05-b380-1be726f8a344",
        "node_1": "beeb12",
        "node_id_1": "f48138e0-8dae-4076-8b68-9365a15b449b",
        "voltage_1": 132.0,
        "node_2": "beeb5e",
        "node_id_2": "064180fb-9818-44f8-8812-1083eeab3d21",
        "voltage_2": 11.11,
        "node_3": "beeb5f",
        "node_id_3": "72637dc2-d37a-477a-8876-01467553005d",
        "voltage_3": 11.11,
        "nom_rating": 60.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "85c36b47-64ff-4939-8ab2-e7eb26211d70",
        "substation_name": "beech st"
    }
]
 ukpn_lpn_bsp_beech 51.520693136804 -0.093377275646604 lpn-s000000000407