home / primary / substation_types

substation_types: 38

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
38 blackhorse lane primary lpn ukpn
[
    "8dca3a72-dc4c-4e51-a98d-4fea1f5b4c88"
]
[
    11.275,
    66.0
]
[
    {
        "transformer_name": "t1",
        "transformer_id": "32c9cbbe-b4f6-4f12-a44e-0c9f253e13bb",
        "node_1": "blhl61",
        "node_id_1": "604137a0-c178-4762-b78d-56b9e40fdadd",
        "voltage_1": 66.0,
        "node_2": "blhl51 r bb1(1)",
        "node_id_2": "6f35db83-ca7f-4f63-a227-1b09b34e198a",
        "voltage_2": 11.275,
        "nom_rating": 15.0,
        "gsp_group_id": "0ba3e841-136b-410e-ae93-f99f8908a949",
        "gsp_group_name": "07 - hackney 66kv gsp",
        "bsp_group_id": "8dca3a72-dc4c-4e51-a98d-4fea1f5b4c88",
        "bsp_group_name": "blackhorse lane",
        "substation_id": "8dca3a72-dc4c-4e51-a98d-4fea1f5b4c88",
        "substation_name": "blackhorse lane"
    },
    {
        "transformer_name": "t2",
        "transformer_id": "3aaf0452-7e87-4660-88db-e6e714ba338b",
        "node_1": "blhl62",
        "node_id_1": "7858074f-3faa-4e14-9f62-d04f20d1c046",
        "voltage_1": 66.0,
        "node_2": "blhl51 f bb1(1)",
        "node_id_2": "42cfda98-aa32-4a1f-a324-db3b2d910aec",
        "voltage_2": 11.275,
        "nom_rating": 15.0,
        "gsp_group_id": "0ba3e841-136b-410e-ae93-f99f8908a949",
        "gsp_group_name": "07 - hackney 66kv gsp",
        "bsp_group_id": "8dca3a72-dc4c-4e51-a98d-4fea1f5b4c88",
        "bsp_group_name": "blackhorse lane",
        "substation_id": "8dca3a72-dc4c-4e51-a98d-4fea1f5b4c88",
        "substation_name": "blackhorse lane"
    },
    {
        "transformer_name": "t4",
        "transformer_id": "e2b0ab1f-1af7-4460-8c6d-7aa5811a8e68",
        "node_1": "blhl63",
        "node_id_1": "b0d3920c-5da5-4907-beab-a9b3fa249962",
        "voltage_1": 66.0,
        "node_2": "blhl51 f bb2(1)",
        "node_id_2": "fe6bd1c6-72af-4fa0-aed9-b031665dcf06",
        "voltage_2": 11.275,
        "nom_rating": 15.0,
        "gsp_group_id": "0ba3e841-136b-410e-ae93-f99f8908a949",
        "gsp_group_name": "07 - hackney 66kv gsp",
        "bsp_group_id": "8dca3a72-dc4c-4e51-a98d-4fea1f5b4c88",
        "bsp_group_name": "blackhorse lane",
        "substation_id": "8dca3a72-dc4c-4e51-a98d-4fea1f5b4c88",
        "substation_name": "blackhorse lane"
    }
]
ukpn_lpn_primary_blackhorse_lane 51.5896895284359 -0.040236782608312 lpn-s000000000503
Powered by Datasette · Queries took 7.772ms