substation_types: 79

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
79 exeter rd primary lpn ukpn 
[
    "5023316a-d62d-4c7b-ba66-c9db3bc64cb4"
]
 
[
    11.0,
    66.0
]
 
[
    {
        "transformer_name": "t4",
        "transformer_id": "333de2a4-7ce0-47b1-9d22-f3ec3dddc0f8",
        "node_1": "exet64",
        "node_id_1": "10ecb8d8-1fd9-42a6-955c-17e36c637bf9",
        "voltage_1": 66.0,
        "node_2": "exet52 r bb1(1)",
        "node_id_2": "a9eca9b7-e624-441e-af66-8a4cd9201620",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "0ba3e841-136b-410e-ae93-f99f8908a949",
        "gsp_group_name": "07 - hackney 66kv gsp",
        "bsp_group_id": "5023316a-d62d-4c7b-ba66-c9db3bc64cb4",
        "bsp_group_name": "exeter rd",
        "substation_id": "5023316a-d62d-4c7b-ba66-c9db3bc64cb4",
        "substation_name": "exeter rd"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "39a40b3f-bac2-4218-b77e-066e5113e5e5",
        "node_1": "exet61",
        "node_id_1": "850205cd-42a8-48cb-accc-0d8aee4ba723",
        "voltage_1": 66.0,
        "node_2": "exet51 f bb2(1)",
        "node_id_2": "01f42aea-8bec-43cb-b3c9-cb95fd282938",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "0ba3e841-136b-410e-ae93-f99f8908a949",
        "gsp_group_name": "07 - hackney 66kv gsp",
        "bsp_group_id": "5023316a-d62d-4c7b-ba66-c9db3bc64cb4",
        "bsp_group_name": "exeter rd",
        "substation_id": "5023316a-d62d-4c7b-ba66-c9db3bc64cb4",
        "substation_name": "exeter rd"
    },
    {
        "transformer_name": "t2",
        "transformer_id": "8ecc216e-0caf-4b41-a4d2-c8364544633a",
        "node_1": "exet62",
        "node_id_1": "d9e3f80c-4f5e-4b14-af43-0fd571ff44d0",
        "voltage_1": 66.0,
        "node_2": "exet52 r bb2(1)",
        "node_id_2": "a258b25d-7cd4-48bb-a729-abe1b843c581",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "0ba3e841-136b-410e-ae93-f99f8908a949",
        "gsp_group_name": "07 - hackney 66kv gsp",
        "bsp_group_id": "5023316a-d62d-4c7b-ba66-c9db3bc64cb4",
        "bsp_group_name": "exeter rd",
        "substation_id": "5023316a-d62d-4c7b-ba66-c9db3bc64cb4",
        "substation_name": "exeter rd"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "e9d9efba-d4d6-4e08-91e2-1086c8f61d60",
        "node_1": "exet63",
        "node_id_1": "ddaa621a-c47d-4bc7-9862-7595e86f101e",
        "voltage_1": 66.0,
        "node_2": "exet51 f bb1(1)",
        "node_id_2": "e0ef00cf-10d7-4a26-8e7e-d4bd72159dc1",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "0ba3e841-136b-410e-ae93-f99f8908a949",
        "gsp_group_name": "07 - hackney 66kv gsp",
        "bsp_group_id": "5023316a-d62d-4c7b-ba66-c9db3bc64cb4",
        "bsp_group_name": "exeter rd",
        "substation_id": "5023316a-d62d-4c7b-ba66-c9db3bc64cb4",
        "substation_name": "exeter rd"
    }
]
 ukpn_lpn_primary_exeter_rd 51.581977946454 -0.0217178020047047 lpn-s000000000524