substation_types: 41

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
41 bow bsp lpn ukpn 
[
    "85aa11c1-c255-486d-9022-bbc04325a952"
]
 
[
    11.11,
    25.0,
    132.0
]
 
[
    {
        "transformer_name": "gt1",
        "transformer_id": "3fae3b00-60fb-4021-a876-128132a15f51",
        "node_1": "bows11",
        "node_id_1": "b7eff79a-05a5-4baa-8990-de8ef8f8a892",
        "voltage_1": 132.0,
        "node_2": "bows5a",
        "node_id_2": "007e92dc-7ea9-47f7-baf6-0cc7230b0366",
        "voltage_2": 11.11,
        "node_3": "bows5b",
        "node_id_3": "67f91549-cf43-481d-91ff-ab63be88600b",
        "voltage_3": 11.11,
        "nom_rating": 66.6,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "substation_id": "85aa11c1-c255-486d-9022-bbc04325a952",
        "substation_name": "bow"
    },
    {
        "transformer_name": "lpn 0022(2)",
        "transformer_id": "571fe5f3-6633-4a02-8510-231a3b3bf062",
        "node_1": "lpn 0022",
        "node_id_1": "cec22da2-e9af-4c5f-ae96-230afb91e93d",
        "voltage_1": 132.0,
        "node_2": "bwnr8a",
        "node_id_2": "d951cc27-0b86-4626-8a5f-3f53631a0286",
        "voltage_2": 25.0,
        "nom_rating": 85.0,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "substation_id": "85aa11c1-c255-486d-9022-bbc04325a952",
        "substation_name": "bow"
    },
    {
        "transformer_name": "lpn 0022(3)",
        "transformer_id": "62700cd0-c987-425b-957c-d72a76685e35",
        "node_1": "lpn 0022(1)",
        "node_id_1": "f20e4735-00e1-44c6-aafb-14193486c4f7",
        "voltage_1": 132.0,
        "node_2": "bwnr8b",
        "node_id_2": "7632c07c-2dc8-4336-a7ce-99ae071d16bb",
        "voltage_2": 25.0,
        "nom_rating": 85.0,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "substation_id": "85aa11c1-c255-486d-9022-bbc04325a952",
        "substation_name": "bow"
    },
    {
        "transformer_name": "gt2",
        "transformer_id": "74db772b-6101-4143-bbe5-f7d4d58dc0c6",
        "node_1": "bows12",
        "node_id_1": "56c5c421-bfa8-45a1-b59d-7cc77cd25350",
        "voltage_1": 132.0,
        "node_2": "bows5c",
        "node_id_2": "63cac601-3690-47e2-8f96-b461a53a3ce0",
        "voltage_2": 11.11,
        "node_3": "bows5d",
        "node_id_3": "7cf223c2-989d-4189-a40c-3e5431bebfd6",
        "voltage_3": 11.11,
        "nom_rating": 66.6,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "substation_id": "85aa11c1-c255-486d-9022-bbc04325a952",
        "substation_name": "bow"
    }
]
 ukpn_lpn_bsp_bow 51.5325947141485 -0.0123825637120869 lpn-s000000000615