substation_types: 47

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
47 bromley south primary lpn ukpn 
[
    "01ae7a79-ccf7-4ad4-b0dd-603ef29a6e53"
]
 
[
    11.0,
    33.0
]
 
[
    {
        "transformer_name": "t3",
        "transformer_id": "136218b6-d833-4951-ba46-3295b38a0c28",
        "node_1": "bros31",
        "node_id_1": "7e429ef2-8075-4d62-905f-2f933b8c69ff",
        "voltage_1": 33.0,
        "node_2": "bros52 u bb2(1)",
        "node_id_2": "9c0f7db0-06aa-4973-8078-5e16603cd8ad",
        "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": "01ae7a79-ccf7-4ad4-b0dd-603ef29a6e53",
        "bsp_group_name": "bromley south",
        "substation_id": "01ae7a79-ccf7-4ad4-b0dd-603ef29a6e53",
        "substation_name": "bromley south"
    },
    {
        "transformer_name": "t4",
        "transformer_id": "1ae99da0-19ba-4e05-b7bb-604b9d96df86",
        "node_1": "bros33",
        "node_id_1": "9103c557-099d-4231-a04a-a6a7e0e78868",
        "voltage_1": 33.0,
        "node_2": "bros51 l bb2(1)",
        "node_id_2": "85586f57-af93-4353-8c00-0f0ab7bbc425",
        "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": "01ae7a79-ccf7-4ad4-b0dd-603ef29a6e53",
        "bsp_group_name": "bromley south",
        "substation_id": "01ae7a79-ccf7-4ad4-b0dd-603ef29a6e53",
        "substation_name": "bromley south"
    },
    {
        "transformer_name": "t2",
        "transformer_id": "4078506c-2b77-48cd-aa6b-9840b6c529b4",
        "node_1": "bros34",
        "node_id_1": "bfcadfcc-d52e-43f1-823f-5960f1d54b1a",
        "voltage_1": 33.0,
        "node_2": "bros51 l bb1(1)",
        "node_id_2": "ec471c98-c5ac-417b-9cc0-3d5607bc1fae",
        "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": "01ae7a79-ccf7-4ad4-b0dd-603ef29a6e53",
        "bsp_group_name": "bromley south",
        "substation_id": "01ae7a79-ccf7-4ad4-b0dd-603ef29a6e53",
        "substation_name": "bromley south"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "f3efe4e5-94aa-4c8a-a2a9-2353e449d8a3",
        "node_1": "bros32",
        "node_id_1": "11625878-4f3a-4071-9fe9-680aa827fdd3",
        "voltage_1": 33.0,
        "node_2": "bros52 u bb1(1)",
        "node_id_2": "c75a4f2d-82db-456a-95b6-fd623ad1b101",
        "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": "01ae7a79-ccf7-4ad4-b0dd-603ef29a6e53",
        "bsp_group_name": "bromley south",
        "substation_id": "01ae7a79-ccf7-4ad4-b0dd-603ef29a6e53",
        "substation_name": "bromley south"
    }
]
 ukpn_lpn_primary_bromley_south 51.3914391742025 0.037681542207521 lpn-s000000000808