distribution_substations: 56

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
56 trimpell bsp 0 enw 
[
    "320f473d-c05e-48fb-a2be-368871fedb63"
]
 
[
    11.0,
    132.0
]
 
[
    {
        "node_1": [
            "trimpe_132_gt2",
            "trimpe_132_gt1"
        ],
        "node_id_1": [
            "1f72ac82-e112-4586-958f-99ca1671d1bb",
            "847bfd03-deb2-4ac5-8059-8409efef26af"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "trimpe_11_gt2",
            "trimpe_11_gt1"
        ],
        "node_id_2": [
            "cf1e5c82-1902-426f-a6c7-6c0fb0f69631",
            "df576e30-1fa3-49a9-84ec-242ad5a85902"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            56.25,
            56.25
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 3.8474942976406115,
        "firm_capacity": 23.815,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 23.815,
        "local_dem_headroom": 19.96750570235939
    }
]
 enw_bsp_trimpell 54.01945 -2.89654 609918 0 0 enw_gsp_heysham 609900 
[]
 23.815 19.96750570235939