To ask the Scottish Government what flood prevention schemes were approved, and at what cost, broken down by local authority, in each financial year from 2007-08 to 2024-25. In 2016, an agreement was reached between Scottish Ministers and COSLA on a new strategic funding plan for flood protection schemes.