substation_types: 80

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
80 fairlop rd primary lpn ukpn 
[
    "5b025ec1-0389-44cb-8802-59f62a11459e"
]
 
[
    11.0,
    33.0
]
 
[
    {
        "transformer_name": "ft2",
        "transformer_id": "0935481e-1c02-4632-9ec7-89b3b00f2e48",
        "node_1": "fair34",
        "node_id_1": "c8b230e0-4997-4fbb-9bbc-675164fcb1fb",
        "voltage_1": 33.0,
        "node_2": "fair51 f bb1(1)",
        "node_id_2": "19976a38-d4d8-4731-b363-4e90fd632167",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "bsp_group_id": "5b025ec1-0389-44cb-8802-59f62a11459e",
        "bsp_group_name": "fairlop rd",
        "substation_id": "5b025ec1-0389-44cb-8802-59f62a11459e",
        "substation_name": "fairlop rd"
    },
    {
        "transformer_name": "ft4",
        "transformer_id": "97b868d4-229e-4c57-ad07-2baf78de7d3d",
        "node_1": "fair33",
        "node_id_1": "32194558-cef4-4e37-936e-4c0a54183a8c",
        "voltage_1": 33.0,
        "node_2": "fair51 f bb2(1)",
        "node_id_2": "8c515a0e-23ac-45de-8cf1-aa1fb0137840",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "bsp_group_id": "5b025ec1-0389-44cb-8802-59f62a11459e",
        "bsp_group_name": "fairlop rd",
        "substation_id": "5b025ec1-0389-44cb-8802-59f62a11459e",
        "substation_name": "fairlop rd"
    },
    {
        "transformer_name": "ft1",
        "transformer_id": "d97627e9-f01b-4d8f-98c2-c2f7b9926f2e",
        "node_1": "fair32",
        "node_id_1": "39e7be47-9a68-40ed-bcae-e0a4cf0243ea",
        "voltage_1": 33.0,
        "node_2": "fair51 r bb1(1)",
        "node_id_2": "b054ad21-9d2a-4a74-a069-cbf9b5ae7571",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "bsp_group_id": "5b025ec1-0389-44cb-8802-59f62a11459e",
        "bsp_group_name": "fairlop rd",
        "substation_id": "5b025ec1-0389-44cb-8802-59f62a11459e",
        "substation_name": "fairlop rd"
    },
    {
        "transformer_name": "ft3",
        "transformer_id": "ec1cf9d2-d7d4-4bdc-980c-a13f663f2baa",
        "node_1": "fair31",
        "node_id_1": "696e7b05-d1fe-4879-b9c1-a33d0ec4070d",
        "voltage_1": 33.0,
        "node_2": "fair51 r bb2(1)",
        "node_id_2": "164b88fa-b5f1-46b3-a4fe-85f744849664",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "3afda362-bc9a-4106-8593-3610cf6bdac8",
        "gsp_group_name": "05 - brimsdown 132kv gsp",
        "bsp_group_id": "5b025ec1-0389-44cb-8802-59f62a11459e",
        "bsp_group_name": "fairlop rd",
        "substation_id": "5b025ec1-0389-44cb-8802-59f62a11459e",
        "substation_name": "fairlop rd"
    }
]
 ukpn_lpn_primary_fairlop_rd 51.5931847836538 0.0841496939754189 lpn-s000000000526