home / primary / substation_types

substation_types: 77

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
77 epping new rd primary lpn ukpn
[
    "3bd49092-8b7c-4974-83ac-fe034f28318c"
]
[
    11.0,
    33.0
]
[
    {
        "transformer_name": "ft1",
        "transformer_id": "632b1fbd-c836-4f69-9b84-09e93fb91e21",
        "node_1": "eppn32",
        "node_id_1": "0aec33a9-77e6-4121-ae6c-efe66d937424",
        "voltage_1": 33.0,
        "node_2": "eppn51 u bb1(1)",
        "node_id_2": "6362f594-a61f-422b-b580-ec07e8abae2e",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "bsp_group_id": "3bd49092-8b7c-4974-83ac-fe034f28318c",
        "bsp_group_name": "epping new rd",
        "substation_id": "3bd49092-8b7c-4974-83ac-fe034f28318c",
        "substation_name": "epping new rd"
    },
    {
        "transformer_name": "ft3",
        "transformer_id": "70db118a-bcf8-4a5c-aaaa-3e592f24f0e9",
        "node_1": "eppn31",
        "node_id_1": "27afa1bf-2085-4d93-8fc9-e2800d4d8289",
        "voltage_1": 33.0,
        "node_2": "eppn51 u bb2(1)",
        "node_id_2": "0bfa6369-29c0-41b8-870f-b0ec384428c2",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "bsp_group_id": "3bd49092-8b7c-4974-83ac-fe034f28318c",
        "bsp_group_name": "epping new rd",
        "substation_id": "3bd49092-8b7c-4974-83ac-fe034f28318c",
        "substation_name": "epping new rd"
    },
    {
        "transformer_name": "ft4",
        "transformer_id": "8660461d-7674-4fd9-b400-744db9829f1d",
        "node_1": "eppn33",
        "node_id_1": "823a3769-6f4b-4ef2-afaa-2d9a0a89e035",
        "voltage_1": 33.0,
        "node_2": "eppn52 l bb2(1)",
        "node_id_2": "8d605949-1933-4520-8893-85fd359fb0f1",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "bsp_group_id": "3bd49092-8b7c-4974-83ac-fe034f28318c",
        "bsp_group_name": "epping new rd",
        "substation_id": "3bd49092-8b7c-4974-83ac-fe034f28318c",
        "substation_name": "epping new rd"
    },
    {
        "transformer_name": "ft2",
        "transformer_id": "e2b4adf7-4508-4774-89e1-43aebbdca868",
        "node_1": "eppn34",
        "node_id_1": "3dd47ff8-fefc-4482-8f43-7bb91d7c943c",
        "voltage_1": 33.0,
        "node_2": "eppn52 l bb1(1)",
        "node_id_2": "37045d63-c8b5-41b7-a69d-81cad1bcbf35",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "bsp_group_id": "3bd49092-8b7c-4974-83ac-fe034f28318c",
        "bsp_group_name": "epping new rd",
        "substation_id": "3bd49092-8b7c-4974-83ac-fe034f28318c",
        "substation_name": "epping new rd"
    }
]
ukpn_lpn_primary_epping_new_rd 51.6271376055075 0.029948701308337 lpn-s000000000523
Powered by Datasette · Queries took 9.324ms