home / primary / substation_types

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
Powered by Datasette · Queries took 6.04ms