distribution_substations: 53
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53 | stretford | bsp | 0 | enw | [
"e158449d-e42b-4239-91ae-e547382e2f54"
] |
[
33.0,
132.0
] |
[
{
"node_1": [
"stretf_132_gt2",
"stretf_132_gt1"
],
"node_id_1": [
"4307186c-1427-4694-8a5f-f2c4f89f41a2",
"8f5c2cb2-926e-4413-9af6-ad8c07ad8973"
],
"voltage_node_1": 132.0,
"node_2": [
"stretf_33_gt2",
"stretf_33_gt1"
],
"node_id_2": [
"12abc110-168b-48b4-a764-f615a460709c",
"c9c89af3-8a52-42bf-9118-1622477c3e22"
],
"voltage_node_2": 33.0,
"nom_rating": [
117.0,
117.0
],
"eme_rating": [],
"transformer_count": 2,
"accepted_export": 3.0,
"accepted_import": 3.0,
"project_id": [
"enw__ecr_project_322"
],
"min_transformer_flow": 0.0,
"max_transformer_flow": 64.27280998085104,
"firm_capacity": 103.5,
"spare": [
false,
false
],
"local_gen_headroom": 100.5,
"local_dem_headroom": 36.22719001914896
}
] |
enw_bsp_stretford | 53.4523 | -2.30113 | 100505 | 0 | 0 | enw_gsp_south_manchester | 100091 | [] |
100.5 | 36.22719001914896 |