substation_types: 45

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
45 bromley bsp lpn ukpn 
[
    "16e01f9f-26e2-4371-9f9d-df841bfda51f"
]
 
[
    33.0,
    132.0
]
 
[
    {
        "transformer_name": "gt1",
        "transformer_id": "0182a305-8267-4b4c-917f-5c977e4bb848",
        "node_1": "brom11(5)",
        "node_id_1": "0756c781-a67f-401e-9bcf-74f7a4a00f26",
        "voltage_1": 132.0,
        "node_2": "brog32 f bb1(1)",
        "node_id_2": "8b1c60ee-c0e5-41bc-8267-55ab8a197d81",
        "voltage_2": 33.0,
        "nom_rating": 60.0,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "substation_id": "16e01f9f-26e2-4371-9f9d-df841bfda51f",
        "substation_name": "bromley grid"
    },
    {
        "transformer_name": "gt2",
        "transformer_id": "80e599a7-3ff7-499e-9790-bbce53bdb9d6",
        "node_1": "brom11(6)",
        "node_id_1": "3cce5427-fc5b-48cf-9064-2c5e1f80102b",
        "voltage_1": 132.0,
        "node_2": "brog31 r bb2(3)",
        "node_id_2": "b842e631-0dfd-4bc2-a750-81351648f2b7",
        "voltage_2": 33.0,
        "nom_rating": 60.0,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "substation_id": "16e01f9f-26e2-4371-9f9d-df841bfda51f",
        "substation_name": "bromley grid"
    },
    {
        "transformer_name": "gt3",
        "transformer_id": "94f3ea3d-0d53-473d-ac7c-571ef8fb5fbb",
        "node_1": "brom12(6)",
        "node_id_1": "1f63e7ba-d5d6-4b16-817c-e98b058acbe1",
        "voltage_1": 132.0,
        "node_2": "brog31 r bb1(3)",
        "node_id_2": "ae70de8a-573e-401a-980d-124dfa50c821",
        "voltage_2": 33.0,
        "nom_rating": 60.0,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "substation_id": "16e01f9f-26e2-4371-9f9d-df841bfda51f",
        "substation_name": "bromley grid"
    },
    {
        "transformer_name": "gt4",
        "transformer_id": "e693f0e3-9da1-4b7b-97cd-6fedbd8eef71",
        "node_1": "brom12(5)",
        "node_id_1": "6c2ad1ed-dad7-4e17-855c-18b2060e2adf",
        "voltage_1": 132.0,
        "node_2": "brog32 f bb2(1)",
        "node_id_2": "407ee0d6-2e83-44bf-bd44-e841723c7f88",
        "voltage_2": 33.0,
        "nom_rating": 60.0,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "substation_id": "16e01f9f-26e2-4371-9f9d-df841bfda51f",
        "substation_name": "bromley grid"
    }
]
 ukpn_lpn_bsp_bromley 51.3914391742025 0.037681542207521 lpn-s000000000808