Skip to content

Constraint Management Zone (CMZ) (Tranche 6A – winter 2021)

This dataset contains a SQLite database containing flexibility service data for the latest flexibility service (Tranche 6A – winter 2021). The database also contains DFES scenario based signposting for flexibility services. This data set is displayed on the Network Flexibility map on the WPD website and Flexible Power website.

SQL queries are provided to extract data from the database in conjunction with example extracts. The SQL queries list:

  • Which primary substations are associated with which Constraint Managed Zone (CMZ) for Tranche 6A – winter 2021 flexibility service tender;

  • Which postcodes are associated with which Constraint Managed Zone (CMZ) for Tranche 6A – winter 2021 flexibility service tender;

  • Which CMZs are open for the Tranche 6A – winter 2021 flexibility service tender;

  • CMZ availability windows for the Tranche 6A – winter 2021 flexibility service tender;

  • CMZ utilisation volumes for the Tranche 6A – winter 2021 flexibility service tender;

Data Files

Name Format Last Changed Download
6A CMZ Primary Substation List csv
4 months ago
6A CMZ Procurement Postcodes csv
4 months ago
6A FSP Information - CMZ Information csv
4 months ago
6A FSP Information - MW Profiles csv
4 months ago
6A FSP Information - MWh Values csv
4 months ago
6A CMZ Database dbase
4 months ago
6A CMZ Procurement Postcodes sql
4 months ago
6A CMZ Primary Substation List sql
4 months ago
6A FSP Information - CMZ Information sql
4 months ago
6A FSP Information - MW Profiles sql
4 months ago
6A FSP Information - MWh Values sql
4 months ago

Additional Info

Field Value
Uploaded Date February 4, 2022, 10:37 (UTC)
Creator Western Power Distribution
Rights WPD Open Data Licence
Contributor Digitalisation & Data
Identifier CMZPC
Publisher Western Power Distribution
Relation Flexibility
Language EN

Integrate this dataset using cURL

# Get a list of dataset's resources

curl -L -s https://connecteddata.westernpower.co.uk/dataset/constraint-management-zone-cmz-6a/datapackage.json | grep path

# Get resources

curl -L https://connecteddata.westernpower.co.uk/dataset/78786d26-82b7-4bbc-99cb-7554abf5359c/resource/a0b8e4fd-81f6-4113-9528-63d9f2291b9a/download/6a-cmz_primary_substation_list.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/78786d26-82b7-4bbc-99cb-7554abf5359c/resource/806100f3-0a8b-4d06-bdd5-d224f2a00cce/download/6a-cmz_procurement_postcodes.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/78786d26-82b7-4bbc-99cb-7554abf5359c/resource/591a47c2-906b-4237-a879-9483f39da8b2/download/6a-fsp_information-cmz_information-table.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/78786d26-82b7-4bbc-99cb-7554abf5359c/resource/86ac98bd-e104-49d8-ad9a-55dd628a6d51/download/6a-fsp_information-mw_profiles-table.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/78786d26-82b7-4bbc-99cb-7554abf5359c/resource/d66b9a3f-e6c4-4d0d-9976-bb02e448cb06/download/6a-fsp_information-mwh_values-table.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/78786d26-82b7-4bbc-99cb-7554abf5359c/resource/4f987106-7ba8-4971-8b41-336441a462f7/download/t6a_cmz_published_database_external.db
curl -L https://connecteddata.westernpower.co.uk/dataset/78786d26-82b7-4bbc-99cb-7554abf5359c/resource/0211fd7e-64b5-4d9c-9f35-88aa5c97e8a1/download/6a-cmz_procurement_postcodes.sql
curl -L https://connecteddata.westernpower.co.uk/dataset/78786d26-82b7-4bbc-99cb-7554abf5359c/resource/0a0ed9e2-7739-4dc0-b737-92474e1ee503/download/6a-cmz_primary_substation_list.sql
curl -L https://connecteddata.westernpower.co.uk/dataset/78786d26-82b7-4bbc-99cb-7554abf5359c/resource/aed0c054-eb3b-4315-8ffc-99fa2ab70286/download/6a-fsp_information-cmz_information-table.sql
curl -L https://connecteddata.westernpower.co.uk/dataset/78786d26-82b7-4bbc-99cb-7554abf5359c/resource/a78be0b5-25f8-4ec9-894d-21d673ac528b/download/6a-fsp_information-mw_profiles-table.sql
curl -L https://connecteddata.westernpower.co.uk/dataset/78786d26-82b7-4bbc-99cb-7554abf5359c/resource/7659331f-3307-4ce8-a671-70b91457611a/download/6a-fsp_information-mwh_values-table.sql