distribution_substations: 46

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
46 royton bsp 0 enw 
[
    "ebf05de1-bf40-4b79-9356-c258fce453e9"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "royton_132_gt1",
            "royton_132_gt2"
        ],
        "node_id_1": [
            "97f73b9e-58e9-4fc4-af28-0489e36b3b57",
            "6fb72319-1bbd-41b3-b53e-5dd1a4db4d8f"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "royton_33_gt1",
            "royton_33_gt2"
        ],
        "node_id_2": [
            "905b5bb8-66aa-4554-91a6-dd3a2cc3a147",
            "af604465-5290-4ba6-97c1-a3aba4523669"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 27.05263157894737,
        "accepted_import": 6.0,
        "project_id": [
            "enw__ecr_project_72",
            "enw__ecr_project_308"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 32.46750098673368,
        "firm_capacity": 68.5872,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 41.534568421052626,
        "local_dem_headroom": 30.119699013266313
    }
]
 enw_bsp_royton 53.56464 -2.11572 300009 0 0 0 0 
[]
 41.534568421052626 30.119699013266313