home / primary / substation_types

substation_types: 66

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
66 deptford west primary lpn ukpn
[
    "35e8afd6-54c3-4db6-b6b4-b47c5236a6a6"
]
[
    0.415,
    22.0
]
[
    {
        "transformer_name": "gt3_a",
        "transformer_id": "0620b8e5-7632-42eb-a469-c12f55543e94",
        "node_1": "depw82 f bb1(2)",
        "node_id_1": "d4fabcb9-1e7c-48d7-8bb6-c250022d6c86",
        "voltage_1": 22.0,
        "node_2": "terminal",
        "node_id_2": "aeaa78b2-e549-4ba0-b0b1-904e6acb2182",
        "voltage_2": 0.415,
        "nom_rating": 0.17,
        "gsp_group_id": "6f49c534-d05c-4831-b97f-72931e320ba1",
        "gsp_group_name": "13 - new cross 132kv gsp",
        "bsp_group_id": "35e8afd6-54c3-4db6-b6b4-b47c5236a6a6",
        "bsp_group_name": "deptford west",
        "substation_id": "35e8afd6-54c3-4db6-b6b4-b47c5236a6a6",
        "substation_name": "deptford west"
    },
    {
        "transformer_name": "gt5_a(1)",
        "transformer_id": "6aba0298-5096-4115-b1d1-186d61f05b9f",
        "node_1": "depw81",
        "node_id_1": "0b618877-2c44-4f75-867e-6a7303899129",
        "voltage_1": 22.0,
        "node_2": "terminal(1)",
        "node_id_2": "2057c7b9-30ee-46ac-8807-177482483e9e",
        "voltage_2": 0.415,
        "nom_rating": 0.17,
        "gsp_group_id": "6f49c534-d05c-4831-b97f-72931e320ba1",
        "gsp_group_name": "13 - new cross 132kv gsp",
        "bsp_group_id": "35e8afd6-54c3-4db6-b6b4-b47c5236a6a6",
        "bsp_group_name": "deptford west",
        "substation_id": "35e8afd6-54c3-4db6-b6b4-b47c5236a6a6",
        "substation_name": "deptford west"
    }
]
ukpn_lpn_primary_deptford_west 51.4837341488212 -0.0228184606791258 lpn-s000000003722
Powered by Datasette · Queries took 2.288ms