distribution_substations: 83

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
83 baguley primary 0 enw 
[
    "b62ada92-d6a6-4b5f-b60a-ba7e081f83dd"
]
 
[
    11.0,
    33.0
]
 
[
    {
        "node_1": [
            "baguly_33_abaguly_11_afrom_icn",
            "baguly_33_bbaguly_11_bfrom_icn"
        ],
        "node_id_1": [
            "c13ffa68-94ef-4b92-9bc6-2472cb379723",
            "1bdf8540-1d09-40fd-aeb9-7fa5430f35e1"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "baguly_33_abaguly_11_ato_icn",
            "baguly_33_bbaguly_11_bto_icn"
        ],
        "node_id_2": [
            "397fc55b-e398-45a0-897f-c3c1cbfe8e89",
            "868e98db-afd8-4bba-9b71-71b0f3de83af"
        ],
        "voltage_node_2": 11.0,
        "nom_rating": [
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 1.3157894736842106,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_2"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 15.134982242590228,
        "firm_capacity": 22.863,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 21.547210526315787,
        "local_dem_headroom": 7.728017757409772
    }
]
 enw_primary_baguley 53.39757 -2.2937 100103 0 0 0 100092 
[]
 21.547210526315787 7.728017757409772