I-4_Water Quality Web Portal_Userguide

Water Quality Web Portal
The City maintains a web portal for the storage and distribution of sampling information, field
measurements, and laboratory results for water and sediment quality samples. This web portal may be
accessed at http://www.durhamwatergualitV.org/. The Web Portal offers public access of information
following the creation of a user account. The Web Portal also allows City staff to perform common data
management tasks including reviewing, approving, and qualifying data prior to publishing. Data and
summary statistics can also be downloaded through this interface. The steps to creating a user account
are outlined below.
Creating an account and logging in to the web portal
1. Use any web browser to go to: www.durhamwaterguality.org.
2. Accept the Disclaimer by checking the box, then clicking the "I Read and Understand the
Disclaimer".
I Disclaimer Although Stormwater
Services makes every effort to ensure data
quality in the monitoring program, errors do
arise and may not be identified at the time the
data was uploaded to this database. The City
of Durham does not assume any liability
associated with the use of these data and is
not obligated to notify parlies of modifications
or changes to the database.
Figure 1 Web Portal disclaimer.
3. The user will be taken to a login screen (Figure 2). To create an account, click on the "Help" link
next to "Don't have an account?". To login to an existing account, enter the username and
password and click the "Login" button on this same window. There are three additional links for
maintaining an existing account: "Forgot your username?"; "Forgot your password?"; and
"Change your password?"

o �v ofr,w�4u x
F - G' I O Not secure I www.durhamwaterqua€ily.org
Mps :: CoolH.- ❑ wehportal M NEOGOY I� wmken.rl 4 ourham,INC -GONrepe CO Courses C) eateSciertceCaases', ID GIs-w4 0 u
Water Quality Data Web Portal ---- City of Durham
Sign in to access data.
Username
Password'
Login
Don't have an account? Help
Forgot yourusername? Help
Forgot your password? Help
Change your password? Help
Figure 2 Login screen
4. After clicking on the "Help?" link to create a new account, a registration form will appear (Figure
3). Fill in all fields. It is recommended that City of Durham staff use their work address, work
email, and enter "City of Durham Public Works" as their Organization. Select and enter a
username and password.
atrap�n�, wale. Q. x
E G' O Not secure www.durhamwaterquakity.crg/sgnup.php
C=I... [� --w © nrmov Ija] —:�i g - 1— t; ars Q ® c
Register for City of Durham's Water Quality Data Web PWal_
Please fill out the fields to gain access
to the application. 'All fields are required_
Name':
Address'
City`-
Stale or Country'_
I
Zip'.
C
Organization':
Email'.
I
Usemame*_
Password':
0
Confirm Password*_
0
Sign Up
Already signed up, Login Here
Figure 3 Registration form

5. Click "Sign Up". You will receive the message shown below. Click the "HERE" link in the message
to return to the main web page and log in with the newly created username and password.
,Reg s'e,ed
Thank you. your information has been added to the database.
You may now log in
Figure 4 Registered notification
6. The Web Portal has three user levels:
o Level 1 (General Public): Allows querying and downloading data, getting basic summary
statistics, and viewing pre -staged graphs. New users are assigned Level 1 access by
default.
o Level 2 (Super User Level 1): In addition to Level 1 access, allows uploading data files
and limited access to certain data tables. All City of Durham Water Quality Unit staff
should have at least Level 2 access.
o Level 3 (Super User Level 2): Allows full access to all tables and functions in the web
portal, including: quality assurance review and release of uploaded data, modifying
access level for registered users, and updating/maintaining all modifiable tables. Level 3
access is generally limited to the Water Quality Managers, Environmental Planning &
Compliance Analysts, and Environmental Planning & Compliance Coordinators.
Data Qualification
Following collection of samples by field staff, field measurements and laboratory results are compiled
into existing templates for data upload. This step is usually performed by the Coordinator responsible
for the sampling event or project. Initial QA/QC checks are also performed as part of this process. Final
approval and release of uploaded data is performed by the Level 3 User responsible for the project or
program, generally this is the Monitoring and Assessment Program Supervisor. Data qualifier codes may
be assigned based on results from field blanks or other QC samples. Blank data evaluations generally
follow recommendations outline in Chapter 5: Data Evaluation of the Risk Assessment Guidance for
Superfund Sites published by the USEPA. Qualifier codes are shown below in Table 1. It should be noted
that any result given an "R" code will be hidden from Level 1 and Level 2 users, and will not be included
in any summary statistic calculations or graphs.

Table 1 Data Qualification codes
Qcode Description
Microbial tests Results based on colony counts outside of the acceptable
B membrane filter (MF) range and should be used with caution.
counts
Microbial tests Countable membranes w/ less than 20 colonies. Reported
B1 membrane filter (MF) value is estimated or is a total of the counts on all filters
counts reported per 100mL.
Counts from all filters were zero. The value reported is based
Microbial tests on the number of colonies per 100mL that would have been
B2 membrane filter (MF) reported if there had been one colony on the filter
counts representing the largest filtration volume ( reported as
value).
Microbial tests Countable membranes with more than 60 (or 80) colonies.
B3 membrane filter (MF) The value reported is calculated using the count from the
counts smallest volume filtered (reported as a ">" value).
Microbial tests Filters have counts of both >60 (or >80) and <20. Reported
B4 membrane filter (MF) value is a total of the counts from all countable filters
counts reported per 100mL.
Too many colonies were present / too numerous to count
Microbial tests (TNTC). The numeric value represents the max number of
B5 membrane filter (MF) counts typically accepted on a filter membrane (60 or 80),
counts multiplied by 100 and then divided by the smallest filtration
volume analyzed (reported as a ">" value).
Microbial tests
B6
membrane filter (MF)
Estimated value. Blank contamination evident.
counts
D
Dilution
Sample analyzed at dilution.
E
Exceeded Calibration
Analyte concentration exceeded the calibration of the
instrument for that specific analysis.
G1
Dilution Water Blank
The DO depletion of the dilution water blank is > 0.2 mg/L
G5
Glucose/glutamic acid
The glucose/glutamic acid standard was outside the 198 +/-
standard
30.5 mg/L range.
<1 mg/L DO remained for all dilutions set. The reported value
G7
Over -depletion
is an estimated > value and is calculated for the dilution
using the least amount of sample
Oxygen Usage <2 mg/L for all dilution sets. The reported
G8
Under -depletion
value is an estimate < value and is calculated for dilution
using the most amount of sample.
The reported value is less than the laboratory Method
J
Estimated
Reporting Limit (MRL) but greater than or equal to the
Method Detection Limit (MDL)
J1
Estimated
Surrogate recovery limits have been exceeded

J10
Estimated
Field meter did not calibrate or post -check within specified
range.
J2
Estimated
The reported value failed to meet the established QC criteria
for either precision or accuracy
J3
Estimated
The sample matrix interfered with the ability to make any
accurate determination.
J4
Estimated
The data is questionable because of improper laboratory or
field protocols
J5
Estimated
Temperature limits exceeded (samples frozen or > 4 C)
during transport
J6
Estimated
Laboratory analysis was from an unpreserved or improperly
chemically preserved sample.
J7
Estimated
Blank contamination evident, value may not be accurate
The reported value is determined by a one -point estimation
A
Estimated
rather than against a regression equation. The estimated
concentration is less than the practical quantitation limit and
greater than the method detection limit.
The parameter concentration exceeded the limits of the
OR
Over -range
instrument. The reported value is the upper limit of the
instrument.
P
Elevated PQL due to matrix interference and/or sample
dilution
Q
Holding time exceeded
Holding time exceeded
Q1
Holding time exceeded
Holding time exceeded prior to receipt by lab
Q2
Holding time exceeded
Holding time exceeded following receipt by lab
R
Rejected
Sample rejected due to blank contamination exceeding value
reported
S
Field filtration
contamination
Suspected contamination during field filtration.
U
Non -detect
The contaminant was not detected at a concentration greater
than the detection limit
X
Not analyzed
X1
Not analyzed
Sample not screened for this constituent
X2
Not analyzed
Sampled, but analysis lost or not performed - field error.
X3
Not analyzed
Sampled, but analysis lost or not performed - lab error
Y
Elevated PQL due to insufficient sample size
Sample results are rejected due to serious deficiencies in the
Z
Rejected
ability to analyze the sample and meet QC criteria. The
presence or absence of the analyte can't be verified.