substation_types: 26

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
26 back hill bsp lpn ukpn 
[
    "ae5dd606-030b-4e17-b55d-fce39c1ba9b4"
]
 
[
    11.0,
    33.0,
    132.0
]
 
[
    {
        "transformer_name": "gt1a",
        "transformer_id": "1dd654c0-8bf8-4456-b781-cfdaa2c21746",
        "node_1": "1024 baca1t1a",
        "node_id_1": "b6819710-b2b7-47cd-8f27-fd14bbd33d11",
        "voltage_1": 132.0,
        "node_2": "baca52 t bb2(1)",
        "node_id_2": "246aa984-f2c7-4942-a344-d1351e2fe94e",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "substation_id": "ae5dd606-030b-4e17-b55d-fce39c1ba9b4",
        "substation_name": "back hill"
    },
    {
        "transformer_name": "gt3a",
        "transformer_id": "377aac14-8c95-4f2b-8d50-298f270733fb",
        "node_1": "1028 baca1t3a",
        "node_id_1": "b42e2c8d-432a-4261-912a-a2682d78b8a9",
        "voltage_1": 132.0,
        "node_2": "baca52 t bb1(1)",
        "node_id_2": "a1385c56-e114-498d-af19-70fa5c600bbf",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "substation_id": "ae5dd606-030b-4e17-b55d-fce39c1ba9b4",
        "substation_name": "back hill"
    },
    {
        "transformer_name": "gt4a",
        "transformer_id": "4b58800c-a667-4b29-b45d-dad32b56be33",
        "node_1": "1030 baca1t4a",
        "node_id_1": "93d39a9c-6227-46a6-a169-6286d48b14e6",
        "voltage_1": 132.0,
        "node_2": "baca51 b bb1(1)",
        "node_id_2": "7d4885cb-6e47-465a-aec0-7bd12f0d8bf5",
        "voltage_2": 11.0,
        "nom_rating": 30.0,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "substation_id": "ae5dd606-030b-4e17-b55d-fce39c1ba9b4",
        "substation_name": "back hill"
    },
    {
        "transformer_name": "gt4b",
        "transformer_id": "5776122c-580b-456e-8e75-bd017adc9c11",
        "node_1": "1051 back1t4b",
        "node_id_1": "1123491e-d6e0-4d91-b981-47ccdc30fe73",
        "voltage_1": 132.0,
        "node_2": "back31(4)",
        "node_id_2": "95237365-ff10-4ab9-9004-96f68567af91",
        "voltage_2": 33.0,
        "nom_rating": 45.0,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "substation_id": "ae5dd606-030b-4e17-b55d-fce39c1ba9b4",
        "substation_name": "back hill"
    },
    {
        "transformer_name": "gt3b",
        "transformer_id": "5fa21fda-854c-4bcd-9d91-8518db383717",
        "node_1": "1050 back1t3b",
        "node_id_1": "18426afa-45c4-4847-8655-f737e8c6362a",
        "voltage_1": 132.0,
        "node_2": "bacb33 u bb3(1)",
        "node_id_2": "e0f78253-6224-4515-adbb-3b342c4a31d8",
        "voltage_2": 33.0,
        "nom_rating": 45.0,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "substation_id": "ae5dd606-030b-4e17-b55d-fce39c1ba9b4",
        "substation_name": "back hill"
    },
    {
        "transformer_name": "gt2a",
        "transformer_id": "93f21f9b-f1ec-49f9-ac91-a92781e5fef5",
        "node_1": "1026 baca1t2a",
        "node_id_1": "95bfb7de-be0a-42de-9a17-96bb6416dab1",
        "voltage_1": 132.0,
        "node_2": "baca50",
        "node_id_2": "4a95f9a2-3b4c-4fd4-94f1-5a0791fb941e",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "substation_id": "ae5dd606-030b-4e17-b55d-fce39c1ba9b4",
        "substation_name": "back hill"
    },
    {
        "transformer_name": "gt1b",
        "transformer_id": "a0d3cc8d-dd3d-4932-bbcd-9d0b9386595b",
        "node_1": "1048 back1t1b",
        "node_id_1": "a7f2bf39-93fc-44e1-8897-cbd22e4abd71",
        "voltage_1": 132.0,
        "node_2": "bacb33 u bb3(2)",
        "node_id_2": "f15a8035-2a94-49a4-9184-c7beb311fc73",
        "voltage_2": 33.0,
        "nom_rating": 45.0,
        "gsp_group_id": "1a47043d-0708-4949-b619-18973548d137",
        "gsp_group_name": "16 - st johns wood 132kv gsp",
        "substation_id": "ae5dd606-030b-4e17-b55d-fce39c1ba9b4",
        "substation_name": "back hill"
    }
]
 ukpn_lpn_bsp_back_hill 51.52295260436 -0.110191899804077 lpn-s000000003206