substation_types: 28

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
28 bankside bsp lpn ukpn 
[
    "02e94660-dbf8-4a3b-b61a-deca003f0852"
]
 
[
    11.11,
    20.0,
    132.0
]
 
[
    {
        "transformer_name": "gt5",
        "transformer_id": "19d7e1f0-8748-43b3-ae72-bc1c7da39e0f",
        "node_1": "band12",
        "node_id_1": "fde343e4-5631-4356-8ee4-52e3dc89fbd1",
        "voltage_1": 132.0,
        "node_2": "band82 r bb2(1)",
        "node_id_2": "95197566-5bdf-4516-bea4-55ff9772e55c",
        "voltage_2": 20.0,
        "node_3": "band82 m bb2(1)",
        "node_id_3": "7d9869cb-7958-427b-8ed0-5a7be2a885e8",
        "voltage_3": 20.0,
        "nom_rating": 90.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "02e94660-dbf8-4a3b-b61a-deca003f0852",
        "substation_name": "bankside"
    },
    {
        "transformer_name": "gt3",
        "transformer_id": "356cad65-5e31-4ed0-8d6a-fd0efb9d1bed",
        "node_1": "banc13",
        "node_id_1": "517acdc1-ed68-45b6-af83-c4488f70a37d",
        "voltage_1": 132.0,
        "node_2": "banc52 m bb4(3)",
        "node_id_2": "b8c90cf1-5349-4bbf-a477-23e0090a5616",
        "voltage_2": 11.11,
        "node_3": "banc52 m bb4(2)",
        "node_id_3": "7b671733-53f7-47ff-85ea-779f9c1ecdc2",
        "voltage_3": 11.11,
        "nom_rating": 66.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "02e94660-dbf8-4a3b-b61a-deca003f0852",
        "substation_name": "bankside"
    },
    {
        "transformer_name": "gt2",
        "transformer_id": "3bcaa1ab-4f76-4f75-a86e-5e8e102e4f66",
        "node_1": "banc12",
        "node_id_1": "4b11d82c-a0bc-4791-8f30-97b766ad90f9",
        "voltage_1": 132.0,
        "node_2": "banc53 r bb2(3)",
        "node_id_2": "5a5caa6c-c596-4b9c-b284-830ed49993c3",
        "voltage_2": 11.11,
        "node_3": "banc53 r bb2(2)",
        "node_id_3": "1e7fb46f-eae7-48d9-9710-6fdbb38d01af",
        "voltage_3": 11.11,
        "nom_rating": 66.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "02e94660-dbf8-4a3b-b61a-deca003f0852",
        "substation_name": "bankside"
    },
    {
        "transformer_name": "gt1",
        "transformer_id": "63e70f0f-0d90-4ef3-9486-97fa6549b0d8",
        "node_1": "banc11",
        "node_id_1": "9ef2ed98-2eeb-4bf4-bd4f-2781bcfedc72",
        "voltage_1": 132.0,
        "node_2": "banc51 m bb1(2)",
        "node_id_2": "4790925f-30de-4c06-b1b1-14ba209c373e",
        "voltage_2": 11.11,
        "node_3": "banc51 m bb1(1)",
        "node_id_3": "4f75bd55-2cc4-4188-8ff3-a81520bf6f50",
        "voltage_3": 11.11,
        "nom_rating": 66.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "02e94660-dbf8-4a3b-b61a-deca003f0852",
        "substation_name": "bankside"
    },
    {
        "transformer_name": "gt1b",
        "transformer_id": "66a717f6-86e3-4ba5-94f5-f2618a9a458e",
        "node_1": "band11",
        "node_id_1": "94dacdeb-cd86-4752-9fa8-9d1478259561",
        "voltage_1": 132.0,
        "node_2": "band81 r bb1(3)",
        "node_id_2": "b4e22e41-6f50-4696-905f-ef94239d65eb",
        "voltage_2": 20.0,
        "node_3": "band81 m bb1(3)",
        "node_id_3": "bb52335c-186c-4176-b1dc-ab65ddf5b72d",
        "voltage_3": 20.0,
        "nom_rating": 90.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "02e94660-dbf8-4a3b-b61a-deca003f0852",
        "substation_name": "bankside"
    },
    {
        "transformer_name": "gt4",
        "transformer_id": "e4db9a37-8977-4fca-b59d-4124447756eb",
        "node_1": "banc14",
        "node_id_1": "1f1de3b6-9c0d-4b92-b559-5b9233b08a52",
        "voltage_1": 132.0,
        "node_2": "banc54 r bb4(5)",
        "node_id_2": "fb2e1b7b-15f2-474c-bba2-e6e475e792e6",
        "voltage_2": 11.11,
        "node_3": "banc54 r bb4(2)",
        "node_id_3": "f3401e01-f70e-45d5-9a02-6915bec326bb",
        "voltage_3": 11.11,
        "nom_rating": 66.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "02e94660-dbf8-4a3b-b61a-deca003f0852",
        "substation_name": "bankside"
    }
]
 ukpn_lpn_bsp_bankside 51.5076350987211 -0.0999747983822171 lpn-s000000003908