substation_types: 93

This data as json

rowid location type licence source substation_ids voltages transformers substation_type_id latitude longitude source_id
93 hackney primary lpn ukpn 
[
    "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a"
]
 
[
    0.415,
    6.6,
    66.0
]
 
[
    {
        "transformer_name": "t1_a",
        "transformer_id": "0c93080d-eda3-48fd-9d27-826d2687c812",
        "node_1": "hacc7a",
        "node_id_1": "a4e6fb41-eb27-4f31-83cf-da689aa09483",
        "voltage_1": 6.6,
        "node_2": "3085 hacb9t3_",
        "node_id_2": "f4723670-c611-4b27-b327-2b5474bbab01",
        "voltage_2": 0.415,
        "nom_rating": 0.5,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "bsp_group_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "bsp_group_name": "hackney supergrid",
        "substation_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "substation_name": "hackney supergrid"
    },
    {
        "transformer_name": "t3_a",
        "transformer_id": "23eea779-e562-479c-9d42-95f723711067",
        "node_1": "hacc7c",
        "node_id_1": "0c1e0b94-91ab-48d2-8561-2831d8fec814",
        "voltage_1": 6.6,
        "node_2": "3083 hacb9t1_",
        "node_id_2": "874441e3-e69f-43bc-8105-6965f0579aeb",
        "voltage_2": 0.415,
        "nom_rating": 0.5,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "bsp_group_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "bsp_group_name": "hackney supergrid",
        "substation_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "substation_name": "hackney supergrid"
    },
    {
        "transformer_name": "t1",
        "transformer_id": "861ff7cd-46c5-457c-9b26-ab4723bdfb06",
        "node_1": "hacb61",
        "node_id_1": "f63ad211-2609-4d86-896d-7f379cde0482",
        "voltage_1": 66.0,
        "node_2": "hacc7c",
        "node_id_2": "0c1e0b94-91ab-48d2-8561-2831d8fec814",
        "voltage_2": 6.6,
        "nom_rating": 30.0,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "bsp_group_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "bsp_group_name": "hackney supergrid",
        "substation_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "substation_name": "hackney supergrid"
    },
    {
        "transformer_name": "t2_a",
        "transformer_id": "97e3e4d9-dcb8-4520-84c6-f35656c53d36",
        "node_1": "hacc7b",
        "node_id_1": "0c654e18-640d-44d1-91d2-e8ff21071e14",
        "voltage_1": 6.6,
        "node_2": "3084 hacb9t2_",
        "node_id_2": "48561b6e-182c-40ed-ae04-cff9f25d5519",
        "voltage_2": 0.415,
        "nom_rating": 0.5,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "bsp_group_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "bsp_group_name": "hackney supergrid",
        "substation_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "substation_name": "hackney supergrid"
    },
    {
        "transformer_name": "t3",
        "transformer_id": "9ed9cda6-fb31-4b89-8cf2-a4445727acc2",
        "node_1": "hacb63",
        "node_id_1": "377d477a-fcd4-4e8f-9e74-6c7191936e09",
        "voltage_1": 66.0,
        "node_2": "hacc7a",
        "node_id_2": "a4e6fb41-eb27-4f31-83cf-da689aa09483",
        "voltage_2": 6.6,
        "nom_rating": 30.0,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "bsp_group_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "bsp_group_name": "hackney supergrid",
        "substation_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "substation_name": "hackney supergrid"
    },
    {
        "transformer_name": "t2",
        "transformer_id": "bbfa849d-e58c-4251-91b5-cefd800db191",
        "node_1": "hacb62",
        "node_id_1": "6deaa01c-6caa-4dc1-8e53-3cc867163536",
        "voltage_1": 66.0,
        "node_2": "hacc7b",
        "node_id_2": "0c654e18-640d-44d1-91d2-e8ff21071e14",
        "voltage_2": 6.6,
        "nom_rating": 35.0,
        "gsp_group_id": "27f43fe3-a93e-4a72-9662-5bb936b49b78",
        "gsp_group_name": "08 - hackney 132kv gsp",
        "bsp_group_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "bsp_group_name": "hackney supergrid",
        "substation_id": "fc09b3c7-23eb-4f2b-8cdb-4f80d91ae33a",
        "substation_name": "hackney supergrid"
    }
]
 ukpn_lpn_primary_hackney 51.558880955487 -0.0423838561875229 lpn-s000000003436