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
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.
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.
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.
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 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