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