Description of Data Records

35 separate data vales are recorded at fifteen-minute intervals (downloaded hourly).  Please refer to this map for the layout of the observatory.

Column

Value

TIMESTAMP Date and time record was recorded
RECORD Sequential number of record since current program was started (not particularly useful)
P1_shallow_H_ft Piezometric elevation of P1B (feet AMSL)
P2_shallow_H_ft Piezometric elevation of P2B (feet AMSL)
P3_shallow_H_ft Piezometric elevation of P3B (feet AMSL)
P1_deep_H_ft Piezometric elevation of P1A (feet AMSL)
P2_deep_H_ft Piezometric elevation of P2A (feet AMSL)
P3_deep_H_ft Piezometric elevation of P3A (feet AMSL)
P1_shallow_Temp_C Water temperature (°C) measured by sonde in P1B
P2_shallow_Temp_C Water temperature (°C) measured by sonde in P2B
P3_shallow_Temp_C Water temperature (°C) measured by sonde in P3B
P1_deep_Temp_C Water temperature (°C) measured by sonde in P1A
P2_deep_Temp_C Water temperature (°C) measured by sonde in P2A
P3_deep_Temp_C Water temperature (°C) measured by sonde in P3A
P1_shallow_Cond_uS_cm Specific conductance (microsiemens [µS])  measured by sonde in P1B
P2_shallow_Cond_uS_cm Specific conductance (microsiemens [µS])  measured by sonde in P2B
P3_shallow_Cond_uS_cm Specific conductance (microsiemens [µS])  measured by sonde in P3B
P1_deep_Cond_uS_cm Specific conductance (microsiemens [µS])  measured by sonde in P1A
P2_deep_Cond_uS_cm Specific conductance (microsiemens [µS])  measured by sonde in P2A
P3_deep_Cond_uS_cm Specific conductance (microsiemens [µS])  measured by sonde in P3A
P1_delta_H P1 head measured at bottom of aquifer minus head measured at bottom of aquifer (feet).  Positive values mean upward flow (from bottom towards top)
P2_delta_H P2 head measured at bottom of aquifer minus head measured at bottom of aquifer (feet).  Positive values mean upward flow (from bottom towards top)
P3_delta_H P3 head measured at bottom of aquifer minus head measured at bottom of aquifer (feet).  Positive values mean upward flow (from bottom towards top)
average_shallow_H Elevation of piezometric surface (feet AMSL) averaged from values in P1B, P2B, and P3B
average_deep_H Elevation of piezometric surface (feet AMSL) averaged from values in P1A, P2A, and P3A
aver_deep_H - aver_shallow_H Average of deep heads minus average of shallow heads (average_deep_H - average_shallow_H). Positive values mean upward flow (from bottom towards top)
shallow_temp_aver Water temperature (°C) averaged from values in  P1B, P2B, and P3B
deep_temp_aver Water temperature (°C) averaged from values in P1A, P2A, and P3A
shallow_SP_aver Specific conductance (microsiemens [µS])  averaged from values in P1B, P2B, and P3B
deep_SP_aver Specific conductance (microsiemens [µS])  averaged from values in P1A, P2A, and P3A
shallow_gradient Gradient of piezometric surface from plane fit surface observed in P1B, P2B, and P3B
deep_gradient Gradient of piezometric surface from plane fit surface observed in P1A, P2A, and P3A
shallow_flow_azimuth Flow azimuth (degrees from true north) of piezometric surface from plane fit surface observed in P1B, P2B, and P3B
deep_flow_azimuth Flow azimuth (degrees from true north) of piezometric surface from plane fit surface observed in P1A, P2A, and P3A
P_Temp_C Air temperature (°C) measured on CR6 datalogger panel in instrument enclosure on tower (not necessarily representative of outside temperature)
P_RH_% Air relative humidity (%) measured on CR6 datalogger panel in instrument enclosure on tower (not necessarily representative of outside temperature)
P_Batt_Volts Voltage of solar-charged storage battery powering the observatory
Miamitown_Stage_ft USGS 03274615 gage reading at Miamitown, Ohio (feet, gage datum 481.43 feet above NAVD88)
Hamilton_Precip_in_per_15 Precipitation in inches per fifteen minute period measured by USGS 03274000 gage reading at Hamilton, Ohio
Hamilton_Stage_ft USGS 03274000 gage reading at Hamilton, Ohio (feet, gage datum 499.19 feet above NAVD88)
Hamilton_Q_cfs Stream discharge calculated (by USGS) for USGS 03274000 gage at Hamilton, Ohio