substation_types: 19

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
19 .johns wood bsp lpn ukpn 
[
    "f5117388-d988-4e08-b9a2-3923d0a88f58"
]
 
[
    22.0,
    132.0
]
 
[
    {
        "transformer_name": "gt3b",
        "transformer_id": "32c1c691-9ad2-4050-8249-75ca385f069f",
        "node_1": "sjow1f",
        "node_id_1": "c6444d52-3cb8-466f-acc8-603c968f1541",
        "voltage_1": 132.0,
        "node_2": "sjow81 bb1(1)",
        "node_id_2": "de866797-2c2b-4d36-b8c9-d27344fdf0ff",
        "voltage_2": 22.0,
        "nom_rating": 45.0,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "substation_id": "f5117388-d988-4e08-b9a2-3923d0a88f58",
        "substation_name": "st.johns wood"
    },
    {
        "transformer_name": "gt5b",
        "transformer_id": "aa23ea4d-6e3c-4017-8f65-ec8f66a12c44",
        "node_1": "sjow1j",
        "node_id_1": "57dfcab9-ddd2-4a8b-b132-e52fad69c624",
        "voltage_1": 132.0,
        "node_2": "t_19",
        "node_id_2": "322c504a-5660-4c00-ae1c-1e8677563c5a",
        "voltage_2": 22.0,
        "nom_rating": 45.0,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "substation_id": "f5117388-d988-4e08-b9a2-3923d0a88f58",
        "substation_name": "st.johns wood"
    }
]
 ukpn_lpn_bsp_.johns_wood 51.5271023519136 -0.17173674118327 lpn-s000000003385