distribution_substations: 11

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
11 bolton bsp 0 enw 
[
    "559d8135-7a7b-4aef-bf3f-69a26ebfbeff"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "bolton_132_gt1bolton_33_gt1from_icn",
            "bolton_132_gt3bolton_33_gt3from_icn",
            "bolton_132_gt4bolton_33_gt4from_icn"
        ],
        "node_id_1": [
            "5041c9ca-4fc7-4d55-947d-d6e005e90fd7",
            "708bab53-576f-4ef2-a67d-e74523fce7d9",
            "552fcdf8-3a1d-41c6-9251-a26f3fc9ae6b"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "bolton_33_gt1",
            "bolton_33_gt3",
            "bolton_33_gt4"
        ],
        "node_id_2": [
            "1f066130-f97d-46bf-86db-b7f5601942a3",
            "bfb5f62b-5532-4830-a19a-7c4b8017fea4",
            "098050e3-f4a9-4b80-ae0f-3f7f43f57ebc"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            75.0,
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 6.0,
        "accepted_import": 6.0,
        "project_id": [
            "enw__ecr_project_315"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 101.87117273350606,
        "firm_capacity": 124.0,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 118.0,
        "local_dem_headroom": 16.128827266493943
    }
]
 enw_bsp_bolton 53.59102 -2.42059 200111 0 0 enw_gsp_kearsley 200220 
[]
 118.0 16.128827266493943