substation_types: 23

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
23 amberley rd bsp lpn ukpn 
[
    "e8acac99-7ac4-43de-bea4-2813881b56fb"
]
 
[
    11.11,
    132.0
]
 
[
    {
        "transformer_name": "gt2",
        "transformer_id": "cbc679c0-97ce-4044-a108-06110d487a99",
        "node_1": "ambl12",
        "node_id_1": "6580019a-790b-4b35-aec7-bb710e3c9781",
        "voltage_1": 132.0,
        "node_2": "ambl51 r bb2(1)",
        "node_id_2": "7dc73657-90ce-492b-ac97-ba8db41d3cb4",
        "voltage_2": 11.11,
        "node_3": "ambl51 r bb1(1)",
        "node_id_3": "30e1c0f4-a2b8-4e47-aa56-69c1145ee0ab",
        "voltage_3": 11.11,
        "nom_rating": 66.6,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "substation_id": "e8acac99-7ac4-43de-bea4-2813881b56fb",
        "substation_name": "amberley rd"
    },
    {
        "transformer_name": "gt1",
        "transformer_id": "fcd1e890-6516-4497-9525-e3941d7b0e8b",
        "node_1": "ambl11",
        "node_id_1": "3c0772d0-28d3-4340-b3b6-30e667c904b6",
        "voltage_1": 132.0,
        "node_2": "ambl52 m bb1(1)",
        "node_id_2": "03173f3f-e6dd-497e-86c2-655d6c3cb547",
        "voltage_2": 11.11,
        "node_3": "ambl52 m bb2(1)",
        "node_id_3": "52ffc4c7-17e2-4009-a41b-43581f8159d2",
        "voltage_3": 11.11,
        "nom_rating": 66.6,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "substation_id": "e8acac99-7ac4-43de-bea4-2813881b56fb",
        "substation_name": "amberley rd"
    }
]
 ukpn_lpn_bsp_amberley_rd 51.5227947036953 -0.192609179198131 lpn-s000000000309