distribution_substations: 32

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
32 longsight bsp 0 enw 
[
    "c032b94e-7a5a-4a15-ac4e-a687617b2f81"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "longsi_132_gt2",
            "longsi_132_gt1"
        ],
        "node_id_1": [
            "84aa5ab2-c5a1-4278-9757-5b46d5908d05",
            "6dd01a67-8db5-4499-9b20-576424b7a777"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "longsi_33_gt2",
            "longsi_33_gt1"
        ],
        "node_id_2": [
            "2ebae950-0d20-44ef-a70e-6728642fc1c4",
            "32d16ca9-8a37-455a-a0e0-f7edee1a5228"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 6.72,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_142",
            "enw__ecr_project_52",
            "enw__ecr_project_361"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 76.17073599361304,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 110.28,
        "local_dem_headroom": 40.829264006386964
    }
]
 enw_bsp_longsight 53.46086 -2.21901 100004 0 0 enw_gsp_bredbury 305953 
[]
 110.28 40.829264006386964