Download Rivers Database Version 3 A User Manual
Transcript
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 A1 RHP The desired query output for the specific query outlined in this section. Sampling Site code Date Secondary catchment code SASS GIS GIS Longitude Latitude Data Version SASS4 Score Number ASPT of Families pH Values Once the Query Master has been opened, the steps below are followed to extract the data required to meet the specifications outlined above for this example. 1 Select the correct primary component. In this example, the “Information - Site Visit” primary component is selected because it contains both site specific data (i.e. the site code and secondary catchment) and site visit specific data (i.e. sampling date). Click “next”. This opens the “Select Secondary Components” form. 2 Select appropriate secondary components to combine with the “Information - Site Visit” primary component. The following secondary components are selected: • “SASS scores by Site: Full data” (contains SASS scores, ASPT and Number of families, regardless of biotopes), • “Chemistry: Values only” (contains the pH values), Click “next”. This opens the “Available Field Selection” screen. 3 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: • RHP Site code • Sampling date • GIS Latitude • GIS Longitude • Secondary Catchment Code b) Secondary component: Chem: Values only • pH c) Secondary component: SASS scores by site: full data • SASS Data Version • SASS Score 53