home / primary / substation_types

substation_types: 39

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
39 blackwall way bsp lpn ukpn
[
    "101fee46-c11a-4dcb-b6b6-4269180bf7bc"
]
[
    11.11,
    132.0
]
[
    {
        "transformer_name": "gt1a",
        "transformer_id": "1e56236e-55b9-4828-b66e-212a4bbf99e6",
        "node_1": "bkwy11",
        "node_id_1": "0c4a37bb-a548-4502-a51d-ee30e2860e53",
        "voltage_1": 132.0,
        "node_2": "bkwy51 u bb1(1)",
        "node_id_2": "7736a278-80ab-48c2-b1ef-2b2fd96394e6",
        "voltage_2": 11.11,
        "node_3": "bkwy51 u bb2(1)",
        "node_id_3": "3d4df323-d4c8-47eb-bf4c-819132a84cf1",
        "voltage_3": 11.11,
        "nom_rating": 66.66,
        "gsp_group_id": "18985509-f571-4feb-a570-3bb1fe521ec0",
        "gsp_group_name": "17 - west ham 132 kv gsp",
        "substation_id": "101fee46-c11a-4dcb-b6b6-4269180bf7bc",
        "substation_name": "blackwall way"
    },
    {
        "transformer_name": "gt2a",
        "transformer_id": "915f3f7a-a796-4f5b-ada4-d4d6daa1bad4",
        "node_1": "bkwy12",
        "node_id_1": "00fe3ba9-fb36-4205-8ef0-0455af16ba7e",
        "voltage_1": 132.0,
        "node_2": "bkwy52 l bb1(1)",
        "node_id_2": "8b6071c7-cf20-47bf-9de2-aceddcc18cab",
        "voltage_2": 11.11,
        "node_3": "bkwy52 l bb2(1)",
        "node_id_3": "8e455a68-4e9a-4760-8b6f-6839b4ad360f",
        "voltage_3": 11.11,
        "nom_rating": 66.66,
        "gsp_group_id": "18985509-f571-4feb-a570-3bb1fe521ec0",
        "gsp_group_name": "17 - west ham 132 kv gsp",
        "substation_id": "101fee46-c11a-4dcb-b6b6-4269180bf7bc",
        "substation_name": "blackwall way"
    }
]
ukpn_lpn_bsp_blackwall_way 51.507129604829 -0.00350464748068387 lpn-s000000000640
Powered by Datasette · Queries took 2.983ms