substation_types: 75

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
75 eltham primary lpn ukpn 
[
    "279566aa-aa0f-488a-a693-09a421107c21"
]
 
[
    0.415,
    33.0
]
 
[
    {
        "transformer_name": "gt1a_a_et",
        "transformer_id": "04340a62-dbb0-4a93-ac2c-db718fe9c243",
        "node_1": "eltg32 r bb2(3)",
        "node_id_1": "58b11828-d5a1-4974-9a6d-1372b650bbbe",
        "voltage_1": 33.0,
        "node_2": "terminal(1)",
        "node_id_2": "f6108d69-0ab5-4492-bd31-e7d4a111786e",
        "voltage_2": 0.415,
        "nom_rating": 0.4,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "279566aa-aa0f-488a-a693-09a421107c21",
        "bsp_group_name": "eltham grid",
        "substation_id": "279566aa-aa0f-488a-a693-09a421107c21",
        "substation_name": "eltham grid"
    },
    {
        "transformer_name": "gt4a_a_et",
        "transformer_id": "062214a7-91e9-4266-8934-cba469e56f51",
        "node_1": "eltg32 r bb1(1)",
        "node_id_1": "b4b19141-b9b9-4767-9b2a-f5917249100b",
        "voltage_1": 33.0,
        "node_2": "terminal",
        "node_id_2": "8977ace2-a727-4b5f-9396-f9f485410be2",
        "voltage_2": 0.415,
        "nom_rating": 0.4,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "279566aa-aa0f-488a-a693-09a421107c21",
        "bsp_group_name": "eltham grid",
        "substation_id": "279566aa-aa0f-488a-a693-09a421107c21",
        "substation_name": "eltham grid"
    },
    {
        "transformer_name": "gt3a_a_et",
        "transformer_id": "0799da9f-96dc-4604-a595-554babf4c2a0",
        "node_1": "eltg3a",
        "node_id_1": "cdc0d04a-90c3-4913-8177-de4f4bad3fed",
        "voltage_1": 33.0,
        "node_2": "terminal(3)",
        "node_id_2": "3ab5b384-a23f-490f-8387-d3e4e8f4d160",
        "voltage_2": 0.415,
        "nom_rating": 0.4,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "279566aa-aa0f-488a-a693-09a421107c21",
        "bsp_group_name": "eltham grid",
        "substation_id": "279566aa-aa0f-488a-a693-09a421107c21",
        "substation_name": "eltham grid"
    },
    {
        "transformer_name": "gt2a_a_et",
        "transformer_id": "e91c6741-0dd9-46d1-beba-26ed6ae63a90",
        "node_1": "eltg31 f bb1(3)",
        "node_id_1": "94f87be7-44cc-4df6-bbd8-f11393c85bf1",
        "voltage_1": 33.0,
        "node_2": "terminal(2)",
        "node_id_2": "eb9d1696-bd18-4405-b77d-8c69136e18aa",
        "voltage_2": 0.415,
        "nom_rating": 0.4,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "279566aa-aa0f-488a-a693-09a421107c21",
        "bsp_group_name": "eltham grid",
        "substation_id": "279566aa-aa0f-488a-a693-09a421107c21",
        "substation_name": "eltham grid"
    }
]
 ukpn_lpn_primary_eltham 51.4597977977912 0.0804566948455602 lpn-s000000003732