substation_types: 40

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
40 bloomfield place primary lpn ukpn 
[
    "9f796eab-89fc-41b7-afd2-904285c804d8"
]
 
[
    6.8,
    66.0
]
 
[
    {
        "transformer_name": "t3",
        "transformer_id": "10932311-ba4f-4e74-a11a-6c9fbe987f5b",
        "node_1": "blop63",
        "node_id_1": "be4b03fa-5a4f-48c8-a58c-4e6cd714782a",
        "voltage_1": 66.0,
        "node_2": "blop72 r bb2(1)",
        "node_id_2": "a2d1d1cb-e3e1-486e-a56a-10ea12699032",
        "voltage_2": 6.8,
        "nom_rating": 12.0,
        "gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
        "gsp_group_name": "12 - lodge road b 66kv gsp",
        "bsp_group_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
        "bsp_group_name": "bloomfield place",
        "substation_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
        "substation_name": "bloomfield place"
    },
    {
        "transformer_name": "ft1",
        "transformer_id": "1b911554-07d0-4650-873e-154970f971bd",
        "node_1": "blop61",
        "node_id_1": "69416061-64de-4817-bcba-5db0cec3bed7",
        "voltage_1": 66.0,
        "node_2": "blop72 r bb1(1)",
        "node_id_2": "fc7de079-9103-475b-8bd5-a20a0993743e",
        "voltage_2": 6.8,
        "nom_rating": 12.0,
        "gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
        "gsp_group_name": "12 - lodge road b 66kv gsp",
        "bsp_group_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
        "bsp_group_name": "bloomfield place",
        "substation_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
        "substation_name": "bloomfield place"
    },
    {
        "transformer_name": "ft2",
        "transformer_id": "2ecdf959-814e-4514-93bc-c2d779c138e2",
        "node_1": "blop62",
        "node_id_1": "bcabd608-9d84-4311-9e9b-2ec0faa1e6fc",
        "voltage_1": 66.0,
        "node_2": "blop71 f bb1(1)",
        "node_id_2": "e5c23fcb-c675-41b2-8af5-2727983b0174",
        "voltage_2": 6.8,
        "nom_rating": 12.0,
        "gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
        "gsp_group_name": "12 - lodge road b 66kv gsp",
        "bsp_group_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
        "bsp_group_name": "bloomfield place",
        "substation_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
        "substation_name": "bloomfield place"
    },
    {
        "transformer_name": "t4",
        "transformer_id": "b79da6d1-b311-45e9-b7d2-2b77d4259ea4",
        "node_1": "blop64",
        "node_id_1": "b028a29d-1187-4a2d-bcad-85cb85d3aac3",
        "voltage_1": 66.0,
        "node_2": "blop71 f bb2(1)",
        "node_id_2": "a3ca2a71-7d79-4232-8485-5461450a8958",
        "voltage_2": 6.8,
        "nom_rating": 12.0,
        "gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
        "gsp_group_name": "12 - lodge road b 66kv gsp",
        "bsp_group_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
        "bsp_group_name": "bloomfield place",
        "substation_id": "9f796eab-89fc-41b7-afd2-904285c804d8",
        "substation_name": "bloomfield place"
    }
]
 ukpn_lpn_primary_bloomfield_place 51.5115765277992 -0.144515414150925 lpn-s000000000313