substation_types: 81

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
81 farjeon rd primary lpn ukpn 
[
    "ae6f8262-3a5e-4d2c-97f4-f0dfd65377a9"
]
 
[
    11.0,
    33.0
]
 
[
    {
        "transformer_name": "t4",
        "transformer_id": "6f47bd0c-1aff-4e6d-8561-58a884dc61d3",
        "node_1": "farj33",
        "node_id_1": "88173e86-993c-41b3-90c7-1b0ffca6befb",
        "voltage_1": 33.0,
        "node_2": "farj51 l bb2(1)",
        "node_id_2": "f198a5fc-d49b-4921-b459-1a2fd1472797",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "ae6f8262-3a5e-4d2c-97f4-f0dfd65377a9",
        "bsp_group_name": "farjeon rd",
        "substation_id": "ae6f8262-3a5e-4d2c-97f4-f0dfd65377a9",
        "substation_name": "farjeon rd"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "7f1eddbf-279f-4261-a21d-d2a7b08c2ba3",
        "node_1": "farj32",
        "node_id_1": "8e1e6f55-0128-4197-a71c-14e56fbb64ac",
        "voltage_1": 33.0,
        "node_2": "farj52 u bb1(1)",
        "node_id_2": "1d802b52-cb3d-4a88-979c-5aae14844352",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "ae6f8262-3a5e-4d2c-97f4-f0dfd65377a9",
        "bsp_group_name": "farjeon rd",
        "substation_id": "ae6f8262-3a5e-4d2c-97f4-f0dfd65377a9",
        "substation_name": "farjeon rd"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "a5db08a0-4e52-49f0-a8c5-66b9d4e19bb5",
        "node_1": "farj31",
        "node_id_1": "f2d57c42-4b81-4c19-94b2-41d58b8757b9",
        "voltage_1": 33.0,
        "node_2": "farj52 u bb2(1)",
        "node_id_2": "ae984929-41e6-408c-b925-93f4922981ab",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "ae6f8262-3a5e-4d2c-97f4-f0dfd65377a9",
        "bsp_group_name": "farjeon rd",
        "substation_id": "ae6f8262-3a5e-4d2c-97f4-f0dfd65377a9",
        "substation_name": "farjeon rd"
    },
    {
        "transformer_name": "t2",
        "transformer_id": "d9ceabcc-6a52-4175-b48d-0885af5e1cf5",
        "node_1": "farj34",
        "node_id_1": "d33300fb-1892-4966-af08-845ddb8f2129",
        "voltage_1": 33.0,
        "node_2": "farj51 l bb1(1)",
        "node_id_2": "6ed3b87f-58fe-4353-abf6-10e70d3ad43c",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "f6b7abdf-f26c-4d55-9106-d17e5bf9b99c",
        "gsp_group_name": "09 - hurst 132kv gsp",
        "bsp_group_id": "ae6f8262-3a5e-4d2c-97f4-f0dfd65377a9",
        "bsp_group_name": "farjeon rd",
        "substation_id": "ae6f8262-3a5e-4d2c-97f4-f0dfd65377a9",
        "substation_name": "farjeon rd"
    }
]
 ukpn_lpn_primary_farjeon_rd 51.4727028050111 0.0374273283590525 lpn-s000000000734