substation_types: 100

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
100 kimberley rd primary lpn ukpn 
[
    "c3707021-bff8-4ff0-8f62-fd06b0362031"
]
 
[
    11.0,
    22.0
]
 
[
    {
        "transformer_name": "t3",
        "transformer_id": "2f4742dd-c976-4d51-a53c-25f63f3612ba",
        "node_1": "kimb82",
        "node_id_1": "7ff51bfc-8a21-4e0c-bff2-7f643354a0d4",
        "voltage_1": 22.0,
        "node_2": "kimb52 r bb2(1)",
        "node_id_2": "d6535e7e-b9f5-4582-a55b-747eeed7f899",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "201ea065-5cff-4b47-8738-5ea436e35f5d",
        "gsp_group_name": "01 - acton lane 22kv gsp",
        "bsp_group_id": "c3707021-bff8-4ff0-8f62-fd06b0362031",
        "bsp_group_name": "kimberley rd",
        "substation_id": "c3707021-bff8-4ff0-8f62-fd06b0362031",
        "substation_name": "kimberley rd"
    },
    {
        "transformer_name": "t2",
        "transformer_id": "4ace6dda-29e2-4e23-a44c-4969b2dcdb65",
        "node_1": "kimb83",
        "node_id_1": "ae28659c-49f5-43d3-9730-ced8d3a1fb8a",
        "voltage_1": 22.0,
        "node_2": "kimb51 f bb1(1)",
        "node_id_2": "81f6940d-57ef-4445-a5c5-4e4e44673c4b",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "201ea065-5cff-4b47-8738-5ea436e35f5d",
        "gsp_group_name": "01 - acton lane 22kv gsp",
        "bsp_group_id": "c3707021-bff8-4ff0-8f62-fd06b0362031",
        "bsp_group_name": "kimberley rd",
        "substation_id": "c3707021-bff8-4ff0-8f62-fd06b0362031",
        "substation_name": "kimberley rd"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "7d2619e6-5217-44a0-b5c2-457689fefae8",
        "node_1": "kimb81",
        "node_id_1": "5d3b492a-b610-47d0-9ebd-d8d65177cb91",
        "voltage_1": 22.0,
        "node_2": "kimb52 r bb1(1)",
        "node_id_2": "7cdf4d66-55cf-449c-ae59-da549ee8a630",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "201ea065-5cff-4b47-8738-5ea436e35f5d",
        "gsp_group_name": "01 - acton lane 22kv gsp",
        "bsp_group_id": "c3707021-bff8-4ff0-8f62-fd06b0362031",
        "bsp_group_name": "kimberley rd",
        "substation_id": "c3707021-bff8-4ff0-8f62-fd06b0362031",
        "substation_name": "kimberley rd"
    },
    {
        "transformer_name": "t4",
        "transformer_id": "bff74abe-dce7-485d-be3b-67b441245202",
        "node_1": "kimb84",
        "node_id_1": "fddcd063-f0d5-4e64-8fce-dfca1f48057f",
        "voltage_1": 22.0,
        "node_2": "kimb51 f bb2(1)",
        "node_id_2": "a2a3565d-39f2-4342-89f6-3fd59963235d",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "201ea065-5cff-4b47-8738-5ea436e35f5d",
        "gsp_group_name": "01 - acton lane 22kv gsp",
        "bsp_group_id": "c3707021-bff8-4ff0-8f62-fd06b0362031",
        "bsp_group_name": "kimberley rd",
        "substation_id": "c3707021-bff8-4ff0-8f62-fd06b0362031",
        "substation_name": "kimberley rd"
    }
]
 ukpn_lpn_primary_kimberley_rd 51.5410281307337 -0.205874961127166 lpn-s000000000247