GLOBE E-Mail Data Entry Template - Hydrology
Copy and paste this entire document as text into an e-mail to DATA@GLOBE.GOV with the subject DATA.
For cells within specific protocols for which you have no data, please place an 'X' in that cell (except the comment cells).
You do not have to enter 'X's into the cells of protocols you did not complete… you may leave all those cells empty.
Comments are optional. If you have no comment, leave that column empty (no 'X').
For instructions on using these templates, please refer to: http://www.globe.gov/hq/templ.cgi?mainsp
For more complete instructions, including examples, please refer to: http://www.globe.gov/hq/templ.cgi?emaild
Any other Questions? Contact HELP@GLOBE.GOV
PROTOCOLS INCLUDED IN THIS TEMPLATE:
Temperature, pH, Transparency - Secchi Disk, Transparency - Turbidity Tube, Dissolved Oxygen, Alkalinity, Conductivity, Salin
Temperature Protocol: SWT
(SWT) School ID: School ID
Site Number: Site Number
YYYYMMDDHHmm: Date and Time of Measurement (UT) (Year, Month, Day, Hour,
Water Source State: N=Normal state, FR=Frozen, D=Dried, FL= Flooded, U=Unrea
If Source State is N, include the following Fields:
Temperature #1: Water Temperature of Sample #1 (degrees Celsius)
Temperature #2: Water Temperature of Sample #2 (degrees Celsius)
Temperature #3: Water Temperature of sample #3 (degrees Celsius)
Example:
Protocol School ID Site # YYYYMMDDHHmm Water Source StateSample 1
SWT YOURSCID 1 200001130924 N 8
ENTER DATA IN BLANK FIELDS BELOW, IN-BETWEEN THE "//AA" and "//ZZ"… ADD ROWS AS NECESSARY
Protocol School ID Site # YYYYMMDDHHmm Water Source StateSample 1
//AA
//ZZ
pH Protocol: SWP
(SWP) School ID: School ID
Site Number: Site Number
YYYYMMDDHHmm: Date and Time of Measurement (UT) (Year, Month, Day, Hour,
Technique: Technique for Measuring the pH ( PP = pH Paper, M = pH Meter )
Conductivity 1: If salt added, Conductivity - Sample1 ( microSiemens/cm )
pH 1: Water Acidity - Sample 1 (pH)
Conductivity 2: If salt added, Conductivity - Sample2 ( microSiemens/cm )
pH 2: Water Acidity - Sample 2 (pH)
Conductivity 3: If salt added, Conductivity - Sample3 ( microSiemens/cm )
pH 3: Water Acidity - Sample 3 (pH)
3 Buffer Values: Value of buffers used. A 3-digit string ( with no spaces ) represent
1st character - pH 4 buffer
2nd character - pH 7 buffer
3rd character - pH 10 buffer
Example:
Protocol School ID Site # YYYYMMDDHHmm Technique Conductivity 1
SWP YOURSCID 1 200301130924 M 210
ENTER DATA IN BLANK FIELDS BELOW, IN-BETWEEN THE "//AA" and "//ZZ"… ADD ROWS AS NECESSARY
Protocol School ID Site # YYYYMMDDHHmm Technique Conductivity 1
//AA
//ZZ
Transparency - Secchi Disk Protocol: SWTS
(SWTS) School ID: School ID
Site Number: Site Number
YYYYMMDDHHmm: Date and Time of Measurement (UT) (Year, Month, Day, Hour,
Cloud Cover: N=No Clouds, C=Clear, I=Isolated, S=Scattered, B=Broken, O=Overc
Disappear 1 (m): Distance from where the rope was marked to the disk when the dis
Reappear 1 (m): Distance from where the rope was marked to the disk when the dis
Dist to Water 1 (m): Distance from where the rope was marked to the water surface
Water Depth (?): If Secchi Disk does not disappear for sample #1, enter Depth of the
Disappear 2 (m): Distance from where the rope was marked to the disk when the dis
Reappear 2 (m): Distance from where the rope was marked to the disk when the dis
Dist to Water 2 (m): Distance from where the rope was marked to the water surface
Water Depth (?): If Secchi Disk does not disappear for sample #2, enter Depth of the
Disappear 3 (m): Distance from where the rope was marked to the disk when the dis
Reappear 3 (m): Distance from where the rope was marked to the disk when the dis
Dist to Water 3 (m): Distance from where the rope was marked to the water surface
Water Depth (?): If Secchi Disk does not disappear for sample #3, enter Depth of the
Example:
Protocol School ID Site # YYYYMMDDHHmm Cloud Cover Disappear 1 (m)
SWTS YOURSCID 1 200001081200 S 5.2
ENTER DATA IN BLANK FIELDS BELOW, IN-BETWEEN THE "//AA" and "//ZZ"… ADD ROWS AS NECESSARY
Protocol School ID Site # YYYYMMDDHH Cloud Cover Disappear 1 (m)
//AA
//ZZ
Transparency - Turbidity Tube Protocol: SWTT
(SWTT) School ID: School ID
Site Number: Site Number
YYYYMMDDHHmm: Date and Time of Measurement (UT) (Ye
Cloud Cover: N=No Clouds, C=Clear, I=Isolated, S=Scattered
Disappear 1 (cm): Image Disappears Depth - Observer(s) 1 (c
Greater? 1 (Y/N): Greater than Depth of Tube - Observer(s) 1
Disappear 2 (cm): Image Disappears Depth - Observer(s) 2 (c
Greater? 2 (Y/N): Greater than Depth of Tube - Observer(s) 2
Disappear 3 (cm): Image Disappears Depth - Observer(s) 3 (c
Greater? 3 (Y/N): Greater than Depth of Tube - Observer(s) 3
Note: If the image is still visible when the tube is full, input the full length of the tube for the Disappears Depth, and enter 'Y' in th
Example:
Protocol School ID Site # YYYYMMDDHHmm Cloud Cover Disappear 1 (m)
SWTT YOURSCID 1 200001191115 B 90
ENTER DATA IN BLANK FIELDS BELOW, IN-BETWEEN THE "//AA" and "//ZZ"… ADD ROWS AS NECESSARY
Protocol School ID Site # YYYYMMDDHHmm Cloud Cover Disappear 1 (m)
//AA
//ZZ
Dissolved Oxygen Protocol: SWDO
(SWDO) School ID: School ID
Site Number: Site Number
YYYYMMDDHHmm: Date and Time of Measurement (UT) (Year, Month, Day, Hour,
DO Sample #1: Sample #1 - The Dissolved Oxygen of the water sample (mg/L)
DO Sample #2: Sample #2 - The Dissolved Oxygen of the water sample (mg/L)
DO Sample #3: Sample #3 - The Dissolved Oxygen of the water sample (mg/L)
Example:
Protocol School ID Site # YYYYMMDDHHmm DO Sample #1 DO Sample #2
SWDO YOURSCID 1 200201211829 6.4 6.8
ENTER DATA IN BLANK FIELDS BELOW, IN-BETWEEN THE "//AA" and "//ZZ"… ADD ROWS AS NECESSARY
Protocol School ID Site # YYYYMMDDHHmm DO Sample #1 DO Sample #2
//AA
//ZZ
Alkalinity Protocol: SWA
(SWA) School ID: School ID
Site Number: Site Number
YYYYMMDDHHmm: Date and Time of Measurement (UT) (Year, Month, Day, Hour,
Conversion Constant - ( Only for kits that count drops )
# of Drops 1: Number of Drops Sample 1 - ( Only for kits that count drops )
Alkalinity drops 1: Alkalinity - Sample 1 ( For kits that count drops ) (mg/L as CaC
Alkalinity direct 1: Alkalinity - Sample 1 ( For kits that Read alkalinity Directly )
# of Drops 2: Number of Drops Sample 2 - ( Only for kits that count drops )
Alkalinity drops 2: Alkalinity Sample 2 - ( For kits that count drops ) (mg/L as CaCO
Alkalinity direct 2: Alkalinity - Sample 2- ( For kits that Read alkalinity Directly ) (mg
# of Drops 3: Number of Drops - Sample 3- ( Only for kits that count drops )
Alkalinity drops 3: Alkalinity - Sample 3 - ( For kits that count drops ) (mg/L as CaCO
Alkalinity direct 3: Alkalinity - Sample 3 - ( For kits that Read alkalinity Directly ) (mg
Example:
Protocol School ID Site # YYYYMMDDHHmm Conver. Constant # of Drops 1
SWA YOURSCID 1 200301211852 32 28
SWA YOURSCID 1 200301211852 X X
ENTER DATA IN BLANK FIELDS BELOW, IN-BETWEEN THE "//AA" and "//ZZ"… ADD ROWS AS NECESSARY
Protocol School ID Site # YYYYMMDDHHmm Conver. Constant # of Drops 1
//AA
//ZZ
Conductivity Protocol: SWC
(SWC) School ID: School ID
Site Number: Site Number
YYYYMMDDHHmm: Date and Time of Measurement (UT) (Year, Month, Day, Hour,
Temperature: of sample (degrees C)
Conductivity 1: Conductivity of Sample 1 (microSiemens/cm)
Conductivity 2: Conductivity of Sample 2 ( microSiemens/cm )
Conductivity 3: Conductivity of Sample 3 ( microSiemens/cm )
Conductivity Standard: Conductivity of Standard ( microSiemens/cm )
Example:
Protocol School ID Site # YYYYMMDDHHmm Temperature Conductivity 1
SWC YOURSCID 1 200001211841 20 210
ENTER DATA IN BLANK FIELDS BELOW, IN-BETWEEN THE "//AA" and "//ZZ"… ADD ROWS AS NECESSARY
Protocol School ID Site # YYYYMMDDHHmm Temperature Conductivity 1
//AA
//ZZ
Salinity Protocol: SWS
(SWS) School ID: School ID
Site Number: Site Number
YYYYMMDDHHmm: Date and Time of Measurement (UT) (Year, Month, Day, Hour,
H/L Tide Before: Hour and Minute(s) of High or Low Tide before Salinity measureme
High or Low: Type of Tide above (H=High, L=Low)
H/L Tide After: Hour and Minute(s) of High or Low Tide after Salinity measurement (
High or Low: Type of Tide above (H=High, L=Low)
Water Temp: Sample 1 Temperature of water sample in 500 mL tube - Hydrometer
Specific Gravity: Sample 1 Specific Gravity of water sample - Hydrometer method
Salinity: Sample 1 Salinity of water sample - Hydrometer method (ppt)
Salinity: Sample 1, Salinity of Water - Titration method only (ppt)
Water Temp: Sample 2 Temperature of water sample in 500 mL tube - Hydrometer
Specific Gravity: Sample 2 Salinity of water sample - Salinity Titration method (ppt)
Salinity: Sample 2, Salinity of water - Hydrometer method only (ppt)
Salinity: Sample 2, Salinity of Water - Titration method only (ppt)
Water Temp: Sample 3, Temperature of Water in tube - Hydrometer Method only (d
Specific Gravity: Sample 3, Specific Gravity of water - Hydrometer method only
Salinity: Sample 3, Salinity of water - Hydrometer method only (ppt)
Salinity: Sample 3, Salinity of Water - Titration method only (ppt)
Example:
Protocol School ID Site # YYYYMMDDHHmm H/L Tide Before High or Low
SWS YOURSCID 1 200001211821 1102 H
ENTER DATA IN BLANK FIELDS BELOW, IN-BETWEEN THE "//AA" and "//ZZ"… ADD ROWS AS NECESSARY
Protocol School ID Site # YYYYMMDDHHmm H/L Tide Before High or Low
//AA
//ZZ
Nitrate Protocol: SWN
(SWN) School ID: School ID
Site Number: Site Number
YYYYMMDDHHmm: Date and Time of Measurement (UT) (Year, Month, Day, Hour,
Nitrate+Nitrite: Sample #1 - Nitrate + Nitrite of water sample (mg/L nitrate nitrogen +
Nitrite: Sample #1 Nitrite only (mg/L nitrite nitrogen)
Nitrate+Nitrite: Sample #2 - Nitrate + Nitrite of water sample (mg/L nitrate nitrogen +
Nitrite: Sample #2 Nitrite only (mg/L nitrite nitrogen)
Nitrate+Nitrite: Sample #3 - Nitrate + Nitrite of water sample (mg/L nitrate nitrogen +
Nitrite: Sample #3 Nitrite only (mg/L nitrite nitrogen)
Example:
Protocol School ID Site # YYYYMMDDHHmm Nitrate+Nitrite 1 Nitrite 1
SWN YOURSCID 1 200301181744 0.6 0
ENTER DATA IN BLANK FIELDS BELOW, IN-BETWEEN THE "//AA" and "//ZZ"… ADD ROWS AS NECESSARY
Protocol School ID Site # YYYYMMDDHHmm Nitrate+Nitrite 1 Nitrite 1
//AA
//ZZ
Calibration Protocol: SWCAL
(SWCAL) School ID: School ID
Site Number: Site Number
YYYYMMDDHHmm: Date and Time of Measurement (UT) (Year, Month, Day, Hour,
DO Water Temp: Temperature of shaken distilled water - Dissolved Oxygen (degree
DO of Water: Dissolved Oxygen for shaken distilled water (mg/L)
DO Test Kit: Kit Model for Dissolved Oxygen (H=Hach, L=LaMotte, O=Other)
Alkalinity of Std: Alkalinity of baking soda standard (mg/L as CaCO3)
Alkalinity Test Kit: Kit Model for Alkalinity (H=Hach, L=LaMotte, O=Other)
Salinity of Std: Salinity of 38.6 ppt standard - Salinity Titration method (ppt)
Salinity Titr. Kit: Kit Model - Salinity Titration method (H=Hach, L=LaMotte, O=Other
Nitrate of Std: Nitrate for 2 ppm standard (mg/L nitrate nitrogen)
Nitrate Test Kit: Kit Model for Nitrate (H=Hach, L=LaMotte, O=Other)
Example:
Protocol School ID Site # YYYYMMDDHHmm DO Water Temp DO of Water
SWCAL YOURSCID 1 200401181700 19.5 9.1
ENTER DATA IN BLANK FIELDS BELOW, IN-BETWEEN THE "//AA" and "//ZZ"… ADD ROWS AS NECESSARY
Protocol School ID Site # YYYYMMDDHH DO Water Temp DO of Water
//AA
//ZZ
with the subject DATA.
ll (except the comment cells).
ave all those cells empty.
www.globe.gov/hq/templ.cgi?mainspsheet
www.globe.gov/hq/templ.cgi?emaildatanew
Oxygen, Alkalinity, Conductivity, Salinity, Nitrate, Calibration
ement (UT) (Year, Month, Day, Hour, Minute)
en, D=Dried, FL= Flooded, U=Unreachable
e #1 (degrees Celsius)
e #2 (degrees Celsius)
#3 (degrees Celsius)
Sample 2 Sample 3 Comments
8.6 8.3 Add any comments here…
OWS AS NECESSARY
Sample 2 Sample 3 Comments
ement (UT) (Year, Month, Day, Hour, Minute)
P = pH Paper, M = pH Meter )
mple1 ( microSiemens/cm )
mple2 ( microSiemens/cm )
mple3 ( microSiemens/cm )
t string ( with no spaces ) representing the 3 buffers. Each digit is either 0 (buffer not used), or a 1 (buffer used)
pH 1 Conductivity 2 pH 2 Conductivity 3 pH 3
6.2 234 6.5 X X
OWS AS NECESSARY
pH 1 Conductivity 2 pH 2 Conductivity 3 pH 3
ement (UT) (Year, Month, Day, Hour, Minute)
d, S=Scattered, B=Broken, O=Overcast, OB=Obscured
was marked to the disk when the disk disappears, sample #1 (meters)
was marked to the disk when the disk reappears, sample #1 (meters)
pe was marked to the water surface, sample #1 (meters)
ear for sample #1, enter Depth of the water (meters)
was marked to the disk when the disk disappears, sample #2 (meters)
was marked to the disk when the disk reappears, sample #2 (meters)
pe was marked to the water surface, sample #2 (meters)
ear for sample #2, enter Depth of the water (meters)
was marked to the disk when the disk disappears, sample #3 (meters)
was marked to the disk when the disk reappears, sample #3 (meters)
pe was marked to the water surface, sample #3 (meters)
ear for sample #3, enter Depth of the water (meters)
Reappear 1 (m) Dist to Water 1 (m) Water Depth (?) Disappear 2 (m) Reappear 2 (m)
5 2.2 X 5.3 5
OWS AS NECESSARY
Reappear 1 (m) Dist to Water 1 (m) Water Depth (?) Disappear 2 (m) Reappear 2 (m)
e and Time of Measurement (UT) (Year, Month, Day, Hour, Minute)
ds, C=Clear, I=Isolated, S=Scattered, B=Broken, O=Overcast, OB=Obscured
Disappears Depth - Observer(s) 1 (centimeters)
than Depth of Tube - Observer(s) 1 (Y = Yes, N = No)
Disappears Depth - Observer(s) 2 (centimeters)
than Depth of Tube - Observer(s) 2 (Y = Yes, N = No)
Disappears Depth - Observer(s) 3 (centimeters)
than Depth of Tube - Observer(s) 3 (Y = Yes, N = No)
Disappears Depth, and enter 'Y' in the Greater Than column.
Greater? 1 (Y/N) Disappear 2 (m) Greater? 2 (Y/N) Disappear 3 (m) Greater? 3 (Y/N)
N 91 N 90 N
OWS AS NECESSARY
Greater? 1 (Y/N) Disappear 2 (m) Greater? 2 (Y/N) Disappear 3 (m) Greater? 3 (Y/N)
ement (UT) (Year, Month, Day, Hour, Minute)
gen of the water sample (mg/L)
gen of the water sample (mg/L)
gen of the water sample (mg/L)
DO Sample #3 Comments
6.3 Add any comments here…
OWS AS NECESSARY
DO Sample #3 Comments
ement (UT) (Year, Month, Day, Hour, Minute)
nly for kits that count drops )
ts that count drops ) (mg/L as CaCO3)
ts that Read alkalinity Directly )
ly for kits that count drops )
its that count drops ) (mg/L as CaCO3)
kits that Read alkalinity Directly ) (mg/L as CaCO3)
nly for kits that count drops )
kits that count drops ) (mg/L as CaCO3)
kits that Read alkalinity Directly ) (mg/L as CaCO3)
Alkalinity drops 1 Alkalinity direct 1 # of Drops 2 Alkalinity drops 2Alkalinity direct 2
17 X 30 16 X
X 35 X X 34
OWS AS NECESSARY
Alkalinity drops 1 Alkalinity direct 1 # of Drops 2 Alkalinity drops 2Alkalinity direct 2
ement (UT) (Year, Month, Day, Hour, Minute)
oSiemens/cm)
oSiemens/cm )
oSiemens/cm )
rd ( microSiemens/cm )
Conductivity 2 Conductivity 3 Conduc. Standard Comments
220 216 500 Add any comments here…
OWS AS NECESSARY
Conductivity 2 Conductivity 3 Conduc. Standard Comments
ement (UT) (Year, Month, Day, Hour, Minute)
Low Tide before Salinity measurement (HHmm) (UT)
ow Tide after Salinity measurement (HHmm) (UT)
ample in 500 mL tube - Hydrometer method (degrees C)
water sample - Hydrometer method
drometer method (ppt)
method only (ppt)
ample in 500 mL tube - Hydrometer method (degrees C)
mple - Salinity Titration method (ppt)
er method only (ppt)
method only (ppt)
in tube - Hydrometer Method only (degrees C)
water - Hydrometer method only
er method only (ppt)
method only (ppt)
H/L Tide After High or Low Water Temp 1 Spec. Gravity 1 Salinity 1
1707 L 17.5 1.019 25.1
Hydromtr Only Hydromtr Only Titration Only
OWS AS NECESSARY
H/L Tide After High or Low Water Temp 1 Spec. Gravity 1 Salinity 1
ement (UT) (Year, Month, Day, Hour, Minute)
water sample (mg/L nitrate nitrogen + nitrite nitrogen)
water sample (mg/L nitrate nitrogen + nitrite nitrogen)
water sample (mg/L nitrate nitrogen + nitrite nitrogen)
Nitrate+Nitrite 2 Nitrite 2 Nitrate+Nitrite 3 Nitrite 3 Comments
.4 .1 .5 .1
OWS AS NECESSARY
Nitrate+Nitrite 2 Nitrite 2 Nitrate+Nitrite 3 Nitrite 3 Comments
ement (UT) (Year, Month, Day, Hour, Minute)
ed water - Dissolved Oxygen (degrees C)
lled water (mg/L)
=Hach, L=LaMotte, O=Other)
ard (mg/L as CaCO3)
ach, L=LaMotte, O=Other)
alinity Titration method (ppt)
ethod (H=Hach, L=LaMotte, O=Other)
nitrate nitrogen)
L=LaMotte, O=Other)
DO Test Kit Alkalinity of Std Alkalinity Test Kit Salinity of Std Salinity Titr. Kit
L 68 H 38.8 L
OWS AS NECESSARY
DO Test Kit Alkalinity of Std Alkalinity Test Kit Salinity of Std Salinity Titr. Kit
3 Buffer Values Comments
110 Add any comments here…
3 Buffer Values Comments
Dist to Water 2 (m) Water Depth (?) Disappear 3 (m) Reappear 3 (m) Dist to Water 3 (m)
2.3 X 5.2 4.9 2.2
Dist to Water 2 (m) Water Depth (?) Disappear 3 (m) Reappear 3 (m) Dist to Water 3 (m)
Comments
Add any comments here…
Comments
# of Drops 3 Alkalinity drops 3Alkalinity direct 3 Comments
X X X Add any comments here…
X X 35 Add any comments here…
# of Drops 3 Alkalinity drops 3Alkalinity direct 3 Comments
Salinty 1 Water Temp 2 Spec. Gravity 2 Salinity 2 Salinity 2
X 18 1.019 25.4 X
Hydromtr Only Hydromtr Only Hydromtr Only Hydromtr Only Titration Only
Salinty 1 Water Temp 2 Spec. Gravity 2 Salinity 2 Salinity 2
Nitrate of Std Nitrate Test Kit Comments
1.8 H Add any comments here…
Nitrate of Std Nitrate Test Kit Comments
Water Depth (?) Comments
X Add any comments here…
Water Depth (?) Comments
Water Temp 3 Spec. Gravity 3 Salinity 3 Salinity 3 Comments
18.1 1.018 25.3 X Add any comments here…
Hydromtr Only Hydromtr Only Hydromtr Only Titration Only Add any comments here…
Water Temp 3 Spec. Gravity 3 Salinity 3 Salinity 3 Comments