substation_types: 20

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
20 .johns wood primary lpn ukpn 
[
    "f5117388-d988-4e08-b9a2-3923d0a88f58"
]
 
[
    0.415,
    22.0
]
 
[
    {
        "transformer_name": "gt5b_a",
        "transformer_id": "9fc436f5-aa09-4949-93ce-142c0702b543",
        "node_1": "sjow81 bb2(2)",
        "node_id_1": "21e22d28-487d-4deb-9271-874540702c31",
        "voltage_1": 22.0,
        "node_2": "1434 sjwd9e5b",
        "node_id_2": "166bd83f-e6fc-49ce-b266-7f25a30fe862",
        "voltage_2": 0.415,
        "nom_rating": 0.5,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "bsp_group_id": "f5117388-d988-4e08-b9a2-3923d0a88f58",
        "bsp_group_name": "st.johns wood",
        "substation_id": "f5117388-d988-4e08-b9a2-3923d0a88f58",
        "substation_name": "st.johns wood"
    },
    {
        "transformer_name": "gt3b_a",
        "transformer_id": "a8fbe313-304c-48e0-8f62-2ef1b49de465",
        "node_1": "sjow81 bb1(1)",
        "node_id_1": "de866797-2c2b-4d36-b8c9-d27344fdf0ff",
        "voltage_1": 22.0,
        "node_2": "1433 sjwd9e3b",
        "node_id_2": "e806aaea-1e48-47d3-a870-b5518652c06c",
        "voltage_2": 0.415,
        "nom_rating": 0.5,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "bsp_group_id": "f5117388-d988-4e08-b9a2-3923d0a88f58",
        "bsp_group_name": "st.johns wood",
        "substation_id": "f5117388-d988-4e08-b9a2-3923d0a88f58",
        "substation_name": "st.johns wood"
    }
]
 ukpn_lpn_primary_.johns_wood 51.5271023519136 -0.17173674118327 lpn-s000000003385