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 |