primary

Custom SQL query

Tables schema

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, primary_substation_type_id, bsp_substation_type_id, gsp_substation_type_id, country

>10,000 rows

metadata

date, host, user, git_commit_id, git_branch

1 row

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, ecr_project_id

>10,000 rows

substation_groups

name, geometry, type, licence, source, location, substation_type_id, source_id, latitude, longitude

1,506 rows

substation_types

location, type, licence, source, substation_ids, voltages, transformers, substation_type_id, latitude, longitude, source_id

4,627 rows