substation_types: 70

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
70 dukes ave primary lpn ukpn 
[
    "bb8e7f3d-29ed-4620-87d8-cb45e7d393a0"
]
 
[
    11.0,
    33.0
]
 
[
    {
        "transformer_name": "t2",
        "transformer_id": "62e46793-f206-49f3-b1b9-94c77628b3d6",
        "node_1": "dkav31",
        "node_id_1": "173265d1-1c94-4e67-b690-b8a3918b4019",
        "voltage_1": 33.0,
        "node_2": "dkav51 b bb1(1)",
        "node_id_2": "782c251e-4f88-401d-9427-71673c06adc8",
        "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": "bb8e7f3d-29ed-4620-87d8-cb45e7d393a0",
        "bsp_group_name": "dukes ave",
        "substation_id": "bb8e7f3d-29ed-4620-87d8-cb45e7d393a0",
        "substation_name": "dukes ave"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "79993e1a-cd81-4256-8857-ef7ab771d7ef",
        "node_1": "dkav32",
        "node_id_1": "7504809a-fc65-4325-b9c1-81daccb15133",
        "voltage_1": 33.0,
        "node_2": "dkav51 t bb2(1)",
        "node_id_2": "b5754a1d-ee67-441f-93df-eef46d2e5ef2",
        "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": "bb8e7f3d-29ed-4620-87d8-cb45e7d393a0",
        "bsp_group_name": "dukes ave",
        "substation_id": "bb8e7f3d-29ed-4620-87d8-cb45e7d393a0",
        "substation_name": "dukes ave"
    },
    {
        "transformer_name": "t4",
        "transformer_id": "be41c96b-1c49-48de-96ec-410a20833401",
        "node_1": "dkav33",
        "node_id_1": "82b2ceca-3690-4d28-ab61-a70e00965fde",
        "voltage_1": 33.0,
        "node_2": "dkav51 b bb2(1)",
        "node_id_2": "a1512311-37f6-4c6b-a922-972d847205b8",
        "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": "bb8e7f3d-29ed-4620-87d8-cb45e7d393a0",
        "bsp_group_name": "dukes ave",
        "substation_id": "bb8e7f3d-29ed-4620-87d8-cb45e7d393a0",
        "substation_name": "dukes ave"
    }
]
 ukpn_lpn_primary_dukes_ave 51.4043906535647 -0.251916156301172 lpn-s000000001025