substation_types: 95

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
95 hatchard rd primary lpn ukpn 
[
    "02b8ae08-fbce-4ea6-a187-2c903c1d6a7f"
]
 
[
    11.0,
    66.0
]
 
[
    {
        "transformer_name": "t3",
        "transformer_id": "0e68c978-3790-4c93-b32e-dd1545e5e700",
        "node_1": "hatr63",
        "node_id_1": "7aaacb84-3364-4faa-9eba-25d0f69ab13c",
        "voltage_1": 66.0,
        "node_2": "hatr52 l bb2(1)",
        "node_id_2": "b9fbd1e2-f7ad-47d6-b7f0-71a504fd1664",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "582ca2d8-29f7-4051-9be1-5d9628bc0d44",
        "gsp_group_name": "10 - islington 132kv gsp",
        "bsp_group_id": "02b8ae08-fbce-4ea6-a187-2c903c1d6a7f",
        "bsp_group_name": "hatchard rd",
        "substation_id": "02b8ae08-fbce-4ea6-a187-2c903c1d6a7f",
        "substation_name": "hatchard rd"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "5af0f63f-5c14-4b4b-87bd-9016f7d111d1",
        "node_1": "hatr61",
        "node_id_1": "158825b2-b127-4a52-8e10-c24aee3ef49c",
        "voltage_1": 66.0,
        "node_2": "hatr52 l bb1(1)",
        "node_id_2": "99eb8784-ef4f-4fdd-80ca-6c01cc1c64f1",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "582ca2d8-29f7-4051-9be1-5d9628bc0d44",
        "gsp_group_name": "10 - islington 132kv gsp",
        "bsp_group_id": "02b8ae08-fbce-4ea6-a187-2c903c1d6a7f",
        "bsp_group_name": "hatchard rd",
        "substation_id": "02b8ae08-fbce-4ea6-a187-2c903c1d6a7f",
        "substation_name": "hatchard rd"
    },
    {
        "transformer_name": "t4",
        "transformer_id": "5c3beb2a-e080-45c8-8a85-b1803f34490d",
        "node_1": "hatr64",
        "node_id_1": "3172cf1a-eeb4-47d0-a8b3-2782ec15c8d6",
        "voltage_1": 66.0,
        "node_2": "hatr51 u bb2(1)",
        "node_id_2": "3167aea1-9133-4b89-871a-8eb545c85a6e",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "582ca2d8-29f7-4051-9be1-5d9628bc0d44",
        "gsp_group_name": "10 - islington 132kv gsp",
        "bsp_group_id": "02b8ae08-fbce-4ea6-a187-2c903c1d6a7f",
        "bsp_group_name": "hatchard rd",
        "substation_id": "02b8ae08-fbce-4ea6-a187-2c903c1d6a7f",
        "substation_name": "hatchard rd"
    },
    {
        "transformer_name": "t2",
        "transformer_id": "fe95667f-1842-4a9b-8066-d618fb41025c",
        "node_1": "hatr62",
        "node_id_1": "4e74dfed-c1b9-47af-a897-23db87bd0542",
        "voltage_1": 66.0,
        "node_2": "hatr51 u bb1(1)",
        "node_id_2": "40d9dcf8-7b99-4ad8-a532-4fb5b6e37d32",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "582ca2d8-29f7-4051-9be1-5d9628bc0d44",
        "gsp_group_name": "10 - islington 132kv gsp",
        "bsp_group_id": "02b8ae08-fbce-4ea6-a187-2c903c1d6a7f",
        "bsp_group_name": "hatchard rd",
        "substation_id": "02b8ae08-fbce-4ea6-a187-2c903c1d6a7f",
        "substation_name": "hatchard rd"
    }
]
 ukpn_lpn_primary_hatchard_rd 51.5657810902315 -0.126279289729663 lpn-s000000000446