distribution_substations: 4

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
4 atherton bsp 0 enw 
[
    "23970efd-da72-48f7-859a-0a8c742af0f7"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "athert_132_gt1",
            "athert_132_gt2"
        ],
        "node_id_1": [
            "892c1a4b-49bf-4ea6-8a11-5b59544f67d2",
            "f843fd8d-4a5a-4376-9e90-87b8628f1220"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "athert_33_gt1",
            "athert_33_gt2"
        ],
        "node_id_2": [
            "0441ee9d-8fc0-444d-9eff-343265780848",
            "50565f6b-2935-44d7-90bf-82fba763095c"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0.0,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_318"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 80.10416455576268,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 117.0,
        "local_dem_headroom": 36.89583544423732
    }
]
 enw_bsp_atherton 53.51405 -2.51233 205317 0 0 enw_gsp_kearsley 200220 
[]
 117.0 36.89583544423732