substation_types: 68

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
68 devonshire square bsp lpn ukpn 
[
    "2206ce32-54ff-4ff5-84b9-287b9e78451e"
]
 
[
    11.11,
    132.0
]
 
[
    {
        "transformer_name": "gt1",
        "transformer_id": "4da9ae3c-27f0-4c33-b73f-d9d278cafa75",
        "node_1": "devo11",
        "node_id_1": "5fb723bb-c6bf-4efe-ab8f-0c3f13ee22e7",
        "voltage_1": 132.0,
        "node_2": "devo5a",
        "node_id_2": "86907a9e-0ba0-4773-b8c6-eaa1dad78620",
        "voltage_2": 11.11,
        "node_3": "devo5b",
        "node_id_3": "d181b266-b80c-4fc5-9b66-12913a49d79c",
        "voltage_3": 11.11,
        "nom_rating": 60.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "2206ce32-54ff-4ff5-84b9-287b9e78451e",
        "substation_name": "devonshire square"
    },
    {
        "transformer_name": "gt2",
        "transformer_id": "dcf1abbe-efbe-41c4-a720-32eec6693b88",
        "node_1": "devo12",
        "node_id_1": "b01ce0ef-238f-4437-82b8-6a37a2fed093",
        "voltage_1": 132.0,
        "node_2": "devo5c",
        "node_id_2": "e57495f8-903a-4333-a41d-092f516ced90",
        "voltage_2": 11.11,
        "node_3": "devo5d",
        "node_id_3": "72014d2f-5b6b-43a5-9ca8-6a444b6dc904",
        "voltage_3": 11.11,
        "nom_rating": 60.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "2206ce32-54ff-4ff5-84b9-287b9e78451e",
        "substation_name": "devonshire square"
    },
    {
        "transformer_name": "gt3",
        "transformer_id": "f68a6e97-34a8-4ec7-8d48-da246d9acbcc",
        "node_1": "devo13",
        "node_id_1": "3f650e22-d5a7-44b7-bdf1-36066462557b",
        "voltage_1": 132.0,
        "node_2": "devo5e",
        "node_id_2": "5e507863-f8bd-41ad-a158-5a5e63a141bf",
        "voltage_2": 11.11,
        "node_3": "devo5f",
        "node_id_3": "9705da57-5eb8-4ea7-986f-1f6bf9c31f2a",
        "voltage_3": 11.11,
        "nom_rating": 60.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "2206ce32-54ff-4ff5-84b9-287b9e78451e",
        "substation_name": "devonshire square"
    }
]
 ukpn_lpn_bsp_devonshire_square 51.5163799124923 -0.0797928643756813 lpn-s000000000418