distribution_substations: 17

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
17 castleton bsp 0 enw 
[
    "c9697d5b-c272-492d-81df-29db4c00bf94"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "node_1": [
            "castle_132_bcastle_33_gt2from_icn",
            "castle_132_acastle_33_gt1from_icn"
        ],
        "node_id_1": [
            "545dec48-6b96-408d-b4fa-a5cbc30c4f43",
            "333bd0d9-555d-4c0c-84e9-04310f88f8e5"
        ],
        "voltage_node_1": 132.0,
        "node_2": [
            "castle_33_gt2",
            "castle_33_gt1"
        ],
        "node_id_2": [
            "4a99e915-8ab3-49a7-a6b4-dbd596ba3bd4",
            "52e8d8b1-65ad-425d-9a5a-fd97c78fd9a8"
        ],
        "voltage_node_2": 33.0,
        "nom_rating": [
            117.0,
            117.0
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 69.05263157894737,
        "accepted_import": 35.0,
        "project_id": [
            "enw__ecr_project_122",
            "enw__ecr_project_434",
            "enw__ecr_project_417",
            "enw__ecr_project_327",
            "enw__ecr_project_489"
        ],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 46.83476755168031,
        "firm_capacity": 117.0,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 47.94736842105263,
        "local_dem_headroom": 35.1652324483197
    }
]
 enw_bsp_castleton 53.59783 -2.17663 304881 0 0 0 0 
[]
 47.94736842105263 35.1652324483197