substation_types: 92
This data as json
| rowid | location | type | licence | source | substation_ids | voltages | transformers | substation_type_id | latitude | longitude | source_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 92 | hackney | bsp | lpn | ukpn | [
"fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a"
] |
[
66.0,
132.0
] |
[
{
"transformer_name": "gt1b",
"transformer_id": "378bbc3a-ada6-4108-bf3f-7c63c810017f",
"node_1": "hack1a",
"node_id_1": "9ee1ecfb-01ac-4b8a-a209-1ab33eddd8d6",
"voltage_1": 132.0,
"node_2": "hacg61 b bb1(2)",
"node_id_2": "33022ee7-23ec-4314-a4d8-4da02b8466b0",
"voltage_2": 66.0,
"nom_rating": 60.0,
"gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
"gsp_group_name": "08 - hackney 132kv gsp",
"substation_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
"substation_name": "hackney supergrid"
},
{
"transformer_name": "gt2a",
"transformer_id": "90020124-b5c5-4a38-a49a-8e244f0abda7",
"node_1": "hack1b",
"node_id_1": "2735db4c-2448-46a0-8073-d7bd0b4de2d1",
"voltage_1": 132.0,
"node_2": "hacg61 b bb1(3)",
"node_id_2": "77882d0b-1358-4357-8e5b-5b1a2291bb7c",
"voltage_2": 66.0,
"nom_rating": 60.0,
"gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
"gsp_group_name": "08 - hackney 132kv gsp",
"substation_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
"substation_name": "hackney supergrid"
},
{
"transformer_name": "gt2b",
"transformer_id": "bde42c33-2334-4cbf-9182-d52ff80a6818",
"node_1": "hack1d",
"node_id_1": "4fd2e974-bbba-46b2-92c3-c1a718092c71",
"voltage_1": 132.0,
"node_2": "hacg61 b bb2(6)",
"node_id_2": "fa04ea7b-9d17-4be5-bfab-8269c8e64a62",
"voltage_2": 66.0,
"nom_rating": 60.0,
"gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
"gsp_group_name": "08 - hackney 132kv gsp",
"substation_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
"substation_name": "hackney supergrid"
},
{
"transformer_name": "gt1a",
"transformer_id": "e084a19e-699f-4621-88cd-5c0f2035f761",
"node_1": "hack1c",
"node_id_1": "fcc4240a-3a4b-4308-9330-3587a5b96d77",
"voltage_1": 132.0,
"node_2": "hacg61 b bb2(2)",
"node_id_2": "0c26ad0e-44cd-41a1-b5b4-0b6086bfdbba",
"voltage_2": 66.0,
"nom_rating": 60.0,
"gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
"gsp_group_name": "08 - hackney 132kv gsp",
"substation_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
"substation_name": "hackney supergrid"
}
] |
ukpn_lpn_bsp_hackney | 51.558880955487 | -0.0423838561875229 | lpn-s000000003436 |