distribution_substations: 20

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
20 droylsden bsp 0 enw 
[
    "a9efe2b8-380f-4926-84c3-490b5176e607"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "droyls_132_gt2",
            "droyls_132_gt1"
        ],
        "node_id_1": [
            "2ddfe8a6-846c-4ec6-b1b6-14ae212572ea",
            "16475591-e1af-46d3-a20e-05f355876694"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "droyls_33_gt2",
            "droyls_33_gt1"
        ],
        "node_id_2": [
            "87adc87a-776b-4981-bc54-eadb1c19df11",
            "a0fb2587-69de-4506-a465-9526565a4d08"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 1.456,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_336"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 65.69879889718855,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 115.544,
        "local_dem_headroom": 51.30120110281145
    }
]
 enw_bsp_droylsden 53.4802 -2.14954 100003 0 0 0 0 
[]
 115.544 51.30120110281145