substation_types: 57

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
57 churchfields primary lpn ukpn 
[
    "f4dc0120-c16c-46d6-b34f-c28d7788075e"
]
 
[
    11.0,
    33.0
]
 
[
    {
        "transformer_name": "t1",
        "transformer_id": "2be64e60-9613-4d9e-84f4-af039cf5887f",
        "node_1": "chur31",
        "node_id_1": "d2c3a75b-7a99-48ee-9384-17e008a45dc1",
        "voltage_1": 33.0,
        "node_2": "chur52 u bb1(1)",
        "node_id_2": "c3fe1047-9217-4f41-9e2e-f61dfed5118d",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "009a2aa4-e220-4c9c-ad9f-9ab27b4dee1a",
        "gsp_group_name": "04 - beddington 132kv gsp",
        "bsp_group_id": "f4dc0120-c16c-46d6-b34f-c28d7788075e",
        "bsp_group_name": "churchfields",
        "substation_id": "f4dc0120-c16c-46d6-b34f-c28d7788075e",
        "substation_name": "churchfields"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "989c48ce-8b5c-40d2-9c7b-97f3b6e80a18",
        "node_1": "chur33",
        "node_id_1": "260674e0-26a5-48ad-b3ff-571bd103fa4a",
        "voltage_1": 33.0,
        "node_2": "chur51 u bb2(1)",
        "node_id_2": "4ea2bce4-a3b5-41f5-b191-7259290c5ac5",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "009a2aa4-e220-4c9c-ad9f-9ab27b4dee1a",
        "gsp_group_name": "04 - beddington 132kv gsp",
        "bsp_group_id": "f4dc0120-c16c-46d6-b34f-c28d7788075e",
        "bsp_group_name": "churchfields",
        "substation_id": "f4dc0120-c16c-46d6-b34f-c28d7788075e",
        "substation_name": "churchfields"
    },
    {
        "transformer_name": "t2",
        "transformer_id": "d77c1d3c-fcad-4e96-a612-1eb299b3024a",
        "node_1": "chur32",
        "node_id_1": "50eafdf7-99ea-4df0-945d-14a9bd8c9553",
        "voltage_1": 33.0,
        "node_2": "chur52 l bb1(1)",
        "node_id_2": "5998567e-5e9c-4b53-b712-29b722f6449a",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "009a2aa4-e220-4c9c-ad9f-9ab27b4dee1a",
        "gsp_group_name": "04 - beddington 132kv gsp",
        "bsp_group_id": "f4dc0120-c16c-46d6-b34f-c28d7788075e",
        "bsp_group_name": "churchfields",
        "substation_id": "f4dc0120-c16c-46d6-b34f-c28d7788075e",
        "substation_name": "churchfields"
    },
    {
        "transformer_name": "t4",
        "transformer_id": "eff3d835-1bfa-4546-994c-cc751bd407fd",
        "node_1": "chur34",
        "node_id_1": "59d825d3-e335-4e76-a20d-25d4625b1fe2",
        "voltage_1": 33.0,
        "node_2": "chur51 l bb2(1)",
        "node_id_2": "c4f7304c-b54d-4390-a515-4b8f877eca7f",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "009a2aa4-e220-4c9c-ad9f-9ab27b4dee1a",
        "gsp_group_name": "04 - beddington 132kv gsp",
        "bsp_group_id": "f4dc0120-c16c-46d6-b34f-c28d7788075e",
        "bsp_group_name": "churchfields",
        "substation_id": "f4dc0120-c16c-46d6-b34f-c28d7788075e",
        "substation_name": "churchfields"
    }
]
 ukpn_lpn_primary_churchfields 51.4037774636768 -0.0446582293113148 lpn-s000000000817