substation_types: 27

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
27 back hill primary lpn ukpn 
[
    "ae5dd606-030b-4e17-b55d-fce39c1ba9b4"
]
 
[
    0.415,
    33.0
]
 
[
    {
        "transformer_name": "gt1b_a(1)",
        "transformer_id": "a7a76b17-1705-4818-83f0-626f7670b60e",
        "node_1": "bacb33 u bb3(2)",
        "node_id_1": "f15a8035-2a94-49a4-9184-c7beb311fc73",
        "voltage_1": 33.0,
        "node_2": "terminal",
        "node_id_2": "d20d0ee6-2006-4764-a6f3-9dbfb9b33647",
        "voltage_2": 0.415,
        "nom_rating": 0.13,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "bsp_group_id": "ae5dd606-030b-4e17-b55d-fce39c1ba9b4",
        "bsp_group_name": "back hill",
        "substation_id": "ae5dd606-030b-4e17-b55d-fce39c1ba9b4",
        "substation_name": "back hill"
    },
    {
        "transformer_name": "gt3b_a(1)",
        "transformer_id": "bffe9624-2150-46ba-af4b-3c15b9015db4",
        "node_1": "bacb33 u bb3(1)",
        "node_id_1": "e0f78253-6224-4515-adbb-3b342c4a31d8",
        "voltage_1": 33.0,
        "node_2": "terminal(2)",
        "node_id_2": "c5a5f6bb-c361-4823-a7d7-bcd8d5f31c25",
        "voltage_2": 0.415,
        "nom_rating": 0.13,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "bsp_group_id": "ae5dd606-030b-4e17-b55d-fce39c1ba9b4",
        "bsp_group_name": "back hill",
        "substation_id": "ae5dd606-030b-4e17-b55d-fce39c1ba9b4",
        "substation_name": "back hill"
    },
    {
        "transformer_name": "gt4b_a(1)",
        "transformer_id": "f7d8b6af-0ae0-4420-83c9-385fb7d3bd66",
        "node_1": "back31(4)",
        "node_id_1": "95237365-ff10-4ab9-9004-96f68567af91",
        "voltage_1": 33.0,
        "node_2": "terminal(3)",
        "node_id_2": "6eb7b1c5-561c-448b-8430-e6af087f0828",
        "voltage_2": 0.415,
        "nom_rating": 0.13,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "bsp_group_id": "ae5dd606-030b-4e17-b55d-fce39c1ba9b4",
        "bsp_group_name": "back hill",
        "substation_id": "ae5dd606-030b-4e17-b55d-fce39c1ba9b4",
        "substation_name": "back hill"
    }
]
 ukpn_lpn_primary_back_hill 51.52295260436 -0.110191899804077 lpn-s000000003206