20240305 10195900 1.0 TRUE 002 5000000 5000 RAMI_Internal dataset SEPA SEPA foi@sepa.org.uk 20240301 Enterprise Geodatabase Feature Class v10 SEPA SEPA foi@sepa.org.uk withheld False SEPA withheld Esri ArcGIS 13.1.3.41833 River Anthropogenic Modification Index RAMI Internal Use map RAMI 2023-09-01T00:00:00 2024-02-15T00:00:00 2024-02-15T00:00:00 Internal versioin 20240215 Peter Pollard SEPA Information Asset Owner peter.pollard@sepa.org.uk Roberto Martinez SEPA roberto.martinez@sepa.org.uk Roberto Martinez SEPA Senior Hydromorphologist River Anthropogenic Modification Index RAMI Internal Use The river anthropogenic modification index (RAMI) describes the degree of anthropogenic impact on a system as a proxy for understanding its condition. Every reach is 1000m long, and MImAS calculations are worked per each of them, based on 1000m reach length. <DIV STYLE="text-align:Left;"><DIV><DIV>The RAMI layer is calculated for all baseline river water bodies. Anthropogenic pressures which were believed to degrade channel form were mapped across all these water bodies. This includes bank protection, culverts, river straightening, bed reinforcement, embankments, weirs and more. This mapping was initially done using remote sensing (e.g. aerial photographs and OS maps) to identify the pressures. All baseline rivers that were identified as being at less than good morphological condition, or in good but close to poor morphological condition due to these modifications were then field surveyed, so that the reliability and resolution in the data was improved. This includes > 7,000 km of river that were walked. River type was also recorded, as the type of the river impacts the degree of impact the anthropogenic pressure will have. The river types include: bedrock, cascade, step-pool, plane-riffle, plane bed, active meandering, wandering, passive meandering and peat. For example, a stretch of bank protection on a bedrock river will have less of an impact on river form and habitat than it would have on an active meandering river, which would naturally be able to move sideways across the floodplain. For every pressure and river type combination, impact ratings were created, to predict the impact that pressure was likely to have on a specific type of river. <OL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI>The impact ratings (see MImAS reference at this end of this section) were then used to calculate the degree of impact (or capacity used) for every 1 km stretch of the baseline river network to create the River Anthropogenic Modification Index (RAMI). </LI><LI>Capacity used = Impact rating x pressure footprint 1 km length </LI><LI>The pressure footprint was simply the length of that pressure within the 1km length being assessed. This was then divided by the length being assessed (in this case 1 km) to get a measure of the capacity used (i.e. how much impact is the system likely to be undergoing). The resulting number was then used to place reaches into categories based on the extent of modification (Table 1). </LI></OL>Table 1: Capacity used score as calculated within the RAMI approach and resulting modification categories. <TABLE><TBODY><TR><TD>Capacity used</TD><TD>RAMI category</TD></TR><TR><TD>< 25%</TD><TD>Low modification</TD></TR><TR><TD>25.1 – 50%</TD><TD>Moderate modification</TD></TR><TR><TD>50.1 – 75 %</TD><TD>High modification</TD></TR><TR><TD>75.1 – 100%</TD><TD>Significant modification</TD></TR><TR><TD>> 100%*</TD><TD>Very significant modification</TD></TR><TR><TD>N/A</TD><TD>Wetland/unknown river type** </TD></TR></TBODY></TABLE>* Due to overlapping pressures, in some circumstances more than 100% capacity can be used.** Capacities were not calculated for this type of waterbody.Method to produce the RAMI layer in GIS<OL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI>All the information was extracted from the different GIS layers (morph pressures and river type) and converted into tables in Excel format. The different pressures were split into different parts when the pressure expanded two river types. This helps to work out accurately the MImAS capacity (i.e. apply the correct impact rating to each section of the pressure). The way to control the length and location of pressures and river types was made using river codes (from the SEPA river network) and downstream and upstream distances. The excel file used for tuis purpose is this one: </LI><LI>The excel file contains different tabs. The tabs that have used for this project are in blue and named starting with a ‘3’. </LI><LI>Tab “3 Water metrics”:<OL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI>To create an internal ID (Internal ID before extracting reaches)</LI><LI>Column F: to find the location (reach number) of the downstream distance of every pressure. Reach number are 1, 2, 3, …… each of those correspond to e.g.: reach 1 is the first 1000m reach, reach 12 is 12,000m, etc.</LI><LI>Column G: to find the location (reach number) of the upstream distance of every pressure. Reach number are 1, 2, 3, …… each of those correspond to e.g.: reach 1 is the first 1000m reach, reach 12 is 12,000m, etc.</LI><LI>Column H: to identify if the pressure is contained in the same reach number.</LI><LI>Column I: to identify if the pressure expands several reaches. </LI><LI>Columns J and K: for the same pressure works out the lowest reach where the pressure expands. It works out the Mimas capacity in K.</LI></OL></LI></OL>Columns L and M: if the pressure expands more than one reach, the reach number and the capacity used is worked out here (M). Columns N and O…. same that before.Etc… <OL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI>Tab “3 Water Metrics 1.1”: <OL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI>Insert the internal ID and Rivercode before each pair: JK, LM, NO, etc, to make it easy to create a table with all those reaches. </LI><LI>To create a new Tab where I will paste all the columns with all the new reaches. (3 Water metrics 2)</LI></OL></LI><LI>Tab 3 Water metrics 2:<OL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI>I copy all the Pairs: RAMI Reach and capacity used for that RAMI reach </LI><LI>I copy all seven pairs and paste them in columns one under the other (i.e. I need a table with the same columns showing reach and capacity for the different reaches)</LI><LI>When I copy the columns in b, I also copy the unique internal ID produced in 1. This will help to bring all the information from the tab Water Metrics, later on to Water Metrics 2.</LI><LI>Also, I need to create two columns with the DWN and UPS distance of reaches 1000, 2000, 3000, etc. to do linear referencing later. </LI><LI>Then I will create a dynamic table to Sum the capacity use in each Reach within each RivCod. This capacity value will be the one that will be useful to allocate the RAMI value. (Tab 3 Water metrics Pivot 3).</LI></OL></LI></OL><OL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI>Tab 3 Water metrics Pivot 3: <OL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI>The dynamic table uses data from Water Metrics 2.</LI><LI>The table extracted from this dynamic table will be the one to export to GIS using linear referencing. </LI><LI>I used a annex tab to help producing this tab (Tab 3 Annex to pivot 4).</LI><LI>The final table to be used in GIS is in tab “3 Extract to GIS 6”.</LI></OL></LI><LI>GIS work. I used ArcGIS Pro. Linear referencing tools making use of RivCode and downstream and upstream distances for each 1000 reaches. </LI><LI>The shapefile was generated. RAMI_test1.zip (this version, attached below, has not metadata yet). </LI></OL></DIV></DIV></DIV> SEPA Hydromorphology RAMI River Modification 1 -8.024558 -0.879902 60.779388 54.615769 Scotland national scale GEMET - INSPIRE themes, version 1.0 2008-06-01T00:00:00 http://www.eionet.europa.eu/gemet/inspire_themes Hydrography Roberto Martinez SEPA roberto.martinez@sepa.org.uk Roberto Martinez Only available as a map service externally. <DIV STYLE="text-align:Left;"><DIV><DIV>For SEPA internal use only. Third party dataset licensed from the Centre for Ecology and Hydrology (Copyright CEH), pro-forma contractors licence available. CEH licence is here: <A href="https://geospatial.cloudnet.sepa.org.uk:443/portal/sharing/rest/content/items/18370f98eda141b5a775d1780e10f842/data" STYLE="text-decoration:underline;">https://geospatial.cloudnet.sepa.org.uk/portal/sharing/rest/content/items/18370f98eda141b5a775d1780e10f842/data</A>The following acknowledgement should be used: "Based on digital spatial data licensed from the Centre for Ecology & Hydrology, Copyright NERC(CEH). (preceded if appropriate by 'some features of this map are'). Contains Ordnance Survey data Copyright Crown copyright and database right [year]."</DIV></DIV></DIV> Data have been produced using CEH river network and morpho pressures dataset. MImAS capacity has been worked out every 1000m using 1000m reach length COMMISSION REGULATION (EU) No 1089/2010 of 23 November 2010 implementing Directive 2007/2/EC of the European Parliament and of the Council as regards interoperability of spatial data sets and services 2010-12-08T00:00:00 No domains in use. 1 9904 EPSG 6.3(3.0.1) RAMI Feature Class 9904 polyline ESRI OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. route_identifier Route Identifier String 14 0 0 Route Identifier SEPA Route Identifier from_measure From Measure (m) Double 8 38 8 From Measure (m) - downstream start of the reach in metres from the sea along the network. SEPA From Measure (m) - downstream start of the reach in metres from the sea along the network. to_measure To Measure (m) Double 8 38 8 To Measure (m) - upstream end of the reach in metres from the sea along the network. SEPA To Measure (m) - upstream end of the reach in metres from the sea along the network. reach_code Reach Identifier String 254 0 0 Reach Identifier SEPA Reach Identifier aux_code Auxiliary Code String 254 0 0 Auxiliary Code for reach SEPA Auxiliary Code for reach anthropogenic_index Anthropogenic Modification Index Double 8 38 8 River anthropogenic modification index SEPA River anthropogenic modification index SSP Average Specific Stream Power (W m²) Double 8 38 8 Average specific stream power for that reach, this is an approximation and it might have issues at confluences. Based on slope, Qmed and channel width every 50m Average Specific Stream Power (W m²) waterbody_id Waterbody ID Integer 4 10 0 Unique identifier for the river waterbody. SEPA Unique identifier for the river waterbody. catchment_number Catchment Number Integer 4 10 0 SEPA Catchment Number SEPA SEPA Catchment Number river_number River Number Integer 4 10 0 SEPA River Number SEPA SEPA River Number restoration_approach Restoration Approach String 255 0 0 Restoration Approach SEPA Restoration Approach ram_index_class RAM Index Class String 255 0 0 Categories of RAMI bases on RAMI values, <0.25 low, <0.50 moderate, <0.75 high, <0.1 significant, >0.1 very significant, other Based on RAMI values, see technical report Categories of RAMI bases on RAMI values, <0.25 low, <0.50 moderate, <0.75 high, <0.1 significant, >0.1 very significant, other st_length(shape) Length (m) Double 0 0 0 Length (m) PostGIS Length (m)