LTDS Table 2b Three-winding Transformer

This resource view is not available at the moment. Click here for more information.

Download resource

Integrate this resource

Access this data via a web API. Further information in the CKAN API guide (opens in new tab).

Endpoints

The Data API can be accessed via the following actions of the CKAN action API.

Create
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_create

Update / Insert
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_upsert

Query
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search

Querying
First 5 results:
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=56033622-8ed7-4425-916c-82a030df4822&limit=5

Results containing 'jones':
https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=56033622-8ed7-4425-916c-82a030df4822&q=jones

Examples
  
    curl -X POST 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search' \
      -H "Content-Type: application/json" \
      -d '{
        "resource_id": "56033622-8ed7-4425-916c-82a030df4822",
        "limit": 5,
        "q": "jones"
      }'
  
  
    using System;
    using System.Net.Http;
    using System.Text;
    using System.Text.Json;
    using System.Threading.Tasks;

    var data = new {
      resource_id = "56033622-8ed7-4425-916c-82a030df4822", // the resource id
      limit = 5, // get 5 results
      q = "jones" // query for 'jones'
    };

    var url = "https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search";

    using var client = new HttpClient();
    var json = JsonSerializer.Serialize(data);
    var content = new StringContent(json, Encoding.UTF8, "application/json");

    try {
      var response = await client.PostAsync(url, content);
      response.EnsureSuccessStatusCode();
      var responseBody = await response.Content.ReadAsStringAsync();
      var result = JsonSerializer.Deserialize<JsonElement>(responseBody);
      Console.WriteLine($"Total results found: {result.GetProperty("result").GetProperty("total")}");
    } catch (HttpRequestException e) {
      Console.WriteLine($"Error fetching data: {e.Message}");
    }
  
  
    const data = {
      resource_id: '56033622-8ed7-4425-916c-82a030df4822', // the resource id
      limit: 5, // get 5 results
      q: 'jones' // query for 'jones'
    };

    const url = new URL('https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search');
    Object.keys(data).forEach(key => url.searchParams.append(key, data[key]));

    fetch(url)
      .then(response => response.json())
      .then(result => {
        console.log('Total results found: ' + result.result.total);
      })
      .catch(error => {
        console.error('Error fetching data:', error);
      });
  
  
    import urllib.request
    import urllib.error
    import json

    url = 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search?resource_id=56033622-8ed7-4425-916c-82a030df4822&limit=5&q=title:jones'  
    
    try:
        with urllib.request.urlopen(url) as response:
            data = json.loads(response.read().decode('utf-8'))
            print(f"Total results found: {data['result']['total']}")
    except urllib.error.URLError as e:
        print(f"Error fetching data: {e}")
  
  
    $data = [
      'resource_id' => '56033622-8ed7-4425-916c-82a030df4822', // the resource id
      'limit' => 5, // get 5 results
      'q' => 'jones' // query for 'jones'
    ];

    $url = 'https://connecteddata.nationalgrid.co.uk/api/3/action/datastore_search';

    $ch = curl_init($url);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_POST, true);
    curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($data));
    curl_setopt($ch, CURLOPT_HTTPHEADER, ['Content-Type: application/json']);

    $response = curl_exec($ch);
    $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
    curl_close($ch);

    if ($httpCode === 200) {
      $result = json_decode($response, true);
      echo "Total results found: " . $result['result']['total'];
    } else {
      echo "Error fetching data: HTTP " . $httpCode;
    }
  

Data Dictionary

Data Dictionary: Column definitions and metadata for this resource
Column Type Label Description Example
Emergency Rating numeric MVA

Forced / Emergency Rating of the transformer

78
GSP Group text Not provided- Not provided- Drakelow 132kV
Licence text Not provided-

Licence area for data

EMIDS
Max Tap numeric %

Maximum Tap Range

10
Method of Earthing text Not provided- Not provided- Solid/Resistor
Min Tap numeric %

Minimum Tap Range

-20
Node 1 text Not provided-

Busbar code at the higher voltage end of the transformer

BURT1_113A
Node 2 text Not provided-

Busbar code at one of the two Lower voltage ends of the transformer

BURT5_#1T0A
Node 3 text Not provided-

Busbar code at one of the two Lower voltage ends of the transformer

BURT5_#1T0B
Nominal Rating numeric MVA

Nominal Rating of the transformer

60
Operating Voltage 1 numeric kV Not provided- 132
Operating Voltage 2 numeric kV Not provided- 11
Operating Voltage 3 numeric kV Not provided- 11
R1 numeric % on 100MVA Base

Positive Sequence Resistance

1.5331
Reverse Power Capability text MVA where Numeric

Full, Partial or MVA

Not provided-
Status text Not provided-

New, Removed, Updated, or Unchanged

Updated
Vector Group text Not provided-

Transformer vector group

YNyn0yn0
X0 HV-LV numeric % on 100MVA Base

Zero Sequence Reactance

1003.562
X0 HV-Tertiary numeric % on 100MVA Base

Zero Sequence Reactance

1005.86
X0 LV-Tertiary numeric % on 100MVA Base

Zero Sequence Reactance

1066.604
X1 HV-LV numeric % on 100MVA Base

Positive Sequence Reactance

90.887
X1 HV-Tertiary numeric % on 100MVA Base

Positive Sequence Reactance

90.053
X1 LV-Tertiary numeric % on 100MVA Base

Positive Sequence Reactance

62.366