distribution_substations: 6

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
6 belfield bsp 0 enw 
[
    "ce6421a5-de26-4078-8b6d-efe028c276e4"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "belfie_132_gt1",
            "belfie_132_gt2"
        ],
        "node_id_1": [
            "44fc8322-7486-4d01-a32c-0e9af2a0c9ec",
            "71ac7a77-9eb6-4838-8b65-a30bd1dced63"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "belfie_33_gt1",
            "belfie_33_gt2"
        ],
        "node_id_2": [
            "cee9474e-817d-4240-a0bd-af28576a9686",
            "c41a5b2e-f2cc-40b1-bcce-855909dfe2a3"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 31.0,
        "accepted_import": 30.0,
        "project_id": [
            "enw__ecr_project_435",
            "enw__ecr_project_147"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 43.76247580300212,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 86.0,
        "local_dem_headroom": 43.23752419699788
    }
]
 enw_bsp_belfield 53.62216 -2.13727 304899 0 0 0 0 
[]
 86.0 43.23752419699788