Integrated Spatial Data Model For Managing Bore Stratigraphic and Hydrological Information

  • Dr Zaffar Mohamed Ghouse, Sinclair Knight Merz, Australia
  • Mr Derek Goodin, Sinclair Knight Merz, Australia
  • Mr Henry Chaplin, Sinclair Knight Merz, Australia
  • Stratigraphic and hydrological data are important inputs to mapping hydrogeological information. Mostly the primary data (Bore information, well information, drillers log, lithology log; and existing stratigraphy ) required to interpret stratigraphy are stored in various formats (for example, text files, spread sheets, ...) which makes it difficult for interpretation. The basic principles and concepts envisaged in the ESRI geodatabase model ‘ArcHydro - Groundwater’ were used in the development of an integrated spatial data model. Awk scripting language was used to automate data load (Bore details; well details; driller log; geologist log; and existing stratigraphy) from text and spread sheet based data to MS SQL server (Relational Data Base Management System (RDBMS)). A user friendly interface was required to interact with the database MS SQL server database. MS Access 2007 was used to develop the front-end (interface) for the database. The major task of the interface was to provide a platform for interpreting stratigraphy information by viewing all primary data required for interpretation. ArcGIS 9.2 was used to visualise the display of spatial data stored in MS SQL Server via Arc SDE (Spatial Data engine). The integrated approach not only provides a data model to store, retrieve and visualise stratigraphy information but also provides a platform to map hydrogeological information.