{"links": [{"rel": "self", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ltds-table-2b-transformer-data-3w"}, {"rel": "datasets", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets"}, {"rel": "attachments", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ltds-table-2b-transformer-data-3w/attachments"}, {"rel": "reuses", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ltds-table-2b-transformer-data-3w/reuses"}, {"rel": "static_exports", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ltds-table-2b-transformer-data-3w/static_exports"}], "dataset": {"visibility": "domain", "dataset_id": "ltds-table-2b-transformer-data-3w", "dataset_uid": "da_wokdgi", "has_records": true, "features": ["analyze"], "attachments": [{"id": "data_triage_long_term_development_statement_xlsx", "title": "Data Triage - Long Term Development Statement.xlsx", "mimetype": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "url": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ltds-table-2b-transformer-data-3w/attachments/data_triage_long_term_development_statement_xlsx"}], "alternative_exports": [], "data_visible": false, "fields": [{"name": "gridsupplypoint", "description": "This is the point of delivery from the transmission system to a distribution system", "annotations": {"sortable": true, "facet": true, "facetsort": "alphanum"}, "label": "GridSupplyPoint", "type": "text"}, {"name": "hv_node", "description": null, "annotations": {"sortable": true, "facet": true, "facetsort": "alphanum"}, "label": "HV_Node", "type": "text"}, {"name": "hv_substation", "description": "The Name of the Site as per the UK Power Networks Control and Asset Management System", "annotations": {"sortable": true, "facet": true, "facetsort": "alphanum"}, "label": "HV_Substation", "type": "text"}, {"name": "voltage_hv", "description": "Highest voltage on the site", "annotations": {"facet": true, "unit": "kV", "facetsort": "-count"}, "label": "Voltage_HV (kV)", "type": "text"}, {"name": "lv_node_1", "description": null, "annotations": {}, "label": "LV_Node_1", "type": "text"}, {"name": "lv_substation_1", "description": "The Name of the Site as per the UK Power Networks Control and Asset Management System", "annotations": {}, "label": "LV_Substation_1", "type": "text"}, {"name": "voltage_lv_1", "description": "Highest voltage on the LV1 site", "annotations": {"unit": "kV", "facet": true, "facetsort": "-count"}, "label": "Voltage_LV_1 (kV)", "type": "text"}, {"name": "lv_node_2", "description": null, "annotations": {"sortable": true}, "label": "LV_Node_2", "type": "text"}, {"name": "lv_substation_2", "description": "The Name of the Site as per the UK Power Networks Control and Asset Management System", "annotations": {"sortable": true}, "label": "LV_Substation_2", "type": "text"}, {"name": "voltage_lv_2", "description": "Highest voltage on the LV2 site", "annotations": {"unit": "kV", "facet": true, "facetsort": "-count"}, "label": "Voltage_LV_2 (kV)", "type": "text"}, {"name": "vector_group_hv", "description": "Vector Group HV Side", "annotations": {"sortable": true}, "label": "Vector_Group_HV", "type": "text"}, {"name": "vector_group_lv1", "description": "Vector Group LV Side Winding 1", "annotations": {}, "label": "Vector_Group_LV1", "type": "text"}, {"name": "vector_group_lv2", "description": "Vector Group LV Side Winding 2", "annotations": {}, "label": "Vector_Group_LV2", "type": "text"}, {"name": "positive_sequence_impedance_r_hv_lv1_percent", "description": "Tx Positive Sequence Resistance HV to LV Winding 1", "annotations": {"unit": "%"}, "label": "Positive_Sequence_Impedance_R_HV_LV1_Percent", "type": "double"}, {"name": "positive_sequence_impedance_r_hv_lv2_percent", "description": "Tx Positive Sequence Resistance HV to LV Winding 2", "annotations": {"unit": "%"}, "label": "Positive_Sequence_Impedance_R_HV_LV2_Percent", "type": "double"}, {"name": "positive_sequence_impedance_r_lv1_lv2_percent", "description": "Tx Positive Sequence Resistance LV Winding 1 to LV Winding 2", "annotations": {"unit": "%"}, "label": "Positive_Sequence_Impedance_R_LV1_LV2_Percent", "type": "double"}, {"name": "positive_sequence_impedance_x_hv_lv1_percent", "description": null, "annotations": {}, "label": "Positive_Sequence_Impedance_X_HV_LV1_Percent", "type": "double"}, {"name": "positive_sequence_impedance_x_lv1_lv2_percent", "description": null, "annotations": {}, "label": "Positive_Sequence_Impedance_X_LV1_LV2_Percent", "type": "double"}, {"name": "positive_sequence_impedance_x_hv_lv2_percent", "description": null, "annotations": {}, "label": "Positive_Sequence_Impedance_X_HV_LV2_Percent", "type": "double"}, {"name": "zero_sequence_impedance_x_hv_lv1_percent", "description": "Tx Zero Sequence Reactance HV Winding to LV Winding 1", "annotations": {"unit": "%"}, "label": "Zero_Sequence_Impedance_X_HV_LV1_Percent", "type": "double"}, {"name": "zero_sequence_impedance_x_hv_lv2_percent", "description": "Tx Zero Sequence Reactance HV Winding to LV Winding 2", "annotations": {"unit": "%"}, "label": "Zero_Sequence_Impedance_X_HV_LV2_Percent", "type": "double"}, {"name": "zero_sequence_impedance_x_lv1_lv2_percent", "description": "Tx Zero Sequence Reactance LV Winding 1 to LV Winding 2", "annotations": {"unit": "%"}, "label": "Zero_Sequence_Impedance_X_LV1_LV2_Percent", "type": "double"}, {"name": "tap_range_min_percent_hv", "description": "Minimum HV Tx Tap Range", "annotations": {"unit": "%"}, "label": "Tap_Range_Min_Percent_HV", "type": "int"}, {"name": "tap_range_min_percent_lv1", "description": "Minimum LV1 Tx Tap Range", "annotations": {"unit": "%"}, "label": "Tap_Range_Min_Percent_LV1", "type": "int"}, {"name": "tap_range_min_percent_lv2", "description": "Minimum LV2 Tx Tap Range", "annotations": {"unit": "%"}, "label": "Tap_Range_Min_Percent_LV2", "type": "int"}, {"name": "tap_range_max_percent_hv", "description": "Maximum HV Tx Tap Range", "annotations": {"unit": "%"}, "label": "Tap_Range_Max_Percent_HV", "type": "int"}, {"name": "tap_range_max_percent_lv1", "description": "Maximum LV1 Tx Tap Range", "annotations": {"unit": "%"}, "label": "Tap_Range_Max_Percent_LV1", "type": "int"}, {"name": "tap_range_max_percent_lv2", "description": "Maximum LV2 Tx Tap Range", "annotations": {"unit": "%"}, "label": "Tap_Range_Max_Percent_LV2", "type": "int"}, {"name": "transformer_rating_mva_summer_hv", "description": "Tx HV Rating Summer", "annotations": {}, "label": "Transformer_Rating_MVA_Summer_HV", "type": "int"}, {"name": "transformer_rating_mva_winter_hv", "description": "Tx HV Rating Winter", "annotations": {}, "label": "Transformer_Rating_MVA_Winter_HV", "type": "int"}, {"name": "transformer_rating_mva_summer_lv1", "description": "Tx LV1 Rating Summer", "annotations": {}, "label": "Transformer_Rating_MVA_Summer_LV1", "type": "int"}, {"name": "transformer_rating_mva_winter_lv1", "description": "Tx LV1 Rating Winter", "annotations": {}, "label": "Transformer_Rating_MVA_Winter_LV1", "type": "int"}, {"name": "transformer_rating_mva_summer_lv2", "description": "Tx LV2 Rating Summer", "annotations": {}, "label": "Transformer_Rating_MVA_Summer_LV2", "type": "int"}, {"name": "transformer_rating_mva_winter_lv2", "description": "Tx LV2 Rating Winter", "annotations": {}, "label": "Transformer_Rating_MVA_Winter_LV2", "type": "int"}, {"name": "reverse_power_capability_percent", "description": "Reverse Power Capability", "annotations": {"facetsort": "-count"}, "label": "Reverse_Power_Capability_Percent", "type": "text"}, {"name": "method_of_earthing_hv", "description": "Tx HV Side Earth Method", "annotations": {"sortable": true, "facet": true}, "label": "Method_of_Earthing_HV", "type": "text"}, {"name": "method_of_earthing_lv1", "description": "Tx LV1 Side Earth Method", "annotations": {"facet": true}, "label": "Method_of_Earthing_LV1", "type": "text"}, {"name": "method_of_earthing_lv2", "description": "Tx LV2 Side Earth Method", "annotations": {"sortable": true, "facet": true}, "label": "Method_of_Earthing_LV2", "type": "text"}, {"name": "sitefunctionallocation", "description": "Unique Site Reference", "annotations": {}, "label": "SiteFunctionalLocation", "type": "text"}, {"name": "licencearea", "description": "This holds the Licence Area or DNO (Distribution Network Operator) name", "annotations": {"sortable": true, "facet": true, "facetsort": "alphanum"}, "label": "LicenceArea", "type": "text"}, {"name": "id", "description": "Row Number", "annotations": {}, "label": "ID", "type": "int"}], "metas": {"dcat": {"created": null, "issued": null, "creator": null, "contributor": null, "contact_name": null, "contact_email": null, "accrualperiodicity": null, "spatial": null, "temporal": null, "granularity": null, "dataquality": null, "publisher_type": null, "conforms_to": null, "temporal_coverage_start": null, "temporal_coverage_end": null, "accessRights": null, "relation": null}, "inspire": {"theme": null, "type": null, "file_identifier": null, "hierarchy_level": null, "hierarchy_level_name": null, "spatial_resolution": null, "topologic_consistency": null, "contact_individual_name": null, "contact_position": null, "contact_address": null, "contact_email": null, "identification_purpose": null, "extend_description": null, "extend_bounding_box_westbound_longitude": null, "extend_bounding_box_eastbound_longitude": null, "extend_bounding_box_southbound_latitude": null, "extend_bounding_box_northbound_latitude": null}, "default": {"title": "Long Term Development Statement (LTDS) Table 2b Transformer Data - 3W", "description": "<h2>Introduction</h2>\n<p class=\"standard-text\">The Long Term Development Statements (LTDS) report on a 0-5 year period, describing a forecast of load on the network and envisioned network developments. The LTDS is published at the end of May and November each year.</p>\n<p class=\"standard-text\">This is Table 2b from our current LTDS report (published 28 November 2025), showing the Transformer information for three winding (1x High Voltage, 2x Low Voltage) transformers associated to each Grid and Primary substation where applicable.</p>\n<p class=\"standard-text\">More information and full reports are available from the landing page below:<br>\n<a class=\"standard-link\" href=\"https://ukpowernetworks.opendatasoft.com/pages/ltds_ndp_landingpage/\">Long Term Development Statement and Network Development Plan Landing Page</a></p>\n\n<h2>Methodological Approach</h2>\n<ul class=\"standard-text\">\n  <li>Site Functional Locations (FLOCs) are used to associate the Substation which the transformer is located to <a class=\"standard-link\" href=\"https://ukpowernetworks.opendatasoft.com/explore/dataset/grid-and-primary-sites/information/?disjunctive.powertransformercount&amp;disjunctive.local_authority\" target=\"_blank\">Key characteristics of active Grid and Primary sites \u2014 UK Power Networks</a></li>\n  <li>ID field added to identify row number for reference purposes</li>\n</ul>\n\n<h2>Quality Control Statement</h2>\n<p class=\"standard-text\">Quality Control Measures include:</p>\n<ul class=\"standard-text\">\n  <li>Verification steps to match features only with confirmed functional locations.</li>\n  <li>Manual review and correction of data inconsistencies.</li>\n  <li>Use of additional verification steps to ensure accuracy in the methodology.</li>\n</ul>\n\n<h2>Assurance Statement</h2>\n<p class=\"standard-text\">The Open Data Team and Network Insights Team worked together to ensure data accuracy and consistency.</p>\n\n<h2>Other</h2>\n<p class=\"standard-text\">Download dataset information: <a class=\"standard-link\" href=\"https://ukpowernetworks.opendatasoft.com/explore/dataset/domain-dataset0/download/?format=json&amp;refine.identifier=ltds-table-2b-transformer-data-3w\">Metadata (JSON)</a></p>\n<p class=\"standard-text\">Definitions of key terms related to this dataset can be found in the Open Data Portal Glossary: <a href=\"https://ukpowernetworks.opendatasoft.com/pages/glossary/\" target=\"_blank\">https://ukpowernetworks.opendatasoft.com/pages/glossary/</a><a class=\"standard-link\" href=\"https://ukpowernetworks.opendatasoft.com/pages/glossary/\" target=\"_blank\"></a></p><p class=\"standard-text\">To view this data please register and login.</p>", "theme": ["Network Infrastructure"], "keyword": null, "license": "CC BY 4.0", "license_url": "https://creativecommons.org/licenses/by/4.0/", "language": "en", "metadata_languages": ["en"], "timezone": null, "modified": "2025-11-28T08:28:36.080000+00:00", "modified_updates_on_metadata_change": false, "modified_updates_on_data_change": true, "data_processed": "2025-11-28T08:28:36.080000+00:00", "metadata_processed": "2025-11-28T08:28:36.148000+00:00", "geographic_reference": null, "geographic_reference_auto": false, "territory": null, "geometry_types": null, "bbox": null, "publisher": "UK Power Networks, Company number 3870728", "references": null, "records_count": 142, "attributions": null, "source_domain": null, "source_domain_title": null, "source_domain_address": null, "source_dataset": null, "shared_catalog": null, "federated": false, "parent_domain": null, "update_frequency": ["ANNUAL_2"]}, "dublin-core": {"title": "Long Term Development Statement (LTDS) Table 2b Transformer Data - 3W", "alternative": null, "subject": ["Transformers", "Distribution System Operator (DSO)", "Grid Substation", "Primary Substation", "Long Term Development Statements (LTDS)", "Extra High Voltage (EHV)"], "description": "<h2>Introduction</h2>\n<p class=\"standard-text\">The Long Term Development Statements (LTDS) report on a 0-5 year period, describing a forecast of load on the network and envisioned network developments. The LTDS is published at the end of May and November each year.</p>\n<p class=\"standard-text\">This is Table 2b from our current LTDS report (published 28 November 2025), showing the Transformer information for three winding (1x High Voltage, 2x Low Voltage) transformers associated to each Grid and Primary substation where applicable.</p>\n<p class=\"standard-text\">More information and full reports are available from the landing page below:<br>\n<a class=\"standard-link\" href=\"https://ukpowernetworks.opendatasoft.com/pages/ltds_ndp_landingpage/\">Long Term Development Statement and Network Development Plan Landing Page</a></p>\n\n<h2>Methodological Approach</h2>\n<ul class=\"standard-text\">\n  <li>Site Functional Locations (FLOCs) are used to associate the Substation which the transformer is located to <a class=\"standard-link\" href=\"https://ukpowernetworks.opendatasoft.com/explore/dataset/grid-and-primary-sites/information/?disjunctive.powertransformercount&amp;disjunctive.local_authority\" target=\"_blank\">Key characteristics of active Grid and Primary sites \u2014 UK Power Networks</a></li>\n  <li>ID field added to identify row number for reference purposes</li>\n</ul>\n\n<h2>Quality Control Statement</h2>\n<p class=\"standard-text\">Quality Control Measures include:</p>\n<ul class=\"standard-text\">\n  <li>Verification steps to match features only with confirmed functional locations.</li>\n  <li>Manual review and correction of data inconsistencies.</li>\n  <li>Use of additional verification steps to ensure accuracy in the methodology.</li>\n</ul>\n\n<h2>Assurance Statement</h2>\n<p class=\"standard-text\">The Open Data Team and Network Insights Team worked together to ensure data accuracy and consistency.</p>\n\n<h2>Other</h2>\n<p class=\"standard-text\">Download dataset information: <a class=\"standard-link\" href=\"https://ukpowernetworks.opendatasoft.com/explore/dataset/domain-dataset0/download/?format=json&amp;refine.identifier=ltds-table-2b-transformer-data-3w\">Metadata (JSON)</a></p>\n<p class=\"standard-text\">Definitions of key terms related to this dataset can be found in the Open Data Portal Glossary: <a href=\"https://ukpowernetworks.opendatasoft.com/pages/glossary/\" target=\"_blank\">https://ukpowernetworks.opendatasoft.com/pages/glossary/</a><a class=\"standard-link\" href=\"https://ukpowernetworks.opendatasoft.com/pages/glossary/\" target=\"_blank\"></a></p><p class=\"standard-text\">To view this data please register and login.</p>", "abstract": null, "tableOfContent": null, "type": ["Dataset"], "language": ["eng"], "coverage": null, "spatial": "EPN= Eastern Power Networks; SPN= South Eastern Power Networks; LPN= London Power Networks", "temporal_start": null, "temporal_end": null, "relation": "https://ukpowernetworks.opendatasoft.com/explore/dataset/ukpn-ltds-infrastructure-projects/information/; https://ukpowernetworks.opendatasoft.com/explore/dataset/ltds-table-1-circuit-data/information/?disjunctive.licencearea; https://ukpowernetworks.opendatasoft.com/explore/dataset/ltds-table-2a-transformer-2w/information/?disjunctive.voltage_hv; https://ukpowernetworks.opendatasoft.com/explore/dataset/ltds-table-3a-load-data-observed/information/?disjunctive.year; https://ukpowernetworks.opendatasoft.com/explore/dataset/ltds-table-3b-load-data-true/information/?disjunctive.season; https://ukpowernetworks.opendatasoft.com/explore/dataset/ltds-table-4a-3ph-fault-level/information/?disjunctive.licencearea&disjunctive.sitevoltage; https://ukpowernetworks.opendatasoft.com/explore/dataset/ltds-table-4b-earth-fault-level/information/?disjunctive.licencearea&disjunctive.sitevoltage; https://ukpowernetworks.opendatasoft.com/explore/dataset/ltds-table-5-generation/information/?disjunctive.licencearea&disjunctive.voltage&disjunctive.fueltype&disjunctive.connectionstatus; https://ukpowernetworks.opendatasoft.com/explore/dataset/ltds-table-6-interest-connections/information/; https://ukpowernetworks.opendatasoft.com/explore/dataset/ltds-table-7-operational-restrictions/information/; https://ukpowernetworks.opendatasoft.com/explore/dataset/ltds-table-8-gt-95-perc-fault-data/information/", "source": "https://ukpowernetworks.opendatasoft.com/", "replaces": null, "references": null, "requires": null, "conformsTo": null, "hasFormat": null, "hasPart": null, "hasVersion": null, "isFormatOf": null, "isPartOf": null, "isVersionOf": null, "isReferencedBy": null, "isReplacedBy": null, "isRequiredBy": null, "contributor": null, "creator": "UK Power Networks, Company number 3870728", "publisher": "UK Power Networks, Company number 3870728", "rights": null, "accessRights": ["Open"], "license": "CC BY 4.0", "date_start": null, "date_end": null, "available_start": null, "available_end": null, "created": null, "dateAccepted": null, "dateCopyrighted": null, "dateSubmitted": null, "issued": "2021-10-06T00:00:00+00:00", "modified": "2025-11-28T08:28:36.080000+00:00", "valid_start": null, "valid_end": null, "format": ["application/json", "text/csv", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"], "extent": null, "medium": null, "identifier": null, "bibliographicCitation": null, "rightsHolder": null, "accrualMethod": null, "accrualPeriodicity": null, "accrualPolicy": null, "audience": null, "educationLevel": null, "instructionalMethod": null, "mediator": null, "provenance": null}}}}