-
Notifications
You must be signed in to change notification settings - Fork 20
Data Requirements
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.
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 |
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 |
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 |
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.