substation_types: 83

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
83 finsbury market primary lpn ukpn 
[
    "34a77ab3-1420-47d2-bccf-749d3244d16a"
]
 
[
    0.415,
    11.0,
    11.275,
    33.0
]
 
[
    {
        "transformer_name": "ft6d",
        "transformer_id": "1ae9a61d-a0fc-417b-b950-7aa74dc1ef4f",
        "node_1": "find32",
        "node_id_1": "13014819-3778-4b64-b803-38d0310f332c",
        "voltage_1": 33.0,
        "node_2": "find51 bb1(1)",
        "node_id_2": "acc3a37f-c588-4033-a17c-84e6a2ebcef4",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "bsp_group_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "bsp_group_name": "finsbury market",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "at2c",
        "transformer_id": "6463e2b7-e29c-4f90-ac05-c1ba743fbd65",
        "node_1": "finf31 r bb4(2)",
        "node_id_1": "5d570998-4a98-4eca-8d85-2871bede80c4",
        "voltage_1": 33.0,
        "node_2": "terminal(48)",
        "node_id_2": "0bc9f311-9455-4a69-868c-0a09d54ae588",
        "voltage_2": 0.415,
        "nom_rating": 0.2,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "bsp_group_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "bsp_group_name": "finsbury market",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "ft7d",
        "transformer_id": "68c69fb3-f123-4f28-8ac4-63633b110c9f",
        "node_1": "find33",
        "node_id_1": "fce53a0d-e5b8-4e99-9d9e-420ed061ff8b",
        "voltage_1": 33.0,
        "node_2": "find51 bb1(2)",
        "node_id_2": "d113c19b-94ff-43e2-b123-3d4a572d7655",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "bsp_group_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "bsp_group_name": "finsbury market",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "gt2b_a",
        "transformer_id": "878b7f1f-dcb8-4405-9dba-36fcf9a88f0f",
        "node_1": "finb31 f bb2(1)",
        "node_id_1": "eaeefb3c-59a4-4d89-a781-c0a2d06cbee5",
        "voltage_1": 33.0,
        "node_2": "terminal(1)",
        "node_id_2": "0ff2dce8-42d9-4210-b58b-be96cfac90a2",
        "voltage_2": 0.415,
        "nom_rating": 0.13,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "bsp_group_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "bsp_group_name": "finsbury market",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "ft5d",
        "transformer_id": "8f60f362-8aa7-4a10-be93-342476d1685c",
        "node_1": "find31",
        "node_id_1": "e5ccd902-3844-476a-b682-22be6b6ce1bb",
        "voltage_1": 33.0,
        "node_2": "find51 bb2(1)",
        "node_id_2": "90a906c6-c74f-4fe6-b6a9-ca65fd6a6d16",
        "voltage_2": 11.0,
        "nom_rating": 15.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "bsp_group_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "bsp_group_name": "finsbury market",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "ft4",
        "transformer_id": "b128cd4d-8697-4b93-be55-be33a1ed8bd2",
        "node_1": "fina31",
        "node_id_1": "12d8637f-c43d-464a-be18-f5533fb6cfa1",
        "voltage_1": 33.0,
        "node_2": "fina52 b bb1(1)",
        "node_id_2": "0d7dc408-a1c0-47cf-922d-e2757c19b4d1",
        "voltage_2": 11.275,
        "nom_rating": 15.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "bsp_group_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "bsp_group_name": "finsbury market",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "at3c",
        "transformer_id": "d0bddaf0-4c4b-444c-a593-83a1f9f820c0",
        "node_1": "finf31 r bb3(3)",
        "node_id_1": "677e36e0-7d05-4f70-a1d8-49d256f7a067",
        "voltage_1": 33.0,
        "node_2": "terminal(28)",
        "node_id_2": "baf377d1-b188-4263-9d86-065da59fe918",
        "voltage_2": 0.415,
        "nom_rating": 0.2,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "bsp_group_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "bsp_group_name": "finsbury market",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "gt3b_a",
        "transformer_id": "dd5b52be-82b5-4ebe-a584-c98aedd2beec",
        "node_1": "finb31 r bb1(2)",
        "node_id_1": "202284a4-a33b-48e3-a056-c365ccfe430a",
        "voltage_1": 33.0,
        "node_2": "terminal(2)",
        "node_id_2": "efc3f4c6-7df3-40e2-99a5-ae7ca7f20131",
        "voltage_2": 0.415,
        "nom_rating": 0.13,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "bsp_group_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "bsp_group_name": "finsbury market",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "at1c",
        "transformer_id": "e525b15e-742a-4ae4-8336-553b83aafb93",
        "node_1": "finf31 r bb3(1)",
        "node_id_1": "65ed8998-1aef-44d8-8adc-eba46cbd62b6",
        "voltage_1": 33.0,
        "node_2": "terminal(29)",
        "node_id_2": "e05e8c44-0d4f-40e4-a5e4-89baae63886a",
        "voltage_2": 0.415,
        "nom_rating": 0.2,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "bsp_group_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "bsp_group_name": "finsbury market",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "gt1b_a",
        "transformer_id": "fc268cb1-af3d-4f9f-a2c7-abf2cda9ec4b",
        "node_1": "finb32",
        "node_id_1": "720a7d23-42f2-43d7-8e88-123b7e34b011",
        "voltage_1": 33.0,
        "node_2": "terminal",
        "node_id_2": "7fab16ae-56b7-489d-8d21-46429628b724",
        "voltage_2": 0.415,
        "nom_rating": 0.13,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "bsp_group_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "bsp_group_name": "finsbury market",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    }
]
 ukpn_lpn_primary_finsbury_market 51.5211529019176 -0.0829651236327095 lpn-s000000003428