home / primary / substation_types

substation_types: 88

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
88 gibbons rd bsp lpn ukpn
[
    "ca2b68cd-f788-4837-a37b-19ae7201e859"
]
[
    11.11,
    132.0
]
[
    {
        "transformer_name": "gt1",
        "transformer_id": "5e33c0ad-55f6-4f52-9da2-d2ffaf9b9791",
        "node_1": "gibr11",
        "node_id_1": "27d9e7f2-9562-44a5-a31e-eaa80137fcd9",
        "voltage_1": 132.0,
        "node_2": "gibr5e",
        "node_id_2": "f1fdc963-0c11-49c5-8e17-acd9492a4de7",
        "voltage_2": 11.11,
        "node_3": "gibr5f",
        "node_id_3": "244c18b7-3bb9-459b-830c-e6344725f8a2",
        "voltage_3": 11.11,
        "nom_rating": 60.6,
        "gsp_group_id": "0194f412-d6f0-4859-aee3-21cb2557ed0b",
        "gsp_group_name": "19 - willesden 132kv gsp",
        "substation_id": "ca2b68cd-f788-4837-a37b-19ae7201e859",
        "substation_name": "gibbons rd"
    },
    {
        "transformer_name": "gt2",
        "transformer_id": "baa0fe58-16f5-43f4-acfb-67317e205f8b",
        "node_1": "4383 gibr1t2_",
        "node_id_1": "39187951-067d-4b2a-b186-d63b08a4fb98",
        "voltage_1": 132.0,
        "node_2": "6383 gibr5t2a",
        "node_id_2": "2e86f887-f842-4ae1-821f-1f02cb5b4756",
        "voltage_2": 11.11,
        "node_3": "5383 gibr5t2b",
        "node_id_3": "1b643578-2e09-43fb-98ab-0bcfe05894b8",
        "voltage_3": 11.11,
        "nom_rating": 60.6,
        "gsp_group_id": "0194f412-d6f0-4859-aee3-21cb2557ed0b",
        "gsp_group_name": "19 - willesden 132kv gsp",
        "substation_id": "ca2b68cd-f788-4837-a37b-19ae7201e859",
        "substation_name": "gibbons rd"
    },
    {
        "transformer_name": "gt3",
        "transformer_id": "d387293f-6e14-4c4e-8b1a-effa8971e3df",
        "node_1": "gibr13",
        "node_id_1": "287fdba8-87b6-46f4-8397-354906386579",
        "voltage_1": 132.0,
        "node_2": "gibr5a",
        "node_id_2": "e65b15b4-f352-4fbe-9ea2-0ae1d77ff761",
        "voltage_2": 11.11,
        "node_3": "gibr5b",
        "node_id_3": "e14a25a4-3b00-44ef-a783-cade2d0937da",
        "voltage_3": 11.11,
        "nom_rating": 60.6,
        "gsp_group_id": "0194f412-d6f0-4859-aee3-21cb2557ed0b",
        "gsp_group_name": "19 - willesden 132kv gsp",
        "substation_id": "ca2b68cd-f788-4837-a37b-19ae7201e859",
        "substation_name": "gibbons rd"
    }
]
ukpn_lpn_bsp_gibbons_rd 51.5463340961811 -0.256605931549261 lpn-s000000000240
Powered by Datasette · Queries took 2.274ms