distribution_substations: 94
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94 | blackburn | primary | 0 | enw | [
"ccaff536-eba3-4316-bdd4-066d1e83e16e"
] |
[
6.6,
33.0
] |
[
{
"node_1": [
"blackb_33_ablackb_6.6_afrom_icn",
"samlzo_33_te2"
],
"node_id_1": [
"169641ef-4644-452b-af1f-cfd00ee5708c",
"4d358162-e130-4df1-899b-31392de81462"
],
"voltage_node_1": 33.0,
"node_2": [
"blackb_33_ablackb_6.6_ato_icn",
"samlzo_33_te2blackb_6.6_bto_icn"
],
"node_id_2": [
"90cb7897-5231-4dfd-a873-eea49350e329",
"052e58f6-7506-4e48-94da-b57e95c4dbff"
],
"voltage_node_2": 6.6,
"nom_rating": [
32.0,
23.0
],
"eme_rating": [],
"transformer_count": 2,
"accepted_export": 0,
"accepted_import": 0,
"project_id": [],
"min_transformer_flow": 0.0,
"max_transformer_flow": 20.525160324014774,
"firm_capacity": 42.183,
"spare": [
false,
false
],
"local_gen_headroom": 42.183,
"local_dem_headroom": 21.657839675985226
}
] |
enw_primary_blackburn | 53.7592 | -2.44764 | 400001 | enw_bsp_blackburn | 400001 | 0 | 0 | [] |
42.183 | 21.657839675985226 |