substation_types: 54

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
54 carslake rd primary lpn ukpn 
[
    "f044db7c-87ee-4e50-b2a2-bb0b9fc290df"
]
 
[
    11.275,
    66.0
]
 
[
    {
        "transformer_name": "t4",
        "transformer_id": "42774f85-28c9-42ca-9e79-21fe9a53bd49",
        "node_1": "cark62",
        "node_id_1": "8ca26b39-5813-40eb-83ec-e8f7dab838e5",
        "voltage_1": 66.0,
        "node_2": "cark5b",
        "node_id_2": "7787b1bf-7ce7-4022-89d3-98db8470f543",
        "voltage_2": 11.275,
        "nom_rating": 15.0,
        "gsp_group_id": "dcf403f4-5966-477d-ad33-ca6a38c4be15",
        "gsp_group_name": "21 - wimbledon 3&4 132kv gsp",
        "bsp_group_id": "f044db7c-87ee-4e50-b2a2-bb0b9fc290df",
        "bsp_group_name": "carslake rd",
        "substation_id": "f044db7c-87ee-4e50-b2a2-bb0b9fc290df",
        "substation_name": "carslake rd"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "818a6c4b-64ce-411f-b08a-a2a634d32dd0",
        "node_1": "cark61",
        "node_id_1": "af161b5c-2d15-411d-80ab-d0bc6b7df0d9",
        "voltage_1": 66.0,
        "node_2": "cark5a",
        "node_id_2": "18c4002d-07ee-40fb-b187-166dca1da8cc",
        "voltage_2": 11.275,
        "nom_rating": 15.0,
        "gsp_group_id": "dcf403f4-5966-477d-ad33-ca6a38c4be15",
        "gsp_group_name": "21 - wimbledon 3&4 132kv gsp",
        "bsp_group_id": "f044db7c-87ee-4e50-b2a2-bb0b9fc290df",
        "bsp_group_name": "carslake rd",
        "substation_id": "f044db7c-87ee-4e50-b2a2-bb0b9fc290df",
        "substation_name": "carslake rd"
    },
    {
        "transformer_name": "t2",
        "transformer_id": "9bad0461-5fda-4bcb-b8fb-9f8c56078f67",
        "node_1": "cark64",
        "node_id_1": "ac0305f4-4368-40df-85c3-2a9f2b39efde",
        "voltage_1": 66.0,
        "node_2": "cark5d",
        "node_id_2": "895ca83a-7edf-41f6-b972-8dc42edfb9fb",
        "voltage_2": 11.275,
        "nom_rating": 15.0,
        "gsp_group_id": "dcf403f4-5966-477d-ad33-ca6a38c4be15",
        "gsp_group_name": "21 - wimbledon 3&4 132kv gsp",
        "bsp_group_id": "f044db7c-87ee-4e50-b2a2-bb0b9fc290df",
        "bsp_group_name": "carslake rd",
        "substation_id": "f044db7c-87ee-4e50-b2a2-bb0b9fc290df",
        "substation_name": "carslake rd"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "a6a0e210-df71-4f47-b8b6-f1e5e16ebaa0",
        "node_1": "cark63",
        "node_id_1": "dde5f22c-4718-4461-a44d-f14292861c87",
        "voltage_1": 66.0,
        "node_2": "cark5c",
        "node_id_2": "03af543d-88ec-42ef-9168-a7bf2b18f76e",
        "voltage_2": 11.275,
        "nom_rating": 15.0,
        "gsp_group_id": "dcf403f4-5966-477d-ad33-ca6a38c4be15",
        "gsp_group_name": "21 - wimbledon 3&4 132kv gsp",
        "bsp_group_id": "f044db7c-87ee-4e50-b2a2-bb0b9fc290df",
        "bsp_group_name": "carslake rd",
        "substation_id": "f044db7c-87ee-4e50-b2a2-bb0b9fc290df",
        "substation_name": "carslake rd"
    }
]
 ukpn_lpn_primary_carslake_rd 51.4540730193291 -0.228472378152626 lpn-s000000001017