intermediate

Tables

enw_distribution_substations

name, type, longitude, latitude, date_published, source, licence, retain_edits, location, substation_id

440 rows

enw_distribution_transformers

gsp_group, node_1, voltage_node_1, node_2, voltage_node_2, nom_rating, date_published, source, licence, retain_edits, type, bsp_group, eme_rating, location, transformer_id, name

839 rows

eso_transmission_substations

name, source_id, location, type, source, latitude, longitude, date_published, substation_id, retain_edits

736 rows

site_code, name, voltage, source, location, all_voltage, type, node_1, node_2, voltage_node_1, voltage_node_2, year, nom_rating, status, substation_id, source_node_1, source_node_2, transformer_id, retain_edits

1,929 rows

metadata

date, host, user, git_commit_id, git_branch

1 row

nged_distribution_substations

name, type, longitude, latitude, date_published, source, retain_edits, licence, location, substation_id

1,964 rows

nged_distribution_transformers

licence, gsp_group, node_1, voltage_node_1, node_2, voltage_node_2, transformer_status, nom_rating, eme_rating, date_published, source, retain_edits, name, bsp_group, location, type, transformer_id

3,085 rows

npg_distribution_substations

name, type, longitude, latitude, date_published, source, retain_edits, licence, location, substation_id

847 rows

npg_distribution_transformers

node_1, voltage_node_1, node_2, voltage_node_2, nom_rating, gsp_group, date_published, source, licence, retain_edits, location, type, transformer_id

1,211 rows

spen_distribution_substations

name, date_published, source, licence, retain_edits, latitude, longitude, type, location, substation_id

1,198 rows

spen_distribution_transformers

bsp_group, name, node_1, voltage_node_1, node_2, voltage_node_2, nom_rating, date_published, source, licence, retain_edits, type, gsp_group, location, transformer_id

1,675 rows

sse_distribution_substations

name, type, longitude, latitude, date_published, source, licence, retain_edits, location, substation_id

1,043 rows

sse_distribution_transformers

bsp_group, node_1, voltage_node_1, node_2, voltage_node_2, nom_rating, date_published, source, licence, retain_edits, name, gsp_group, type, location, transformer_id, eme_rating

1,864 rows

ukpn_distribution_substations

licence, name, longitude, latitude, date_published, source, retain_edits, location, type, substation_id

1,179 rows

ukpn_distribution_transformers

licence, gsp_group, node_1, voltage_node_1, node_2, voltage_node_2, source_id, eme_rating, nom_rating, date_published, source, retain_edits, type, location, transformer_id

2,174 rows