Abstract
The Galilee Impact and Risk Analysis Database (Analysis Database) is a fit-for-purpose geospatial information system developed for the Impact and Risk Analysis (Component 3-4) products of the Bioregional Assessment Technical Programme (BATP). The Analysis Database brings together many of the data sets of the scientific disciplines of the Programme and includes modelling results from hydrogeology and hydrology, landscape classes and economic, sociocultural and ecological assets. These data sets are listed in the Data Register for each subregion and can be found on the Bioregional Assessments web site (http://www.bioregionalassessments.gov.au/).
An Analysis Database of common design and schema was implemented for each individual subregion where a full Impact and Risk Analysis was completed. To populate each database, input datasets were transformed, normalised and inserted into their respective Analysis Database in accord with the common design and schema. The approach enabled the universal treatment of data analysis across all bioregions despite data being of a different specification and origin.
The Analysis Database provided for this subregion is an exact replica of the original used for the assessment of the subregion with the exception that a few spatial data for individual Assets subject to restrictions have been removed before publication. The restrictions are typically for threatened species spatial data but occasionally, restrictive licencing conditions imposed by some custodians prevented publication of some data. The database is constructed using the Open Source platform PostgreSQL coupled with PostGIS. This technology was considered to better enable the provenance and transparency requirements of the Programme. The files provided here have been prepared using the PostgreSQL version 9.5 SQL Dump function - pg_dump.
A detailed description of the Analysis Database, its design, structure and application is provided in the supporting documentation: http://data.bioregionalassessments.gov.au/dataset/05e851cf-57a5-4127-948a-1b41732d538c
Purpose
The Galilee Impact and Risk Analysis Database (Analysis Database) is the geospatial database for completing the Impact and Risk Analysis component of a Bioregional Assessment. This includes the creating of results, tables and maps that appear in the relevant Products of each assessment. The database also manages the data used by the BA Explorer.
An individual instance of the Analysis Database was developed for each subregion where a component 3-4 Impact and Risks Assessment was conducted. With the exception of the subregion-specific data contained within it and the removal of restricted data records, each analysis database is of identical design and structure.
Dataset History
This Analysis Database is an instance of PostgreSQL version 9.5 hosted on Linux Red Hat Enterprise Linux version 4.8.5-4. PostgreSQL geospatial capabilities are provided by POSTGIS version 2.2.
Data pre-processing and upload into each PostgreSQL database was completed using FME Desktop (Oracle Edition) version 2016.1.2.1. Analysis data and results are provided to users and systems via the geospatial services of Geoserver version 2.9.1. Scientific analysis and mapping was undertaken by connecting a range of data using a combination of Microsoft Excel, QGIS and ArcMap systems.
During the Programme and for its working life, the Analysis Database was hosted and managed on instances of Amazon Web Services managed by Geoscience Australia and the Bureau of Meteorology.
Dataset Citation
Bioregional Assessment Programme (2018) GAL Impact and Risk Analysis Database v01. Bioregional Assessment Derived Dataset. Viewed 12 December 2018, http://data.bioregionalassessments.gov.au/dataset/3dbb5380-2956-4f40-a535-cbdcda129045.
Dataset Ancestors
-
Derived From QLD Dept of Natural Resources and Mines, Groundwater Entitlements 20131204
-
Derived From Galilee Drawdown Rasters
-
Derived From Galilee Groundwater Model, Hydrogeological Formation Extents v01
-
Derived From GAL SW Quantiles Interpolation for IMIA Database
-
Derived From SA Petroleum Production License Applications
-
Derived From Galilee tributary catchments
-
Derived From Springs of the Galilee subregion - Points Geometry
-
Derived From GAL Aquifer Formation Extents v01
-
Derived From Geofabric Surface Cartography - V2.1
-
Derived From SA Mineral and/or Opal Exploration Licenses
-
Derived From Environmental Asset Database - Commonwealth Environmental Water Office
-
Derived From Geoscience Australia GEODATA TOPO series - 1:1 Million to 1:10 Million scale
-
Derived From GAL Assessment Units 1000m 20160522 v01
-
Derived From GEODATA TOPO 250K Series 3, File Geodatabase format (.gdb)
-
Derived From Phanerozoic OZ SEEBASE v2 GIS
-
Derived From Asset database for the Galilee subregion on 2 December 2014
-
Derived From Key Environmental Assets - KEA - of the Murray Darling Basin
-
Derived From Bioregional Assessment areas v03
-
Derived From SA Petroleum Exploration Licences/Permits
-
Derived From South Australia Mineral Leases Production, 6 March 2013
-
Derived From BA ALL Assessment Units 1000m 'super set' 20160516_v01
-
Derived From Kevin's Corner Project Environmental Impact Statement
-
Derived From Galilee Hydrological Response Variable (HRV) model
-
Derived From Asset list for Galilee - 20140605
-
Derived From Bioregional Assessment areas v01
-
Derived From Bioregional Assessment areas v02
-
Derived From QLD Current Exploration Permits for Minerals (EPM) in Queensland 6/3/2013
-
Derived From Victoria - Seamless Geology 2014
-
Derived From Galilee groundwater numerical modelling AEM models
-
Derived From GAL Surface Water Reaches for Risk and Impact Analysis 20180803
-
Derived From Matters of State environmental significance (version 4.1), Queensland
-
Derived From Communities of National Environmental Significance Database - RESTRICTED - Metadata only
-
Derived From National Groundwater Dependent Ecosystems (GDE) Atlas
-
Derived From GAL Aquifer Formation Extents v02
-
Derived From Queensland wetland data version 3 - wetland areas.
-
Derived From Galilee surface water modelling nodes
-
Derived From GAL Eco HRV SW Quantiles Interpolation for IMIA Database
-
Derived From National Groundwater Dependent Ecosystems (GDE) Atlas (including WA)
-
Derived From China Stone Coal Project initial advice statement
-
Derived From NSW Catchment Management Authority Boundaries 20130917
-
Derived From South Australia Mineral Production Claims, 6 March 2013
-
Derived From Onsite and offsite mine infrastructure for the Carmichael Coal Mine and Rail Project, Adani Mining Pty Ltd 2012
-
Derived From QLD Dept of Natural Resources and Mines, Groundwater Entitlements linked to bores and NGIS v4 28072014
-
Derived From National Surface Water sites Hydstra
-
Derived From GAL Surface water nodes for Risk and Impact Database 20170804
-
Derived From Multi-resolution Valley Bottom Flatness MrVBF at three second resolution CSIRO 20000211
-
Derived From Galilee model HRV receptors gdb
-
Derived From Great Artesian Basin and Laura Basin groundwater recharge areas
-
Derived From QLD Mining Claim 6/3/2013
-
Derived From Geofabric Surface Cartography - V2.1.1
-
Derived From Australia - Species of National Environmental Significance Database
-
Derived From Australia, Register of the National Estate (RNE) - Spatial Database (RNESDB) Internal
-
Derived From GAL GW Quantile Interpolation 20161013
-
Derived From Collaborative Australian Protected Areas Database (CAPAD) 2010 (Not current release)
-
Derived From Queensland QLD - Regional - NRM - Water Asset Information Tool - WAIT - databases
-
Derived From Stream gauges for the Galilee surface water model calibration
-
Derived From BA ALL Assessment Units 1000m Reference 20160516_v01
-
Derived From National Groundwater Information System (NGIS) v1.1
-
Derived From Birds Australia - Important Bird Areas (IBA) 2009
-
Derived From Asset database for the Galilee subregion on 04 January 2016
-
Derived From Gippsland Project boundary
-
Derived From Natural Resource Management (NRM) Regions 2010
-
Derived From Galilee drawdown grids
-
Derived From QLD Current Authorities to Prospect for Petroleum (ATP), 6/3/2013
-
Derived From Species Profile and Threats Database (SPRAT) - Australia - Species of National Environmental Significance Database (BA subset - RESTRICTED - Metadata only)
-
Derived From QLD Dept of Natural Resources and Mines, Surface Water Entitlements 131204
-
Derived From Ramsar Wetlands of Australia
-
Derived From Geological Provinces - Full Extent
-
Derived From Landscape classification of the Galilee preliminary assessment extent
-
Derived From GAL262 mine footprints
-
Derived From QLD Mining Lease 6/3/2013
-
Derived From National Heritage List Spatial Database (NHL) (v2.1)
-
Derived From QLD DNRM Licence Locations Linked to Cadastre Plan - v1 - 20140307
-
Derived From Asset database for the Galilee subregion on 22 May 2015
-
Derived From Queensland groundwater dependent ecosystems
-
Derived From Node catchment for Galilee surface water modelling
-
Derived From Australia World Heritage Areas
-
Derived From Stream gauges within Galilee surface water modelling domain
-
Derived From Surface Geology of Australia, 1:2 500 000 scale, 2012 edition
-
Derived From SA Mineral and/or Opal Exploration Licence Applications
-
Derived From Asset database for the Galilee subregion on 10 September 2015
-
Derived From Landscape classification of the Galilee preliminary assessment extent
-
Derived From Three-dimensional visualisation of the Great Artesian Basin - GABWRA
-
Derived From QLD Department of Natural Resources and Mines Groundwater Database Extract 20142808
-
Derived From Bioregional Assessment areas v06
-
Derived From Directory of Important Wetlands in Australia (DIWA) Spatial Database (Public)
-
Derived From SA Petroleum Exploration Licence/Permit Applications
-
Derived From GAL Groundwater modelling nodes for Risk and Impact Analysis 20170616
-
Derived From Impact and Risk Analysis Database Documentation
-
Derived From SA Mining and Production Tenement Applications
-
Derived From GAL Landscape Class Reclassification for impact and risk analysis 20170601
-
Derived From GEODATA 9 second DEM and D8: Digital Elevation Model Version 3 and Flow Direction Grid 2008
-
Derived From Bioregional Assessment areas v04
-
Derived From Seven coal mines included in Galilee surface water modelling
-
Derived From GAL_IMIA234_FootprintsIMIA_20170525
-
Derived From QLD Exploration and Production Tenements (20140728)
-
Derived From QLD Current Exploration Permits for Coal 6/3/2013
-
Derived From QLD Dept of Natural Resources and Mines, Groundwater Entitlements linked to bores v3 03122014
-
Derived From Queensland QLD Regional CMA Water Asset Information WAIT tool databases RESTRICTED Includes ALL Reports
-
Derived From GEODATA TOPO 250K Series 3
-
Derived From Permanent and Semi-Permanent Waterbodies of the Lake Eyre Basin (Queensland and South Australia) (DRAFT)
-
Derived From China First Galilee Coal Project Environmental Impact Assessment
-
Derived From QLD Petroleum Leases 6/3/2013
-
Derived From Alpha Coal Project Environmental Impact Statement
-
Derived From Queensland petroleum exploration data - QPED
-
Derived From GAL ZOPHC Master layer 20170804
-
Derived From Bioregional Assessment areas v05
-
Derived From GAL AWRA-L Model v01
-
Derived From QLD Springs Dataset 2016
-
Derived From Galilee gauge contributing area
-
Derived From South Australia Petroleum Production Licenses
-
Derived From South Australia SA - Regional - NRM Board - Water Asset Information Tool - WAIT - databases
-
Derived From Biodiversity status of pre-clearing and remnant regional ecosystems - South East Qld
-
Derived From Galilee Surface Water Preliminary Assessment Extent (PAE) v02
-
Derived From Lake Eyre Basin Surface water Potential Assessment Extents v01
-
Derived From GAL Analysis boundaries 20161005 v01
-
Derived From QLD Mineral Development License 6/3/2013
-
Derived From QLD Springs Dataset 2016 v02
-
Derived From Queensland Geological Digital Data - Detailed state extent, regional. November 2012
-
Derived From QLD DNRM Surface Water Licences linked to Spatial Locations - v1 20140313