Skip to content

Data Requirements

Tim Peterson edited this page Jul 15, 2021 · 3 revisions

Overview

Below is a summary of the input data files. All must be input as .csv text files.

Note, different types of analysis may require a subset of these files. For example, the Data Preparation requires only the head data while construction of time-series Model Construction requires all three input files.

Observed Head

The observed groundwater head data file must be formatted with columns bore ID, year, month, day, head. The hours and minute columns are optional. The Head must be input as an elevation (not depth) and must be the last column within the file. The head values can be in any units (eg metres or feet). Importantly, relevant model parameters will have the same units as the inputs. For example, if the head is in units of metres, then transmissivity will be in units m^2/day. Below is a snippet of a correct input file.

BoreID Year Month Day Hour Head
bore_86656 1987 7 1 23 1.18
bore_86656 1987 9 9 23 0.97
bore_86656 1987 10 19 23 0.82
bore_86656 1987 12 9 23 0.96
bore_86656 1988 1 11 23 1.07
bore_86656 1988 4 6 23 0.42
bore_86656 1988 7 13 23 1.3

Forcing Data

The forcing data file must be formatted with columns year, month, day and the columns for each forcing time series. Importantly, the first row must contain the column names (without spaces in names), the data must have a daily time-step and have no gaps and should extend prior to the first head observation by ~5 years.

If groundwater pumping is to be accounted for, then a value >0 represents an extraction from the aquifer. If the pumping observation record is, however, incomplete (i.e. pumping started before metering) or infrequent (i.e. annual or seasonal metering), then the pumping downscaling transformation function should be used and the input forcing data prepared as shown here.

Below is a snippet of a correct input file.

Year Month Day Precip PET Pump_22
1950 1 1 0 3.4 0
1950 1 2 1 4.2 0
1950 1 3 12 4.3 0
1950 1 4 0 5.2 0

Coordinates

The projected coordinates (not lat. long) for the bore ID and each forcing data with columns Site ID, Easting, Northing is required. Note, all columns within the focriung file and all bores within the head file must be listed within the coordinates file.

SiteID Easting Northing
bore_86656 516413.4 5786059.1
Precip 516413.4 5786059.1
APET 516413.4 5786059.1
Pump_22 515239 5786892

Example Data Files

Examples of the required data formats can be obtained from the inbuilt TFN model examples. Simply select an example model and input where the data files are to be saved. The saved .csv files can then be inspected.

Clone this wiki locally