WQX User Call
April 25, 2019
12:00-1:00 PM EST
202-991-0477 ID: 4189172
Webinar: http://epawebconferencing.acms.com/wqp/
There were approximately 27 participants.
Next WQX User Meeting: Thursday, May 23, 2019
Agenda:
1) Freshwater Explorer Demo - Susan Cormier, OST
2) Domain Value Change Notification Alert FTP Site -
ftp://newftp.epa.gov/storet/wqx/domain alerts/
• Characteristic and Taxonomic names
• deprecated, retired, and duplicate value resolution
1) Freshwater Explorer Demo - Susan Cormier, OST
PowerPoint Presentation is available at:
ftp://newftp.epa.qov/storet/xfer/How/2019-04-25/
WQX_presentation_Freshwater_Explorer_20190422. pptx
The Freshwater Explorer is an interactive web-based tool that provides the status of salt and
mineral content in freshwater resources for streams in the lower 48 states. The data is
comprised of both WQX and NWIS data from WQP.
The tool was developed to make salt and mineral content information more accessible to users
by providing information on the status of water resources for a network of steams and predicting
and measuring freshness. Susan explained how the model was created and discussed the
issues found with the data reported in WQP. When ORD started they tossed 50% of the data.
Then they decided to flag data with issues.
Erroneous data such as salt contents with negative counts, data reported as |jS/cm but likely
measured as mS/cm need to be addressed. Susan asked data stewards to review their data by
reviewing the spreadsheet she referenced. Data is broken down by state and each organization
is listed. The spreadsheet contains a worksheet to select the link to and query the questionable
data in
WQP.
The spreadsheet is located at: ftp://newftp.epa.qov/storet/xfer/How/2019-04-25/
WQP_Data_Summarization.xlsx
The plan is for ORD to release the application. ORD would like feedback on the application and
data stewards to help cleaning up the data flagged for issues. ORD would like pull the data
WQX Monthly User Group Call - April 25, 2019
1
-------
from the WQP again before publishing the Storybook. ORD also plans to make an explorer
tools for other parameters such as nitrogen.
Susan opened the floor to questions:
• Dwane Young reminded data stewards that WQX business rule require the entire
sample to be uploaded. Correction submissions for Individual results require the
uploading the entire sample. If the entire sample is updated, it will overwrite all the
information for that sample.
• Dwane confirmed that the |jS/cm to mS/cm units are input into WQX that way and are
not translated by WQP. If it goes into WQX that way, then it comes out in WQP that
way.
2) Domain Value Change Notification Alert - Kevin Christian
ftp: //n ewftp. e pa. g ov/storet/wqx/do m ai n a lerts/
a. Characteristic and Taxonomic names - are impacted by our reference systems
SRS Characteristics, Taxon - ITIS and Bio Data
b. deprecated, retired, and duplicate value resolution
One of the challenges in stewarding WQX domain values is communicating domain changes to
the user community.
Characteristics and Taxonomic names are updated on a daily basis. They are impacted by
reference systems, SRS for Characteristics and ITIS and Biodata for Taxonomic names.
The WQX will leverage the ftp site to keep the user community informed on updates to
Characteristics and Taxonomic domains. An update for Characteristic changes was recently
sent out. Kevin is hoping to release an update for Taxonomic name changes and the impacts to
organizations.
ITIS system is fully vetted. Diatoms are always changing and ITIS tracks this information. Kevin
references ITIS for retired diatoms. He retires Latin names that are synonyms of valid taxon
names. Kevin explained he has had to unretired names as they have been made valid after they
were flagged to be retired.
Kevin asked users to provide feedback on the Domain Value Change Notification process.
Enclosed is the PowerPoint presentation for Freshwater Explorer Demo - Susan Cormier, OST
WQX Monthly User Group Call - April 25, 2019
2
-------
Freshwater Explorer
a database story map
Susari Cormier, NCEA
Chris Whartori and Isabella Bertani, TetraTech, Inc.
John Olson, CSU Monterrey Bay
-------
What is the Freshwater Explorer?
The Freshwater Explorer is an
interactive-web based platform that
provides the status of the salt and
mineral content (i.e., freshness) for
freshwater resources across a
network of streams in the
contiguous 48 states.
Freshness, defined as conductivity,
are presented as color-coded
predicted stream reach values and
point (site-specific) measured
values.
Juxtaposing background and
measured conductivity over satellite
imagery lets users see patterns and
otential factors associated with
resh water conditions.
If,
X I
i Predicted Background Conductivity : 1
1 Medicine Dow River
1 COMID
15965529
Stream Name
Medicine
Bow River
1
% p£/trn
I ftfw kgr a md (cmdut tivity
1 Stream Type
StreamRJver 1
COMID
Stream
Name
Organization
Abbreviation
Organization
Name
15968529
Medicine Bow River
WYDEQ_WQX
State of Wyoming
Department of
Environmental Quality
Watershed Program
D WYD EQ_W QX-S R6
rype River/Stream
44,5 pS/cm
44.5 pS/cm
44.5 pS/cm
1 r~-\
-------
Why was the Freshwater Explorer developed?
• Currently, this type of data is stored in EPA's Water Quality Portal, but is not
very accessible or intuitive in a spatial context.
How was it developed?
• To enable self-sufficiency and greater access, scientists at ORD developed national
datasets that let users independently compare background and measured water
freshness (i.e., conductivity).
• Methods and approaches were published in peer-reviewed journals.
• The national datasets were derived from conductivity data in OWOW's signature
Water Quality Portal. Presently, more than 400 monitoring groups contribute data
to the (WQP) resulting in a spatially and temporally robust dataset.
• The national datasets are presented as an interactive StoryMap.
• OST, OWOW, Regions 3, 5, 6, 9, and 10 were consulted during development or
reviewed the Freshwater Explorer
-------
Who are the primary audiences?
National Water Quality Monitoring Council
Working together for clean water
The 400+ entities that contribute to the
WQP
Federal, state, local agencies, monitoring
groups, NGO's, and industry with a need
to access local water quality data.
Audience requires some degree of
technical knowledge.
Water Quality Portal
The Water Quality Portal (WQP) is a cooperative service sponsored by the United States
Geological Survey (USGS), the Environmental Protection Agency (EPA), and the National Water
Quality Monitoring Council (NWQMC). It serves data collected by over 400 state, federal, tribal,
and local agencies.
DOWNLOAD
DATA
Download water-quality data in
Excel, CSV, TSV, and KML
formats.
HOW TO USE THE WQP
User Guide
Web Services Guide
FAQs V
Upload Data
NATIONAL RESULTS COVERAGE
Water-quality data in your state.
ABOUT THE WQP
What is the WQP?
Contributing organi
Other Water Quali
Explore WQP Sites
VQP£ fff
fe/rfi
iUSGS vvEPA
Environmental Protection
-------
What are the anticipated uses and benefits
of the Freshwater Explorer?
• It provides information on the status
of water resources for a network of
streams in the contiguous 48 states
color-coded for predicted and
measured freshness, i.e., low salt and
mineral content.
• Currently, only measured conductivity data is provided, a measurement of
fresh water and water quality that is stored in EPA's Water Quality Portal.
• The web-based story map allows users to quickly access information about
estimated background and measured conductivity.
-------
Observations
Nationally, wetter and higher elevation
portions of the country have naturally fresher
water, particularly in the Northwest, East and
Southeast.
• Measured conductivity in these areas are often
near predicted background conductivity.
In the arid West and agricultural Mid-West,
predicted conductivity is greater.
• Measured conductivity often is greater than
predicted natural conditions owing to various
sources of mineral loadings
Locally, there are a variety of apparent causes
of increased conductivity including road
deicing, marine intrusion, agricultural, urban
and industrial releases and run-off
-------
Changes in Freshness compared to Background
Measured less than or no more than Measured 500 microS/cm greater
100 microS/cm > predicted Background than predicted Background
Causes may include: sea water intrusion, drought, loadings, etc.
7
-------
Local Example
??***•
V LEGEND
o
° ° o°°£>#
5@cJo £°
*o ^°<§!
*•••
- °*\£A-
^ i-^oq
-------
Freshwater Explorer Example
Courtesy of: Matt Wood, Assessment Coordinator
NH Department of Environmental Services
°o
o
d
Mean
Median
Min
Max
Conductivity
Samples
Last
Measurement,
Date
Last Measi
Conductivity
Average
Predicted
Background
Conductivity
66300 uS/cm
66300 uS/cm
57400 uS/cm
75200 uS/cm
2
1%
75200
iS/cm
31.9 pS/cm
Predicted: 31.9
|iS/cm
-------
Salt pile was removed
and covered salt
storage was built
-------
Plans are to delist from 303d
after a bit more monitoring
0
r
\
O cm
s s s
8 8
o
8
«r
8
8 8
o
H
O
ft
~A
•40
-35
THORN HILL BROOK
(NHRIV600020104-04)
-30 -
\
5
¦o
c
-20
0
>
¦
-15
a>
+•*
-10 I
L o
-"Current" line for
2018
CI Chronic
—
-CI Acute
~
Chloride
¦
WSI per the 193
TM0L approach
(Concord Mun.
Airport)
Chloride level
decreased
dramatically after
moving pile away
from stream and
covering some of it
O
Winter Severity Index
Courtesy of: Matt Wood, Assessment Coordinator
Chloride (mg/L) NH Department of Environmental Services
ii
-------
Freshwater Explorer has 3 Data sets
1. Results of a model that predicts natural background conductivity
from empirical data (Natural Background Stream Conductivity
(NBSC) Model).
2. Measured data (National Conductivity Dataset) from the EPA Water
Quality Portal (WQP), the nation's largest source for water quality
monitoring data.
3. Measured data (Measured Conductivity - NWIS) from the National
Water Information System (NWIS) collected by USGS.
12
-------
Brief Explanation of the Empirical
Background Conductivity Model
estimated based on geology, climate, soil,
vegetation, topography, and other factors
Modeling Spatial and Temporal Variation in Natural Background
Specific Conductivity
John R. Olson*' and Susan M. Connier
-------
Monthly Climate
Landscape Data Data 2000-2015
Regression Tree Analysis
lES&f
Rock
%CaO
Rock
%S
Atm Ca
Dep
Water
Table
Depth
% Grass
Soil K
Factor
Rock
Strength
% Clay
%
Shrub
%
Conifer
%
Mixed
Forest
Soil
Perme-
ability
6 Mo
Avg
Precip
2 Mo
Prior
Max T
12 Mo
Avg ET
Max T
% Herb
Wetland
3 Mo
Avg
Precip
1 Mo
Prior
Precip
2001
2015
Mean Predicted Natural Conductivity
Predicted and Observed
Conductivity in Wet and Dry Periods
-------
Clean-up process for Measured Data
Remove SC values < 0.
SC values are positive and cannot be
negative
Remove SC values reported with units different
from Siemens or mho
Considered ambiguous.
E.g., SC reported as NTU, or °C
Convert remaining SC values to |iS/cm
(e.g., values as mS/cm were multiplied by 1000).
Allowed direct comparison among
samples
Flag sites with SC values < 10 |iS/cm as uncertain
(gray circles)
Identified data reported as |iS/cm but
likely measured as mS/cm
Flag SC values > 5000 |iS/cm (grey circles).
Data reported as mS/cm but likely
measured as |iS/cm, brine, or marine.
15
-------
A1 lent own |
Chester
Flag SC values > 5000 [iS/cm
(grey circles)
Station Type
Conductivity
Samples
Mean
Median
Max
>i \
Last
Measurement
Date
Lake
32000 pS/cm
32000 |jS/cm
32000 pS/cm
32000 pS/cm
5
9/19/2007
Last Measure 32000 |iS/cm
Conductivity
Average Predicted 77.7 pS/cm
Background
1 \\
Data reported as mS/cm
but likely measured as |iS/cm,
or is brine or marine.
I LWTadilla
V LEGEND
Rob
o Station Type
River/Stream
34,5 pS/cm
34 pS/cm
31 pS/cm
37 pS/cm
11
Mean
Median
Conductivity
Samples
12/7/2010
Last
Measurement
Date
[iS/cm
31
Last Measure
Conductivity
Average Predicted 77.3 pS/cm
Background
-------
o
o
o o
% ©o"
° o
00.0° 6>
o °
f as |iS/cm but likely
measured as mS/cm ^
01
o
oOQ
o °
o
o
o
°° °o
© OO o
0 99
$
O^tQ
0 8 , o, w
$6 8
4 Max
K
Conductivity
Samples
0.4 pS/cm
5
e
O^
Last Measurement 9/21/2009
Date
o
o
D ©
QQD
OO
O
<9
Last Measured
Conductivity
Average Predicted
Background
Conductivity
0.3 pS/cm
176.8 pS/cm
O O
Oq & co
n
All^ce O Q
gd
&
o
>pencer
Storm Lake
-------
o
o
% ©o"
° o
oo_qo &
o
a
^ ° O 00,0^ 6> 0
But, some may still 0o
be there, especially
near the 10 |aS/cm
threshold.
as -
c%°c
M
to
o8d wcP °cg
0 %0
M'Q 0 O
gd
spencer
Storm Lake
O
O 00<
vO^OopO -n
o
°Q& ©ear-m^he^ioSge ^re^<~ps
-------
Charles'
:onductivity
am pies
River/Stream
17515 MS/cm
8281 [iS/St
47.8 |iS/cm
5100
Stat on Type
Mean
Median
10/17/2017
Last
Measurement
Date
Last Measured 25655 pS/cm
Conductivity
85,4 pS/cm
Average
Predicted
V OVERVIEW MAP
Probably tidal
LEGEND
Esri, HERE, Garmin, NGA, USGS, NP5 j Esri, HERE, NPS
-------
-------
Check water body type
/ \
Station Type \ Stream )
Conductivity
Samples
75 pS/cm
70 pS/cm
19 pS/cm
152 pS/cm
22
Last Measurement 9/18/2006
Date
Last Measured
Conductivity
33 jjS/cm
jfal
Station Type(^
Mean
\
Estuary )
~$3"557". £T pS/cm
/Tl
Median
51112 pS/cm
Min
45426 |jS/cm
rGb
Max
69255 pS/cm
>
Conductivity
Samples
13
Last
12/4/2007
21
-------
V LEGEND
^n0 'nCOrreCt
^%!i v un't entfycan
affect the mean >^45/
Station Type J~\4
-*S> /
1978.7 [iS/cm
49 ^S/cm
36 jiS/cm
27080 |iS/cm^*v 1
ii n —
14
12/3/2014 J , ,
Mean
Medi
Conductiv
Samples
Last
Measurement
Date
Last Measured 62 pS/crn
Conductivity
Average Predicted 60.7 pS/cm
Background
-------
QUESTIONS ABOUT DATA ENTRY
Organization
Formal Name
Samples
Sta.
Min.
Cond.
Max.
Cond.
Mean
Cond.
Cond.
In
Other
Units
Cond.
Samples
< 10
Cond.
Samples
>5000
Potentia
My
Exclude
d
for
Units
Potentially
Excluded
for Value
6
1
0
0
0.00
0
6
0
0%
100%
No data or zero
conductivity?
1848
49
271
58600
16481
0
0
858
0%
46%
Mix of fresh and
estuarine?
1347
52
235
58800
16425
0
0
618
0%
46%
Duplicate entry?
4068
1719
5
59590
31612
0
5
3475
0%
86%
Min of 5 entered
as |iS but is mS?
18819
40
0
56
9.21
0
12439
0
0%
66%
Measured as mS
recorded as |iS?
86
3
1
568
335
1
3
0
1%
3%
Incorrect units
FL
City of Lakeland,
Lakeland Florida
489
21
45
273
172
0
0
0
0%
0%
Fresh,
looks correct
FL
CITY OF MARCO ISLAND
44
6
48356
53220
51453
0
0
44
0%
100%
marine
-------
B *5'
WQP_Data_Summarization sorted .xlsx - Excel
1 Home
Insert
Page Layout
Formulas
Data
Review View
Help
Q Tell me what you want to do
D'0
& Cut
% Copy ¦»
x Format Painter
Clipboard rM
Calibri
]n - K fC — =B -
! Wrap Text
Percentage
Comma
en n~L
«-m aV
ffl eP
How to check and make corrections
¦
ccr
Insert Delete Forme
M422
0,4^-t-o^
A
A
B
c
D
E
F
G
H
"
J
*
L
M
1
Geographic
State
Organization Formal Name
Samples
Stations
Min.
Conductivity
Max.
Conductivity
Mean
Conductivity
Conductivity In
Other Units
Conductivity
Samples
<10
Conductivity
Samples
>5000
Pontentially
Excluded
for Units
Potentially
Excluded
forValue
2
L?
[~
!~
~
~
~
[~
~
[~
|Ti
3
AK
Alaska Department of Environmental Conservation (BEACH)
213
12
8
39396
10722.46
0
1
86
0%
41%
4
AK
Alaska Dept of Environmental Conservation - Water Quality
115712
141
0
816
97.82
4
1630
0
0%
1%
5
AK
Alaska Monitoring and Assessment Program
7268
281
0
3417
22.15
480
6283
0
7%
86%
6
AK
Alaska Soil and Water Conservation District
88
51
0
270
82.64
0
2
0
0%
2%
7
AK
Chickaloon Native Village
66
16
0
1
0.14
0
66
0
0%
100%
8
AK
Craig Tribal Association
264
6
0
120
2.80
0
252
0
0%
95%
9
AK
Environmental Monitoring and Assessment Program
2134
16
2
4
3.01
2134
2134
0
100%
100%
10
AK
EPA National Aquatic Resources Survey (NARS)
2363
18
-99
4
18.71
2363
2363
0
100%
100%
11
AK
Georgetown Tribal Council
149
25
4
413
160.10
0
4
0
0%
3%
12
AK
Kenai National Wildlife Refuge
4356
33
0
536
77.11
0
288
0
0%
7%
13
AK
Kenai Watershed Forum
569
22
18
29398
343.63
0
0
11
0%
2%
14
AK
Levelock Village
68
3
31
67
46.93
0
0
0
0%
0%
15
AK
Seldovia Village Tribe
75791
44
0
173
47.38
488
912
0
1%
1%
16
AK
State of Alaska, Department of Environmental Conservation
554
67
0
8778
170.75
0
200
2
0%
36%
1 "7
A f
I ICfZC A l-irl", UMnr Crinnrn Tnntnr
*71 m
oon
Q
TfiAAAn
TO
n
<;
1 0
no/.
no/.
WQP Data Query Access
WV
USGS West Virginia Water Science Center
2838
684
22
5380
409.40
0
0
2
0%
0%
wv
West Virginia Department of Environmental^! \on Watershed Improvemen
1332
13
2
2630
339.80
0
3
0
0%
0%
WV
WV Div of Environmental Protection. OHflfHKier Resource
4079
2171
2
9138
402.45
0
14
5
0%
0%
WY
Colorado Dept. of Public Health & e/ ^ >^rt
21
2
27
330
85.29
0
0
0
0%
0%
¦ -i " --m f—
804
805'
806
-------
WQP_Data_Summarizatk>n sorted,xlsx - Excel
A susan cormier H
insert Page Layout Formulas Data Review View Help Q Tell me what you want to do
0
Paste
^ Cut
ill Copy *
^ Format Painter
Clipboard rj
Calibri
B I
-J11 v A A
' St: ft-A- S
Font fi I
= = ^
: Wrap Text
| Merge & Center
General
$ • %
E
I 1 Explanatory... Followed Hy...
Conditional Format as Linked Cell
Formatting' Table ~
Output
Hyperlink | Input
Warning Text Heading 1
m o=l .
*-m ciV; -B -
ffl gP
Insert Delete Format
zT P
y AutoSum
[T] Fill -
Sort & Find fii
* Clear' Filter' Select'
Editing
C8
T : | X ~
fx https://www.waterqualitydata.us/portal/ftstatecode=US%3A09&sampleMedia=Water&characteristicName=Conductivity&characteristicName=Specific%20conductance&characteristicName=Specific%20conductivity&startDateLo=01-01-2000&startDateHi=12-31-
A
A
B
C
1
2
State
Query
3
Alabama
h;:oE7/',v'.v.',' v.'d'tTc ja :yqa:a us/pc rra .¦,>s*a:ecocle=:JS;'::SAr _A.ea : eV'e:: a -V. acer&c;-araccers: c\ane=Ce -.c ¦• :y&caarac:er s: c\a'^e-Spec " c :22ce "n'Jcca-cceAc:ai'ac:er e: :A a je=Soec f c: lACce-c-jc: v :y&s:ar:Da:e_c=C':-Cl-2CCC&s:artDateH
=12-31-2015&mimeTv
4
Arizona
a '.•'aterq.ja :yda:a jc ccaa -e:a:ecec2c = J2A: 2A2.-A.ca- :¦ eV'ec: a- '' aceA.f-.jraLce: r. ¦;'v^i=C od _;c" ¦ Ay S c^a-acce- c: c Aa-je = 2c.ec c:,22cc.- c^ctcr" c-Sfd-'oce^; cAj'je = Saec f c A 2Acc:jc2jc: y :y &c :a-:2!a:e_c =0 _ - C- IC 22Ac;a*a DateH
=12- 31- 2015&m i meT v
5
Arkansas
https://www.waterqualitvdata.'js/oortal/astatecode=J55'-;3AC5&Sd-ri::ile,Vledia=VVater&coaracteristlcNarne=Condjctivitv&charaaeristic\ia--iie=S::iecific:':2Cco'idjcta--ice&cnaracteri':: c\a-je=seec f cA 22ceac! jc: :. &c:a-: 2a:e 1 -C1 -22:CC&start DateH
=12-31-2015&mimeTv
6
California
https://wvywAvaterqualitydata.us/portal/Sstateccde- A- 3A06&samc eMed a=V fster&characteristieName=Conductivity&charac:" ••• cAa"ae=2eec ' :¦ ¦¦¦:: _<::a ace Ac -,a-r cAa-ae=5cec r cA2A:cacAic: tySsiar: Ja:e^c2Cccod.Jctance&cnaracteristicNlame=Soecificc;c2Cco'idjcTivity&startDate_c=Cl-Ci-2CC0&startDateH
=12-31-2015&mimeTy
16
Iowa
https://www.waterqualitydata.us/ocrtai/>statecode=dS%3Ai9&sampieMedia=Water&char£ ^ ^ ^ CJ L CJ O w l» :ific%2Cconductance&characteristicNanie=Specific%2Cconductivity&startDate^o=Ci-Ci-2CCC&startDateH
=12-31-2015&mimeTv
17
Kansas
https://wwwAvaterqualitydata.us/portal/=sta:ecocie=JS::2A22A:a "a :¦ -Vfj a='2 a-e-ic-a-ac:e-" c: c \jaTie=LonaucTiviiy&cnaracieriSTic-.\ane=bpecific::2c.cc -,c ...c-a x-=&ciaracteristic\laTie=Soec;f ca2Ccoad jcAc ey5^ta^Date.o=Gi-c:-2CCC&startDateH
=12-31-2015&mimeTv
18
Kentucky
ntios ://¦ : :¦, da:a. jc/ : -2eacijc: ¦¦ :\ 2 a-ae=2aec ; ::: _ 22 co -a ci... cea -j c -e aaracien;Tic\Ja^-ie=Seec £ c:j2Ccoadjc: ': v &; t a 2* a t e _c =C 2 -CI- 2CCC&sta rt Date H
=12-31-2015&mimeTv
19
Louisiana
https://www.waterqualitydata.us/portal/#statecode=US%3A22&sampleMedia=Water&characteristicMame=Conductivity&cnaracteristic.MaTie=:.:::ec f ~ : 20cor ducta ace&c - aracter r ame=S:ec f c:: 2Cco-iductivity&startDateLo=01-01-2000&startDateH
=12-31-2015&mimeTv
20
Maine
'•.•.¦'.'¦.¦.¦'aterc: ja da:a. jc : c -"ta =e:arecede-Ji';-::.A23&-ra "i c e'/ea-'2 a:e^S.c-ia!"ac:e" c: c ',a-ie-2e "id jc: v e. *:a-"ac:e" c: c\ati-?=Seec : c: :2c co v:; jc:a -.ce&c " acac:e-'e: c -.a -"le^seec-f c22ce jc! jc: ¦/ iy&star:2!ate_c=C:-C2-2CCC&startDateH
=12-31-2015&mimeTy
21
Maryland
https://www.waterqualltYdata.us/portal/#5tatea>de=JS%3A24&sampleMedia=Water&characteristicName=Conductivity&characteristicName=Specific%20conductance&characteristic>Jame=Soecific%20conductivity&startDateuO=Cl-CI-2CCC&startDateH
E
E
o3
o
22
Massachusetts
https://vvwvvAvaterqualitydata.us/portal/Pstatecode=JS%3A25&sanipleMedia=VVater&characteristicNaineiGohductivitv&characteristicName=Specific%20conductance&characteristicName=Specific%20condJCtivitv&startDate'_o=01-0i-2000&startDateH
=12-31-2015&mimeTv
23
Michigan
¦jctoc: ¦'Ac;v, 7;a:e-o ja e, da:a _.c ¦ ;c: "a =;tatecode = JSC/:3A2n&;a;"a : eMedia^'.'Vaier&c-iaracteristicMaTie^o'id Jctivitv&ciaracteristicMa-ne=Soecific%2CcondJctance&cnaracteriiiicvJa-rie=S3ecific?'::2Ccond Jctivitv&startDate_c=Cl-C2-2CCC&s:artDateH
=12-31-2015&mimeTy
24
Minnesota
":: e c. ¦¦ a:e'Jj.,a :¦¦, c;a:a.. c ¦': c -:a "a ¦ ecec:---2 ¦ .: 2 A ; .ceA'77:c::c.;.":cAe.:.c: cej-acce^ ¦:; c' .a-vie-: :;ec C'c2ccc--c: ^.:a "-ce 2 r - - c A j - va-: -ac ; c:: 2 Arc. cc c: . ' , 2;. :a-: 2 a: e _c jA-C 2-22 22 : :a-- 2a;e -
=12-31-2015&mimeTy
25
Mississippi
httos:/,/www.waterqualitvdata.us/portal/#statecode=JSS'i3A2S&san-ip!e\'iedia=Water&cnaracTeristic\ame=Ccridjctivitv&characteristlcName=Specific%20conductance&cnaracteristicName=Specific%Mconductivitv&startDate_e=c:-Ci-2CCC&startDateH
=12-31-2015&mimeTv
26
Missouri
https://www. waterqualitydata.us/portal/#statecode=US%3A29&sampleMedia=Water&characteristicName=Conductivitv&characteristicName=Specific%20conductance&characteristicName=Specific%20conductivity&startDateLo=01-01-2000&startDateH
=12-31-2015&mimeTy
45
Utah
https://www.waterquaiitydata.us/portal/#statecode=US%3A49&sampleMedia=Water&characteristicName=Conductivitv&characteristicName=Specific%20conductance&characteristicName=Specific%20conductivity&startDateLo=01-01-2000SistartDateH
=12-31-2015&mimeTvi
46
Vermont
https://www.waterqualitydata.us/portal/#statecode=US%3A50&sampleMedia=Water&characteri5ticName=Conductivity&characteristicName=Specific%20conductance&characteristicName=Specific%20conductivity&startDateLo=01-01-2000&startDateH
=12-31-2015&mimeTvi
47
Virginia
https://www. waterqualitvdata.us/portal/ffstatecode=US%3A51&sampleMedia=Water&characteristicName=Conductivitv&characteristicName=Specific%20conductance&characteristicName=Specific%20conductivitv&startDateLo=01-01-2000&startDateH
=12- 31- 2015 &m i m eTvi
48
Washington
https://www.waterqualitydata.us/portal/#statecode=US%3A53&sampleMedia=Water&characteristicName=Conductivitv&characteristicName=Specific%20conductance&characteristicName=Specific%20conductivity&startDateLo=01-01-2000&startDateH
=12-31-2015&mimeTv
49
West Virginia
https://www.waterqualitydata.us/portal/#statecode=US%3A54&sampleMedia=Water&characteristicName=Conductivity&characteristicName=Specific%20conductance&characteristicName=Specific%20conductivity&startDateLo=01-01-2000&startDateH
=12-31-2015&mimeTvi
50
Wisconsin
"it:o£://'c;7,"c; ¦;..:¦ ; :. cea . .eece: c Aa-ie=2e jcIjc: v cyAc ja'acce ¦ c: c',a -ie^;::c Aa-ie = -eec f c::22,;e a cj jc: A2 -.-.ZAateH
=12-31-2015&mimeTvi
51
Wyoming
httos://7;7v'vvAvaterqualitydata.js/oortal/i>statecode=JS5'c3A56&sample-v1edia=\Vater&characteristicName=Condjctivitv&characteristicNlame=Specific%2Cconductance&characteristicNlame=Specific%2Cconductivitv&startDateLO=0l-Cl-2C00&startDateH
=12-31-2015&mimeTvi
-------
National Water Quality Monitoring Council
Working together for clean water
J ITj"
lJ l'l
Water Quality Data
WQP Home Download Data How to use the WQP » National Results Coverage About the WQP-
LOCATION
Place:
Country:
State:
County:
All
SITE PARAMETERS
Site Type:
Organization ID:
Site ID:
HUC:
Minimum sampling
activities per site:
All
All
All
Scroll
down
Point Location: ?
Within
SAMPLING PARAMETERS
Sample Media:
Characteristic Group:
Characteristics:
Project ID:
Parameter Code: (nwis only)
Bounding Box: ?
North:
* US:CT
the
„ | 7 miles of
South:
All
Lat:
¦}
East:
page
Long:
West:
Use my location
"Water
All
« Conductivity | [ * Specific conductance
< Specific conductivity
All
26
RPTA\ 9
-------
Check
how
many
samples
Search Upstream and Downstream (BETA) ?
I
UP '
¦ MEXICO |
Leaflet 1 Powered by Esri HERE, DeLorme Mapmyindia. @ OpenStreetM-..
Minimum results per site:
Date range - from: 01-01-2000
Biological sampling parameters: ?
Assemblage: All
Taxonomic Name: All
to: 12-31-2015
DATA SOURCE
Select database:
Show sites on map
Style sites: By source
^Select data to download:
Organization Data
Site data only
Project data
Project Monitoring Location Weighting data
Sample results (physical/chemical metadata)
Sample results (biological metadata)
Sample results (narrow)
Sampling Activity
Sampling Activity Metrics
Result Detection Quanlilation Limit Data
Biologic^
DOWNLOAD
: Detection Quanlilatic
i
File format:
* Comma-separated
Tab-separated
MS Excel 2007+
KML {Keyhole Markup Language - for Sites only)
Sort data
-------
https://ww\v.watGrqualitydata.us/portal/#statecodG=US%3AO9&samp!eMedia=WatGr&.characteristicNamG=Conductivity8icharacteristicName=Specific%2Oconduct3nce8icharacteristicNam0=Specific%2Oconductivity&startDateLo
DATA SOURCE
Select database:
Show sites on map
Style site
Select data to download:
Organization Data
• Site data only
Project data
Project Monitoring Location Weighting data
Sample results (physical/chemical metadata)
Sample results (biological metadata)
Sample results (narrow)
Sampling Activity
Sampling Activity Metrics
Result Detection Quantitation Limit Data
. Biological Habitat Metrics
DOWNLOAD
Download Status
Your query will return 282 sites:
From BIODATA: 0 sites
From NWIS: 257 sites
From STEWARDS: 0 sites
From STORET: 25 sites
Click Continue to download the data
Cancel I Continue
KML [Keyhole Maricuc Language - for Sites only)
Copy to clipboard
https://Www.waterqualitydata-US/portal/#statecode=US%3A09&5ampieMedia=Water&characteri5ticName=C<
tiaracteristicName=Specific%20c0nductivity&startDateLo=0l-01-2000&startDateHi=12-31-2015&mimeTy
Sort data
Reports how
many samples,
can download
locational data
or you can
choose to get
all data
nce&c
Show Web Service Calls ¦ Show ArcGIS Online Parameters
Contact us
iUSGS
svEPA
United States
Environmental Protection
Agency
US DA
-------
Choose
sample
results
and
download
Search Upstream and Downstream (BETA) ?
Minimum results per site:
Date range - from: 01-01-2000
Biological sampling parameters: ?
Leaflet Powered by Esri i HERE. DeLorme Maprnylndia. © OpenStreetM...
DATA SOURCE
Select database:
Show sites on map
Style sites: By source
Select data to download:
Organization Data
Site data only
C Project data
Project Monitoring Location Weighting data
* Sample results (physical/chemical metadata)
Sample results (biological metadata)
Sample results (narrow)
Sampling Activity
Sampling Activity Metrics
Result Detection Quantitation Limit Data
Biological Habitat Metrics
File format:
* Comma-separated
Tab-separated
MS Excel 2007+
KML (Keyhole Markup Language - for Sites o
to:
12-31-2015
Assemblage: Ail
Taxonomic Name: All
Sort data
DOWNLOAD
29
-------
Search Upstream and Downstream (BETA) ?
Chose
continue or
download
Leaflel l Powered by Esri HERE DeLorme- Mapmylndia. S OpenStre
TA SOURCE
Select database:
Download Status
Your query will return 12,708 sample
results from 282 sites:
From BIODATA: 0 sample results from 0
sites
From NWIS: 12,231 sample results from
257 sites
From STEWARDS: 0 sample results from
0 sites
From STORET: 477 sample results from
25 sites
Click Continue to download the data
to: 12-31-2015
Show sites on map
Style sites: By source w
Select data to download:
Organization Data
Site data only
Project data
Project Monitoring Location Weighting data
• Sample results (physical/chemical metadata)
Sample results (biological metadata)
Sample results (narrow)
Sampling Activity
Sampling Activity Metrics
Result Detection Quantils^ Limit Data
Biological i
DOWNLOAD
File format:
~ Comma-separated
Tab-separated
MS Excel 2007+
Sort data
-------
An Example Output: Geophysical data download
which we then screened for use in Freshwater Explorer
Good Neutral {Calculation 11
[input | Linked Cell Note |\Z\ Insert Delete I
Styles Cells
£
s
T
U , V I w
X
Y
Z
AA
AB
AC
AD
AE
AF AG
AH
Al
AJ
AK
AL
AM
AN
AO
AP
:tivityBc Projectlde ActivityCc Monitorin ActivityCcSampleAc Hydrologi Hydrologi
SampleCo SampleCo SampleCo SampleCo
ResultDet
Character! ResultSarr
ResultMe
ResultMe;
MeasureC
ResultStal Statistical
ResultVal
ResultWe
ResultTim
ResultTen
Res
U.S. Geolc USGS-01111500
Stable, Ion Routine s£ USGS
USGS
USGS
Unknown
Specif
cccTotal
78
uS/cm @25C
Historical
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, lo\ Routine S£ USGS
USGS
USGS
Unknown
Specif
cccTotal
75
uS/cm @25C
Historical
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, lo\ Routine s£ USGS
USGS
USGS
Unknown
Specif
cccTotal
75
uS/cm @25C
Historical
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, lo\ Routine S£ USGS
USGS
USGS
Unknown
Specif
cccTotal
124
uS/cm @25C
Historical
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, lo\ Routine s£ USGS
USGS
USGS
Unknown
Specif
ccc Total
121
uS/cm @25C
Historical
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, no Routine S£ USGS
USGS
USGS
Unknown
Specif
ccc Total
121
uS/cm @25C
Historical
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, no
Routine ssUSGS
USGS
USGS
Unknown
Specif
ccc Total
126
uS/cm @25C
Historical
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, no
Routine S£ USGS
USGS
USGS
Unknown
Specif
cccTotal
126
uS/cm @25C
Historical
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, no
Routine ScUSGS
USGS
USGS
Unknown
Specif
ccc Total
126
uS/cm @25C
Historical
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, no
Routine S£ USGS
USGS
USGS
Unknown
Specif
ccc Total
111
uS/cm @25C
Accepted
Actual
25 deg C
U.S. Geolc USGS-Oll: x=correction perger
Stable, no
Routine s£
USGS
USGS
USGS
Unknown
Specif
ccc Total
114
uS/cm @25C
Accepted
Actual
25 deg C
U.S. Geolc USGS-01l:x=correction perger
Stable, no
Routine s£
USGS
USGS
USGS
Unknown
Specif
ccc Total
111
uS/cm @25C
Accepted
Actual
25degC
U.S. Geolc USGS-01111500
Stable, no
Routine s£
USGS
USGS
USGS
Unknown
Specif
cccTotal
126
uS/cm @25C
Accepted
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, hij
Routine S£
USGS
USGS
USGS
Unknown
Specif
cccTotal
66
uS/cm @25C
Accepted
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, hif
Routine sfUSGS
USGS
USGS
Unknown
Specif
ccc Total
65
uS/cm @25C
Accepted
Actual
25 deg C
U.S. Geolc USGS-Oll: reed 7-20-01
Stable, no
Routine s£
40
USGS para
Multiples
US DH-81 with Teflot Specif
cccTotal
129
uS/cm @25C
Accepted
Actual
25 deg C
U.S. Geolc USGS-Oll: reed 7-20-01
Stable, no
Routine s£
40
USGS para
Multiple
US DH-81 with Teflot
Specif
cccTotal
131
uS/cm @25C
Accepted
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, no
Routine S£
70
USGS para
Grab samf
Grab sample
Specif
ccc Total
144
uS/cm @25C
Accepted
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, no
Routine S£
70
USGS para
Grab samf
Grab sample
Specif
cccTotal
142
uS/cm @25C
Accepted
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, no
Routine S£ USGS
USGS
USGS
Unknown
Specif
cccTotal
138
uS/cm @25C
Accepted
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, no
Routine S£ USGS
USGS
USGS
Unknown
Specif
ccc Total
134
uS/cm @25C
Accepted
Actual
25 deg C
USGS-01111500
Stable, no
Routine S£ USGS
USGS
USGS
Unknown
Specif
cccTotal
152
uS/cm @25C
Accepted
Actual
25 deg C
U.S. Geolc USGS-01111500
Stable, no
Routine s£
10
USGS para
Equal wid
US DH-95 Teflon bot Specif
cccTotal
135
uS/cm @25C
Accepted
Actual
25 deg C
1 rpcult I I 14 I
f
result.csv [Read-Only] - Excel
, (X> Cut
^ ija) Copy *
^ Format Painter
Clipboard
Page Layout
Calibri
B I U
Q Tell me what you want to do
Jll ' A A
. | =:
— — — «¦= •*=
f Wrap Text
^ Merge & Center
Alignment
General
$ - % » |
Number
ra
Conditional Format as
Formatting" TableT
/ Normal
Bad
Explanatory.
-------
Comments or Questions?
32
------- |