Home

Rivers Database Version 3 A User Manual

1. Chem Code Description Unit Minimum Maximum MO Molybdenum mg l 0 005 0 5 MO DISS Molybdenum Dissolved mg l 0 005 0 5 MO H Molybdenum Acid extractable mg l 0 005 0 5 NA Sodium mg l 1 500 4 Ammonia nitrogen mg l 0 0001 10 NI Nickel mg l 0 004 1 NI DISS Nickel Dissolved mg l 0 004 1 Nickel Acid extractable mg l 0 004 1 NO2 N Nitrite nitrogen mg l 0 0007 0 5 NO3 NO2 N Nitrate Nitrite Nitrogen mg l 0 04 5 NO3 N Nitrate nitrogen mg l 0 0001 1 ORGS Organic fraction in TSS mg l 0 100 PB Lead concentration mg l 0 0001 0 15 PB DISS Lead Dissolved mg l 0 001 0 15 PB H Lead Acid extractable mg l 0 001 0 15 PH pH pHunit 2 10 PHEN Phenols mg l 0 001 0 1 PO4 P Orthophosphate mg l 0 005 1 REDOX Redox MV 10 300 SALINITY Salinity SI Silicates mg l 0 01 35 04 Sulphate mg l 0 01 2000 SR Strontium mg l 0 001 5 SR DISS Strontium Dissolved mg l 0 001 5 SR H Strontium Acid extractable mg l 0 001 3 SRP oe reactive phosphorus often assumed PO4 mg l 0 0001 1 TAL Total alkalinity meg l 0 01 5 TDS Total dissolved solids mg l 1 5000 Temperature oC 5 35 TI Titanium mg l 0 001 0 1 TI DISS Titanium Dissolved mg l 0 001 0 1 TI H Titanium Acid extractable mg l 0 001 0 1 TP Total Phosphate mg l 0 005 0 5 TSS Total suspended solids mg l 0 0001 50 TURB Turbidity NTU scale NTU 0 100 V Vanadium mg l 0 002 0 1 V D
2. Code Scientific Name Common Name Family Status Hbar Hemigrammopetersius barnardi Herre 1936 Barnard S Robber Characidae Hodo Hepsetus odoe Bloch 1794 African Pike Hepsetidae Hlon Heterobranchus longifilis Valenciennes 1840 Vundu Clariidae Hans Hippopotamyrus ansorgii Boulenger 1905 Slender Stonebasher Mormyridae Hdis Hippopotamyrus discorhynchus Peters 1852 Zambezi Parrotfish Mormyridae Hvit Hydrocynus vittatus Castelnau 1861 Tigerfish Characidae Native Hmol Hypophthalmichthys molitrix Valenciennes 1844 Silver Carp Ex Cyprinidae Introduced Hcap Hyporhamphus capensis Thominot 1886 Cape Halfbeak Ms Hemirhamphidae Hday Hypseleotris dayi Smith 1950 Golden Sleeper M Eleotridae Hjub Hypsopanchax jubbi Poll amp Lambert 1965 Southern Deepbody Cyprinodontidae Kang Kneria angolensis Steindachner 1866 Angola Kneria Kneriidae Kaur Kneria auriculata Pellegrin 1905 Southern Kneria Kneriidae Native Kmay Kneria maydelli Ladiges amp Voelker 1961 Cunene Kneria Kneriidae Kpol Kneria polli Trewavas 1936 Northern Kneria Kneriidae Krup Kuhlia rupestris Lacep de 1801 Rock Flagtail Ms Kuhliidae Lalt Labeo altivelis Peters 1852 Manyame Labeo Cyprinidae Lans Labeo ansorgii Boulenger 1907 Cunene Labeo Cyprinidae Lcap Labeo capensis Smith 1841 Orange River Labeo Cyprinidae Lcon Labeo congoro Peters 1852 Purple Labeo Cyprinidae Native Lcyl Labeo
3. 9 Creating a new river and notifying the Rivers Administrator to ensure river validatiOn ica reete the eti ie petes et dete elec es 9 Viewing details 0f a ne eee ee He eee esa e aee 10 Viewing tributaries Of a river eene netten 10 Viewing sites on a river the longitudinal zone and a description are june 11 Viewins site cte tite REP eee 11 Uploading photographs to a site eene 12 Searching for a river using the extended search 15 Sorting the rivers in the tree view sese 15 Adding a sitein the Site Last cies reu ee iode nerit 16 Adding site visit from the main 16 Toolbar providing access to forms in Section and General Site Information 19 Spatial Information ote Pete eee alee Eee e eee RP e R 20 Location Detail ree etie tee aes neem apnea 20 Site Transaction ie ated ie ee eel 21 Adding anew Site seo cpi 23 Condition of Catchment tine en en ete 23 Channel Condition iE tee pete edite 24 Channel Morphology ae eerte e e Ree e RR Re Ree ee aen 24 Instream riparian zone and catchment 25 Rivertype and seasonality 2 t egesta ides e e Oo euet ithe 26 instream compohnents itte retener ot e ee ke ee ce PL Dee et 26 THE Riparian C
4. 11201 00 00 Version 3 0 2664 27407 Logged on User Administrator Screen 4 4 Adding a site visit from the main menu 16 Rivers Database Version 3 2007 4 2 Viewing and adding Site data Section A When a site is selected from the list the general site information form is loaded by default into a new tab The site and site visit list are still open in their original tab allowing the user to open multiple sites at the same time The tab can be closed by clicking on the x in the right hand corner Section A contains three forms which display general information about a site and a fourth form which summarises any changes made to this information Each of the forms are available via a vertical toolbar on the left hand site of the form Screen 4 5 Section A includes the following forms e General Site information e Spatial Information e Location Details e Site Transactions Site Header A header with information about the current user the organisation to which the user is affiliated and the owner of the data as well as the RHP Site Code remains visible at the top of the screen as one clicks through each screen in this section a General Site information Screen 4 5 General site information includes information that characterises the site Each field is described briefly below and the reader is referred to the glossary or Dallas 2005 if additional clarification is required In a
5. A specific query example is provided in Appendix 2 and a list of Frequently Asked Questions FAQs is provided in Section 6 4 to assist with any problems that may be encountered when installing or using the Query Master 42 Rivers Database Version 3 2007 Query Master Microsoft Internet Explorer File Edit View Favorites Tools Help Qs c a yo Search Sf Favorites z amp http localhost querymaster SelectSphere asp Links gt Query Master Primary Data Component Selection Information Select the required Primary Data Component then click the Next button Click on any component icon to view a list of the fields that are available within that component gig oka Category Description Data Category Selection Password Information that characterises the site such as RHP site code site ownership Site Description River Section Primary longitudinal zone Map Reference Site Length Altitude Hydrological Type Natural and Present day Information General Site Associated Systems etc Information at site visit level including RHP Site Code Sampling Date and Site Visit Owner Additional Primaty spatial fields are included to facilitate filtering e g River Name Longitudinal Zone Altitude Political Section A Information region WMA Ecoregion and Il Sec and Quar catchment Veg Type Geol Type Bioregion WCMR and G
6. Location and Landowner Detail Tum off the R43 Near Goudini and Worcester Spatial Information Notify Owner L1 Contact No Permit Required rT Permit Details Key Needed a Key Details Farm Name Somerso Farm Registration Code Site Transaction Version 3 0 2664 27407 Logged on User Administrator Screen 4 7 Location Detail 20 Rivers Database Version 3 2007 Rivers File Site Tools Window E 2 g lel ISBREE ABBEY T General Site Information i E Spatial Information Location Details Hel Site Transaction Version 3 0 2686 22353 pM H5BREE ABBEY 5 User Organisation Owner Geordie Ractliffe Freshwater Consulting group Site Transactions Secondary Catchment H7 General Site Comment Original Value H7BREE ABBEY Modified To H5BREE ABBEY Date Changed User 2006 05 09 12 00 00 AM Administrator 2006 05 09 12 00 00 AM Administrator 2003 03 25 12 00 00 Administrator Organisation Freshwater Consulting group Freshwater Consulting group H5 SASS scores from report The SASS scores from report The Freshwater Consulting group Logged on User Administrator Screen 4 8 Site Transaction 4 3 Viewing and adding Site Visit data Sections B and C The following procedure outlines the steps taken when addi
7. 12 14 Query Master enne eate nih ene oi utem ate 2 40 Defining Filter Critetia iu mde NR En Hr ege tee eR eee cue 40 Display report 5 eene eR RAT ERRARE BAG HER Sed 41 53 Field e eee 40 Prequently asked questions eec rre ee e epe o UE E E Genres 47 Output 5 eiat e te ede o ote oe t Em Her He Eas 42 Primary Data Component 5 eI e ee cei e a e e ERE AE Le ae ces Ie abd 40 Secondary Data Componetit 2 eene e Eee SEE e dece PU eee seen e cipe te 40 aisi ER 46 Step by step instructions on using the QM ce cesceseceseceseesseeseeeeeeeeeseeeseecaaeesecseceeeeeseeseneeeaes 40 References Pto ae db e PROPERE EET aE n dis 50 Register as new User eR Hep ed rad ed eti ee e te ee t tee to eden eto e Ce 3 Reporting bugs or error messages 50 Rivers C iet eot etate oet ea net ava mah siet ade 2512 9 aede deed tu tiende tdt ceni iet i S 1 6 searching by River Or Site c tii ete se Eee Oen rede e E seine es o Ra tede He Er ert is 13 Site Data Section C E 17 General Site mfOrmaton ie Ue 17 Spatial InformatiOn 18 Location Details re Pe 18 Site Transactions reed er quet tar dite dp 19 Site Visit Section B General 5 LR HER HU HEU CL Ama ERI cea 2
8. Rivers Database Version 3 2007 Framework Microsoft Internet Explorer CC fe x File Edit View Favorites Tools Help ay sak x Search sip Favorites A Re wj LJ a 33 Address http www softcraft co za Rivers Application DeFault aspx v Go Links gt m River s Administration Documentation s Query Master Logout The River Health Programme Version 3 0 Site photo View and edit the site photo details Delete Site River Photo date 05 06 1992 Comment Phtograph take from causeway Site HIBREE WITBR Photo Area Upstream Image path gif jpg 1 C photagraphs wWorkP Mb Limit Browse Screen 3 7 Uploading photographs to a site 4 RIVERS CLIENT Sections A B and C of the Rivers Client Figure 4 1 form the main body of the Rivers Database for the inclusion of information which both characterises a site and provides information for the assessment of the condition of a river at a particular site at a given time The field datasheets for the collection of river health data form the basis for the design of this component of the Rivers Database and a full description of some of the information included in the database has been taken from the associated site characterisation manual Dallas 2005 Sections A B and C vary with regard to the nature of information entered and the frequency of assessment as follows Type of information Frequen
9. enne enne nnne nre 29 g Biotopes Sampled IHAS Screen 4 24 30 hy Bish Screen 4 297 iniecit uter tete eee Mo ee 30 5 DATA TRANSFER BETWEEN RIVERS CLIENT AND RIVERS SERVER 35 5 1 Uploading data Screen 5 1 eere eee ecce esee eese sense seta setate tease esas te eo s tese stesse sena 35 5 2 Downloading data Screen 5 2 eee eee eee Leere ee esee eese aset easet eso etse seen 36 5 3 Assessor maintenance adding Assessors via Rivers Client Screen 5 3 36 5 4 SASS proficiency status Screen 5 3 eee e e eee eese te seta ease tete st ee stesse seas 36 5 5 SASS data import Screen 5 4 va theo eo eoo eade ceasseeecensoesssessgsuacebeatessanss 36 5 6 Updates Service Packs sicsisesicscecssssessessssesennsevescensdtesonsddescoosstesonsscdesdessttesonastiesgeedsesennsosesces 40 6 QUERYING THE DATABASE QUERY 40 6 1 Basic structure of the Query Master sccsscscssscssssscssscesccescscssscscesscesseesssesesesssecsseseoes 40 Primary Data Component Selection Screen 1 40 Secondary Data Component Combine Components Screen 6 2 40 Field Selection Scre en
10. Version 3 2 2733 17643 Screen 4 15 IHI instream components Owner Helen Dallas Freshwater Research Unit UCT Assessor Helen Dallas Instream Components Hydrology BaseFlows Freshwater Research Unit UCT Physico Chemical pH Confidence Rating Zero Flows Floods Hydrology Rating Bed Modification Metric Salts Nutrients Water Temperature Turbidity Oxygen Sediment Benthic Growth Bed Modification Rating Bank Modification Marginal Non M 3 Bank Modification Rating Logged on User Helen Dallas 26 Toxics P C Rating Longitudinal Lateral Rivers Database Version 3 2007 ays yaieas E Sabie 4 5 2004 6 26 2007 X3SABI BRAND 2007 06 26 15 12 Instream Modifications n 9 E Riparian Zone Modifications 19 lu a Ca Modifications 5 5 3 ti t E River gs ill 5s g a lu ti Instream Components Riparian Zone Component Result and Ownership Version 3 2 2733 17643 um LLL Helen Dallas Riparian Zone Hydrology Base Flow Low Flow Freshwater Research Unit UCT Helen Dallas Freshwater Research Unit UCT Bank Structure Bank Structure Modifications arginal Rating Non Marginal Rating 30 Substrate Exposure 30 4bx Zero Flow Invasive alien vegetation
11. e Click Refresh Pick Lists to download the most recent modifications to the administrative component e g change in SASS taxon sensitivity weightings chemical variable additions new land uses etc e Click Refresh Rivers to download the latest national rivers coverage All changes made to any river on the server since the last river download are retrieved and updated on the client database e Click Download site and site visit data for selected rivers to download data for specific river s It is important to limit the number of rivers selected especially when using slow connections such as dial up As a guide on broadband and network systems the Berg River and its tributaries or the Sabie River and its tributaries can be downloaded in one go The Limpopo River and its tributaries however cannot and the user must select a subset of rivers for download Expand the list by clicking on the and click the required rivers To select only the main river and not its tributaries use Shift Click e The system displays a report to the user indicating which data was downloaded successfully 5 3 Assessor maintenance adding Assessors via Rivers Client Screen 5 3 registered Users can edit Assessor data or add an Assessor i e the person who actually did the sampling via the Menu Bar by selecting File Assessor Then with the mouse positioned under the surname column right click and select Complete the deta
12. Helen Dallas Dwner Helen Dallas Overhanging Vegetation 2 Sparse poor 5 25 2 5 5292 1 Rate very poor lt 5 3 Moderate aood 25 75 Undercut Banks and Root Wads Water column Sampling Effort Mesh Size No of adults Length Depth Dimension No of juveniles Aber Amos long Dmos ni 10 Salt humpback largemouth 1 3 5 Logged on User Helen Dallas Version 3 0 2711 17771 Screen 4 25 Fish data 34 Rivers Database Version 3 2007 5 DATA TRANSFER BETWEEN RIVERS CLIENT AND RIVERS SERVER The data transfer functionality is available via the Rivers Client Since data transfer is a real time process via the internet a broadband connection is recommended It is essential to upload site and site visit data on a regular basis to ensure the national database remains up to date and to minimise the chance of local data loss in the event of a desktop crash Users with slower internet connections will also benefit by uploading data regularly since less data that will mean a faster upload process Immediately after logging onto the Rivers Client the User will be prompted to upload data changes made since the last upload if any It is strongly recommended that users follow this prompt and upload outstanding data NB If you experience problems uploading and downloading
13. In channel and bank modifications at the sites are listed or added from the drop down list The extent of their impact both upstream and downstream of the site is rated and the distance of each modification upstream or downstream specified Comments about the impact can be included in the free text box next to each modification Adding and saving modifications follow the same process as for land use c Channel Morphology Screen 4 12 Details pertaining to the channel type and cross section are captured in this section Channel type is selected from the drop down list If bedrock is selected then no Channel type details are required If either mixed bedrock and alluvial or alluvial with dominant type s are selected then Channel type details need to be captured by right clicking and selecting More than one substrate type may be selected The presence of each cross section feature is noted for both the left and right banks by clicking the appropriate box Hint If you prefer using the keyboard to capture data use Insert to add a new record type the first letter of the variable to be added Tab to move from one column to another repeat until all data are added 22 Rivers Database Version 3 2007 88 Sabie 6 21 2007 4bx E Sabie Site Code Site Description Longitudinal Zone Owner P t Sabie 3 x3S4B1 ANTHO B
14. e DWAF trace file import Update the river networks using trace files from DWAF e Pick lists Maintenance of the drop down lists in the database e Invertebrate taxa Maintenance of the list of the invertebrate taxa their associated groups and record of there inclusion in SASS4 and SASSS5 e Fish data Maintenance of the list of fish taxa e Users and organisations Maintenance of the list of all database users and their organisations Rivers Database Version 3 2007 Zi Framework Microsoft Internet Explorer mef Fie Edit View Favorites Tools AN Qe x Search Sf Favorites 2 i rel 2 Address http www softcraft co za Rivers Application Default aspx Go Links EFI The River Health Programme Version 3 0 m River Administration Documentation s Query Master Logout Rivers Use the list to view and manage rivers River Tributary Of Drainage Region a lein Sabie Sabie X Crocodile E River Bsabic Incomati Crocodile El sabie Tributary of Drainage region All regions v Added since Unvalidated 0 lt Prev 1 Next gt Screen 3 1 Checking for existing rivers on the Rivers Server Framework Microsoft Internet Explorer File Edit View Favorites Tools ay Qs T x yo Search She Favorites B M LJ a 33 Address http www softcraft co za Rivers Application Default aspx Go
15. sparse 3 common 4 abundant 5 entire The degree of embeddedness is also recorded using a drop down list Details of the methodology are given in Dallas 2005 e Invertebrate Biotopes Screen 4 22 General river make up is recorded using the drop down list Biotopes have been included at two levels namely SASS biotopes e g Stones In Current Stones Out Of Current Marginal Vegetation In Current Marginal Vegetation Out Of Current Aquatic Vegetation Gravel Sand and Silt mud clay and specific biotopes e g Riffle Run Boulder rapid Bedrock Chute Cascade Backwater Slackwater In Channel Pool Grasses Reeds Shrubs Sedges moss trailing grasses filamentous algae etc The abundance of each biotope is rated for each SASS and specific biotope Details of the methodology are given in Dallas 2005 To enter data select an abundance rating for each SASS biotope using the drop down list Select an abundance rating for specific biotopes by highlighting the SASS biotope and selecting the rating f Invertebrates Screen 4 23 Both SASS4 and SASS5 data may be viewed and added although the default version is SASS5 If SASS4 data needs to be captured the user may click this option Users must capture SASS data at the biotope level by selecting a biotope from the drop down list SIC SOOC MV AQV or G S M These are based on the accepted biotope groupings in SASS 5 see Dickens and Graham 2002 for more details To capture d
16. 20 40 Moderate Floods Large Floods Riparian Zone Hydrology Rating 2 5 Connectivity Modification Longitudinal Ptysico Chemical Erosion Channel Straightening Calculated Bank Modifications Marginal Lateral Connectivity Rating Logged on User Helen Dallas Screen 4 16 IHI Riparian Components auspices E 88 Sabie 4 5 2004 6 26 2007 Instream Modifications Riparian Zone Modifications River Seasonality BA 5 o 5 a il Instream Components Err Riparian Zone Component Result and Ownership Version 3 2 2733 17643 Bisina X3SABI BRAND 2007 06 26 15 12 User Non Marginal Bank Structure Rating Organisation a gt x Helen Dallas Freshwater Research Unit UCT Helen Dallas Result and Ownership Instream Habitat Integrity Percentage 87 Category B Riparian Zone Habitat Integrity Percentage 72 Category t IHI Ownership Owner Helen Dallas Assessor Helen Dallas Kate Rowntree Kate Snaddon Kululwa Mkosana Liz Day Margaret Kalule Sabiti Marie Watson Mark Chutter Mark Graham Logged on User Helen Dallas Screen 4 17 Results and Ownership 27 Freshwater Research Unit LICT Rivers Database Version 3 2007 Viewing and adding Site Visit data Section C Section C includes the follo
17. Bker Barbus kerstenii Peters 1868 Redspot Barb Cyprinidae Bkes Barbus kessleri Steindachner 1866 Gillbar Barb Cyprinidae Bkim Barbus kimberleyensis Gilchrist amp Thompson 1913 Largemouth Yellowfish Cyprinidae Blin Barbus lineomaculatus Boulenger 1903 Line Spotted Barb Cyprinidae Native Bmac Barbus macrotaenia Worthington 1933 Broadband Barb Cyprinidae Bman Barbus manicensis Pellegrin 1919 Yellow Barb Cyprinidae Bmar Barbus marequensis Smith 1841 Largescale Yellowfish Cyprinidae Native Bmat Barbus mattozi Guimaraes 1884 Papermouth Cyprinidae Native Bmio Barbus miolepis Boulenger 1902 Zig Zag Barb Cyprinidae 62 Rivers Database Version 3 2007 Code Scientific Name Common Name Family Status Bmot Barbus motebensis Steindachner 1894 Marico Barb Cyprinidae Native Bmul Barbus multilineatus Worthington 1933 Copperstripe Barb Cyprinidae Bnat Barbus natalensis Castelnau 1861 Scaly Cyprinidae Bnee Barbus neefi Greenwood 1962 Sidespot Barb Cyprinidae Native Bpal Barbus pallidus Smith 1841 Goldie Barb Cyprinidae Bpau Barbus paludinosus Peters 1852 Straightfin Barb Cyprinidae Bpoe Barbus poechii Steindachner 1911 Dashtail Barb Cyprinidae Bpol Barbus polylepis Boulenger 1907 Smallscale Yellowfish Cyprinidae Native Brad Barbus radiatus Peters 1853 Beira Barb Cyprinidae Native Bser Barbus serra Peters 1864 Saw
18. Helen Dallas Helen Dallas Helen Dallas Justine Ewart Smith Geordie Ractliffe Helen Dallas Helen Dallas Site Visit 2 1995 11 01 00 00 Owner Helen Dallas Version 3 0 2664 27407 Rivers Logged on User Administrator Screen 4 3 Adding a site in the Site List Site Code HIBREE CERES HIBREE WITBR 5 H1BREE SLANG HIBREE WYSERS H1BREE NEKKI E H4BREE LECHA HSBREE SECUN 3 H5BREE DREWB H4BREE MOORD HEBREE ABBEY H7BREE SWELL H7BREE NAPYK Site Description Near golf course below Ceres At roadbridge near Mitchells Pass road below Low flow bridge at Slanghoek tum of Ceres W Downstream of bridge south of Wysersdrift Upstream of bridge near resort Die Nekkies Below DWAF weir on Farm Le Chasseur nea Near weir on farm Secunda on road f Near low flow bridge at Drew At low flow bridge at Moordkuildrif u s of confluence with Riviersonderend at the Hidro sign immediately before Swellendam on t On farm Napyksmond on road to Cape Infanta Longitudinal Zone Upper foothill Upper foothill Upper foothill Lower foothill Lower foothill Lower foothill Lower foothill Lower foothill Lower foothill Lowland river Lowland river Lowland river Owner Helen Dallas Helen Dallas Helen Dallas Justine Ewart Smith Helen Dallas Helen Dallas Helen Dallas Helen Dallas Justine Ewart Smith Geordie Ractliffe Helen Dallas Helen Dallas
19. and number it sequentially 1 2 3 etc Hint Type 1 2 3 then highlight numbers and drag right hand corner of block to end of column to auto number entire column Select the entire block of data and using the menu Select Data Sort sort on abundance Then delete all the records that have no abundance Reselect block of data and sort on Order Check your data to ensure that it is correct Then delete the Order column e Check the data format e g 12 Jan 2007 Highlight the Sampling Date Column and select Format Cells select Custom from Category and scroll to dd mmm yy under Type Add an extra yy so that it reads dd mmm yyyy e Save your file in an appropriate directory as a csv file using the File Save As and selecting Save as Type CSV NB Limit the number of rows to Comma delimited Hint to check that date format is 1000 to speed up the import process correct open the file using Notepad which returns it as a text file e Click on Tools SASS Import e Browse to the SASS file required to be imported into the database e Once the file has been located click on Import Note this needs to be csv file which can be created and saved in Microsoft Excel e The results of the import will be shown on the screen e Jf errors are reported check using the Reference button This opens an excel spreadsheet with Owner Assessor SASS Biotope Taxon Name and Abundance information The user needs to check
20. CD to assist users in populating the spatial data Site Owners are also able to populate these fields using drop down lists e Drainage Region drainage region of current river e Political Region One of nine regions e Water Management Area DWAF s 19 water management areas e Ecoregion Level I One of 31 as identified in Kleynhans et al 2005 e Ecoregion Level II One of 135 as identified in Kleynhans et al 20072 e Secondary Catchment Code DWAF secondary drainage region e Quaternary Catchment Code DWAF quaternary drainage region e Water Chemistry Management Region One of seven as identified Day et al 1998 e Vegetation Type Based on Low and Rebelo s 1996 potential natural vegetation of South Africa Lesotho and Swaziland e Geological Type Based on Vegter s 1995 simplified lithostratigraphic units e Contour Range Altitude range within which site falls estimated from a 1 50 000 map e Source Distance Distance from source of river estimated from a 1 50 000 map or extracted from the table which is included as a table in the rivers coverage e Rainfall Region Season in which the majority of rain falls e Stream Order Order estimated of 1 50 000 map using the Strahler method DWAF Gauging Station the presence of a DWAF gauging station is indicated If present the greyed boxes become active and the DW AF Code and estimated distance upstream or downstream of the site is recorded c Location Details
21. Diedricks Gerhard Diedricks _ X3SABI LTPASS 4 5 2004 12 00 00 AM sicisooc CHIRONOMIDAE Gerhard Diedricks Gerhard Diedricks X3SABI LTPASS 4 5 2004 12 00 00 sicisooc SIMULIIDAE B Gerhard Diedricks Gerhard Diedricks X3SABI LTPASS 4 5 2004 12 00 00 AM sicisooc TIPULIDAE Gerhard Diedricks Gerhard Diedricks X3SABI LTPASS 4 5 2004 12 00 00 sicisooc ANCYLIDAE B Gerhard Diedricks Gerhard Diedricks BAETIDAE 2 SP 1 Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO Sass Import 2 CAENIDAE Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO A CERATOPOGONIDAE Gerhard Diedricks Gerhard Diedricks W Data imported successfully CHIRONOMIDAE B Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO LEPIDOSTOMATIDAE Gerhard Diedricks Gerhard Diedricks LEPTOCERIDAE B Gerhard Diedricks Gerhard Diedricks LIMNICHIDAE Gerhard Diedricks Gerhard Diedricks OLIGOCHAETA Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO 4 5 2004 12 00 00 AM GiSim PISULIIDAE B Gerhard Diedricks Gerhard Diedricks 4 5 2004 12 00 00 AM GiSim POTAMONAUTIDAE 1 Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO 4 5 2004 12 00 00 AM GiSimM SPHAERIIDAE Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO 4 5 2004 12 00 00 AM GISiM SYNLESTIDAE CHLOR B Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO 4 5 2004 12 00 00 AM G S M T
22. Gobiidae Nloz Neolebias lozii Winemiller amp Kelso Winemiller 199 Banded Neolebias Distichodontidae Ncap Nothobranchius sp Caprivi Killifish Aplocheilidae Nfur Nothobranchius furzeri Jubb 1971 Turquoise Killifish Aplocheilidae Nkaf Nothobranchius kafuensis Wildekamp amp Rosenstock 1 Kafue Killifish Aplocheilidae Nkuh Nothobranchius kuhntae Ahl 1926 Beira Killifish Aplocheilidae Nort Nothobranchius orthonotus Peters 1844 Spotted Killifish Aplocheilidae Native Nrac Nothobranchius rachovii Ahl 1926 Rainbow Killifish Aplocheilidae Native Ofer Omobranchus ferox Herre 1927 Gossamer Blenny Ms Blenniidae 66 Rivers Database Version 3 2007 Code Scientific Name Common Name Family Status Omyk Oncorhynchus mykiss Walbaum 1792 Rainbow Trout Ex Salmonidae Introduced Oper Opsaridium peringueyi Gilchrist amp Thompson 1913 Southern Barred Minnow Cyprinidae Native Otwe Opsaridium tweddleorum Dwarf Sanjika Cyprinidae Ozam Opsaridium zambezense Peters 1852 Barred Minnow Cyprinidae Omac Oreochromis Nyasalapia macrochir Boulenger 191 Greenhead Tilapia Cichlidae Oand Oreochromis andersonii Castelnau 1861 Threespot Tilapia Cichlidae Oaur Oreochromis aureus Steindachner 1864 Israeli Tilapia Ex Cichlidae Omor Oreochromis mortimeri Trewavas 1966 Kariba Tilapia Cichlidae Omos Oreochromis mossambicus Peter
23. Links The River Health Programme Version 3 0 m River s Administration s Documentation s Query Master Logout Saved successfully River View and edit the river details Validate Delete Tributary Of River Detail Tributaries Sites This river needs to be validated by the Rivers Administrator before related sites can be created Notify Rivers Adrninistrator River Name New River Tributary Of Berg Add Political Region Western Cape v Sort Order Drainage Region G Great Berg et al Screen 3 2 Creating a new river and notifying the Rivers Administrator to ensure river validation Rivers Database Version 3 2007 Framework Microsoft Internet Explorer File Edit View Favorites Tools Help Qe M JO search She Favortes B rel Address http www softcraft co za Rivers Application Default aspx Go Links The River Health Programme Version 3 0 River s Administration Documentation Query Master Logout River View and edit the river details Validate Delete Close Tributary of River Detail Tributaries Sites River Name Sabie Tributary Of Incomati Add Political Region Mpumalanga Sort Order 2 Drainage Region X Crocodile E Screen 3 3 Viewing details of a river
24. Screen 4 7 This is a descriptive form to facilitate future access to the site for biomonitors who may not have visited the site previously The form provides a text box for entering a relatively detailed description of how to find the site and whose land must be traversed to access the site Provision is made to indicate whether or not a permit is required where to obtain the permit whether or not a key is needed and where to obtain the key If the site is on a farm the name and farm registration code may be recorded Extracts from 1 50 000 topographical maps can also be used to indicate site location See Section 3 2 18 Rivers Database Version 3 2007 d Site Transaction read only Screen 4 8 The site transaction form is an inventory of all changes that are made to the information entered in Section A When a user changes information that was entered on a previous occasion in Section A the user is asked to confirm whether the change should be made If the user confirms these changes then the database automatically updates the Site Transaction form with these changes The following information is recorded on this form the field which has been changed the information that was initially recorded for that field the new information added to that field the date that the changes were made the user who is responsible for making the changes and the organisation to which the user is affiliated In this way a complete record is
25. Version 3 2007 Rivers ays yueas Ei E General Site Visit Information Water Chemistry Stream Dimensions X3SABI BRAND 1999 05 20 00 00 Helen Dallas Freshwater Research Unit UCT Christa Thirion Resource Quality Services DWAF Invertebrate Biotopes Summarised River Make Up SASS Biotopes Biotope Abundance Rating Stones in current SIC 4 Abundant Stones out of current SOOC Marginal vegetation unspecified Aquatic vegetation Substratum Composition Invertebrate Biotopes Invertebrates Fish Gravel 2 Sparse 2 Sparse 0 Absent 2 Sparse Sand Silt mud clay Version 3 0 2711 17771 Rivers Logged on User Helen Dallas 2 Sparse 4 Abundant 5 Entire Screen 4 22 SASS and specific biotopes Rond Biotopes Select a SASS Biotope to which specific Biotopes can be a Specific Biotope In channel ays E I User Organisation Owner Hermien Roux North West Province Nature Conservation General Site Visit Information HEI Water CI mistry Stream Dimensions Assessor Site Visit Level Biotope Level Hermien Roux Taxon Abundance Version 4 SASS Version 5 Biotope E 64 North West Province Nature Conservation Invertebrate D
26. current version The Rivers Server is available either via Internet Explorer Start Programs Rivers Database 2007 Rivers Server or click the desktop icon or via a window in the Rivers Client In the River Client open the Tools menu and select Rivers Server Check for existing rivers or creating a new river Screen 3 1 and 3 2 Open the Rivers Server and Login to the Rivers Server Open the River menu and click Rivers Rivers Database Version 3 2007 e Ensure the river does not already exist by using the Filter functionality to search for the river on the rivers server i e type the name of the river in the River box and click Search The river its parent and drainage region are returned e To view river details click on river name Hint For users with access to Geographical e Ifno matching rivers are returned click New Information Systems GIS it is useful to plot the site on the 1 500 000 rivers coverage to see where it lies in relation to e Enter the river details River name type in name e Assign the new river to a parent river by clicking on Add searching for the parent river using the filter EA existing rivers Sometimes your river name and search functionality and selecting the parent may different to the national name This river e Assign a Political Region and Drainage Region for the POLIS MARE CES Soh MONEE new river a
27. cylindricus Peters 1852 Redeye Labeo Cyprinidae Native Llun Labeo lunatus Jubb 1963 Upper Zambezi Labeo Cyprinidae Lmol Labeo molybdinus du Plessis 1963 Leaden Labeo Cyprinidae Native Lros Labeo rosae Steindachner 1894 Rednose Labeo Cyprinidae Native Lrub Labeo rubromaculatus Gilchrist amp Thompson 1913 Tugela Labeo Cyprinidae Lrud Labeo ruddi Boulenger 1907 Silver Labeo Cyprinidae Native Lsee Labeo seeberi Gilchrist amp Thompson 1911 Clanwilliam Sandfish Cyprinidae Lumb Labeo umbratus Smith 1841 Moggel Cyprinidae Native Lmac Dup Lepomis macrochirus Rafinesque 1819 Bluegill Sunfish Ex Centrarchidae Lrot Leptoglanis rotundiceps Hilgendorf 1905 Spotted Sand Catlet Amphiliidae Lcho Leptoglanis sp Chobe Sand Catlet Amphiliidae Lmio Limnothrissa miodon Boulenger 1906 Kapenta Ex Clupeidae Lfal Liza falcipinnis Valenciennes 1836 Sickle Fin Mullet Ms Mugilidae 65 Rivers Database Version 3 2007 Code Scientific Name Common Name Family Status Lmac Liza macrolepis Smith 1846 Large Scale Mullet Ms Mugilidae Introduced Lric Liza richardsonii Smith 1846 Southern Mullet Ms Mugilidae Larg Lutjanus argentimaculatus Forsskal 1775 River Snapper Ms Lutjanidae Mele Malapterurus electricus Gmelin 1789 Electric Catfish Malapteruridae Mmac Marcusenius macrolepidotus Pet
28. data or logging on to the Rivers Server after registering online you may get an error message similar to the following Proxy server HTTP 407 error This may be due to settings on your organisation s firewall blocking your internet connection to the Rivers Server Please contact your organisation s system administrator to enable the River url i e to allow data to be uploaded and downloaded from the Rivers website or contact the Rivers Administrator for support 5 1 Uploading data Screen 5 1 e Inthe Rivers Client open the Tools Data Transfer Utility menu and click Upload e Click Site and Site Visit Data e Select the Drainage Region in which your site s falls If you need to check it is on the first form of the Section A Hint If you are not sure what data is new and needs to be uploaded scroll through the drainage regions The system determines which sites and site visits have changed or been added to the system Data in each drainage region needs to be uploaded separately e The system validates the site and site visit data to determine suitability for uploading The user can only upload data for which the current user is the owner e The system displays a list of rivers and its related sites and site visits The user selects the river to be uploaded by clicking in the river s box e The user initiates the upload process for selected data e All new or modified entries in the Assessor table are aut
29. each search Search results either sites or rivers are displayed in alphabetical 12 Rivers Database Version 3 2007 order below the search criteria Selecting a river or site from the list results in the associated river and all its tributaries being loaded in a River Tree View The user can navigate through the river hierarchy and load any of the rivers including the parent of the original river into its own River Tree View The River Tree View allows any river in the hierarchy to be sorted in alphabetical or source to sea order Selecting a river in the River Tree View loads all the sites located on that river into a site list next to the River Tree View Under the site list a list of site visits linked to the selected site is displayed Selecting either site or site visit results in the associated date capture forms being displayed in a new tab Rivers Network Parent rivers and tributaries Section A e General site information e Spatial Information e Location details e Site transaction Assessed during initial site visit and checked during each subsequent site visit Assessed during each site visit Section B General Section B Index of Habitat Section C Condition of catchment Channel condition Channel morphology Integrity Instream modifications Riparian Zone modifications General Site Visit information Water chemistry Stream dimensions Substratum composition Invertebrate bioto
30. on Vegter 1995 giving Lithostratigraphic Unit and Principle Rock Types Lithostratigraphic Unit Principle Rock Types CPd Db BokkveldGrup Shale siltstone sandstone o O J r sandstone quartz porphyry basalt Lebowa Granite Suite Hornblende and biotite granites Gneiss granite metasediments iron formation calc silicates lava tuff volcaniclastic rocks Mn Namaqua Metamorphic Complex SON schist amphibolite charnockiti Quartizite conglomerate grit sandstone siltstone mudstone shale basalt trachy andesite Ms Soutpansberg Group And Blouberg Formation tuff diabase dykes sills eo Volop Group subgreywacke quartzite conglomerate shale Waterberg Group And Glentig Formation grit sandstone siltstone mudstone shale trachyte quartz porphyry diabase dykes and sills Wilgenhoutsdrif Group Greenstone phyllite quartzite 2 Cape Granite Suite Unspeciied Cape Granite Suite Kuboos George Woodville Plutons Gariep Complex Quartzite arkose dolomite diamictite phyllite schist gneiss adesite basalt tuff Gamtoos Formation Phyllite greywacke conglomerate sandstone limestone 55 Mw Waterberg Group And Glentig Formation Group And Glentig Formation Rivers Database Version 3 2007 eal Lithostratigraphic Unit Principle Rock Types Malmesbury Group Tygerberg Franschhoek Klipheuwel Shist phyllite phyllitic shale shale limestone sandstone greywacke cong
31. on the minus sign next to the appropriate river e Continue expanding each river in the hierarchy until the desired river has been found e Click a river to load a list of sites located on the river e Right click a river and select the desired sort order of the river and its tributaries Select either the Order by name order or Order by sequence which sorts the river and its tributaries either alphabetically or in the order of occurrence from source to sea along a parent river respectively e Right click the river and select Explore parent from the pop up menu to explore the parent of a given river in a new tab If the Explore parent option is grayed out a parent does not exist for the river Step 3 Add edit or delete a Site Screen 4 3 e Click the river in the River Tree View to view a list of sites on the river e Click a site to view a list of site visits associated with the site or right click and select View Edit from the context menu e Double click a site to load the site form to view edit the site information e Adda new site or delete a selected site by selecting Edit from the main menu and selecting Add or Delete or right click and select Add or Delete from the context menu The Delete option is only available to the site owner NB When adding a new site it is compulsory to add the Georeference latitude and longitude Site description and L
32. that can be used to log onto both the Rivers Server and Rivers Client The user has the option to change the password at any time via the Rivers Client To Login to the Rivers Server Internet connection required e Select Rivers Server Start Programs Rivers Database 2007 Rivers Server or click the desktop icon This will open Internet Explorer and display the Login page Alternatively access the Rivers Server via a window in the Rivers Client Open the Tools menu and select Rivers Server This will automatically Login to the Rivers Server To Login to the Rivers Client Internet connection NOT required e Start the Rivers Client e Enter the username and password and click OK To register as a new user Internet connection required Screens 2 1 to 2 4 e Start Rivers Server and complete and submit Save the online User registration form e Click Request System Access to send an email to the Rivers Administrator e The Rivers database administrator will verify the user details and assign appropriate access rights to the user The administrator will confirm the username and password that can be used to access both the Rivers Server via the internet and the Rivers Client on the desktop via e mail e Start the Rivers Client Start Programs Rivers Database 2007 Rivers Client or click the desktop icon For information on installing the Rivers Client please refer to Section 7 2 e Enter the username and pa
33. way as Starts With and Ends With with the exception that all records for a given field that contain a specified item or value will be returned For example if River Name Containing B is selected then all rivers and associated records that contain the letter in the name will be returned regardless of where in the name the letter occurs 6 4 Frequently asked questions Query Master Question I get a dialog box asking me if I want to connect or work offline when I open Query Master What must I do Answer Click the Connect button If you have a normal dialup internet account then your computer might attempt to dial out for an internet connection If this happens then click the cancel button LAN uses should not encounter this type of problem I clicked the Query Master icon my browser window opens Internet Explorer but it just seems to hang What might be the problem It could be that your web server Personal Web Server or IIS is not running or not working correctly Another problem could be that the File System Object is corrupt or not working or it could simply be that the installation went wrong and the link is not working Sometimes the pages seem to contain old data from other previously run queries What must I do to ensure that the query runs correctly Press Ctrl F5 to refresh the pages because your browser stores the pages and sometimes it is necessar
34. 0 002 0 5 B DISS Boron Dissolved mg l 0 002 0 5 BE Beryllium mg l 0 001 0 005 BE DISS Beryllium Dissolved mg l 0 001 0 005 BE H Beryllium Acid extractable mg l 0 001 0 005 B H Boron Acid extractable mg l 0 002 0 5 CA Calcium mg l 0 500 CaCO3 Alkalinity as Calcium Carbonate mg l 0 500 CD Cadmium mg l 0 001 0 15 CD DISS Cadmium Dissolved mg l 0 001 0 15 CD H Cadmium Acid extractable mg l 0 001 0 15 CL Chloride mg l 0 1000 CO Cobolt mg l 0 001 0 05 CO DISS Cobolt Dissolved mg l 0 001 0 05 CO H Cobolt Acid extractable mg l 0 001 0 05 COND Conductivity mS m 1 500 CR Chromium mg l 0 001 0 5 CR DISS Chromium Dissolved mg l 0 001 0 5 CR H Chromium Acid extractable mg l 0 001 0 5 CU Copper mg l 0 001 0 1 CU DISS Copper Dissolved mg l 0 001 0 1 CU H Copper Acid extractable mg l 0 001 0 1 DO Dissolved oxygen mg l 1 15 DOC Dissolved Organic Carbon mg l DOPER saturation of oxygen dissolved in the water 10 150 Faecal Coliforms E Coli F Flourine mg l 0 1 5 FE Iron mg l 0 0001 50 FE DISS Iron Dissolved mg l 0 0001 1 Iron Acid extractable mg l 0 0001 50 HG Mercury mg l 0 01 1 HG H Mercury Acid extractable mg l 0 01 1 K Potassium mg l 0 0001 100 KN Kjeldahl Nitrogen mg l 0 04 1 MG Magnesium mg l 0 1 150 MN Manganese mg l 0 001 20 MN DISS Manganese Dissolved mg l 0 001 20 MN H Manganese Acid extractable mg l 0 001 20 59 Rivers Database Version 3 2007
35. 1 Limited Local Logged on User Helen Dallas Screen 4 18 General Site Visit Information Rivers ays yueas 8 User Comments Organisation Helen Dallas Freshwater Research Unit UCT General Site Visit Information Water Chemistry Saal Stream Dimensions c ETE Substratum Composition Err Invertebrate Biotopes Err Invertebrates Version 3 0 2711 17771 Christa Thirion Water Chemistry Instruments in Fast Flow v Samples Collected Date Sent for Analysis Water Filtered Volume Filtered ml Other Preservation If no where Samples Frozen Resource Quality Services DWAF 6 21 2007 Mercury Chloride Institution Samples Sent 05 Water Turbidity Discoloured Water Chemistry Data Ownership Helen Dallas Owner Chemistry Details Description Calcium 3 00000 Helen Dallas Alkalinity as Calcium Carbonate 40 00000 Chloride 10 00000 Conductivity 11 80000 0 10000 1 Flourine es i Potassium Magnesium 5 00000 Sadium 5 00000 Logged on User Helen Dallas Screen 4 19 Water Chemistry 31 Rivers Database Version 3 2007 Rivers 5 Se ays yeas B General Site Visit Information Err W
36. 1 9512194 Gauteng Undo Row Edit Eckhardt Holger holgere parks sa 0137354227 Eckhardt Holger South African National Parks Kruger holgere parks sa co za 013 7354227 Mpumalanga s Jii SASS Validation Assessor ValidFrom Valid To Status Gerhard Diedricks 1 30 Quality Assured Gerhard Diedricks m 2000 12 31 2001 Quality Assured Gerhard Diedricks 1 1 1992 12 31 1999 Unknown Version 3 0 2711 17771 Logged on User Helen Dallas Screen 5 3 Assessor data and SASS Validation Status Rivers I sass Data Import 4bx a C HelenAllFiles RiversD base Data Gerhard Diedticks S Testlmport c Print 3 Cm m a Import Results Owner Assessor SiteCode _ SiteVisit SassBiotope TaxonName Abundance Gerhard Diedricks Gerhard Diedricks X3SABI LTPASS 4 5 2004 12 00 00 AM sicisooc BAETIDAE 2 SP B Gerhard Diedricks Gerhard Diedricks X3SABI LTPASS 4 5 2004 12 00 00 AM SIC SO0C CAENIDAE Gerhard Diedricks Gerhard Diedricks X3SABI LTPASS 4 5 2004 12 00 00 AM sicisooc TRICORYTHIDAE B Gerhard Diedricks Gerhard Diedricks X3SABLLTPASS 4 5 2004 12 00 00 AM sicisooc HYDROPSYCHIDAE 1 Gerhard Diedricks Gerhard Diedricks X3SABI LTPASS 4 5 2004 12 00 00 AM sicisooc ATHERICIDAE Gerhard Diedricks Gerhard Diedricks X3SABLLTPASS 4 5 2004 12 00 00 AM sicisooc BLEPHARICERIDAE B Gerhard
37. 2 Condition of Catchment 2 hue e HER Meere Ge eet eee eee eee 22 Channel and aude teal les 22 Channel Morphology x no pre Rer eet ete eee egt tette edie 22 Rivers Database Version 3 2007 Site Visit Section Index of Habitat Integrity 0 eese eene 25 Site Visit Section Gases ete or eoi D iic ec a e eR epe 28 General Site Visit Information ns secs ede dee e oen tede te ee Hee deiude 28 Water 28 Stream DIMENSIONS ireen toe paci e HE DEC eee a ete e et Pee 29 Substratum CoimposSIUOnD ae eee De Ep e ree eee i Mev dete oe tret ee det ed 29 Invertebrate B10topes ttp Rep e s 29 Invertebrates ento Hen In C Roe HU ra tee dt 29 Biotopes Sampled THAS oie ete een E cep e e tee EE HE E ne e Rr e e c eer dua de 30 DERE 30 Software and Hardware Requirements eese rennen nennen nennen tenete tnter 49 Support for Rivers Database Users neenon nne nennen nennen ener i 50 Systein ac6688 on E e e e ee S 3 Techical information iioi inei E ep RUE OR dee a Ue tinte 49 Uninstalling the Rivers application 49 Uploading site photographs r o iret ede e tette eee ee epe te et eene 7 Viewing and adding Site nein eee eene ten ate o teen edet bete ete Ee obe ette EE eet 17 Viewing and adding Site Visit To enne tenete nein 21 Sec
38. 5 51 Rivers Database Version 3 2007 Appendix 1 Glossary of terms used in this manual Navigational sequence Biomonitoring Criteria Data owner Data user Drop down list Ecological Reference Condition Free text box Geological type Hydrological type Parent river Quaternary catchment code Secondary catchment code Site level components Site visit components Longitudinal zone Tick boxes Vegetation type The hierarchical sequence of Parent Rivers their tributaries can be sorted either alphabetically or according to the sequence of occurrence from source to sea The navigational sequence is therefore the of the route to navigate to a site The systematic use of biological responses to evaluate primarily anthropogenic changes in the environment with the intent to use this information in a quality control programme Matthews et al 1982 The conditions that control which records to display in a query the words or values used to determine the data that appears in a data list The person responsible for either site or site visit information that is entered into the database The ownership of data is automatically assigned to the user who enters the data into the database Information can only be altered or changed when the user and owner are the same The person who is logged on to the Rivers Database according to a predetermined user name and password A predeter
39. 6 3 ead ae urb EAE ENE EEE 40 Define Filter Criteria Screen 6 4 and 6 5 6 ener nns 40 Display report Screen 6 0 HO etie eee oce e eodd 41 6 2 Step by step instructions on using the Query Master ccccsssscssssccsssccssssssssecsssescssees 41 Creatng anew 41 sass ceatseeneceseotecenssguacenoatesseess 46 6 4 Frequently asked questions Query Master ee 47 7 TECHNICAL INFORMATION e eeeeee eee ee stt ense ta sesso s staat 49 7 1 Software and Hardware Requirements eee ee eee cete ee ee ee ee eene 49 7 2 Installing the Rivers application eee eere ee eee eee ee eee eee sete 49 7 3 Uninstalling the Rivers application 4 eee ecce ee eres ee eren eene etta eee 49 7 4 User Support for the Rivers Database cene ecce eee eee eee eaae eate sette seta asse eaae 50 Reporting bugs or error messages srren eiir e E a EEEE 50
40. 69 Rivers Database Version 3 2007 Index Addseditior delete a Site itii 14 Add editor delete a Site 14 Adding Assessors via Rivers eee en retener nter ene 36 Change your passwords metto ed tete 3 CHECK FOF existlig eee ete tete 6 Creating a new e up redo e Edo etn 40 Creating a neW TIVE ei ee eae ee ea eel nee ceed I eee 6 Data ownership esee ee ae ee Ud ee ete tua e ee ge tea e a ee CERE eat 5 D tastransfet E aet oper eite P ee Cte o ei Pee a tea egeta a 35 Data Uploading eiie eee tere 35 Data Downloadimg scooter eee Al beatae eins 36 PYOCUMEN LATION re pde rax deine rupe update ects 8 48 Downloading Updates eei eet e dee tede de ne eese ee eee cd 39 Gira m CER 52 Importing SASS data ende eate eee ee etre ve pet 36 Installing the Rivers application eere eee eti en e degere 49 Loginto the Rivers lenti oen tt He Re e E ba e Lt Est rte S kes 3 the Rivers Server aee ete Sis eee e e LEE eas ce RR eae e CR a A eee 3 Managing Rivels i ei Ede e ett ep b ie Ene e e Ga ri e Ete aee Peace isque 6 Navigating the River Tree View iniit tse ice ie e e de Po i eni p PROS 12 14 Navigating to Sites and Site Visits eisimirce esteen nennen
41. 8 DOCUMENTATION err E EEA 50 9 REFERENCE SG cccccccsccsscccsecseeccsccsccceccsccseccenseneenccecsecseccssccseccusesscsecsensenccacsscseucesessecceseeseeese 50 Rivers Database Version 3 2007 LIST OF FIGURES Figure 2 1 Schematic representation of the Rivers Database Version 3 2007 architecture and data 2 Figure 4 1 Schematic representation of the various components included in the Rivers Database 2007 cR DR 13 LIST OF DATA VIEWING AND CAPTURE SCREENS Screen 2 1 Screen 2 2 Screen 2 3 Screen 2 4 Screen 3 1 Screen 3 2 Screen 3 3 Screen 3 4 Screen 3 5 Screen 3 6 Screen 3 7 Screen 4 1 Screen 4 2 Screen 4 3 Screen 4 4 Screen 4 5 Screen 4 6 Screen 4 7 Screen 4 8 Screen 4 9 Screen 4 10 Screen 4 11 Screen 4 12 Screen 4 13 Screen 4 14 Screen 4 15 Screen 4 16 Screen 4 17 Screen 4 18 Screen 4 19 Screen 4 20 Screen 4 21 Screen 4 22 Screen 4 23 Screen 4 24 Screen 4 25 Screen 5 1 Screen 5 2 Screen 5 3 Screen 5 4 Screen 6 1 Screen 6 2 Screen 6 4 Screen 6 5 Screen 6 6 The Rivers Database Login Screen 4 New Users Registration form User detail eee 4 New Users Registration form Experience 5 Registration successful Users request system access 5 Checking for existing rivers on the Rivers
42. 832 Silver Catfish Schilbeidae Native Syan Schilbe yangambianus Poll 1954 Yangambi Buttercatfish Schilbeidae Smah Schwetzochromis machadoi Poll 1967 Cunene Dwarf Bream Cichlidae Salt Serranochromis altus Winemiller amp Kelso Winemiller Humpback Largemouth Cichlidae Sang Serranochromis angusticeps Boulenger 1907 Thinface Largemouth Cichlidae Slon Serranochromis longimanus Boulenger 1911 Longfin Largemouth Cichlidae Smao Serranochromis macrocephalus Boulenger 1899 Purpleface Largemouth Cichlidae Smer Serranochromis meridianus Jubb 1967 Lowveld Largemouth Cichlidae Native Srob Serranochromis robustus jallae Boulenger 1896 Nembwe Cichlidae Srob_Dup Serranochromis robustus robustus Giinther 1896 Tsungwa Cichlidae Sthu Serranochromis thumbergi Castelnau 1861 Brownspot Largemouth Cichlidae Ssib Silhouettea sibayi Farquharson 1970 Sibayi Goby M Gobiidae Sken Stenogobius kenyae Smith 1959 Africa Rivergoby M Gobiidae Slei Strongylura leiura Bleeker 1851 Yellowfin Needlefish Ms Belonidae Sleo Synodontis leopardinus Pellegrin 1914 Leopard Squeaker Mochokidae Smac Synodontis macrostigma Boulenger 1911 Large Spot Squeaker Mochokidae Smar Synodontis macrostoma Skelton amp White 1990 Largemouth Squeaker Mochokidae Sneb Synodontis nebulosus Peters 1852 Cloudy Squeaker Mochokidae 68 Rivers Database Version 3 2007 Code Scientific Name Comm
43. 996 Server Download a gt x Download Control Panel Data ltem Result Eror Message tn Users and Assessors Successful None a Refresh picklist Pick lists Successful None 5 Rivers Successful None River Sabie Successful None Refresh rivers River Name Avinagamu Successful None River Name Hluvamaduba Successful None River Name Klein Sabie Successful None Download site and site visit data for selected rivers River Name Langspruit Successful None River Name Lubye Lubye Successful None Drainage region X Crocodile E v River Name Mac Mac Successful None River Name Mantsiyane Successful None Limit the number of rivers selected if you have a River Name Marite Successful None slow internet connection e g dial up None Refresh Data None Download Completed None B None D Crocodie E None E Goudstroom None H None DE Incomati N one a E Crocodile None w E None amp 0E Massintonto None a ME Sabie None MB Avinagamu River Name Shinkwene Successful None Hiuvamaduba River Name Xiharini Successful None leg Klein Sabie River Name Msuthulu Successful None River Name Musutlu Successful None MIE Langspruit River Name Mtshawu Successful None mE Lubye Lubye River Name Nyamondwa Successful None v Mac Mac River Name Masalahane Successful None Mantsiyane River Name Ngwenyameni Successful None River Name Benjani Successful None Riv
44. Framework Microsoft Internet Explorer BA Fie Edit View Favorites Tools AAG ps rem 2 5 a aS Address http www soFtcraft co za Rivers Application DeFault aspx AL ALT The River Health Programme Version 3 0 River s Administration Documentation Query Master s Logout River View and edit the river details Validate Delete Tributary Of River Detail Tributaries Sites Add and remove tributaries from the river Add Remove gy 5 13 oudstroom 15 abane 21 22 Langspruit Noord Sand 32 33 a venyameni bandweni bpe pepene pene pene ne je Screen 3 4 Viewing tributaries of a river 10 Rivers Database Version 3 2007 Framework Microsoft Internet Explorer mef Fie Edit View Favorites Tools Help AN Qs T x 2 5 Sie Favorites 3 m 2 LJ Address http www softcraft co za Rivers Application Default aspx STA The River Health Programme Version 3 0 m River Administration Documentation Query Master s Logout River View and edit the river details Validate Tributary River Detail Tributaries Sites Add and remove sites from the river RHP Site Code Longitudinal Zone Site Description ABI GROUB Mountain Headwater Strea G
45. H Downstream of Drie Heuwels weir Lower Foothill Quaternary Catch B Krom S GIBERG GOEDV Downstream of roadbridge at Goedverwacht near Gouda LowerFoohil zone B sera GIBERG HERMO Downstream of Hermon road bridge Lower Foothill L GIBERG LADYL Upstream of Lady Loch Bridge below Wellington Lower Foothill Site Owner Helen Dallas v E G1BERG PIKET Downstream of roadbridge near Piketberg N7 Lower Foothill 5 Kompaniies n 3 Site Code lj Koopmans River Search Type v Site Visit Owner ie E Canal 2005 02 16 10 00 Toni Belcher O Main Rivers Only B Unspecified 2003 10 27 03 30 Toni Belcher Al Rivers amp Bl Klein Berg 2003 08 28 11 40 Toni Belcher Bassegaaibosch lj Vier en Twintig DOSS OL Lee Tori Bicher Beah 3 1995 10 01 00 00 Helen Dallas 2 H i 8 1995 07 01 00 00 Helen Dallas m ae 1995 03 01 00 00 Helen Dallas i 994 11 01 00 00 Helen Dallas 1994 09 01 00 00 Helen Dallas B Moreesburasprut 1994 03 01 00 00 Helen Dallas E Unspecified 1994 02 01 00 00 Helen Dallas E 1993 12 01 00 00 Helen Dallas Bj Unspecified 1933 11 01 00 00 Helen Dallas 8 Boesmans E 1993 09 01 00 00 Helen Dallas BB Soutkloot 1993 02 01 00 00 Helen Dallas Sout mi 88 Unspecified Site search River Version 3 5 Logged on User Helen Dallas Citations To cite this manual Dallas H Molteno A Ewar
46. ISS Vanadium Dissolved mg l 0 002 0 1 V H Vanadium Acid extractable mg l 0 002 0 1 ZN Zinc mg l 0 003 1 5 ZN DISS Zinc Dissolved mg l 0 003 1 5 ZN H Zinc Acid extractable mg l 0 003 1 5 ZR Zirconium mg l 0 001 0 05 ZR DISS Zirconium Dissolved mg l 0 001 0 05 ZR H Zirconium Acid extractable mg l 0 001 0 05 60 Rivers Database Version 3 2007 Appendix 5 Fish codes Code Scientific Name Common Name Family Status Aben Anguilla bengalensis Eel Anguillidae Aber Acanthopagrus berda Forsskal 1775 Riverbream Ms Sparidae Native Ahil Amarginops hildae Bell Cross 1973 Hilda S Grunter Claroteidae Anaa Ambassis natalensis Gilchrist amp Thompson 1908 Slender Glassy Ms Ambassidae Apro Ambassis productus Guichenot 1866 Longspine Glassy Ms Ambassidae Alat Amphilius laticaudatus Skelton 1984 Broadtail Mountain Catfish Amphiliidae Anat Amphilius natalensis Boulenger 1917 Natal Mountain Catfish Amphiliidae Native Aura Amphilius uranoscopus Pfeffer 1889 Stargazer Mountain Catfish Amphiliidae Native Alab Anguilla bengalensis labiata Peters 1852 African Mottled Eel Anguillidae Abic Anguilla bicolor bicolor McClelland 1844 Shortfin Eel Anguillidae Amar Anguilla marmorata Quoy amp Gaimard 1824 Giant Mottled Eel Anguillidae Native Amos Anguilla mossambica Peters 1852 Longfin Eel Anguillidae Native Ahut Aplocheilichth
47. Please request system access from the Rivers Administrator If your organisation does not exist in the list please request the Rivers Administrator to add it Request system access First name New Surname User Organisation M Province Western Cape Telephone 021 5555555 Fax 0214444444 Email New User organisation org Postal Address anen Sesto E Cape Town Postal Code 8001 Regional Champion o User Name automatically generated Comment Screen 2 4 Registration successful Users request system access 2 5 Data ownership Data integrity is ensured via assigning data ownership to each component of the database The Owner of the Site or Site Visit data is defaulted to the logged in user This is often the person who located and sampled the site initially although it is also sometimes the regional champion The Assessor is the person who actually did the assessment they are often the same person When creating either a new site or site visit the logged in user becomes the owner of the site or site visit in question Data ownership is structured in a hierarchical manner as follows Rivers Database Version 3 2007 e Site the logged in user becomes the owner of the site created Only the Owner may edit or delete site data Site ownership may be reassigned by selecting another user from the drop down list in Section A After re assigning ownership the ori
48. RICORYTHIDAE 1 Gerhard Diedricks Gerhard Diedricks 4 5 2004 12 00 00 AM G SiM TURBELLARIA Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO 4 5 2004 12 00 00 AM G S M VELIIDAE MESOVELIID Gerhard Diedricks Gerhard Diedricks 4 5 2004 12 00 00 AM ANCYLIDAE 1 Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO 4 5 2004 12 00 00 AM MVIAQV BAETIDAE gt 2 SP Gerhard Diedricks Gerhard Diedricks 4 5 2004 12 00 00 AM BLEPHARICERIDAE 1 Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO 4 5 2004 12 00 00 AM MVrAQV CAENIDAE 1 Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO 4 5 2004 12 00 00 AM MVjAQV CHIRONOMIDAE Gerhard Diedricks Gerhard Diedricks 4 5 2004 12 00 00 DIXIDAE Gerhard Diedricks Gerhard Diedricks 4 5 2004 12 00 00 AM MWAQV HYDRAENIDAE il Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO 4 5 2004 12 00 00 AM MViAQV LEPIDOSTOMATIDAE B gens Diedricke Rerhard Niadrinke Y3GARILANTHO 12 nn nn ERIOCERA n a m a anas Al Version 3 2 2733 17643 Logged on User Helen Dallas Screen 5 4 SASS Data Importing 39 Rivers Database Version 3 2007 5 6 Updates Service Packs Service Packs are software patches that are released at ad hoc intervals and downloaded automatically by the Rivers Client These software patches permit users to up
49. Rivers Database Version 3 A User Manual H Dallas A Molteno J Ewart Smith and P Janssens The Freshwater Consulting Group in association with Soft Craft Systems For T i Bg DEPT OF WATER AFFAIRS amp FORESTRY WATER RESEARCH COMMISSION DEPT OF ENVIRONMENTAL AFFAIRS amp TOURISM 4 Search River Berg Drainage Region he Berg Site Code Site Description Longitudinal Zone River seo E GIBERG FORES Below forestry operations Mountain stream Waterfall GIBERG FRANS Mountain stream in Franschhoek Forestry Reserve Mountain stream Extended Search Criteria a Assegaaibosch GIBERG BRBM1 Above Theewaterskloof water transfer tunnel Skuiftaam Dam Upper Foothill E wolvekloot 3 G1BERG CECIL Cecilas Drift above Paarl Upper Foothill Region E Franschhoek GIBERG DEWDA Below Dewdale fish farm Skuifraam Dam Site 2 Upper Foothill WMA amp 8 Wemmershoek Upstream of Jim onflu ol a Olifants GIBERG SKUIF Site below proposed Skuifraam Dam in Franschhoek Forest Upper Foothill Ecorsgion zs EM Drakenstein 3 G1BERG THEE2 Below Theewaterskloof water transfer tunnel Upper Foothill Ecoregion II Kasteelkloof aj GIBERG BRIDG At Bridgetown Farm Lower Foothill B DWars GIBERG DALJO Daljasophat in Paarl below sewage treatment works Lower Foothill B Hugo 3 G1BERG DRIE
50. S on Vista Go to Start Control Panel Programs and Features and select Turn Windows features on or off on the bar on the left hand side In the screen that pops up check the Internet Information Services checkbox Expand the Internet Information Services node using the plus sign and check the Web Management Services and World Wide Web Service Finally make sure that ALL check boxes under these two options are checked e Insert the Rivers installation CD e The installation shield should begin automatically If it does not browse for setup exe on the CD e Click setup exe to start the installation process Depending on the software already installed on your computer you may be prompted to accept various licensing agreements from Microsoft Click Accept and follow the prompts if an error is displayed make sure IIS is installed as described above e n some cases it may be necessary restart the computer during the installation process The installation process will continue automatically following the reboot e Once the installation is complete the Rivers Client Rivers Server and Query Master shortcuts will be available on you desktop and in the Start menu Start Programs Rivers Database 2007 7 3 Uninstalling the Rivers application WARNING Uninstalling the Rivers client application will result in the loss of all data that has not been uploaded to the Rivers server e Navigate to Start Control Panel Add Remo
51. Sandspruit B wit Wabooms 8 Slanghoek Jan du Toits 8 Smalblaar E Bothaspruit Hartbees Holsloot 8 2 Nuy 8 Doring a Unspecified Bj Poeslenels ll vink Eg Willem Nels Hoops 8 Keisers Klaas HIBREE CERES HIBREE WITBR H1BREE SLANG HIBREE WYSERS H1BREE NEKKI H4BREE LECHA HSBREE SECUN 3 HSBREE DREWB H4BREE MOORD HBBREE ABBEY H7BREE SWELL 7 lt EU Near golf course below Ceres At roadbridge near Mitchells Pass road below Low flow bridge at Slanghoek tum of Ceres W Downstream of bridge south of Wysersdrift Upstream of bridge near resort Die Nekkies Below D WAF weir on Farm Le Chasseur nea Near DWAF weir on farm Secunda on road f Near low flow bridge at Drew At low flow bridge at Moordkuildrif u s of confluence with Riviersonderend at the Hidro sign immediately before Swellendam on t On farm Napyksmond on road to Cape Infanta Upper foothill Upper foothill Upper foothill Lower foothill Lower foothill Lower foothill Lower foothill Lower foothill Lower foothill Lowland river Lowland river Lowland river Site Visit 1995 11 01 00 00 Owner Helen Dallas DoR 4bx Breede Site Code Breede peas 8 Dwars 8 Titus lg wi Unspecified Hoeks Sandspruit 88 Wabooms H1JAND SOMER amp Doring Site De
52. ae Pbug Pseudobarbus burgi Boulenger 1911 Berg River Redfin Cyprinidae Pphl Pseudobarbus phlegethon Barnard 1938 Fiery Redfin Cyprinidae Pqua Pseudobarbus quathlambae Barnard 1938 Drakensberg Minnow Cyprinidae 67 Rivers Database Version 3 2007 Code Scientific Name Common Name Family Status Pten Pseudobarbus tenuis Barnard 1938 Slender Redfin Cyprinidae Pphi Pseudocrenilabrus philander Weber 1897 Southern Mouthbrooder Cichlidae Native Rdew Redigobius dewaali Weber 1897 Checked Goby M Gobiidae Rmau Rhabdalestes maunensis Fowler 1935 Slender Robber Characidae Stru Salmo trutta Linnaeus 1758 Brown Trout Ex Salmonidae Introduced Sfon Salvelinus fontinalis Mitchill 1815 Brook Charr Ex Salmonidae Sbai Sandelia bainsii Castelnau 1861 Eastern Cape Rocky Anabantidae Scap Sandelia capensis Cuvier 1831 Cape Kurper Anabantidae Scar Sargochromis carlottae Boulenger 1905 Rainbow Bream Cichlidae Scod Sargochromis codringtonii Boulenger 1908 Green Bream Cichlidae Scou Sargochromis coulteri Bell Cross 1975 Cunene Bream Cichlidae Sgia Sargochromis giardi Pellegrin 1903 Pink Bream Cichlidae Sgre Sargochromis greenwoodi Bell Cross 1975 Greenwood S Bream Cichlidae Smor Sargochromis mortimeri Bell Cross 1975 Mortimer S Bream Cichlidae Sint Schilbe intermedius R ppell 1
53. ai Formations Quartzite quartz sericite schist amphibolite Loskop And Wilge River Formations Pyroclastics lava quartzite conglomerate sandstone siltstone grit shale diabase sills Rashoop Granophyre And Lebowa Granite Suite Granophyre hornblende and biotite granites ngeluk Formation Together With Overlying Voelwater And AS Vo Ong 4 8 O ying Andesite dolomite jaspilite lava diamictite sandstone quartzite conglomerate Underlying Makganyeni And Gamagara Formations Pretoria Group Duitschland Penge And Langrant Quartzite shale conglomerate iron formation breccia diamicitite limestone dolomite and Formations where not shown separately as Vh a Rooiberg Group Rhyolite pyroclastics Rustenburg Layered Suite Bronzitite harzitite harzhurgite norite pyroxenite anorthotise gabbro diorite Vrw Rust Der Winter Formation Sandstone conglomerate rhyolite Pretoria And Chuniespoort Groups Quartzite shale dolomite 57 Campbell Group And Vryburg Formation Rivers Database Version 3 2007 Lithostratigraphic Unit Principle Rock Types Nelspruit Dalmein Hebron Halfway House Goudplaats And Unnamed Intrusives Granite granodiorite tonalite gneiss migmatite Barberton Sequence Sandstone shale conglomerate greywacke lava pyroclastic rocks Gravelotte Group Ultramafic mafic and acid lava tuff schist conglomerate quartzite Giyani Group Ultramafic and mafic lavas schist Kraaip
54. all rivers are returned excluding those associated with the Berg River Compare with the operator Not In This key is used when searching for more than one item For example if River Name In Berg Breede Olifants is selected then all records for these 3 rivers are returned Compare with the operator Equals This key is used to exclude several values or items For example if River Name not in Berg Breede Olifants is selected then all for all rivers are returned excluding those associated with these 3 rivers Compare with the operator Not Equals This key is used to return all records where the specified field has values greater than a specified value For example if Chem value Greater than 5 is selected then all records where the specified chemistry code has values greater than 5 will be returned This key is used to return all records where the specified field has values less than a specified value For example if Chem value than 5 is selected then all records where the specified chemistry code has values less than 5 will be returned This key is used to return all records where the specified field has values equal to or greater than a specified value For example if Chem value Greater Than Equal To 5 is selected then all records where the specified chemistry code has values equal to or greater than 5 will be return
55. an Group Chert iron formation jasilite schist lava Limpopo Mobile Belt Sand River Gneiss Beit Bridge Migmatite gneiss meta quartzite meta pelite marble calc silicate rocks amphibolite Complex Messina Suite Bulai Gneiss meta anorthosite serpentinite meta pyr ZRm Marydale Group Prieska And Doornfontein Subgroups Conglomerate subgreywacke lava tuff amphibolite iron formation biotite muscovite 8 Skalkseput Draghoender Intrusives granite granite gneiss Polgola Sequence Nsuze And Mozaan Groups Basalt andesite quartzite shale hornfels Pongola Sequence Nsuze And Mozaan Groups Basalt andesite quartzite shale hornfels rhyolite dacite gabbro granite Migmatite gneiss ultramafics amphibolite acid lava sedimentary rocks 58 Rivers Database Version 3 2007 Appendix 4 Water Chemistry codes giving the description units expected minimum and maximum values Chem Code Description Unit Minimum Maximum AL Aluminium concentration mg l 0 02 320 AL DISS Aluminium Dissolved mg l 0 02 0 5 AL H Aluminium Acid extractable mg l 0 009 350 AS Arsenic mg l 0 03 0 5 AS DISS Arsenic Dissolved mg l 0 03 0 5 AS H Arsenic Acid extractable mg l 0 03 0 5 B Boron mg l 0 002 0 5 BA Barium mg l 0 002 0 5 BA DISS Barium Dissolved mg l 0 002 0 5 BA H Barium Acid extractable mg l
56. and maximum values are shown as a guide for data entry and are used for Data integrity checking It is possible to add a value below or above the limit although the user will be prompted with the message The Chemistry value is outside the expected range do you still want to add data Please comment or correct the value To enter data position the cursor under the Description column right click and select type the first letter of the chemistry variable you want to add and scroll down until the correct variable is highlighted press tab twice to move the cursor to the value column and enter the value tab to comment field and add text if necessary Right click and the record Repeat process until all chemistry variables have been added Table data may be exported to excel by right clicking and selecting Export to Excel c Stream Dimensions Screen 4 20 Macro channel active channel and water surface widths left and right bank heights and average depths of available deep and shallow water biotopes are selected from the drop down list or added directly within each field or comments field Details of the methodology are given in Dallas 2005 d Substratum Composition Screen 4 21 The abundance of each substratum type bedrock boulder cobble pebble gravel sand and silt mud for the bed and bank is estimated using a rating scale using the following scale 0 absent 1 rare 2
57. ape Telephone 021 5555555 Fax 021 4444444 Email New User organisation org Postal Address 10 New Street Cape Town Postal Code 8001 Regional Champion 7 User automatically generated Password ETTET Confirm password eseese Comment Screen 2 2 New Users Registration form User detail Rivers Database Version 3 2007 UserCRUD Microsoft Internet Explorer File Edit View Favorites Tools ay Q x yo Search Favorites E iw LJ a 33 Address http www softcraft co zafRivers Application UserCRUD aspx B Go Links User Registration Complete the user details form to register Save Close User detail Experience Qualification Bachelor of Science degree Experience Experience with biomonitoring tools SASS 3 years FRAI 0 tj Care Other Physico chemistry monitoring geomorphological please specify Screen 2 3 New Users Registration form Experience component UserCRUD Microsoft Internet Explorer File Edit View Favorites Tools Help ay Qe x yo Search she Favortes 2 p jw a 3 Address http www softcraft co za Rivers Application UserCRUD aspx Links gt User Registration Complete the user details form to register Save Close User detail Experience Registration successful
58. ary over time The geomorphological zones of river channels based on channel gradient as defined by Rowntree amp Wadeson 1998 A box which is ticked when a positive action is recorded The potential natural vegetation of South Africa Lesotho and Swaziland according to Low and Rebelo 1996 52 Rivers Database Version 3 2007 Appendix 2 A step by step example of a query setting specific criteria Requirements Provide SASS scores ASPT scores and the Number of taxa for all site visits on all rivers which fall within secondary catchments B1 B2 and B3 where the pH is greater than 4 This query must reveal geo reference information so that the sites can be displayed in GIS Table A1 gives an indication of the data that should be returned in the final query output to satisfy these requirements Table Al The desired query output for the specific query outlined in this section RHP Secondary SASS Number 1 Sampling GIS GIS SASSA pH Site catchment Data ASPT of Date Longitude Latitude 3 Score Xe Values code code Version Families Once the Query Master has been opened the steps below are followed to extract the data required to meet the specifications outlined above for this example 1 Select the correct primary component In this example the Information Site Visit primary component is selected because it contains both site specific data i e the site code and s
59. ata position the mouse in Taxon column and right click mouse type the first letter of the taxon and scroll to the correct taxon Tab Tab to Abundance column and enter abundance 1 A B C or D Right click and Save to save record and continue until all taxa have been captured for the biotope Select next biotope and repeat the process To view and edit data at the Site level click Site Visit Level For taxa such as Baetidae and Hydropsychidae it may be necessary to modify the site level details as per Dickens and Graham 2002 The SASS Score Number of Taxa and ASPT are calculated automatically as are the Air Breather Scores Additional comments may be captured in the Comments field Data may be exported to excel by right clicking on SASS data and selecting Export to Excel 29 Rivers Database Version 3 2007 2 Biotopes Sampled IHAS Screen 4 24 The biotopes sampled at the site are recorded on this form It is based on the modified version of IHAS Invertebrate Habitat Assessment System documented in Dallas 2005 To capture data position the mouse under the Score column and select a value from the drop down list Hint to speed up the process enter the number then enter and you are automatically taken to the next criterion Continue until all criteria is scored h Fish Screen 4 25 The fish component has been developed by Kleynhans 2007 and details pertaining to the method are described
60. ata Ownership Owner Hermien Roux f i Warning Changing data at biotope level may affect data at site visit level Please review site visit data Group Taxon Sensitivity Weighting SASS 5 Abundance Substratum Composition Invertebrate Biotopes Invertebrates EPHEMEROPTERA BAETIDAE 2 SP E A EPHEMEROPTERA CAENIDAE E DDONATA GOMPHIDAE E ODONATA LIBELLULIDAE HEMIPTERA VELIIDAE MESOVELIIDAE DIPTERA CHIRONOMIDAE DIPTERA Additional Comment Version 3 5 Logged on User Helen Dallas SIMULIIDAE 5 SASS Score 37 No Families 8 ASPT 4 63 Air Breather Score Air Breather Families 1 Air Breather ASPT 5 00 Screen 4 23 Invertebrate Taxa 33 Rivers Database Version 3 2007 Rivers File SiteVisit i Lll General Site Visit Information Water Chemistry tl Stream Dimensions Substratum Composition Invertebrate Biotopes Invertebrates Biotopes Sampled IHAS Fish Window Sabie Elands 9 15 1999 6 21 2007 A2ELAN LINDL 2007 06 21 14 38 Biotopes Sampled Invertebrate Habitat Assessment Criterion Owner Helen Dalas Freshwater Research Unit UCT Assessor Helen Dallas Freshwater Research Unit UCT System HAS Total leng
61. ater Chemistry Substratum Composition Sabie 7 13 1999 PEE EAEG E 1999 07 13 10 30 Stream Dimensions Stream Dimensions Stream Dimension Water Surface Width Macro channel Width m Bank Height a Helen Dallas Freshwater Research Unit UCT Christa Thirion Resource Quality Services DWAF Width Category Bank Height Category Right Bank Height Left Bank Height 13 v Dominant Physical Biotope Type Invertebrate Biotopes 0 9 9 Invertebrates il 0 E Biotopes Sampled IHAS n tj E ish Dominant Physical Biotope Efe Shallow water habitat Deep water habitat 0 25 Cobble riffle 0 75 Pool Version 3 0 2711 17771 ays yeas E E Rivers Logged on User Helen Dallas Screen 4 20 Stream Dimensions User Organisation Helen Dallas Freshwater Research Unit UCT General Site Visit Information Water Chemistry E Stream Dimensions Substratum Composition Invertebrate Biotopes Christa Thirion Substratum Composition Embeddedness Material 0 25 0 Absent 2 Sparse 3 Common 3 Common 3 Common 2 Sparse Resource Quality Services DWAF Version 3 0 2711 17771 Logged on User Helen Dallas Screen 4 21 Substratum composition 32 Rivers Database
62. ative Cbif Chiloglanis bifurcus Jubb amp le Roux 1969 Incomati Suckermouth Or Rock Catlet Mochokidae Native Cema Chiloglanis emarginatus Jubb amp le Roux 1969 Pongolo Suckermouth Or Rock Catlet Mochokidae 63 Rivers Database Version 3 2007 Code Scientific Name Common Name Family Status Cfas Chiloglanis fasciatus Pellegrin 1936 Okavango Suckermouth Or Rock Catlet Mochokidae Cneu Chiloglanis neumanni Boulenger 1911 Neumann S Suckermouth Or Rock Catlet Mochokidae Cpar Chiloglanis paratus Crass 1960 Sawfin Suckermouth Or Rock Catlet Mochokidae Native Cpre Chiloglanis pretoriae van der Horst 1931 Shortspine Suckermouth Or Rock Catlet Mochokidae Native Cswi Chiloglanis swierstrai van der Horst 1931 Lowveld Suckermouth Or Rock Catlet Mochokidae Native Cpla Clariallabes platyprosopos Jubb 1964 Broadhead Catfish Clariidae Ccav Clarias cavernicola Trewavas 1936 Cave Catfish Clariidae Cgar Clarias gariepinus Burchell 1822 Sharptooth Catfish Clariidae Native Clio Clarias liocephalus Boulenger 1898 Smoothhead Catfish Clariidae Cnga Clarias ngamensis Castelnau 1861 Blunttooth Catfish Clariidae Csta Clarias stappersii Boulenger 1915 Blotched Catfish Clariidae Cthe Clarias theodorae Weber 1897 Snake Catfish Clariidae Csup Clinus superciliosus Linnaeus 1758 Super Klipfish Ms Clinidae Cwit Coptostoma
63. barbus wittei David amp Poll 1937 Upjaw Barb Cyprinidae Cmos Croilia mossambica Smith 1955 Burrowing Goby M Gobiidae Cide Ctenopharyngodon idella Valenciennes 1844 Grass Carp Ex Cyprinidae Introduced Cmul Ctenopoma multispine Peters 1844 Manyspined Climbing Perch Anabantidae Ccar Cyprinus carpio Linnaeus 1758 Carp Ex Cyprinidae Introduced Dmos Distichodus mossambicus Peters 1852 Nkupe Distichodontidae Dsch Distichodus schenga Peters 1852 Chessa Distichodontidae Efus Eleotris fusca Schneider 1801 Dusky Sleeper Ms Eleotridae Emel Eleotris melanosoma Bleeker 1852 Broadhead Sleeper Ms Eleotridae Evit Eleotris vittata Dum ril 1858 Striped Sleeper Ms Eleotridae Gzeb Galaxias zebratus Castelnau 1861 Cape Galaxias Galaxiidae Gaff Gambusia affinis Baird amp Girard 1853 Mosquitofish Ex Poeciliidae Introduced Gaes Gilchristella aestuaria Gilchrist 1913 Estuarine Round Herring Clupeidae Gcal Glossogobius callidus Smith 1937 River Goby M Gobiidae Native Ggiu Glossogobius giuris Hamilton Buchanan 1822 Tank Goby M Gobiidae Native Glep Gobionellus lepturus Pfaff 1933 Slender Goby Gobiidae Helo Hemichromis elongatus Guichenot 1859 Banded Jewelfish Cichlidae Hmac Hemigrammocharax machadoi Poll 1967 Dwarf Citharine Distichodontidae Hmul Hemigrammocharax multifasciatus Boulenger 1923 Multibar Citharine Distichodontidae 64 Rivers Database Version 3 2007
64. cription of the steps that should be followed to select data components and filter data These forms are Primary Data Component Selection Screen 6 1 Allows the selection of one of the primary data components that group primary data relevant to specific query requirements The Description field indicates the type of information that can be accessed by a specific component and the Data Category field indicates the source of the information within the Rivers Database Only one Primary Data Component is selected for a specific query Secondary Data Component Combine Components Screen 6 2 Allows the selection of additional Secondary Data Components to combine with the Primary Data Component previously selected on the Primary Component Screen Field Selection Screen 6 3 Contains a list of the available fields that can be used in a query for filtering and displaying Define Filter Criteria Screen 6 4 and 6 5 Allows the user to define criteria for filtering the data It includes a screen which permits the selection of values or items that are already in the database Data Components are units of data assembled by pre defined queries They can contain data from one or many tables within a database A Data Component is a chunk of raw data that can be filtered drilled in and queried on until the required results are obtained 40 Rivers Database Version 3 2007 Display report Screen 6 6 This displays the
65. cy of assessment Section A Site specific information Entered during or after the first site visit c Enter uring the first site visit checked an Section B Site visit information ered reassessed on each site visit Section C Site visit information Assessed during each site visit 4 1 Using the River Tree View to navigate to Sites and Site Visits The Rivers Client provides the user with an efficient mechanism to locate sites and site visit data This involves searching for either sites or rivers loading and navigating either up or down the River Tree View that is associated with the selected river site and selecting the required site and or site visit from the available lists Once the relevant site or site visit has been found the user can view and potentially edit depending on ownership the data for the selected site and or site visit The process always starts on one of the two search forms i e river or site search form The forms can be pinned always visible or unpinned forms available via tags on the left of the screen and automatically hidden when the user navigates off the form Common search criteria e g river name site name drainage region are provided by default as well as whether the river is a tributary or a main river not a tributary of any river Additional criteria e g water management area are available if a more refined search is required Search criteria are cleared after
66. date Rivers Client with the most recent structural functional and data changes without having to re install the entire Rivers Client If an internet connection is available when a client logs on the Rivers Client checks for new service packs and prompts the user to download the latest updates if available The service pack is then automatically downloaded and applied by the Rivers Client The user can also use the Menu Toolbar to check for Updates and download them Tools Check for Updates 6 QUERYING THE DATABASE QUERY MASTER The Query Master is an HTML application which allows the user to construct user defined queries by combining the available attributes fields of registered data components pre defined queries These can be sorted and filtered to control the data that is returned by the query The Query Master can be used to query the user s local copy of the Rivers Database or the national Rivers Database which would constitute the most up to date version of all data collected nationally and transferred to the national administrator The Query Master can therefore be accessed via the internet independently of the Rivers Database The Query Master is designed to filter the dataset using set criteria so that the raw data required can be copied to a spreadsheet such as MS Excel for further analyses 6 1 Basic structure of the Query Master The Query Master consists of five main screens each with a header that provides a des
67. ds that relate to catchment condition including land use channel condition and channel morphology Components of this section are assessed during the initial site visit and then checked and reassessed if necessary on subsequent site visits The information is therefore site visit specific i e the information is related to a specific sampling date Information from a previous site visit can be automatically populated in the new site visit by right clicking and selecting Generate from previous Section B General includes the following forms e Condition of Catchment e Channel Condition e Channel Morphology a Condition of Catchment Screen 4 10 This form includes features regarding the condition of the local catchment and land use within the catchment One or several land uses are selected from the drop down list right click and select Add and the extent of each within the riparian zone and beyond the riparian zone rated depending on the level of the impact The potential impact of each land use on river health is estimated A level of confidence is selected Any specific information about each entry can be included in the free text box titled Comments the form To save right click and select Save Further land uses may then be added Specific data may also be exported directly by right clicking on the relevant screen and selecting export to excel see screen 4 11 b Channel Condition Screen 4 11
68. econdary catchment and site visit specific data i e sampling date Click next This opens the Select Secondary Components form Select appropriate secondary components to combine with the Information Site Visit primary component The following secondary components are selected e SASS scores by Site Full data contains SASS scores ASPT and Number of families regardless of biotopes e Chemistry Values only contains the pH values Click next This opens the Available Field Selection screen Tick the fields that you would like to return in the final query or which may be required in the filtering process The fields are given for the primary component and each of the secondary components respectively The following fields are ticked a Primary component Information Site Visit e RHP Site code e Sampling date e GIS Latitude e GIS Longitude e Secondary Catchment Code b Secondary component Chem Values only e pH c Secondary component SASS scores by site full data e SASS Data Version e SASS Score 53 Rivers Database Version 3 2007 Number of Families ASPT Click next This opens the Define Filter Criteria screen 4 This example specifies that data for secondary catchments B1 B2 and B3 must be returned and that data for site visits where the pH is greater than 4 must be returned Therefore we must filter the Secondary Catchment and pH field
69. ed This key is used to return all records where the specified field has values equal to or less than a specified value For example if value Less Than Equal To 5 is selected then all records where the specified chemistry code has values equal to or less than 5 will be returned This key can be used to select all items that start with a specified item or value For example if River Name Starts With is selected then all rivers and associated records that start with the letter B will be returned Filtering can be number a string text or a single letter 46 Rivers Database Version 3 2007 Ends With Containing further refined by selecting more letters or values For example if River Name Starts With Brak is selected instead of selecting just B then all rivers and associated records that start with Brak will be returned This key can be used to select all items that end with a specified item or value For example if River Name Ends With E is selected then all rivers and associated records that end with the letter E will be returned Filtering can be further refined by selecting more letters or values For example if River Name Ends With tjie is selected instead of selecting just then all rivers and associated records that end with tjie will be returned This key works in the same
70. egion in which the site is located such as river Section A Desktop Spatial longitudinal zone political region WMA Ecoregion and Il Secondary catchment 1 to 1 Information Site Vegetation Type Geological Type etc enera Secondary General information regarding site location details such as Land Owner and contact Section A Location i 1 to 1 2 details General Information Site amp Geo Reference Seconda Geo reference data longitude and latitude coordinates in three different formats Erde Geo ar 1 to 1 Data Site lt lt Back Next gt gt Screen 6 2 Secondary Data Component Combine Components 43 Rivers Database Version 3 2007 Query Master Microsoft Internet Explorer File Edit View Favorites Tools Help Q n JO search Sg Favorites p rel 3 Address http fflocalhost querymaster SelectFields asp M Go Links gt m Query Master Field Selection Information Select the required fields for query output and filtering purposes Selection of all fields or clearing of the selection in all components is possible by clicking on Select All or Clear All Selection of all fields or clearing of the selection within a specific component is possible by clicking on Select All or Clear All Available Fields Selecta ClxAl Component Information Site Select All Clear All 5 RHP Site Code S
71. elow confluence of Sabie and Sand rivers amp nthoclysta KNP Leop Lower foothill Andrew Deacon E 3 294 Calcutta 294 Lower foothill Neels Kleynhans u E x3SABI CALOT Sabiehoek Calcutta 294 Lower foothill Johan Engelbrecht X3SABI CALO3 Madras 292 Pump station Lower foothill Mick Angliss ES E 5 Lower Sabie fish ladder at weir bridge Lower foothill Neels Kleynhans E X3SABI HAZYV Red Ridge Hazyview Lower foothill Johan Engelbrecht 5 X3SAB1 HOXAN Hoxane below roadbridge from R536 from KNP Lower foothill Andrew Deacon E s 35 1 ALIFE Site 5 Nwitimnhiri ower foothill Andrew Deacon fx foothill Andrew Deacon ler foothill Andrew Deacon ler foothill Andrew Deacon ler foothill Johan Engelbrecht ler foothill Johan Engelbrecht ler foothill Andrew Deacon ler foothill Johan Engelbrecht ie June 2007 C EN KCN MEE Helen Dallas 10 122 12 d3 745 75 316 17 18 19 20 BE 22 23 24 25 26 27 28 29 30 l 2 Si Gm 7 Today 6 21 2007 Version 3 0 2711 17771 Logged on User Helen Dallas Screen 4 9 Adding a new Site Visit M Assegaaibosch Berg Sabie 9 15 1999 x3sABI LUBYE 9 15 1999 4bx F X3SABI BRAND 1999 15 11 00 o 3 o Fi Condition of Catchment we Helen Dallas Freshwater Research Unit Christa Thirion Resource Quality Services DWAF Condition Local Catchment Channel Conditi
72. eneral Site Visit Rainfall Region Summary Primary Provides access to site data summarised per River and Longitudinal Zone River Network NIA Information User Primary Information on the contact details of registered users of the Rivers Database Administration Information JE Primary Data archived from previous Rivers Database e g geomorphology IHI macrophyte and algal cover Data HAM HAI RVI data Archived Data Screen 6 1 Primary Data Component Selection Query Master Microsoft Internet Explorer File Edit View Favorites Tools Help ay 1 A C YA O d seo deem O 8 2 JAMS Address http localhost querymaster SelectJoin asp _ _ Links Query Master N Women _ _ Select one or more of the Secondary Data Components to combine with the selected Primary Data Component then click Next Secondary Data Component Selection Combine Components If no secondary data components required click Proceed without combine Only one of the 1 to Many relationship components may be selected at any one time This is due to the nature of the relationships between the data in these components Primary Data Component Information Site Proceed without combine Component Name Category Description Data Category Combine Relationship Seconda Information that characterises the r
73. er Nhawavi Successful None G E River Name Nhlowa Successful None v ner River Name Makathlanyane Successful None Mhlambanyathi River Name Shimangwana Successful None Mnondozi River Noord Sand Successful None v Msuthulu River Name Mababababa Successful None Mtshawu River White Waters Successful None v Version 3 0 2711 17771 Logged on User Helen Dallas Screen 5 2 Data Downloading 38 Rivers Database Version 3 2007 Assessors 4 x a First Name Organisation Email Telephone Political Region Comment de Villiers Pierre devilliersp absamail co za 083 2362924 Deacon Andrew AndrewD sanparks org 1013 7354237 comment Deacon Andrew South African National Parks Kruger NP AndrewD sanparks org 013 7354237 Mpumalanga comment Dickens Chris DickensC Gukzn ac za 033 3411151 Dickens Chris Natural Resource Institute DickensC ukzn ac za 033 3411151 KwaZulu Natal Diedticks i Gerhard I gerherddmiweb co za 082 3372312 no comment ays yeas Ei E Gerhard gerhardd mweb co za Jt 312 National Dixon Paver Hugh 3cf dwat ntl kzntl gov za 031 3362700 Dixon Paver Hugh DWAF Kwazulu Natal 3ci dwaf ntl kantl gov za 091 3362700 KwaZulu N J du Toit Stephan sdt envir infodoor co za 021 9512194 M save du Toit Stephan Mogale City Local Municipality sdt envir infodoor co za 02
74. ers 1852 Bulldog Mormyridae Native Mcyp Megalops cyprinoides Broussonet 1782 Oxeye Tarpon Megalopidae Mbre Mesobola brevianalis Boulenger 1908 River Sardine Cyprinidae Native Macu Micralestes acutidens Peters 1852 Silver Robber Characidae Native Mint Micro Ctenopoma intermedium Pellegrin 1920 Blackspot Climbing Perch Anabantidae Mbra Microphis brachyurus Bleeker 1853 Opossum Pipefish M Syngnathidae Mflu Microphis fluviatilis Peters 1852 Freshwater Pipefish M Syngnathidae Mdol Micropterus dolomieu Lacep de 1802 Smallmouth Bass Ex Centrarchidae Introduced Mpun Micropterus punctulatus Rafinesque 1819 Spotted Bass Ex Centrarchidae Msal Micropterus salmoides Lacep de 1802 Largemouth Bass Ex Centrarchidae Introduced Marg Monodactylus argenteus Linnaeus 1758 Natal Moony Ms Monodactylidae Mfal Monodactylus falciformis Lacep de 1801 Cape Moony Ms Monodactylidae Mang Mormyrops anguilloides Linnaeus 1758 Cornish Jack Mormyridae Mlac Mormyrus lacerda Castelnau 1861 Western Bottlenose Mormyridae Mlon Mormyrus longirostris Peters 1852 Eastern Bottelnose Mormyridae Mcep Mugil cephalus Linnaeus 1758 Flathead Mullet M Mugilidae Mdur Mugilogobius durbanensis Barnard 1927 Durban Goby Gobiidae Mcap Myxus capensis Valenciennes 1836 Freshwater Mullet M Mugilidae Nmac Nannocharax macropterus Pellegrin 1925 Broadbarred Citharine Distichodontidae Nans Nematogobius ansorgii Boulenger 1910 Spotfin Goby Ms
75. ers or creating a new river Screen 3 1 and 3 2 sss 6 Viewing existing rivers tributaries and associated sites Screens 3 3 to 3 6 7 3 2 Site photographs Screen 3 7 eere eee eee ee eee eee ee eee sten aestas ette seta aset ease seen sete seen ases eaae 7 Fo upload site photographs 2 niit etn eR ee tee tcp Eb d e eet idee 8 3 3 Administration User Registration eee ee ecce eee eene eee seen sae setae setas eee taa 8 34 DocurnigutatloI ies dieser Uit ERO 8 3 5 Query Master Server Version eee e eee ee ee esee sete sean e esse seta se tete s 8 3 6 Rivers Administrative Sue SHY eu AUS epis neon URL Ur URN iU ENS 8 RIVERS CLIENT Eee 12 4 1 Using the River Tree View to navigate to Sites and Site Visits 12 Step 1 Searching by River or Site Screen 4 1 13 Step 2 Navigating the River Tree View Screen 4 2 sss 14 Step 3 Add edit or delete a Site Screen 4 3 14 Step 4 Add edit or delete a Site Visit Screen 4 4 14 4 2 Viewing and adding Site Visit data Section A sssscssssccsssscsssscs
76. ersion running on the internet The three primary components can be accessed via the Start Programs Rivers Database or via the appropriate shortcut installed on the desktop i e Rivers Server Rivers Client and Query Master A Data Transfer Utility is accessible via the Rivers Client enabling data to be transferred between the Rivers Server and Client The Rivers Database is available on CD from the Rivers Administrator or provincial champion or can be downloaded from the Rivers website The Rivers Administrator is responsible for maintaining components of the database including validating rivers updating pick lists invertebrate and fish lists and assigning rights to users For information on installing the Rivers Client please refer to Section 7 2 2 1 Rivers Server The River Server s primary role is to provide a real time centralized repository of data at a national level 1 Rivers Database Version 3 2007 It provides a web based interface to manage rivers users invertebrate and fish lists pick lists and site photographs Figure 2 1 The Rivers Server is accessible either through Internet Explorer or via a window in the Rivers Client application 2 2 Rivers Client The Rivers Client application is the primary data entry and viewing application for Site and Site Visit related data It provides a Data Transfer Utility that allows the Site and Site Visit data to be uploaded from your desktop laptop i e Local database to
77. etermination version 2 Joint Water Research Commission and Department of Water Affairs and Forestry report WRC Report No In Press 50 Rivers Database Version 3 2007 Low A B amp A G Rebelo 1996 Vegetation of South Africa Lesotho and Swaziland Dept Of Environmental Affairs amp Tourism Pretoria Matthews R A A L Buikema J Jr Cairns amp J H Rodgers 1982 Biological monitoring Part Receiving system functional methods relationships and indices Water Research 16 129 139 Reynoldson T B Norris V Resh E Day amp D M Rosenberg 1997 The reference condition a comparison of multimetric and multivariate approaches to assess water quality impairment using benthic macroinvertebrates J N Am Benthol Soc 16 4 833 852 Rowntree KM and RA Wadeson 1999 A hierarchical framework for categorising the geomorphology of selected South African rivers Final Report to the Water Research Commission Rowntree KM and RA Wadeson 2000 Field manual for channel classification and condition assessment National Aquatic Ecosystem Biomonitoring Programme Report Series No 13 Institute for Water Quality Studies Department of Water Affairs and Forestry Pretoria South Africa Vegter J R 1995 Geology map of South Africa with simplified lithostratigraphy for geohydrological use Simplified lithostratigraphy digitised by A Havenga Council for Geosciences 1994 Water Research Commission TT 74 9
78. etters or numbers or by clicking on the box that appears under Value This opens a list of all items values already entered into the database Select the required values or items that appear in the available fields box on the left of the screen Click the right arrow button or double click on these values or items to move them to the selected fields box on the right hand side of the screen Click done to return to the Define Filter Criteria e Click the Add Filter button add additional filters repeat the steps outlined above e To delete a filter click the corresponding Delete button e Click next to continue to the Display Report screen or back to return to the previous screen Note If filtering is done using River only those rivers that have sites on them will be returned If a river is not visible in the filter form it means that no data exists for that site In the Query Output Screen Screen 6 6 The final screen displays the query result as specified in the filtering criteria previously selected The query can be e saved by clicking the save query button available under file in the menu to the left of the screen and then accessed via the open query button at a later stage or e exported to Excel as a CSV file click Export to Excel csv under File in the menu to the left of the screen Hint it is better to select Save As rather than
79. fin Cyprinidae Btha Barbus thamalakanensis Fowler 1935 Thamalakane Barb Cyprinidae Btop Barbus toppini Boulenger 1916 East Coast Barb Cyprinidae Native Btre Barbus treurensis Groenewald 1958 Treur River Barb Cyprinidae Native Btrv Barbus trevelyani G nther 1877 Border Barb Cyprinidae Btri Barbus trimaculatus Peters 1852 Threespot Barb Cyprinidae Native Buni Barbus unitaeniatus G nther 1866 Longbeard Barb Cyprinidae Native Bviv Barbus viviparus Weber 1897 Bowstripe Barb Cyprinidae Native Bleb Batanga lebretonis Steindachner 1870 Deep Sleeper Ms Eleotridae Bimb Brycinus imberi Peters 1852 Imberi Characidae Native Blat Brycinus lateralis Boulenger 1900 Striped Robber Characidae Cfre Caecomastacembelus frenatus Boulenger 1901 Longtail Spinyeel Mastacembelidae Cshi Caecomastacembelus shiranus G nther 1896 Malawi Spinyeel Mastacembelidae Cvan Caecomastacembelus vanderwaali Skelton 1976 Ocellate Spinyeel Mastacembelidae Caur Carassius auratus Linnaeus 1758 Goldfish Ex Cyprinidae Ccar Dup Carcharhinus leucas Valenciennes 1839 Bull Shark M Carcharhinidae Cbre Chetia brevis Jubb 1968 Orange Fringed Largemouth Cichlidae Native Cfla Chetia flaviventris Trewavas 1961 Canary Kurper Cichlidae Native Cgra Chetia gracilis Greenwood 1984 Slender Happy Cichlidae Cwel Chetia welwitschi Boulenger 1898 Angolan Happy Cichlidae Cano Chiloglanis anoterus Crass 1960 Pennant Tail Suckermouth Or Rock Catlet Mochokidae N
80. following sections e Rivers Database 2007 General structure of the database explaining the concepts of the Rivers Server and Rivers Client and the responsibilities of each in terms of managing rivers sites and site visit data and transferring data between Rivers Client and Server System Access is described specifically How to register as a new user and login to the Rivers Server and Rivers Client Data Ownership is outlined e Rivers Server Description of the functionality in the Rivers Server and how to use it e Rivers Client Description of the functionality in the Rivers Client and how to use it e Data transfer between the Rivers Client and Rivers Server Description of the data transfer utility and SASS data import e Querying the Database Description of the Query Master for filtering data and querying the database local and server e Technical Information Hardware and software requirements installing the Rivers Client troubleshooting e Documentation Information about the relevant documents e References relevant documents e Index an index for locating specific tasks is provided 2 RIVERS DATABASE 2007 The Rivers Database consists of three primary components Figure 2 1 namely the Rivers Server web application running on the internet Rivers Client windows application running on a desktop and the Query Master application for extracting data a local version running on the desktop and a server v
81. ginal owner will no longer be able to edit or delete site data e Site Visit Section B General the logged in user becomes the owner of the Site Visit created Only the Owner may edit or delete this Site Visit data Site Visit ownership may be reassigned via the menu Toolbar as follows Select SiteVisit Edit Page Header Change Owner and or Assessor using the drop down lists The general site visit ownership also includes the following components in Section C General site visit information stream dimensions and substratum composition e Site Visit Section B Index of Habitat Integrity the logged in user becomes the owner of the Site Visit created Only the Owner may edit or delete this Site Visit data The Owner may reassign the Ownership and Assessor to another user assessor via the Results and Ownership form if appropriate Save change of ownership using the Rivers Toolbar SiteVisit Save e Site Visit Section C Water Chemistry the logged in user who created the Site Visit becomes the owner of the Site Visit Water Chemistry data Only the Owner may edit or delete this data The Site Visit Owner may reassign the Water Chemistry Ownership and Assessor to another user assessor using the drop down lists on the Water Chemistry form if appropriate Save change of ownership using the Rivers Toolbar SiteVisit Save e Site Visit Section C Invertebrates includes Invertebrate Biotopes and Biotopes Sampled HAS the logged
82. h for the river on which the site is situated e Select the river by clicking on the river in the list e Click on the Sites tab to view a list of sites on the river e Select the site by clicking on the RHP Site Code in the list Click on the Site photo s tab to view a list of photos for the site e Click New in the site photos tab e Enter the site photo details and select the path of the image to be uploaded and click the Save button e To view the image click the box and select View The image opens in a separate window e The image may be Saved Printed or Emailed Right click and select option 3 3 Administration User Registration Users may update their User detail and Experience using the forms provided 3 4 Documentation Users may download the Rivers Database Version 3 2007 user manual as a pdf file The Site Characterisation manual Dallas 2005 and other relevant pdf files are also provided 3 5 Query Master Server version The Rivers Server provides access to the server version of the Query Master providing views into the national rivers database This is useful to extract data on the national database that the user may not have downloaded onto the desktop version i e Rivers Client Details pertaining to the functionality of the Query Master are given in Section 6 of this manual 3 6 Rivers Administrative functions Rivers Administration functions are available to specific Users
83. he site visit e Canopy Cover extent of canopy cover open closed partially open e Impact on stream habitat rate of the impact on channel flow of coarse woody debris or any other obstruction Specify if the source is local or upstream and add additional comments in the text box b Water Chemistry Screen 4 19 General information pertaining to water chemistry such as sampling process details and information related to water condition is recorded and displayed Screen 24 It includes e Instruments in fast flow Were the meters positioned in the fastest flowing section of the stream e Samples collected Were samples collected e Date sent for Analysis What was the date when the samples were they sent for analysis e Water filtered Was the water sample filtered e Volume filtered Mention the volume in ml of the water sample e Samples frozen Was the water sample frozen e Other Preservation If not frozen which other method of preservation was utilised e Institution Samples Sent Name the testing institution the water sample was submitted to e Water Turbidity What is the turbidity of the water sample Select from a drop down menu whether the water was clear discoloured opaque or silty chemistry data for the site visit is given together with the standard units of measurement and values 28 Rivers Database Version 3 2007 NB Data should be converted to these standard units preceding data capture Minimum
84. i AN Qe T yo Search Sie Favorites B rel 33 Address http flocalhost querymaster DisplayReport asp Go Links gt Query Master Query Output RHP Water Site Owner River PII atitudeGIS LongitudeGis UN Politica Management Feoregion of Description Region 1 Code Area E1JAND Toni A Olifants Western Western Folded BRIDG Belcher Jan Dissel WC 32 173 18 9 At low water bridge near Clanwilliam town Cape Olifants Doorn Mountains E1NOOR Toni Olifants Road from Citrusdal to the East of Olifants River Western Western Folded OFFTA Belcher MERLE Els QVC EET upstream of the bridge above offtake point Cape ERLEBT Mountains E10LIF Toni Olifants Western Western Folded BOSCH Belcher WC 32 975 19 18389 Boschkloof Cape Olifants Doorn Mountains E10LIF Olifants Western Western Folded BULSH Liz Day NC 31 99111 18 79 About 1 km downstream ofthe Bulshoek Dam Cape Olifants Doorn Mountains E10LIF Toni Olifants z Western Western Folded 3 CITRU Belcher WC 32 58 18 Downstream of Citrusdal Cape Olifants Doorn Mountains E1OLIF Toni Olifants About 1 km downstream ofthe Clanwilliam Dam Western 7 Western Folded CLANW Belcher WC 32 1732 18 87083 tthe Clanwilliam road bridge Cape OlfantsiDoom Mountains E10LIF 2 Olifants At Grootfontein downstream ofthe confluence Western Western Folded 40 73288722 19 09444 i
85. ils of the Assessor and rightOclick and Save to save the record 5 4 SASS proficiency status Screen 5 3 This is an administrative function undertaken by the Rivers Administrator in the Rivers Client Normal users do not have rights to modify this Each User is given a validation rating according to their SASS proficiency testing for a specific time period Users are able to view the SASS proficiency validation for themselves and other users via the Rivers Client e Click on File Assessors e Click on the assessor to be viewed 5 5 SASS data import Screen 5 4 There are two steps to importing SASS data into the Rivers Client The first is to capture the data in Excel using the SASS Import Template the second is the import the file into the Rivers Client Follow the steps below to import SASS data Download the SASS Import Template from the Rivers Server Documentation e Save and open in Excel e Enter data into the template including Owner Assessor Site Code Sampling Date and abundance Copy fields as appropriate for each biotope and site visit NB The Site Code needs to exist before 36 Rivers Database Version 3 2007 SASS data can be imported Check on your Rivers Client for the correct Site Code Use the Reference spreadsheet to check details Once all data has been captured it is necessary to delete the blank lines i e where no abundance in given To do this add a temporary column called Order
86. in Kleynhans 2007 and Dallas 2005 Data related to fish habitat sampling effort and fish species caught are captured Data are captured for different velocity depth classes fast deep fast shallow slow deep and slow shallow Combinations of these are also available as well as Unspecific habitat where flow and depth classes where not distinguished during sampling e To capture fish habitat data select a Fish Habitat using the drop down list position the mouse in the Abundance rating column and either select from the drop down list or type the value between 0 and 4 hitting Enter after each cover type e To capture Velocity Depth Classes sampled and effort ensure that the correct Fish Habitat is selected position the mouse below Sampling method column right click the mouse and select Add Select the sampling method using the drop down list e g cast net electro shocker etc Use the Tab to move along the line to populate the other columns as described in the method Dallas 2005 When completed right click and Save record Repeat until all sampling methods have been captured for the Fish Habitat and repeat for all other Fish Habitats sampled e To capture Fish Species data ensure that the correct Fish Habitat is selected and Sampling method is highlighted Position the mouse below the Code column and right click and select Select the fish code b
87. in user who created the Site Visit becomes the owner of the Site Visit Invertebrate data Only the Owner may edit or delete this data The Site Visit Owner may reassign the Invertebrate Ownership and Assessor to another user assessor using the drop down lists on the Invertebrates form if appropriate Save change of ownership using the Rivers Toolbar SiteVisit Save e Site Visit Section C Fish the logged in user who created the Site Visit becomes the owner of the Site Visit Fish data Only the Owner may edit or delete this data The Site Visit Owner may reassign the Fish Ownership and Assessor to another user assessor using the drop down lists on the Invertebrates form if appropriate Save change of ownership using the Rivers Toolbar SiteVisit Save 3 RIVERS SERVER 3 1 River management Rivers and their tributaries are managed centrally on the Rivers Server Thus if a river does not exist on the Rivers Client it must be created on the Rivers Server and downloaded to the client It is important to do an extensive search for the river on both the Rivers Client AND Rivers Server before creating it to ensure duplicate rivers are not created on the system The Rivers Database 2007 currently contains a comprehensive network of rivers spanning all the major drainage regions at 1 500 000 resolution This data has been imported from the DWAF trace files Rivers created on previous versions of the Rivers Database have been consolidated into the
88. ip For instream riparian zone and catchment modifications Screen 4 13 the relevant modification or activity is selected from the drop down list by right clicking and selecting After allocating ratings the modification is saved by right clicking and selecting Save Fields in the River Type and Seasonality Screen 4 14 IHI Instream Components Screen 4 15 IHI Riparian Zone Components Screen 4 16 forms are given a rating and confidence level using the drop down lists On the Results and Ownership Screen 4 17 form the final percentage and category for Instream and Riparian Zone Habitat Integrity are captured Ownership or Assessor of the IHI data defaults to the logged in user but may be reassigned to another user using the drop down list if appropriate Right click Delete to delete record B Sabie 4 5 2004 6 26 2007 4bx X3SABI BRAND 2007 06 26 15 12 8 User Organisation 7 z Owner Helen Dallas Freshwater Research Unit UCT Assessor Helen Dallas Freshwater Research Unit LICT Instream Modifications E Instream Instream Overall Rating Site Rating Comment Upstream Rating Upstream Comment Riparian Zone T Modifications Abstraction run of river 1 Limited 2 Moderate Water pumps evident 2 Moderate Crossings low water 1 Limited 1 Limited Small size 0 None Catchment Inter basin transfers Modifications Introduced habitat modifiyi
89. ive Filters Field Name Operator Value Type Action S p Equals Western Cape String Delete Filter Political Region Options Null Conditions This option is set by default to allow Query Master to filter on NULL instead of blank values Field Name Operator Value Add SELECT FIELD Add Fitter lt lt Back Display Report Screen 6 4 Define filter Criteria 44 Rivers Database Version 3 2007 F Query Master Microsoft Internet Explorer Edit lew lelp M x JO Search She Favorites 2 B rel 3 Address http localhost querymaster SelectFilters asp Select Field Values Web Page Dialog Select field values to filter where field River In Define Filter Crit _Available Values _Selected Values Alexanderspruit Current Active Fil Eg as Refine search Assegaaibosch Political Re Bankspruit l Bath Baviaans Baviaanskloof Stream Baynespruit RS Beetgekraalspruit Bellingham Stream Options Null q Belvedere Creek Berg Biedou River Bietou Big Lotus Black Blauuwklippen Blesbokspruit Blinkwaterspruit MM Blystaanspruit Boesmans Number of records 397 Screen 6 5 Select Field values already in the Rivers Databa 3 Query Master Microsoft Internet Explorer File Edit View Favorites Tools Help s
90. kept of any changes that may be made to the site information Although the information included in Section A is site specific and therefore should not change over time it is important to allow changes to be made for example if land ownership changes or improved GPS technology allows more accurate geo referencing of a site This form is automatically updated and cannot be edited Rivers Ce Eile Site Tools Window E cese 4 gt gt 2 a E un General Site Information General Site Information bold fields are mandatory and must be completed Spatial Information Owner Helen Dallas RHP Site Code G2EERSJONKE _ Reference Site v i Y nen ject Si Ez Old Site Code Project Site Number 1 Location Details River Eerste T Tributary of ETT Conventional DMS GIS Decimal Degrees GPS Degrees amp Decimal Min Site Transaction C datum 1880 S aff oh o 5 34000000 58 4je 0000000 L wass4daumHBHS4 EO v EO 18933000 Eg 18 Other Sites within 500m Site Description Mountain stream in Jonkershoek State Forest Map Reference 3318DD Site Length m Longitudinal Zone Mountain stream v Altitude 380 Hydrological Present day Pe
91. le Suites Aderouke R Hugomond Lekkersmaak Mtlala Matok Moletsi Granite biotie muscovite granite diabase dolerite dykes Palmietfontein S Bothaville Formation Kameeldoorns Formation Ventersdorp Conglomerate sandstone shale Supergroup Ventersdorp Supergroup Klipriviersberg Zoetlief Amalia Andesite quartz porphyry dacite rhyolite trachyte ignimbrite tuff agglomerate 56 Rivers Database Version 3 2007 eas Lithostratigraphic Unit Principle Rock Types Molteno Bihor And Clarens Sandstone stiltstone mudstone shale intruded by dolerite dykes and sheets V Mpageni Meinhardskraal And Unnamed Intrusives Potassic biotite and leucocratic granites with north easterly trending diabase dolerite dykes Buffelsfontein Group Lava volcaniclastic rocks quartzite greywacke shale Dolomite dolomitic limestone chert shale siltstone quartzite andesite diabasedolerite dykes Groblersdal Group Dennilton And Bloempoort Formations Lava tuff schist gneiss slate shale quartzite Griquatown Group Mudstone iron formation riebeckite jasilite diabase dolerite dykes except where the latter is included with Malmani subgroup and Assen formation Lava Formation tuff quartzite shale conglomerate Vm Malmani Subgroup Assen And Black Reef Formations exept where the latter is included with Godwan formation and Wolkberg group Dolomite chert subordinate quartzite conglomerat Dagbreek Sultanaoord And Uitdra
92. ll cases data are either added directly by typing in the free text boxes or by selecting from the appropriate drop down list Some fields are compulsory indicated with an in the manual e Owner The owner of the site data often the Regional Champion e RHP Site Code A standardised unique site code is allocated to each site secondary Catchment code first four letters of river name first five letters of location farm name etc For example G1EERS JONKE is the Eerste River in the Jonkershoek Forestry Reserve A duplicate site code will not be accepted and will require the user to modify the site code by changing the location component of the code when adding a new site e Old Site Code Previous code s used for the site e Reference Site Ticked if the site is a reference site e Project Site Number Project specific site number for mapping purposes e River name of river assessed e Tributary of name of the parent of the current river This is important in cases where river names are common and rivers of the same name may occur in different catchments e Latitude and Longitude three different formats for longitude and latitude co ordinates are available in the database i e conventional format degree minutes seconds GPS format degrees and minutes seconds and GIS format decimal degrees Data may be entered in conventional GPS or GIS format by selecting the format using the appropriate radio button and entering the values in the ap
93. lomerate Formations Bridgetown Complex quartzite greenstone Natal Group Quartzitic sandstone shale arkose Table Mountain Group Quartizitic sandstone subordinate shale and tillite Mapumulo Group Mzimkulu Formation Gneiss granulite marble dolomite granulite onglomerate mudstone limestone amphibolite schist gneiss tonalite metamorphosed Tugela Mfongozi And Ntingwe Groups And Intrusives 5 j p 8 3 TP mafic and ultramafic rocks Van Rhynsdorp Group Sandstone shale siltstone limestone dolomite quartzite schist d Shale intruded by dolerite dykes and sheets shale sandstone intruded by dolerite dykes and sheets PTRu Undifferentiated Karoo Sequence Sandstone siltstone mudstone shale intruded by dolorite and includes patches of Letaba basalt north of the Soutpansberg IQ Fluvial Deposits Alluvium sand gravel E Houtrivier Salisbury Kop Mpuluzi Gaborone Harmony Biotite muscovite granite gneiss leucogranite migmatite potassic granite quartz Richtersveld Suite Granite porphyry biotite granite syenite Adelaide Subgroup Mudstone sandstone intruded by dolerite dykes and sheets And Cunning Moor Intrusives monzonite tonalite quartz porphyry Andesite quartz porhyry quartzite Rdw Dominion Group And Witwatersrand Supergroup Andesite quartz porhyry quartzite shale conglomerate Quartzite shale hornfels Rooiwater Complex Diorite gabbro V Vs Vv Mashashane And Mashishima
94. mined list of options for a text box which limits the user to select one of these text options This is the condition that is representative of a group of least impacted or minimally disturbed habitats organised by selected physical chemical and biological attributes Reynoldson et al 1997 It acts as a benchmark with which monitoring information can be compared thereby providing a means of estimating the degree of degradation or deviation from natural conditions A box which allows the user to type whatever text is desired within that box See drop down list for a comparison Simplified lithostratigraphic units as defined by Vegter 1995 Can be one of three types based on the occurrence of flowing water in the system i e perennial flows continuously all year round seasonal flows annually at a predictable time of year but ceases to flow for some time each year and ephemeral flows periodically every few years Dallas 2005 The central or common river into which all rivers within a catchment flow A code for each quaternary drainage region as classified for South Africa by DWAF A code for secondary drainage regions as classified for South Africa by DWAF All information which is specific to a site but does not vary over time i e information which is spatially defined rather then temporally defined All information which is specific to the date of collection of such information i e information about a site which may v
95. nd click the Save button Note the names or incorrect river name allocation Drainage region of the new river must match the Various coverages are provided on the drainage region of the parent river Rivers Database CD e Add the Sort Order if known by assigning a sort number one greater than the upstream tributary i e if the tributary joining the mainstem immediately upstream has a sort order of 5 assign your new tributary a sort order of 6 If the sort order is not known leave as blank e Notify Administrator of the creation of a new river NB Add the co ordinates of a site on the new river to assist validation e Unvalidated rivers remain red until they have been validated by the Rivers Administrator They can be searched for by selected Unvalidated in the filter box of the Rivers form e Once email verification is received download the river list to make the river available on the Rivers Client see Section 5 2 Download Data in the Rivers Client section of this document Viewing existing rivers tributaries and associated sites Screens 3 3 to 3 6 Open the Rivers Server and Login to the Rivers Server e Open the River menu and click Rivers e Use the Filter functionality to search for the river e Select the river by clicking on the river in the list e Click on Tributaries tab to view tributaries of the selected river e Click on Sites tab to view sites on the river e To got
96. ng viewing or editing Site Visit data for a specified site code and date When a site is selected from the list the site visits are listed in the Site Visit window To view or edit a site visit double click on the Site Visit to add a site visit right click and select Add a Site Visit Screen 4 9 For a new site a pop up form appears with a date and time field and Owner and Assessor drop down lists The default for both is the logged in user if different select using the list The Site Visit information form is then loaded by default into a new tab Each of the forms are available via a vertical toolbar on the left hand site of the form Screen 4 10 Each field is described briefly below and the reader is referred to the glossary or Dallas 2005 if additional clarification is required In all cases data are either added directly by typing in the free text boxes or by selecting from the appropriate drop down list Rating scales are used in many cases Rating Scale 0 None none in vicinity of site no discernible impact Limited limited to a few localities impact minimal 2 Moderate land use generally present impact noticeable 3 Extensive land use widespread impact significant small areas unaffected 4 Entire land use 100 in area impact significant 21 Rivers Database Version 3 2007 Viewing and adding Site Visit data Section General Section B General consists of forms that include fiel
97. ng fauna Runoff effluent Industries Runoff effluent Irrigation Runoff effluent Mining River Type and Instream Components Riparian Zone Component E Result and Ownership Version 3 2 2733 17643 Logged on User Helen Dallas Screen 4 13 Instream riparian zone and catchment modifications 25 Rivers Database Version 3 2007 ays yess 8 Instream Modifications Riparian Zone Modifications Err Catchment Modifications River Type and Seasonality Instream Components Riparian Zone omponent Result and Ownership mr Version 3 2 2733 17643 Screen 4 14 River t Rivers River Type and Seasonality Perennial Longitudinal Geomorphological Zone Width Change in Seasonality Large Floods X 3SABI BRAND 2007 06 26 15 12 que 0000 LLL Owner Helen Dalas Freshwater Research Unit UCT Helen Dallas Freshwater Research Unit UCT Yes O No Foothill 215 Change in Seasonality Freshes amp Moderate Floods Change in Seasonality Baseflows Logged on User Helen Dallas User and seasonalit Organisation ays upieac og Instream Riparian Zone Modifications Catchment Modifications River Type and Seasonality Instream Components 558 2 component Err Result and Ownership
98. nts can be selected at a time e Use the description field to guide the selection of the most appropriate Secondary Data Component e Should all the required fields be contained within the Primary Data Components then select the proceed without combine button to continue without combining any Secondary Data Components e f Secondary Data Components have been combined then click next to continue to the Field Selection screen or back to return to the previous screen In the Field Selection screen Screen 6 3 e Select the fields that are desired for filtering or querying These are listed according to the respective data components previously selected Select all and Clear all are used to select or clear all the displayed fields respectively Alternatively the individual fields can be selected by ticking the appropriate boxes e fno filtering of data is required then click Display report to return the query results In the Define Filter Criteria screen Screen 6 4 and 6 5 e Add the required filter s by following the steps below e Select a field from the Field Name drop down menu e Select the appropriate operator see section 6 3 for filtering the field from the Operator drop down menu 41 Rivers Database Version 3 2007 e Enter the value s or items for filtering from the Values column according to the operator that has been selected This can be achieved by simply typing in l
99. nu point to Pop up Blocker and then click Pop up Blocker Settings In the Address of Web site to allow box type the address or URL of the Web site you want to see pop ups from and then click Add 48 Rivers Database Version 3 2007 7 TECHNICAL INFORMATION 7 1 Software and Hardware Requirements Operating System preferably Windows 2000 or Windows XP with Service Pack 2 installed e Internet Information Server must be installed on Windows 2000 or Windows XP To install go to Control panel Add or Remove programs Add Remove Windows Components check the Internet Information Services checkbox and click Next The original windows setup CD may be required to complete this task e Memory minimum of 256 RAM e Software Microsoft Office 2000 or greater e Minimum Screen Resolution 1024 x 768 e Hard Drive 200MB free e Regional Settings Ensure that your short date format in Control Panel Regional Settings is set to display an acceptable date format e g dd mm yyyy 7 2 Installing the Rivers application IMPORTANT Before installing the Rivers application please ensure Internet Information Services 5 or greater is installed on your computer to check Start Settings Control Panel Add or Remove Programs Add Remove Windows Components If the Internet Information Services IIS checkbox is not checked check the box and click Next This will require the original windows installation CD To Install II
100. o a specific tributary click on the tributary name in the list Tributaries of the selected river and sites may be viewed e To navigate back to the parent river click on Tributary of in right hand corner of screen e To view details of a site click on the RHP Site Code Details include the Site Description Site Owner Longitudinal Zone GeoReference Lat Long and Location 3 2 Site photographs Screen 3 7 Photographs of the upstream downstream bank side views or specific features at the site can be uploaded to the Rivers Server In addition to the photo date and an optional comment the area or feature photographed is selected from a drop down list to maintain a record of user specific photographs Users may photographic material Only the Site Owner may delete photographs Site photographs are not maintained on the Rivers Client but are uploaded and viewed directly on the Rivers Server as gif or jpg files This upload process is independent of the Site and Site Visit data upload process that is available on the Rivers Client Users need to reduce the size of their photographs before uploading lt Imb Extracts of 1 50 000 topographical maps saved as jpg or gif files can also be uploaded Rivers Database Version 3 2007 To upload site photographs Open the Rivers Server and Login to the Rivers Server e Open the River menu and click Rivers e Use the Filtering functionality to searc
101. omatically uploaded to the server before site and site visit data are processed The system sends data one site at a time followed by the site visits for that site e The server receives and validates the data New sites are created and existing sites are updated e During the site upload if any site data fails during the upload to the server that site and the error is returned to be logged and displayed to the client Other sites continue to be uploaded During the site visit upload if any site visit data fails during the upload to the server that site visit and the error is returned to be logged and displayed to the client Other site visits continue to be uploaded If any data has been modified on the server the upload for the site fails and the user must download the site before re uploading the data e The systems displays a report to the user indicating which sites and site visits were uploaded successfully and which site and site visits returned errors Errors should be resolved before attempting to re upload the data 35 Rivers Database Version 3 2007 5 2 Downloading data Screen 5 2 This section describes the operations required to download river site site visit and assessor data Static data that has changed on the server since the last download event is also downloaded Assessor data is downloaded at each new upload session e In the Rivers Client open the Tools Data Transfer Utility menu and click Download
102. omponents reete terree ti e teet ee eens 27 Results and Ownership eate e Me ipee ien 27 General Site Visit Information essere nennen nennen 31 Wat r Chemistry uet rp nU ene EE ertt dede 31 Stream Dimensions cena eod Aan indiana iis ae 32 SUDStralUM COMPOSITION iier e Eee repre nette Ee Eb 32 SASS and specific DIOtopes ne ae tst e ene REL eot p 33 Invertebrate Taxa eee tti estne Oe e etie denen 33 Biotopes Sampled IHAS eiecit etienne tton etate 34 Fish ETE EEE EE E A E deua ors 34 Data Uploading teet ee a a aerate 38 Data Downloading 38 Assessor data and SASS Validation Status 39 SASS Data Importing reete e AE i MP nete A Ta eec iue 39 Primary Data Component Selection eese 43 Secondary Data Component Combine 43 Define filter Criteria iiie e ete eec P e eet eet ote eee 44 Select Field values already in the Rivers Database eee 45 Results of thie qUeEy ote e ence ER tete bo ee ee o eie eee Le 45 lil Rivers Database Version 3 2007 LIST OF APPENDICES Appendix 1 Appendix 2 Appendix 3 Appendix 4 Appendix 5 Glossary of terms used in this manual eee 52 A step by step exam
103. on Site Visit Land Use Ex Within Riparian Beyond Riparian Impact Rating Confidence Level Comments Chanriel Morphology Afforestation general 0 None 2 Moderate 3 Estensive LHE only Rural development 0 None 2 Moderate 3 Extensive Farm dwellings Wilderness area 3 Estensive 0 None 3 Extensive Left bank only Agriculture crops orchards etc vi j ensive RHB only orchard Alien vegetation infestation Aquaculture Bush clearing ploughing Conservation Construction Version 3 2 2733 17643 Logged on User Helen Dallas Screen 4 10 Condition of Catchment 23 Rivers Database Version 3 2007 I Rivers File SiteVisit Tools Window Assegaaibosch Berg Sabie 9 15 1999 X3SABI LUBYE 9 15 1999 X3SABI BRAND 1999 09 15 11 00 LLL Condition of Catchment we Helen Dallas Freshwater Research Unit UCT Christa Thirion Resource Quality Services DWAF Channel Condition ays queas Channel Condition In channel and Bank Modification Upstream Impac Upstream Distan Downstream Im Downstream Dis Comments Ctrl Enter Undo Row Edit Export to Excel Generate from Previous Version 3 2 2733 17643 Logged on User Helen Dallas Screen 4 11 Channel Condition EF Rivers File Sitevisit Tools Window Assegaaibosch Berg Sabie 9 15 1999 X3SABI LUBYE 9 15 1999 a g
104. on Name Family Status Snig Synodontis nigromaculatus Boulenger 1905 Spotted Squeaker Mochokidae Stha Synodontis thamalakanensis Fowler 1935 Bubblebarb Squeaker Mochokidae Svan Synodontis vanderwaali Skelton amp White 1990 Finetooth Squeaker Mochokidae Swoo Synodontis woosnami Boulenger 1911 Upper Zambezi Squeaker Mochokidae Szam Synodontis zambezensis Peters 1852 Brown Squeaker Mochokidae Native Talb Thoracochromis albolabris Trewavas amp Thys van den Thicklipped Happy Cichlidae Tbuy Thoracochromis buysi Penrith 1970 Namib Happy Cichlidae Tgui Tilapia guinasana Trewavas 1936 Otjikoto Tilapia Cichlidae Tren Tilapia rendalli Boulenger 1896 Redbreast Tilapia Cichlidae Native Truw Tilapia ruweti Poll amp Thys van den Audenaerde 19 Okavango Tilapia Cichlidae Tspa Tilapia sparrmanii Smith 1840 Banded Tilapia Cichlidae Native Ttin Tinca tinca Linnaeus 1758 Tench Ex Cyprinidae Ttri Trichogaster trichopterus Gourami Ex Anabantidae Valamugil cunnesius Valenciennes 1836 Longarm Mullet Ms Mugilidae Vnas Varicorhinus nasutus Gilchrist amp Thompson 1911 Shortsnout Chiselmouth Cyprinidae Vnel Varicorhinus nelspruitensis Gilchrist amp Thompson Incomati Chiselmouth Cyprinidae Native Vpun Varicorhinus pungweensis Jubb 1959 Pungwe Chiselmouth Cyprinidae Xhel Xiphophorus helleri Heckel 1848 Swordtail Ex Poeciliidae Introduced Xmac Xiphophorus maculatus Gunther 1866 Platy Ex Poeciliidae
105. ongitudinal Zone If these are not completed the site cannot be saved If the site is within 500m of an existing site the user is warned to check that it is indeed a new site This avoids unnecessary site duplication Step 4 Add edit or delete a Site Visit Screen 4 4 e Click a site in the site list to view a list of site visits associated with the site e Double click a site visit in the list to load the site visit form to view edit the site visit information e Adda new site visit or delete a selected site visit by selecting Edit from the main menu and selecting or Delete or right click and select Add or Delete from the context menu The Delete option is only available to the site visit owner 14 Rivers Database Version 3 2007 Rivers DER File Edit View Tools Window Search River Drainage Region River Extended Search Political Region WMA Ecoregion 1 Ecoregion II Secondary Catch Quaternary Catch Longitudinal Zone Site Owner Site Code River Search Type Main Rivers Only All Rivers H Breede Breede 4px Breede Site Code bree ria Search River Search Site 8 Kogmanskloof Version 3 0 2664 27407 Logged on User Administrator File Edit Breede Tools Helen Dallas Window g Breede Unspecified Hoeks B Dwars Titus Witels
106. pes Catchment modifications River Type and Seasonality IHI Instream components IHI Riparian Zone Invertebrates components Biotopes sampled IHI result and Ownership IHAS Fish Figure 4 1 Schematic representation of the various components included in the Rivers Database 2007 Step 1 Searching by River or Site Screen 4 1 e Click one of the tabs on the left border to open either the site or river search form The tabs will automatically retreat to the left hand margin when the mouse moves off the tab To prevent the tab from automatically minimising click the Pin icon at the top right corner of the search form The search form will then remain on the screen e Enter search criteria If required expand the Extended Search Criteria by clicking the down arrow to refine the search Choose whether to search only for main rivers rivers without tributaries using the radio buttons 13 Rivers Database Version 3 2007 e Click Find e Find the site or river in the list Double click on the selected site or river or right click and Explore on the pop up menu e Navigate through the River Tree View to find the river Step 2 Navigating the River Tree View Screen 4 2 e Once a river network has been loaded into the River Tree View click the plus icon to the left of the river name of a given parent river to expand the tributaries of that river To reverse the operation and contract the tributaries click
107. ple of a query setting specific criteria 53 Geological types based on Vegter 1995 giving Lithostratigraphic Unit and Principle Rock Types aiite hene e RE HUE Set coe RT 55 Water Chemistry codes giving the description units expected minimum and maximum val es eee e tele I e RT BR eL ree ER D eR 59 Code 5 den e d euer olere lastre da 61 70 Rivers Database Version 3 2007 1 INTRODUCTION The Rivers Database is the national data storage and management system developed for the River Health Programme RHP The RHP forms a key component of the National Aquatic Ecosystems Biomonitoring Programme NAEBP of the Department of Water Affairs amp Forestry DWAF This manual accompanies Rivers Database Version 3 0 which is currently distributed on CD or internet download broadband connection required The Rivers Database is a combination of a web based Rivers Server and desktop application Rivers Client which allows registered users to transfer data from one to the other via a data transfer utility RHP practitioners using the biomonitoring tools developed for RHP are encouraged to contribute their data to the national Rivers Database System access is controlled via compulsory user registration and site and or site visit ownership is based on their user name This manual has been written as a guide to users of the Rivers Database application It is divided into the
108. propriate fields Other formats are then calculated automatically and records are stored automatically e Other sites within 500m all other sites within 500m of the current site are listed automatically This is aimed at minimising site duplication and ensures the user is aware of other sites in close proximity e Site Description details of site location e g farm name road bridge village etc Map Reference either 1 250 000 or 1 50 000 17 Rivers Database Version 3 2007 e Longitudinal Zone longitudinal zone within which the site falls e Site Length length of river being assessed e Altitude altitude of the site e Hydrological Type natural and present day based on the following types perennial seasonal or ephemeral e Associated Systems important systems associated with the site or river e g wetlands or estuaries e Distance of associated system from the site e Associated System Name name of associated system e Additional Comment Any additional information that may be pertinent to the site that has not been included in the forms b Spatial Information Screen 4 6 Spatial data are populated intermittently via the Rivers Server To facilitate this all RHP sites are plotted in GIS and intersected against the various spatial covers such as political region WMA Ecoregion Geological type etc This task is undertaken by the Rivers Administrator GIS coverages are also provided on the Rivers Database
109. rbus andrewi Barnard 1937 Whitefish Cyprinidae Bann Barbus annectens Gilchrist amp Thompson 1917 Broadstriped Barb Cyprinidae Native Bano Barbus anoplus Weber 1897 Chubbyhead Barb Cyprinidae Native Barg Barbus argenteus Giinther 1868 Rosefin Barb Cyprinidae Native Batk Barbus atkinsoni Bailey 1969 Dash Dot Barb Cyprinidae Bbar Barbus barnardi Jubb 1965 Blackback Barb Cyprinidae Bbao Barbus barotseensis Pellegrin 1920 Barotse Barb Cyprinidae Bbel Barbus bellcrossi Jubb 1964 Gorgeous Barb Cyprinidae Bbif Barbus bifrenatus Fowler 1935 Hyphen Barb Cyprinidae Native Bbre Barbus breviceps Trewavas 1936 Shorthead Barb Cyprinidae Native Bbrv Barbus brevidorsalis Boulenger 1915 Dwarf Barb Cyprinidae Bbri Barbus brevipinnis Jubb 1966 Shortfin Barb Cyprinidae Beal Barbus calidus Barnard 1938 Clanwilliam Redfin Cyprinidae Bcap Barbus capensis Smith 1841 Clanwilliam Yellowfish Cyprinidae Bcho Barbus choloensis Norman 1925 Silver Barb Cyprinidae Bcod Barbus codringtonii Boulenger 1908 Upper Zambezi Yellowfish Cyprinidae Bdor Barbus dorsolineatus Trewavas 1936 Topstripe Barb Cyprinidae Beru Barbus erubescens Skelton 1974 Twee River Redfin Cyprinidae Beut Barbus eutaenia Boulenger 1904 Orangefin Barb Cyprinidae Native Bfas Barbus fasciolatus Giinther 1868 Red Barb Cyprinidae Bgur Barbus gurneyi G nther 1868 Redtail Barb Cyprinidae Bhaa Barbus haasianus David 1936 Sicklefin Barb Cyprinidae Bhos Barbus hospes Barnard 1938 Namaqua Barb Cyprinidae
110. rennial M Associated Systems Distance Associated System Name Additional Comment Version 3 5 Logged on User Helen Dallas Screen 4 5 Toolbar providing access to forms in Section and General Site Information 19 Rivers Database Version 3 2007 Eg cese G2eeRs 30NKe 4d x M MA G2EERS JONKE S General Site we Helen Dallas Freshwater Research Unit UCT Information Spatial Information Spatial Infomation Drainage Region G Great Berg et al Political Region Western Cape Water Management Area Berg Bio Region Fynbos E Ecoregion Southem Folded Mountains Ecoregion Il 19 04 1 Secondary Catchment G2 Quaternary Catchment G22F Location Details Water Chem Management Southern and Western Coast Vegetation Type Mountain Fynbos Geological 051 Sie Tlansaeti n Contour Range From 380 400 Source Distance mJ 2 00 Rainfull Region Seasonal Winter Stream Order 2 DWAF Gauging Station Distance Upstream DWAF Code Distance Doan Version 3 0 2711 17771 Logged on User Helen Dallas Screen 4 6 Spatial Information Bresde 1 5 2000 01 15 m E O o O General Site wer Justine Ewart Smith Freshwater Consulting group Information E Location Details dany tpaeas
111. results of the query These screens can be accessed via the Menu bar on the left of each screen under Go to with the same names The full Menu bar pops out when the cursor is moved over the bar Additional guidance and descriptions of the process may be viewed by clicking on the icon next to the various headings 6 2 Step by step instructions on using the Query Master The Query Master may be accessed within Rivers Client by e using the Rivers Toolbar by selecting Rivers Functions Query Database or e via Windows by selecting Start Programs Rivers Database 2007 Query Master or via the Shortcut created on the desktop Creating a new query In the Primary Data Component Selection screen Screen 6 1 e Select one of the five pre defined Primary Data Components that contain the primary fields that are relevant to a specific query For example to return data relevant to a site only with no requirements for site visit data select Information Site e Use the description field to guide the selection of the most appropriate Primary Data Component e Click on Next to proceed to the Secondary Data Components Combine Components screen In the Secondary Data Components Combine Components screen Screen 6 2 e Select one or more Secondary Data Components Note Because of the nature of the relationships between data in different tables only one of the one to many relationship compone
112. rouberg on KLF Ceylon plantation ABI BEHSF Mountain stream w Horseshoe Falls ABI HSFALL Mountain stream Above Horseshoe Falls and sawmill ABI LTPA Mountain eam Long Tom Pass ar Whiskeyspruit 8 ABI AANDE Upper Foothill Aan de Vliet ABI AMILL Upper Foothill GFP ABI BRAMD Upper Foothill At Branc confluence of Sabane and Mac Mac R 8 ABI CASTL Upper Foothill Castle Rock X3SABI FRANK Upper Foothill At Frankfort safcol E x3SABI LUNSK Upper Foothill Lunsklip on KLF Frankfort Save Screen 3 5 Viewing sites on a river the longitudinal zone and a description are provided Framework Microsoft Internet Explorer Sek File Edit View Favorites Tools Help ay X x JO search Favorites B T a x Address http www aspx Links gt The River Health Programme Version 3 0 m River s Administration Documentation s Query Master s Logout Site View and edit the site details Site Detail Site Photo s RHP Site Code X3SABI LUBYE Description At confluence with Lubye lubye KNP Site Owner Andrew Deacon Longitudinal Zone Lower Foothill GeoReference Lat 25 5 94 Long 31 153 16 Location At confluence with Lubye lubye River in Kruger Park Screen 3 6 Viewing site details 11
113. s 1852 Mozambique Tilapia Cichlidae Native Onil Oreochromis niloticus Linnaeus 1758 Nile Tilapia Ex Cichlidae Opla Oreochromis placidus Trewavas 1941 Black Tilapia Cichlidae Oshi Oreochromis shiranus Boulenger 1896 Shire Tilapia Cichlidae Psil Pandaka silvana Barnard 1943 Dwarfgoby Ms Gobiidae Pfor Parakneria fortuita Penrith 1973 Cubango Kneria Kneriidae Pmos Parakneria mossambica Jubb amp Bell Cross 1974 Gorongoza Kneria Kneriidae Pjac Paramormyrops jacksoni Poll 1967 Ghost Stonebasher Mormyridae Pnga Parauchenoglanis ngamensis Boulenger 1911 Zambezi Grunter Claroteidae Pflu Perca fluviatilis Linnaeus 1758 European Perch Ex Percidae Pcat Petrocephalus catostoma Giinther 1866 Churchill Mormyridae Native Pcau Phalloceros caudimaculatus Hensel 1868 Spottail Mosquitofish Ex Poeciliidae Pacu Pharyngochromis acuticeps Steindachner 1866 Zambezi Bream Cichlidae Pret Poecilia reticulata Peters 1859 Guppy Ex Poeciliidae Pcas Pollimyrus castelnaui Boulenger 1911 Dwarf Stonebasher Mormyridae Pmic Pristis microdon Latham 1794 Smalltooth Sawfish M Pristidae Pamp Protopterus amphibius Peters 1844 East Coast Lungfish Protopteridae Pann Protopterus annectens brieni Poll 1961 Lungfish Protopteridae Pafe Pseudobarbus afer Peters 1864 Eastern Cape Redfin Cyprinidae Pasp Pseudobarbus asper Boulenger 1911 Smallscale Redfin Cyprinidae Pbur Pseudobarbus burchelli Smith 1841 Burchell S Redfin Cyprinid
114. s To add the appropriate filters Select Secondary Catchment from the drop down list under Field Name Then select In from the drop down list available under operators Click on the box that appears under Value This opens a list of all secondary catchment codes already entered into the database Select B2 and that appear in the available fields box on the left of the screen Click the right arrow button or double click on these items to move them to the selected fields box on the right hand side of the screen Click done to return to the Define Filter Criteria once all the codes have been selected Click Add Filter Once the filter has been added select from the drop list under Field Then select greater than from the drop down list available under operators Type in the number 4 in the box under Value Click Add Filter 5 Click Display Report This opens a screen that displays the results of the query or the query report The final query output should be similar to the structure indicated in Table A1 6 To export the data into MS Excel move mouse over Menu bar and click Export to excel csv and Save the file giving it a suitable name You can then open the file in MS Excel and analysed it further 54 Rivers Database Version 3 2007 Appendix 3 Geological types based
115. s H F 2005 River Health Programme Site characterisation field manual and field data sheets National Biomonitoring Programme Report Series No 18 Institute for Water Quality Studies Department of Water Affairs and Forestry Pretoria Day J A Dallas amp Wackernagel 1998 Delineation of management regions for South African rivers based on water chemistry Aquatic Ecosystem Health and Management 1 183 197 Dickens C amp Graham M 2002 The South African Scoring System SASS Version 5 Rapid bioassessment methods for Rivers South African Journal of Aquatic Science Vol 27 Kleynhans CJ Thirion C and Moolman J 2005 A level I River Ecoregion classification system for South Africa Lesotho and Swaziland Report no N 0000 00 REQ0104 Resource Quality Services Department of Water Affairs and Forestry Pretoria South Africa Kleynhans CJ Thirion C Moolman J and Gaulana L 2007 A level II River Ecoregion classification system for South Africa Lesotho and Swaziland Report no N 0000 00 REQxxxx Resource Quality Services Department of Water Affairs and Forestry Pretoria South Africa Kleynhans CJ Graham M Louw MD 2007b Module G Index of Habitat Integrity Manual for EcoStatus Determination version 2 Joint Water Research Commission and Department of Water Affairs and Forestry report In press Kleynhans CJ 2007 Module D Fish Response Assessment Index in River EcoClassification Manual for EcoStatus D
116. scription Alongside vineyards on the farm Somersu Longitudinal Zone Owner Upper foothill Justine Ewart Smith 2000 01 15 12 30 Owner Justine Ewart Smith Unspecified 8 Gg Poeslenels 8 vink Nets 8 Hoops E Keisers Klaas Voogs Koamanskloot Version 3 0 2664 27407 Logged on User Administrator Screen 4 2 Sorting the rivers in the tree view 15 Rivers Database Version 3 2007 Rivers File Edt View Tool Window Breede Breede a Breede yures S E Site Code H1BREE CERES 3 H1BREE WITBR H1BREE SLANG 5 1 H4BREE LECHA HSBREE SECUN E HSBREE DREWB H4BREE MOORD E HBBREE ABBEY H7BREE SWELL 3 7 3 HIBREE WYSERS Site Description Near golf course below Ceres At roadbridge near Mitchells Pass road below Downstream of bridge south of u s of confluence with Riviersonderend at the Hidro sign immediately before Swellendam on t On farm Napyksmond on road to Cape Infanta Low flow bridge at Slanghoek tum of Ceres W Longitudinal Zone Upper foothill Upper foothill Upper foothill Lower foothill Lower foothill Lower foothill Lower foothill Lower foothill Lower foothill Lowland river Lowland river Lowland river 4 Owner Helen Dallas Helen Dallas Helen Dallas Justine Ewart Smith Helen Dallas
117. ssccssssssssscsssesssseceees 17 a General Site information Screen 4 5 enne enne 17 b Spatial Information Screen 4 6 32 enne 18 c Location Details Screen 4 7 18 d Site Transaction read only Screen 4 8 nene 19 4 3 Viewing and adding Site Visit data Sections B and C 1 ccssccsssscsssscssssscsssssssescsscsscees 21 Viewing and adding Site Visit data Section B General eee 22 a Condition of Catchment Screen 4 10 eene 22 b Channel Condition Screen 4 11 enne ener enne 22 c Channel Morphology Screen 4 12 sse ener enne 22 Viewing and adding Site Visit data Section B Index of Habitat Integrity 25 Viewing and adding Site Visit data Section 28 1 Rivers Database Version 3 2007 a General Site Visit Information Screen 4 18 sess 28 b Water Chemistry Screen 4 19 28 c Stream Dimensions Screen 4 20 ener nennen nes 29 d Substratum Composition Screen 4 21 eere enne 29 e Invertebrate Biotopes Screen 4 22 enne 29 f Invertebrates Screen 4 23
118. ssword and click e Follow the prompts on the screen to refresh your username and password from the Server and Login to the Rivers Client for the first time To change your password Internet connection required e Start the Rivers Client Open the File menu and select Change Password e Enter and confirm the new password e Click Submit to update the password on both the Rivers Server and Client Rivers Database Version 3 2007 Microsoft Internet Explorer File Edit View Favorites Tools Help AN il Qm O DAD Ds yr O 2 2 a ADs 1 Address http www softcraft co za Rivers Application Login aspx ReturnUrl 2FRivers 2FDefault aspx Links gt X ATALIAH p The River Health Programme Version 3 0 Login Enter your username and password Username Password Click here to register as a new user Screen 2 1 The Rivers Database Login Screen UD Microsoft Internet Explorer Fie Edit View Favorites Tools Help ay Om DAO Ds frome e 2 2 a ADs Address http www softcraft co za Rivers Application UserCRUD aspx Links gt z User Registration Complete the user details form to register User detail Experience First name New Surname User Organisation CapeNature E Province Western C
119. t x X3SABI BRAND 1999 09 1 A User Organisation E Condition of Catchment wner Helen Dallas Freshwater Research Unit UCT Assessor Christa Thirion Resource Quality Services DWAF Channel Morphology Channel Type Alluvial with dominant type s Channel Condition Channel Type Details Channel Type Details Channel Morphology Cross Sectional Feature Present Right Present Left High terrace rarely inundated Terrace infrequently inundated Flood Bench inundated by annual flood Island vegetation Secondary or lateral channel Flood plain inundated by annual flood Hillslope abutting onto active channel Version 3 2 2733 17643 Logged on User Helen Dallas Screen 4 12 Channel Morphology 24 Rivers Database Version 3 2007 Viewing and adding Site Visit data Section B Index of Habitat Integrity The Index of Habitat integrity is based on the recent version Kleynhans et al 2007b developed as module G of the river ecoclassification manual for ecostatus determination Version 2 Details are available via the RHP website www csir co za rhp Section B Index of Habitat integrity includes the following forms e Instream Modifications e Riparian Zone Modifications e Catchment Modifications e River Type and Seasonality e Instream Components e Riparian Zone Components e Results and Ownersh
120. t Smith J amp Janssens P 2007 Rivers Database Version 3 User Manual Report for the Department of Water Affairs and Forestry River Health Programme Prepared by The Freshwater Consulting Group in association with Soft Craft Systems 71pp To cite data in the Rivers Database Reference the data by listing the owners of the data Site or Site Visit data in the following manner DWAF 2007 Rivers Database Data Owners List data owners Rivers Database Version 3 2007 1 2 TABLE OF CONTENTS 1 RIVERS DATABASE 2007 tastes status sta stato se tastes sone tastes sesso seta sesso seta ao 1 Bike SOEVOE RO erat Ue Suet E EX 1 2 2 7 Rivers 0i 2 2 3 Query Master Server and Client cce e eee e eee e sees sesto sesto sete s tese stesse seen ae 2 IA BESA AE 1 1 OE VU E o AE E 3 To Login to the Rivers Server Internet connection required eese 3 To Login to the Rivers Client Internet connection NOT required ees 3 To register as a new user Internet connection required Screens 2 1 to 2 4 3 To change your password Internet connection required eese 3 PE SEMU PIPERIS ETT TEES DEDE DI 5 RIVERS SERVER e 6 3 1 RE 6 Check for existing riv
121. th of white water Total length of submerged stones in curent Number of separate SIC areas kicked Average stone size s kicked Amount of stone surface clear Protocol time spent actually kicking SIC s Length of marginal vegetation sampled Amount of aquatic vegetation algae sampled Marginal vegetation sampled in or out of current Type of vegetation Stones out of current SOOC sampled Sand sampled in minutes Gravel sampled in minutes Bedrock sampled Algal presence c wm eo 2omwm2lmwioimimimwumxom 4bx Version 3 0 2711 17771 Logged on User Helen Dallas Screen 4 24 Biotopes Sampled IHAS E Rivers File Sitevisit Tools ays upieac og General Site Visit Information il Water Chemistry Ell Stream Dimensions Substratum Composition Invertebrate Biotopes Invertebrates Biotopes Sampled Fish Sabie Elands 9 15 1999 Elands 6 22 2004 9 2 1997 6 21 2007 Window A2ELAN DOORN 2007 06 21 15 05 User Organisation a gt x Owner Helen Dallas Freshwater Research Unit UCT Assessor Helen Dallas Fish Habitat Velocity Depth Classes and Cover Present Fish Habitat Deep Abundance Rating i Aquatic Macrophytes 1 Rare very poor lt 5 Freshwater Research Unit UCT Fish Data Ownership
122. that the reference information matches the data in their import file as it is critical that all the fields match exactly or the import will fail The Column headers on the import form should also match those in the user spreadsheet exactly e Note the owner of the site visit is derived from the logged in user e Please be patient when importing a large amount of data as the import takes some time NB It is critical to specify the date format in Excel as Day Month Year i e 01 Jan 2007 This ensures that the imported date is correct in the Rivers application To change the date format highlight the column select Format Cells scroll to Custom from the category and type dd mmm yyyy in the Type field 37 Rivers Database Version 3 2007 Server Upload Upload Control Panel f Upload assesso f 8 u m v Site and site visit data Drainage region G GreatBergetal connection dial Limit the number of rivers selected if you have a slow internet Refresh Data 4bx Version 3 2 2733 17643 Logged on User Helen Dallas Screen 5 1 Data Uploading River Site V Assegaaibosch GIASSE FRANS v Bera GIBERG FORE Boesmans GIBOES BANG Data Item Result Error Message Assegaaibosch Successful None Berg Successful None Boesmans Successful None Uploads Complete 1 1 1
123. the Rivers Server i e National database via the internet in real time Figure 2 1 Furthermore data that is managed on the Rivers Server rivers users invertebrate and fish lists pick lists etc and Site and Site Visit related data can be downloaded from the centralized repository on the Server The Rivers Client also provides an automated SASS data import facility that allows invertebrate data to be imported from an excel file via creation of a csv file National database Query Master Rivers Server server Web application Web Server Internet Data transfer Rivers Client windows application Query Master local SASS import csv Figure 2 1 Schematic representation of the Rivers Database Version 3 2007 architecture and data flow 2 3 Query Master Server and Client The Query Master can be used to extract data from the database A local version of the query master runs on the desktop and a server version runs on the web server Figure 2 1 The Query Master is accessible either through Internet Explorer or via a window in the Rivers Client application 2 Rivers Database Version 3 2007 2 4 System access System access is controlled via compulsory User Registration and new users need to register before being able to access the system Once registered the user will receive a username and password
124. tion B G neral n IR 22 Section B Index of Habitat nennen rennen eren 25 SOCHON 28 Viewing existing rivers tributaries and associated sites 7 Viewing SASS proficiency Status chere ede debe dre i eet eee E eet ee ede ehe di epo 36 71
125. tring Project Site Number String Owner String E River String 4e Tributary of String LatitudeGIS Number 4e LongitudeGIS Number ivi 43 Site Description String _4 4 Map Reference String LJ D Site Length Number atitude Number a Longitudinal Zone String Screen 6 3 Available fields for selection Query Master Microsoft Internet Explorer File Edit View Favorites Tools Help ay Qs v JO search S Favorites p e rel Address http localhost querymaster SelectFilters asp Links Query Master Define Filter Criteria oq Information Add the required filter s by following the steps below Step 1 Select the required field for filtering from the Field Name drop down menu Step 2 Select the appropriate operator for filtering the field from the Operator drop down menu Step 3 Enter the value s or items for filtering under Value This can be achieved by typing in letters or numbers or by Clicking on the box that appears under Value to select the required values from a list of all possible values currently available for that field Step 4 Click the Add Filter button Step 5 Repeat steps 1 to 4 to add additional filters Click Display Report to view the query output Current Act
126. tt the Ratel River Cape OlfantsDoOm Mountains E1OLIF Toni Olifants Western Western Folded KEERO Belcher WC 32 85 19 085 AtKeerom Cape Olifants Doorn E1OLIF Helen Olifants 3 Western 5 Western Folded KRIED Dallas WC 32 36528 18 95278 At Algeria causeway Kriedowkrans Cape Olifants Doorn E10LIF Toni Olifants Western Western Folded LANGK Belcher WC 32 04777 18 82273 Langkloof upstream Bulshoek Dam Cape Olifants Doorn Total Records 596 Page 1 of 30 NEXT gt gt gt HEHE 5 7 8 11 12 1 14 15 s 17 18 18 23 22 23 24 25 5 Please note the the records returned are limited to 300 Screen 6 6 Results of the query 45 Rivers Database Version 3 2007 6 3 Setting criteria Below is a short explanation of the different operators that can be used to set criteria Equals Not Equals In Not In Greater Than Less Than Greater Than Equal to Less Than Equal to Starts With This key is used to select only one value or item to return records for a single value or item For example if River Name Equals Berg is selected then only records for the Berg River are returned Compare with the operator In This key is used to exclude a single value or item from the list of those records returned For example if River Name not equals Berg is selected then all records for
127. ve Programs Select Rivers from the program list and click Remove 49 Rivers Database Version 3 2007 7 4 User Support for the Rivers Database Version 3 0 of the Rivers Database has been distributed to all RHP practitioners who attended the training workshops to regional champions and other relevant authorities known to be doing biomonitoring work in South Africa It is likely during the course of using the database that problems and suggestions for improvement will be noted Users are encouraged to send comments to the Rivers Administrator See Contact Details on the Rivers Server Reporting bugs or error messages Should you come across a bug in the Rivers application please report it by sending the following information via email to the rivers administrator as specified under the Contact details on the rivers server e The date of the error e The logged in user e A full description of the error including the process that resulted in the error e screen shot of the error while an error is displayed on the page click Alt and Print screen open Paint or Microsoft Word paste and save the image document 8 DOCUMENTATION Several reports related to the Rivers Database have been published They are available as pdf files within the Rivers Database via the Rivers Server Documentation The manual and other relevant publications are also available on the RHP website http www csir co za rhp 9 REFERENCES Dalla
128. wing forms e General Site Visit Information e Water Chemistry e Stream Dimension e Substratum Composition e Invertebrate Biotopes e Invertebrates Biotopes Sampled IHAS e Fish a General Site Visit Information Screen 4 18 This form provides information pertaining to each site visit or sampling occasion All users may view the data but only the Record Owner may edit the data linked to the particular site visit Each field is described briefly below and the reader is referred to the glossary or Dallas 2005 if additional clarification is required Data is added directly in the text boxes or using the drop down lists Date and time formats are specified and tick boxes are used for some fields Details of each field are given below Note If data in this section is collected on different dates but is still considered to be part of the same site visit then the earliest date should be used For example if SASS data was collected on 06 06 1999 and fish data on 07 06 1999 both should be entered as 06 06 1999 This is necessary to enable subsequent queries to be linked to common site visits e Water Level water level at time of sampling dry isolated pools low flow moderate flow high flow flood e Velocity and discharge estimates Optional measurement of water surface width and stream velocity for the calculation of discharge e Rainfall in the last 4 days this indicates the presence and extent of any rainfall event preceding t
129. y to refresh these so that the query is displayed correctly The River Server loads in the IE window that the Query Master was in Open Internet Explorer go to Tools Options and go to the advanced tab Under Browsing unclick Reuse windows for launching shortcuts When attempting to open the query master I am asked for a log in name and password Select cancel A pop up bar indicating that you can work on the intranet appears Right click this bar and select work on the intranet you can now proceed with working through the query master 47 Rivers Database Version 3 2007 When opening the query master I get the following message Unable to open Query Master asks for a login name In the Internet Explorer menu bar open Tools Options Connections LAN Settings and check the Bypass proxy server for local addresses checkbox When I open query master and click on Primary Component and the screen freezes When I try to add a filter and I unable to Go to File in menu You ll see that the work off line option in the drop down list has a tick next to it Click the work off line option and the tick will disappear You can now proceed to use the query master You need to enable Pop Up windows On the Tools menu click Pop Up Blocker Turn off Pop Up Blocker If you only want to allow pop ups from the Rivers website then on the Tools me
130. y typing the first letter of the fish species and using the scroll bar Tab Tab to move to No of Adults Tab No of Juveniles Tab No of Abnormalities The total is calculated automatically Right click and select Save to save the record Repeat until all fish species for the sampling method and fish habitat have been recorded Then select the next sampling method and or habitat and repeat until all data is captured To export all fish data captured click the Export button 30 Rivers Database Version 3 2007 Rivers ays yueas Ei E General Site Visit Information I h li Water Chemistry 0 19 ti Stream Dimensions 0 lu ti Sul Composition 5 2 2a 3 n 1 E Invertebrate Biotopes 19 i E Invertebrates 0 19 E Biotopes Sampled Fish Helen Dallas Freshwater Research Unit UCT Christa Thirion Resource Quality Services DWAF X3SABI BRAND 1999 07 13 10 30 Version 3 0 2711 17771 General Site Visit Information Water level at time of Sampling Moderate flow Significant rainfall in the last week Velocity and discharge estimates Average Velocity ms 1 Average Depth Discharge m3s 1 Rain Comment Cover Canopy Cover Comment Impact on Stream Habitat Channel flow organic debris Score Source Coa ody debris
131. ys hutereaui Boulenger 1913 Meshscaled Topminnow Cyprinodontidae Ajoh Aplocheilichthys johnstoni G nther 1893 Johnston S Topminnow Cyprinodontidae Akat Aplocheilichthys katangae Boulenger 1912 Striped Topminnow Cyprinodontidae Native Amya Aplocheilichthys myaposae Boulenger 1908 Natal Topminnow Cyprinodontidae Acal Astatotilapia calliptera G nther 1893 Eastern Happy Cichlidae Aort Astyanax orthodus Ex Hepsetidae Abre Atherina breviceps Valenciennes 1835 Cape Silverside Atherinidae Alac Atherinomorus lacunosus Forster 1801 Hardyhead Silverside Atherinidae Abar Austroglanis barnardi Skelton 1981 Barnard S Rock Catfish Austroglanididae Agil Austroglanis gilli Barnard 1943 Clanwilliam Rock Catfish Austroglanididae Ascl Austroglanis sclateri Boulenger 1901 Rock Catfish Austroglanididae Native Aaen Awaous aeneofuscus Peters 1852 Freshwater Goby M Gobiidae Native Agui Awaous guineensis Peters 1876 Brown Goby M Gobiidae Baen Barbus aeneus Burchell 1822 Smallmouth Yellowfish Cyprinidae Bafr Barbus afrohamiltoni Crass 1960 Hamilton S Barb Cyprinidae Native Bafo Barbus afrovernayi Nichols amp Boulton 1927 Spottail Barb Cyprinidae Bama Barbus amatolicus Skelton 1990 Amatola Barb Cyprinidae 61 Rivers Database Version 3 2007 Code Scientific Name Common Name Family Status Band Ba

Rivers Database Version 3 A User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents