home / primary / substation_types

substation_types: 56

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
56 chislehurst primary lpn ukpn
[
    "307819ee-cf77-4f39-bfca-82247f007630"
]
[
    11.0,
    33.0
]
[
    {
        "transformer_name": "t2",
        "transformer_id": "149bcfb3-56e8-4a4c-b251-542862bd5e19",
        "node_1": "chsl34",
        "node_id_1": "609e3e2e-414e-4517-8a1b-a1e275a9e012",
        "voltage_1": 33.0,
        "node_2": "chsl51 l bb1(1)",
        "node_id_2": "64c03a3e-b6f0-4821-b144-a97353ca8aaf",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "307819ee-cf77-4f39-bfca-82247f007630",
        "bsp_group_name": "chislehurst",
        "substation_id": "307819ee-cf77-4f39-bfca-82247f007630",
        "substation_name": "chislehurst"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "26806242-520f-43e1-946d-b57c28a79812",
        "node_1": "chsl31",
        "node_id_1": "df6ff2c1-67d9-4816-815b-a30bcf723cfa",
        "voltage_1": 33.0,
        "node_2": "chsl52 u bb2(1)",
        "node_id_2": "b938cfce-c9b2-467b-8902-474e07784ea8",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "307819ee-cf77-4f39-bfca-82247f007630",
        "bsp_group_name": "chislehurst",
        "substation_id": "307819ee-cf77-4f39-bfca-82247f007630",
        "substation_name": "chislehurst"
    },
    {
        "transformer_name": "t4",
        "transformer_id": "adbb3f79-298a-4b1f-9333-f75680ec4bfa",
        "node_1": "chsl32",
        "node_id_1": "68edc124-203e-4bcf-8690-2132cd6b0196",
        "voltage_1": 33.0,
        "node_2": "chsl52 l bb2(1)",
        "node_id_2": "423ea607-886a-4edf-afca-0ae31faea810",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "307819ee-cf77-4f39-bfca-82247f007630",
        "bsp_group_name": "chislehurst",
        "substation_id": "307819ee-cf77-4f39-bfca-82247f007630",
        "substation_name": "chislehurst"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "e522012e-e725-445f-b3e7-eed5fa2cfdde",
        "node_1": "chsl33",
        "node_id_1": "7427c45f-5e72-4bb3-a0d0-7439a55033f9",
        "voltage_1": 33.0,
        "node_2": "chsl51 u bb1(1)",
        "node_id_2": "e4f61f1a-7ae7-4c34-926d-672f6b752b64",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "307819ee-cf77-4f39-bfca-82247f007630",
        "bsp_group_name": "chislehurst",
        "substation_id": "307819ee-cf77-4f39-bfca-82247f007630",
        "substation_name": "chislehurst"
    }
]
ukpn_lpn_primary_chislehurst 51.4224843258183 0.0581639046629971 lpn-s000000000816
Powered by Datasette · Queries took 5.816ms