substation_types: 25

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
25 axe st primary lpn ukpn 
[
    "27b9421d-a569-4e64-8790-0878c54ae440"
]
 
[
    11.275,
    33.0
]
 
[
    {
        "transformer_name": "ft2",
        "transformer_id": "6df21978-db56-4c6d-95b5-300743753bf4",
        "node_1": "axes32",
        "node_id_1": "ffdac1e7-3f39-4e37-be24-669ab94d52b4",
        "voltage_1": 33.0,
        "node_2": "axes52 t bb2(1)",
        "node_id_2": "c508aa23-5de3-41a9-ba5e-2eb32cddd9e5",
        "voltage_2": 11.275,
        "nom_rating": 15.0,
        "gsp_group_id": "d0f6c531-f4b3-4d78-8d32-19762ce467ee",
        "gsp_group_name": "03 - barking west 33kv gsp",
        "bsp_group_id": "27b9421d-a569-4e64-8790-0878c54ae440",
        "bsp_group_name": "axe st",
        "substation_id": "27b9421d-a569-4e64-8790-0878c54ae440",
        "substation_name": "axe st"
    },
    {
        "transformer_name": "ft1",
        "transformer_id": "ccc363f9-21d8-4040-9f79-7f4faaa8d6bf",
        "node_1": "axes31",
        "node_id_1": "a9d47c06-f29d-43b5-8716-611dad6925e0",
        "voltage_1": 33.0,
        "node_2": "axes52 t bb1(1)",
        "node_id_2": "10e92aa3-4cb6-417e-8383-12732cec0b8e",
        "voltage_2": 11.275,
        "nom_rating": 15.0,
        "gsp_group_id": "d0f6c531-f4b3-4d78-8d32-19762ce467ee",
        "gsp_group_name": "03 - barking west 33kv gsp",
        "bsp_group_id": "27b9421d-a569-4e64-8790-0878c54ae440",
        "bsp_group_name": "axe st",
        "substation_id": "27b9421d-a569-4e64-8790-0878c54ae440",
        "substation_name": "axe st"
    },
    {
        "transformer_name": "ft3",
        "transformer_id": "e84c9ed5-6460-42e8-add9-a257b49a7cce",
        "node_1": "axes33",
        "node_id_1": "664b9aae-882c-4a32-a025-8093625f0399",
        "voltage_1": 33.0,
        "node_2": "axes51 b bb2(1)",
        "node_id_2": "7540dc1c-365b-4d47-8043-eed3b2b88951",
        "voltage_2": 11.275,
        "nom_rating": 15.0,
        "gsp_group_id": "d0f6c531-f4b3-4d78-8d32-19762ce467ee",
        "gsp_group_name": "03 - barking west 33kv gsp",
        "bsp_group_id": "27b9421d-a569-4e64-8790-0878c54ae440",
        "bsp_group_name": "axe st",
        "substation_id": "27b9421d-a569-4e64-8790-0878c54ae440",
        "substation_name": "axe st"
    },
    {
        "transformer_name": "ft4",
        "transformer_id": "fbea3656-8be8-43a5-8be4-b96217697588",
        "node_1": "axes34",
        "node_id_1": "0c800eab-e45a-4654-95a1-9e3e094c72ea",
        "voltage_1": 33.0,
        "node_2": "axes51 b bb1(1)",
        "node_id_2": "2581fbf0-78c0-40b6-a543-0466977d1d95",
        "voltage_2": 11.275,
        "nom_rating": 15.0,
        "gsp_group_id": "d0f6c531-f4b3-4d78-8d32-19762ce467ee",
        "gsp_group_name": "03 - barking west 33kv gsp",
        "bsp_group_id": "27b9421d-a569-4e64-8790-0878c54ae440",
        "bsp_group_name": "axe st",
        "substation_id": "27b9421d-a569-4e64-8790-0878c54ae440",
        "substation_name": "axe st"
    }
]
 ukpn_lpn_primary_axe_st 51.5357624271409 0.0798094496235656 lpn-s000000000606