ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Water Quality Control Division Surface Water Data Template
3
Version 4, updated 5/26/2022
4
5
This template is a data entry spreadsheet that guides data owners through organizing water quality data into a format that meets division data validation requirements.
6
7
This template is intended for submission of water quality data to the division for assessment and other purposes.
8
9
There are five worksheet tabs which need to be completed. The tabs (below) for these two worksheets are green:
10
 • Monitoring Locations, which includes site information and contact information. All sites require coordinates (latitude/longitude) and monitoring location type
11
 • MonitoringLocationTypes, which lists the acceptable location types and whether the data from each of the types wll be used in the Regultation #93 assessments
12
 • Activities_Results, which contains the data
13
 • Characteristic Cross Walk, which allows the data submitter to specifically identify any nutrient results for which a different name might have been used in their local database.
14
 • Qualifier Cross Walk, which allows the data submitter to translate any qualifers used in their database so they will be correctly interpreted. There are five listed but others may be added.
15
16
On the Monitoring Locations tab, column headers are color-coded: Yellow indicates a required field and orange indicates an optional field.
17
All fields should be examined on the Results tab. Some fields are not applicable for all parameters and therefore no required fields are identified.
18
19
For assistance or questions about using this template, please contact CDPHE_WQCD_surfacewaterdata@state.co.us
20
21
The most recent copy of this template can be downloaded from https://www.colorado.gov/cdphe/rivers-lakes-and-streams-data
22
This template has been modified from USEPA WQXWeb Physical Chemistry Template Version 1.04.
23
24
Qualifier Definitions and Use
25
J: Used to identify results that fall between the ML and MDL
26
U: Used to identify results that are less than the minimum level. Requires a minimum level to be reported
27
DL: Used to identify results that are less than the method detection limit. Requires a method detection limit to be reported
28
29
Monitoring Locations must include site type.
30
Typical examples of valid site types
31
· River/Stream
32
· Lake
33
· Reservoir
34
35
Sites identified as ditches or canals will usually not be used for stream assessments
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100