distribution_substations: 31

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
31 leyland bsp 0 enw 
[
    "34db85e9-5219-4a8a-9678-e666538f676b"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "leylan_132_gt1",
            "leylan_132_gt2"
        ],
        "node_id_1": [
            "baf5e28d-5149-4a50-97e3-df2dc7eb442d",
            "0f52fd7e-3351-4f1a-958d-31bf97b14b87"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "leylan_33_gt1",
            "leylan_33_gt2"
        ],
        "node_id_2": [
            "4d472275-3a2f-438d-ae61-b4ae50377eeb",
            "42593eeb-5057-40a1-8591-e7b629ab3a29"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            116.1,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 11.8,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_301",
            "enw__ecr_project_211",
            "enw__ecr_project_29",
            "enw__ecr_project_545"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 82.09933426853928,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 105.2,
        "local_dem_headroom": 34.90066573146072
    }
]
 enw_bsp_leyland 53.70478 -2.69663 401212 0 0 enw_gsp_penwortham_east_rochdale 400240 
[]
 105.2 34.90066573146072