distribution_substations: 15

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
15 carlisle bsp 0 enw 
[
    "fb2410d4-9591-48d5-82f8-490942b0f19b"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "carlis_132_gt1",
            "carlis_132_gt2",
            "carlis_132_gt3"
        ],
        "node_id_1": [
            "a018c591-24de-42bb-8d13-8a34bf7a7e68",
            "acf72f55-4e43-46bd-b8cf-a62ee3255f5d",
            "38c8207e-2527-4810-8884-c0103c605508"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "carlis_33_gt1",
            "carlis_33_gt2",
            "carlis_33_gt3"
        ],
        "node_id_2": [
            "72458558-ba66-4ce8-8fd3-61cbf0ab2b00",
            "d6cf43fc-9e4f-4723-a03f-6feb9735656e",
            "9a20cda6-3082-474f-82c9-05f7b5f523cf"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            60.0,
            78.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 99.00526315789475,
        "accepted_import": 0.0,
        "project_id": [
            "enw__ecr_project_144",
            "enw__ecr_project_252",
            "enw__ecr_project_307",
            "enw__ecr_project_333"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 128.8930402981027,
        "firm_capacity": 174.5,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 75.49473684210525,
        "local_dem_headroom": 45.606959701897296
    }
]
 enw_bsp_carlisle 54.8993 -2.9589 609609 0 0 enw_gsp_harker_hutton 609600 
[]
 75.49473684210525 45.606959701897296