distribution_substations: 75

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
75 ashton under lyne primary 0 enw 
[
    "a3bfecb6-e93f-4fb7-9d57-cd1202ba41a3"
]
 
[
    6.6,
    33.0
]
 
[
    {
        "node_1": [
            "ashunl_33_t13",
            "ashunl_33_t12",
            "ashunl_33_t11"
        ],
        "node_id_1": [
            "a060a11c-181c-46e1-ad7d-786f63d35322",
            "9d07d000-27ba-4f20-b12a-b6a69986bfc5",
            "c023664b-0847-452d-ae56-fb9abc1c3f72"
        ],
        "voltage_node_1": 33.0,
        "node_2": [
            "ashunl_33_t13ashunl_6.6_cto_icn",
            "ashunl_33_t12ashunl_6.6_bto_icn",
            "ashunl_33_t11ashunl_6.6_ato_icn"
        ],
        "node_id_2": [
            "f09809e6-eb08-4657-8eb1-f05fe7d2453a",
            "a666d0b1-d51e-40ea-bf49-4ecb3a194a30",
            "acd7fcf3-0d9c-45a7-b05d-b9b1de9b671c"
        ],
        "voltage_node_2": 6.6,
        "nom_rating": [
            23.0,
            23.0,
            23.0
        ],
        "eme_rating": [],
        "transformer_count": 3,
        "accepted_export": 0,
        "accepted_import": 0,
        "project_id": [],
        "min_transformer_flow": 0.0,
        "max_transformer_flow": 21.57876572645956,
        "firm_capacity": 36.113,
        "spare": [
            false,
            false,
            false
        ],
        "local_gen_headroom": 36.113,
        "local_dem_headroom": 14.534234273540438
    }
]
 enw_primary_ashton_under_lyne 53.49047 -2.10269 307115 enw_bsp_heyrod 304200 0 0 
[]
 36.113 14.534234273540438