substation_types: 48

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
48 buckhurst hill bsp lpn ukpn 
[
    "02e7671d-6fa9-4298-a597-05579288fe34"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "transformer_name": "gt1a",
        "transformer_id": "31888e16-a713-47c9-9ac1-2bad55870192",
        "node_1": "buck11(1)",
        "node_id_1": "19e0413f-ba17-4475-b655-3eae4e313850",
        "voltage_1": 132.0,
        "node_2": "buck32 r bb1(3)",
        "node_id_2": "b0101447-330e-491d-b74e-2470ebd75867",
        "voltage_2": 33.0,
        "nom_rating": 60.0,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "substation_id": "02e7671d-6fa9-4298-a597-05579288fe34",
        "substation_name": "buckhurst hill"
    },
    {
        "transformer_name": "gt2a",
        "transformer_id": "616f9f72-a181-47e3-a5e3-84ef4b71bfcc",
        "node_1": "buck12(2)",
        "node_id_1": "169becd5-0949-43e6-bd8d-392ee8b311eb",
        "voltage_1": 132.0,
        "node_2": "buck31 f bb1(3)",
        "node_id_2": "babda42c-2fef-46ca-aaa0-9262ed22b7fb",
        "voltage_2": 33.0,
        "nom_rating": 60.0,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "substation_id": "02e7671d-6fa9-4298-a597-05579288fe34",
        "substation_name": "buckhurst hill"
    },
    {
        "transformer_name": "gt1b",
        "transformer_id": "c8326d3a-5f71-40d1-bf6a-0ac363dfe56f",
        "node_1": "buck11(2)",
        "node_id_1": "f3fab431-eaac-4d4b-a520-19389c470263",
        "voltage_1": 132.0,
        "node_2": "buck31 f bb2(4)",
        "node_id_2": "34fe9c4d-6186-4926-9e3c-7f989a9b0ba8",
        "voltage_2": 33.0,
        "nom_rating": 60.0,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "substation_id": "02e7671d-6fa9-4298-a597-05579288fe34",
        "substation_name": "buckhurst hill"
    },
    {
        "transformer_name": "gt2b",
        "transformer_id": "e6319d57-4b0d-40d0-b0e1-69b1ec9d64f5",
        "node_1": "buck12(1)",
        "node_id_1": "0c7a8dd4-d30f-41e9-9302-d4ac83985a03",
        "voltage_1": 132.0,
        "node_2": "buck32 r bb2(3)",
        "node_id_2": "206b36c5-bc82-4a1c-87ab-0887569fab22",
        "voltage_2": 33.0,
        "nom_rating": 60.0,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "substation_id": "02e7671d-6fa9-4298-a597-05579288fe34",
        "substation_name": "buckhurst hill"
    }
]
 ukpn_lpn_bsp_buckhurst_hill 51.6250134762281 0.032136634041024 lpn-s000000003508