intermediate
Tables schema
cim_circuits
circuit_id, circuit_name, source, licence, equipment, node_id_1, node_id_2, node_name_1, node_name_2, substation_id_1, substation_id_2, substation_name_1, substation_name_2, rating, circuit_length, normally_open, voltage, gsp_group_id, gsp_group_name
>10,000 rows
cim_transformers
transformer_id, transformer_name, source, node_id_1, node_id_2, node_id_3, gsp_group_id, gsp_group_name, bsp_group_id, substation_id, bsp_group_name, substation_name, node_1, node_2, node_3, nom_rating, voltage_1, voltage_2, voltage_3, transformer_type, licence
9,080 rows
ecr
customer_name, customer_site, address_line_1, address_line_2, city, county, postcode, gsp, bsp, primary, voltage, licence, energy_source, connection_status, connected_export, date_connected, accepted_export, accepted_import, date_accepted, longitude, latitude, source, gsp_location, bsp_location, primary_location, ecr_project_id, country
>10,000 rows
repd
repd_project_id, operator, site_name, technology_type, installed_capacity, development_status, address, county, region, country, postcode, longitude, latitude, planning_authority, date_permission_granted, date_under_construction, date_operational, source, location
>10,000 rows
substations
substation_id, substation_name, source, licence, type, location, name, longitude, latitude, geometry, source_id, region
>10,000 rows
transformer_flows
name, type, longitude, latitude, voltage, firm_capacity, min_transformer_flow, max_transformer_flow, source, location, geometry, licence, source_id
5,486 rows