home / primary / substation_types

substation_types: 92

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
92 hackney bsp lpn ukpn
[
    "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a"
]
[
    66.0,
    132.0
]
[
    {
        "transformer_name": "gt1b",
        "transformer_id": "378bbc3a-ada6-4108-bf3f-7c63c810017f",
        "node_1": "hack1a",
        "node_id_1": "9ee1ecfb-01ac-4b8a-a209-1ab33eddd8d6",
        "voltage_1": 132.0,
        "node_2": "hacg61 b bb1(2)",
        "node_id_2": "33022ee7-23ec-4314-a4d8-4da02b8466b0",
        "voltage_2": 66.0,
        "nom_rating": 60.0,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "substation_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "substation_name": "hackney supergrid"
    },
    {
        "transformer_name": "gt2a",
        "transformer_id": "90020124-b5c5-4a38-a49a-8e244f0abda7",
        "node_1": "hack1b",
        "node_id_1": "2735db4c-2448-46a0-8073-d7bd0b4de2d1",
        "voltage_1": 132.0,
        "node_2": "hacg61 b bb1(3)",
        "node_id_2": "77882d0b-1358-4357-8e5b-5b1a2291bb7c",
        "voltage_2": 66.0,
        "nom_rating": 60.0,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "substation_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "substation_name": "hackney supergrid"
    },
    {
        "transformer_name": "gt2b",
        "transformer_id": "bde42c33-2334-4cbf-9182-d52ff80a6818",
        "node_1": "hack1d",
        "node_id_1": "4fd2e974-bbba-46b2-92c3-c1a718092c71",
        "voltage_1": 132.0,
        "node_2": "hacg61 b bb2(6)",
        "node_id_2": "fa04ea7b-9d17-4be5-bfab-8269c8e64a62",
        "voltage_2": 66.0,
        "nom_rating": 60.0,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "substation_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "substation_name": "hackney supergrid"
    },
    {
        "transformer_name": "gt1a",
        "transformer_id": "e084a19e-699f-4621-88cd-5c0f2035f761",
        "node_1": "hack1c",
        "node_id_1": "fcc4240a-3a4b-4308-9330-3587a5b96d77",
        "voltage_1": 132.0,
        "node_2": "hacg61 b bb2(2)",
        "node_id_2": "0c26ad0e-44cd-41a1-b5b4-0b6086bfdbba",
        "voltage_2": 66.0,
        "nom_rating": 60.0,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "substation_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "substation_name": "hackney supergrid"
    }
]
ukpn_lpn_bsp_hackney 51.558880955487 -0.0423838561875229 lpn-s000000003436
Powered by Datasette · Queries took 13.814ms