distribution_substations: 37

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
37 orrell bsp 0 enw 
[
    "09c68e05-57f1-47ad-a911-39008900100a",
    "dbd8eb02-7744-47e0-b00a-36cab2ccd9ff"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "orrell_132_gt1",
            "orrell_132_gt2"
        ],
        "node_id_1": [
            "0f8571fd-e25f-4da3-bdd0-5bee19ea82f1",
            "a5cc9e9b-d55b-4e4b-a4ad-edf86d1f1662"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "orrell_33_gt1",
            "orrell_33_gt2"
        ],
        "node_id_2": [
            "22fcf270-6370-4dc2-8dc7-75670b18dcfa",
            "2b68b6ec-2ca5-4d51-b0e8-ab0d6e6d6583"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 70.0,
        "accepted_import": 70.0,
        "project_id": [
            "enw__ecr_project_511",
            "enw__ecr_project_539"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 43.50155036566105,
        "firm_capacity": 78.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 8.0,
        "local_dem_headroom": -35.50155036566105
    }
]
 enw_bsp_orrell 53.5356 -2.71374 200430 0 0 enw_gsp_washway_farm 200419 
[]
 8.0 -35.50155036566105