distribution_substations: 21

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
21 egremont bsp 0 enw 
[
    "7ac63675-01e5-4d96-be6c-6a0b536910ec"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "egremo_132_gt2",
            "egremo_132_gt1"
        ],
        "node_id_1": [
            "c3cd2bb6-16c8-4e41-8f28-f4028dea5ec5",
            "004a4974-ae85-43fe-9294-f3e123a89677"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "egremo_33_gt2",
            "egremo_33_gt1"
        ],
        "node_id_2": [
            "c510ae11-4b7f-4fbe-a9ca-531d8b2a4ce6",
            "c63a972b-296c-45cd-9dea-378c59c54318"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 127.53157894736842,
        "accepted_import": 45.0,
        "project_id": [
            "enw__ecr_project_159",
            "enw__ecr_project_387",
            "enw__ecr_project_524",
            "enw__ecr_project_552"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 51.39327183998001,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": -10.531578947368416,
        "local_dem_headroom": 20.606728160019998
    }
]
 enw_bsp_egremont 54.50354 -3.52919 609351 0 0 enw_gsp_harker_hutton 609600 
[]
 -10.531578947368416 20.606728160019998