substation_types: 46

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
46 bromley primary lpn ukpn 
[
    "16e01f9f-26e2-4371-9f9d-df841bfda51f"
]
 
[
    0.415,
    33.0
]
 
[
    {
        "transformer_name": "gt2_a",
        "transformer_id": "33d3f043-978d-4d72-ba80-29bc872a6aab",
        "node_1": "brog31 r bb2(3)",
        "node_id_1": "b842e631-0dfd-4bc2-a750-81351648f2b7",
        "voltage_1": 33.0,
        "node_2": "terminal(3)",
        "node_id_2": "e521a374-2187-437b-a9a7-90aab21c8518",
        "voltage_2": 0.415,
        "nom_rating": 0.14,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "16e01f9f-26e2-4371-9f9d-df841bfda51f",
        "bsp_group_name": "bromley grid",
        "substation_id": "16e01f9f-26e2-4371-9f9d-df841bfda51f",
        "substation_name": "bromley grid"
    },
    {
        "transformer_name": "gt1_a",
        "transformer_id": "5d16a616-aa97-4a2e-bcd7-e4399214a1e7",
        "node_1": "brog32 f bb1(1)",
        "node_id_1": "8b1c60ee-c0e5-41bc-8267-55ab8a197d81",
        "voltage_1": 33.0,
        "node_2": "terminal(8)",
        "node_id_2": "87d9c25f-2ec8-49cb-bc4b-e06515e2d3fd",
        "voltage_2": 0.415,
        "nom_rating": 0.14,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "16e01f9f-26e2-4371-9f9d-df841bfda51f",
        "bsp_group_name": "bromley grid",
        "substation_id": "16e01f9f-26e2-4371-9f9d-df841bfda51f",
        "substation_name": "bromley grid"
    },
    {
        "transformer_name": "gt3_a",
        "transformer_id": "9bf20f1c-264a-49f8-963c-54e795aa25ea",
        "node_1": "brog31 r bb1(3)",
        "node_id_1": "ae70de8a-573e-401a-980d-124dfa50c821",
        "voltage_1": 33.0,
        "node_2": "terminal(9)",
        "node_id_2": "2c8cce02-7e3a-4188-aa44-19f1af877a43",
        "voltage_2": 0.415,
        "nom_rating": 0.14,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "16e01f9f-26e2-4371-9f9d-df841bfda51f",
        "bsp_group_name": "bromley grid",
        "substation_id": "16e01f9f-26e2-4371-9f9d-df841bfda51f",
        "substation_name": "bromley grid"
    },
    {
        "transformer_name": "gt4_a",
        "transformer_id": "da01337d-5e82-4a42-86b1-ecd376d02c09",
        "node_1": "brog32 f bb2(1)",
        "node_id_1": "407ee0d6-2e83-44bf-bd44-e841723c7f88",
        "voltage_1": 33.0,
        "node_2": "terminal(2)",
        "node_id_2": "2aa88578-294a-4e82-bc19-9e90f045bac7",
        "voltage_2": 0.415,
        "nom_rating": 0.14,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "16e01f9f-26e2-4371-9f9d-df841bfda51f",
        "bsp_group_name": "bromley grid",
        "substation_id": "16e01f9f-26e2-4371-9f9d-df841bfda51f",
        "substation_name": "bromley grid"
    }
]
 ukpn_lpn_primary_bromley 51.3914391742025 0.037681542207521 lpn-s000000000808