home / primary / substation_types

substation_types: 32

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
32 barnes primary lpn ukpn
[
    "6c774275-644b-4ede-943e-0caa8f5af005"
]
[
    6.9,
    66.0
]
[
    {
        "transformer_name": "t3b",
        "transformer_id": "03b08c0c-1fd2-4968-8e15-ba5f7569a8b9",
        "node_1": "bnsb61",
        "node_id_1": "1c5ff5cb-4aaf-4a56-8655-040f5190c551",
        "voltage_1": 66.0,
        "node_2": "bnsb7a",
        "node_id_2": "65e57cb6-8547-4b9a-8386-527363aa17ba",
        "voltage_2": 6.9,
        "nom_rating": 30.0,
        "gsp_group_id": "dcf403f4-5966-477d-ad33-ca6a38c4be15",
        "gsp_group_name": "21 - wimbledon 3&4 132kv gsp",
        "bsp_group_id": "6c774275-644b-4ede-943e-0caa8f5af005",
        "bsp_group_name": "barnes",
        "substation_id": "6c774275-644b-4ede-943e-0caa8f5af005",
        "substation_name": "barnes"
    },
    {
        "transformer_name": "t4b",
        "transformer_id": "4db114bc-a47b-41bc-8e39-9c096416bbe9",
        "node_1": "bnsb62",
        "node_id_1": "133c87c7-b2c3-43a7-9f7b-58f9b98b8295",
        "voltage_1": 66.0,
        "node_2": "bnsb7b",
        "node_id_2": "2ecbbda2-1ec2-4079-afee-bdae89588214",
        "voltage_2": 6.9,
        "nom_rating": 30.0,
        "gsp_group_id": "dcf403f4-5966-477d-ad33-ca6a38c4be15",
        "gsp_group_name": "21 - wimbledon 3&4 132kv gsp",
        "bsp_group_id": "6c774275-644b-4ede-943e-0caa8f5af005",
        "bsp_group_name": "barnes",
        "substation_id": "6c774275-644b-4ede-943e-0caa8f5af005",
        "substation_name": "barnes"
    }
]
ukpn_lpn_primary_barnes 51.4701811475145 -0.258660815801242 lpn-s000000001008
Powered by Datasette · Queries took 13.087ms