substation_types: 53

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
53 carnaby primary lpn ukpn 
[
    "41874633-a2e7-4e34-8247-e0218d499ae9"
]
 
[
    11.0,
    11.3,
    21.8,
    66.0
]
 
[
    {
        "transformer_name": "ft3",
        "transformer_id": "0493e5b0-b424-48aa-8302-bf7f45b34e4a",
        "node_1": "carn63",
        "node_id_1": "3cbb39a2-5d4c-4870-ae40-84d827cd117e",
        "voltage_1": 66.0,
        "node_2": "terminal(1)",
        "node_id_2": "7ca15f85-a819-4857-88e6-e772609fbffe",
        "voltage_2": 21.8,
        "node_3": "carn51 r bb2(1)",
        "node_id_3": "94825493-dd04-400b-8529-75219675ad58",
        "voltage_3": 11.3,
        "nom_rating": 36.0,
        "gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
        "gsp_group_name": "12 - lodge road b 66kv gsp",
        "bsp_group_id": "41874633-a2e7-4e34-8247-e0218d499ae9",
        "bsp_group_name": "carnaby st",
        "substation_id": "41874633-a2e7-4e34-8247-e0218d499ae9",
        "substation_name": "carnaby st"
    },
    {
        "transformer_name": "ft1",
        "transformer_id": "2c63fa07-d0f1-4206-8086-2a12f2478a8f",
        "node_1": "carn61",
        "node_id_1": "4071116a-363b-4517-b188-2afaf80af299",
        "voltage_1": 66.0,
        "node_2": "terminal(3)",
        "node_id_2": "a846ded0-aae7-477f-b8ae-66bece8dd72c",
        "voltage_2": 21.8,
        "node_3": "carn51 r bb1(1)",
        "node_id_3": "77722bc0-7fd3-4ab2-9582-5ab87a649cd8",
        "voltage_3": 11.3,
        "nom_rating": 36.0,
        "gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
        "gsp_group_name": "12 - lodge road b 66kv gsp",
        "bsp_group_id": "41874633-a2e7-4e34-8247-e0218d499ae9",
        "bsp_group_name": "carnaby st",
        "substation_id": "41874633-a2e7-4e34-8247-e0218d499ae9",
        "substation_name": "carnaby st"
    },
    {
        "transformer_name": "ft2",
        "transformer_id": "7f48b0c1-d24f-458e-8292-94e1ef13d313",
        "node_1": "carn62",
        "node_id_1": "b071b3b7-3f0c-4ae1-9dab-a86a5644a0ec",
        "voltage_1": 66.0,
        "node_2": "terminal",
        "node_id_2": "18c19aad-e32c-4dca-abbb-40d506fdc4fc",
        "voltage_2": 21.8,
        "node_3": "carn52 f bb1(1)",
        "node_id_3": "ac79b333-0dd8-496c-81ac-d2622de26567",
        "voltage_3": 11.3,
        "nom_rating": 36.0,
        "gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
        "gsp_group_name": "12 - lodge road b 66kv gsp",
        "bsp_group_id": "41874633-a2e7-4e34-8247-e0218d499ae9",
        "bsp_group_name": "carnaby st",
        "substation_id": "41874633-a2e7-4e34-8247-e0218d499ae9",
        "substation_name": "carnaby st"
    },
    {
        "transformer_name": "ft4",
        "transformer_id": "d1db6828-d570-4fe9-9ded-3024ed4188cc",
        "node_1": "carn64",
        "node_id_1": "a655294b-8375-4eb3-a7dd-e5b49b84b8e7",
        "voltage_1": 66.0,
        "node_2": "carc51 l bb1(1)",
        "node_id_2": "3181a516-f07e-4b69-808b-cbbe5b2e8f21",
        "voltage_2": 11.0,
        "nom_rating": 33.3,
        "gsp_group_id": "0691662c-6d9b-40dd-877e-1500764c66ad",
        "gsp_group_name": "12 - lodge road b 66kv gsp",
        "bsp_group_id": "41874633-a2e7-4e34-8247-e0218d499ae9",
        "bsp_group_name": "carnaby st",
        "substation_id": "41874633-a2e7-4e34-8247-e0218d499ae9",
        "substation_name": "carnaby st"
    }
]
 ukpn_lpn_primary_carnaby 51.5132017792974 -0.138122497344929 lpn-s000000000319