substation_types: 60

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
60 clarks rd b primary lpn ukpn 
[
    "d71b7921-720a-4567-8a3b-e4d4ae2f3c40"
]
 
[
    11.0,
    33.0
]
 
[
    {
        "transformer_name": "t3b",
        "transformer_id": "20e49857-73cc-41ad-8d7a-44ca4f5bdc70",
        "node_1": "clar31",
        "node_id_1": "fe9b9a77-3b8e-4787-baa9-5511362bd19f",
        "voltage_1": 33.0,
        "node_2": "clar52 u bb2(1)",
        "node_id_2": "38ab92ea-6bef-4c6d-992a-75e947791bb1",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "5bd0f911-d72b-477d-a243-d7afd45edc0f",
        "gsp_group_name": "15 - redbridge 132kv gsp",
        "bsp_group_id": "d71b7921-720a-4567-8a3b-e4d4ae2f3c40",
        "bsp_group_name": "clarks rd b",
        "substation_id": "d71b7921-720a-4567-8a3b-e4d4ae2f3c40",
        "substation_name": "clarks rd b"
    },
    {
        "transformer_name": "t4b",
        "transformer_id": "2b4f5a03-d5f7-4c47-912d-66cc88599207",
        "node_1": "clar33",
        "node_id_1": "ec5117ab-39bd-4c39-9c85-9e221ec04096",
        "voltage_1": 33.0,
        "node_2": "clar52 l bb2(1)",
        "node_id_2": "14d5ac26-8e14-4626-aea1-710e0c286c42",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "5bd0f911-d72b-477d-a243-d7afd45edc0f",
        "gsp_group_name": "15 - redbridge 132kv gsp",
        "bsp_group_id": "d71b7921-720a-4567-8a3b-e4d4ae2f3c40",
        "bsp_group_name": "clarks rd b",
        "substation_id": "d71b7921-720a-4567-8a3b-e4d4ae2f3c40",
        "substation_name": "clarks rd b"
    },
    {
        "transformer_name": "t2b",
        "transformer_id": "2cb26e78-cfff-406e-ac54-42e453af75f0",
        "node_1": "clar34",
        "node_id_1": "256ac5ab-19e5-4276-aea7-0b73b55b5a31",
        "voltage_1": 33.0,
        "node_2": "clar51 l bb1(1)",
        "node_id_2": "97eddc40-5a2a-4ccf-a4cb-c7f57111caca",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "5bd0f911-d72b-477d-a243-d7afd45edc0f",
        "gsp_group_name": "15 - redbridge 132kv gsp",
        "bsp_group_id": "d71b7921-720a-4567-8a3b-e4d4ae2f3c40",
        "bsp_group_name": "clarks rd b",
        "substation_id": "d71b7921-720a-4567-8a3b-e4d4ae2f3c40",
        "substation_name": "clarks rd b"
    },
    {
        "transformer_name": "t1b",
        "transformer_id": "7ae6b376-aa21-4a70-8085-bcfbd3adf80a",
        "node_1": "clar32",
        "node_id_1": "e0c1ce85-9e56-419a-b24b-8ad1cd3876f0",
        "voltage_1": 33.0,
        "node_2": "clar51 u bb1(1)",
        "node_id_2": "3b8a9ba5-d230-4e9a-b803-ac8c577f8f43",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "5bd0f911-d72b-477d-a243-d7afd45edc0f",
        "gsp_group_name": "15 - redbridge 132kv gsp",
        "bsp_group_id": "d71b7921-720a-4567-8a3b-e4d4ae2f3c40",
        "bsp_group_name": "clarks rd b",
        "substation_id": "d71b7921-720a-4567-8a3b-e4d4ae2f3c40",
        "substation_name": "clarks rd b"
    }
]
 ukpn_lpn_primary_clarks_rd_b 51.5616115695199 0.0902081005716816 lpn-s000000000514