20080868 Ver 2_CZR Management of Raw Data_20190628

CZR Management of Raw Electronic Data
Hydrology data:
Field crew turn in the Meazura RDA (blue palm) and completed well data form upon return from
field work.
The palm is downloaded and each data file is transferred to its own individual digital folder. The
folder name is the serial number of the well and resides in the Important Data Files directory
within each monitoring location site folder. NOTE: Important Data directory is only accessible
by the Office Manager, Assistant Office Manager, and two secretaries.
There is also an automatic backup file (bak) created at the time of download which resides in the
C:\ drive on the computer in which the data was downloaded. The folder name is the date of the
download in the field, and can be found at C:\Program Files\Palm\ in a folder depicting the name
of the Meazura (example: palms are named numerically from 1-7). This automatic backup file
serves as an additional source of raw data if needed. CZR's server backup software also creates
a backup of raw data files daily and an external data storage device is switched out weekly with
one device being stored off site.
For output, raw data for each well is transferred into a spreadsheet. The well data form is
reviewed simultaneously and any notes on the data form are incorporated into the spreadsheet.
For example: data gaps due to reprogramming or malfunction, well replacements, correction
factor changes, damages to equipment, battery changes. Graphs are created from the spreadsheet
and reviewed by a biologist. Raw data forms are stored in a 3-ring binder.
Water level and salinity data:
Field crew turn in the RuggedReader Handheld PC and completed Continuous Water Quality
Monitor Field form upon return from field work.
The RuggedReader is downloaded and each data file (.wsl file) is exported from the WinSitu5
software directory to an Excel file and stored in the Important Data Files directory within each
monitoring location site folder. The .wsl data files that reside in the WinSitu5 software directory
act as an additional backup file and are located on the C:\ drive on the computer in which the
data was downloaded. These data files in WinSitu5 are not separated into individual location
folders, they are depicted by their location name and date of download. CZR's server backup
software also creates a backup of raw data files daily and an external data storage device is
switched out weekly with one device being stored off site.
For output, raw data from the Excel file created is transferred into a spreadsheet for each
individual monitoring station. The data form is reviewed simultaneously and any notes on the
data form are incorporated into the spreadsheet. For example: data gaps due to reprogramming
or malfunction, equipment replacement, damages to equipment. Certain parameters of data are
extracted from the individual spreadsheet and combined into one spreadsheet. Graphs are then

created for each location from the combined spreadsheet and reviewed by a biologist. Raw data
forms are stored in a 3-ring binder.