substation_types: 82

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
82 finsbury market bsp lpn ukpn 
[
    "34a77ab3-1420-47d2-bccf-749d3244d16a"
]
 
[
    11.0,
    11.11,
    33.0,
    132.0
]
 
[
    {
        "transformer_name": "gt1c",
        "transformer_id": "07664487-05f6-450e-8fe5-bf7e4493f8ef",
        "node_1": "finf11",
        "node_id_1": "4371fe1e-2c35-419b-b8e8-1fb9fb90553b",
        "voltage_1": 132.0,
        "node_2": "finf31 r bb3(1)",
        "node_id_2": "65ed8998-1aef-44d8-8adc-eba46cbd62b6",
        "voltage_2": 33.0,
        "nom_rating": 90.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "gt3e",
        "transformer_id": "28832a4f-5e74-4b53-94ee-ec1375857c0b",
        "node_1": "fine13(1)",
        "node_id_1": "a19bb213-31dd-4a20-88ea-dbca21f2a377",
        "voltage_1": 132.0,
        "node_2": "fine51 f bb3(1)",
        "node_id_2": "14daba59-4b38-403d-bc39-0ab4c7c4194d",
        "voltage_2": 11.11,
        "node_3": "fine51 f bb2(1)",
        "node_id_3": "92c44f51-43df-4050-af23-412ade567af4",
        "voltage_3": 11.11,
        "nom_rating": 66.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "gt3a",
        "transformer_id": "47bfab32-3851-4924-bd90-c86583b2b5fc",
        "node_1": "finm12(1)",
        "node_id_1": "ceca2901-b033-4e83-9e86-83b0afc5bc4a",
        "voltage_1": 132.0,
        "node_2": "fina51 t bb1(1)",
        "node_id_2": "562dd1b4-9518-4821-ab87-72d1837105a4",
        "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",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "gt2e",
        "transformer_id": "4979a244-1b10-429c-99c4-f4f3a8f7b223",
        "node_1": "fine12(1)",
        "node_id_1": "8dc7d5df-1deb-4dd5-a508-02e15924d02a",
        "voltage_1": 132.0,
        "node_2": "fine53 r bb2(1)",
        "node_id_2": "b52b14a3-17f6-44ab-a4a4-c47bbb27b746",
        "voltage_2": 11.11,
        "node_3": "fine53 r bb3(1)",
        "node_id_3": "47dd33b4-c1aa-482b-bb61-a870913552c0",
        "voltage_3": 11.11,
        "nom_rating": 66.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "gt3b",
        "transformer_id": "5022cda8-bdad-4089-b269-6f18edce0bdb",
        "node_1": "finm12(2)",
        "node_id_1": "070d7b46-77d8-4c03-8951-b6befb94fa45",
        "voltage_1": 132.0,
        "node_2": "finb31 r bb1(2)",
        "node_id_2": "202284a4-a33b-48e3-a056-c365ccfe430a",
        "voltage_2": 33.0,
        "nom_rating": 45.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "gt1a",
        "transformer_id": "615f277d-fa35-49b9-936f-3df7b888e8a8",
        "node_1": "finm13(1)",
        "node_id_1": "39427fcd-8e71-413e-a084-0b9188edca91",
        "voltage_1": 132.0,
        "node_2": "fina51 t bb2(1)",
        "node_id_2": "bf50849f-a916-43de-9fc7-54ca73e45522",
        "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",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "gt2b",
        "transformer_id": "741d0acd-638c-4caf-878f-11b739b8f505",
        "node_1": "finm11(2)",
        "node_id_1": "dbe85ba6-893c-48b8-8042-bea1ffbf7a7f",
        "voltage_1": 132.0,
        "node_2": "finb31 f bb2(1)",
        "node_id_2": "eaeefb3c-59a4-4d89-a781-c0a2d06cbee5",
        "voltage_2": 33.0,
        "nom_rating": 45.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "gt1e",
        "transformer_id": "996e7896-6dac-4cdd-9909-fa9a63fcaeca",
        "node_1": "fine11(1)",
        "node_id_1": "62571916-6c79-44b9-a3aa-ba107b149d8f",
        "voltage_1": 132.0,
        "node_2": "fine52 f bb1(1)",
        "node_id_2": "335dc91a-5dec-4729-9a8d-a2fdbba61704",
        "voltage_2": 11.11,
        "node_3": "fine52 r bb1(1)",
        "node_id_3": "3db03ea4-4c2e-4af3-8902-01f7e8eb96a0",
        "voltage_3": 11.11,
        "nom_rating": 66.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "gt2a",
        "transformer_id": "c9e222e4-d6aa-4ae5-9418-e1c21ca9e373",
        "node_1": "finm11(1)",
        "node_id_1": "db4d6de3-4420-4852-b37b-5a963444b283",
        "voltage_1": 132.0,
        "node_2": "fina51 t bb2(2)",
        "node_id_2": "2ac1e001-77ab-4235-935a-cf5dfb603cf0",
        "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",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "gt2c",
        "transformer_id": "cafbf6c4-88a1-47a8-bbd6-214a1bc15f43",
        "node_1": "finf12",
        "node_id_1": "81bbefa7-fdf0-4244-8d52-c6a9db86ce30",
        "voltage_1": 132.0,
        "node_2": "finf31 r bb4(2)",
        "node_id_2": "5d570998-4a98-4eca-8d85-2871bede80c4",
        "voltage_2": 33.0,
        "nom_rating": 90.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "gt1b",
        "transformer_id": "df0efe6e-ceb6-4aab-806f-05dd9bf1db9e",
        "node_1": "finm13(3)",
        "node_id_1": "b5d4044e-7b8b-4d56-afea-afe15f27a5e9",
        "voltage_1": 132.0,
        "node_2": "finb32",
        "node_id_2": "720a7d23-42f2-43d7-8e88-123b7e34b011",
        "voltage_2": 33.0,
        "nom_rating": 45.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    },
    {
        "transformer_name": "gt3c",
        "transformer_id": "ed0f08ed-4bd5-4904-b3f7-4a331ed80501",
        "node_1": "finf13",
        "node_id_1": "a6d7e325-8db2-41b8-9b7c-938c1afe3b7e",
        "voltage_1": 132.0,
        "node_2": "finf31 r bb3(3)",
        "node_id_2": "677e36e0-7d05-4f70-a1d8-49d256f7a067",
        "voltage_2": 33.0,
        "nom_rating": 90.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "34a77ab3-1420-47d2-bccf-749d3244d16a",
        "substation_name": "finsbury market"
    }
]
 ukpn_lpn_bsp_finsbury_market 51.5211529019176 -0.0829651236327095 lpn-s000000003428