substation_types: 99

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
99 imperial college primary lpn ukpn 
[
    "354534b8-b84b-4add-96dc-a4ff566a80b8"
]
 
[
    6.6,
    22.0
]
 
[
    {
        "transformer_name": "t4",
        "transformer_id": "01466a4c-b8b3-47be-91ee-64dcf2db4f0a",
        "node_1": "impc84",
        "node_id_1": "e22a60d2-6c17-41c3-a6e4-71b0d503cee0",
        "voltage_1": 22.0,
        "node_2": "impc71 l bb2(1)",
        "node_id_2": "e564a865-5904-4605-a23d-e8a1980ffeaf",
        "voltage_2": 6.6,
        "nom_rating": 10.0,
        "gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
        "gsp_group_name": "12 - lodge road b 66kv gsp",
        "bsp_group_id": "354534b8-b84b-4add-96dc-a4ff566a80b8",
        "bsp_group_name": "imperial college",
        "substation_id": "354534b8-b84b-4add-96dc-a4ff566a80b8",
        "substation_name": "imperial college"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "71256b56-9603-458a-b2ba-d3ba9a4c0cd9",
        "node_1": "impc81",
        "node_id_1": "97842f25-0927-4d05-a313-8e7426bf9879",
        "voltage_1": 22.0,
        "node_2": "impc72 u bb1(1)",
        "node_id_2": "3cb0605f-e2ad-4987-b348-2284f540f8dd",
        "voltage_2": 6.6,
        "nom_rating": 10.0,
        "gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
        "gsp_group_name": "12 - lodge road b 66kv gsp",
        "bsp_group_id": "354534b8-b84b-4add-96dc-a4ff566a80b8",
        "bsp_group_name": "imperial college",
        "substation_id": "354534b8-b84b-4add-96dc-a4ff566a80b8",
        "substation_name": "imperial college"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "93dc61f0-b7c6-4ea1-9076-85241f8d61ea",
        "node_1": "impc83",
        "node_id_1": "f33b00b9-8f92-410d-97ac-eb7750ccabad",
        "voltage_1": 22.0,
        "node_2": "impc72 u bb2(1)",
        "node_id_2": "3d6dea1c-58d8-4b8c-8ac1-0d6e82c285aa",
        "voltage_2": 6.6,
        "nom_rating": 10.0,
        "gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
        "gsp_group_name": "12 - lodge road b 66kv gsp",
        "bsp_group_id": "354534b8-b84b-4add-96dc-a4ff566a80b8",
        "bsp_group_name": "imperial college",
        "substation_id": "354534b8-b84b-4add-96dc-a4ff566a80b8",
        "substation_name": "imperial college"
    },
    {
        "transformer_name": "t2",
        "transformer_id": "cf197f03-f487-4bff-86f7-37a0adca652f",
        "node_1": "impc82",
        "node_id_1": "86308e4b-240a-4486-8bbd-ba436ece552e",
        "voltage_1": 22.0,
        "node_2": "impc71 l bb1(1)",
        "node_id_2": "d104f0ab-9787-4702-a06a-8a02a27a5733",
        "voltage_2": 6.6,
        "nom_rating": 10.0,
        "gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
        "gsp_group_name": "12 - lodge road b 66kv gsp",
        "bsp_group_id": "354534b8-b84b-4add-96dc-a4ff566a80b8",
        "bsp_group_name": "imperial college",
        "substation_id": "354534b8-b84b-4add-96dc-a4ff566a80b8",
        "substation_name": "imperial college"
    }
]
 ukpn_lpn_primary_imperial_college 51.4987944853967 -0.176385161046171 lpn-s000000000353