distribution_substations: 38

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
38 padiham bsp 0 enw 
[
    "45e25bb8-4427-44d8-bb22-4b3626116fc7"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "nelson_132_gt1",
            "nelson_132_gt2",
            "padiha_132_gt1",
            "padiha_132_gt2"
        ],
        "node_id_1": [
            "be1f866f-5669-438a-956e-0a6b32167552",
            "d1098472-6689-491f-8879-48d6755af141",
            "944dc6b8-aa31-49c1-8737-2b9a5948e50c",
            "8d5e54f6-9cab-4350-b981-3c8b353f7eb2"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "nelson_33_gt1",
            "nelson_33_gt2",
            "padiha_33_gt1",
            "padiha_33_gt2"
        ],
        "node_id_2": [
            "a62ad712-197a-421d-9478-dc7e05a42467",
            "508b9dd1-371d-456d-bc02-c1b595359339",
            "3df081c6-06e3-41a5-acc8-1e795edeff94",
            "c9339c57-300d-496a-90fa-4cc28b12364f"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            78.0,
            78.0,
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 4,
        "accepted_export": 20.0,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_174"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 72.25666983199581,
        "firm_capacity": 103.49999999999999,
        "spare": [
            false,
            false,
            false,
            false
        ],
        "local_gen_headroom": 83.49999999999999,
        "local_dem_headroom": 31.243330168004178
    }
]
 enw_bsp_padiham 53.79502 -2.32919 400071 0 0 0 0 
[]
 83.49999999999999 31.243330168004178