distribution_substations: 3

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
3 altrincham bsp 0 enw 
[
    "eeacadc3-9582-4192-8472-0a27bba26c83"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "altrin_132_gt2",
            "altrin_132_gt1"
        ],
        "node_id_1": [
            "c5455a0e-8e44-4292-b9de-b672c210ae0a",
            "3e90ea19-5c12-4698-92bf-db4e62c60cd9"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "altrin_33_gt2",
            "altrin_33_gt1"
        ],
        "node_id_2": [
            "e8569b04-bf43-4ea2-9694-8de4d765ec2d",
            "27ee63e5-979a-4887-aa58-8482d6992fa5"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 55.47384709488014,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 117.0,
        "local_dem_headroom": 61.52615290511986
    }
]
 enw_bsp_altrincham 53.39778 -2.35667 100001 0 0 0 100092 
[]
 117.0 61.52615290511986