substation_types: 49

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
49 buckhurst hill primary lpn ukpn 
[
    "02e7671d-6fa9-4298-a597-05579288fe34"
]
 
[
    0.415,
    33.0
]
 
[
    {
        "transformer_name": "gt2b_a",
        "transformer_id": "0680bea6-1e0c-4cd3-a3a1-e50413221b97",
        "node_1": "buck32 r bb2(3)",
        "node_id_1": "206b36c5-bc82-4a1c-87ab-0887569fab22",
        "voltage_1": 33.0,
        "node_2": "terminal(3)",
        "node_id_2": "c7c852e2-3fd8-4e0f-9286-5560accf551a",
        "voltage_2": 0.415,
        "nom_rating": 0.155,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "bsp_group_id": "02e7671d-6fa9-4298-a597-05579288fe34",
        "bsp_group_name": "buckhurst hill",
        "substation_id": "02e7671d-6fa9-4298-a597-05579288fe34",
        "substation_name": "buckhurst hill"
    },
    {
        "transformer_name": "gt1a_a",
        "transformer_id": "7de7928d-52ef-40f0-a260-eb705e2219fe",
        "node_1": "buck32 r bb1(3)",
        "node_id_1": "b0101447-330e-491d-b74e-2470ebd75867",
        "voltage_1": 33.0,
        "node_2": "terminal",
        "node_id_2": "fa592cad-d27b-4a73-8001-a41f15948c0d",
        "voltage_2": 0.415,
        "nom_rating": 0.155,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "bsp_group_id": "02e7671d-6fa9-4298-a597-05579288fe34",
        "bsp_group_name": "buckhurst hill",
        "substation_id": "02e7671d-6fa9-4298-a597-05579288fe34",
        "substation_name": "buckhurst hill"
    },
    {
        "transformer_name": "gt2a_a",
        "transformer_id": "942bb4fd-1f21-4a5c-b44c-b35569002219",
        "node_1": "buck31 f bb1(3)",
        "node_id_1": "babda42c-2fef-46ca-aaa0-9262ed22b7fb",
        "voltage_1": 33.0,
        "node_2": "terminal(2)",
        "node_id_2": "8838258f-0210-4a09-b0fb-4c64ea368df6",
        "voltage_2": 0.415,
        "nom_rating": 0.155,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "bsp_group_id": "02e7671d-6fa9-4298-a597-05579288fe34",
        "bsp_group_name": "buckhurst hill",
        "substation_id": "02e7671d-6fa9-4298-a597-05579288fe34",
        "substation_name": "buckhurst hill"
    },
    {
        "transformer_name": "gt1b_a",
        "transformer_id": "de05a3c7-ab09-4f67-a484-ca4865f53eaf",
        "node_1": "buck31 f bb2(4)",
        "node_id_1": "34fe9c4d-6186-4926-9e3c-7f989a9b0ba8",
        "voltage_1": 33.0,
        "node_2": "terminal(1)",
        "node_id_2": "ad350025-9fe3-4b3d-84d4-a0d96ac8b375",
        "voltage_2": 0.415,
        "nom_rating": 0.155,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "bsp_group_id": "02e7671d-6fa9-4298-a597-05579288fe34",
        "bsp_group_name": "buckhurst hill",
        "substation_id": "02e7671d-6fa9-4298-a597-05579288fe34",
        "substation_name": "buckhurst hill"
    }
]
 ukpn_lpn_primary_buckhurst_hill 51.6250134762281 0.032136634041024 lpn-s000000003508