distribution_substations: 9
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9 | blackpool | bsp | 0 | enw | [
"d9fa6c43-c518-40b6-b807-00b1c69c473b"
] |
[
33.0,
132.0
] |
[
{
"node_1": [
"blackp_132_gt1",
"blackp_132_gt2"
],
"node_id_1": [
"28e36806-f0ee-4941-8bb1-80b8d2cd5868",
"421c5366-3611-41ec-a88f-52b78632b564"
],
"voltage_node_1": 132.0,
"node_2": [
"blackp_33_gt1",
"blackp_33_gt2"
],
"node_id_2": [
"55daceed-8ec2-4e7e-b673-c2ee1ec5542a",
"5feaff9b-f366-4577-9829-d85590573c58"
],
"voltage_node_2": 33.0,
"nom_rating": [
117.0,
117.0
],
"eme_rating": [],
"transformer_count": 2,
"accepted_export": 0,
"accepted_import": 0,
"project_id": [],
"min_transformer_flow": 0.0,
"max_transformer_flow": 67.49934345196115,
"firm_capacity": 117.0,
"spare": [
false,
false
],
"local_gen_headroom": 117.0,
"local_dem_headroom": 49.50065654803885
}
] |
enw_bsp_blackpool | 53.80944 | -3.05179 | 400113 | 0 | 0 | enw_gsp_penwortham_east_rochdale | 400240 | [] |
117.0 | 49.50065654803885 |