substation_types: 71

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
71 durnsford rd primary lpn ukpn 
[
    "65b7858c-2e5a-4086-bb96-1ec53323013c"
]
 
[
    11.0,
    33.0
]
 
[
    {
        "transformer_name": "ft4",
        "transformer_id": "17a5711d-7f00-4487-829c-525597c325c9",
        "node_1": "derm34",
        "node_id_1": "31d4526d-013a-4a1f-98b8-9d626259e8da",
        "voltage_1": 33.0,
        "node_2": "durn51 f bb1(1)",
        "node_id_2": "04a8e5fa-d27f-42e2-b619-6946e1b8aea7",
        "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": "65b7858c-2e5a-4086-bb96-1ec53323013c",
        "bsp_group_name": "durnsford rd",
        "substation_id": "65b7858c-2e5a-4086-bb96-1ec53323013c",
        "substation_name": "durnsford rd"
    },
    {
        "transformer_name": "ft3",
        "transformer_id": "3fd11f30-19db-4401-902b-7a415add0613",
        "node_1": "derm33",
        "node_id_1": "ba6447a4-2d64-4231-8d1c-02d68803d536",
        "voltage_1": 33.0,
        "node_2": "durn51 f bb2(1)",
        "node_id_2": "3b42b5df-92e4-4d48-852e-eea58cc50653",
        "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": "65b7858c-2e5a-4086-bb96-1ec53323013c",
        "bsp_group_name": "durnsford rd",
        "substation_id": "65b7858c-2e5a-4086-bb96-1ec53323013c",
        "substation_name": "durnsford rd"
    },
    {
        "transformer_name": "ft2",
        "transformer_id": "4336663a-aa97-45d3-bfce-e52eb714ddf7",
        "node_1": "derm32",
        "node_id_1": "96bc291b-6b4c-4ec9-82c8-6e80b3b49d06",
        "voltage_1": 33.0,
        "node_2": "durn52 r bb2(1)",
        "node_id_2": "c29a493d-6e02-47fd-8da4-48e3de4c68b6",
        "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": "65b7858c-2e5a-4086-bb96-1ec53323013c",
        "bsp_group_name": "durnsford rd",
        "substation_id": "65b7858c-2e5a-4086-bb96-1ec53323013c",
        "substation_name": "durnsford rd"
    },
    {
        "transformer_name": "ft1",
        "transformer_id": "954ee8a3-9a4a-4dc6-9851-9b676727c647",
        "node_1": "derm31",
        "node_id_1": "032bb8a1-2f78-45ec-b6c0-33c9d31ece85",
        "voltage_1": 33.0,
        "node_2": "durn52 r bb1(1)",
        "node_id_2": "26fc2277-5cc6-4c07-84f1-ccfeea943750",
        "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": "65b7858c-2e5a-4086-bb96-1ec53323013c",
        "bsp_group_name": "durnsford rd",
        "substation_id": "65b7858c-2e5a-4086-bb96-1ec53323013c",
        "substation_name": "durnsford rd"
    }
]
 ukpn_lpn_primary_durnsford_rd 51.4302890842008 -0.191457167996828 lpn-s000000001027