Home

Standardisation of river classifications:

1. nal in AQEM you can fill in numbers a yellow label is displayed in AQEM if there are data in STAR and vice versa In the STAR protocol a text field for others was added a yellow label is displayed in AQEM if there are data in STAR and vice versa In STAR you only can enter yes n a a yellow label is displayed in AQEM if there are data in STAR and vice versa The tables were changed for STAR a yellow label is displayed in AQEM if there is data in STAR and vice versa relation lentic lotic in STAR pools riffles in AQEM discharge is an estimated value in STAR in AQEM it is calculated from No 106 a yellow label is displayed in AQEM if there is data in STAR and vice versa optional in STAR in AQEM it is calculated from tab 116 Picture Map on page 1 is not saved only the path is saved minimises the database in size only jpg files can be inserted size limitation 1200 x 1000 pixel path Vinstallation path pics filename sample no map jpg recommended filename sample no pic jpg recommended filename Tables 103 amp 104 automatically write values into table 116 The values are only transmitted when the values in table 103 amp 104 equal the sum of 100 or 20 replicates respectively Otherwise all entries in table 116 are deleted Table 116 is restricted in parts microhabitats can only be altered in table 103 amp 104 Table 106 all values must be entered otherwise the calcula
2. positions Typology Note 1 mS m 10 n S cm Conductivity Specific conductivity value of the water at Numeric Sampling 18 5 sampling Given as mS m decimal point 4 Typology Note 1 mS m 10 uS cm positions Model Locality length Fished length sampled length of the stream in Numeric Database 140 0 metres decimal point 6 positions 7 4 Locality width Estimated fished width of sampled locality given Numeric Sampling 10 0 metres Could be derived from the previous and the decimal point 6 following variable and is therefore Optional positions 7 5 A Fished area Area of the section that has been sampled Numeric integer 6 Sampling 1400 locality length locality width given in m positions Database MWetted width The wetted width of the stream representative Numeric Sampling 10 0 width of the section given in metres Wetted decimal point Typology width is normally calculated as the average of six positions Model several transects across the stream Wetted width Locality width if the whole stream section was sampled Could be replaced by average width if only such data are available 801 Table FISHING OCCASION Average depth The average depth is given in metres for the Numeric Sampling 0 56 sampled area Note that the precision is down decimal point to centimetres six positions Same as average depth of site if whole length Hn A and w
3. Stream type 102 102 102 102 102 102 102 102 102 102 102 102 102 102 102 102 102 102 102 102 102 102 102 102 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 River name Kekava Kuja Licupe Tumsupe Veseta Age Kisupe Peterupe Vitrupe lecava Misa Ige Korgite Letiza Zana Arona 3 Mergupe 3 Pededze 3 Raunis 3 Rauza 3 Strikupe 3 Amula 3 Koja 3 Riezupe 3 Site name In the park area of Kekava village middle part above crossing way Cesvaine Aizkuja near farmstead UpesMarkuti Above Podkajas farmstead Near by Vutalva Lower part of river in Saulkrasti town The lower part of Kisupe in Saulkrasti town The lower part in the territory of cooperative VEF Pie Kirbizu forestry In the park area of lecava village Above crossing of ViaBaltica road Below Mileni 500 m from river mouth Middle part Below settlement Pampali Lower part nearby Rubeni Lower part Lower part Lower part Lower part near farmstead Caunites Lower part Lower part Lower part Lower part Status OO Oo Oo Oc P o o o Oo Cc bb Go ca PM P SM Dominant stressor Organic Organic Organic Organic Organic Organic Organic Organic Organic Or
4. included Optional but important for lowland sections of larger rivers gt 10 000 km Mean discharge Average annual water discharge at site Could String 5 Typology 100 class be deduced from maps or from similar or positions nearby stations Optional Classes 1 10 100 1000 gt 1000 m s 1 e 0 0 9 1 9 9 10 99 9 100 999 9 1000 L6 Table SITE Flow regime Normal flow pattern for the river Divided into String 10 Typology Permanent four classes positions Initial Permanent Never or extremely rarely capital letter and having zero water velocity or low flow Never then lower case drying out letters Summer dry In normal years having extreme summer low flow with no water velocity or even dry conditions Mediterranean regime Winter dry In normal years having extreme winter low flow with no water velocity or even dry conditions Episodic Having extreme low flow with no water velocity or even dry conditions at intervals The timing and length of intervals is unpredictable Altitude The altitude of the site in metres above average Numeric Model 345 sea level If the altitude is only available in integer four Typology classes use class midpoint value positions 7 5 Geological typology According to WFD Classes siliceous String 15 Typology Siliceous calcareous organic The definition of organic is positions still unclear Geological formation Addit
5. lt 4 5 grayling gt 4 5 trout 230 0 45 bream lt 1 5 barbel 5 grayling gt 5 trout 225 0 5 bream lt 1 75 barbel lt 5 5 gt 5 5 trout 220 0 5 bream lt 2 barbel 5 7 grayling gt 5 7 trout gt 15 lt 0 6 bream lt 2 barbel lt 6 grayling gt 6 trout gt 10 lt 0 7 bream lt 2 3 barbel lt 6 5 grayling gt 6 5 trout gt 4 5 lt 1 bream lt 2 7 barbel lt 7 grayling gt 7 Dout lt 4 5 lt 1 bream lt 3 barbel gt 3 upstream gt 7 trout ncludes trout and grayling zone SOI Table FISHING OCCASION VARIABLE EXPLANATION TYPE USED FOR EXAMPLE PRECISION MNT Reporter code See Table REPORTER Site code See Table SITE Reference site On a national basis by FAME partners String 3 Database No considered as a reference site at time of positions Model sampling Yes or No Definite selection of reference sites to be decided later Latitude See Table SITE String 8 Database 54 3501N positions Longitude See Table SITE String 8 Database 10 0445E positions Date Date of sampling given as Microsoft date Date format 10 Database 2002 05 14 format Format Y Y Y Y MM DD positions Numdate Date of sampling given as a numeric integer Numeric Database 20020514 Format YYYYMMDD For safety until we are Integer 8 sure that date format previous variable works positions Sampling strategy Definition of how the section was sampled String 15 Sampli
6. 001 Table SITE Distance from sourc Distance in km from source headwater to Numeric Model 235 amp the sampling site measured along the river integer 5 Measurement shall be made to the furthest positions 7 555 away most distant upstream source Obligatory Distance to mouth Distance in km classes from the sampling site String 5 Typology 71000 class to the sea measured along the river Classes positions 10 50 100 500 1000 71000 km Obligatory Distance to mouth Distance in km from the sampling site to the Numeric Typology 2345 sea measured along the river Optional integer 5 positions Water source type The source of the river water should be String 15 Typology Nival assigned to one of three classes glacial nival and pluvial Glacial gt 15 glaciated area in the catchment maximum monthly mean flow during summer Nival Yearly flow regime dominated by snowmelt in spring with spring maximum flow Pluvial Yearly flow regime dominated by rainfall maximum flow often during spring autumn winter Mediterranean areas will fall under pluvial but often with Flow regime summer dry or episodic If national experts have good reasons for doing so it is also possible to give combinations Pluvio nival Pluvio glacial Glacio nival Nivo pluvial etc positions Initial capital letter and then lower case letters Table SITE Appe
7. Exploitation site Fauna impact site m Flora impact site Weed cutting site Catches Total Biomass Total Abundance Estimated hinmass estimate abundance estimate efficiency M Run Run Rund Bund Totalal Total 0 Ped Hber bs Species ber SE Number 3 3 Posts BL 7 oa bel av a 88 Length Adding length data is optional In the data table one length is stored per record row This will produce long tables if you have much data Be sure to put in the lengths directly when you are adding the species to the catch Always give Type of data All Subsample Minmax Other and Length type Total Fork before each individual length It is enough to just write the initial letter in the fields for Type of data and Length type the rest is filled in automatically Otherwise you can use Ctrl or copy the correct data whole columns if you want to or use the help list displayed when you click on the arrow to the right of the input field Length class This table is although simple laborious to store data in from the keyboard A You will create a new record Length class by clicking on a line marked with a sign new record B You fill in all the Lengths classes and number for the species in question Check the input When you have managed to input the data from the first site and fishing occasion it
8. Research Institute Senckenberg Andrea Acker Sorting laboratory processing Research Institute Senckenberg Hedwig Bluemel Sorting laboratory processing Research Institute Senckenberg Britta Gehenio Sorting data input Research Institute Senckenberg Anke Peppmiiller Sorting Research Institute Senckenberg Julia Ehrenberg Sorting EcoRing Hardegsen Eckhard Coring Identification diatoms Limares Essen Christian Frenz Fishing University of Duisburg Essen UDE Sandra Kramm Identification invertebrates University of L dz Bis Barbara Site selection sampling and data management macroinvertebrate field sampling spring data processing FIDES STAR PP Protocols environmental data input University of L dz Sicinski Jacek Laboratory processing management University of L dz Jakubowski Marek Field sampling spring autumn laboratory processing sorting University of L dz Burchard Sosnowska Field sampling autumn laboratory processing sorting faunal Dorota data input University of L dz Laskowski Zbigniew Field sampling spring autumn sorting University of L dz Jozefowicz Patrycja Field sampling spring University of L dz Chaniecka Karolina Sorting University of L dz Presler Ewa Sorting University of L dz Janowska Ewa Sorting University of L dz Piotrowska Ola Sorting University of L dz Bacela Karolina Sorting University of L dz Jaskula Radek Sorti
9. cells sample frequency within the processed cells 1 1 1 1 fraction input column for pre picked taxa Macro invertebrate taxa input x Sample unit name 41 15 0 fo Sampling instrument agen 20 iso Gef hs i No Cells Species cs Turbellaria Gen sp 73 17 0 Nematoda sp L 4 1 0 Enchytraeidae Gen sp 4 1 0 Eiseniella tetraedra 1 0 1 Lumbricidae Gen sp 5 1 1 Hydrachnidia Gen sp 3 2 0 Gammarus fossarum 656 153 0 Alainites muticus 1 34 8 0 Baetis alpinus 30 7 0 Baetis alpinus Gr 4 1 0 Baetis sp 4 1 0 Serratella ignita 60 14 0 Ecdyonurus sp 13 3 0 Epeorus assimilis 21 5 0 Rhithrogena carpatoalpina iridina pic 1 E 3 2 0 Rhithrogena semicolorata Gr 26 0 Gen sp EI KEN LEI 4 1 0 Siphonoperla montana 4 1 0 Perla pallida L 15 3 2 Taxon New Edit Delete Close paste Excel import 64 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 d RIVPACS data input The following columns are available e TS total sample frequency of the taxon within the total sample is calculated automatically according to entries of the fraction columns e 1 1 input column for the 1 1 vial e 1 2 input column for the 1 2 vial e 1 4 input column for the 1 4 vial e 1 8 input co
10. e TS total sample frequency of the taxon within the total sample is calculated by summing up the specific fractions multiplied with the specific percentage values e CF coarse fraction frequency within the coarse fraction FFx fine fraction frequency within the fine fraction s 65 t 6 Deliverable 31 July 2004 2001 00089 e Macro invertebrate taxa input 0500272 1 0 ment AQEM 20 flava Hydropsyche angustipennis Hydropsyche Note For the Original AQEM Method the sampling area should be 1 25 m for all 20 replicates Alterations may be necessary if you want to put in riffles and pools or all replicates separately In this case the sampling area selection list can be used This list can be modified in the menu ists Please notice that the sum of your areas for a specific sample number must be 1 25 m Other data input The windows of all other methods were adapted according to your specifications and are to be used in the same way Taxa copy Taxa paste In AQEMdip 2 6 you can copy taxa from one sample unit to another Only the taxa names without frequencies will be copied e click the appropriate sampling unit with the right mouse button in the left window e select Edit with the left mouse button e the data input window opens e mark a taxon with the mouse e add other taxa by keeping the shift button pressed e press the Taxa copy button e edit
11. e choose if you only want to import rows with values greater than 0 e press the Read in button The imported file can be seen in the lower window The first two columns contain the original entries of your Excel file column 3 and 4 contain the values that will be imported by AQEMdip 67 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 d 19 Macro invertebrate taxa input taxa import Select Excel file fou niiSTAR AgemDip test_import xls o Load Select Excel sheet Tabele1 Taxa column s fa 4 14 1 2 1 4 1 8 115 e From row 2 to c H 8 H H H Taxalist 00200 Excel file Ecoprof Taxa Genus Species cf juv 14 1 2 Baetis alpinus Baetis alpinus Baetis cf alpinus Baetis alpinus Caenis horaria Caenis horaria Silo palipes Metalype fragilis Psychomyia fragilis Allrows Read in Taxalist export Do not import taxa with 1 1 KI Import Close The following colour codes are possible green the taxon was identified by the AQEMdip taxa database and read in correctly yellow the taxon was identified by the AQEMdip taxa database and basically read in correctly the status of the taxon e g juv cf was automatically adapted by AQEMdip a check is therefore reasonable orange the taxon was identified as synonym by the AQEMdip taxa database the suggested taxon for import can b
12. to 1 km for small streams 5 km for intermediate streams and 10 km for large streams see definitions in Table Fishing occasion Preferably the slope is measured from a map scale 1 50 000 or 1 100 000 If the slope is only available in classes use class midpoint value 66 Table SITE Huet zonation River zonation according to Huet 1949 String 10 Typology Trout Classification scheme enclosed below positions Initial QA Appendix 4 Classes Trout Grayling Barbel capital letter and Bream Optional then lower case letters Other zonation Zonation used within your country Optional String 50 Typology Epi positions Further work Metapotamal Stream order Strahler system of stream classification based Numeric Typology 4 on confluent points Classification from map integer 1 QA scale 1 50 000 Headwater smallest blue line position two headwaters joined together 2 etc Optional Lakes upstream Are there natural lakes present upstream in the String 3 Model Yes river continuum Answer Yes or No Only positions Initial applicable if the lake affects the site e g by capital letter and altering thermal regime flow regime or then lower case providing seston Use national definition of letters what is a lake Obligatory Distance to lake Distance to natural lake upstream affecting site Numeric Model 1 2 Given in km Optional decimal point 4 positions
13. Fishing data management Comenius University Bratislava DE CUB Krno Field sampling macroinvertebrate identification stoneflies data input Comenius University Bratislava DE CUB Tomas Derka Field sampling laboratory processing macroinvertebrate O I O I identification mayflies
14. Phytobenthos Substratum from the selection list 60 t 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 L Note you make your choice from the first second third selection list the following selection lists will only comprise those options that are possible regarding your first second third choice e The sum up the frequencies of the sampling sites field will be ticked or not according to your choices from the selection lists Change this status if necessary Note If you want to have the frequencies of the samples units within this sample number summed up tick the check box otherwise the program will calculate the mean values e press the Accept button e to enter a second sample number select first sample number or the date with the right mouse button e select New sample number e enter the second sample number the BQE the method the main or replicate and the phytobenthos substratum on the right side of the window e press the Accept button e all further sample numbers should be entered the same manner Entering the sample unit e Click the appropriate sample number with the right mouse button in the left window e select New sample unit with the left mouse button e a blinking cursor will now appear in the field sampling unit name in the right data input window enter a name of the sampling unit here e choose a Sampling instrument including sampling area from the selection list or fill in a Time rela
15. Portugal Portugal Portugal Portugal Portugal Portugal Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Stream type P04 P04 P04 P04 P04 P04 P04 P04 P04 P04 V01 V01 V01 V01 V01 V01 V01 V01 V01 V01 V01 V01 V02 V02 V02 V02 V02 V02 V02 V02 V02 V02 V02 V02 V02 Type description medium sized streams in lower mountainous areas of Southern Portugal medium sized streams in lower mountainous areas of Southern Portugal medium sized streams in lower mountainous areas of Southern Portugal medium sized streams in lower mountainous areas of Southern Portugal medium sized streams in lower mountainous areas of Southern Portugal medium sized streams in lower mountainous areas of Southern Portugal medium sized streams in lower mountainous areas of Southern Portugal medium sized streams in lower mountainous areas of Southern Portugal medium sized streams in lower mountainous areas of Southern Portugal medium sized streams in lower mountainous areas of Southern Portugal small sized calcareous mountain stream in the East Carpathians small sized calcareous mountain stream in the East Carpathians small sized calcareous mountain stream in the East Carpathians small sized calcareous mountain stream in the East Carpathians small siz
16. according to the STAR protocol Lists menu Sampling Instruments amp Area opens the window for defining and editing sampled areas and sampling instruments Export menu EXDOP opens the window for exporting the data to Excel and Access Extras menu DDLEOFIS opens the window for setting program options menu Use opens a window for help information j oc information about the program 56 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 o How to handle existing data AQEM database AQEMdip 1 3 and 2 6 can be used parallelly If you have already entered data in an earlier version of AQEMdip and you want to use these data together with newly entered STAR data the existing database has to be adapted Please comply with the following steps e open your current AQEMdip e select Extras in the menu and subsequently select Options in the sub menu e note the directory of the ProjectDB database e open your Windows Explorer or any other similar program e open the directory of your ProjectDB e copy the file ep prj mdb e send this file via email to ecoprof irv software at When you get back the file please comply with the following steps e install AQEMdip 2 6 for instructions see above e after the first run close AQEMdip 2 6 once again e copy the file prj mdb that you got with email into the installation directory of AQEMdip
17. at Monmouth Cap Bridgend Stokesay Bedwas Ynysddu Handforth Small Heath Stockport Cann Bridge Status a gt ch MM bb bb Oo Oo gt gt MM Go bb PO Dominant stressor None None None Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic None None None Organic Organic Organic Organic Organic Organic Organic Organic Organic v00C INE 9 qe1oA ToC 9 680007 100C LO DMAH vv M e Appendix III The samples collected and surveys undertaken at each site Site number 600 601 602 603 604 605 606 607 608 609 610 611 612 952 953 700 701 702 703 704 705 706 707 708 709 710 711 712 954 955 956 957 958 959 960 961 Country Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Stream type A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 AQEM AQEM AQEM AQEM AQEM Nat l Nat l Nat l spring spring season season winter spring spring season season winter winter main repl 2main 2repl main main
18. gt 15 urban land severe impact impact class 5 gt 15 urban land strong impact impact class 4 lt 15 moderate impact impact class 3 lt 15 low impact impact class 2 lt 1 impact class 1 SII Table FISHING OCCASION 3 Connectivity_river migration barriers within the river basin down to confluence in another river or the sea preventing access for diadromous species to river segment segment is defined below Definite artificial barrier impact class 5 Passage for single species occasionally impact class 4 Passage for certain species or certain years impact class 3 Passage for most species most years impact class 2 No barriers or functioning bypass similar device impact class 1 River segment A river segment is defined as 1 km for small rivers catchment 100 km 5 km for medium sized rivers 100 1000 km 10 km for large rivers 21000 km A segment for a small river will thus be 500 m up and 500 m downstream of the sampling site 4 Land use segment impact of agriculture silviculture on the river segment level in this case referring to the catchment upstream Agriculture gt 40 cultivated land intensive crops severe impact impact class 5 gt 40 cultivated land strong impact impact class 4 lt 40 moderate impact impact class 3 lt 40 low impact impact class 2 1096 impact class 1 Silviculture must be assessed on a national lev
19. near Wernersdorf near K flach near Kleingraden PP Schwanberg headrace section PP Schwanberg residual flow PP Schwanberg artifical channel Schwanberg downst PP Bad Sauerbrunn side channel upst Gr nberg upst sediment control dam upst Gr nberg in sediment control dam upst Gr nberg downst sediment control dam Status a P seh ch sch 0WNWR P P P Oo Oo C MO PO 0 Go GP P 0810101 o Dominant stressor None None None Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat None None None None Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat None Habitat None Habitat Habitat v00C INE 9 68000 1002 12 SE Country Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Stream type River name c04 c04 c04 c04 c04 c04 c04 c04 c04 c04 c04 c04 c04 c04 c05 c05 c05 c05 c05 c05 c05 c05 c05 c05 Luborca Velka Hana Mala Hana Cerny potok Velicka Sudomericky potok Okluka Nectav
20. 1 Core stream type 2 Additional types Austria 1 0 1 Czech Republic 1 0 1 Denmark 0 1 0 France 0 0 1 Germany 1 1 1 0 0 1 Italy 0 0 2 Latvia 0 1 0 Poland 0 2 0 Portugal 0 0 1 Slovakia 2 0 0 Sweden 0 1 1 United Kingdom 0 1 1 TOTAL 5 7 10 A total of 288 sites from 12 core stream and 10 additional stream types were sampled during the project for one or usually more BQE s Appendix I This compares with the intended numbers stated in the project DoW of 302 sites from 16 core and 9 additional sites The shortfall of 14 sites resulted from an over ambitious expectation of the University of Lodz that they would sample 48 sites in four stream types during their single year of sampling In fact they sampled 24 sites in two stream types exceeding the number of sampled sites by most partners This was partially compensated for by several partners sampling one or more extra sites The shortfall in site types was explained by the loss of two Polish site types see preceding paragraph and by Latvia combining all its sites into a single site type In addition to the site types recorded above and in the appendices Greece sampled three extra sets of sites comprising 25 extra sites Furthermore Italy and Greece also sampled in additional seasons to the two seasons sampling stipulated in the DoW The extra Greek and Italian data will be used in some project outputs and increases the number of sampled sites above the n
21. Central Apennines small sized calcareous streams in the Central Apennines small sized calcareous streams in the Central Apennines small sized calcareous streams in the Central Apennines small sized calcareous streams in the Central Apennines small sized calcareous streams in the Central Apennines small sized calcareous streams in the Central Apennines Core or additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional v00C INE TQLIATOA 9 68000 100 LD T AAA 6 Site number 997 998 999 1006 1007 1017 1018 1019 1020 1021 1022 1023 1024 1031 1035 996 1002 1005 1010 1013 1016 1027 1030 1034 Country Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Stream type L02 102 102 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 Type description medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland stream
22. Deviation from natural hydrological state both Numeric Reference cond flow pattern and quantity of the investigated integer Assessment site This variable is obligatory whereas the next two are optional and would ideally be a more precise description of the present variable Classes 1 to 5 See Appendix 2 Natural flow pattern Deviation from natural flow pattern of the Numeric Reference cond site investigated site Classes 1 to 5 See Appendix integer Assessment 2 Optional Natural flow quantity Deviation from natural flow quantity of the Numeric Reference cond site investigated site Classes 1 to 5 See Appendix integer Assessment 2 Optional Upstream dam site Artificial lenthic water body upstream of the Numeric Reference cond investigated site affecting the site Classes 1 to integer Assessment 5 See Appendix 2 Morphological condition Deviation from natural state of stream bed and Numeric Reference cond site banks of the investigated site Classes 1 to 5 integer Assessment See Appendix 2 Salinity site Deviation from natural saline state of the Numeric Reference cond investigated site Classes 1 to 5 See Appendix 2 integer Assessment Table FISHING OCCASION Toxic acidification site Deviation from natural state of the investigated Numeric Reference cond site Classes 1 to 5 See Appendix 2 integer Assessment Nutrients organic input Devi
23. EVK1 CT 2001 00089 g System requirements standard Office PC MS Win 98SE NT4 2000 MS Office 97 or higher runs also on XP Recommended MS Win NT4 or 2000 MS Office 97 2000 English versions Executable 4 5 MB taxadatabase for macro invertebrate 17MB taxadatabase for diatoms 2MB Complete software ca 32MB Technical Information taxalists Access 97 Technical support Technical support via mail see manual for details and website www aqem de General information on the use of AQEMDIP can be found in the AQEMDIP manual Appendix X 3 1 2 Macrophyte database Source Based on an early Mean Trophic Rank database developed by the Institute of Freshwater Ecology Centre for Ecology amp Hydrology UK www dorset ceh ac uk Programmer Database structure including all tables queries forms reports macros and visual basic code John Davy Bowker Centre for Ecology amp Hydrology UK www dorset ceh ac uk Database testing including testing of River Habitat Survey Indices John Davy Bowker Pete Scarlett Mike Furse Centre for Ecology amp Hydrology UK www dorset ceh ac uk Supporting taxonomic standardisations Taxonomic standardisations for data output and analysis Krzysztof Szoszkiewicz ACAU Poland 19 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 L Technical information STARMTRI Programmed in MS Access 2000 Database Engine MS Access 2000 Setup non run time application open s
24. Segment Other_zonation Site Segment Mean_air_temperature Site Site as close as possible Mean_Jan_temperature Site Site as close as possible Mean_July_temperature Site Site as close as possible Stream_order Site Site Water_source_type Site Site as close as possible but can be judged from catchment e g glaciers 81 Varible Land use river Urbanisation river Connectivity river Land use segment Urbanisation river Riparian zone segment Floodplain lateral Sediment load segment Hydrological regime site Natural flow pattern site Natural flow quantity site Upstream dam site Morphological condition site Salinity site Toxic acidification site Nutrients organic input site Introduction fish site Impact of stocking site Exploitation site Fauna impact site Flora impact site Weed cutting site Table Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion Fishing occasion 82 Refers to SCALE River basin River basin Whole river basin i e down to con fluence with the sea Segment of river Segment of river Segment of river Segment of river Segment of river Site Site Site
25. additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional River name Vasc o Murtigao Pardiela Caia X vora Tripeiro Taveir Alpreade Ponsul Bas gueda Laborec 1 Laborec 2 Rieka 1 Rieka 2 Struznica 1 Struznica 2 Svetli ka Udava 1 Udava 2 Udava 3 Udava 4 Vyrava Zitava 1 Zitava 2 Zitavica Bystrica 1 Bystrica 2 Bystrica 3 Bystrica 4 Hostiansky potok 1 Hostiansky potok 2 Hostiansky potok 3 Pok tsky potok 1 Pok tsky potok 2 Stupavsky potok Site name Vasc o Murtigao Pardiela Caia X vora Tripeiro Taveir Alpreade Ponsul Bas gueda Mokr l ky Medzilaborce Zlomy Hrbky pod Hr astym pri JelSine nad Svetlicami pri chate hranica s CHKO Hostovick luky Pase n nad Pod Bystrim pri Zivanskej vezi Machulince pri Pred Zitavou pod Vel kou skalou pri lyZiarskom vleku Horn domovina Bystri any pri Pod Javorom pod Obecn m vrchom nad Topo iankami pod Za liabkom pod Ostr m Pod Dra m hr dkom UUV P Oo Go Oo Om P 01 I9 P Oo A Oo Go Ga Om GA Dominant stressor None Organic Organic Organic Organic None None Organic Organic Organic organ
26. area Figure 1 Macrophyte sampling surveys were undertaken in late summer early autumn in most cases as stated in the project DoW Macro invertebrates AQEM samples were taken at all sites by each participating partner At each site in the 22 main stream types with a very small number of exceptions each partner also collected samples using a notional national sampling method This was normally a widely used protocol within the individual partner s Member State but the UK RIVPACS protocol was used in three countries Germany Austria and Greece without a common national sampling protocol Wherever possible the sample was taken within the macro invertebrate sampling area which was between 350 450m below the upstream limit of the survey area Figure 1 Both AQEM and national samples were collected in at least two seasons of which one was always spring The second sample was collected in either summer or autumn No firm definitions of the three seasons were applied because of regional climatic differences However March April and May were the most commonly allocated spring months June July and August were the most commonly allocated summer months and September October November were often assigned as autumn Fish Fish sampling was carried out at most sites Sampling was on a single occasion and normally involved two fishing runs of a stop netted area in excess of 100m2 However as stated above a significant minority of
27. barriers within river basin preventing diadromous fish from accessing river segment Down to confluence with the sea Classes 1 to 5 See Appendix 2 Numeric integer Reference cond Assessment Land use segment Impact of agriculture amp silviculture on the river segment level Classes 1 to 5 Segments are defined as 1 km in streams 100 km 5 km in streams 100 1000 km 10 km in streams 71000 km Classes 1 to 5 See Appendix 2 Numeric integer Reference cond Assessment Urbanisation segment Impact of urbanisation on river segment level Classes 1 to 5 See Appendix 2 Numeric integer Reference cond Assessment Table FISHING OCCASION Riparian zone segment Deviation from natural state of riparian zone of Numeric Reference cond the river segment vegetation zone adjacent to integer Assessment stream Classes 1 to 5 See Appendix 2 Floodplain lateral Deviation from natural possibilities for Numeric Reference cond movements segmen movements of biota and water within active integer Assessment t floodplain on the segment scale Classes 1 to 5 See Appendix 2 Sediment load segment Deviation from natural sediment load both Numeric Reference cond transported in water column and deposited in integer Assessment stream bed on the segment scale Classes 1 to 5 See Appendix 2 Hydrological regime site
28. core1 core1 core1 core1 core1 core1 core1 core1 core1 additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional v00C INE e qe1oA ToC 9 68000 1002 0 c Site number 613 614 615 616 617 618 619 620 621 622 623 624 625 626 713 714 715 716 717 718 719 720 721 722 Country Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Czech Republic Stream type C04 C04 C04 C04 C04 C04 C04 C04 C04 C04 C04 C04 C04 C04 C05 C05 C05 C05 C05 C05 C05 C05 C05 C05 Type description small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow m
29. left mouse button the following table containing all STAR sites opens Sitetable X GU e 5 ed crystalline streams of the ridges of the Central Alps h bei Koflach 709 small sized crystalline streams of the ridges of the Central amp lps Stainzbach Bad Sauerbn 704 small sized crystalline streams of the ridges of the Central Alps Stainzbach bei Marhof 706 small sized crystalline streams of the ridges of the Central Alps Stulleggbach bei Aicheag 710 small sized crystalline streams of the ridges of the Central lps Wei e Sulm bei W ernersc 703 small sized crystalline streams of the ridges of the Central Alps Wei e Sulm Sulmklamm 705 small sized crystalline streams of the ridges of the Central lps Wildbach oh Schobert 605 small sized shallow mountain streams GieBenbach uh Grasmuhl 606 small sized shallow mountain streams Hallbach oh Wirnsdo 511 small sized shallow mountain streams Hallbach oh Wiirnsdo 612 small sized shallow mountain streams Kleine Ysper Ausleitung 09 small sized shallow mountain streams Kleine Ysper Ausleitung 01 small sized shallow mountain streams Kleine aper oh Ysperm l 04 small sized shallow mountain streams Sarmingbach oh Angern 607 small sized shallow mountain streams Sammingbach Waldhausen 608 small sized shallow mountain streams Samingbach Werkskanal 610 small sized shallow mountain streams Sammingbach Werksk
30. lower part of each screen Sa Post 1414 17 Note that for several variables you will have help list available if you click on the arrow of the right part of the field In such fields data can also be added by just typing the first letter of the word The rest 15 filled i 1 Geological typology Silicious Geological_formation Sedimentary Mean air temperature ZU Reporter At the start of the first session begin with adding you as the reporters using the form New reporters 1 Push the button New reporters 2 If the table is empty it should be just start to add data 3 If data are already present indicate that new data is to be put in by clicking on Post 14 4 17 et rx New Sites amp Fishing occasions etc A After you have added yourself as a reporter it is time to open New Sites Fishing occasions Catches by simply pushing that button Input fram keyboard form views New Sites Fishing occasions Catches Lengths Length classes Mew Reporters B You will start in the upper purple part of the window i e with information that will be stored in the Site table If the table is empty just start to add data If data are already present later sessions indicate that new data are to be put in by clicking on new Post 14 4 7 mde 86 C Give the Site code Latitude and the Longitude of the site Site Stecode 2 dim Country abbreviation Geciogical typo
31. mountain streams small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps small sized crystalline streams of the ridges of the Central Alps Core or additional core1 core1 core1 core1 core1 core1
32. single species occasionally impact class 4 Passage for certain species or certain years impact class 3 Passage for most species most years impact class 2 No barriers or functioning bypass similar device impact class 1 8 Floodplain lateral movements segment deviation from natural floodplain river system and possibilities for movements of biota and water to and within floodplain water body types only for floodplain rivers no floodplains impact class 5 lt 10 in natural state most types missing impact class 4 lt 25 in natural state some types missing impact class 3 gt 50 in natural state all types present impact class 2 gt 90 in natural state all types present impact class 1 LII Table FISHING OCCASION 9 Sediment_load_segment deviations from natural sediment load increase in the segment Expert judgement Site i e the investigated section where the samples are taken of the stream river 10 Hydrological_regime_site deviation from natural state at the site obligatory Expert judgement Use highest value of impact from variables 11 Natural_flow_pattern_site and 12 Natural_flow_quantity_site if available 11 Natural flow pattern site deviation from natural flow pattern optional lt 50 level and strong deviation from natural yearly variation in flow regime impact class 5 509 level and deviation from natural yearly variation in flow regime i
33. sites 13 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 L Phytobenthos Two sources of replicate data were collected These were a ring test conducted during the second project workshop in La Bresse France and a replicate sampling programme undertaken by a sub set of partners in association with the macro invertebrate replicate sampling programme see below In La Bresse the majority of partners participating in WP7 and WP8 each collected three replicate samples from each of two different substratum types at each of two different sampling sites Each partner sampled two substrata from the three tested hard surfaces sand and macrophytes The results of the ring test are presented in separate deliverable 5b These data are not currently stored in the project database holding the results of the main phytobenthos sampling programme Replicate sampling of phytobenthos alongside the main sampling programme was undertaken in France Greece Portugal Sweden and the UK Results of these samples are stored in the database holding the results of the main phytobenthos sampling programme Macro invertebrates A structured field sampling programme was operated for both STAR AQEM and national invertebrate samples All partners participating in WP7 and or WP7 except Partner 12 LABBIO 21 SAS IZ and 22 DE CUB collected two STAR AQEM and two national samples in each sampling season from each of six of the sites in their individua
34. sites did not meet each of these three parameters In most cases the sampling reach was 100m in length and ideally was located between 150 and 250m below the upstream limit of the survey area Figure 1 However partners were given licence to extend the sampling length upstream in order to attain an adequate representative catch Normally any extension of the sampling area remained within the 500m survey area but there were some exceptions to this practice 12 t 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 g Fish surveys were undertaken in late summer early autumn in most cases as stated in the project DoW Hydromorphology River Habitat Surveys were undertaken on a single occasion at most STAR sites In theory the RHS survey area was selected first and all subsequent sampling locations for the other BQE s were located within the RHS survey area according to the conceptual model Hydromorphological surveys were undertaken in late summer early autumn in most cases as stated in the project DoW Supporting chemical physico chemical and geographical elements A survey of key chemical physico chemical and geographical elements was undertaken at each site This was termed the STAR site protocol and was a cut down version of the protocol developed in the AQEM project The modified AQEM protocol as used in STAR is presented in the Protocols section of the STAR project website The modified version of the AQEM site prot
35. sized small sized small sized small sized small sized small sized small sized small sized small sized shallow lowland streams shallow lowland streams shallow lowland streams shallow lowland streams shallow lowland streams shallow lowland streams shallow lowland streams shallow lowland streams shallow lowland streams shallow lowland streams shallow lowland streams shallow lowland streams shallow lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams Core or additional additional additional additional additional additional additional additional additional additional additional additional additional additional core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 7002 INE LIANA 9 68000 1002 10 vt Appendix List of river and site names pre classified ecological status 5 High to 1 and dominant degradation stress for the stream type High status sites are deemed to have no operating stress and are the reference sites for the stream type Country Austria Austria Austria Austria Austria Austria Austria Austria Austria Au
36. 08 F08 F08 Type description medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams small sized shallow headwater streams in Eastern France small sized shallow headwater streams in Eastern France small sized shallow headwater streams in Eastern France small sized shallow headwater streams in Eastern France small sized shallow headwater streams in Eastern France small sized shallow headwater streams in Eastern France small sized shallow headwater streams in Eastern France small sized shallow headwater streams in Eastern France small sized shallow headwater streams in Eastern France small sized shallow headwater streams in Eastern France small sized shallow headwater streams in Eastern France small sized shallow headwater streams in Eastern France Core or additional core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 additional additional additional additional additional additional additional additional additional additional additional additional v00C AINE e qe1oAToQq 9 68000 100 LD T AAA LC Site number 649 650 651 652 653 654 655 656 657 658 659 660 661 6
37. 2 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 L02 AQEM AQEM AQEM AQEM Nat l Nat l Nat l Nat l Nat l Nat l S AOEN 8 4 Diatoms Diatoms Spring spring season season winter spring spring season season winter winter Fish RHS site main repl 2main 2repl main main repl 2main 2repl main repl man repl phytes protocol 002 AINE T e qe1oAmoq 9 68000 1002 122 05 Site number 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 968 916 917 918 Country Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Stream type 002 002 002 002 002 002 002 002 002 002 002 002 002 003 003 003 003 003 003 003 003 003 003 003 003 003 AQEM AQEM AQEM Nat l Nat l Nat l Nat l Nat l Nat l d 4 Diatoms Diatoms Macro spring spring season season winter spring spring season season winter winter Fish RHS site main repl 2main 2repl main main repl 2main 2repl main repl phytes protocol HFF HF rF v00C INE TE IQLIATOA 9 68000 1002 12 IS AQEM AQEM AQEM AQEM AQEM Nat l Nat l Nat l Nat l Nat l AQEM Site Count
38. 2 6 usually c program AQEMdip20 attention if you changed the e open AQEMdip 2 6 e select Extras in the menu and subsequently select Options in the sub menu e press Connect e when the procedure is finished close the window with the help of the Close button e start working 57 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 d Site amp sample input window The Site amp Sample Input window to begin entering the organisation structure is opened by selecting Data input display in the menu and subsequently selecting Site amp Sample I nput in the submenu The menu bar is equivalent to the main menu bar The Site amp Sample Input window is divided into two sections e the left window shows the organisation structure with sampling sites for which data have already been entered e the right window serves to show and edit data input data input window Note The first line of the organisation structure automatically displays the AQEM country Site and sample input Austr Order Austria crystaline streams of the ridges of the E streame oid Stream type small sized crystalline streams of the ridges of the o Gradnerbach Stream name Schwarze Sulm fo Schwarze Sulm beiKlem
39. 27 628 629 630 631 632 633 634 635 636 637 638 815 816 817 818 819 820 821 822 823 824 Country Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Stream type D03 D03 D03 D03 D03 D03 D03 D03 D03 D03 D03 D03 D03 D04 D04 D04 D04 D04 D04 D04 D04 D04 D04 D04 D04 D06 D06 D06 D06 D06 D06 D06 D06 D06 D06 Type description medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shall
40. 29 Sea of Marmara 19 Irish Sea and the St George s Channel 30 Black Sea 20 Bristol Channel 31 Sea of Azov 21 English Channel 21a Celtic Sea 22 of Biscay 23 North Atlantic Ocean 23a INE Atlantic Ocean Limit 40W LO Table SITE Appendix 3 Criteria to define geology of catchment bedrock variable geological formation The bedrock could be characterised from origin formation processes and acid base content We could distinguish between three major formation processes Igneous Igneous rocks formed by direct crystallization of minerals from a magma melt Intrusive plutonic rocks crystallize at depth whereas extrusive volcanic and pyroclastic rocks rocks crystallize after the magma reaches the earth s surface In general extrusive rocks have a finer grained texture than intrusive rocks Sedimentary rocks Sedimentary rocks are those rocks which form at or near the earth s surface at relatively low temperatures and pressures by either deposition by water wind or ice or precipitation from solution may be biologically mediated and or growth in position by organic processes e g limestone formed from carbonate reefs Metamorphic rocks Metamorphic rocks form from other rocks by changes in mineralogy and or texture as a result of a change in chemical and or physical environment Out of the classes required by the WFD calcareous is found in the sedimentary rocks whereas siliceous may be present in al
41. 2main 2 Nat l Nat l Diatoms Diatoms Macro 5 main main repl AQEM Fish RHS site protocol phytes 002 AINE T e qe1oAmoq 9 680007 100C LO DMAH AQEM AQEM AQEM AQEM AQEM Nat l Nat l Nat l Nat l Nat l Nat l Site Stream S e i 2 Diatoms Diatoms 2 n mber Country type spring spring season season winter spring spring season season winter winter Fish RHS site main repl 2main 2repl main main repl 2main 2repl main repl manm repl protocol 613 Czech Republic C04 614 Czech Republic C04 615 Czech Republic C04 616 Czech Republic C04 617 Czech Republic C04 618 Czech Republic C04 619 Czech Republic C04 620 Czech Republic C04 621 Czech Republic C04 622 Czech Republic C04 623 Czech Republic C04 624 Czech Republic C04 625 Czech Republic C04 626 Czech Republic C04 714 Czech Republic C05 715 Czech Republic C05 716 Czech Republic C05 717 Czech Republic C05 718 Czech Republic C05 719 Czech Republic C05 720 Czech Republic C05 721 Czech Republic C05 722 Czech Republic C05 v00C AINE TE e qe1oAmoQq 9 680007 100C LO DMAH AQEM AQEM AQEM Nat l Nat l Nat l Nat l Nat l Nat l f AQEM sprin spring season season winter sprin spring season season winter winter Diatoms Diatoms Macro Fish RHS site pring spring pring spring main phytes Site Co ntr Stream number y type or 662 Denmark K02 663
42. 4 Appendix IV The AQEMDIP V2 6 User Manual 23 07 2004 A AQEMER Manual for the AQEM data input program AQEMDIP Version 2 6 Installation and first run e Installation of the AQEMdip starts by running the setup exe e The setup is installing the program to a folder of your choice and automatically creates two subfolders one for the databases one for pictures e Start the AQEMdip e Login see below e Select the menu Extras and subsequently the submenu Options e The program automatically sets the paths to the databases e Press Connect and a progress bar shows that the program is connecting to its databases e Close the program and restart it again e During the following program start the user is asked to enter a country for future data input e Once the country is entered automatically gt the organisation structure AQEM country will be initialised and the corresponding taxalist is loaded into the program Note You cannot change the country after the first start To change the country the program must be installed again Login For login enter Agem in the field User and AQEM in the field Password please notice that the password has to be written in capital letters The login password can not be changed in the current program version Backup of your data It is recommended to make backups of your data on a regular base The data you have entered into AQEMdip are stored in the subfolder installation di
43. 6 506 506 506 506 506 AQEM AQEM AQEM Nat l Nat l Nat l Nat l Nar Diatoms Diatoms Macro spring spring season season winter spring spring season season winter winter Fish RHS main repl 2main 2repl main main 2main 2 H IT iR main phytes omplete AQEM site protocol v00C AINE TE e qe1oAmoQq 9 680007 100C LO DMAH ES AQEM AQEM Nat l Nat l Nat l Nat l Nat l Site Stream d 2 gt Diatoms Diatoms n mber Country type spring spring season season winter spring spring season season winter winter Fish RHS site main repl 2main 2repl main main repl 2main 2repl main repl repl phytes protocol 639 United Kingdom U15 640 United Kingdom U15 641 United Kingdom U15 642 United Kingdom U15 643 United Kingdom U15 644 United Kingdom U15 645 United Kingdom U15 646 United Kingdom U15 647 United Kingdom U15 648 United Kingdom U15 889 United Kingdom U15 890 United Kingdom U15 891 United Kingdom U15 674 United Kingdom U23 675 United Kingdom U23 676 United Kingdom U23 677 United Kingdom U23 678 United Kingdom U23 679 United Kingdom U23 680 United Kingdom U23 681 United Kingdom U23 682 United Kingdom U23 683 United Kingdom U23 892 United Kingdom U23 893 United Kingdom U23 00 AINE TE e qe1oATo QT 9 68000 1002 12 6 Deliverable 31 July 200
44. 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 e In addition to the possibilities of the site protocol the option not available na was added for parameters which were not or could not be collected Values in tables can be edited after being double clicked The tabulator key selects the input fields in numerical order In tables the correctness of input is checked 5 96 10 96 steps Sum 100 96 A correct sum is marked green an incorrect one is marked red Error check Data can be checked for correctness by pressing the button Error check Incorrect or empty fields will be BESSERES a window will open and will show the results of the error check 12 ecoregion and no Alps ch 16 size typology ES 1019100 kr The following parameters checked whether the fields are empty or not whether fields contain letters instead of digits whether data correspond with selection list entries whether values were selected in optional fields whether the sum of tables add up to 100 96 Note The program cannot check whether or not the values entered are reasonable or not When you open the site protocol display all values are noted as missing in the database and more than 150 errors occur if the input window is closed without data entry Please perform the error check before closing the site protocol and correct any possible errors otherwise data can be lost if an error occurs during saving data to the database Com
45. 8 Tsivlos Prevedos Aptera Gadouras Gorgopotamos Bridge Gorgopotamos Village Rio della Cascata at km 3 3 Rio S Nicol at km 1 4 Rio di Camin at km 5 2 Rio Gardena at km 11 7 Rio Gardena at km 4 4 Rio Gardena at km 2 3 Rio Funes at km 2 7 Rio Stolla at km 9 4 Rio Stolla at km 6 9 Rio Sesto at km 15 8 Farma lesa SI reference downstream Albegna Roccalbegna GR reference Merse Monticiano SI Feccia Monticiano SI Lente downstream Pitigliano GR Senna Piancastagnano SI SS 2 Paglia Piancastagnano SI SS 2 Fiora downstream farm S Fiora GR Fiora Cellena GR Zancona loc Zancona GR reference Ente downstream Podere dei Frati GR Status SO OD P gt UN OM P Go P Oo MO P GM OO Dominant stressor Organic Organic None Organic None Organic Organic Organic None Organic None Habitat Habitat Habitat Habitat None Habitat Habitat None Habitat None None Habitat Habitat Habitat Habitat Habitat Habitat Habitat None Habitat 7002 INE TE e qe1oAmoQq 9 680007 100C LO DMAH 6t Site number 997 998 999 1006 1007 1017 1018 1019 1020 1021 1022 1023 1024 1031 1035 996 1002 1005 1010 1013 1016 1027 1030 1034 Country Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia
46. Aube Seine Aujon Rognon Ornain Meuse Bassoncourt Anger Madon Meuse Bourg Sainte Marie Mouzon Sa nelle Site name Noerre Grene Stids Moelle Roede Moelle Noerre Linaa Hoegild Edderup Okkels Lillemoelle Skibstedbro Faarup Jerslev bro Koed Ignon upstream Fresnois Aube at Aubepierre sur Aube Seine at the Ermitage du Val de Seine Aujon upstream Giey sur Aujon Rognon at Montot sur Rognon Ornain downstream Abainville Meuse between Daillecourt and Bassoncourt Anger downstream Jainvillotte Madon at Hag court pont bleu Meuse between Bourg Sainte Marie and Bourmont Mouzon at Sartes Sa nelle downstream Villouxel Status i000 Oo Oo Oo Oo gt zb sch P bu Dominant stressor None None None Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat None None None Organic Organic Organic Organic Organic Organic Organic Organic Organic v00C INE TE e qe1oAToQT 9 68000 1002 122 LE Site number 649 650 651 652 653 654 655 656 657 658 659 660 661 627 628 629 630 631 632 633 634 635 636 637 638 815 816 817 818 819 820 821 822 823 824 Country Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Germany Ger
47. BI Mara Dzene Laboratory processing U Field sampling data input Slovak Academy of Sciences SAS IZ Ferdinand Sporka Field sampling macroinvertebrate identification Slovak Academy of Sciences SAS IZ Elena Stefkova Field sampling diatom identification Slovak Academy of Sciences SAS IZ Ladislav Hamerlik Field sampling macroinvertebrate identification Slovak Academy of Sciences SAS IZ Zuzana Zatovicova Field sampling macroinvertebrate identification Slovak Academy of Sciences SAS IZ Zuzana Pastuchova Field sampling data input Slovak Academy of Sciences SAS IZ Maria Gudabova Sorting Slovak Academy of Sciences SAS IZ Maria Nagyova Laboratory processing Slovak Academy of Sciences SAS IZ Silvia Kubalova Field sampling macrophyte identification Slovak Academy of Sciences SAS IZ Daniela Illesova Field sampling macroinvertebrate identification Slovak Academy of Sciences SAS IZ Tomas Cejka Macroinvertebrate identification Comenius University Bratislava DE CUB Eva Bul nkov Field sampling macroinvertebrate identification other flies various Diptera dragonflies RHS Comenius University Bratislava DE CUB Ol ga Michal kov Sorting Comenius University Bratislava DE CUB Andrea Rodriguez Sorting Comenius University Bratislava DE CUB Beata Slez kov Field sampling Comenius University Bratislava DE CUB Vladimir Kova
48. Denmark K02 664 Denmark K02 665 Denmark K02 666 Denmark K02 667 Denmark K02 668 Denmark K02 669 Denmark K02 670 Denmark K02 671 Denmark K02 672 Denmark K02 673 Denmark K02 723 France F08 724 France F08 725 France F08 726 France F08 727 France F08 728 France F08 729 France F08 730 France F08 731 France F08 732 France F08 733 France F08 734 France F08 main repl 2 main 2 main main repl 2main 2 protocol 7002 AINE TE e qe1oAmoq 9 680007 100C LO DM AH LV AQEM AQEM Nat l Nat l Nat l Nat l Nat l Nat l AQEM Site Stream 4 p Diatoms Diatoms Macro number Country type spring spring season season winter spring spring season season winter winter Fish RHS site main 2main 2repl main main 2main 2repl main repl phytes protocol 649 Germany D03 650 Germany D03 651 Germany D03 652 Germany D03 HESE 653 D03 654 Germany D03 655 Germany D03 656 Germany D03 657 Germany D03 658 Germany D03 659 Germany D03 660 Germany D03 661 Germany D03 627 Germany D04 628 Germany D04 629 Germany D04 630 Germany D04 631 Germany D04 632 Germany D04 633 Germany D04 634 Germany D04 635 Germany D04 636 Germany D04 637 Germany D04 638 Germany D04 815 Germany D06 816 Germany D06 817 Germany D06 818 Germany D06 819 Germany D06 820 German
49. Field sampling laboratory processing University of Latvia Institute of Biology LUBI Agnija Skuja Field sampling laboratory processing data input University of Latvia Institute of Biology LUBI Martins Mazurs Field sampling laboratory processing data input Jniversity of Latvia Institute of Biology LUBI Vjaceslavs Kulikovs Data input niversity of Latvia Institute of Biology LUBI Ilze Zilvere Laboratory processing Vita Salavejus Laboratory processing Jniversity of Latvia Institute of Biology LUBI Kristine Evalde Laboratory processing U U University of Latvia Institute of Biology LUBI U U niversity of Latvia Institute of Biology LUBI Aiva Eindorfa Laboratory processing niversity of Latvia Institute of Biology LUBI Janis Birzaks University of Latvia Institute of Biology LUBI Agrita Briede Field sampling data input University of Latvia Institute of Biology LUBI Andris Urtans Field sampling data input University of Latvia Institute of Biology LUBI Lelde Engele Field sampling University of Latvia Institute of Biology LUBI Gunta Springe Field sampling data input University of Latvia Institute of Biology LUBI Ivars Druvietis Field sampling University of Latvia Institute of Biology LUBI Linda Eglite Field sampling laboratory processing University of Latvia Institute of Biology LU
50. IIW I Bertahas Chemical analysis amp hydrochemistry Hellenic Centre for Marine Research HCMR IIW A Diapoulis Data acquisition processing amp input Hellenic Centre for Marine Research HCMR IIW K Bogdanos Data acquisition processing amp input Hellenic Centre for Marine Research HCMR IIW S Zoggaris Electrofishing sampling fish fauna data process National amp Kapodistrian University of Athens S C B Montesantou Diatoms identification National amp Kapodistrian University of Athens S C L Koumpli Macrophytes identification Consiglio Nazionale delle Richerche CNR IRSA Not yet supplied niversity of Evora Joana Rosado Macroinvertebrate sampling identification and input niversity of Evora Silvia Fernandes fish sampling identification and imput niversity of Evora Agronomical Institute Francisca Aguiar Macrophytes sampling identification niversity of Evora Agronomical Institute Ant nio Albuquerque U University of Evora Elsa Mourinha Macroinvertebrate sampling identification and input University of Evora Rita Ramalhinho Macroinvertebrate sampling identification and input University of Evora Helena Novais Diatom sampling identification and input University of Evora Susana Nunes Diatom sampling identification and input University of Evora Manuela Morais RHS University of Evora Jo o P dua RHS University of Evora Ana Sofia Pedro RH
51. Plytnica Drzewce Jazwiny Maczkow Kraplewo Katy Dziedzice Lutomiersk Jamborek Kiszkowo Gradki Dolne Zawady Szrensk Podkamionka Krolowy Most Walily Stacja Babia Gora Stara Bialowieza Podolany Stopily Hajnowka Jozefowo Szczebra Wolkusz Status PO Oc gt OO GA P P AURA Dominant stressor None None None Organic Organic Organic Organic Organic Organic Organic Organic Organic None Organic Organic Organic Organic Organic None None Organic Organic Organic Organic Organic v00C INE TQLIATOA 9 680007 100C LO DMAH Iv Site number 859 860 861 862 863 864 865 866 867 868 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 Country Portugal Portugal Portugal Portugal Portugal Portugal Portugal Portugal Portugal Portugal Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Slovakia Stream type P04 P04 P04 P04 P04 P04 P04 P04 P04 P04 vo1 V01 V01 V01 V01 V01 V01 V01 V01 V01 V01 V01 vo2 vo2 vo2 vo2 vo2 vo2 vo2 vo2 vo2 vo2 vo2 vo2 vo2 Core or additional additional additional additional additional additional additional
52. S Dominant stressor None None Organic Organic Organic Organic Toxic Toxic Toxic Toxic Toxic None None Organic Organic Organic Organic Organic Organic Organic Organic Organic v00C INE e qe1oA ToC 9 68000 1002 12 tr Site number 639 640 641 642 643 644 645 646 647 648 889 890 891 674 675 676 677 678 679 680 681 682 683 892 893 Country United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom Stream type River name U15 U15 U15 U15 U15 U15 U15 U15 U15 U15 U15 U15 U15 U23 U23 U23 U23 U23 U23 U23 U23 U23 U23 U23 U23 Ecchinswell Brook Sweatford Water Tadnoll Brook Westbury Brook Tadnoll Brook Barkham Brook Caundle Brook Cuddington Brook Pill River Cliff Brook Hyde Brook Arrowe Brook Wettenhall Brook Clun Llynfi Onny Monnow Ogmore Onny Rhymney Sirhowy Dean Cole Tame Darwen Site name Headley Fordingbridge Old Knowle Westbury Crossways Arborfield Glanvilles Wootton Cuddington Blue Anchor Crowton Bishops Cleeve Moreton Wettenhall Marlow Glasbury Plowden Woods
53. S University of Evora Santiago del Ser fish sampling identification and imput University of Evora Maria Ilh u fish sampling identification and imput U U U Macrophytes sampling identification v00C INE e qe1oAToQT 9 68000 1002 0 University of Evora Agronomical Institute Patr cia Gonzalez Macrophytes sampling identification National Environment Research Institute NERI Jens Skriver Field sampling macroinvertebrate ID National Environment Research Institute NERT Johnny Nielsen Field sampling sorting macroinvertebrate ID National Environment Research Institute NERT Dorte Nedergaard Field sampling chemical analysis National Environment Research Institute NERD Louise Korsgaard Field sampling diatom ID National Environment Research Institute NERT Silke S Johannsen Field sampling diatom ID National Environment Research Institute NERT Morten L Pedersen Field sampling hydromorphology National Environment Research Institute NERI Annette Baattrup Pedersen Field sampling macrophyte ID National Environment Research Institute NERTI Torben L Lauridsen Field sampling macrophyte ID National Environment Research Institute NERI Marianne Pedersen Data input and handling National Environment Research Institute NERI E Larsen Data handling National Envi
54. Site segment and catchment up stream distance depending on influence Site Site Site Site Site Site Site Site Site Site Instructions Unfortunately there has been no time to give a live demonstration of the data input procedures We trust that you have national competence in the matter If problems occur or if you have questions please mail us Character encoding First of all we emphasise that you follow some instructions to enable use of all national characters for FIDES Many of the TrueType fonts included in Microsoft Office 2000 supports a number of languages with different characters Arial Unicode MS included in the Office package is a complete font containing all of the 40 000 alphabetic characters ideograph characters and symbols which are defined in the Unicode standard 2 1 The empty FIDES Access database will be prepared using this font If you did not install the font Arial Unicode MS when you installed Microsoft Office 2000 or another Office program you can reinstall Office and choose add remove functions Press the plus sign beside Office tools and then on the plus sign beside International support After that click the icon at Universal fonts and finally choose the alternative you wish Reinstall Microsoft Office To follow this procedure is necessary as we understand it for all who are putting in data in the national contributions to FIDES This is most important for the final FIDES in MS SQL 2000 ve
55. Standardisation of river classifications Framework method for calibrating different biological survey results against ecological quality classifications to be developed for the Water Framework Directive qo Contract No 1 2001 00089 6th deliverable due 31 07 04 entitled Results of the sampling programme Paper version Compiled by Mike T Furse Astrid Schmidt Kloiber J org Strackbein John Davy Bowker Armin Lorenz Johan van der Molen and Pete Scarlett Partners no 1 CEH United Kingdom 2 BOKU Austria 3 UDE Germany and 4 Alterra The Netherlands A project under the 5m Framework Programme Energy Environment and Sustainable Development Key Action 1 Sustainable Management and Quality of Water Contents 1 INTRODUCTION 1 1 Objectives 1 2 Format of the deliverable METHODS 2 Participating partners 2 2 Site selection 2 3 Biological Quality Elements 2 4 Sampling methods 2 5 Sampling programme 2 5 The main sampling programme 2 5 2 The replicate sampling programme 2 6 Site numbering 2 7 Sample survey numbering 2 8 Taxon codes 2 9 Databases 3 RESULTS 3 1 Databases 3 1 1 Phytobenthos macro invertebrates and site protocol AQEMDIP 2 6 3 1 2 Macrophyte database 3 1 3 Hydromorphology RHS database 3 1 4 Fish database 3 2 Number of samples 3 3 Software supplied 4 DISCUSSION 5 REFERENCES APPENDICES I II IV V VI List of stream types and catego
56. Street POB Street address or post box number if applicable String 50 QA positions City Name of city String 30 QA Drottningholm positions State province If applicable String 30 QA positions Postal code Zip or postal code including country abbreviation String 20 QA SE 178 93 positions Country Name of the country in English String 20 QA Sweden positions Email Email address of the responsible person String 50 QA erik degerman positions fiskeriverket se v6 Table SITE VARIABLE EXPLANATION TYPE USED FOR PRECISION 0 EXAMPLE Site code Country abbreviation your own code of the String 15 Database GEBAO0001 site e g GE0001 could be site 1 in Germany positions first 001 could instead be used and would perhaps two letters mean site number 1 in Bavaria Germany always capital Site name Your national name identifying the site String 30 Database Optional positions Latitude Latitude in Degrees MinutesSeconds String 8 Database 54 3501N Degrees followed by decimal point and then positions Minutes and Seconds two digits each written after one another as decimals Note if more than four decimals 1 e decimals of Seconds the number should be rounded to four decimals Latitude is always followed by N no space in between Measure preferably from the downstream beginning of the site Longitude Latitude in Degrees MinutesSeconds String 8 Database 10 0445E Degrees f
57. The STAR project inherited and enhanced the AQEM eight character sample numbering system through the addition of eight further descriptive characters The two 8 character components sample number and sample descriptor combine to form a 16 character sample code Character 1 of the sample code represents the country of origin of the sample A Austria C Czech Republic D Germany H Greece K Denmark L Latvia M Finland N The Netherlands O Poland P Portugal S Sweden U United Kingdom V Slovak Republic W Norway Characters 2 and 3 represent the stream type Characters 4 to 7 are unrestricted digits selected by the individual partners for that sample They may or may not include hierarchical information according to the decisions of individual partners Character 8 represents the sampling season 1 spring 2 summer 3 autumn 4 winter Character 9 represents the biological quality element I macro invertebrates P phytobenthos Character 10 defines the sampling method S STAR AQEM Mcooriginal AQEM Q Italian AQEM R RIVPACS C PERLA B IBE E EBEO I IBGN A Austrian method K DSFI method L LVS 240 1999 P Portuguese method O Polish method V CSN 83 0532 1981 W Swedish method X other invertebrate method D Diatoms Character 11 indicates main or replicate sampling Character 12 defines the phytobenthos substratum if available H hard M macrophyte S sand silt Characters 13 and 14 repres
58. U O Moog Field sampling BOKU H Nesemann Identification BOKU T Ofenb ck Field sampling BOKU K Pall Identification BOKU A Schmidt Kloiber Field sampling BOKU M Seebacher Data input BOKU F Sporka Identification BOKU G Unfer Field sampling BOKU G Wassermann Identification BOKU P Wenzl Field sampling laboratory processing BOKU C Wiesner Field sampling data input Donabaum amp Wolfram sub contractor BOKU R Mutschlechner Laboratory processing Donabaum amp Wolfram sub contractor BOKU J R mer Field sampling laboratory processing Donabaum amp Wolfram sub contractor BOKU T Schuh Field sampling Department of Environmental Assessment SLU Berta Andersson Macrophyte identification Department of Environmental Assessment SLU Oskar Andersson Field work laboratory processing Department of Environmental Assessment SLU Jenny Bergfur Field work data input Department of Environmental Assessment SLU Therese Carlsson Field work data input Department of Environmental Assessment SLU Joakim Dahl Field work poo AINE 9148 9 Department of Environmental Assessment SLU Lars Eriksson Field work macroinvertebrate identification Department of Environmental Assessment SLU Jens F lster Field work Department of Environmental Assessment SLU Willem Goedkoop Field work Department of Environmental Assessment SLU Amelie Jarlman Phytobentos i
59. Y Y Y Y MM DD positions Species Scientific name of species see Table TAXA String 30 positions Database Aspius aspius AND GUILDS first letter of genus Model name always capital remaining letters normally in lower case letters Type of data Indicate if the whole catch or a subsample was measured Codes All Subsample Minmax Other String 10 positions first letter always capital and the rest in lower case Further work Length type Total length or Fork length String 5 positions first letter always capital and the rest in lower case Further work Total Length Length of individual in mm Numeric integer 4 positions Further work 345 9cI Table LENGTH TABLE is OPTIONAL to be used if individual lengths are available VARIABLE EXPLANATION TYPE USED FOR EXAMPLE PRECISION Site code See Table SITE String 8 Database LT001 positions first two letters always capital Latitude See Table SITE String 8 Database 55 3501N positions Longitude See Table SITE String 8 Database 24 0445E positions Date Date of sampling given as Microsoft date Date format 10 Database 2002 05 14 format Format Y Y Y Y MM DD positions Species See Table CATCH Type of data Indicate if the whole catch or a subsample was String 10 positions Further work All measured Codes All Subsample Minmax O
60. a Sumice Olesna Drahansky potok Usobrnsky potok Umori Bykovka Huntava Sitka Trusovicky potok Oslava Luha Nemilka Oskava Drazuvka Trebuvka Trebuvka Site name Luborca Rychtarov Ruprechtov Biskupice Suchovske mlyny Mlynky Vicov Brezinky Kandia Zvole Myslejovice Novy Dvur Zbraslavec Cerna Hora Valsovsky dul Horni Zleb Belkovice Techanov Sloup Ruzove udoli Oskava Sumvald Dlouha Loucka Borsov Status gt P P P PP Oo o gt P P P Oo Om Oo Dominant stressor None None None Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic Organic v00C INE AGeIOATIOC 9 None None None Habitat Habitat Habitat Habitat Habitat Habitat Habitat 68000 100 LD T AAA 9t Site number 662 663 664 665 666 667 668 669 670 671 672 673 723 724 725 726 727 728 729 730 731 732 733 734 Country Denmark Denmark Denmark Denmark Denmark Denmark Denmark Denmark Denmark Denmark Denmark Denmark France France France France France France France France France France France France Stream type River name K02 K02 K02 K02 K02 K02 K02 K02 K02 K02 K02 K02 F08 F08 F08 F08 F08 F08 F08 F08 F08 F08 F08 F08 Karstoft Aa Mattrup Aa Lindenborg Aa Sunds Noerre Aa Rind Aa Kastbjerg Aa Fjederholt Aa Tange Aa Skibsted Aa Skals Aa Ry Aa Ryom Aa Iignon
61. ain streams in Western Central and Southern Greece small sized calcareous mountain streams in Western Central and Southern Greece small sized calcareous mountain streams in Western Central and Southern Greece small sized calcareous mountain streams in Western Central and Southern Greece small sized calcareous mountain streams in Western Central and Southern Greece small sized calcareous mountain streams in Western Central and Southern Greece small sized calcareous mountain streams in Western Central and Southern Greece small sized calcareous mountain streams in Western Central and Southern Greece small sized calcareous mountain streams in Western Central and Southern Greece small sized streams in the southern calcareous Alps small sized streams in the southern calcareous Alps small sized streams in the southern calcareous Alps small sized streams in the southern calcareous Alps small sized streams in the southern calcareous Alps small sized streams in the southern calcareous Alps small sized streams in the southern calcareous Alps small sized streams in the southern calcareous Alps small sized streams in the southern calcareous Alps small sized streams in the southern calcareous Alps small sized calcareous streams in the Central Apennines small sized calcareous streams in the Central Apennines small sized calcareous streams in the Central Apennines small sized calcareous streams in the Central Apennines small sized calcareous streams in the
62. al 23 Weed cutting site Cutting of weeds at the site Classes 1 to 5 Expert judgement Optional Performed several times a year impact class 5 Performed on average once a year or every second year impact class 4 Has been performed within the last five years impact class 3 Has been performed more than five years ago impact class 2 Never performed impact class 1 Table HISTORICAL VARIABLE EXPLANATION TYPE USED FOR EXAMPLE PRECISION MANET Site code See Table SITE Period start Starting year of specific period from which data Numeric Database 1600 originate integer 4 Model positions 7 5 Period end Ending year of specific period from which data Numeric Database 1699 originate integer 4 Model positions 7 755 Period string More specific definition of period Optional String 25 Database 1650 s to positions Model 1680 s Species Scientific name of species see Table TAXA String 30 positions Database Salmo salar AND GUILDS first letter of genus Model name always capital remaining letters normally in lower case letters Status scale class 0 not found Numeric Database 5 1 probably present in river basin integer 1 Model 2 present in river basin position 3 probably present in river segment 4 present in river segment 5 probably present at site 6 present at site Abundance_class Optional Numeric Database 2 3 high abunda
63. ams Corel Habitat Germany Small sized Buntsandstein streams Add Habitat Greece Small calcareous mountain streams in W Central amp S Greece Add Organic Italy Small sized streams in the southern calcareous Alps Add Habitat Italy Small sized calcareous streams in the Central Apennines Add Habitat Latvia Medium sized lowland streams Core2 Organic Poland Medium sized lowland streams Eco region 14 Core2 Organic Poland Medium sized lowland streams Eco region 16 Core2 Organic Portugal Medium sized streams lower mountainous areas in Southern Portugal Add Organic Slovakia Small sized calcareous mountain stream in the E Carpathians Add Organic Slovakia Small sizes siliceous mountains streams in the W Carpathians Add Organic Sweden Medium sized lowland streams Core2 Mixed Sweden Medium sized streams on calcareous soils Add Organic UK Small sized shallow lowland streams Add Organic UK Medium sized lowland streams Core2 Organic 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 L Combined site selection strategy For each stream type in each country a roughly defined number of sites was sampled for each level of ecological status High 3 sites Good 3 sites Moderate 2 sites Poor 2 sites and Bad ca 2 sites except that Ecological Status is considered unlikely to occur and was not recognised for habitat degradation A list of sites domin
64. anal 600 small sized shallow mountain streams Sarminabach Wolsschucuad select site including stream type and stream name press the OK button the information of the site table will automatically be transferred into the Site amp Sample Input window if you do not want to make any further corrections press the Accept button Entering new sites not sampled in STAR go to AQEM country in the left window and click the right mouse button select New stream type name with the left mouse button a blinking cursor will now appear in the field stream type in the right data input window enter the appropriate stream type here enter the stream name in the proceeding field press the Accept button to enter a second stream type name select first stream type name or AQEM country in the left window with the right mouse button select New stream type name enter the second stream type name on the right side of the window press the Accept button all further stream types names should be entered in the same manner 59 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 g Entering the site name e Click the appropriate stream name with the right mouse button in the left window e select New site name with the left mouse button e a blinking cursor will now appear in the field site name in the right data input window enter the appropriate site name here e press the Accept button e to enter a second site name select f
65. another sample unit e press the Taxa paste button e add the frequencies of the new taxa 66 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 g Note To avoid double entries of the same taxon it is only possible to copy taxa into an empty sample unit Macro invertebrate data import Existing macro invertebrate data files can be imported into AQEMdip 2 6 via an import interface for MS Excel data files Before the data import can be started it is necessary to create the whole sample structure i e it is necessary to enter a stream type a stream name a site name a sampling date a sample number a sample unit name After this is done e click the appropriate sampling site with the right mouse button in the left window e select Edit with the left mouse button e data input window according to your preceding choices opens e to import an Excel file click the button Excel import at the lower end of the form The macro invertebrate taxa input taxa import window opens e Click on the button and select an Excel file from your hard disk e press the Load button to load the file e select an Excel sheet within the loaded file e define the columns in which the taxa names are stored in your Excel file e define the rows that should be imported e define the columns in which the number of individuals are stored Note The selection lists and names of the columns change according to the method defined when creating the sample unit
66. ant stresses and pre classified ecological status is provided in Appendix II 2 3 Biological Quality Elements The WFD recognises four Biological Quality Elements that must or should be sampled in rivers for specific monitoring purposes with specific emphasis on their inclusion for surveillance monitoring These are e Phytoplankton Macrophytes and phytobenthos e Benthic invertebrate fauna e Fish fauna The WFD states section 1 3 1 of Annex V that Surveillance monitoring shall be carried out for each monitoring site for parameters indicative of all biological quality elements The STAR project sampled three of these elements macrophytes and phytobenthos benthic invertebrates and fish Separate sampling programmes were established for macrophytes and for phytobenthos which for the purposes of the project were regarded as two distinct BQE s The paucity of phytobenthos in the small streams sampled in the STAR project led to their exclusion from the sampling programme on the basis that they could not be measured with adequate confidence and precision WFD Section 1 3 Annex V Surveillance monitoring programmes for the purposes of the classification of ecological status of rivers as defined by the WFD Section 1 1 1 Annex V also requires monitoring for supporting elements including hydromorphological elements chemical and physicochemical elements and specific pollutants The STAR sampling programme
67. areous Alps Italy Small sized Buntsandstein streams Germany Small sized crystalline streams of the ridges of the Central Alps Austria Additional stream types were selected to fulfil four potential roles as defined in the agreed project Description of work DoW They were intended to e allow new characteristic sites of individual states to be included in the analysis e provide an opportunity to extend the range of sites in existing European assessment systems e extend the range of sites at which the AQEM and RIVPACS field methods are compared e provide an opportunity to test alternative sampling assessment methods of specific importance to individual consortium Member States e g IBGN IBE and PERLA The additional site sets were selected according to the same set of System A criteria as the core stream sites and some additional site sets therefore categorised in the same System A compartments as the core stream sites whilst others did not t 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 g Thus all the 22 sets of sites Table 1 ultimately used in the project for data collection were therefore defined hierarchically by the same following criteria a Eco region b Site altitude Catchment area of site Geology c Specific geographical and environmental characteristics Table 1 The numbers sets of sites site types sampled in each country Country Core stream type
68. ation from natural state of P N and TOC Numeric Reference cond site of the investigated site Classes 1 to 5 See integer Assessment Appendix 2 Introduction of fish site Impact on natural fish populations by species Numeric Reference cond new to the river basin on the investigated site integer Assessment Classes 1 to 5 See Appendix 2 Impact of stocking site Impact of stocked fish i e already present Numeric Reference cond within river basin on natural fish fauna on the integer Assessment investigated site Classes 1 to 5 See Appendix 2 Exploitation site Impact of human exploitation e g fishing on Numeric Reference cond the investigated site Classes 1 to 5 See integer Assessment Appendix 2 Fauna impact site Effects on fish fauna on the investigated site Numeric Reference cond from introduced species invasive species or integer Assessment rapidly increasing species not fish e g predation parasitism competition Classes 1 to 5 Appendix 2 Flora impact site Unnatural increase in water vegetation Numeric Reference cond including helophytes reeds and submerged integer Assessment macrophytes on the investigated site Classes 1 to 5 Appendix 2 Weed cutting site Cutting of weeds on the investigated site Numeric Reference cond Classes 1 to 5 Appendix 2 integer Assessment Table FISHING OCCASION Appendix 1 The lowest common particle denominator or how to
69. ave the data in digital form already and have a computer wizard at the department 83 Definitions Field The smallest piece of data in a table Record A collection of all fields occupying a single row of a table Table The spreadsheet where the data are stored Forms A method of entering displaying and searching data in other than the spreadsheet like environment of tables and queries a graphical user interface Reports Summarizes and formats data in the look that you want for either table or query data Object Components that make up a database 1 tables forms queries reports macros amp modules In FIDES The input is made in a form named Site Subform to the Site form is the form Fishing occasion Subform to the Fishing occasion form is the form Catches Subforms to Catches are Length and Length class The linking of forms and subforms allows you to just put in e g Latitude once but still to have it stored in each table This way the number of errors are reduced and the tables are directly linked together Navigation and essential key combinations There are numerous ways to maneuver through an Access table If you want to just look through the table without moving the cursor highlight use the scroll bar on the right side of the table However if you want to move the highlight as you move down the table you can use the down arrow lt Dn gt or the page down lt PgDn gt keys The same is true if you are mo
70. ce Biologique Global Normalis IBGN is widely used in France In STAR the method was only used in France DSFI This protocol is the national sampling method associated with the calculation of the Danish Stream Fauna Index DSFI STAR this method was only used in Denmark t 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 LVS 240 1999 This method is the national protocol for Latvia In STAR this method was only used in Latvia Swedish The un named Swedish national sampling protocol was only used in Sweden in the STAR project PERLA The PERLA method is widely used in the Czech Republic The method is associated with a predictive software system similar to the UK RIVPACS In STAR this method was only used by the Czech and Slovak partners Polish The un named Polish national sampling protocol was only used in Poland in the STAR project Portuguese An un named Portuguese sampling protocol was only used in Potugal in the STAR project All methods using hand nets were compatible with the CEN Standard on the handnet sampling of aquatic macro invertebrates EN 27828 Fish The fish sampling protocol as published on the Protocols page of the STAR website required catch depletion fishing using stop nets The majority of partners followed the protocol but a minority either did not use stop nets or did not use depletion fishing or did not use either The STAR protocol was derived from and is compatible with the secti
71. classify substrate FAMEwise measurements are in mm and refer to particle diameter The suggestion for FAME is in boldface below Note that apart from the simple classes as Sand or Rock it is also permitted to use compound classes e g PebbleCobble Allowed classes are in boldface below U S Class CEN Baden W rttenberg Sweden AQEM U S Colorado Indiana Organic Text definition Not defined Not defined Not defined Not defined Not defined Clay Text definition Not defined Not defined Not defined 0 004 0 002 Silt Text definition Not defined 0 2 0 004 0 06 0 002 0 02 Sand lt 2 lt 2 0 2 2 lt 2 0 06 2 0 02 4 8 Gravel 2 16 2 20 2 20 2 20 2 20 4 8 75 Pebble 16 64 20 63 20 100 20 60 20 64 Not defined Cobble 64 256 63 500 100 200 60 200 64 256 75 300 Boulder 1 gt 256 gt 500 200 2000 200 400 P256 2300 Rock Continuos gt 2000 gt 400 rock FAME Classes Note Additional classes allowed Fine 0 2 Or as close as national standard permits FineSand lt 2 0 2 2 Or as close as national standard permits GravelPebble 2 60 Gravel 2 20 Or as close as national standard permits PebbleCobble 20 200 Pebble 20 60 Or as close as national standard permits CobbleRock gt 60 Cobble 060 200 Or as close as national standard permits BoulderRock gt 200 Boulder gt 200 Or as close as national standard permits Rock Continuos Or as close as nat
72. cols associated with the Mean Trophic Rank MTR indexation method This method is the standard procedure used in the United Kingdom in association with the implementation of the European Union Urban Wastewater Directive and is compatible with methodologies used in several of the other Member States participating in STAR It is compatible with the draft CEN Comite Europ en de Normalisation standard for the surveying of aquatic macrophytes in running waters prEN 14184 Macro invertebrates A variety of internal and national sampling methods were used in order to address issues of inter calibration of methodologies These were AQEM This sampling method was devised for use in the EC AQEM project www agem de It was used by all partners and is the common standard that will facilitate inter calibration of other protocols RIVPACS This sampling method River InVertebrate Prediction and Classification System is used in the UK in association with an eponymous software system that uses predicted reference and observed metric values to calculate EQR s for bio assessment purposes In STAR the method was used by partners from UK Germany Austria and Greece IBE The Indice Bi tico Esteso IBE is widely used in Italy and involves bankside sorting of samples It has also been applied successfully in Nicaraguan streams In STAR this method was formally used in Italy but extra informal IBE samples were also collected in Greece IBGN The Indi
73. dded This refers to typology and we do not know at present what the data input is supposed to be We will have to come back to you about this Hopefully the typology can be concluded from the other data that you provide and this variable will not be needed However to be sure it is included in this version of FIDES 4 Other zonation is the river zonation scheme used nationally if you have one This is optional but please provide it if available Table FISHING OCCASION pages 27 42 refers to changeable environmental characteristics the sampling procedure and assessment of the anthropogenic impact It is understood that each site is sampled only once each day Should you have several subsamples from a specific site at the same day you will have to pool the data before adding them to the database Notice that five new variables have been added all these new variables are optional They are Day night time of sampling during the 24 hours of a day Conductivity absolute value Wattage used effect in watt used when fishing Flora impact site unnatural increase in water vegetation Weed cutting site if cutting of weeds occur To assess anthropogenic impact 23 variables have been included in the FISHING OCCASION table The six last variables describing anthropogenic impact are optional as well as Natural flow pattern site and Natural flow quantity site The others are obligatory One variable was omitted Water level and Maximum depth c
74. dentification Department of Environmental Assessment SLU Richard K Johnson Field work Department of Environmental Assessment SLU Jakob Nisell Field work Department of Environmental Assessment SLU Daniel Larsson Field work Department of Environmental Assessment SLU Putte Olsson Laboratory processing Department of Environmental Assessment SLU Leonard Sandin Field work data input Ir Ir A T Department of Environmental Assessment SLU Sonja Stendera Field work Department of Environmental Assessment SLU Anneli Widenfalk Field work Department of Environmental Assessment SLU Bj rn Wiklund Field work laboratory processing Department of Environmental Assessment SLU Mikael Ostlund Field work Department of Environmental Assessment SLU Erik Eriksson Laboratory processing Masaryk University Karel Brabec Field sampling identification Masaryk University Libuse Opatrilova Field sampling laboratory processing data input Masaryk University Petr Paril Field sampling identification Masaryk University Marcela Ruzickova Field sampling Masaryk University Vit Syrovatka Field sampling laboratory processing Masaryk University Katerina Sumberova Macrophyte identification Masaryk University Svatava Kubesova Macrophyte identification Hellenic Centre for Marine Research HCMR IIW K C Gritzalis RHS sampling sorting identification
75. dium sized streams on calcareous soils medium sized streams on calcareous soils medium sized streams on calcareous soils medium sized streams on calcareous soils medium sized streams on calcareous soils medium sized streams on calcareous soils medium sized streams on calcareous soils medium sized streams on calcareous soils medium sized streams on calcareous soils Core or additional core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 additional additional additional additional additional additional additional additional additional additional additional additional 7002 AINE TE e qe1oAmoQq 9 680007 100C LO DMAH EE Site number 639 640 641 642 643 644 645 646 647 648 889 890 891 674 675 676 677 678 679 680 681 682 683 892 893 Country United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom United Kingdom Stream type U15 U15 U15 U15 U15 U15 U15 U15 U15 U15 U15 U15 U15 U23 U23 U23 U23 U23 U23 U23 U23 U23 U23 U23 U23 Type description small sized small sized small sized small sized small
76. e seen in column 3 and 4 white the taxon was not identified by the AQEMdip taxa database e g because of a spelling mistake and could not be read in if another taxon should be entered instead click into the field in column 3 and choose a taxon form the selection list If all changes and specifications are done click on the Import button and the file will be read in into your sample unit form Note The numbers on the left side of the import window correspond to the row numbers of your original Excel file If you press the button Taxalist export a documentation of the import is exported to Excel It is only possible to import an Excel file into an empty sample unit form 68 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 L Data input biological data diatoms Click the appropriate sampling unit with the right mouse button in the left window select Edit with the left mouse button a data input window opens to enter a taxon click on the button New the window Species selection New opens select a Genus and a Species from the respective selection lists Note Once the genus is selected only the possible species names according to the selected genus and taxalist appear in the species list By typing the first characters of the genus or species name the process can be accelerated the tabulator allows you to switch between the fields using Alt and the cursor buttons you can scroll up and down in the selection lis
77. e2 Poland 002 medium sized lowland streams Eco region 14 core2 am Poland 002 medium sized lowland streams Eco region 14 core2 Poland 002 medium sized lowland streams Eco region 14 core2 Poland 002 medium sized lowland streams Eco region 14 core2 gt Poland 002 medium sized lowland streams Eco region 14 core2 Poland 002 medium sized lowland streams Eco region 14 core2 Poland 003 medium sized lowland streams Eco region 16 core2 Poland 003 medium sized lowland streams Eco region 16 core2 Poland 003 medium sized lowland streams Eco region 16 core2 Poland 003 medium sized lowland streams Eco region 16 core2 Poland 003 medium sized lowland streams Eco region 16 core2 Poland 003 medium sized lowland streams Eco region 16 core2 Poland 003 medium sized lowland streams Eco region 16 core2 Poland 003 medium sized lowland streams Eco region 16 core2 Poland 003 medium sized lowland streams Eco region 16 core2 Poland 003 medium sized lowland streams Eco region 16 core2 Poland 003 medium sized lowland streams Eco region 16 core2 Poland 003 medium sized lowland streams Eco region 16 core2 Poland 003 medium sized lowland streams Eco region 16 core2 68000 1002 12 Site number 859 860 861 862 863 864 865 866 867 868 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 Country Portugal Portugal Portugal Portugal
78. ed calcareous mountain stream in the East Carpathians small sized calcareous mountain stream in the East Carpathians small sized calcareous mountain stream in the East Carpathians small sized calcareous mountain stream in the East Carpathians small sized calcareous mountain stream in the East Carpathians small sized calcareous mountain stream in the East Carpathians small sized calcareous mountain stream in the East Carpathians small sized calcareous mountain stream in the East Carpathians small sized siliceous mountains streams in the West Carpathians small sized siliceous mountains streams in the West Carpathians small sized siliceous mountains streams in the West Carpathians small sized siliceous mountains streams in the West Carpathians small sized siliceous mountains streams in the West Carpathians small sized siliceous mountains streams in the West Carpathians small sized siliceous mountains streams in the West Carpathians small sized siliceous mountains streams in the West Carpathians small sized siliceous mountains streams in the West Carpathians small sized siliceous mountains streams in the West Carpathians small sized siliceous mountains streams in the West Carpathians small sized siliceous mountains streams in the West Carpathians small sized siliceous mountains streams in the West Carpathians Core or additional additional additional additional additional additional additional additional additional additional additional addit
79. el As a suggestion if more than 30 of the available forested area is used for commercial forestry the impact class should be 4 or 5 Extent of clear cutting and whether natural tree species composition is altered should also be taken into consideration Impact should increase with proximity of forestry activities to the river segment Combined impact of agriculture and silviculture should be assessed with expert judgement OTT Table FISHING OCCASION 5 Urbanisation_segment impact of urbanisation on the river segment level in this case referring to catchment upstream gt 15 urban land severe impact impact class 5 gt 15 urban land strong impact impact class 4 lt 15 moderate impact impact class 3 lt 15 low impact impact class 2 lt 1 impact class 1 6 Riparian zone segment deviation from natural state adjacent vegetation zone normally 30 50 m on each shore of the segment lt 25 of shore length both sides in natural state impact class 5 lt 50 of shore length both sides in natural state impact class 4 lt 75 of shore length both sides in natural state impact class 3 lt 90 of shore length both sides in natural state impact class 2 gt 90 of shore length both sides in natural state impact class 1 7 Connectivity segment migration barriers preventing free migration of potadromous species to segment Definite artificial barrier impact class 5 Passage for
80. ema glaucescens LOEW 1864 13967 acanglau 50840121 32510200010 SCATOPHAGIDAE HYDROMYZINAE canthocnema sp 14481 acatsp 50840100 52510200000 BAETIDAE BAETINAE Acentrella almohades ALBA TERCEDOR amp 16578 acenalmo BAETIDAE BAETINAE Acentrella inexpectata 5 1928 10670 baetinex 0300300070 Note If taxa are missing or if you note spelling taxonomic mistakes please contact Armin Lorenz armin lorenz uni essen de or Astrid Schmidt Kloiber astrid schmiat kloiber boku ac at regarding benthic invertebrates and Piet Verdonschot Piet Verdonschot 9 wur nl regarding diatoms Lists menu The menu for changing the sampling area is opened by choosing Lists in the menu and subsequently opening Sampling instruments amp area in the submenu Entering a new sampling area e press Add new e enter a new area in m in the field Area e enter a sampling instrument in the field Sampling instrument e chose a value from the selection list if you want to define the sampling instrument amp area as default for a certain method optional e enter a description in the field Description optional e press Close 71 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 g Data input stream characteristics At the lower end of the Data input window two buttons are available AQEMEN Site protocol Site protocol AQEM Site Protocol opens the window for entering stream characteristics data site prot
81. ent the sample unit depending on the method chosen 0C combined sample LO lotic LE lentic 01 to 20 separate sample units Character 15 indicates main or replicate sub sampling Character 16 indicates whether the sample has been subject to internal or external audit or both 15 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 g 2 8 Taxon codes Macro invertebrates The taxa in the macro invertebrate taxalist is based upon two principal types of taxon codes ID ART ID AQEM Unique 4 to 5 character number codes sequential numbers Shortcode Unique 8 letter codes derived from characters within the taxon name Both codes originate form the Austrian ECOPROF database that was extended within the AQEM project and then further enlarged within the STAR project These codes are intended to be available for all European freshwater macro invertebrate taxa There are several national taxon codes that are also included into the database but only exist for selected taxa the German DV number 1 to 5 character sequential number code the Dutch TCM code 1 to 4 character sequential number code the British Furse code 8 character number letter code and the Czech PERLA code 17 character number code Phytobenthos The phytobenthos taxa are coded with a unique 4 letter code based on the diatom list originating from OMIDIA Lecointe C M Coste amp J Prygiel 2003 This taxon code is available for all existing taxa and was amended during t
82. er members of the FAME consortium 17 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 L 3 RESULTS 3 1 Databases 3 1 1 Phytobenthos macro invertebrates and site protocol AQEMDIP 2 6 Source Based on Austrian Software ECOPROF BOKU University of Natural Resources amp Applied Life Sciences Vienna www ecoprof at and on AQEM DIP 1 3 AQEM Project www agem de Programmers Main program and structure database structure biological data input DLL programming technical support Robert Vogl Softwarehaus Graf amp Partner www grafsoft co at in co operation with IRV Software http www irv software at Austria Site protocol parts of export function setup and installation technical support coordinator J rg Strackbein UDE Germany http www uni duisburg essen de fb10 forschen index shtml Taxadatabase scientific consulting technical and scientific support Astrid Schmidt Kloiber BOKU Austria http www boku ac at hfa Supporting taxalists Responsible for content of the taxalist Astrid Schmidt Kloiber BOKU Austria Armin Lorenz UDE Germany Johan van der Molen Alterra The Netherlands Contents of taxalists 11434 macro invertebrate taxa July 2004 9105 diatoms July 2004 Technical information AQEMDIP 2 6 Programmed in MS Visual Basic 6 Database MS Jet Engine Setup by InstallShieldExpress 3 Developed on MS Win NT4 WIN2000 prof systems 18 t 6 Deliverable 31 July 2004
83. gadenPl 3j bei Kleingraden Site name bei Kleingraden AP1 o 01 08 2002 Site number n 2 A0101011 DCD _ _ _ _ _ _ 0 00252 15 0 Date 01 08 2002 Time 0600262 5 0 02 0 WE 40600462 IRMO 0 00 Sample number 40500252 o Stainzbach Stullnegabach BUE Invertebrates 2 H Weibe Sulm Method STARAQEM H Wildbach Main or replicate small sized shallow mountain streams P mid sized streams Hungerian Plains Ecoregior Phytobenthos Substratum mid sized calcareous alpine streams Ecoregio small cristalline alpine streams Ecoregion 4 mid sized streams Bohemian Massif Ecoregior Fe Sample unit name Sampling instrument Area n Sample unit No Cells STAR AGEM Subsample JT 4d Aud y AQEME Export Close 21 D Site protocol Site protocol General note Data input edit is managed by the use of the right mouse button and is to be done level by level Select the favoured level in the left window then press the right mouse button and make your choice To finish input edit of the selected level please press accept to save the data or cancel to quit without saving 58 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 d Entering new STAR sites go to AQEM country in the left window and click the right mouse button select New STAR site with the
84. ganic Organic Organic Organic Organic Organic None None None None Organic None None None None 7002 INE TE e qe1oA oQ 9 680007 100C LO DMAH 07 Site number 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 968 916 917 918 Country Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Poland Stream type River name 002 002 002 002 002 002 002 002 002 002 002 002 002 003 003 003 003 003 003 003 003 003 003 003 003 003 Pilawa profile Szwecja Dobrzyca profile Czapla Plytnica profile above Plytnica Pliszka profile Konotop Korytnica profile Jazwiny Ilanka profile Maczkow Samica profile Kraplewo Struga profile Katy Meszna profile Katy Ner profile Lutomiersk Grabia profile Rokitnica Mrerzaczka Mala Welna profile Kiszkowo Wieprza profile Gradki Dolne Slina profile Zawady Mlawka profile Szrensk Sokolda profile Nowa Rozedranka Ploska profile Przechody Suprasl profile Zarzeczany Narew profile border on the country lutownia profile Pogorzelce Narewka profile Bialowieza Lesna Prawa profile Stopily Lesna Prawa Hajnowka Rospuda profile Jozefowo Blizna profile Szczerba Wolkuszanka Wolkusz Site name Szwecja Czapla
85. he STAR project for new taxa There are several national taxon codes that are also included into the database but only exist for selected taxa the Austrian ID Art 3 to 4 character sequential number code and the British NEWCODE 8 character number code 2 9 Databases Three databases were designed modified for the STAR project AQEMDip Version 2 6 holds both phytobenthos and macro invertebrate data and is an extension to the earlier version created within the AQEM project The principal modification is the new inclusion of phytobenthos but there are many other extensions to and improvements in the functionality and performance characteristics of the latest version The macrophyte database is an extensively modified version of an earlier database designed by the Institute of Freshwater Ecology now part of CEH 16 t 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 L The un named hydro morphological database STARRHSI is an extensively modified version of an earlier database designed by the Institute of Freshwater Ecology now part of CEH It is specifically designed to hold RHS data and is capable of storing data collected by four different versions of the RHS protocol including the southern European version The STAR fish data are stored in FIDES the fish database designed by the FAME project CT 2001 00094 and kindly made available by that project s co ordinator BOKU and the oth
86. he cursor on any field on the form Edit Delete record Note 1 To repeat the data from a previous field go to the empty field below and type Ctrl or Ctrl 2 You can copy and paste a whole row 3 Be sure to save a back up copy of the database after each session Save the database under a different name Normally you should have several back up copies saved Keep track of what date you saved the copy and how far the data input had advanced 4 If a problem occurs when recording data using the form Fishing occasion close the form and then open it again Before you start over check that no erroneous data were stored 90 2 Input from keyboard datasheet views More advanced users You will view and edit related records in subdatasheets When you open a table in datasheet view you will find a sign at the beginning of the record If you click on the sign you will see the records in the subsheet To close the table click on the sign Definitions The Site table is a sheet Subsheet to the Site table is the sheetview for the table Fishing Occasion Subsheet to Fishing occasion table is the sheetview for the table Catch Subsheets to Catch are the sheetviews for the tables Length and Length class 9 3 Importing from Excel Advanced users We assume you have entered your data in the enclosed empty Excel files You must then import to FIDES in the following order 1 Site xls 2 Reporter xls 3 Histor
87. hectare 710 000 m positions Model Abundance estimate Method used for the abundance estimation String 50 Sampling Zippin 1958 When successive removal multiple runs has positions been carried out you should preferably give a short reference e g Zippin 1958 Carle amp Strub 1978 Bohlin et al 1979 Junge amp Liboswarsky 1965 Higgins 1985 Gerdeaux 1987 de Lury 1958 When only one passage one run was carried out state if just an average p value catch efficiency was used Average p references used should be given in full to the Swedish partner to allow for a help table with this information to be produced Optional State the catch efficiency p value calculated Numeric decimal Sampling 0 51 Estimated efficienc Y successive removal or used one run Should refer to the proportion of estimated abundance caught at the first passage p1 Optional point 4 positions Table LENGTH TABLE is OPTIONAL to be used if individual lengths are available VARIABLE EXPLANATION TYPE USED FOR EXAMPLE PRECISION Site code See Table SITE String 8 Database LT001 positions first two letters always capital Latitude See Table SITE String 8 Database 55 3501N positions Longitude See Table SITE String 8 Database 24 0445E positions Date Date of sampling given as Microsoft date Date format 10 Database 2002 05 14 format Format
88. ic organic none organic none none organic none organic organic organic organic none organic organic none none organic organic none organic organic none organic organic v00C INE 9 68000 1002 12 cv Site number 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 874 875 876 877 878 879 880 881 882 883 887 888 Country Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Stream type River name S05 Nittalven 05 Silveran S05 Jonsbergs n S05 Pajsoan S05 Savalven 05 Sverkestaan 05 H rks lven S05 Kisa n S05 Gusum n S05 Sandan S05 Saxhyttan 05 Storan 05 Rast lven S05 Borkhultsan S05 Sagan S06 Algangsan S06 Forsmarksan S06 Hagaan S06 Tamnaran S06 Str maran S06 Penningbyan S06 J rs str mmen S06 Muskan S06 Kagghamraan S06 Husbyan S06 Skeboan S06 Brostr mmen Site name Downstream Nordtj rns lven Upstream Jonsberg Upstreams the bridge Upstream S vefors Halldammsforsen Brattforsen Downstream Nedre F lingen Gusum Rif Kojan Saxhyttan Downstream Storakvarn Grangeshyttan Downstream nya dammen Sala Furuvik Johannisfors Lurbo Kvarnberget S J rs Finsta Status NNOO A P P CQ i00 bb P
89. ical data xls 4 Fishing occasion xls 5 Catch xls 6 Length xls 7 Length classes xls Steps to take From the main menu choose 1 File 2 Get external data 3 Import 4 Look in the folder where the file is that you will import 5 Choose file of type Microsoft Excel xls 6 Mark the file to import 7 Import 8 Mark First Row Contains Column Headings 9 Next 10 In an existing file 11 Choose the file 12 Next 13 Finish 14 You will get the note Finished importing file 15 If anything goes wrong you will have a note and sometimes you will have an error table in the receiving folder 92 6 Table REPORTER VARIABLE EXPLANATION TYPE USED FOR EXAMPLE PRECISION T Reporter_code Your own code always started with the two letters String 10 positions Database SEerik indicating country E g FR001 or FRUdL could both always the first two QA be Universit de Lyon in France letters capital the rest as You prefer Responsible person Name of person responsible for data supply and also String 50 positions Database Erik Degerman responsible for QC amp QA First name followed by last name QA Company University If applicable String 50 QA National Board of positions Fisheries Institute Agency Name of Your institute or governmental agency String 50 QA Institute of positions Freshwater Research
90. idth of site was sampled Maximum depth class The maximum depth in metres is given for the String 3 Sampling lt 1 surveyed river section i e the deepest spot positions Model even if this was not sampled Note not the segment Classes lt 1 lt 2 lt 5 gt 5 m Optional The dominating substrate type at the sampled String 20 Model Sand Dominating substrat area of the stream Classes Silt Sand Gravel positions Initial Typology 8 Pebble Cobble Boulder Rock and FineSand capital letter and Sampling GravelPebble PebbleCobbble CobbleRock and BoulderRock See definitions in Appendix 1 Optional then lower case letters 601 Table FISHING OCCASION Stop nets used State if stop nets block nets were used to String 4 Sampling No delimit the sampling site Codes positions Initial Yes Both up and downstream capital letter and Up Only upstream then lower case Down Only downstream letters No No nets used No of anodes Number of anodes used One Two Three String 10 Sampling One Four Multiple positions Initial capital letter and then lower case letters Type of anode Ring Rectangular Boom Other String 6 Sampling Ring positions Initial capital letter and then lower case letters Size of anode Obligatory if applicable For ring circular anodes Numeric decimal Sampling 0 25 ring diametre is given in metres For boom anodes p
91. ification inverts CEH visiting scientist UDE see below Marta Wenikajtys Sorting data input Centre for Ecology and Hydrology CEH Paul Henville Surveying Centre for Ecology and Hydrology CEH Pete Scarlett Surveying data management Centre for Ecology and Hydrology CEH John Davy Bowker Database construction data management Centre for Ecology and Hydrology CEH Cynthia Davies Data management Centre for Ecology and Hydrology CEH Stewart Welton Fishing Centre for Ecology and Hydrology CEH Bill Beaumont Fishing Centre for Ecology and Hydrology CEH Adrian Pinder Fishing data management Centre for Ecology and Hydrology CEH Rudi Gozlan Fishing Centre for Ecology and Hydrology CEH Will Beaumont Fishing University of Duisburg Essen UDE Not yet supplied BOKU M Car Identification BOKU C Frangez Field sampling BOKU W Graf Field sampling identification BOKU U Grasser Identification 7002 AINE TE e qe1oAmoQq 9 680007 L00C LO DMAH BOKU M Hinterhofer Field sampling BOKU M Horzak Identification BOKU Hor Laboratory processing BOKU T Huber Field sampling laboratory processing BOKU B Janecek Identification BOKU J Kodada Identification BOKU H Kummer Field sampling BOKU P Leitner Field sampling laboratory processing BOKU A Melcher Data input BOK
92. included detailed collection of hydromorphological data together with limited collection of supporting chemical physical and geographical information Chemical physical and geographical information were collected for each STAR site The sampling of biological and hydromorphological elements for each of the 22 STAR stream types is given in Table 3 with individual site information provided in Appendix III 6 Deliverable 31 July 2004 2001 00089 Table 3 The biological and hydro morphological quality elements sampled for each STAR site type gt o0 an 2 8 5 8 E o amp e 9 o ae c gt 42 gt COUNTRY Site type definition E 15 185 m Austria Small sized shallow mountain streams ea Austria Small sized crystalline streams of ridges of the Central Alps Czech Repub Small sized shallow mountain streams nile Czech Repub Small sized streams in Central sub alpine mountains Denmark Medium sized lowland streams France Small sized shallow headwater streams in Eastern France Germany Medium sized lowland streams Germany Small sized shallow mountain streams Germany Small sized Buntsandstein streams Greece Small calcareous mountain streams W Central amp S Greece Italy Small sized streams in the southern calcareous Alps Ital
93. ional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional additional 7002 AINE TE e qe1oAmoQ 9 68000 100C LO DMAH TE Site number 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 874 875 876 877 878 879 880 881 882 883 887 888 Country Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Stream type 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 506 506 506 506 506 506 506 506 506 506 506 506 Type description medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized streams on calcareous soils medium sized streams on calcareous soils medium sized streams on calcareous soils me
94. ional information on the geology of the String 20 Typology Metamorphic catchment upstream of the sampling site positions Initial Model Classes Igneous Sedimentary Metamorphic See Appendix 3 Optional capital letter and then lower case letters 86 Table SITE Mean air temperature Yearly average air temperature measured for at least Numeric Model 12 3 10 years during the period 1960 2002 Given in decimal point Typology degrees Celcius C If the temperature is only five positions available in classes use class midpoint value HHHH Mean Jan temperature Average air temperature in January measured for Numeric Model 0 1 over 10 years during the period 1960 2002 Given in decimal point Typology degrees Celcius C If the temperature is only five positions available in classes use class midpoint value HHHH Optional Mean Jul temperature Average air temperature in July measured for over 10 Numeric Model 18 4 years during the period 1960 2002 Given in degrees decimal point Typology Celcius C If the temperature is only available in five positions classes use class midpoint value Optional Hitt A Gradient slope Slope of stream bed along stream expressed as Numeric Model 6 780 per mil Slope is drop of altitude divided decimal point 7 Typology by stream segment length If possible the positions stream segment should be as close as possible HHH HHH
95. ional standard permits rock vil Table FISHING OCCASION Appendix 2 Suggestion for classification of impact variables Impact classes 5 bad status severe impact on fish fauna 4 poor status strong impact on fish fauna 3 moderate status moderate impact on fish fauna 2 good status slight impact on the fish fauna 1 high status reference conditions only minor negligible alterations Guidance for classification of impact follows each variable River basin The whole river basin also downstream of the site All the way down to the confluence in another river or the sea 1 Land_use_river impact of agriculture silviculture on the river basin level Agriculture gt 40 cultivated land intensive crops severe impact impact class 5 gt 40 cultivated land strong impact impact class 4 lt 40 moderate impact impact class 3 lt 40 low impact impact class 2 lt 10 impact class 1 Silviculture must be assessed on a national level As a suggestion if more than 30 of the available forested area is used for commercial forestry the impact class should be 4 or 5 Extent of clear cutting and whether natural tree species composition is altered should also be taken into consideration Combined impact of agriculture and silviculture should be assessed with expert judgement 2 Urbanisation river impact of urbanisation on the river basin level down to confluence
96. irst site or stream name with the right mouse button e select New site name e enter the second site name on the right side of the window e press the Accept button e all further site names should be entered in the same manner Note The field Site number will stay empty because your site is not a STAR site Entering the sampling date e click the appropriate site name with the right mouse button in the left window e select New date e a blinking cursor will now appear in the field date in the right data input window enter the appropriate sampling date and time optional here e press the Accept button e to enter a second sampling date select first date or the site name with the right mouse button e select New date e enter the second sampling date on the right side of the window e press the Accept button e all further sampling dates should be entered in the same manner Note The input of date and time format should correspond to your regional setting properties Entering the sample number e click the appropriate sampling date with the right mouse button in the left window e select New sample number e a blinking cursor will now appear in the field sample number in the right data input window enter the appropriate sample number here e choose a Biological Quality Element BQE from the selection list e choose a Method from the selection list e choose an option for Mam or Replicate from the selection list e choose a
97. is important that you leave the input forms and look at the data in the tables View data reports This way you can see if things worked out the way they were meant to If everything in the tables looks fine you might even try to perform a validity test Please observe that the validity check just verifies that data has been put in where necessary that values are reasonable some fields and that classes presented are allowed There are still many possible error possibilities left Deleting a Fishing Occasion It is not always that data stored are correct Perhaps you will make some initial mistakes using this programme That is why there is a way to erase such bad records If you want to delete a whole fishing occasion You will have to delete records in following order 1 Length and Length class mark the record s and Delete 2 Catches put the cursor on the field Species and Delete 3 Finally the Fishing occasion Edit Delete record You ll have to close and open the form after a deletion or move to another record and then come back or Refresh the form 89 Deleting a Site You will have to delete records in the following order 1 Length and Length class mark the records for the length or and the Length classes and Delete 2 Catches put the cursor on the Species field Edit Topline and Delete the record 3 Fishing occasion put the cursor on any field on the form Edit Delete record 4 Finally the Site put t
98. l sampling programme Partners were instructed to collect their pairs of replicate samples from the same 100m sampling area see Figure 1 but the second sample of each pair could be taken by the same sampler as the first sample or by a second different person Partners were expected to apply a consistent same sampler or different sampler policy for each of their sites Where a different sampler policy operated each sampler should undertake and record their own STAR AQEM habitat cover estimates before deciding how many sample units to be collected from each habitat type Where partners were sampling more than one stream type the replicate samples were normally distributed evenly amongst those stream types In general partners were requested to spread their replicate sites across a range of ecological statuses but with tendency to favour the higher quality sites with greater species richness 14 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 g 2 6 Site numbering A simple site numbering system overarches and is compatible with all three STAR databases AQEMDIP 2 6 macrophyte database and hydromorphology database and with FIDES the fish database developed by the FAME project Sites are numbered sequentially from 600 to 1035 with some omissions Site numbers have no functionality but are a linking field to country river name and site name and hence to all fields in the project databases 27 Sample survey numbering
99. l the formation processes Hence it is necessary to also define the acid base status or the proportion of SiO in the mineral to decide the classification according to WFD typology Igneous siliceous A percentage in weight of SiO above or equal to 63 would refer to a siliceous acid rock This would include for instance granite granodiorite rhyolite and dacite Igneous basic A percentage in weight of SiO less than 63 would refer to a basic rock This would include for instance gabbro basalt komatiite peridotite andesite diorite Sedimentary acid Siliciclastics silicicate rich breccias sandstones mudrocks Sedimentary basic Precipitates and allochems limestone Calcareous dolostones cherts Metamorphic acid E g gneisses Metamorphic basic E g several slates But When the WFD typology is used obligatory it is sufficient to just state the formation process of the bedrock By combining the variables geological_typology and geological_formation a more precise definition of the bedrock is achieved Hence three classes are suggested Igneous Sedimentary Metamorphic Table SITE Appendix 4 Criteria to define the river zonation according to Huet 1949 Stream 81 zone Slope o zone Slope 6o zone Slope o zone width m gt 100 lt 0 25 bream 20 25 barbel lt 4 5 grayling gt 4 5 trout gt 60 lt 0 33 bream lt 1 25 barbel
100. lass has been turned into optional due to lack of data in several countries Please observe that conductivity is measured in mS m This corresponds to uS cm divided by 10 The table HISTORICAL page 43 is unaltered from the draft version In this table all occurrence of species in the past can be recorded Notice that occurrence of a species can be stated as certain or probable and on different spatial levels river basin segment site in accordance with the description of reference conditions and impact The table CATCH pages 44 46 is used to report the catch in each run the estimated abundance and the estimated biomass of each species Note that these data refers to 79 abundance and biomass per hectares For species of special interest indicator species also the catch of 0 in each run should be given if possible Two tables are included for the optional reporting of lengths LENGTH individual lengths of different species and LENGTH CLASS number of individuals of each species in each length class Be sure to clearly state what kind of length data that is provided 1 total length or fork length and if the whole catch or a subsample was measured If length frequencies are reported the length classes upper and lower limit in mm must be defined This will be a laborious work but we suspect that pre defined length classes will not be possible to use due to the variation in data between countries Finally there are some he
101. logy _ H Eco region no Geological formation Subecoregon 4 Mean a temperatwe 7 River type oW MeantempJan Main tives region Mean temp Jul River name P Graden shope Rm Locality name Huet zonation Nationa ee Other zonation E Nakedmepcode2 Stream order Size ot catchment class x Lakes upstream E Size of catchment Distance to lake Width flooded area KH Distance source Mean 4 class E Distance to mouth class Flow regme y Distance to mouth Akude Water type zj The latter two fields are preformatted Be sure to be in the very left position before you start to type in data D Continue to add data in all the fields displayed in the site section upper purple part of the window See above from Country abbreviation to Water source type E You are now ready to add data of the Fishing occasion in the mid section of the window light blue If the site has been visited on several occasion it is most convenient to add them all one after another If the table is empty is just to add the data If you have previous data start by clicking on the asterisk button indicating New record This will also empty subforms 1 preparing them for New records aee i yes H W Porat e vote Finde mp ult Se SHTA 0 mieu input from keyboard Form view FIDES Fish database of European Streams Site Saecode 54612386 L
102. lp tables included most important is TAXA and GUILDS You are not supposed to alter or input data in these help tables They are there to facilitate data input almost like a dictionary The help table TAXA and GUILDS at present just consists of fish species names pending the finalisation of WP1b 80 Scale of variables included in FIDES There are five levels of scale in FIDES Site The sampled site in the stream Segment A river segment is defined as 1 km for small rivers catchment 100 km 5 km for medium sized rivers 100 1000 km 10 km for large rivers 71000 km A segment for a small river will thus be 500 m up and 500 m downstream of the sampling site Catchment The whole catchment watershed upstream of the site River basin The river basin up and downstream of the site The river basin stretches down to the sea or a confluence in an equally sized or larger river This scale is only used for the variables Land use river and Urbanisation river in table Fishing occasion Whole river basin The river basin up and downstream of the site The whole river basin stretches down to the sea This scale is only used for the variable Connectivity river in table Fishing occasion Varible Table Refers to SCALE Size of catchment Site Catchment Size of catchment class Site a Geological_typology Site Ee Geological formation Site a Width_flooded_area Site Segment Gradient_slope Site Segment Huet_zonation Site
103. lumn for the 1 8 vial e 1 16 input column for the 1 16 vial Sample unit name 40600341 IRMO D Time relation min 300 0200 Genus Crenobia 4 0 0 1 0 0 Polycelis felina 0 0 3 0 0 Gen sp 2 2 0 0 0 0 Fridericia sp 4 0 0 1 0 0 Lumbricidae sp Bl 1 1 0 0 0 0 Nais alpina 4 0 1 0 0 Nais elinguis 8 0 0 2 0 0 Hydrachnidia Gen sp L 4 0 0 1 0 0 Gammarus fossarum 464 0 0 0 58 0 Alainites muticus 13 1 0 3 0 0 Baetis alpinus 4 15 0 8 0 0 Baetis alpinus Gr 15 3 0 3 0 0 Baetis melanonyx 13 0 2 0 0 Baetis rhodani 3 3 0 0 0 0 Serratella ignita 4 0 0 1 0 0 Ecdyonurus sp 1 1 0 0 0 0 Ecdyonurus venosus L E 1 1 0 0 0 0 Epeorus assimilis 25 25 0 0 0 0 Rhithrogena carpatoalpina iridina pic C d 17 17 0 0 0 0 Taxon New Edit Delete Close paste Excel import Original AQEM data input First of all the fractions have to be specified e Sampling fractions enter the percentage of the aliquot used for determination of the coarse fraction in the field CF if subsampling was performed default is 100 96 e enter the percentage of the aliquot used for determination of the fine fraction in the fields FF1 to FF4 if subsampling was performed The following columns are available
104. m 1 amp m ph data input Hellenic Centre for Marine Research HCMR IIW N T Skoulikidis Hydrochemistry geology typology field work Hellenic Centre for Marine Research HCMR IIW 1 Karaouzas Sampling sorting identification m 1 data input Hellenic Centre for Marine Research HCMR IIW T S Koussouris Land uses pressures data acquisition field work Hellenic Centre for Marine Research HCMR IIW T Kouvarda Sampling sorting Hellenic Centre for Marine Research HCMR IIW Economou Electrofishing sampling fish fauna data process amp acquisition 8cI Hellenic Centre for Marine Research HCMR IIW M Stoumpoudi Electrofishing sampling fish fauna data process amp acquisition Hellenic Centre for Marine Research HCMR IIW R Barbieri Electrofishing sampling fish fauna data process amp acquisition Hellenic Centre for Marine Research HCMR IIW S Laschou Chemical analysis amp hydrochemistry field work Hellenic Centre for Marine Research HCMR IIW E Kaloghianni Electrofishing sampling fish fauna data process Hellenic Centre for Marine Research HCMR IIW N Mpellou Sampling sorting identification EPT taxa Hellenic Centre for Marine Research HCMR IIW A Papadaki Sampling sorting Hellenic Centre for Marine Research HCMR IIW K G Piniotis Sampling sorting hydrochemistry Hellenic Centre for Marine Research HCMR
105. many Germany Germany Germany Germany Germany Germany Germany Germany Stream type River name D03 D03 D03 D03 D03 D03 D03 D03 D03 D03 D03 D03 D03 D04 D04 D04 D04 D04 D04 D04 D04 D04 D04 D04 D04 D06 D06 D06 D06 D06 D06 D06 D06 D06 D06 Stepenitz Eltingm hlenbach Rhin rtze Aue Lachte Berkel B hme Karthane Dinkel Issel Stever Dinkel Wei er Wehebach Elbrigh user Bach Kall Platifibach Prether Bach Linnepe Wolfferter Bach Salwey Marienwasser Lahn Dreisbach Rahmede Aubach Ilme Orb Itterbach Hafenlohr Bieber Klingbach Jossa Orb Aura Site name Stepenitz near Putlitz BB Eltingmuehlenbach near Greven NRW Rhin near Raegelsdorf BB Oertze N of Poitzen NS Aue E of Wildeshausen NS Lachte W of Lachendorf NS Berkel SE of Vreden NRW Boehme S of Vierde NS Karthane near Muehlenholz Karthan BB Dinkel near Heek NRW Issel N of Loikum NRW Stever near Hullern NRW Dinkel at Gronau NRW Wehebachtalsperre Neuludwigsdorf Kalltalsperre Eicherscheider Berg Oberprether M hle Linneperh tte Wiesen Niedersalwey Wemlighausen Feudingen Dreis Tiefenbach Breitenhagen Aubach above Wiesthal above Relliehausen Orb below Bad Orb Itterbach above Kailbach Hafenlohr above Lichtenau Bieber above Rossbach Klingbach below Hausen Jossa below Sahlensee Orb in Bad Orb Aura in Burgsinn Status gt P P P P Oo Oo g
106. ments from normal salinity range impact class 3 impact class 2 Salinity range within normal variation impact class 1 16 Toxic_acidification_site deviations from natural state of toxic conditions including acidification and oxygen levels at the site Constant long periods months or frequent reoccurrence of strong deviations from normal undisturbed conditions e g pH lt 5 0 impact class 5 e g pH lt 5 5 impact class 4 Occasional deviations single measurements episodes from normal undisturbed conditions e g single pH lt 5 5 impact class 3 e g single pH lt 6 0 impact class 2 Conditions within normal variation impact class 1 Suggestions regarding oxygen levels applicable for at least grayling and trout zones lt 2 mg l or lowest measured oxygen saturation lt 70 impact class 5 2 5 mg l or lowest measured oxygen saturation 70 80 impact class 4 5 mg l or lowest measured oxygen saturation 78094 impact class 3 7 mg l or lowest measured oxygen saturation 80 90 impact class 2 77 mg l or lowest measured oxygen saturation gt 90 impact class 1 611 Table FISHING OCCASION 17 Nutrients organic input site deviations from natural state including humic substances fish farming etc at the site Conditions deviate more than 300 of established national background levels of P N and TOC concentrations impact class 5 Occasional devia
107. ments on some individual parameters No 9 10 Longitude and latitude are now entered in decimal values the old data are shown in the fields above but cannot be changed Enter the coordinates as simple decimal coordinates 2 digits before and 7 digits after decimal e g longitude 13 2064925 latitude 52 2152457 Date WGS 84 Use negative values for coordinates west of Greenwich This makes data entry as simple as possible and enables to export coordinates as decimal numbers to GIS Other systems such as UTM may need to re format the data for analysis 73 6 Deliverable 31 July 2004 Table 18 No 18 Table 19 No 25 No 26b Table 30 No 74 75 No 78 Table 79 80 No 91 Table 103 104 No 105a No 106 No 119 120 EVK1 CT 2001 00089 e Data coming from STAR are marked with a yellow x in AQEM In the STAR protocol a field for others was added If the sum of 100 is reached with filling in this others field you will get less than 100 in the AQEM protocol Artificial and reservoir were added in the STAR protocol AQEM you will get a yellow label if these points were filled in STAR New in STAR d is equivalent to AQEM 105 e is equivalent to AQEM 117 and f is equivalent to AQEM 118 See table 19 Instead of numbers you have to enter none few several many in STAR a yellow label is displayed in AQEM if there are data in STAR and vice versa In STAR you have to mark yes
108. mpact class 4 gt 50 level and near natural duration of flooding periods impact class 3 gt 75 level and near natural duration of flooding periods impact class 2 gt 90 level and natural duration of flooding periods impact class 1 12 Natural flow quantity site deviation from natural flow quantity optional lt 10 of mean annual discharge impact class 5 lt 15 of mean annual discharge impact class 4 gt 15 of mean annual discharge impact class 3 gt 30 of mean annual discharge impact class 2 gt 90 of mean annual discharge impact class 1 13 Upstream dam site Artificial man made lenthic water body upstream affecting the site with respect to e g altered thermal regime decreased sediment load etc Expert judgement SII Table FISHING OCCASION 14 Morphological_condition_site deviation from natural state of river channel and banks e g channelization at the site canal impact class 5 channelized most natural habitat types missing impact class 4 channelized some natural habitat types missing impact class 3 most of natural channel form maintained all habitat types present impact class 2 negligible morphological alteration impact class 1 15 Salinity_site deviation from natural state at the site Constant or long periods months of strong deviations from normal salinity range impact class 5 impact class 4 Occasional deviations single measure
109. n amp Technical Considerations To use the database you will need a computer with Microsoft amp Access 2000 The database is a single user system and is not designed for simultaneous multi users The database will run fastest when placed on a local C drive rather than on a network We recommend that wherever the database is placed the directory should have at least 300Mb of storage capacity because when closing down the database it will automatically compact itself causing it to temporarily double its file size Using the database The database has an intuitive design and includes many help forms to guide the user Scoring species raw data SCH SIR CVS Highlighted Ere r MTR standardised Cover Value Scores cus 46 0 Species Cover Values SCY 24 0 Mean Trophic Rank DS D Zaw Substrate mm D Number of Highlighted Species Highlighted 7 0 1 Confidence Suffix b 10 192 Bed Stability Depth m Flow Types fastto del River Width Types Shade of channel Right gt I 4 E Lx Water Clarity Clarity Secci m Further Information For further information about the STAR macrophyte database contact The River Communities Research Group Centre for Ecology amp Hydrology Winfrith Technology Centre Dorchester Dorset DT1 1LF UK Tel 44 0 1305 213 500 For fu
110. nce integer 1 Model 2 medium abundance position 1 low abundance CCl Table CATCH VARIABLE EXPLANATION TYPE USED FOR EXAMPLE PRECISION MANT Site code See Table SITE Latitude See Table SITE Longitude See Table SITE Date Date of sampling given as Microsoft date Date format 10 Database 2002 05 14 format Format Y Y Y Y MM DD positions Species Scientific name of species see Table TAXA String 30 positions Database Atherina boyeri AND GUILDS first letter of genus Model name always capital remaining letters normally in lower case letters number all caught individuals incl 0 of the species in run Numeric integer 5 Database 12 1 positions Model Sampling Run number caught 0 of the species in run 1 Numeric integer 5 Database 3 0 plus Note Only used for species of special interest positions Model Sampling Run2 number all caught individuals incl 0 of the species in run Numeric integer 5 Database 6 2 positions Model Sampling Run2 number caught 0 of the species in run 2 Numeric integer 5 Database 1 0 plus positions Model Sampling Table CATCH Run3 number all All caught individuals incl 0 of the species in run Numeric integer 5 Database 3 3 positions Model Sampling Run3 number caught 0 of the species in
111. ndix 1 Ecoregions according to Illies and WFD Annex XI Eco region according to WFD Eco region according to WFD Participating country 1 Iberian Peninsula 14 Central Plains The Netherlands Germany Sweden Poland Day i SSS SSCS Dkdmd 1 7 Eastern Balkan fe 20 Borealic Uplands Sweden 8 Western Highlands 21 Tundra 9 Central Highlands Germany Austria Poland 22 Fenno Scandian Shield Sweden 10 The Carpathians 23 Taiga 11 Hungarian Lowlands Austria 24 The Caucasus Depression T 13 Westem Plains France Belgium The Netherlands EE EE Ecoreaions covered bv the FAME proiect 101 001 Table SITE Appendix 2 Sea areas according to ICES www ices dk ocean Code Sea area according to ICES IHB Code Sea area according to ICES IHB 1 Baltic Sea 28 Mediterranean Sea 01a Gulf of Bothnia 28a Mediterranean Sea Western Basin 01b Gulf of Finland 28b Mediterranean Sea Eastern Basin 01c Gulf of Riga 28c Strait of Gibraltar 2 Kattegat Sound and Belts 28d Alboran Sea 3 Skagerrak 28e Balearic Sea or Iberian Sea 4 North Sea 28f Ligurian Sea 5 Greenland Sea 28g Tyrrhenian Sea 6 INorwegian Sea 28h Ionian Sea 7 Barents Sea 281 Adriatic Sea 8 White Sea 28j Aegean Sea 18 Inland Sea off the West Coast of Scotland
112. ng University of L dz Krysiak Iwona Sorting University of L dz Soszynska Maj Sorting Agnieszka University of Lodz Kostecka Anna Sorting University of Lodz Podkrolewicz Sorting University of Lodz Pietruszka Dorota Sorting University of Lodz Latoszek Joanna Sorting University of Lodz Grohnert Wiktor Sorting University of Lodz Michalak Agnieszka Sorting University of Lodz Pawlikowska Magda Sorting environmental data input University of L dz Slabiak Malgorzata Audit environmental data input August Cieszkowski Agricultural University Poznan Krzysztof Field sampling Szoszkiewicz August Cieszkowski Agricultural University Poznan Ryszard Staniszewski Field sampling August Cieszkowski Agricultural University Poznan Dominik Mendyk Field sampling data input laboratory processing August Cieszkowski Agricultural University Poznan Jerzy Kupiec Field sampling data input laboratory processing August Cieszkowski Agricultural University Poznan Szymon Jusik Field sampling August Cieszkowski Agricultural University Poznan Tomasz Zgota Field sampling August Cieszkowski Agricultural University Poznan Justyna Urbaniak Laboratory processing August Cieszkowski Agricultural University Poznan Klaudia Borowiak Field sampling data input laboratory processing University of Latvia Institute of Biology LUBI Elga Parele
113. ng Whole Whole river width or partial and if partial adopted sampling strategy Codes Whole Whole river width and section Partiallbank Partial one bank Partial2banks Partial both banks Partialrandom Partial random sites Partialprop Partial each habitat type proportionally sampled Other Unknown or other strategy positions Initial capital letter and then numbers or lower case letters 901 Table FISHING OCCASION Method Electric fishing by Wading or Boat String 6 pos Sampling Wading Initial capital letter then lower case letters Day night Sampling period Day daylight or Night String 6 pos Sampling Day darkness Optional Initial capital letter then lower case letters Number of runs Number of runs passages removals carried out Numeric Sampling 3 integer 1 position Runs separated Is the catch reported separately for each run or String 6 Database Separated as a total cumulative for all runs Answer positions Initial Separated or Total If only one passage has capital letter and been carried out the answer must be Total then lower case letters Water temperature The temperature of the water depth 0 2 2 m at Numeric Sampling 19 4 sampling given in degrees Celcius Optional decimal point 5 positions LOI Table FISHING OCCASION Conductivity class E ENEE String 5
114. ocol according to the AQEM Manual STAR Site Protocol opens the window for entering stream characteristics data site protocol according to the STAR Manual The Stream Characteristics window is opened by clicking the one of the Site Protocol buttons in the Gite amp Sample Input window or by selecting Data input display in the menu and subsequently selecting Stream characteristics either STAR Site Protocol or AQEM Site Protocol in the submenu The input of stream characteristics data is based on the site protocol Specific comments concerning contents of the data can be taken from the manual for completing the site protocol General information The STAR and the AQEM site protocol differ in several terms It is possible to enter data into the STAR protocol and to open the same data in the AQEM protocol and vice versa Parameter in the AQEM protocol will be labelled in yellow if there are data filled in the STAR protocol and vice versa For details see Comments on some individual parameters below the site protocols and manuals Example Data was entered in the AQEM protocol and re opend in the STAR protocol 77 dams cumulative height AQEM Site Protocol 78 other transverse structures 5 7 dams STAR Site Protocol TBolhertansversestuctures C yes C no C na For details see Comments on some individual parameters below the site protocols and manuals 72 t
115. ocol involves collection of field and cartographic data from maps and GIS Most field data are collected during the first site visit but a limited number of time variant variables are measured recorded on each sampling visit General The sampling programme presented above is the general model Several partners have elaborated on this programme with additional sampling methods and or seasons Conversely not all partners have sampled surveyed each site for each BQE in each recommended season On balance the number of sites examined samples taken and surveys completed exceeds that stated in the project DoW The databases provided contain all the information collected from the sites comprising the 22 site types for each sampling occasion Some additional data are also included in the data sets resulting from extra sampling or extra sites or from other project WPs However not all extra sample data are currently held on the project databases and may alternatively be held by the partner that collected them 2 5 2 The replicate sampling programme For the purposes of WP11 and WP12 replicate sampling programmes for phytobenthos macro invertebrates was established results of these programmes in conjunction with the main sampling programme and the audit programme WP9 will be used to estimate and account for the variation associated with biological data collection for the purposes of bio assessment of the ecological status of river
116. oge i223 Costy 21 Gedeged cke Ej Eco regen Geological lamaten Subecotegon Mean ar lerpetstoe 70 River Meen temo Jan EI Ma sew regen Menimpa 45 Rive fee 0 Drei dee 0570 Bag seat G Fill in the Date The format is YYYY MM DD This is preformatted Be sure to be in the very left position before you start to type 87 Now you can fill in the data about the Fishing occasion Don t be surprised by the fact that you are first obliged to give the date in numerical format Y Y Y YMMDD This is just a precaution see page 27 Catches After all data about the fishing occasion has been added in the light blue region it is time to put in the catch data for that fishing occasion Catch is recorded in the lower part colour light purple of the input window As the catch is given species by species you will have to push the asterisk indicating New record after the first species is entered A Choose a Species B Now just fill in the data about the catch of that species The Id for the Catch Site code Latitude Longitude Date and Species will be transformed automatically to the subforms Length and Length classes C If you have more species caught at that site that day you will have to indicate that a new record is to be added Be sure to press the correct button Dominating substrate m Mesh size
117. ogy amp Hydrology Winfrith Technology Centre Dorchester Dorset DT1 1LF UK Tel 44 0 1305 213 500 For further information about the STAR project visit the STAR web site at amp WWwW eu star at 4 Raven P J Holmes N T H Dawson F H Fox Everard M Fozzard R amp Rouen K J 1998 River Habitat Quality the physical character of rivers and streams in the UK and Isle of Man Environment Agency Bristol United Kingdom Appendix VII The FAME project FIDES User Manual Kindly supplied to STAR by the FAME project for the purposes of this report only Not to be circulated to any third partner by any authorised RE recipient of this report Data input to the ACCESS 2000 database FIDES Fish Database of European Streams The FAME project 2002 06 04 Ulrika Beier Erik Degerman Herbert Wirl f National Board of Fisheries Institute of Freshwater Research Drottningholm Sweden Table HISTORICA 2 Help table ECOREGION Help table Site code SITE COUNTRIES Help table Site code La Lo FISHING REPORTER Reporter code OCCASION Date Help table TAXA and GUILDS Site code La Lo Date Species Site code La Lo Date Species Table Table LENGTH LENGTH CLASS Figure 1 Overview of table structure of the FIDES Access input file 77 Index Figure of FIDES structure page 77 Comments to included variables 78 Scale of variables included in FIDES 81 Instruction
118. oint six positions maximum length of the active anode Otherwise the precision centimetres maximum length of the anode HEH HH Type of current The type of current used for fish sampling String 3 Sampling PDC AC Alternating current God forbid positions all DC Dead current rippled letters capital PDC Pulsed dead current Voltage used The voltage used given in Volt Optional Numeric Integer 4 Sampling 400 positions Wattage used The wattage used given in Watt Optional Numeric Integer 5 Sampling 1200 positions OTI Table FISHING OCCASION Mesh size Mesh size not stretched net of the net used for sampling fish given in mm If possible given as a single digit e g 4 mm but interval is also acceptable e g 4 6 mm The interval should be given using minimum and maximum mesh size separated by i e 4 6 String 5 positions 7g Sampling 4 6 Land use river Impact of agriculture amp silviculture on the river basin level 1 whole catchment also downstream of segment Down to confluence with other river or the sea Classes 1 to 5 See Appendix 2 Numeric integer Reference cond Assessment Urbanisation river Impact of urbanisation on river basin level Down to confluence with other river or the sea Classes 1 to 5 See Appendix 2 Numeric integer Reference cond Assessment Connectivity river Impact of artificial migration
119. ollowed by decimal point and then positions Minutes and Seconds two digits each written after one another as decimals Note if more than four decimals 1 e decimals of Seconds the number should be rounded to four decimals Longitude is followed by E or W no space in between Measure preferably from the downstream beginning of the site Country abbreviation Country abbreviation e g PL Poland PT Portugal All String 2 Database GE available in the menu Look in help table n positions QA S6 Table SITE Eco_region_no Ecoregion according to Illies from 1 to 25 1 Numeric Typology 9 Iberian peninsula 25 Caspic depression integer 2 Displaying Complete list in Appendix 1 positions results Subecoregion National ecoregions A free text field for your String 50 Typology Bayern national codes Optional positions Initial Tanneregione capital letter and then lower case letters River type be completed following WP 1a String 50 Typology positions Initial capital then lower case letters Main river region English name of river system or marine String 50 Database Danube confluence i e marine area where the river positions Initial Typology ends meets the sea capital letter and Displaying It is suggested that river names be used only for then lower case results rivers basins larger than 25 000 For letters smaller basins the marine confluence area should be used a
120. ols used to obtain the data The collection and processing of data required to meet these objectives form Workpackage 7 WP7 Workpackage 8 WP8 of the project A specific objective of WP7 Core stream types 1 and 2 is To provide complete sets of data from sites of two stream types small shallow upland streams and medium sized deeper lowland streams distributed across Central and Northern Europe in order to inter calibrate methods integrate data from a variety of taxonomic morphological sources Specific objectives of WP8 Additional stream types include To supplement the aims of Workpackage 7 and the objectives of the project e To extend the coverage of existing or developing pan European assessment methods and databases 12 Format of the deliverable The deliverable comprises two complementary components e This written document Databases containing all the data specifically collected during and for the project 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 g METHODS Participating partners 17 of the 22 partners participated in WP7 and or WP8 These were as follows e Centre for Ecology and Hydrology United Kingdom e University of Duisburg Eesen Germany e BOKU University of Agricultural Sciences Austria e Swedish University of Agricultural Sciences Sweden e Masaryk University Brno sess Czech Republic e Hellenic Centre for Ma
121. on in the draft CEN standard on sampling of fish with electricity concerning wadable rivers prEN 14011 Hydromorphology The River Habitat Survey RHS protocol was used for hydromorphological surveys The method was devised and is commonly used in the UK It had also previously been applied in other European countries including Italy and Poland RHS surveyors are required to be certificated The UK Environment Agency and sub contractor Nigel Holmes provided three days of training for all participating partners through two three day courses held in France and Poland Only accredited surveyors were used to collect the STAR data The RHS sampling methodology is compatible with the evolving draft CEN guidance standard for assessing the hydromorphological features of rivers prEN14614 10 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 g 2 5 Sampling programme All biological and hydromorphological sampling and surveying of a site was collected within a 500m survey area typical in character for that section of the river A conceptual model Figure 1 was developed for allocating the theoretical location of each type of sample within the 500m survey area However partners were provided with the freedom to deviate from this model were local circumstances dictated Figure 1 The conceptual sampling framework to be used wherever feasible at each sampling site RHS will take place over a 500m section divided by ten transect line
122. or contact CEH via web site at www dorset ceh ac uk Brief information on the database is provided in Appendix V 3 1 4 Fish database The FIDES database used to store the STAR fish data was produced by the EC Framework V project FAME Technical data on the database may be obtained via the project website fame boku ac at The FIDES user manual is also supplied here Appendix VII by kind permission of the FAME project 32 Number of samples The total number of samples surveys including replicate samples that are known to have been collected undertaken at the 288 sites in the 22 stream types comprising WP7 and WPS are shown in Table 4 Table 4 The number of samples and surveys from the 288 sites from the 22 stream types included WP7 and WP8 Biological Quality Element Number of samples surveys Phytobenthos diatoms 265 Macrophytes 235 Macro invertebrates AQEM 712 Macro invertebrates National 721 Fish 229 Hydromorphology 263 A full list of STAR personnel responsible for collecting processing identifying recording and managing the data from these samples is given in Appendix VIII 3 3 Software supplied This report is accompanied by the supply of the three specific STAR databases and the biological and environmental data from WP7 and WPS that they contain Under the terms of the STAR DoW Table 3 4 2 deliverables list the supply of databases is RE and its dissemination is restricted by
123. otional figure stated in the DoW 6 Deliverable 31 July 2004 2001 00089 Environmental stresses Sq A single stress was associated with each of 22 STAR site types Ideally this stress pressure type should be the only one operating at sites within a STAR set of sites from a single site type However this ideal is impracticable for most sites below moderate status and the criterion for the selection of sites was redefined so that a dominant stress was associated with each of 22 STAR site types The major stress categories recognised by the study were e Organic pollution including eutrophication e Toxic pollution including acidification e Habitat degradation The predominant stressors for each of the 22 site types are given in Table 2 Table 2 Stream type definitions and pre dominant stressors Country Definition Core Add Stress Austria Small sized shallow mountain streams Corel Habitat Austria Small sized crystalline streams of ridges of the Central Alps Add Habitat Czech Republic Small sized shallow mountain streams Corel Organic Czech Republic Small sized streams the Central sub alpine Mountains Add Habitat Denmark Medium sized lowland streams Core2 Habitat France Small sized shallow headwater streams in Eastern France Add Organic Germany Medium sized lowland streams Core2 Habitat Germany Small sized shallow mountain stre
124. ountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized streams in the Central sub alpine Mountains small sized streams in the Central sub alpine Mountains small sized streams in the Central sub alpine Mountains small sized streams in the Central sub alpine Mountains small sized streams in the Central sub alpine Mountains small sized streams in the Central sub alpine Mountains small sized streams in the Central sub alpine Mountains small sized streams in the Central sub alpine Mountains small sized streams in the Central sub alpine Mountains small sized streams in the Central sub alpine Mountains Core or additional core1 core1 core1 core1 core1 core1 core1 core1 core1 core1 core1 core1 core1 core1 additional additional additional additional additional additional additional additional additional additional v00C AINE TE e qe1oAToQq 9 68000 1002 12 9 Site number 662 663 664 665 666 667 668 669 670 671 672 673 723 724 725 726 727 728 729 730 731 732 733 734 Country Denmark Denmark Denmark Denmark Denmark Denmark Denmark Denmark Denmark Denmark Denmark Denmark France France France France France France France France France France France France Stream type K02 K02 K02 K02 K02 K02 K02 K02 K02 K02 K02 K02 F08 F08 F08 F08 F08 F08 F08 F08 F08 F
125. ource Developed on MS Win 2000 amp XP prof systems System requirements high specification PC MS Win 2000 XP MS Office 2000 Complete software ca 43MB Technical support Technical support for STAR partners via email to John Davy Bowker jobo ceh ac uk or contact via web site at www dorset ceh ac uk Brief information on the database is provided in Appendix V 3 1 3 Hydromorphology RHS database Source Based on an early River Habitat Survey database developed by the Institute of Freshwater Ecology Centre for Ecology amp Hydrology UK www dorset ceh ac uk Programmer Database structure including all tables queries forms reports macros and visual basic code John Davy Bowker Centre for Ecology amp Hydrology UK www dorset ceh ac uk Database testing including testing of River Habitat Survey Indices John Davy Bowker Pete Scarlett Mike Furse Cynthia Davies John Murphy Centre for Ecology amp Hydrology UK www dorset ceh ac uk Technical information STARRHSI Programmed in MS Access 2000 Database Engine MS Access 2000 Setup non run time application open source Developed on MS Win 2000 amp XP prof systems System requirements high specification PC MS Win 2000 XP MS Office 2000 Complete software ca 55MB 20 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 L Technical support Technical support for STAR partners via email to John Davy Bowker jobo gceh ac uk
126. ow automatically placed in the first available field enter the frequency of the taxon the input is finished by pressing the enter key the taxa input window Species selection New opens again automatically all further taxa entries are performed in the same manner after taxa input click the Close button to finish data input 63 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 Options Note If you want mark one of these options in addition to an already entered taxon you have to enter the one with the addition first e g if you want to enter Baetis alpinus and Baetis alpinus juv you have to start with Baetis alpinus juv If the taxon was not securely determined the cf box can be marked Juveniles can be identified by marking the juv box If the taxon is additional to the taxalist or sampling site the box add can be marked e g Hydropsyche sp if a second Hydropsyche sp is found that is surely different to another already entered Hydropsyche sp then the add box must be marked If you wish to change a species place the cursor in the respective field and press the edit button To delete a species from the list place the cursor in the row to be deleted and press the delete button STAR AQEM data input The following columns are available TS total sample frequency of the taxon within the total sample is calculated automatically according to the number of processed cells and the 1 1 column CS
127. ow mountain streams small sized Buntsandstein streams small sized Buntsandstein streams small sized Buntsandstein streams small sized Buntsandstein streams small sized Buntsandstein streams small sized Buntsandstein streams small sized Buntsandstein streams small sized Buntsandstein streams small sized Buntsandstein streams small sized Buntsandstein streams Core or additional core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core1 core1 core1 core1 core1 core1 core1 core1 core1 core1 core1 core1 additional additional additional additional additional additional additional additional additional additional 7002 INE 9 68000 1002 12 8c Site number 735 736 737 738 739 740 751 753 756 757 849 850 851 852 853 854 855 856 857 858 835 836 837 838 839 840 841 842 843 845 847 Country Greece Greece Greece Greece Greece Greece Greece Greece Greece Greece Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Stream type H04 H04 H04 H04 H04 H04 H04 H04 H04 H04 105 105 105 105 105 105 105 105 105 105 106 106 106 106 106 106 106 106 106 106 106 Type description small sized calcareous mountain streams in Western Central and Southern Greece small sized calcareous mount
128. ow to be deleted and press the delete button Diatom sampling site NEN ABAS SPEC R Ross amp Sims Fs Achnanthidium alteragracillima Lange Bertalot Round amp Bukhtiyarova Taxa copy Taxa paste In AQEMdip 2 6 you can copy taxa from one sample unit to another Only the taxa names without number of valves will be copied e Click the appropriate sampling unit with the right mouse button in the left window e select Edit with the left mouse button e the data input window opens e mark a taxon with the mouse e add other taxa by keeping the shift button pressed e press the copy button e edit another sample unit e press the Taxa paste button e add the number of valves of the new taxa Note To avoid double entries of the same taxon it is only possible to copy taxa into an empty sample unit 70 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 d Taxalists The taxalists for macro invertebrates or diatoms are opened by choosing Taxalist in the menu and subsequently opening Macro invertebrates and Diatoms respectively in the submenu For macro invertebrates the options Taxalist Europe and Taxalist country as well as Synonyms can be chosen For diatoms the options Taxalist and Synonyms can be chosen The taxalists serve as a compendium The columns can be ordered alphabetically by pressing on the column s heading The synonym sections serve to consult the current name of a taxon Taxalist Euro
129. pe 15 9605 Species in Taxalist Europe KEE EE Ancylidae RAFINESQUE 18 Bi EGEE CHIRONOMIDAE ORTHOCLADIINAE Abiskomyia paravirgo GOETGHEBUER 19 14903 abispara CHIRONOMIDAE ORTHOCLADIINAE Abiskomyia sp 16860 abiskosp CHIRONOMIDAE ORTHOCLADIINAE Abiskomyia virgo EDWARDS 1937 14904 abisvirg CHIRONOMIDAE TANYPODINAE Tribus Pentaneurini Ablabesmyia monilis phatta 14805 ablaphmo CHIRONOMIDAE TANYPODINAE Tribus Pentaneurini Ablabesmyia sp 8854 ablabesp 10384 50420800 51410100000 CHIRONOMIDAE TANYPODINAE Tribus Pentaneurini Ablabesmyia longistyla FITTKAU 1962 8360 ablalong 10494 3565 50420801 CHIRONOMIDAE TANYPODINAE Tribus Pentaneurini Ablabesmyia monilis LINNAEUS 1758 8357 ablamoni 10495 3566 50420802 31410100010 CHIRONOMIDAE TANYPODINAE Tribus Pentaneurini Ablabesmyia phatta EGGER 1863 8355 ablaphat 10486 3567 50420803 CHIRONOMIDAE ORTHOCLADIINAE Acamptocladius reissi CRANSTON amp SAET 10997 acamreis 10583 CHIRONOMIDAE ORTHOCLADIINAE Acamptocladius sp 10988 acamsp 50463400 CHIRONOMIDAE ORTHOCLADIINAE Acamptocladius submontanus EDWARDS 1932 8361 acamsubm 4034 50453401 ACANTHOBDELLIDAE FamACANTHOBDELLIDAE Acanthobdella peledina GRUBE 1850 10638 acanpele ACANTHOBDELLIDAE Fam ACANTHOBDELLIDAE Acanthobdella sp 14480 acansp ACANTHOBDELLIDAE Fam amp CANTHOBDELLIDAE Acanthobdellidae Gen sp 16811 acantgen SCATOPHAGIDAE HYDROMYZINAE Acanthocn
130. point then the minutes two digits directly followed by the seconds rounded to two digits Finally the direction is given as N E or W no space in between So for a site with a latitude of 54 degrees 4 minutes and 12 seconds North the correct input is 54 04 12N Notice the zero 0 ahead of 4 And for a site with a longitude of 1 degrees 12 minutes and 6 seconds West the correct input is 1 1206W Notice the zero 0 ahead of 6 For some variables you are supposed to provide the absolute values It has been stressed as very important for the modelling to provide as many cases as possible with absolute values If you only have access to classified data we suggest that you use the class mid point as input Due to the great importance for modelling we anticipate that absolute values are available for almost all obligatory data If some country has to use class midpoints for an obligatory variable let us know this Always try to give the marine confluence area Main river region for all smaller rivers i e those without English name Please notice that four new variables have been added 1 Site name is included as an optional variable for countries where this variable is useful for identifying sites This was earlier called Locality name 2 Distance to mouth class has been added since this is important for typology but absolute data was a problem for several countries 3 Also notice that a new variable River type has been a
131. py all data of the selected sample number and insert them into a new sample number e the new changed sampling code will be set automatically e Click the appropriate sample number with the right mouse button in the left window e select Edit with the left mouse button e make the corrections of taxa and number of individuals according to the audit results Note It is only possible to copy combined samples for audit Options within the Site amp Sample Input window e The order of stream types stream names site names sample numbers and sample sites can be altered or fixed by changing the numbers in the small fields on the right of the appropriate layer e To delete a stream type stream name site name date sample number or sample site click the appropriate layer with the right mouse button in the left window and subsequently choose Delete e To edit a stream type stream name site name date sample number or sample site for changing your entries click the appropriate layer with the right mouse button in the left window and subsequently choose Edit Note a STAR sample code is entered it is not possible to change it any more You can only change it by deleting the old sample code and creating a new one 62 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 g Data input biological data benthic invertebrates click the appropriate sampling unit with the right mouse button in the left window select Edit with the left mouse b
132. rectory database There are 8 files with the extension mdb that you should backup with the exception of ep db mdb and ep adb mdb which do not contain any user entered data 54 6 Deliverable 31 July 2004 Main menu The main program menu bar contains the following menus File Edit Taxalist Data input display Lists Export Extras File menu Printer options Close window Taxalist menu Macro invertebrates Data input display menu Site amp Sample Input EVK1 CT 2001 00089 e options for the standard printer closes the opened window or form ends the AQEMdip deletes the marked element and copies it into the clip board copies the marked element into the clip board inserts the element from the clip board at the cursor position deletes the marked element searches for family genus species or author in the opened taxalist opens either the complete European or the country specific taxalist of benthic macro invertebrates Opens also the synonym section of benthic macro invertebrates opens the complete European taxalist of diatoms Opens also the synonym section of diatoms opens the general data structure that also serves for data input 55 t 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 o Stream characteristics opens the window for stream characteristics data input site protocol either according to the AQEM or
133. ries corel core2 or additional for STAR WP7 and WP8 List of river and site names pre classified ecological status 5 High to 1 Bad and dominant degradation stress for the stream type The samples collected and surveys undertaken at each site The AQEMDIP V2 6 User Manual 23 07 2004 The STAR macrophyte database fact sheet The STAR hydromorphology database fact sheet VII The FIDES User Manual Restricted access see full legend to appendix VIII Contributors to the data collection programme for WP7 and WP8 18 19 20 21 21 21 22 23 24 24 34 44 54 75 76 77 127 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 g 1 INTRODUCTION 1 1 Objectives The aims of this report are e To outline the procedures for the collection of new data for the purposes of the STAR project e To provide the European Commission with accessible sets of the biological and supporting environmental data collected during the project in order to meet its general and specific objectives The general objectives of STAR include Integration of data collected from a variety of Biological Quality Elements BQE required to assess the ecological status of rivers under the terms of the Water Framework Directive WFD European Commission 2000 Inter calibration of the assessments derived in different river types eco regions and Member States Quantification of the errors associated with the field and laboratory protoc
134. rine Research IIW Greece Consiglio Nazionale delle Ricerche Italy e University E Portugal e National Environmental Research Institute Denmark e Vyzkumny ustav vodohospodarsky T G Masaryka Czech Republic e Autonomous Province of Bolzano sssssssss Italy s University ot MISE France e Research Institute Senckenberg Germany University EU Food t d BARCA Poland s University DI MOINS ARN I Latvia e Slovak Academy of Sciences Slovak Republic e Comenius University Brattslava Slovak Republic 2 2 Site selection Stream types Details of the site selection are provided in the second project deliverable Hering amp Strackbein 2002 They will be summarised briefly here Participating partners selected sets of sites in specific eco regions comprised between 10 and 15 sites of similar character that represented a degradation gradient in response to a pre selected dominant environmental stressor pressure The exception to this rule was Latvia where 24 sites of one individual type were sampled Annex of the WFD Each set of sites were first defined by the System A typology outlined in section 1 2 1 of Sites were thus characterised by their altitude
135. ronment Research Institute NERI Carsten Fjorback Field sampling National Environment Research Institute NERI Hans O Hansen Field sampling National Environment Research Institute NERI Nikolai Friberg Field sampling fish ID Vyzkumny ustav vodohospodarsky T G Masaryka Jiri Kokes Field sampling Vyzkumny ustav vodohospodarsky T G Masaryka Bohdana Stefelova Field sampling data input Vyzkumny ustav vodohospodarsky T G Masaryka Eva Strasakova Laboratory processing LIMNI Ltd Blazena Brabcova Data input University of South Bohemia Zdenek Adamek Field sampling LABBIO Autonomous Province of Bolzano Stefania Covi Laboratory processing and data imput University of Metz Not yet supplied Research Institute Senckenberg Peter Haase Sampling identification invertebrates Research Institute Senckenberg Susanne Lohse Sampling identification invertebrates data input 7002 AINE TE 914 9 Research Institute Senckenberg Thomas Michl Sampling macrophytes identification macrophytes Research Institute Senckenberg Steffen Pauls Sampling identification Invertebrates data input Research Institute Senckenberg Karin Schindehuette Sampling identification Invertebrates data input Research Institute Senckenberg Andrea Sundermann Sampling identification Invertebrates data input
136. rsion of 2 RHS hydromorphological indices Habitat Quality Score HQS Habitat Modification Score HMS The database also allows exports of raw data and index values to Microsoft amp Excel Installation amp Technical Considerations To use the database you will need a computer with Microsoft amp Access 2000 It is also recommended that you use a fairly high specification computer The database is a single user system and is not designed for simultaneous multi users The database will run fastest when placed on a local CX drive rather than on a network We recommend that wherever the database is placed the directory should have at least 300Mb of storage capacity because when closing down the database it will automatically compact itself causing it to temporarily double its file size Using the database The database has an intuitive design and includes many help forms to guide the user BACKGROUND MAP BASED INFORMATION EDITS HE Altitude m Te Slope m km Ez Solid geology code Help Drift geology code 1 Cinnifjeant byl Resectioned reprofiled En cu ms Reinforced whole bank GCN 54 Reinforced top only Ga Reinforced toe only Jove Artificial two stage NX Poached wen Embanked Setback embankments Further Information For further information about the STAR hydromorphology database contact The River Communities Research Group Centre for Ecol
137. rsion to be accessed through Internet later this year Possible import methods This short input manual is not an Access 2000 database manual We have tried to facilitate for inexperienced users by making a menu which guides you through the data input For the more advanced users it is also possible to work directly with the tables or to import data from other programs Additionally we provide you with the opportunity to import data via formatted Excel spreadsheets Thus you have four ways to input the data 1 Via keyboard using the menu the form 2 Via keyboard directly into the data tables 3 Via keyboard to Excel spread sheets which are then imported to Access 4 Directly import files from other applications If you are an novice Access user and do not have the data in files already we suggest route 1 above i e keyboard input with the help of the menu help tables validity checks and adjusted formats In this way also all links between tables are established automatically and the risk of input errors are reduced If you are a more experienced user and prefer to input data from the keyboard directly into the tables route 2 is possible but route 1 is still suggested If you choose route 3 the data input into the Excel tables is quite easy but the import to FIDES is difficult and will have to be performed by a professional database manager To import data directly into FIDES i e route 4 will be common among those of you that h
138. rther information about the STAR project visit the STAR web site at B WWW eu star at Dawson F Newman J R Gravelle M J Rouen K J Henville P 1999 Assessment of the trophic status of rivers using macrophytes Environment Agency R amp D Technical Report E39 Environment Agency Bristol United Kingdom Centre for Ecology amp Hydrology NATURAL ENVIRONMENT RESEARCH COUNCIL Appendix VI The STAR hydromorphology database fact sheet qu The STAR Hydromorphology Database Fact Sheet The EU Framework 5 project STAR has created a new project database of hydromorphological data from 324 stream sites in 13 European Union member states The STAR hydromorphology database contains new survey data collected by the STAR consortium during 2001 2002 and 2003 using River Habitat Survey methodology This fact sheet briefly describes what the database contains its installation requirements how to use the database and where to obtain further information What the database contains The STAR hydromorphology database contains River Habitat Survey data River Habitat Survey is a comprehensive survey system for assessing the hydromorphological structure of streams including the nature of the stream substrate the banks and all common forms of human modifications The database is designed to hold data for 4 different versions of RHS form 1997 2001 2001 Southern European and 2003 versions and also calculates the 1997 ve
139. run 3 Numeric integer 5 Database 0 0 plus positions Model Sampling Rund number all caught individuals incl 0 of the species in run Numeric integer 5 Database 4 positions Model Sampling Rund number caught 0 of the species in run 4 Numeric integer 5 Database 0 plus positions Model Sampling Total number all caught individuals incl 0 of the species in all Numeric integer 5 Database 21 runs cumulative total positions Model Sampling Total number caught 0 of the species in all runs Numeric integer 5 Database 6 0 plus cumulative total positions Model Sampling Vcl Table CATCH Total biomass Estimated biomass of the species in kg per Numeric decimal Database 32 450 hectare 710 000 m It is understood that the point 9 positions Model biomass is calculated from the estimated THHBBR HHH abundance E g 3 kg was caught in the Note that allowed sampling of the species and the number of precision is down to caught individuals was 10 The estimated gram abundance was calculated to 100 individuals ha Then the Total biomass should be 30 kg ha Biomass estimate Define if biomass was estimated by weighing String 2 Sampling WE or length weight conversion Code WE positions use or LW Optional only capital letters Total abundance Estimated abundance no of individuals of the Numeric integer 6 Database 1200 species per
140. ry Stream spring spring season season winter spring spring season season winter winter Diatoms Diatoms Macio Fish RHS site number type n H a main phytes main 2 2 main 2 2 protocol 859 Portugal P04 860 Portugal P04 861 Portugal P04 862 Portugal P04 863 Portugal P04 864 Portugal P04 865 Portugal P04 866 Portugal P04 867 Portugal P04 868 Portugal P04 969 Slovakia V01 970 Slovakia V01 971 Slovakia V01 972 Slovakia V01 973 Slovakia V01 974 Slovakia V01 975 Slovakia V01 976 Slovakia V01 977 Slovakia V01 978 Slovakia V01 979 Slovakia V01 980 Slovakia V01 981 Slovakia V01 982 Slovakia V01 983 Slovakia V01 984 Slovakia V01 985 Slovakia V01 986 Slovakia V01 987 Slovakia V01 988 Slovakia V01 989 Slovakia V01 990 Slovakia V01 991 Slovakia V01 992 Slovakia V01 993 Slovakia V01 v00C AINE TE e qe1oATo QT 9 68000 100C LO DMAH cs Site number 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 874 875 876 877 878 879 880 881 882 883 887 888 Country Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Sweden Stream type 505 505 505 505 505 505 505 505 505 505 505 505 505 505 505 506 506 506 506 506 506 50
141. s medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams medium sized lowland streams Core or additional core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 core2 v00C INE TE e qe1oAmoq 9 68000 1002 122 0t Site number 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 968 916 917 918 m Core or Country Stream type Type description additional S Poland 002 medium sized lowland streams Eco region 14 o Poland 002 medium sized lowland streams Eco region 14 core2 lt Poland 002 medium sized lowland streams Eco region 14 core2 e Poland 002 medium sized lowland streams Eco region 14 core2 Z Poland 002 medium sized lowland streams Eco region 14 core2 W Poland 002 medium sized lowland streams Eco region 14 core2 a Poland 002 medium sized lowland streams Eco region 14 cor
142. s 83 1 Input from keyboard form view 85 2 Input from keyboard datasheet views 9 3 Importing from Excel 92 Table REPORTER 93 Table SITE 94 Table FISHING OCCASION 105 Table HISTORICAL 111 Table CATCH 122 Table LENGTH 125 Table LENGTH CLASS 126 Note variables given in boldface are obligatory whereas variables in italics are optional Comments to included variables For each table you will find a description of the variables definitions and precision required Note variables given in boldface are obligatory whereas variables in italics are optional The table REPORTER page 15 holds information about the person who 18 responsible for the reporting of data from each country It is not the person who actually fished it is the person for us to mail if there are questions regarding the data Table SITE pages 16 26 refers to the location sampled and the physical characteristics of the site The information included is such that it does not change within or even between years The Site code is unique for each site as well as Latitude and Longitude are So the Latitude Longitude should be redundant data in the other tables But we are rather safe than sorry and therefore include both the Site code and Lat Long in all tables 78 There has been some confusion about the coordinates Lat Long Please check that you understand the format It is a string text not a numerical value First you give the degrees then add a decimal
143. s name Suggested names of marine regions are according to ICES sea area list see Appendix 2 below Do not use the numeric code use the full name River name National name of the river For transboundary String 50 Matching small rivers use the name from the country positions Initial national data where it confluences i e Semois Belgium capital letter and Database Semoy France then lower case letters 96 Table SITE National code 1 Your national map grid coordinates first Numeric Database 656578 0 direction e g North South decimal point QA 13 positions HHRHH MAD Your national map grid coordinates second Numeric Database 143567 0 National map code direction e g East West decimal point QA 2 13 positions PIHHHBHLTHHBHHE Size of catchment class So of the catchment watershed upstream of the sampling String 6 Typology 1000 Classes 10 100 1000 10000 10000 km i e 0 9 10 99 100 999 1000 9999 10000 Obligatory Size of catchment Absolute size of the catchment upstream of Numeric Model 768 sampling site given in km integer 7 Optional but the goal must be to provide data positions for at least 50 of sites PIHHHHBI Width flooded area The width of the active floodplain area in Numeric Model 140 metres Should refer to natural conditions The integer 5 area flooded in 50 years intervals should be positions
144. s where spotchecks will be taken The predominant substratum between each spotcheck will be recorded No downstream spotcheck Flow ck RHS spotcheck no 1 2 3 4 5 6 7 8 9 10 The conceptual locations of the STAR sampling areas for each of the five recorded features at each STAR sample site Indications of the type and location of the substratum estimates are also given Fish sampling using CEN based protocols will take place in the middle of the RHS section The maximum fished length is likely to be 100m and fishing should take place between RHS spotchecks 4 and 6 If a longer fishing length is needed the fished section should be extended upstream only For preference the fishing section should be Stop netted although this is not essential The FAME sampling method seems to require substratum sampling so this should be recorded using the same units and categories as in the AQEM protocol The AQEM macroinvertebrate sampling section is between RHS spot checks 8 and 10 In practice a suitable AQEM sampling section should be selected containing both runs and riffles The 100m AQEM macro invertebrate sample should be centred on RHS spotcheck 9 and at this point should be on the predominant flow type run or riffle over the 100m AQEM substratum estimation will take place in this section The national macro invert sample should be taken in lt the same 100m
145. section The AQEM sample should be The macrophyte survey should taken first be between RHS spotchecks 6 and 8 It will cover 100m gt The substratum in the survey The phytobenthos samples area for macrophytes should should be taken in the same be recorded using the same 100m section units and categories as in the AQEM protocol No substratum estimation needed for phytobenthos 2 5 1 The main sampling programme Phytobenthos A single sample of benthic diatoms was collected at almost all sampling site by the participating partners According to the partner s choice the sample was taken from either hard substrata sand or the surface of macrophytes A single sample was collected as an aggregate collection of material from more than one object stone plant stem etc Details of the sampling protocol including substratum selection are given on the project website 11 t 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 g Wherever possible the sample was taken within the macro invertebrate sampling area which was between 350 450m below the upstream limit of the survey area Figure 1 Samples were collected after a period of stable flow and if this criterion was met preferably in spring Macrophytes A single MTR survey was conducted at almost all sampling site by the participating partners The sampling reach was 100m in length and ideally was located between 250 and 350m below the upstream limit of the survey
146. ste af leg Catch Length class ox Leva cimo cine Histonca date esie This is a form that acts like an interface between you and the tables stored In the left column are the data input section Be sure to use the upper left part input from Keyboard If You want to look at data go to the middle column upper part under View data reports When you push the buttons below each table will be displayed You can choose between different kinds of views input view or spreadsheet view When you are finished looking leave the report by clicking on the lower of the two of the upper x of the screen JEN Bedgera Ves loge Format Poser Verktyg Finder Mio ps mes meta 2 2 Al Sites code Fro Longitude Finally there is an option to do some validity checking of the data that are in the tables Try these buttons after the initial data input sessions You ll find them in the lower part of the middle column 85 Adding new data the tables that will be displayed are connected When you open your database for the very first time it will be empty Now it is easy to just start to add data The next time you are putting in data you will see the old data in the input form when you start To add new data then you must tell the program that new data are coming New records The easiest way to do this_is to click on the asterisk the
147. stria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Stream type River name A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 Sarmingbach Kleine Ysper Giefienbach Grosse Ysper Sarmingbach Giefienbach H llbach Sarmingbach Sarmingbach Kleine Ysper Sarmingbach H llbach Kleine Ysper Giefienbach Giefienbach Stainzbach Wildbach Stullneggbach Wei e Sulm Stainzbach Wildbach Stullneggbach Wei e Sulm Stullneggbach Stainzbach Wei e Sulm Gradnerbach Schwarze Sulm Schwarze Sulm Schwarze Sulm Schwarze Sulm Schwarze Sulm Stainzbach Stullneggbach Stullneggbach Stullneggbach Site name Wolfsschlucht upst Ysperm hl upst Grasm hle near Altenmarkt upst Angern downst Grasm hle near W rnsdorf Waldhausen Waldhausen artificial channel lower part Artnerm hle artificial channel lower part Waldhausen artificial channel upper part upst W rnsdorf Artnerm hle artificial channel upper part Klausm hle Klausm hle downst weir H llgraben near Kramermirtl near Kruckenberg Sulmklamm near Marhof upst Schoberberg near Aichegg Wernersorf near Mainsdorf Bad Sauerbrunn
148. t MM GO P bb Oo Oo Oo gt M GO P bb P Oo Dominant stressor None None None None Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat None None Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat None None Habitat Habitat Habitat Habitat Habitat Habitat Habitat Habitat v00C INE 9 qe1oA ToC 9 68000 100 LD T AAA 8t Site number 735 736 737 738 739 740 751 753 756 757 849 850 851 852 853 854 855 856 857 858 835 836 837 838 839 840 841 842 843 845 847 Country Greece Greece Greece Greece Greece Greece Greece Greece Greece Greece Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Stream type River name H04 Peristeria H04 Peristeria H04 Tsouraki H04 Tsouraki H04 Krathis H04 Peiros H04 Koiliaris H04 Gadouras H04 Gorgopotamos H04 Gorgopotamos 105 Rio della Cascata K 10 15 105 Rio S Nicol B 25 80 105 Rio di Camin B 65 95 105 Rio Gardena 1 105 Rio Gardena 1 105 Rio Gardena 1 105 Rio Funes B 300 105 Rio Stolla C 400 10 105 Rio Stolla 400 10 105 Rio Sesto J 105 106 Farma 106 Albegna 106 Merse 106 Feccia 106 Lente 106 Senna 106 Paglia 106 Fiora 106 Fiora 106 Zancona 106 Ente Site name Artiki Kalo nero Tsouraki SL 9
149. the consortium to the 22 partners in the STAR consortium and to the officials of the European Commission responsible for the management of the STAR project EVK 1 CT 2001 00089 21 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 L 4 DISCUSSION The STAR WP7 and WP8 sampling programme involved amongst the most extensive collection of standardised riverine biomonitoring data ever assembled both in its geographical coverage and its range of biological quality elements It has involved the sampling of 288 sites in 14 Member States spread between Portugal in the west to Poland in the east and from Italy and Greece in the south to Sweden in the North The data collected is an extremely valuable resource for use both within and outside the STAR project They are supported by equally useful databases and taxon lists that will have both internal project and external applications 22 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 L 5 REFERENCES European Commission 2000 Directive of the European Parliament and of the Council 2000 60 EC establishing a framework for community action in the field of water policy European Commission PE CONS 3639 1 100 Rev 1 Luxemborg Hering D amp Strackbein J 2002 STAR stream types and sampling sites A report to the European Commission on the STAR Project EVK1 CT 2001 00089 28pp Lecointe C M Coste amp J Prygiel 1993 OMNIDIA software for taxonomy calculation of diatom indices and in
150. ther first letter always capital and the rest in lower case Length_type Total length or Fork length String 5 positions first Further work Total letter always capital and the rest in lower case Length_class_min Give length class lower limit in mm Numeric integer 4 Further work 50 positions Length_class_max Give length class upper limit in mm Numeric integer 4 Further work 99 positions Number Number of individuals in this length class Numeric integer 4 Further work 2 positions Appendix Contributors to the data collection programme for WP7 and WP8 Partner Name Role Centre for Ecology and Hydrology CEH Nick Kneebone Sampling sorting identification diatoms inverts data input Centre for Ecology and Hydrology CEH Martin Neale Sampling sorting identification inverts Centre for Ecology and Hydrology CEH Helen Vincent Sampling sorting identification diatoms inverts data input Centre for Ecology and Hydrology CEH Tracy Corbin Sampling sorting identification inverts data input Centre for Ecology and Hydrology CEH Mike Furse Sampling CEH visiting scientist University of Granada Jose Poquet Sampling Centre for Ecology and Hydrology CEH Rick Gunn Sorting identification Oligochaeta Centre for Ecology and Hydrology CEH John Blackburn Sorting identification Chironomidae Centre for Ecology and Hydrology CEH John Murphy Sorting ident
151. tion e choose a Sample unit from the selection list e choose a STAR AQEM Sub sample and the number of processed cells from the selection lists e choose an option for Audited Note you make your choice from the first second third selection list the following selection lists will only comprise those options that are possible regarding your first second third choice Note If you have sampled riffles and pools or other sample units separately you have to enter them as different sampling units e g Unit 1 to 20 Please tick the check box sum up the frequencies according to your choice mark the sum up the frequencies of the sampling sites field if you want to have the frequencies of the sample units within the sample number summed up otherwise the program will calculate the mean values 61 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 o Copy for audit To facilitate the input process of audit data it is possible to copy an already entered sample so that you do not have to enter all taxa again e Click on the sample number that you want to copy in the left window e Click on the Copy for audit button e choose one of the three audit options internal external or internal amp external audit e press the Copy button Audited intemally Audited w Internally Audited Externally Audited d Internally amp External Audited Close Combined All sample units e the program will co
152. tion cannot be performed correctly The calculation is activated manually by pressing the calculate button the table is also saved for further checking AQEM site protocol only 74 Appendix V The STAR macrophyte database fact sheet Centre for Ecology amp Hydrology NATURAL ENVIRONMENT RESEARCH COUNCIL qo The STAR Macrophyte Database Fact Sheet The EU Framework 5 project STAR has created a new project database of macrophyte data from 295 stream sites in 13 European Union member states The STAR macrophyte database contains new survey data collected by the STAR project consortium during 2002 2003 and 2004 using Mean Trophic Rank methodology This fact sheet briefly describes what the database contains its installation requirements how to use the database and where to obtain further information What the database contains The STAR macrophyte database contains Mean Trophic Rank survey data Mean Trophic Rank is a comprehensive survey system for assessing the aquatic macrophyte structure of streams and also includes physical assessments such as substrate type flow patterns and water depth The database also calculates a version of the Mean Trophic Rank scoring system This allows an assessment to be made of the degree to which a stream is impacted by organic pollution or enrichment based on its macrophyte flora The database also allows exports of raw data and index values to Microsoft amp Excel Installatio
153. tions more than 300 impact class 4 Conditions within 150 300 of established national background levels of P N and TOC concentrations impact class 3 Occasional deviations more than 150 impact class 2 Conditions within 150 of established national background levels of P N and TOC concentrations impact class 1 18 Introduction of fish site impact from species new to river basin at the site Optional Expert judgement assessment of impact on natural fish fauna Self reproducing populations with high numbers impact 4 or 5 should be compared to not reproducing species in low numbers impact 2 or 3 19 Impact of stocking site impact of species already present in river basin at the site Optional Expert judgement assessment of impact on natural fish fauna genetic effects not considered 20 Exploitation site impact of human exploitation e g fishing at the site Optional Expert judgement assessment of impact on present fish fauna 2 Fauna impact site Effects on fish fauna at the site from introduced species invasive species or rapidly increasing species not fish e g predation parasitism competition Classes 1 to 5 Expert judgement assessment of impact on present fish fauna Optional Table FISHING OCCASION 22 Flora impact site Unnatural increase in water vegetation at the site including helophytes reeds and submerged macrophytes Classes 1 to 5 Expert judgement Option
154. ts N Species selection New 101 x Genus Achnanthes Species elliptica Cl Euler var pungens fo ikpukensis e Note If you cannot find a certain taxon in the taxalist please open the synonym table Menu Taxalist and select the current name of the taxon If the taxon is not listed there please inform Piet Verdonschot P F M Verdonschot Alterra wag ur nl click the Accept button or press the enter key to finish this taxon input the species is loaded into the sampling site window the cursor is now automatically placed in the first available field enter the number of valves for the taxon into the no valves column the input is finished by pressing the enter key the taxa input window Species selection New opens again automatically all further taxa entries are performed in the same manner after taxa input click the Close button to finish data input Options If the taxon was not securely determined the cf box can be marked Note If you want mark this option in addition to an already entered taxon you have to enter the one with the addition first e g if you want to enter Achnanthes arctica and Achnanthes cf arctica you have to start with Achnanthes cf arctica 69 D 6 Deliverable 31 July 2004 2001 00089 e e f you wish to change a species place the cursor the respective field and press the edit button e To delete a species from the list place the cursor in the r
155. upstream catchment size and pre dominant geological type The WP7 sites comprised two groups of sets of sites e Core stream type 1 e Core stream type 2 Each set usually t 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 g Both sets of sites were also included in the preceding AQEM project EVK1 CT1999 00027 and much of the macro invertebrate and environmental data collected in the two projects are compatible for analytical purposes Core stream 1 sites were all at mid altitude 200m 800m and had small catchment areas 10 100km2 In practice it was decided that all sites would be chosen to be in the range 200 500m Core stream 2 sites were all classed as lowland lt 200m and had medium catchment areas 100 1000km2 Each set of sites was chosen to be of a common geological type selected from the WFD options of calcareous siliceous and organic The WFD offered no definitions of these classes and none were uniformly accepted by Member States at the inception of STAR STAR partners adopted their own specific definitions of these terms based on either catchment geology or a parameter indicative of catchment geology such as the alkalinity of the stream water at the sampling location Partners further refined their definition of their site groups by other common geographical or environmental characteristics The many examples include Small sized streams in the southern calc
156. utton a data input window according to your preceding choice opens explanation of different available columns see below to enter a taxon click on the button New the window Species selection New opens select the Taxalist from the selection list the country list is loaded as the default setting however the complete European taxalist may be selected alternatively select a Genus and a Species in the second and third field from the respective selection lists Note Once the genus is selected only the possible species names according to the selected genus and taxalist appear in the species list By typing the first characters of the genus or species name the process can be accelerated the tabulator allows you to switch between the fields using Alt and the cursor buttons you can scroll up and down the selection lists 23 Species selection New Bl x Taxalist of Genus eats Species alpinus e Note If you cannot find a certain taxon neither the taxalist of your country nor in the European taxalist please open the synonym table Menu Taxalist and select the current name of the taxon If the taxon is not listed there please inform Armin Lorenz armin lorenz uni essen de or Astrid Schmidt Kloiber astrid schmidt kloiber boku ac at click the Accept button or press the enter key to finish this taxon input the species is loaded into the sampling site window the cursor is n
157. ventories management Hydrobiologia 269 270 509 513 23 AppendixI List of stream types and categories corel core2 or additional for STAR WP7 and WP8 Site number 600 601 602 603 604 605 606 607 608 609 610 611 612 952 953 700 701 702 703 704 705 706 707 708 709 710 711 712 954 955 956 957 958 959 960 961 Country Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Austria Stream type A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A05 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 A06 Type description small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow mountain streams small sized shallow
158. ving up the table use the up arrow Up or the page up lt PgUp gt keys If you want to move the highlight to the very first cell of the table A1 press lt Ctrl Home gt Conversely if you want to move the highlight to the very last cell of the table press lt Ctrl End gt To move the highlight from field to field use either the lt Tab gt or lt Enter gt keys To copy a field s value from the previous record to the current record press Ctrl the Ctrl key the apostrophe key To save instantly press lt Shift Enter gt Before you start Make a copy of the database for training purposes Continue to make back up copies through out 84 1 Input from keyboard form view Start the program with the file FIDES mdb This can be done in many ways all familiar to the Windows user Automatically the menu will show see below FIDES Fish database of European streams Export database Input from keyboard form wews New occasions Catches Lengths Length Help tables Courtnes reasonable values Other reasonable dato All fishing occations All catches Ecoregons sta ad Sia Stes Fishing occasions and Catches esten All reporters and Guilds Mow nang accm icm amd caches From the Swedish National Denn naf Ert Validity tests data in tables Caci arse Ste Reporter J Fishing occasion Lown ba
159. y D06 821 Germany D06 822 Germany D06 823 Germany D06 824 Germany D06 SSES 7002 AINE TE e qeJoAT oQT 9 68000 1002 12 8r AQEM AQEM Nat l Nat l Nat l Nat l Nat l Nat l 3 AQEM Site Stream E d Diatoms Diatoms Macro spring spring season season winter spring spring season season winter winter Fish RHS site main repl 2main 2repl main main repl 2main 2repl main repl Country number type main phytes protocol 735 Greece H04 736 Greece H04 737 Greece H04 738 Greece H04 739 Greece H04 740 Greece H04 751 Greece H04 753 Greece H04 756 Greece H04 757 Greece H04 849 Italy 105 850 Italy 105 851 Italy 105 852 Italy 105 853 Italy 105 854 Italy 105 855 Italy 105 856 Italy 105 857 Italy 105 858 Italy 105 835 Italy 106 836 Italy 106 837 Italy 106 838 Italy 106 839 Italy 106 840 Italy 106 841 Italy 106 842 Italy 106 843 Italy 106 845 Italy 106 847 Italy 106 002 INE e qe1oATo QT 9 68000 100 LD T AAA 6t Site number 997 998 999 1006 1007 1017 1018 1019 1020 1021 1022 1023 1024 1031 1035 996 1002 1005 1010 1013 1016 1027 1030 1034 Country Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Latvia Stream type L02 L02 L02 L02 L02 L02 L02 L0
160. y Small sized calcareous streams in the Central Apennines Latvia Medium sized lowland streams Poland Medium sized lowland streams Eco region 14 Poland Medium sized lowland streams Eco region 16 m Portugal Medium sized streams lower mountainous areas S Portugal Slovakia Small sized calcareous mountain stream in the E Carpathians Slovakia Small sizes siliceous mountains streams the W Carpathians Sweden Medium sized lowland streams Sweden Medium sized streams on calcareous soils UK Small sized shallow lowland streams UK Medium sized lowland streams BER RE ERE T 2 4 Sampling methods A series of standard national and international sampling protocols each with supporting laboratory bankside sample processing protocols were selected for use in the project Many of these are displayed on the STAR website www eu star at under the public access section Protocols The methods for each biological hydromorphological elements will be listed briefly here 6 Deliverable 31 July 2004 EVK1 CT 2001 00089 L Phytobenthos Phytobenthos samples were collected using the protocols associated with the Trophic Diatom Index TDI indexation method The procedure is in accordance with the Draft European Standard Guidance standard for the routine sampling an pre treatment of benthic diatoms from rivers prEN 13946 Macrophytes Macrophyte surveys were undertaken using the proto

Standardisation of river classifications:

Contents

Download Pdf Manuals

Related Search

Related Contents