distribution_substations: 40

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
40 preston east bsp 0 enw 
[
    "5e0c3aee-3531-4a2f-a500-b9771b3ed46c"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "preste_132_gt2",
            "preste_132_gt1"
        ],
        "node_id_1": [
            "97cf5ee8-c59a-4c9c-a894-df2970aa18a9",
            "2c4148d3-19eb-4b25-818d-64c6a6e34941"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "preste_33_gt2",
            "preste_33_gt1"
        ],
        "node_id_2": [
            "628b526b-2afe-495f-972f-1ab9046681a0",
            "16020857-4e55-44d0-b348-8ddebf2e3cb5"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 21.05263157894737,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_248"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 62.82375224165701,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 95.94736842105263,
        "local_dem_headroom": 54.17624775834299
    }
]
 enw_bsp_preston_east 53.79104 -2.6584 400400 0 0 0 0 
[]
 95.94736842105263 54.17624775834299