substation_types: 59
This data as json
| rowid | location | type | licence | source | substation_ids | voltages | transformers | substation_type_id | latitude | longitude | source_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 59 | clapham park rd | primary | lpn | ukpn | [
"50ecdaf8-be78-4a05-9b0e-f913e3d1b21f"
] |
[
11.0,
33.0
] |
[
{
"transformer_name": "t2",
"transformer_id": "038ef167-89f1-4e12-93fd-2a2d23a4ed43",
"node_1": "clap32",
"node_id_1": "c1d943d0-cce6-4ded-be18-4f618f740735",
"voltage_1": 33.0,
"node_2": "clap51 f bb1(1)",
"node_id_2": "de674ebc-1f70-418b-b20d-bc7a3ef7c730",
"voltage_2": 11.0,
"nom_rating": 15.0,
"gsp_group_id": "2b412ddc-3e42-4f14-b7a4-a07701540790",
"gsp_group_name": "20 - wimbledon 1&2 132kv gsp",
"bsp_group_id": "50ecdaf8-be78-4a05-9b0e-f913e3d1b21f",
"bsp_group_name": "clapham park rd",
"substation_id": "50ecdaf8-be78-4a05-9b0e-f913e3d1b21f",
"substation_name": "clapham park rd"
},
{
"transformer_name": "t4",
"transformer_id": "7b3f7337-4f2c-4b2c-aba6-4fc318b8e00b",
"node_1": "clap34",
"node_id_1": "26982552-8070-4494-92fc-c1b38196cfe0",
"voltage_1": 33.0,
"node_2": "clap51 f bb2(1)",
"node_id_2": "f764d09a-39e5-494a-960b-15dcb8e02f14",
"voltage_2": 11.0,
"nom_rating": 15.0,
"gsp_group_id": "2b412ddc-3e42-4f14-b7a4-a07701540790",
"gsp_group_name": "20 - wimbledon 1&2 132kv gsp",
"bsp_group_id": "50ecdaf8-be78-4a05-9b0e-f913e3d1b21f",
"bsp_group_name": "clapham park rd",
"substation_id": "50ecdaf8-be78-4a05-9b0e-f913e3d1b21f",
"substation_name": "clapham park rd"
},
{
"transformer_name": "t1",
"transformer_id": "a4b03358-1d38-42c9-8a34-674fd89de3e9",
"node_1": "clap31",
"node_id_1": "0023baad-f3cc-4238-a853-030fb9214a1c",
"voltage_1": 33.0,
"node_2": "clap5a",
"node_id_2": "1c3ad48b-2412-4dd3-92c5-a84d2abd0301",
"voltage_2": 11.0,
"nom_rating": 15.0,
"gsp_group_id": "2b412ddc-3e42-4f14-b7a4-a07701540790",
"gsp_group_name": "20 - wimbledon 1&2 132kv gsp",
"bsp_group_id": "50ecdaf8-be78-4a05-9b0e-f913e3d1b21f",
"bsp_group_name": "clapham park rd",
"substation_id": "50ecdaf8-be78-4a05-9b0e-f913e3d1b21f",
"substation_name": "clapham park rd"
},
{
"transformer_name": "t3",
"transformer_id": "b597a285-2393-41ed-89a7-c0d0c4c94869",
"node_1": "clap33",
"node_id_1": "395a462f-a082-4b1b-ac13-35a734613aa6",
"voltage_1": 33.0,
"node_2": "clap52 r bb2(1)",
"node_id_2": "14234e2a-4366-4127-b349-10cf78a46b74",
"voltage_2": 11.0,
"nom_rating": 15.0,
"gsp_group_id": "2b412ddc-3e42-4f14-b7a4-a07701540790",
"gsp_group_name": "20 - wimbledon 1&2 132kv gsp",
"bsp_group_id": "50ecdaf8-be78-4a05-9b0e-f913e3d1b21f",
"bsp_group_name": "clapham park rd",
"substation_id": "50ecdaf8-be78-4a05-9b0e-f913e3d1b21f",
"substation_name": "clapham park rd"
}
] |
ukpn_lpn_primary_clapham_park_rd | 51.4615405357285 | -0.13648290441052 | lpn-s000000000914 |