substation_types: 96

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
96 hearn primary lpn ukpn 
[
    "6ad1809b-c2cd-4510-b294-900dd617f251"
]
 
[
    11.0,
    66.0
]
 
[
    {
        "transformer_name": "t2",
        "transformer_id": "624d0590-e567-42f5-852a-3bb9f1e826a7",
        "node_1": "hear62",
        "node_id_1": "e84b9d2a-1102-4448-bfbd-7b5acdf0b86d",
        "voltage_1": 66.0,
        "node_2": "hear5b",
        "node_id_2": "626580d7-d708-4064-abc8-9400c6b052a2",
        "voltage_2": 11.0,
        "nom_rating": 22.5,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "bsp_group_id": "6ad1809b-c2cd-4510-b294-900dd617f251",
        "bsp_group_name": "hearn st",
        "substation_id": "6ad1809b-c2cd-4510-b294-900dd617f251",
        "substation_name": "hearn st"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "94ab131d-0ad1-4c98-a6e1-42215e8b5ba2",
        "node_1": "hear63",
        "node_id_1": "98fd4624-b231-4484-9317-6a24d6d2531b",
        "voltage_1": 66.0,
        "node_2": "hear5c",
        "node_id_2": "a6e258ec-34eb-4a83-8807-be8049fb7fbe",
        "voltage_2": 11.0,
        "nom_rating": 22.5,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "bsp_group_id": "6ad1809b-c2cd-4510-b294-900dd617f251",
        "bsp_group_name": "hearn st",
        "substation_id": "6ad1809b-c2cd-4510-b294-900dd617f251",
        "substation_name": "hearn st"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "ad6c4965-9bb2-4fba-acc7-17553426a032",
        "node_1": "hear61",
        "node_id_1": "76ae8d71-5086-478a-9d5e-9668a4cb44dc",
        "voltage_1": 66.0,
        "node_2": "hear5a",
        "node_id_2": "8a647fd3-37ce-4ac6-9bbb-aa4028628212",
        "voltage_2": 11.0,
        "nom_rating": 22.5,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "bsp_group_id": "6ad1809b-c2cd-4510-b294-900dd617f251",
        "bsp_group_name": "hearn st",
        "substation_id": "6ad1809b-c2cd-4510-b294-900dd617f251",
        "substation_name": "hearn st"
    }
]
 ukpn_lpn_primary_hearn 51.522385880359 -0.079727620236909 lpn-s000000000453