substation_types: 36

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
36 bengeworth rd primary lpn ukpn 
[
    "3f212a58-0494-4d7a-8a7c-717b60b1ae82"
]
 
[
    0.415,
    11.0,
    33.0
]
 
[
    {
        "transformer_name": "t2",
        "transformer_id": "3775bf14-ebb7-437e-a0bf-cf708d6aafca",
        "node_1": "benb3i",
        "node_id_1": "c6d7a0c3-8dba-41b8-8c4f-734557eae884",
        "voltage_1": 33.0,
        "node_2": "benr52 u bb1(1)",
        "node_id_2": "d83d97fc-3123-4313-a2e9-6802abc698ca",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "2b412ddc-3e42-4f14-b7a4-a07701540790",
        "gsp_group_name": "20 - wimbledon 1&2 132kv gsp",
        "bsp_group_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "bsp_group_name": "bengeworth rd",
        "substation_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "substation_name": "bengeworth rd"
    },
    {
        "transformer_name": "gt4_a",
        "transformer_id": "4e6d0d19-bd59-4d61-8019-1970cbf91536",
        "node_1": "benr3d",
        "node_id_1": "99d8413e-6d8d-44b2-9508-62553e538254",
        "voltage_1": 33.0,
        "node_2": "6046 benr9e4_",
        "node_id_2": "d10e6400-da7c-4256-90a2-15146067a171",
        "voltage_2": 0.415,
        "nom_rating": 0.5,
        "gsp_group_id": "2b412ddc-3e42-4f14-b7a4-a07701540790",
        "gsp_group_name": "20 - wimbledon 1&2 132kv gsp",
        "bsp_group_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "bsp_group_name": "bengeworth rd",
        "substation_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "substation_name": "bengeworth rd"
    },
    {
        "transformer_name": "t4",
        "transformer_id": "510f765f-2cd5-4ff4-99e8-26ce2ac9bbe1",
        "node_1": "benb3l",
        "node_id_1": "089e0abc-a848-4d6f-a520-d2442a872d97",
        "voltage_1": 33.0,
        "node_2": "benr52 u bb2(1)",
        "node_id_2": "2c44fd2a-40f8-44f2-9fea-5f0dfd9b9756",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "2b412ddc-3e42-4f14-b7a4-a07701540790",
        "gsp_group_name": "20 - wimbledon 1&2 132kv gsp",
        "bsp_group_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "bsp_group_name": "bengeworth rd",
        "substation_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "substation_name": "bengeworth rd"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "5222c9bc-e368-4ff8-afb1-3ffec59d97ed",
        "node_1": "benb3g",
        "node_id_1": "7a38ee34-8c1f-4426-95ce-c879a780be7e",
        "voltage_1": 33.0,
        "node_2": "benr51 l bb2(1)",
        "node_id_2": "9779597f-330c-40a1-aea3-baa16351e96b",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "2b412ddc-3e42-4f14-b7a4-a07701540790",
        "gsp_group_name": "20 - wimbledon 1&2 132kv gsp",
        "bsp_group_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "bsp_group_name": "bengeworth rd",
        "substation_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "substation_name": "bengeworth rd"
    },
    {
        "transformer_name": "gt3_a",
        "transformer_id": "9b5537c9-04e2-4411-a2e4-a6767bcd805d",
        "node_1": "benr3c",
        "node_id_1": "8d30045b-55e5-47b5-a8d4-ac77ffb38402",
        "voltage_1": 33.0,
        "node_2": "6045 benr9e3_",
        "node_id_2": "001319c0-2c39-438a-9ddc-639f0f879f2b",
        "voltage_2": 0.415,
        "nom_rating": 0.5,
        "gsp_group_id": "2b412ddc-3e42-4f14-b7a4-a07701540790",
        "gsp_group_name": "20 - wimbledon 1&2 132kv gsp",
        "bsp_group_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "bsp_group_name": "bengeworth rd",
        "substation_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "substation_name": "bengeworth rd"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "a0f50e1a-644c-4404-91c9-798f7bb894f4",
        "node_1": "benb3e",
        "node_id_1": "4bb8375c-5a4a-4374-a8c5-590310f2de4b",
        "voltage_1": 33.0,
        "node_2": "benr51 l bb1(1)",
        "node_id_2": "703ef31b-1ec6-4b83-99d1-a95b7bdb3f49",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "2b412ddc-3e42-4f14-b7a4-a07701540790",
        "gsp_group_name": "20 - wimbledon 1&2 132kv gsp",
        "bsp_group_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "bsp_group_name": "bengeworth rd",
        "substation_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "substation_name": "bengeworth rd"
    },
    {
        "transformer_name": "gt1_a",
        "transformer_id": "a70def8b-c6df-4f39-80fe-0e353c174685",
        "node_1": "benr3b",
        "node_id_1": "329670f1-c29f-4cec-8847-e5847a4951f1",
        "voltage_1": 33.0,
        "node_2": "6043 benr9e1_",
        "node_id_2": "8c4dca37-c96c-47e6-b02c-6b4f9d66374a",
        "voltage_2": 0.415,
        "nom_rating": 0.5,
        "gsp_group_id": "2b412ddc-3e42-4f14-b7a4-a07701540790",
        "gsp_group_name": "20 - wimbledon 1&2 132kv gsp",
        "bsp_group_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "bsp_group_name": "bengeworth rd",
        "substation_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "substation_name": "bengeworth rd"
    },
    {
        "transformer_name": "gt2_a",
        "transformer_id": "bb0f5703-a508-4b28-a54a-aa340c1e835d",
        "node_1": "benr3a",
        "node_id_1": "59927a31-25a5-49d0-b7fb-583bdf6e2ad8",
        "voltage_1": 33.0,
        "node_2": "6044 benr9e2_",
        "node_id_2": "47622996-68f4-4970-a594-04cca2660e43",
        "voltage_2": 0.415,
        "nom_rating": 0.5,
        "gsp_group_id": "2b412ddc-3e42-4f14-b7a4-a07701540790",
        "gsp_group_name": "20 - wimbledon 1&2 132kv gsp",
        "bsp_group_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "bsp_group_name": "bengeworth rd",
        "substation_id": "3f212a58-0494-4d7a-8a7c-717b60b1ae82",
        "substation_name": "bengeworth rd"
    }
]
 ukpn_lpn_primary_bengeworth_rd 51.4672396010659 -0.0965998096299446 lpn-s000000003909