substation_types: 64

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
64 deptford bsp lpn ukpn 
[
    "00e0c808-597e-43da-91de-db48c245e398"
]
 
[
    11.11,
    132.0
]
 
[
    {
        "transformer_name": "gt2",
        "transformer_id": "1048bd9f-0c38-47f7-9c51-de0695d649e9",
        "node_1": "dept11 bb2(1)",
        "node_id_1": "4edd013e-09d6-44bb-8955-01d4b9428b09",
        "voltage_1": 132.0,
        "node_2": "depd52 bb4(1)",
        "node_id_2": "1883b079-0974-4405-b024-7d479e85424c",
        "voltage_2": 11.11,
        "node_3": "depd52 bb3(1)",
        "node_id_3": "bf89e19c-4f76-42f3-9f16-3a0ddab70eb0",
        "voltage_3": 11.11,
        "nom_rating": 66.6,
        "gsp_group_id": "6f49c534-d05c-4831-b97f-72931e320ba1",
        "gsp_group_name": "13 - new cross 132kv gsp",
        "substation_id": "00e0c808-597e-43da-91de-db48c245e398",
        "substation_name": "deptford grid"
    },
    {
        "transformer_name": "gt1",
        "transformer_id": "2ac4c7ba-9720-4a0b-a3e8-1ff9b1ac060a",
        "node_1": "dept11 bb1(1)",
        "node_id_1": "6e1071f2-3aa1-4581-ad33-e1dfc5ef136a",
        "voltage_1": 132.0,
        "node_2": "depd51 bb2(1)",
        "node_id_2": "2a22f0dc-c23f-46ef-b2dd-3f09371e8344",
        "voltage_2": 11.11,
        "node_3": "depd51 bb1(2)",
        "node_id_3": "147f6973-961c-41f4-84b8-4f78f8387e40",
        "voltage_3": 11.11,
        "nom_rating": 66.6,
        "gsp_group_id": "6f49c534-d05c-4831-b97f-72931e320ba1",
        "gsp_group_name": "13 - new cross 132kv gsp",
        "substation_id": "00e0c808-597e-43da-91de-db48c245e398",
        "substation_name": "deptford grid"
    },
    {
        "transformer_name": "gt4b",
        "transformer_id": "5cea9a47-41ff-4cc7-a90d-36b391728305",
        "node_1": "degr1a",
        "node_id_1": "3f11efc5-98b5-45b8-986d-79ca66108a0e",
        "voltage_1": 132.0,
        "node_2": "depd53 bb6(1)",
        "node_id_2": "c409bd11-7749-43e9-b61a-642033335a6e",
        "voltage_2": 11.11,
        "node_3": "depd53 bb5(1)",
        "node_id_3": "863de5bf-f888-4bbf-bce4-d9445729fb4c",
        "voltage_3": 11.11,
        "nom_rating": 66.6,
        "gsp_group_id": "6f49c534-d05c-4831-b97f-72931e320ba1",
        "gsp_group_name": "13 - new cross 132kv gsp",
        "substation_id": "00e0c808-597e-43da-91de-db48c245e398",
        "substation_name": "deptford grid"
    }
]
 ukpn_lpn_bsp_deptford 51.4846145395064 -0.0232988938090129 lpn-s000000003726