distribution_substations: 59

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
59 west didsbury bsp 0 enw 
[
    "ea1acfe1-d96b-41fa-bc00-51e22e4e5db6"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "wdidsb_132_gt1",
            "wdidsb_132_gt2",
            "wdidsb_132_gt3"
        ],
        "node_id_1": [
            "45f7538c-b8c8-4f9f-a73a-64f85e010953",
            "c330eaa5-04d9-4cd4-8af8-5f3fe790cea8",
            "c934514f-f890-48da-b2bc-89c79520dafc"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "wdidsb_33_gt1",
            "wdidsb_33_gt2",
            "wdidsb_33_gt3"
        ],
        "node_id_2": [
            "1f2eaf20-7aa6-453a-a215-5918c6246aad",
            "38c4372b-6c64-4946-9170-5c638a30f467",
            "2344d773-b261-443c-95ff-ff45778504cb"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            78.0,
            60.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 94.93233103722451,
        "firm_capacity": 124.0,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 124.0,
        "local_dem_headroom": 29.067668962775485
    }
]
 enw_bsp_west_didsbury 53.42927 -2.25292 0 0 0 enw_gsp_south_manchester 100091 
[]
 124.0 29.067668962775485