-
Notifications
You must be signed in to change notification settings - Fork 20
Time series models
The time-series modelling requires three .csv format input files. Head is detailed below.
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 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. 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.