home / master_data / distribution_substations

distribution_substations: 85

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
85 barbara primary 0 enw
[
    "3b435e0f-707f-423a-aae9-67bcb4ad0511"
]
[
    6.6,
    33.0
]
[
    {
        "node_1": [
            "barbar_33_t12",
            "barbar_33_t11"
        ],
        "node_id_1": [
            "51bd3c2e-dd02-4313-8084-853c63cd69d6",
            "2bb72cf4-3861-4139-8fa1-6779745cbff0"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "barbar_33_t12barbar_6.6_bto_icn",
            "barbar_33_t11barbar_6.6_ato_icn"
        ],
        "node_id_2": [
            "d7ca39e6-66d1-438c-8e19-0f194316c882",
            "45270555-4e94-4f46-911a-ff92e483545a"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            17.5,
            17.5
        ],
        "eme_rating": [],
        "transformer_count": 2,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 13.043566886312167,
        "firm_capacity": 15.6,
        "spare": [
            false,
            false
        ],
        "local_gen_headroom": 15.6,
        "local_dem_headroom": 2.5564331136878327
    }
]
enw_primary_barbara 53.56417 -2.44396 200104 enw_bsp_bolton 200111 enw_gsp_kearsley 200220
[]
15.6 2.5564331136878327
Powered by Datasette · Queries took 2.584ms