Assigning a bore to a specific aquifer is underpinned by the screened interval data and the aquifer boundaries. In many cases, it is impossible to assign the screened interval of a bore to a single aquifer as bores are either screened across different aquifers or there is insufficient information on stratigraphy and screened intervals. The National Groundwater Information System (NGIS) groundwater database (Bureau of Meteorology, ) contains only limited stratigraphic data for groundwater bores in the Clarence-Moreton bioregion. Therefore, an independent assessment of the stratigraphy boundary was conducted during the Clarence-Moreton Bioregional Assessment (the Assessment) (as described in Section 22.214.171.124.1). Following this stratigraphic assessment for the Clarence-Moreton bioregion in NSW, and after a quality check of the data from the Queensland groundwater database (Bioregional Assessment Programme, ), bores were assigned to aquifers by comparing their screen intervals and depth with aquifer boundary data. Furthermore, a code was used for each bore to indicate the spatial relationship between the source aquifer and screen intervals.
The following steps were followed during the aquifer assignment:
- Determine the boundary of the aquifer of interest. The ‘Aquifer’ table in the Queensland Department of Natural Resources and Mines (DNRM) database registers aquifers that a bore intersects when it is drilled and records the upper and lower extents of aquifers. This information was used to identify the aquifer boundary at any specific location. When boundary information was missing the ‘Stratigraphy’ table was used to identify aquifer boundaries instead.
- Determine the screen interval of bores. The ‘Casing’ table contains the screen information for most bores in the database. The codes ‘PERF’ (perforated), ‘SCRN’ (screen) and ‘ENDD’ (open end pipe considered as an entry point) in the column ‘MATERIAL’ indicate water entry locations. The code ‘OPEN’ indicates that a bore is uncased at some depths; if bores intersect an aquifer, then they are considered as water supply points. These codes were used to find the screen interval of a bore. When multiple screens exist, the bore is assumed to be screened across the entire length of the individual screens.
- Determine the screen code. A bore may tap into an aquifer in four ways depending on its screen location in aquifers. Four codes (I, T, B and E; abbreviations are explained in the figure caption of Figure 19) were used to indicate the different spatial relationships of a bore with its targeted aquifer (Figure 19). When screen information is lacking, bores with their lower ends located in an aquifer are assumed to be tapped to that aquifer and were assigned a screen code ‘BOI’ (Figure 19).
(I) the screen interval is within the aquifer; (T) the top of the screen interval is within the aquifer; (B) the bottom of the screen interval is within the aquifer; (E) the bore screen penetrates the entire aquifer; (BOI) there is no screen information in the database, but the bore bottom is located within the aquifer
- Filter bores for a specific area using a shape file or coordinates. If only a part of the aquifer is of interest, then the bores can be filtered based on their locations.
- Cross-check the final datasets against expert knowledge and spatial context of aquifers. Any errors that remain following extensive data quality checks can be highlighted during data interpretation and visual representation and can subsequently be corrected through an iterative process.
New South Wales
- Assess the boundaries of aquifers as outlined in Section 126.96.36.199.6.
- Determine the screen intervals of bores. The screen information was extracted from the ‘Construction’ table in the Bureau of Meteorology () groundwater data archive. The keywords ‘OPENING’ and ‘HOLE’ were used to calculate screen intervals. For example, for the bores in Table 9, GW102905, GW004084 and GW410337 have screen intervals of 12 to 30 mBGL, 80.7 to 115.7 mBGL and zero to 3.05 mBGL, respectively. The bore depth information was extracted from the NSW Water Data Transfer Format (WDTF), Hydstra, and the Bureau of Meteorology () dataset. For bores without depth information in these databases, the bore depth calculations were based on the construction information.
- Filter bores for a specific area using a shape file or coordinates.
- Cross-check the final datasets against expert knowledge, the spatial context of aquifers and the 3D geological model.
Table 9 Sample data to show the algorithm used to determine the screen interval
mBGL refers to metres below ground level
Product Finalisation date
- 2.1.1 Geography
- 2.1.2 Geology
- 188.8.131.52 Methods
- 184.108.40.206 Observed data
- 220.127.116.11 Statistical analysis and interpolation
- 18.104.22.168.1 Three-dimensional geological model workflow
- 22.214.171.124.2 Definition of the stratigraphic column
- 126.96.36.199.3 Selection of input datasets
- 188.8.131.52.4 Representation of structural elements in the three-dimensional geological model
- 184.108.40.206.5 Characterisation of binding horizons of shallow aquifers (alluvium and basalt)
- 220.127.116.11.6 Characterisation of the bedrock stratigraphic units in the Clarence-Moreton bioregion
- 18.104.22.168.7 Isopach maps, depth to formation top and depth to base of formation
- 22.214.171.124 Gaps
- 2.1.3 Hydrogeology and groundwater quality
- 126.96.36.199 Methods
- 188.8.131.52 Observed data
- 184.108.40.206 Statistical analysis and interpolation
- 220.127.116.11 Gaps
- 2.1.4 Surface water hydrology and water quality
- 2.1.5 Surface water – groundwater interactions
- 18.104.22.168 Observed data
- 22.214.171.124 Statistical analysis and interpolation
- 126.96.36.199 Gaps
- 2.1.6 Water management for coal resource developments
- Contributors to the Technical Programme
- About this technical product