substation_types: 73
This data as json
| rowid | location | type | licence | source | substation_ids | voltages | transformers | substation_type_id | latitude | longitude | source_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 73 | edwards lane | primary | lpn | ukpn | [
"ed0c721e-b323-409f-b878-e65c09d3ab07"
] |
[
11.275,
66.0
] |
[
{
"transformer_name": "gt2c",
"transformer_id": "2457e87d-eb9c-428f-9ef1-5e1a0add9ddd",
"node_1": "edlc61",
"node_id_1": "76422537-1f11-45d4-8da4-9086266f6fe0",
"voltage_1": 66.0,
"node_2": "edlc5a",
"node_id_2": "04a11ad7-fe90-4ce8-9d42-98d9c8ce2aa1",
"voltage_2": 11.275,
"nom_rating": 33.3,
"gsp_group_id": "0ba3e841-136b-410e-ae93-f99f8908a949",
"gsp_group_name": "07 - hackney 66kv gsp",
"bsp_group_id": "ed0c721e-b323-409f-b878-e65c09d3ab07",
"bsp_group_name": "edwards lane",
"substation_id": "ed0c721e-b323-409f-b878-e65c09d3ab07",
"substation_name": "edwards lane"
},
{
"transformer_name": "gt3c",
"transformer_id": "44e5f62e-c622-485b-82d0-49a9cd2943f6",
"node_1": "edlc62",
"node_id_1": "b955b17c-eee5-4b0f-b5e2-e0384231a1c4",
"voltage_1": 66.0,
"node_2": "edlc5b",
"node_id_2": "a9392580-162d-4663-b5cd-20b8ef8ee12f",
"voltage_2": 11.275,
"nom_rating": 33.3,
"gsp_group_id": "0ba3e841-136b-410e-ae93-f99f8908a949",
"gsp_group_name": "07 - hackney 66kv gsp",
"bsp_group_id": "ed0c721e-b323-409f-b878-e65c09d3ab07",
"bsp_group_name": "edwards lane",
"substation_id": "ed0c721e-b323-409f-b878-e65c09d3ab07",
"substation_name": "edwards lane"
},
{
"transformer_name": "ft2a",
"transformer_id": "6072bd73-aafa-4a12-8a73-751bc4bc4979",
"node_1": "edlc65",
"node_id_1": "3b0f4bde-dc21-4564-810b-8628309b9dab",
"voltage_1": 66.0,
"node_2": "edlc5e",
"node_id_2": "e016289d-7e46-4ac1-bf73-c2bcb55bb08f",
"voltage_2": 11.275,
"nom_rating": 15.0,
"gsp_group_id": "0ba3e841-136b-410e-ae93-f99f8908a949",
"gsp_group_name": "07 - hackney 66kv gsp",
"bsp_group_id": "ed0c721e-b323-409f-b878-e65c09d3ab07",
"bsp_group_name": "edwards lane",
"substation_id": "ed0c721e-b323-409f-b878-e65c09d3ab07",
"substation_name": "edwards lane"
},
{
"transformer_name": "ft1a",
"transformer_id": "9975f1e4-9edb-4bde-b56c-d9f05fa74909",
"node_1": "edlc64",
"node_id_1": "2a49a2e3-c21b-4555-9fef-316e2967ff42",
"voltage_1": 66.0,
"node_2": "edlc5d",
"node_id_2": "8f0fe20f-3e2e-4c41-a6db-40f76764a230",
"voltage_2": 11.275,
"nom_rating": 15.0,
"gsp_group_id": "0ba3e841-136b-410e-ae93-f99f8908a949",
"gsp_group_name": "07 - hackney 66kv gsp",
"bsp_group_id": "ed0c721e-b323-409f-b878-e65c09d3ab07",
"bsp_group_name": "edwards lane",
"substation_id": "ed0c721e-b323-409f-b878-e65c09d3ab07",
"substation_name": "edwards lane"
},
{
"transformer_name": "ft4a",
"transformer_id": "ac3fa484-23ac-4098-b0b2-a13f6022f729",
"node_1": "edlc63",
"node_id_1": "f766c874-f5e6-4d45-95e3-d8491aac2095",
"voltage_1": 66.0,
"node_2": "edlc5c",
"node_id_2": "12da4750-88ec-4835-8d2d-40e554a89d90",
"voltage_2": 11.275,
"nom_rating": 15.0,
"gsp_group_id": "0ba3e841-136b-410e-ae93-f99f8908a949",
"gsp_group_name": "07 - hackney 66kv gsp",
"bsp_group_id": "ed0c721e-b323-409f-b878-e65c09d3ab07",
"bsp_group_name": "edwards lane",
"substation_id": "ed0c721e-b323-409f-b878-e65c09d3ab07",
"substation_name": "edwards lane"
},
{
"transformer_name": "ft3a",
"transformer_id": "c2693971-07dd-40f7-8ffc-972aa63fea9b",
"node_1": "edlc66",
"node_id_1": "896cdbea-59e2-4d39-8f49-b1d276eca3e0",
"voltage_1": 66.0,
"node_2": "edlc5f",
"node_id_2": "262016ec-1f26-4e27-8144-8ee02eca22c8",
"voltage_2": 11.275,
"nom_rating": 15.0,
"gsp_group_id": "0ba3e841-136b-410e-ae93-f99f8908a949",
"gsp_group_name": "07 - hackney 66kv gsp",
"bsp_group_id": "ed0c721e-b323-409f-b878-e65c09d3ab07",
"bsp_group_name": "edwards lane",
"substation_id": "ed0c721e-b323-409f-b878-e65c09d3ab07",
"substation_name": "edwards lane"
}
] |
ukpn_lpn_primary_edwards_lane | 51.5620173159873 | -0.0831081429430271 | lpn-s000000000422 |