home / master_data / transmission_circuits

transmission_circuits: 90

This data as json

rowid node_1 node_2 circuit_length equipment summer_rating source licence year status voltage rating node_1_substation_id source_id node_1_location site_code voltages node_1_name node_1_type source_node_1 licence_node_1 transformer_id transformers transformer_count retain_edits longitude latitude node_2_substation_id source_id_node_2 node_2_location site_code_node_2 voltages_node_2 node_2_name node_2_type source_node_2 licence_node_2 transformer_id_node_2 transformers_node_2 transformer_count_node_2 retain_edits_node_2 longitude_node_2 latitude_node_2 circuit_id is_ignored
90 brim2b walx22 0.0 ohl 925.0 eso nget 2024 current 275.0 925.0 eso_nget_gsp_brimsdown "brim2" brimsdown brim "[132.0, 275.0, 400.0]" brimsdown gsp eso nget
[
    "eso_nget_transformer_104",
    "eso_nget_transformer_106",
    "eso_nget_transformer_108",
    "eso_nget_transformer_109",
    "eso_nget_transformer_110",
    "eso_nget_transformer_103",
    "eso_nget_transformer_105",
    "eso_nget_transformer_107"
]
"[{\"transformer_id\": [\"eso_nget_transformer_103\", \"eso_nget_transformer_104\", \"eso_nget_transformer_105\", \"eso_nget_transformer_106\", \"eso_nget_transformer_107\", \"eso_nget_transformer_108\"], \"node_1\": [\"brim2\"], \"voltage_1\": 275.0, \"node_2\": [\"brim1\"], \"voltage_2\": 132.0, \"nom_rating\": [263.0, 274.0, 262.0, 262.0, 262.0, 262.0], \"transformer_count\": 6, \"year\": [2024.0, 2024.0, 2024.0, 2024.0, 2027.0, 2027.0], \"status\": [\"current\", \"current\", \"current\", \"current\", \"removed\", \"removed\"]}, {\"transformer_id\": [\"eso_nget_transformer_109\", \"eso_nget_transformer_110\"], \"node_1\": [\"brim4\"], \"voltage_1\": 400.0, \"node_2\": [\"brim1\"], \"voltage_2\": 132.0, \"nom_rating\": [262.0, 262.0], \"transformer_count\": 2, \"year\": [2027.0, 2027.0], \"status\": [\"addition\", \"addition\"]}]" 6.0 0 -0.023315142383944023 51.66447137612734 eso_nget_gsp_walthamcross walx2 waltham cross walx
[
    275.0,
    400.0
]
waltham cross gsp eso nget
[
    "eso_nget_transformer_893",
    "eso_nget_transformer_890",
    "eso_nget_transformer_886",
    "eso_nget_transformer_891",
    "eso_nget_transformer_894",
    "eso_nget_transformer_887",
    "eso_nget_transformer_889",
    "eso_nget_transformer_895",
    "eso_nget_transformer_892",
    "eso_nget_transformer_888"
]
[
    {
        "transformer_id": [
            "eso_nget_transformer_886",
            "eso_nget_transformer_887",
            "eso_nget_transformer_888",
            "eso_nget_transformer_889",
            "eso_nget_transformer_890",
            "eso_nget_transformer_891",
            "eso_nget_transformer_892",
            "eso_nget_transformer_893",
            "eso_nget_transformer_894",
            "eso_nget_transformer_895"
        ],
        "node_1": [
            "walx4"
        ],
        "voltage_1": 400.0,
        "node_2": [
            "walx2"
        ],
        "voltage_2": 275.0,
        "nom_rating": [
            1136.0,
            1136.0,
            1137.0,
            1137.0,
            1136.0,
            1136.0,
            1136.0,
            1136.0,
            1137.0,
            1137.0
        ],
        "transformer_count": 10,
        "year": [
            2024.0,
            2024.0,
            2024.0,
            2024.0,
            2027.0,
            2027.0,
            2027.0,
            2027.0,
            2027.0,
            2027.0
        ],
        "status": [
            "current",
            "current",
            "current",
            "current",
            "addition",
            "addition",
            "removed",
            "removed",
            "removed",
            "removed"
        ]
    }
]
2.0 0.0 -0.011573075351718577 51.71392212484482 eso_circuit_89 0
Powered by Datasette · Queries took 2.067ms