distribution_substations: 29

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id bsp_group_id bsp_group_name gsp_group_id gsp_group_name other_substation_ids global_gen_headroom global_dem_headroom
29 kendal bsp 0 enw 
[
    "173653ae-2fb6-42dc-8293-a33b4ff9ed85"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "kendal_132_gt1",
            "kendal_132_gt2"
        ],
        "node_id_1": [
            "6a61ede2-b38c-43d5-a443-ea56e2dc5390",
            "ddebada9-0f2a-4254-a5d7-62c6424e4204"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "kendal_33_gt1",
            "kendal_33_gt2"
        ],
        "node_id_2": [
            "3c47fca6-9aac-47f9-8b29-9074dc5c97d4",
            "1aed9e6a-b67f-4fca-a038-ac4a32b71c63"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 84.85,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_148",
            "enw__ecr_project_209",
            "enw__ecr_project_210",
            "enw__ecr_project_523"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 89.54096598965967,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 32.150000000000006,
        "local_dem_headroom": 27.459034010340332
    }
]
 enw_bsp_kendal 54.31969 -2.74168 609051 0 0 enw_gsp_harker_hutton 609600 
[]
 32.150000000000006 27.459034010340332