substation_types: 51

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
51 burlington rd primary lpn ukpn 
[
    "19a7a67f-0c58-486b-9e6b-d1e2ea8b0a4c"
]
 
[
    11.0,
    33.0
]
 
[
    {
        "transformer_name": "t2",
        "transformer_id": "36b43f7d-320e-4dc9-9d8a-36be9f7e125f",
        "node_1": "burl32",
        "node_id_1": "324c5fe3-e963-4ce2-80cf-a64fca76d05f",
        "voltage_1": 33.0,
        "node_2": "burl52 f bb1(1)",
        "node_id_2": "f64701f8-d688-48ee-85bb-ebc52993f294",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "dcf403f4-5966-477d-ad33-ca6a38c4be15",
        "gsp_group_name": "21 - wimbledon 3&4 132kv gsp",
        "bsp_group_id": "19a7a67f-0c58-486b-9e6b-d1e2ea8b0a4c",
        "bsp_group_name": "burlington rd",
        "substation_id": "19a7a67f-0c58-486b-9e6b-d1e2ea8b0a4c",
        "substation_name": "burlington rd"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "64a2a686-1bf0-43a2-b963-fbc1f2f1191b",
        "node_1": "burl31",
        "node_id_1": "3d8ca4cd-9736-4730-ae84-6cec6df35fd5",
        "voltage_1": 33.0,
        "node_2": "burl51 r bb1(1)",
        "node_id_2": "02eda528-44fe-49fc-add9-8d13d4d0a2d0",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "dcf403f4-5966-477d-ad33-ca6a38c4be15",
        "gsp_group_name": "21 - wimbledon 3&4 132kv gsp",
        "bsp_group_id": "19a7a67f-0c58-486b-9e6b-d1e2ea8b0a4c",
        "bsp_group_name": "burlington rd",
        "substation_id": "19a7a67f-0c58-486b-9e6b-d1e2ea8b0a4c",
        "substation_name": "burlington rd"
    },
    {
        "transformer_name": "t4",
        "transformer_id": "75f1f083-dad9-4053-ab2c-aea11960da3a",
        "node_1": "burl34",
        "node_id_1": "c9bc5e73-f4f6-45dd-a15f-0a72d22b0be9",
        "voltage_1": 33.0,
        "node_2": "burl52 f bb2(1)",
        "node_id_2": "a1b9cd7d-783f-4fa1-9e88-09b42c0ead1b",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "dcf403f4-5966-477d-ad33-ca6a38c4be15",
        "gsp_group_name": "21 - wimbledon 3&4 132kv gsp",
        "bsp_group_id": "19a7a67f-0c58-486b-9e6b-d1e2ea8b0a4c",
        "bsp_group_name": "burlington rd",
        "substation_id": "19a7a67f-0c58-486b-9e6b-d1e2ea8b0a4c",
        "substation_name": "burlington rd"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "e241e3a9-d1d8-4250-a02c-e1bb16867377",
        "node_1": "burl33",
        "node_id_1": "f2dd069c-d428-4c84-94d7-6ca2ab0bf74a",
        "voltage_1": 33.0,
        "node_2": "burl51 r bb2(1)",
        "node_id_2": "e3aa0bf9-08c1-4ae1-ad4e-a6fd0187fd10",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "dcf403f4-5966-477d-ad33-ca6a38c4be15",
        "gsp_group_name": "21 - wimbledon 3&4 132kv gsp",
        "bsp_group_id": "19a7a67f-0c58-486b-9e6b-d1e2ea8b0a4c",
        "bsp_group_name": "burlington rd",
        "substation_id": "19a7a67f-0c58-486b-9e6b-d1e2ea8b0a4c",
        "substation_name": "burlington rd"
    }
]
 ukpn_lpn_primary_burlington_rd 51.3993838291348 -0.242431988934972 lpn-s000000001014