substation_types: 58

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
58 city road bsp lpn ukpn 
[
    "684be99b-db31-4fe0-8fb1-85db7d9795c2"
]
 
[
    11.11,
    132.0
]
 
[
    {
        "transformer_name": "t2",
        "transformer_id": "64a72e74-cdf3-4353-b2d5-33760535ff23",
        "node_1": "city1a",
        "node_id_1": "1c47e6a4-619f-45c9-bce4-5928acef5279",
        "voltage_1": 132.0,
        "node_2": "citb5a",
        "node_id_2": "3cfeb9dd-80a8-43b2-9303-2ee00a15c9bd",
        "voltage_2": 11.11,
        "node_3": "citb5b",
        "node_id_3": "1ae31df9-cb34-404c-b46d-8da249e1600f",
        "voltage_3": 11.11,
        "nom_rating": 60.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "684be99b-db31-4fe0-8fb1-85db7d9795c2",
        "substation_name": "city road"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "94c966e3-df34-4fc1-b597-849744ac430f",
        "node_1": "city1c",
        "node_id_1": "2529ed52-dc16-40b2-8975-72628b871673",
        "voltage_1": 132.0,
        "node_2": "citc5a",
        "node_id_2": "f5d006f7-907a-42e8-9257-46d550115126",
        "voltage_2": 11.11,
        "node_3": "citc5b",
        "node_id_3": "eadfc295-b242-4a17-a70c-2c0f422cf059",
        "voltage_3": 11.11,
        "nom_rating": 60.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "684be99b-db31-4fe0-8fb1-85db7d9795c2",
        "substation_name": "city road"
    },
    {
        "transformer_name": "t4",
        "transformer_id": "b1840601-345c-4bd9-b3f0-5fc81a1a9f36",
        "node_1": "city1d",
        "node_id_1": "6400335d-c1f6-4b47-aff6-ec9de487aae7",
        "voltage_1": 132.0,
        "node_2": "citc5c",
        "node_id_2": "b47ea6eb-c2b2-48e7-b990-de8362df9d2b",
        "voltage_2": 11.11,
        "node_3": "citc5d",
        "node_id_3": "954c5573-0842-404c-97fb-01b6418907af",
        "voltage_3": 11.11,
        "nom_rating": 76.0,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "684be99b-db31-4fe0-8fb1-85db7d9795c2",
        "substation_name": "city road"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "e00478c0-61a1-411c-9a70-2a147424c72d",
        "node_1": "city1b",
        "node_id_1": "78efb214-d023-432e-b167-936eb40b1025",
        "voltage_1": 132.0,
        "node_2": "citb5d",
        "node_id_2": "9efe8c71-4d1c-4d33-af11-672b5cd572fa",
        "voltage_2": 11.11,
        "node_3": "citb5c",
        "node_id_3": "acc0d8d4-d242-4ddb-9dd8-88164f00867e",
        "voltage_3": 11.11,
        "nom_rating": 60.6,
        "gsp_group_id": "bf368156-c887-45e7-828d-ec7b3f38dd80",
        "gsp_group_name": "06 - city road 132 kv gsp",
        "substation_id": "684be99b-db31-4fe0-8fb1-85db7d9795c2",
        "substation_name": "city road"
    }
]
 ukpn_lpn_bsp_city_road 51.5301825926568 -0.0957345663309726 lpn-s000000003413