distribution_substations: 24

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
24 greenhill bsp 0 enw 
[
    "f64f0c87-a45a-4686-8ec0-fd919899856c"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "greenh_132_gt3",
            "greenh_132_gt2"
        ],
        "node_id_1": [
            "91961f8f-d2b4-42dd-9ed4-30e68d15b9dd",
            "801c4a98-a612-4469-984e-39e7f582092f"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "greenh_33_gt3",
            "greenh_33_gt2"
        ],
        "node_id_2": [
            "1dbf3aff-b8a0-4e1b-9508-28228cc9c5df",
            "940f10d4-80d0-4e5e-b9f1-727e539912c0"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 89.05263157894737,
        "accepted_import": 63.0,
        "project_id": [
            "enw__ecr_project_25",
            "enw__ecr_project_380",
            "enw__ecr_project_480",
            "enw__ecr_project_162",
            "enw__ecr_project_330",
            "enw__ecr_project_483"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 70.2141728856293,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 27.94736842105263,
        "local_dem_headroom": -16.214172885629296
    }
]
 enw_bsp_greenhill 53.53936 -2.10308 300024 0 0 0 0 
[]
 27.94736842105263 -16.214172885629296