distribution_substations: 44

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
44 rochdale central bsp 0 enw 
[
    "20cf26ad-091a-43e4-a2ed-dec637ef9d81"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "danest_132_broccen_33_gt2from_icn",
            "danest_132_aroccen_33_gt1from_icn"
        ],
        "node_id_1": [
            "33046b34-6bb3-416a-b853-03f54a0d58e9",
            "bd362a65-f958-45d6-b3ba-7ce41062bbcc"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "roccen_33_gt2",
            "roccen_33_gt1"
        ],
        "node_id_2": [
            "075ddec8-94ed-4099-a9c3-c981367f8029",
            "39d4c1bf-ec9c-44e6-bc2d-e79e47c8b684"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            78.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 99.9,
        "accepted_import": 79.9,
        "project_id": [
            "enw__ecr_project_541",
            "enw__ecr_project_558",
            "enw__ecr_project_561"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 29.827996885851448,
        "firm_capacity": 78.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": -21.900000000000006,
        "local_dem_headroom": -31.727996885851454
    }
]
 enw_bsp_rochdale_central 53.61653 -2.16602 304882 0 0 0 0 
[]
 -21.900000000000006 -31.727996885851454