substation_types: 78

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
78 erith primary lpn ukpn 
[
    "1b6bdd1f-e7e7-4949-93f8-fe8ddb482028"
]
 
[
    11.0,
    22.0
]
 
[
    {
        "transformer_name": "t2",
        "transformer_id": "4f2b1490-6eaf-487b-9b13-48882d0919f1",
        "node_1": "eith82",
        "node_id_1": "37a5cd73-c8c9-477e-be01-81ab64eb2820",
        "voltage_1": 22.0,
        "node_2": "eith52 bb2(1)",
        "node_id_2": "6f8f873d-ea8e-4aa1-9d70-2652a6e18e18",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "835a484d-ebf5-4f1e-9dcd-cf585a66db46",
        "gsp_group_name": "11 - littlebrook 132kv gsp",
        "bsp_group_id": "1b6bdd1f-e7e7-4949-93f8-fe8ddb482028",
        "bsp_group_name": "erith",
        "substation_id": "1b6bdd1f-e7e7-4949-93f8-fe8ddb482028",
        "substation_name": "erith"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "5062f047-5716-4f4d-b73c-23a6c6aef449",
        "node_1": "eith81",
        "node_id_1": "3655f773-35ae-4998-b28e-fe81f7fb4ed3",
        "voltage_1": 22.0,
        "node_2": "eith52 bb2(2)",
        "node_id_2": "d128233c-7063-47f9-bbda-c75d8d1e988a",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "835a484d-ebf5-4f1e-9dcd-cf585a66db46",
        "gsp_group_name": "11 - littlebrook 132kv gsp",
        "bsp_group_id": "1b6bdd1f-e7e7-4949-93f8-fe8ddb482028",
        "bsp_group_name": "erith",
        "substation_id": "1b6bdd1f-e7e7-4949-93f8-fe8ddb482028",
        "substation_name": "erith"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "512478d9-82ab-4ee5-b8af-b6ae0353162c",
        "node_1": "eith83",
        "node_id_1": "dff2f0b6-c35c-48e4-bb1f-667e3d8b940f",
        "voltage_1": 22.0,
        "node_2": "eith51 bb1(1)",
        "node_id_2": "5310c288-b74f-45bb-ab06-dc6805f15c23",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "835a484d-ebf5-4f1e-9dcd-cf585a66db46",
        "gsp_group_name": "11 - littlebrook 132kv gsp",
        "bsp_group_id": "1b6bdd1f-e7e7-4949-93f8-fe8ddb482028",
        "bsp_group_name": "erith",
        "substation_id": "1b6bdd1f-e7e7-4949-93f8-fe8ddb482028",
        "substation_name": "erith"
    }
]
 ukpn_lpn_primary_erith 51.4819896905507 0.178137539244888 lpn-s000000000796