Water Journal : Water Journal June 2015
water June 2015 34 Feature article Water extraction and Rainfall Groundwater extraction data was supplied by DELWP (e.g. megalitres per year of total metered groundwater take in a particular irrigation district). This water extraction data was formatted using MS Access so it could be accessed and displayed either onscreen or in printed reports with the relevant bore hydrographs. Rainfall data received from the Bureau of Meteorology was in raster format. The raster represents monthly rainfall by their pixels for the whole of Australia. More than 50 years of records means several hundred raster files. For a particular bore, it was necessary to analyse several hundred raster to extract and see the historical rainfall together with the hydrograph. When this was expanded to cover the 2,700 bores required for the state, several thousand analyses were required to extract the rainfall data. To make the analysis convenient, a Python script in conjunction with ArcGIS was used, which put all rainfall data into a suitable tabular format. nested Bore To synthesise 3D aquifer information, it was necessary to know about bores constituting the nested site and their characteristic hydrographs. Information about the bore construction was obtained from the DELWP SOBN database and coding was undertaken to enable reporting outputs. front-end Interface Front-End Interface is where users (hydrogeologists or resource managers) can interact with the groundwater level, bore construction, rainfall and metering information in the spatial context. As shown in Figure 1, the Front-End Interface is fed by a database accumulated from all information collated and manipulated through the Back-End Analysis. The Front-End Interface was developed to specifically target novice GIS users. Its design enables easy interaction with the intuitive interface, to interact with bore locations, complex groundwater subsurface geometries and generate reporting outputs. It is divided into three parts – spatial enablement, on-screen hydrographs and pdf reporting. Spatial enablement For spatial enablement, a set of layers was organised in an ArcMap document to display the monitoring bore, associated hydrogeological information and base layers, so that a user could navigate to specific regions of the state to interrogate and extract bore information. A series of customised tools (Figure 3) based on ArcMap was developed to facilitate data interpretation, analysis and reporting. A groundwater level trend in hydrograph form can be visualised by simply ‘clicking’ an individual bore point, or a suite polygon (region). By using these tools, a user can generate a hydrograph report in PDF format by defining a reporting period, e.g . calendar start and end dates, and choosing one of two templates – General Template or Inter-Aquifer Template. More discussion on the templates and their example can be found in the section titled ‘PDF Report’. There is capacity to increase reporting template styles should that be required in the future. Onscreen Hydrograph For quick access to groundwater level data and to generate a hydrograph, a tool was developed (Tool 2 in Figure 3) enabling users to view a hydrograph on a pop-up window by just clicking on a bore. As shown in Figure 4, the bottom part of the on- screen hydrograph (pop-up window) shows the whole data range of Figure 3. Spatial enablement and toolset for hydrograph automation. Figure 4. On-screen hydrograph. Figure 5. PDF report using General template.
Water Journal May 2015
Water Journal August 2015