Skip to content

Constraint Management Zone (CMZ) (Tranche 5B – summer 2021)

This dataset contains a SQLite database containing flexibility service data for the latest flexibility service (Tranche 5B – summer 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 5B – summer 2021 flexibility service tender;

  • Which postcodes are associated with which Constraint Managed Zone (CMZ) for Tranche 5B – summer 2021 flexibility service tender;

  • Which CMZs are open for the Tranche 5B – summer 2021 flexibility service tender;

  • CMZ availability windows for the Tranche 5B – summer 2021 flexibility service tender;

  • CMZ utilisation volumes for the Tranche 5B – summer 2021 flexibility service tender;

Data Files

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

Additional Info

Field Value
Uploaded Date February 11, 2021, 16:18 (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-5b/datapackage.json | grep path

# Get resources

curl -L https://connecteddata.westernpower.co.uk/dataset/cac922a2-9570-441a-b1aa-128b9b511786/resource/34fb235c-f2b5-496d-b966-9d2e0e382542/download/cmz_primary_substation_list.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/cac922a2-9570-441a-b1aa-128b9b511786/resource/046e69b8-fb70-44a8-83c2-f0b39f6066cf/download/cmz_procurement_postcodes.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/cac922a2-9570-441a-b1aa-128b9b511786/resource/1e415fc4-b634-419e-b213-83f085a42c55/download/fsp_information-cmz_information-table.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/cac922a2-9570-441a-b1aa-128b9b511786/resource/878c45a4-2dc2-49fc-9998-150e94c3dea4/download/fsp_information-mw_profiles-table.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/cac922a2-9570-441a-b1aa-128b9b511786/resource/b8e33a08-d7dd-424c-853a-d433202893cc/download/fsp_information-mwh_values-table.csv
curl -L https://connecteddata.westernpower.co.uk/dataset/cac922a2-9570-441a-b1aa-128b9b511786/resource/8ea59424-0a18-4187-bce0-3e81190fa627/download/t5b_cmz_published_database.db
curl -L https://connecteddata.westernpower.co.uk/dataset/cac922a2-9570-441a-b1aa-128b9b511786/resource/be687562-60ed-4c8d-a2d3-73bd4e723606/download/cmz_procurment_postcodes.txt
curl -L https://connecteddata.westernpower.co.uk/dataset/cac922a2-9570-441a-b1aa-128b9b511786/resource/c9805121-3287-4a1b-aaec-6d4305007bb0/download/cmz_primary_substation_list.txt
curl -L https://connecteddata.westernpower.co.uk/dataset/cac922a2-9570-441a-b1aa-128b9b511786/resource/4d62cb02-6990-4488-a3d9-06dcee0926e3/download/fsp_information-cmz_information-table.txt
curl -L https://connecteddata.westernpower.co.uk/dataset/cac922a2-9570-441a-b1aa-128b9b511786/resource/ab3d9447-e38a-47c0-ba8a-aef6d957af3b/download/fsp_information-mw_profiles-table.txt
curl -L https://connecteddata.westernpower.co.uk/dataset/cac922a2-9570-441a-b1aa-128b9b511786/resource/66fb84ef-9e2c-4f37-a957-75c3dc363320/download/fsp_information-mwh_values-table.txt