substation_types: 67

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
67 dermody rd primary lpn ukpn 
[
    "11efcc9c-2c6a-4c95-9c65-6e64cdbef054"
]
 
[
    11.0,
    33.0
]
 
[
    {
        "transformer_name": "t3",
        "transformer_id": "323ae67a-024c-4bd9-a460-7c6aa96e3d57",
        "node_1": "derm32",
        "node_id_1": "336d58e0-2833-4375-93b0-30102cc6b86c",
        "voltage_1": 33.0,
        "node_2": "derm51 u bb2(1)",
        "node_id_2": "812453e3-3838-488a-8fc2-7c2b8d3b6a3f",
        "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": "11efcc9c-2c6a-4c95-9c65-6e64cdbef054",
        "bsp_group_name": "dermody rd",
        "substation_id": "11efcc9c-2c6a-4c95-9c65-6e64cdbef054",
        "substation_name": "dermody rd"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "af83f275-f978-43c9-9574-6b8991c3b24c",
        "node_1": "derm31",
        "node_id_1": "7c6b785a-a068-45c6-afa0-25517f8f58fc",
        "voltage_1": 33.0,
        "node_2": "derm51 u bb1(1)",
        "node_id_2": "20ac6553-2e42-4c9d-8d44-7f5a992444ad",
        "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": "11efcc9c-2c6a-4c95-9c65-6e64cdbef054",
        "bsp_group_name": "dermody rd",
        "substation_id": "11efcc9c-2c6a-4c95-9c65-6e64cdbef054",
        "substation_name": "dermody rd"
    },
    {
        "transformer_name": "t2",
        "transformer_id": "f1a276eb-a514-48b9-8c9c-1de6a52107e8",
        "node_1": "derm33",
        "node_id_1": "bf416b79-ea44-4950-840c-07f9eaca3a85",
        "voltage_1": 33.0,
        "node_2": "derm51 l bb1(1)",
        "node_id_2": "267f5cd3-1605-4327-9fab-aa9e8545fba2",
        "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": "11efcc9c-2c6a-4c95-9c65-6e64cdbef054",
        "bsp_group_name": "dermody rd",
        "substation_id": "11efcc9c-2c6a-4c95-9c65-6e64cdbef054",
        "substation_name": "dermody rd"
    }
]
 ukpn_lpn_primary_dermody_rd 51.4568744152811 -0.00433090329903443 lpn-s000000000822