Skip to content

Constraint Management Zone (CMZ) (Tranche 6B – summer 2022)

This dataset contains a SQLite database containing flexibility service data for the latest flexibility service (Tranche 6B – summer 2022). 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 6B – summer 2022 flexibility service tender;
  • Which postcodes are associated with which Constraint Managed Zone (CMZ) for Tranche 6B – summer 2022 flexibility service tender;
  • Which CMZs are open for the Tranche 6B – summer 2022 flexibility service tender;
  • CMZ availability windows for the Tranche 6B – summer 2022 flexibility service tender;
  • CMZ utilisation volumes for the Tranche 6B – summer 2022 flexibility service tender;

Data Files

Name Format Last Changed Download
CMZ Primary Substation csv
2 months ago
CMZ Procurement Postcodes csv
2 months ago
FSP Information - CMZ Information csv
2 months ago
FSP Information - MW Profiles csv
2 months ago
FSP Information - MWh Values csv
2 months ago
T6B CMZ Database zip
2 months ago
CMZ-6B SQL Queries zip
2 months ago

Additional Info

Field Value
Source Western Power Distribution
Uploaded Date June 23, 2022, 16:40 (UTC)
Creator Western Power Distribution
Rights WPD Open Data Licence
Contributor Digitalisation & Data
Identifier CMZ-6B
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-tranche-6b-summer-2022/datapackage.json | grep path

# Get resources

curl -L https://connecteddata.westernpower.co.uk/dataset/262049dd-66ee-4f8b-8665-18a398c5f050/resource/746931a9-20c2-4582-94bd-53ca64e14024/download/cmz_primary_substation_list.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/262049dd-66ee-4f8b-8665-18a398c5f050/resource/7ada35a1-acd2-417e-b7fa-51c6fedd6dd6/download/cmz_procurment_postcodes.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/262049dd-66ee-4f8b-8665-18a398c5f050/resource/4cfe2db8-9f98-4f88-a6ac-2c46311189d4/download/fsp_information-cmz_information-table.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/262049dd-66ee-4f8b-8665-18a398c5f050/resource/96bd334d-84a5-438d-b6b6-91ef84b6eb1a/download/fsp_information-mw_profiles-table.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/262049dd-66ee-4f8b-8665-18a398c5f050/resource/f8658d69-43ae-4faf-977d-fa000a4e290f/download/fsp_information-mwh_values-table.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/262049dd-66ee-4f8b-8665-18a398c5f050/resource/3a869f1e-e210-4bca-b8f4-a94d56ef8fe6/download/t6b_cmz_published_database_external.zip
curl -L https://connecteddata.westernpower.co.uk/dataset/262049dd-66ee-4f8b-8665-18a398c5f050/resource/bd276972-cf6a-4af6-aa12-3a504f0de92f/download/cmz-6b-sql-queries.zip