Importing Water Levels

Navigation:  Data Types > Water Levels, depths and NAPL depths >

Importing Water Levels

Previous pageReturn to chapter overviewNext page

Groundwater Levels Import Template

For generic information on importing see Importing From Import Templates

A copy of the GW/NAPL  Import template is included below along with field definitions. The import template is from the Access version of ESdat, the SQL server version is similar.

clip0004

 

Location Code:

This is a required field.  A drop down option will allow you to select a Location Code from the range of Location Codes available within ESdat (see Locations Table).  A location code may be added here, however it is not recommended.  It is more efficient to enter Location codes via the Locations import template (see Locations).

Well Code:

This is a required field. All water level data requires a Well Code. For nested piezometers a typical well code may consist of “A”,”B”,”C”.  Where only a single piezometer is installed the WellCode isn't usually relevant so, we recommend a "-" (dash) be used. Well codes may be added via the Wells import template (see Wells).

Date_Time:

Date/Time is a required field. The date time may be entered as date only or as date time eg: “dd mmm yyyy hh:mm:ss” or “dd mmm yyyy”

If a time is omitted Esdat will default to 00:00. Time may be entered as 24 hour or as am/pm.   Where dates are entered in a format such as 11/11/11 ESdat interpret as per the Regional Settings on your PC (ie dd/mm/yy or mm/dd/yy).

Water_Depth:

Water Depth is measured from the top of the well casing (TOC) to the water surface within the well.

Water_Elevation:

Water Elevation does not need to be entered if the Water Depth is entered.  ESdat will automatically calculate Water Elevation from Water_Depth and Reference Elevation data. (ie. Water_Elevation = Reference Elevation – Water Depth) where Reference Elevation equals Top of Casing data (from the Wells table) - if present, or Elevation data (from the Locations table).

Product_Depth:

Product Depth is the depth of Non Aqueous Phase Liquid (NAPL) such as petroleum hydrocarbons  or  Light Non-Aqueous Phase Liquid (LNAPL) on the surface of the groundwater.   

Well_Depth

Well Depth is the depth to the base of the piezometer.

Dry:

The "Dry" flag is True or False, and can be used to indicate if the well was dry at the time of surveying, it will default to False. This is a required field.

Units:

The measurement units for Water_Depth eg.  m  for metres.

Measurement_Method:

The measurement method is a required field and will default to 'dip' if no value is entered, alternative values may include "logger".

Monitoring Round:

Monitoring Round  is a useful way of grouping or filtering measurements that may occur on different dates, but be considered equivalent for analysis purposes

Comments:

Enter any comments appropriate  to the data.

Data Source:

Data Source is an optional field to reference where the data was obtained.