Case Studies

Sussex Flow Initiative produced a number of case studies that act as a useful resource for organisations new to NFM, those wishing to explore new techniques, and those interested in finding examples of collaboration, funding and NFM delivery. The case studies are focussed on Natural Flood Management in lowland catchment, so therefore suitable for organisations working in catchments with similar characteristics.

Read our case studies below:

Case studies
Time Δ Debug Message - Perch Runway 3.2
1791312385.36680 [907] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM swt_pages_staging p LEFT JOIN swt_page_routes pr ON p.pageID=pr.pageID LEFT JOIN swt_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM swt_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
1791312385.40790.0411Matched page: /discover/around-sussex/a-living-wetland-landscape/sussex-flow-initiative-river-ouse/case-studies, so not using routes.
1791312385.40810.0001Server address: 216.73.217.150
1791312385.40810Using master page: /templates/pages/default.php
1791312385.40840.0003 [1] SELECT * FROM swt_pages_staging WHERE pagePath='/discover/around-sussex/a-living-wetland-landscape/sussex-flow-initiative-river-ouse/case-studies' LIMIT 1
1791312385.41130.0028 [86] SELECT DISTINCT settingID, settingValue FROM swt_settings WHERE userID=0
1791312385.41390.0027 [1] SELECT locationID FROM swt_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
1791312385.41480.0009INSERT INTO swt_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]')
1791312385.42260.0078 [1] SELECT * FROM swt_shop_cart WHERE cartID=25052849
1791312385.42360.0011 [1] SELECT * FROM swt_shop_cart WHERE cartID=25052849
1791312385.42470.001 [nil] SELECT * FROM swt_shop_sales WHERE saleFrom<='2026-10-06 18:46:00' AND saleTo>'2026-10-06 18:46:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
1791312385.42620.0016 [2] SELECT regionKey, regionHTML FROM swt_content_regions WHERE regionPage='/discover/around-sussex/a-living-wetland-landscape/sussex-flow-initiative-river-ouse/case-studies' OR regionPage='*' ORDER BY regionPage DESC
1791312385.42730.0011 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/discover/around-sussex/a-living-wetland-landscape/sussex-flow-initiative-river-ouse/case-studies' OR pageSortPath='/discover/around-sussex/a-living-wetland-landscape/sussex-flow-initiative-river-ouse/case-studies' LIMIT 1
1791312385.43010.0027 [1] SELECT * FROM swt_pages_staging WHERE pageID=423 LIMIT 1
1791312385.43120.0011 [250] SELECT country, countryID FROM swt_shop_countries WHERE countryActive=1 ORDER BY country ASC
1791312385.43320.002Using template: /templates/pages/attributes/seo.html
1791312385.43370.0005 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM swt_content_regions WHERE regionKey='Banner image' AND (regionPage='/discover/around-sussex/a-living-wetland-landscape/sussex-flow-initiative-river-ouse/case-studies' OR regionPage='*')
1791312385.4350.0013 [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM swt_content_index idx JOIN swt_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN swt_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=2840 AND idx.itemRev=1)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
1791312385.43720.0022 [82] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=2 ORDER BY pageTreePosition ASC
1791312385.4420.0048 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/discover/around-sussex/a-living-wetland-landscape/sussex-flow-initiative-river-ouse/case-studies' LIMIT 1
1791312385.44460.0026 [5] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-002-005-011-003-003', '000-002-005-011-003', '000-002-005-011', '000-002-005', '000-002', '000') ORDER BY pageTreePosition DESC
1791312385.44780.0033Using template: /templates/navigation/ps_nav_template.html
1791312385.44790.0001 [6] Using template: /templates/navigation/ps_nav_template_children.html
1791312385.44880.0009 [4] Using template: /templates/navigation/ps_nav_template_children.html
1791312385.44930.0005 [29] Using template: /templates/navigation/ps_nav_template_children.html
1791312385.45170.0023 [10] Using template: /templates/navigation/ps_nav_template_children.html
1791312385.45250.0009 [7] Using template: /templates/navigation/ps_nav_template_children.html
1791312385.45320.0007 [9] Using template: /templates/navigation/ps_nav_template_children.html
1791312385.45560.0024 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/discover/around-sussex/a-living-wetland-landscape/sussex-flow-initiative-river-ouse/case-studies' OR pageSortPath='/discover/around-sussex/a-living-wetland-landscape/sussex-flow-initiative-river-ouse/case-studies' LIMIT 1
1791312385.45830.0027 [5] SELECT * FROM swt_pages_staging WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-002-005-011-003-003', '000-002-005-011-003', '000-002-005-011', '000-002-005', '000-002', '000') ORDER BY pageTreePosition
1791312385.46220.0039 [5] Using template: /templates/navigation/breadcrumbs.html
1791312385.46310.0009 [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM swt_content_regions WHERE regionKey='Body Content' AND (regionPage='/discover/around-sussex/a-living-wetland-landscape/sussex-flow-initiative-river-ouse/case-studies' OR regionPage='*')
1791312385.46470.0016 [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM swt_content_index idx JOIN swt_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN swt_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=2841 AND idx.itemRev=4)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
1791312385.46760.0029 [1] Using template: /templates/content/mixed_content.html
1791312385.46780.0002Using sub-template: /templates/content/text_block.html
1791312385.46780Using sub-template: /templates/content/thumbnails.html
1791312385.46790Using sub-template: /templates/content/image.html
1791312385.46790Using sub-template: /templates/content/gallery.html
1791312385.46790Using sub-template: /templates/content/video.html
1791312385.4680Using sub-template: /templates/content/ask_inline.html
1791312385.4680Using sub-template: /templates/content/legacy_request_form.html
1791312385.4680Using sub-template: /templates/content/image.html
1791312385.46810Using sub-template: /templates/content/code_block.html
1791312385.46810.0001Using sub-template: /templates/content/customisable_donate_form.html
1791312385.46820Using sub-template: /templates/content/contact_form.html
1791312385.46830.0001Using sub-template: /templates/forms/details.html
1791312385.46840.0001Using sub-template: /templates/forms/_data_protection.html
1791312385.46840.0001Using sub-template: /templates/forms/_personal_details.html
1791312385.46850.0001Using sub-template: /templates/forms/_address.html
1791312385.46850Using sub-template: /templates/forms/_personal_details.html
1791312385.46860Using sub-template: /templates/forms/_address.html
1791312385.46860Using sub-template: /templates/forms/_data_protection.html
1791312385.46860Using sub-template: /templates/forms/_personal_details.html
1791312385.46870 [2] Using sub-template: /templates/forms/_data_protection.html
1791312385.47460.0059Using template: /templates/pages/attributes/default.html
1791312385.47470.0001Using sub-template: /templates/pages/attributes/seo.html
1791312385.47480.0001Using template: /templates/pages/attributes/default.html
1791312385.47490.0001Using sub-template: /templates/pages/attributes/seo.html
1791312385.4750.0001 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/what-we-do' OR pageSortPath='/what-we-do' LIMIT 1
1791312385.47660.0016 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-002' LIMIT 1
1791312385.47760.001 [7] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
1791312385.4810.0034 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/discover/around-sussex/a-living-wetland-landscape/sussex-flow-initiative-river-ouse/case-studies' LIMIT 1
1791312385.48330.0023 [5] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-002-005-011-003-003', '000-002-005-011-003', '000-002-005-011', '000-002-005', '000-002', '000') ORDER BY pageTreePosition DESC
1791312385.48660.0033 [6] Using template: /templates/navigation/footer-nav.html
1791312385.48740.0008 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/make-a-difference' OR pageSortPath='/make-a-difference' LIMIT 1
1791312385.4890.0015 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-005' LIMIT 1
1791312385.48990.0009 [38] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005%' ORDER BY pageTreePosition ASC
1791312385.49390.004 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/discover/around-sussex/a-living-wetland-landscape/sussex-flow-initiative-river-ouse/case-studies' LIMIT 1
1791312385.49630.0024 [5] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-002-005-011-003-003', '000-002-005-011-003', '000-002-005-011', '000-002-005', '000-002', '000') ORDER BY pageTreePosition DESC
1791312385.49940.0031 [10] Using template: /templates/navigation/footer-nav.html
1791312385.50270.0033 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/visit' OR pageSortPath='/visit' LIMIT 1
1791312385.50420.0015 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-004' LIMIT 1
1791312385.5050.0008 [30] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-004%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
1791312385.50890.0039 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/discover/around-sussex/a-living-wetland-landscape/sussex-flow-initiative-river-ouse/case-studies' LIMIT 1
1791312385.51120.0023 [5] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-002-005-011-003-003', '000-002-005-011-003', '000-002-005-011', '000-002-005', '000-002', '000') ORDER BY pageTreePosition DESC
1791312385.51460.0033 [29] Using template: /templates/navigation/footer-nav.html
1791312385.51660.002 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pagePath='/make-a-difference' OR pageSortPath='/make-a-difference' LIMIT 1
1791312385.51780.0011 [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages_staging WHERE pageTreePosition='000-005' LIMIT 1
1791312385.51870.0009 [11] SELECT * FROM swt_pages_staging WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
1791312385.52210.0034 [1] SELECT pageTreePosition FROM swt_pages_staging WHERE pagePath='/discover/around-sussex/a-living-wetland-landscape/sussex-flow-initiative-river-ouse/case-studies' LIMIT 1
1791312385.52450.0024 [5] SELECT pageID FROM swt_pages_staging WHERE pageTreePosition IN ('000-002-005-011-003-003', '000-002-005-011-003', '000-002-005-011', '000-002-005', '000-002', '000') ORDER BY pageTreePosition DESC
1791312385.52780.0033 [10] Using template: /templates/navigation/footer-nav.html
1791312385.52890.0011Request time: 0.1652
1791312385.52890Process time: 0.165
1791312385.52890Memory: 1.6233