Home

Rivers Database Version 3 A User Manual

Contents

1. 21 Section B G neral Se a en ae lea ee EROR EL ae 22 Section Index of Habitat Integrity 25 SOCHON 28 Viewing existing rivers tributaries and associated sites 7 Viewing SASS proficiency Status n tede ed debe dre i ere eg E e Let ee ede ehe d uro 36 75
2. base Version 3 er Manual SA A Rivers File Edit Tools Window Search River Berg 4b Drainage Region Berg Site Code Site Description Longitudinal Zone gt River a E GIBERG F RES Below forestry operations Mountain stream 8 Waterfall GIBERG FRANS Mountain stream in Franschhoek Forestry Reserve Mountain stream Extended Search Criteria a 8 Assegaaibosch 3 G1BERG BRBM1 Above Theewaterskloof water transfer tunnel Skuiftaam Dam Upper Foothill v Wolvekloof E GIBERG CECIL Cecilas Drift above Paarl Upper Foothill Political Region z a Franschhoek GIBERG DEWDA Below Dewdale fish farm Dam Site 2 Upper Foothill WMA amp ll Wemmershoek g Upper Foothill Ecoregion T lj a GIBERG SKUIF Site below proposed Skuifraam Dam in Franschhoek Forest Upper Foothill E Drakenstein E G1BERG THEE2 Below Theewaterskloof water transfer tunnel Upper Foothill S c k Lowe Foti A Secondary Catch Bl Dwars 1 aljasophat in Paarl below sewage treatment works ower Foot i Ej Hugo G1BERG DRIEH Downstream of Drie Heuwels weir Lower Foothill Quaternary Catch _ _ Z BIBERG GDEDV Downstream of roadbridge at Goedverwacht near Gouda Lower Foothill ose 3 80 Sand E G1BERG HERMO Downstream of He
3. sassData Import 4 gt x a C HelenAllFiles RiversD base Data Gerhard Diedricks SabieT esllmport c Print a Cem 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 sicisooc 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 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 AM sicisooc ANCYLIDAE B Gerhard Diedricks Gerhard Diedricks BAETIDAE 2 SP 1 Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO Sass Import 2 CAENIDAE ty Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO CERATOPOGONIDAE Gerh
4. reed er quet tar dite dp 19 Site Visit Section B General 5 LR HER HU HEU CL Ama ERI cea 22 Condition of Catchment 2 hue e HER Meere Ge eet eee eee eee 22 Channel Condition eet e te Ee Lotte Merete clacton a tos 22 Channel Morphology tete E 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 HAS otc eee een Ee cei e e tee nein e Rr e e c 30 Inte 30 Software and Hardware Requirements esee ener erstes nest 49 70 Support for Rivers Database Users nnen onre 50 System ACCESS 50 AE AA e SEES An 3 70 Technical formation ee aa a ak AEE EE ELEN AES 49 70 Uninstalling the Rivers application 49 Uploading site photographs ede e ett eee dete epe t eee etes 7 Viewing and adding Site dat nin de tene 17 Viewing and adding Site Visit
5. Search sip Favorites ei a 2 Address http www softcraft co za Rivers Application DeFault aspx Links gt m River s Administration Documentation 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 gite HiBREE WITBR v Photo Area Upstream v Image path gif jpg 1 c photographs workF Mb Limit a aphs worke 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 Frequency of assessment Section A Site specific information Entered during or after the first site visit c Enter uring the first site vis
6. sxx x Search Favorites amp 9 rel 2 Address 4 amp http localhost querymaster Selectoin asp Go Link X Query Master OO M 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 region in which the site is located such as river Section A Desktop Spatial longitudinal zone political region WMA Ecoregion and Il Secondary catchment t oO 1 to 1 Information Site Vegetation Type Geological Type etc enera A Secondary General information regarding site location details such as Land Owner and contact Section Location i 1 to 1 2 details General Information Site amp Geo Reference secondary Geo reference data longitude and latitude coordinates in three different formats Geo E 1 10 1 Data Site lt lt Back Next g
7. 3 Extensive Left bank only Agriculture crops orchards etc 3 sive 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 Rivers File SiteVisit Tools Window Assegaaibosch Berg Sabie 9 15 1999 X3SABI LUBYE 9 15 1999 ays yueas Condition of Catchment Channel Condition Channel Morphology X3SABI BRAND 1999 09 15 11 00 dm Owner Helen Dallas Freshwater Research Unit UCT assessor Christa Thirion Resource Quality Services DWAF Channel Condition In channel and Bank Modification Upstream Impac Upstream Distan Downstream Im Downstream Dis Canalisation unspecified Ctrl Enter Undo Row Edit Export to Excel Generate from Previous Comments Version 3 2 2733 17643 Screen 4 11 Channel Condition E Rivers Logged on User Helen Dallas File Sitevisit Tools Window asye Assegaaibosch Berg Sabie 9 15 1999 X3SABI LUBYE 9 15 1999 Channel Condition Channel Morphology X3SABI BRAND 1999 09 1 User Organisation a gt x Owner Helen Dallas Freshwater Research Unit UCT Assessor Christa Thirion Channel Morpholog
8. General Site Visit Information Water Chemistry Erri Stream Dimensions Substratum Composition Invertebrate Biotopes Err Invertebrates 558 sampled Version 3 0 2711 17771 Screen 4 19 Water Chemistry Water Chemistry Christa Thirion Instruments in Fast Flow v Samples Collected Water Filtered Samples Frozen Institution Samples Sent Water Turbidity o o If no where Date Sent for Analysis Volume Filtered rol Other Preservation Resource Quality Services DWAF 6 21 2007 Mercury Chloride 05 Discoloured Water Chemistry Data Ownership Owner Chemistry Details Helen Dallas Description Calcium 3 00000 mg Helen Dallas Alkalinity as Calcium Carbonate 40 00000 mo Chloride 10 00000 Conductivity 11 80000 Flourine Potassium 0 10000 0 80000 Kjeldahl Nitrogen 0 04000 Magnesium 5 00000 Sodium 5 00000 Logged on User Helen Dallas 31 Rivers Database Version 3 2007 ays yueas Ei General Site Visit Information Water Chemistry Stream Dimensions Substratum Stream Dimensions Stream Dimension Width Category m Water Surface Width Macro channel Width m Ban
9. 1 Gerhard Diedricks Gerhard Diedricks 4 5 2004 12 00 00 AM MViAQV CHIRONOMIDAE Gerhard Diedricks Gerhard Diedricks 4 5 2004 12 00 00 MWAQY DIXIDAE Gerhard Diedricks Gerhard Diedricks 4 5 2004 12 00 00 AM HYDRAENIDAE 1 Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO 4 5 2004 12 00 00 MWViAQV LEPIDOSTOMATIDAE B gree Diedricke Rerhard Dliadricbe Y3GARILANTHO AiRI2DDA 12 nn nn Ahd RAIA n 4l 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 update 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
10. ases Sabie 4 5 2004 6 26 2007 1 i E Instream Modifications hu 19 Riparian Zone Modifications 19 Catchment Modifications hu 9 River and Seasonality Instream Components Err Riparian Zone Component Result and Ownership Version 3 2 2733 17643 X3SABI BRAND 2007 06 26 15 12 User Non Marginal Bank Structure Rating Organisation 20 4bx Helen Dallas Freshwater Research Unit UCT Helen Dallas Result and Ownership Instream Habitat Integrity Percentage 87 Category Riparian Zone Habitat Integrity Percentage 72 Category 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 UCT Rivers Database Version 3 2007 Viewing and adding Site Visit data Section C Section C includes the following 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 i
11. 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 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
12. 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 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
13. 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 aL gin Microsoft Internet Explorer File Edit View Favorites Tools Help Om OAD Ds drm O 2 2 a ADs Address a http www softcraft co za Rivers Application Login aspx ReturnUrl 2FRivers 2FDefault aspx Go Links gt 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 File Edit View Favorites Tools Help ay O RAO Pao dem 6 8 2 m Address http www softcraft co za Rivers Application UserCRUD aspx Bo Links gt 3 User Registration Complete the user details form to register User detail Experience First name New Surname User Organisation CapeNature 4 Province Western Telephone 021 5555555 Fax 021 4444444 Email New User organisation org Postal Address 10 New Street Cape Town Postal Code ET Regional Champion Use
14. 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 Longitudinal 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 che
15. 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 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
16. 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 predetermined 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
17. 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 vary 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 e
18. p e m rel http flocalhost querymaster SelectFilters asp Go Links gt Address Query Master Define Filter Criteria 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 Active Filters Field Name Operator Value Type Action F Equals Western Cape String Delete Filter w 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 Fite lt lt Back Display Report Screen 6 4 Define filter Criteria 44 Rivers Database Version 3 2007 Query Master Microsoft Internet Explorer File Edit lelp Qs Si x a JO Search she Fav
19. Check for Updates Download the latest updates for the Rivers Client application 73 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 ee ne tee ite A ao ee eee cd 39 GI ria m ER 52 Importing SASS data ere ede eee tee eerte ste tice etre eet 36 Installing the Rivers application reii ene nest 49 70 tothe Rivers lient ze He rent eae o m tee Lg E red testi 3 Login to the Rivers Server o eee ene ei eee e epe ee CERES eee Rae Ce ae eet cede 3 Managing Ravers st ii e Ee e tst ep b ie Ene te Rd D ai t E te aee eae esto sei sea iode 6 Navigating the River Tree View iniit tse ic
20. 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 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
21. 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 Native 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
22. 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 on the minus sign next to the appropriate river e Continue expanding each river in the hierarchy until the desired river has been found
23. Kogmanskloot y Version 3 0 2664 27407 File Edit Tools Breede Klaas Yoogs HIBREE CERES HIBREE WITBR H1BREE SLANG HIBREE WYSERS H1BREE NEKKI H4BREE LECHA HSBREE SECUN E HS5BREE DREWB H4BREE MOORD HBBREE ABBEY H BREE SWELL H7BREE NAPYK 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 Logged on User Administrator Window DER Breede Site Code Breede Unspecified Hoeks 8 Dwars 8 Titus Sandspruit wi 88 Wabooms wears M H1JAND SOMER amp Doring ua Unspecified 8 Poeslenels vink Willem Nets Hoops 8 Keisers Klaas Voogs Koamanskloot Site De
24. 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 all 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
25. drm O 22 a 08 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 gg anevelaspruit 15 oudstroom 15 abane 21 Mac angspruit oord Sand GB Phabeni 32 Hluvamaduba 33 Ngwenyameni Mbandweni 0 Screen 3 4 Viewing tributaries of a river 10 Rivers Database Version 3 2007 Framework Microsoft Internet Explorer 5 File Edit View Favorites Tools Help AN Qs 9 i Search Sig Favorites v i a x Address http www softcraft co za Rivers Application Default aspx Ai ALTA e We The River Health Programme Version 3 0 m River Administration Documentation Query Master s Logout River View and edit the river details Validate Tributary of River Detail Tributaries Sites Add and remove sites from the river RHP Site Code Longitudinal Zone Site Description ABI GROUB Mountain Headw Grouberg on KLF Ceylon plantation ABI BEHSF Mountain stream Below H hoe Falls ABI HSFALL Mountain stream Above Horseshoe
26. 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 necessary 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 mast
27. 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 rivers 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
28. 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 IIS 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
29. 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 returned 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
30. 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 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
31. Olifants Doom western Folded dip Liz Day Feud 31 99111 18 79 About 1 km downstream ofthe Bulshoek Dam Pesci Olifants Doorn Ware BER Er 32 58 19 Downstream of Citrusdal pended Olifants Doorn Missy ded TUS Med terim Liz Day resi 32 88722 1909444 arbi e ss an lord ofthe confluence en Olifants Doorn ded abc muss 3285 19 085 At Keerom OlifantsiDoom Western Folded AE woe 32 36528 18 95278 AtAlgeria causeway Kriedowkrans ee OlifantsiDoom western Folded Feed iM 32 04777 1882273 Langkloof upstream Bulshoek Dam d OlifantsiDoorn western Folded Total Records 596 Page 1 of 30 NEXT gt gt 2 pu ps pe 7 pe io 11 12 1 34 15 35 iz 22 23 4 28 8 EM ES EN EM 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
32. Pseudobarbus afer Peters 1864 Eastern Cape Redfin Cyprinidae Pasp Pseudobarbus asper Boulenger 1911 Smallscale Redfin Cyprinidae Pbur Pseudobarbus burchelli Smith 1841 Burchell S Redfin Cyprinidae 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 Br
33. Query Master Logout Saved successfully River View and edit the river details Validate Delete Close Tributary 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 Sort Order Drainage Region G Great Berg et al Screen 3 2 Creating new river and notifying Rivers Administrator to ensure river validation Rivers Database Version 3 2007 Framework Microsoft Internet Explorer File Edit View Favorites Tools Help M Q x JO search She Favortes P rel Address http www softcraft co za Rivers Application Default aspx Go The River Health Programme Version 3 0 River s Administration Documentation Query Master s Logout River View and edit the river details Validate Delete e Tributary River Detail Tributaries Sites River Name Sabie Tributary Of Incomati Add Political Region Mpumalanga v Sort Order 2 Drainage Region Crocodile Screen 3 3 Viewing details of a river Framework Microsoft Internet Explorer efx Fie Edit View Favorites Tools O RAO
34. Rivers Database Version 3 2007 ays yueas Ei Instream Modifications River Type and Seasonality Riparian Zone Perennial Longitudinal Geomorphological Zone Width Catchment Modifications Change in Seasonality Large Floods X3SABI BRAND 2007 06 26 15 12 Owner Helen Dalas Freshwater Research Unit UCT Assessor Helen Dallas Freshwater Research Unit UCT O No Foothill River Type and z Seasonality Change in Seasonality Baseflows Instream Components Riparian Zone Component ES Result and Ownership Version 3 2 2733 17643 Logged on User Helen Dallas Screen 4 14 River type and seasonalit Change in Seasonality Freshes amp Moderate Floods Organisation eL ays yeas E e Helen Dallas Freshwater Research Unit UCT Helen Dallas Instream Instream Components Hydrology Riparian Zone Rating Confidence Freshwater Research Unit UCT Physico Chemical pH Confidence Modifications BaseFlows gem Zero Flows Catchment porc Modifications Floods E Hydrology Rating River Type and Bed Modification Seasonality Metric Sediment Instream Components Benthic Growth Bed Modification Rating Bank Modification Riparian Zone omponent Marginal Non Marginal Result and Ownership Bank Modification Rating Version 3 2 273
35. 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 Remove 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
36. 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 fields 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
37. 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 Determination 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 Ge
38. 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 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
39. 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 search 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
40. 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 Framework Microsoft Internet Explorer mef Fie Edit View Favorites Tools Help ay Qe x Search S Favorites B jw rel 2 Address http www softcraft co za Rivers Application Default aspx Go Link ALTA The River Health Programme Version 3 0 m River s Administration Documentation s Query Master s Logout Rivers Use the list to view and manage rivers River Tributary Of Drainage Region 8 lein Sabie Sabie Crocodile ESSE Incomati X Cri River sabie no dile E 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 Help ay Qs x yo Search She Favorites B vi LJ a 33 Address http www softcraft co za Rivers Application Default aspx Go Links The River Health Programme Version 3 0 m River s Administration Documentation s
41. 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 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
42. 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 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 avail
43. 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 Components 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
44. 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 description 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 All
45. 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 components 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
46. weir bridge Lower foothill Neels Kleynhans E x35A8I HAZYV Red Ridge Hazyview Lower foothill Johan Engelbrecht E 35 1 Hoxane below roadbridge from R536 from KNP Lower foothill Andrew Deacon BI B Site itimnhiri gwer foothill Andrew Deacon foothill Andrew Deacon ler foothill Andrew Deacon ler foothill Andrew Deacon foothill Johan Engelbrecht foothill Johan Engelbrecht foothill Andrew Deacon ler foothill Johan Engelbrecht June 2007 noli ze ays yeas Ei E Helen Dallas 10 11 12 13 14 15 16 17 18 19 20 BE 22 23 24 25 26 27 28 29 30 1 2 3 4 25 16 F __ Today 6 21 2007 Version 3 0 2711 17771 Logged on User Helen Dallas Screen 4 9 Adding a new Site Visit Assegaaibosch Berg Sabie 9 15 1999 x3sABI LUBYE 9 15 1999 4bx X3SABI BRAND 1999 09 15 11 00 Condition of Catchment Helen Dallas Freshwater Research Unit UCT Christa Thirion Resource Quality Services DWAF ays yeas Ei E Condition of Local Catchment Channel Condition Site Visit Land Use Ex Within Riparian Beyond Riparian Impact Rating Confidence Level Comments Afforestation general 0 None 2 Moderate 3 Estensive LHB only Channel Morphology Rural development 0 None 2 Moderate 3 Estensive Farm dwellings Wilderness area 3 Extensive 0
47. 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 Although the information included in Section A is site specific and therefore should not change over time it is complete record is kept of any changes that may be made to the site information important to allow changes to be made for example if land ownership
48. 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 DISS 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
49. 1 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 Sawfin 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
50. 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 Aplocheilichthys 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 Ri
51. 1995 11 01 00 00 Helen Dallas Version 3 0 2664 27407 Logged on User Administrator Screen 4 3 Adding a site in the Site List Rivers Site Code Site Description Longitudinal Zone Owner HIBREE CERES Near golf course below Ceres Upper foothill Helen Dallas HIBREE WITBR At roadbridge near Mitchells Pass road below Upper foothill Helen Dallas s HIBREE SLANG Low flow bridge at Slanghoek tum of Upper foothill Helen Dallas HIBREE WYSERS Downstream of bridge south of Wysersdrift Lower foothill Justine Ewart Smith Upstream of bridge near resort Die Nekkies Lower foothill Helen Dallas Below D WAF weir on Farm Le Chasseur nea Lower foothill Helen Dallas HS5BREE SECUN Near DWAF weir on farm Secunda on road Lower foothill Helen Dallas H5BREE DREWB Near low flow bridge at Drew Lower foothill Helen Dallas H4BREE MOORD At low flow bridge at Moordkuildrif Lower foothill Justine Ewart Smith H5BREE ABBEY u s of confluence with Riviersonderend at the Lowland river Geordie Ractliffe E H7BREE SWELL Hidro sign immediately before Swellendam ont Lowland river Helen Dallas H7BREE NAPYK On farm Napyksmond on road to Infanta Lowland river Helen Dallas 11 01 00 00 Helen Dallas 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
52. 3 17643 Logged on User Helen Dallas Screen 4 15 IHI instream components 26 Salts Nutrients Water Temperature Turbidity Oxygen Toxics P C Rating Longitudinal Lateral Connectivity Modification Rating 3 5 Rivers Database Version 3 2007 ays yueas Ei E X 3SABI BRAND 2007 06 26 15 12 il 0 i t Instream Modifications El 0 1 ic Riparian Zone Modifications 0 19 Modifications 5 5 3 0 E River Seasonality 3 o 5 a E Instream Components Riparian Zone Component Result and Ownership Version 3 2 2733 17643 Riparian Zone Hydrology Base Flow Low Flow Helen Dallas Bank Structure Bank Structure Modifications arginal Rating Non Marginal Rating 30 Substrate Exposure 30 Freshwater Research Unit UCT Helen Dallas Freshwater Research Unit LICT 4bx Zero Flow Invasive alien vegetation 20 40 Moderate Floods Large Floods Riparian Zone Hydrology Rating 2 5 Connectivity Modification Longitudinal Physico Chemical Erosion Channel Straightening Calculated Bank Modifications Metric 5 Rating 4 0 5 0 Confidence Marginal 30 2 Lateral Connectivity Rating Logged on User Helen Dallas Screen 4 16 IHI Riparian Components
53. 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 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 an
54. 68 e 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 dd mm yyyy Installing Before installing the Rivers application please ensure that Service Pack 2 SP2 Service Pack 2 has been installed and Internet Information Services IIS 5 or greater is installed SP2 and on your computer Internet Information e Service Pack 2 is available as an update on the Windows website Systems IIS www microsoft com note this is not necessary for Windows Vista e install IIS on Windows 2000 or Windows 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 Install IIS on Vista Go to Start Control Panel Programs and Features and select Turn Windows features 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 Installing the The installation shield should begin automatically when the CD is inserted into the Rivers Database drive If it does not browse for
55. 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 appropriate 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 duplicat
56. Falls and ABI LTPA Mountain eam Long Tom Pas ea Whiske ABI AANDE Upper Foothill Aan de Vliet ABI AMILL Upper Foothill GFP vmill ABI BRAND Upper Foothill At Branc g below confluence of Sabane and Mac Mac Ri E ABI CASTL Upper Foothill Castle Rock X3SABI FRANK Upper Foothill At Frankfort safcol p ABI LUNSK Upper Foothill Lunsklip on KLF Frankfort hd Save ge Screen 3 5 Viewing sites a river the longitudinal zone a description are provided 2 Framework Microsoft Internet Explorer File Edit View Favorites Tools Help ay X JO search Favorites B a 33 Address http www softcraft co za Rivers Application Default aspx Links gt The River Health Programme Version 3 0 m River s Administration Documentation s Query Master 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 z Longitudinal Zone Lower Foothill GeoReference Lat 25 5 94 Long 31 53 16 Location confluence with Lubye lubye River in Kruger Park Screen 3 6 Viewing site details 11 Rivers Database Version 3 2007 Framework Microsoft Internet Explorer mef Fie Edit View Favorites Tools ay Qs c x
57. LULIDAE 4 HEMIPTERA VELIIDAE MESOVELIIDAE 5 Invertebrate Biotopes DIPTERA CHIRONOMIDAE 2 DIPTERA SIMULIIDAE 5 Invertebrates Additional Comment SASS Score 37 Air Breather Score 5 No Families 8 Air Breather Families 1 ASPT 4 63 Air Breather ASPT 5 00 Fish Version 3 5 Logged on User Helen Dallas Screen 4 23 Invertebrate Taxa 33 Rivers Database Version 3 2007 Rivers File SiteVisit Tools Window Sabie Elands 9 15 1999 6 21 2007 4 gt A2ELAN LINDL 2007 06 21 14 38 7 i Owner Helen Dallas Freshwater Research Unit UCT Assessor Helen Dallas Freshwater Research Unit UCT General Site Visit Biotopes Sampled Invertebrate Habitat Assessment System IHAS Information Total length of white water Water Chemistry Total length of submerged stones in current Number of separate SIC areas kicked Average stone size s kicked Stream Dimensions Amount of stone surface clear Protocol time spent actually kicking SIC s Length of marginal vegetation sampled Amount of aquatic vegetation algae sampled Substratum Composition Marginal vegetation sampled in or out of current of vegetation Stones out of current SOOC sampled Invertebrate Biotopes LI Sand sampled in minutes Mud sampled in minutes Gravel sampled in minutes Invertebrates Bedrock sampled Algal
58. Mugilidae Larg Lutjanus argentimaculatus Forsskal 1775 River Snapper Ms Lutjanidae Mele Malapterurus electricus Gmelin 1789 Electric Catfish Malapteruridae Mmac Marcusenius macrolepidotus Peters 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 cape
59. S PROJECT NUMBER REPORT NUMBER PROJECT TITLE DATE Recommended Approved Rivers Database Version 3 A User Manual Dallas H F Molteno A Ewart Smith J and Janssens P Final report 2004 157 N000000REQ0107 Data Storage and Management for the National Coverage Phase of the National Aquatic Ecosystems Health Monitoring Programme River Health Component September 2007 Mr Axel Diefenbach Acting Director RQS Date Mr Mbangiseni P Nepfumbada Chief Director WRIM Date ACKNOWLEDGEMENTS The following project team members and officials of the Department of Water Affairs and Forestry are thanked for their inputs comments and assistance towards the development of this document Project Management Team Mr B Madikizela Deputy Director RQS Ms Jhupsee Mr Sekwele Assistant Director RQS Study Team Dr N Kleynhans Dr K hn Mr B Madikizela Ms P Maseti Ms C Thirion Ms C Todd Dr C Dickens Project Steering Committee Chief Director WRIM Director RQS Deputy Director RQS Director Resource Directed Measures Director Information Programmes Director Water Use and Conservation Director Water Resources Planning Systems Representative Department of Environmental Affairs and Tourism Representative University Representative Water Research Commission Representative Project Management Team Representative Study Team Rivers Database Version 3 2007
60. 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 current version The Rivers Server is available either via Internet Explorer Start Programs Rivers Database 2007 Rivers Server or clic
61. able 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 by 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
62. ard Diedricks Gerhard Diedricks P Data imported successfully CHIRONOMIDAE B Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO LEPIDOSTOMATIDAE Gerhard Diedricks Gerhard Diedricks LEPTOCERIDAE B Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO LIMNICHIDAE Gerhard Diedricks Gerhard Diedricks X3SA4BI ANTHO OLIGOCHAETA Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO 4 5 2004 12 00 00 AM G S M 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 G S M SPHAERIIDAE Gerhard Diedricks Gerhard Diedricks 4 5 2004 12 00 00 GISiM SYNLESTIDAE CHLOR B Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO 4 5 2004 12 00 00 AM G S M TRICORYTHIDAE 1 Gerhard Diedricks Gerhard Diedricks 4 5 2004 12 00 00 AM GISiM TURBELLARIA Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO 4 5 2004 12 00 00 AM GISiM VELIIDAE MESOVELIID Gerhard Diedricks Gerhard Diedricks 4 5 2004 12 00 00 AM MViAQV ANCYLIDAE 1 Gerhard Diedricks Gerhard Diedricks X3SABI ANTHO 4 5 2004 12 00 00 AM MViAQV BAETIDAE gt 25 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
63. at Cells scroll to Custom from the category and type dd mmm yyyy in the Type field 37 Rivers Database Version 3 2007 server upload 4 gt x Upload Control Panel f Upload assessor a m v Site and site visit data ge Drainage region G GreatBergetal Limit the number of rivers selected if you have a slow internet connection dial Refresh Data River Site V Assegaaibosch GIASSE FRANS V Berg G1BERG FORE Boesmans G1B0ES BANG Data Item Result Error Message Assegaaibosch Successful None Berg Successful None Boesmans Successful None Uploads Complete Version 3 2 2733 17643 Logged on User Helen Dallas Screen 5 1 Data Uploading 1 1 1996 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 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 3 i River Name Mac Mac Successful None 5 Crocodie E Ni River Name Mantsipane Successful None Limit the number
64. ata Component then click the Next button Click on any component icon to view a list of the fields that are available within that component 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 J Information General Site Associated Systems etc Information at site visit level including RHP Site Code Sampling Date and Site Visit Owner Additional 0 Primaty spatial fields are included to facilitate filtering e g River Name Longitudinal Zone Altitude Political Section A Information p region WMA Ecoregion and Il Sec and Quar catchment Veg Type Geol Type Bioregion WCMR and General 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 Primary Data archived from previous Rivers Database e g geomorphology IHI macrophyte and algal cover Data HQI RVI data Archived Data NIA Screen 6 1 Primary Data Component Selection A Query Master Microsoft Internet Explorer File Edit View Favorites Tools Help ay A D i gt
65. atabase 70 Frequently asked questions 73 CR 74 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 For a quick guide to obtaining installing and using the Rivers database refer to Appendix 6 of this manual The manual is divided into the 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
66. changes or improved GPS technology allows more accurate geo referencing of a site This form is automatically updated and cannot be edited Rivers fei File Site Tools Window 1 0 Eerste G2EERS IONKE 4 b 2 a User Organisation General Sie Helen Dallas Freshwater Research Unit UCT Information General Site Information bold fields are mandatory and must be completed Spatial Information Owner Helen Dallas Mj RHP Site Code G2EERSJIONKE Reference Site V Site Code ERSO Project Site Number Location Details River Eerste 1 Tributary of Conventional DMS GIS Decimal Degrees GPS Degrees amp Decimal Min Site Transaction C datum Clarke 1880 5 aff a c 5 40000 4 0000000 L wass4daumHBHS4 EO 18993000 Eg 18 Other Sites within 500m Site Description Mountain stream in Jonkershoek State Forest Map Reference 3318DD Site Length Longitudinal Zone Mountain stream v Altitude m 380 Hydrological Natural Present day Perennial vi 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 Info
67. ck 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 Edt View Tools Window Search River Breede Drainage Region H Breede 4px Breede Site Code River bree Breede Extended Search Criteria Political Region Unspecified Hoeks B a Dwars Titus WMA Ecoregion I Ecoregion II Witels Sandspruit B wit 88 Wabooms Secondary Catch 8 a Slanghoek Quaternary Catch Longitudinal Zone Jan du Toits 8 Smalblaar E Bothaspruit Site Owner Helen Dallas Hartbees Site Code River Search Type Main Rivers Only All Rivers 8 Holsloot Hex 8 Doring Unspecified ij Poeslenels vink B Willem Nels Hoops Keisers Bisearch River Search Site amp Bl
68. cluded 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 Rivers Sabie 6 21 2007 4bx 2250 Sabie 3 X3SABI ANTHO Below confluence of Sabie and Sand rivers Anthoclysta KNP Leop Lower foothill Andrew Deacon E x3SABI CA294 Calcutta 294 Lower foothill Neels Kleynhans 3 5 1 01 Sabiehoek Calcutta 294 Lower foothill Johan Engelbrecht X3SABI CALO3 Madras 282 Pump station Lower foothill Mick Angliss 3 X35ABI FISHL Lower Sabie fish ladder at
69. d 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 automatically 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 cl
70. ded a Key Details Err 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 DER File Site Tools Window ISBREE ABBEY 4 D HSBREE ABBEY i User Organisation guner Geordie Freshwater Consulling group Site Transactions Field Original Value Modified To Date Changed User Organisation Spatial Information Site Code H BREE ABBEY HSBREE ABBEY 2006 05 09 12 00 00 Administrator Freshwater Consulting group Secondary Catchment H5 2006 05 09 12 00 00 AM Administrator Freshwater Consulting group General Site Comment SASS scores from report The SASS scores from report The 2003 03 25 12 00 00 AM Administrator Freshwater Consulting group Location Details z Site Transaction Version 3 0 2686 22353 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 adding 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
71. 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 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 invertebrat
72. dw Dominion Group And Witwatersrand Supergroup Andesite quartz porhyry quartzite shale conglomerate Quartzite shale hornfels Rooiwater Complex Diorite gabbro V Vs Vv Mashashane And Mashishimale 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 S
73. e 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 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
74. e 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 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
75. e ie e e de Po i eni p PROS 12 14 Navigating to Sites and Site Visits eisimirce esteen nennen 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 0 cecescesecesecesecsseeseeeeseeeeseeeseecaaensecsseceneeeseeseneesaes 40 References 50 Regist r as a new User etie He ed eet lees elie 3 70 Reporting bugs error messages eee ot iia ee EE A E A i aia AE EES 50 Rivers ae T nO nett aita m ahead siet at 2 12 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
76. eam 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 1832 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 Sn
77. eb Synodontis nebulosus Peters 1852 Cloudy Squeaker Mochokidae 68 Rivers Database Version 3 2007 Code Scientific Name Common 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 J
78. 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 sssscssssccsssscsssscsssccssssssssscsssesssseceees 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 Vi
79. er 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 menu 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 SEE APPENDIX 6 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
80. 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 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 ceatseenece
81. 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 Appendix 6 Appendix 7 Glossary of terms used in this 52 A step by step example of a query setting specific 53 Geological types based on Vegter 1995 giving Lithostratigraphic Unit and Principle Rock i Een Pe 55 Water Chemistry codes giving the description units expected minimum and MAXIMUM values iit pr ce set dee e ture Ebro ced nd 59 Bish codes xii e E et He p ne d RR EE Pei er ees 61 Quick guide for obtaining installing and using the Rivers D
82. 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 Dallas 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
83. hand pane click highlight SQL Server 2005 Services In the right hand pane right click SQL Server SQLEXPRESS and in the pop up menu click Stop d When the server has stopped in the right hand pane right click SQL Server SQLEXPRESS and in the pop up menu click Start e Once the server has started close the SQL Server Configuration Manager f Start and login to the Rivers Client 2 You receive and error similar to the following when trying to install the Rivers client application Error 1001 The file Program Files Microsoft SQL Server MSSQL 1 MSSQL Data Rivers2 mdf is compressed but does not reside in a read only database or file group The file must be decompressed Could not open new database Rivers2 mdf CREATE DATABASE is aborted Resolution a Navigate to the file C Program Files Microsoft SQL Server MSSQL 1 MSSQL Data Rivers2 mdf b Check this file for compression by right clicking Rivers2 mdf file Click Properties under General tab Click the Advanced button d Uncheck Compress Contents to save disk space e Click 3 You receive and error similar to the following when trying to download site and site visit data from the server to the Rivers client application Error Downloading data Error The operation has timed out Resolution a Login to Rivers Client Ensure that you have an internet connection b Click the Tools menu and
84. he 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 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
85. he 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 biotopes Catchment modifications River Type and Seasonality IHI Instream components IHI Riparian Zone Invertebrates components Biotopes sampled
86. ient 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 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 g
87. ight 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 Rivers Sabie 4 5 2004 6 26 2007 4 gt x User Organisation Owner Helen Dallas Freshwater Research Unit UCT Assessor Helen Dallas Freshwater Research Unit UCT Instream ays pees Overall Rating Site Rating Comment Upstream Rating Upstream Comment Abstraction run of river Limited 2 Moderate Water pumps evident 2 Moderate Crossings low water Limited 1 Limited Small size 0 Inter basin transfers Introduced habitat modifiying fauna Runoff effluent Industries Runoff effluent Irrigation Runoff effluent Mining o a River 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
88. ine Distichodontidae Hmul Hemigrammocharax multifasciatus Boulenger 1923 Multibar Citharine Distichodontidae 64 Rivers Database Version 3 2007 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 Cyprinida
89. ion 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 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
90. it 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 each search Search results either sites or rivers are displayed in alphabetical 12 Rivers Database Version 3 2007 order below t
91. ivers Database Version 3 2007 Facilitating Client Server data transfer The River Client component of the Rivers Database is a comprehensive data structure with forms and queries that allows the user to enter detailed information about monitoring sites and sample results on his or her own computer For data security purposes and to allow national reporting each user needs to regularly synchronise the local dataset with the central database using an automatic Internet transfer procedure In order not to compromise government network firewalls the central database is located on a site hosted by Web Africa on the domain www riv co za Where firewalls exist it will be necessary for the Information Technology IT section or your organisation to enable file transfer To obtain a letter detailing this please contact the Rivers Administrator contact details are on the Rivers Server 72 Rivers Database Version 3 2007 Appendix 7 Frequently asked questions 1 You receive an error similar to the following when trying to log into the Rivers client application Microsoft SQL Native Client error 80004005 Shared memory Provider Could not open a connection to SQL Server Or Cannot open database Rivers2 requested by the login The login failed Login failed for user network user Resolution a Click Start All Programs Microsoft SQL Server 2005 Configuration Tools SQL Server Configuration Manager b In the left
92. k Height Bank Height Category m Right Bank Height Left Bank Height 1 3 bd Dominant Physical Biotope ipe Shallow water habitat Deep water habitat E Helen Dallas Freshwater Research Unit UCT Christa Thirion Resource Quality Services Dominant Physical Biotope Type 0 25 Cobble riffle 0 75 Pool Version 3 0 2711 17771 Logged on User Helen Dallas Screen 4 20 Stream Dimensions Rivers ays yess Organisation Freshwater Research Unit UCT General Site Visit Information il Water Chemistry Sea Stream Dimensions Substratum Composition Erri Invertebrate Biotopes Christa Thirion Substratum Composition Embeddedness 0 25 Material 0 Absent 0 Absent 2 Sparse 2 Sparse 0 Absent Absent Absent 0 Absent Resource Quality Services DWAF Version 3 0 2711 17771 Logged on User Helen Dallas Screen 4 21 Substratum composition 32 Rivers Database Version 3 2007 Rivers Helen Dallas Freshwater Research Unit UCT Christa Thirion Resource Quality Services DWAF X3SABI BRAND 1999 05 20 00 00 ER E LJ General Site Visit Invertebrate Biotopes Information Ex Summarised River Make Up Water Chemistry Biotope Abundance Rating Ex Stones in current SIC 4 Abundant Stream Dime
93. k 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 and click the Save button Note the names or incorrect river name allocation Drainage region of the new river must match
94. 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 letters 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 corresp
95. location e Click on the Rivers Server icon on the Desktop this will open Internet Explorer which will display the login screen to Rivers Server e You should also run the upgrade facility Start Program Files Rivers Database 2007 Rivers Upgrade to receive the latest updates System access is controlled via compulsory User Registration and new users need to register before being able to access either the Rivers Server web site or Rivers Client Desktop Once registered the user will receive a username and password that can be used to log onto both the Rivers Server and Rivers Client To register as a new user e Start Rivers Server e Click on Click here to register as a new user e 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 e Enter the username and password and click 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 71 R
96. ndary 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 fields 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 cs
97. nformation 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 the 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 comment
98. nic 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 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
99. nsions Stones out of current 5000 2 Sparse Marginal vegetation unspecified 2 Sparse Aquatic vegetation 0 Absent Gravel 2 Sparse Composition Sand Silt mud 2 Sparse Invertebrate Biotopes Invertebrates led Fish Version 3 0 2711 17771 Logged on User Helen Dallas Screen 4 22 SASS and specific biotopes Rivers Spee Biotopes Select SASS Biotope to which specific Biotopes can be a Specific Biotope In channel Eerste G2EERS JONKE Elands 2006 06 28 Bossink A2ELAN LINDL 2006 06 28 00 00 LL User aus pueas EE 4bx Organisation Owner Hermien Roux Stream Dimensions North West Province Nature Conservation Assessor Hermien Roux North West Province Nature Conservation DACET General Site Visit Taxon Abundance Information Invertebrate Data Ownership il isil CASS Vers Ex Site Visit Level SASS Version 4 Gino ee HemenRam ENS Water Chemistry Biotope Level SASS Version 5 Boop M NEN 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 EPHEMEROPTERA BAETIDAE 25 EPHEMEROPTERA CAENIDAE Substratum Composition ODONATA GOMPHIDAE Ex ODONATA LIBEL
100. nsis Valenciennes 1836 Freshwater Mullet M Mugilidae Nmac Nannocharax macropterus Pellegrin 1925 Broadbarred Citharine Distichodontidae Nans Nematogobius ansorgii Boulenger 1910 Spotfin Goby Ms 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 Threespo
101. nt de Villiers Piere deviliersp 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 DickensCGukzn ac za 033 3411151 Dickens Chris Natural Resource Institute DickensC ukzn ac za 033 3411151 KwaZulu Natal ays yeas Ei E Diedricks Gerhard gerharddmwebico za 082 3372312 comment 312 National Gerhard Bio toring es gethardd mweb co 2a 0 3 Dixon Paver 3ci dwaf ntl kantl gov za 031 3362700 Dixon Paver DWAF Kwazulu Natal 3cf dwaf ntl kantl gov za 031 3362700 KwaZulu N 7 du Toit sdt envir infodoor co za 021 3512134 Save du Toit Mogale City Local Municipality sdt envir infodoor co za 021 9512194 Gauteng Undo Row Edit Eckhardt holgere parks sa co 2a 0137354227 Eckhardt South African National Parks Kruger NP holgere parks sa co za 013 7354227 Mpumalanga Ls E 2 ra em s mom SASS Validation Assessor Valid From Valid To Status Gerhard Diedricks 30 Quality Assured Gerhard Diediicks 1 1 2000 12 31 2001 Quality Assured Gerhard Diedricks 1 1 1992 12 31 1893 Unknown Version 3 0 2711 17771 Logged on User Helen Dallas Screen 5 3 Assessor data and SASS Validation Status Rivers
102. of rivers selected if you have a River Name Marite Successful None slow internet connection e g dial up m None Refresh Data None Download Completed None B None Ilf x Crocodile E None E Goudstroom None p None DE Incomati N one Crocodile w E None amp 0E Massintonto None a ME Sabie None gt Avinagamu River Name Shinkwene Successful None Hiuvamaduba River Name Xiharini Successful None 3 River Name Msuthulu Successful None v Klein Sabie River Nemes gt iver Name Musutlu Successful None 0 Langspruit River Name Mtshawu Successful None Lubye Lubye River Name Nyamondwa Successful None v Mac Mac River Name Masalahane Successful None ME Mantsiyane River Name Ngwenyameni Successful None Marite River Name Benjani Successful None River Nhawavi Successful None s River Name Nhlowa Successful None v River Name Makathlanyane Successful None Mhlambanyathi River Name Shimangwana Successful None Mnondozi River Noord Sand Successful None Msuthulu River Mababababa Successful None Mtshawu River Name White Waters Successful None Version 3 0 2711 17771 Logged on User Helen Dallas Screen 5 2 Data Downloading 38 Rivers Database Version 3 2007 Assessors 4 x First Name Organisation Email Telephone Political Region Comme
103. ology 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 95 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
104. onding 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 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 amp http localhost querymaster SelectSphere asp Go Links gt Address Query Master Primary Data Component Selection il Information Select the required Primary D
105. orites 2 m u 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 Current Active Fi 7 Alexanderspruit As Refine search Assegaaibosch Political Bath Baviaans Baviaanskloof Stream Baynespruit Beetgekraalspruit Bellingham Stream Belvedere Creek Berg Biedou River Bietou Big Lotus Black Blauuwklippen Blesbokspruit Blinkwaterspruit Options Null Q EPUM Blystaanspruit Boesmans Number of records 397 Screen 6 5 Select Field values already in the Rivers Database Query Master Microsoft Internet Explorer File Edit View Favorites Tools AN X E yo Search Sie Favorites B wi T Fel 33 Address http fflocalhost querymaster DisplayReport asp Go Links gt Query Master Query Output River Tbtary Late tons 87 GERE Code EXE GE Area Jan Dissel 32 173 18 9 At low water bridge near Clanwilliam town pesi Olifants Doorn ee ded SIMO on Mere orones Hae merde 32 975 19 18389 Boschkloof
106. ource Quality Services Department of Water Affairs and Forestry Republic of South Africa Rivers Database Version 3 A User Manual Department of Water Affairs and Forestry Resource Quality Services September 2007 Directorate Resource Quality Services Department of Water Affairs and Forestry September 2007 Published by Department of Water Affairs and Forestry Resource Quality Services Private Bag X313 PRETORIA 0001 Republic of South Africa Tel 012 808 0374 Co ordinated by Resource Quality Services Copyright Reserved Project Number 2004 157 This publication may be reproduced only for non commercial purposes and only after appropriate authorisation by the Department of Water Affairs and Forestry has been provided Additional copies can be requested from the above address No part of this publication may be reproduced in any manner without the full acknowledgement of the source This document should be cited as Department of Water Affairs and Forestry 2007 Rivers Database Version 3 A User Manual prepared by The Freshwater Consulting Group and Soft Craft Systems for DWAF Pretoria South Africa 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 Department of Water Affairs and Forestry 2007 Rivers Database Data Owners List data owners DOCUMENT STATUS AND APPROVAL WORKING TITLE AUTHORS REPORT STATU
107. ows 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 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
108. p 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 data 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
109. presence Biotopes Sampled IHAS Fish Version 3 0 2711 17771 Logged on User Helen Dallas Screen 4 24 Biotopes Sampled IHAS E Rivers File SiteVisit Tools Window Sabie Elands 9 15 1999 Elands 6 22 2004 9 2 1997 6 21 2007 4 gt x A2ELAN DOORN 2007 06 21 15 05 A User Organisation g Owner Helen Dallas Freshwater Research Unit UCT Assessor Helen Dallas Freshwater Research Unit UCT elt General Site Visit Fish Habitat Fish Data Ownership Helen Dallas Helen Dallas Owner 4 Sampling Effort Invertebrate Biotopes Invertebrates No of adults Infomation Velocity Depth Classes and Cover Present Fish Habitat 54829 Water Chemistry Abundance Rating E Aquatic Macrophytes 1 Rare very poor 5 A Overhanging Vegetation 2 5 5 25 Dimensions I pne Undercut Banks and Root Wads Rare very poor lt 5 x Water column 3 Moderate good 25 75 Substratum Composition Mesh Size No of juveniles Length Depth No of abnormals No of individuals E Biotopes Sampled umpback largemouth 1 e Fish 5 Logged on User Helen Dallas Version 3 0 2711 17771 Screen 4 25 Fish data 34 Rivers Database Version 3 2007
110. r automatically generated Password Confirm password eecccee 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 Qe c x yo Search Favorites im a 33 Address http jwww softcraft co za Rivers Application UserCRUD aspx Links gt T 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 DERT 0 years fo years Other Physico chemistry monitoring geomorphological please specify index Screen 2 3 New Users Registration form Experience component UserCRUD Microsoft Internet Explorer Fie Edit view Favorites Tools A Qe x yo Search She Favortes 2 jw amp 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 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 Req
111. r 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 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 191
112. rmation 19 Rivers Database Version 3 2007 Rivers cese G2eeRS 30NKE 4d x G2EERS JONKE g 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 Ecoregion Southem Folded Mountains Ecoregion Il 19 04 Secondary Catchment G2 Quaternary Catchment G22F Location Details Water Chem Management Southern and Westem Coast Vegetation Type Mountain Fynbos Geological 05 Ske Transaction Contour Range From 380 To 400 Source Distance mJ 2 00 Rainfull Region Seasonal Winter Stream Order 2 DWAF Gauging Station Distance Upstream DWAF Code Distance Version 3 0 2711 17771 Logged on User Helen Dallas Screen 4 6 Spatial Information Rivers Breede HAJAND SOMER 2000 01 15 puerum 11 JAND SOMER N CANTEN General Site Owner Justine Ewart Smith Freshwater Consulting group Information j Location Details Location and Landowner Detail Tum off the R43 Near Goudini and Worcester Spatial Information Notify Owner Oo Contact No Location Details ee nee Permit Required C Permit Details Key Nee
113. rmon road bridge Lower Foothill a E QGIBERG LADYL Upstream of Lady Loch Bridge below Welington Lower Foothill Site Owner Helen Dalas 88 G1BERG PIKET Downstream of roadbridge near Piketberg N7 Lower Foothill Site Code 9 bc ec gt m Koopmans River Search Type vis Site Visit Owner O Main Rivers Only 8 Canal a 2005 02 16 10 00 Toni Belcher 2003 10 27 09 30 Toni Belcher AlRivers i a uim 3 2003 08 28 11 40 Toni Belcher Ij assegaaibosch S Vieren Twintig 2003 04 01 15 25 Tani Becher Beath Sardspruit 1995 10 01 00 00 Helen Dallas Baviaans 3 E Unspeciied 1995 07 01 00 00 Helen Dallas B Unspecified 1995 03 01 00 00 Helen Dallas Mali iz 1994 11 01 00 00 Helen Dallas 3 gt 1994 09 01 00 00 Helen Dallas EF Drs IRIM 1994 03 01 00 00 Helen Dallas eee lj unspecified 2 1994 02 01 00 00 Helen Dallas amp Pletkloot 1993 12 01 00 00 Helen Dallas icurfeljags E Unspecified 1 1993 11 01 00 00 Helen Dallas Forest E 1993 09 01 00 00 Helen Dallas 3 8 Soutkloot 1993 02 01 00 00 Helen Dallas E al E Sout ET mi 0 Unspecified 852 River Search site a Version 3 5 Logged on User Helen Dallas P 4 3 a 5 gt water amp forestry Department Water Affairs and Forestry REPUBLIC OF SOUTH AFRICA Directorate Res
114. s 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 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
115. scription Alongside vineyards on the farm Somersu Longitudinal Zone Upper foothill Justine Ewart Smith 2000 01 15 12 30 wv wner Justine Ewart Smith 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 DER File View Tools Window T Breede 4px F Breede Site Code Site Description Longitudinal Zone Owner 8 a Breede HIBREE CERES Near golf course below Ceres Upper foothill Helen Dallas 2 3 H1BREE WITBR At roadbridge near Mitchells Pass road below Upper foothill Helen Dallas g H1BREE SLANG Low flow bridge at Slanghoek tum of Ceres w Upper foothill Helen Dallas 3 HIBREE WYSERS Downstream of bridge south of Wysersdrift Lower foothill Justine Ewart Smith B H1BREE NEKKI SSS Lower foothill Helen Dallas E H4BREE LECHA nea Lower foothill Helen Dallas H5BREE SECUN a on road f Lower foothill Helen Dallas H5BREE DREWB Lower foothill Helen Dallas E H4BREE MOORD i Lower foothill Justine Ewart Smith 3 HSBREE ABBEY u s of confluence with Riviersonderend at the Lowland river Geordie Ractliffe H BREE SWELL Hidro sign immediately before Swellendam ont Lowland river Helen Dallas E H7BREE NAPYK On farm Napyksmond on road to Cape Infanta Lowland river Helen Dallas SURE 2
116. se Version 3 2007 eal Lithostratigraphic Unit Principle Rock Types Malmesbury Group Tygerberg Franschhoek Klipheuwel Shist phyllite phyllitic shale shale limestone sandstone greywacke conglomerate 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 R
117. seotecenssguacenoatesseess 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 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
118. setup exe on the CD 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 70 Rivers Database Version 3 2007 Redirecting the Rivers Dbase to the Rivers Website Registering as a New User on the Rivers Database website and follow the prompts if an error is displayed make sure IIS is installed as described above In some cases it may be necessary restart the computer during the installation process The installation process will continue automatically following the reboot 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 A connection update needs to installed before the Rivers Database is functional The update can be downloaded from http www riv co za Files ServerConnection serverconnect zip The file needs to be unzipped and the files extracted It has a readme file that explains where to copy the files Steps to upgrade your Rivers Server connection e Extract ServerConnect zip to a location on your hard drive e Copy the five extracted files to C Program Files Softcraft Systems Rivers folder You will be prompted to overwrite existing files this will ensure that you are copying the files to the correct
119. shale conglomerate greywacke lava pyroclastic rocks Gravelotte Group Ultramafic mafic and acid lava tuff schist conglomerate quartzite Giyani Group Ultramafic and mafic lavas schist Kraaipan 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 Arse
120. sit 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 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
121. 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 yeas Ei E General Site Visit Information 0 19 9 Water Chemistry 0 Stream Dimensions 0 n Sul Composition 5 2 2 3 0 1 Invertebrate Biotopes al 9 9 Invertebrates 0 19 Biotopes Sampled Fish X3SABI BRAND 1999 07 13 10 30 Helen Dallas Freshwater Research Unit UCT Christa Thirion Resource Quality Services DWAF General Site Visit Information Water level at time of Sampling Significant rainfall in the last week Rain Comment Canopy Cover Canopy Cover Comment Impact on Stream Habitat Channel flow organic debris Moderate flow Velocity and discharge estimates Average Velocity ms 1 Average Depth Discharge m3s 1 1 Score Source Limited Local Comments Version 3 0 2711 17771 Rivers Logged on User Helen Dallas Screen 4 18 General Site Visit Information ays yueas Sabie 7 13 1999 User Organisation Helen Dallas Freshwater Research Unit UCT
122. stappersii Boulenger 1915 Blotched Catfish Clariidae Cthe Clarias theodorae Weber 1897 Snake Catfish Clariidae Csup Clinus superciliosus Linnaeus 1758 Super Klipfish Ms Clinidae Cwit Coptostomabarbus 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 Cithar
123. t gt Screen 6 2 Secondary Data Component Combine Components 43 Rivers Database Version 3 2007 A Query Master Microsoft Internet Explorer File Edit View Favorites Tools Help ae Q n JO search Sg Favorites p rel 3 Address http localhost querymaster SelectFields asp _ ve Links gt 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 or Clear All Available Fields Seb Clear All Component Information Site Select All Clear All 4 RHP Site Code String Project Site Number String Owner String d 4e River String Tributary of String D LatitudeGIS Number 4e LongitudeGIS Number ivi Site Description String D Map Reference String L D Site Length Number 4 Altitude Number D Longitudinal Zone String Screen 6 3 Available fields for selection Query Master Microsoft Internet Explorer File Edit View Favorites Tools ay Qs c JO search Sg Favorites
124. t Tilapia Cichlidae Oaur Oreochromis aureus Steindachner 1864 Israeli Tilapia Ex Cichlidae Omor Oreochromis mortimeri Trewavas 1966 Kariba Tilapia Cichlidae Omos Oreochromis mossambicus Peters 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
125. 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 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 Form
126. 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 password 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
127. 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 goto a specific tributary click on the tributary name in the list Tributaries of the selected river and sites may be viewed e To navigate
128. 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 Quick guide Appendix 6 Frequently Asked Questions Appendix 7 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 version 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
129. ubb 1959 Pungwe Chiselmouth Cyprinidae Xhel Xiphophorus helleri Heckel 1848 Swordtail Ex Poeciliidae Introduced Xmac Xiphophorus maculatus Gunther 1866 Platy Ex Poeciliidae 69 Rivers Database Version 3 2007 Appendix 6 Quick guide for obtaining installing and using the Rivers Database Before RHP data can be captured and stored in the Rivers Database RHP practitioners need to acquire a copy of the Rivers Database software and install the database The process to follow is described below Obtaining acopy RHP practitioners need to contact the RHP Programme Manager at Resource of the Rivers Quality Services Department of Water Affairs amp Forestry Tel 012 808 9500 to Database CD obtain a CD of the Rivers Database The manual and other relevant documentation is included on the CD Insert CD in CD Drive Cancel Rivers setup wizard Browse to the CD drive and Open save the relevant pdf file Software and The Rivers Database is a custom programme that runs within the Windows 2000 Hardware XP Professional and Windows Vista environments The Software and Hardware requirements Requirements are as follows e Operating System preferably Windows 2000 or Windows XP Professional with Service Pack 2 installed or Windows Vista e Internet Information Server must be installed e Memory minimum of 256 RAM e Software Microsoft Office 2000 or greater e Minimum Screen Resolution 1024 x 7
130. ubgroup 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 Uitdraai 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
131. uest system access First name New Surname User Organisation Province Telephone Fax Email Postal Address CapeNature Western Cape 021 5555555 021 4444444 New User organisation org 10 New Street 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 original 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
132. uide 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 details 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 t
133. v 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 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 Databa
134. vers Database Version 3 2007 Code Scientific Name Common Name Family Status Band Barbus 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 Giinthe
135. 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 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 in
136. xample 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 secondary 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 seco
137. y Alluvial with dominant type s Channel Type Details Channel Type Details Cross Sectional Feature Present Right Present Left High terrace rarely inundated Terrace infrequently inundated Flood Bench inundated by annual flood ai Island vegetation Secondary or lateral channel Flood plain inundated by annual flood Hillslope abutting onto active channel Resource Quality Services DWAF Logged on User Helen Dallas Version 3 2 2733 17643 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 Ownership 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 r
138. 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 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 dro

Download Pdf Manuals

Related Search

Related Contents

Monitor    CARMEN® Modo de empleo  Samsung GT-I8530 Vartotojo vadovas  り安全上のご云 意  Samsung SE-W164C Benutzerhandbuch  1 業務の概要 2 業務箇所 佐久市岩村田1862番地1 3 品名・数量 別紙  Apparatus for topical negative pressure therapy  Kenmore 8543543 Washer User Manual  Guide d`utilisation  

Copyright © All rights reserved. Failed to retrieve file