MBC Impact and Risk Analysis Database v01

Abstract

The Maranoa-Balonne-Condamine 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 version provided here for public download has been slightly modified to remove restricted material such as the co-ordinates of protected or threatened species. This version was used to populate BA Explorer.

The Analysis Database brings together many of the data sets used in Components 1 and 2 of the assessments and includes hydrology and hydrogeology modelling results, landscape classes and economic, sociocultural and ecological assets. These data sets are listed in the Component 1 and 2 products under the Assessments tab in http://www.bioregionalassessments.gov.au/.

An Analysis Database of common design and schema was implemented for each 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 Databases in accord with the common design and schema. The approach enabled the universal treatment of data analysis across all bioregions despite data being of different specifications and origins.

The Analysis Database includes all the data used for the assessment of the subregion with the exception of those datasets that were not provided to the program with an open access licence. 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 Maranoa-Balonne-Condamine Impact and Risk Analysis Database (Analysis Database) is the geospatial database for completing the Impact and Risk Analysis component of the Maranoa-Balonne-Condamine 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 (2017) MBC Impact and Risk Analysis Database v01. Bioregional Assessment Derived Dataset. Viewed 25 October 2017, http://data.bioregionalassessments.gov.au/dataset/69075f3e-67ba-405b-8640-96e6cb2a189a.

Dataset Ancestors

• Derived From QLD Dept of Natural Resources and Mines, Groundwater Entitlements 20131204

• Derived From Surface Geology of Australia, 1:1 000 000 scale, 2012 edition

• Derived From Asset database for the Maranoa-Balonne-Condamine subregion on 16 June 2015

• Derived From South East Queensland GDE (draft)

• Derived From Geofabric Surface Cartography - V2.1

• Derived From Environmental Asset Database - Commonwealth Environmental Water Office

• Derived From QLD Dept of Natural Resources and Mines, Surface Water Entitlements 131204

• Derived From GEODATA TOPO 250K Series 3, File Geodatabase format (.gdb)

• Derived From Catchment Scale Land Use of Australia - 2014

• Derived From Surface water preliminary assessment extent for the Maranoa-Balonne-Condamine subregion - v02

• Derived From MBC Groundwater model domain boundary

• Derived From Key Environmental Assets - KEA - of the Murray Darling Basin

• Derived From Bioregional Assessment areas v03

• Derived From MBC Groundwater model ACRD 5th to 95th percentile drawdown

• Derived From Permanent and Semi-Permanent Waterbodies of the Lake Eyre Basin (Queensland and South Australia) (DRAFT)

• Derived From Receptors for the Maranoa-Balonne-Condamine subregion

• Derived From Bioregional Assessment areas v01

• Derived From Bioregional Assessment areas v02

• Derived From MBC Assessment Units 20160714 v01

• Derived From Victoria - Seamless Geology 2014

• Derived From Matters of State environmental significance (version 4.1), Queensland

• Derived From Communities of National Environmental Significance Database - RESTRICTED - Metadata only

• Derived From Bioregional Assessment areas v06

• Derived From Asset database for the Maranoa-Balonne-Condamine subregion on 9 June 2015

• Derived From Queensland wetland data version 3 - wetland areas.

• Derived From Groundwater Preliminary Assessment Extent (PAE) for the Maranoa Balonne Condamine (MBC) subregion - v02

• Derived From National Groundwater Dependent Ecosystems (GDE) Atlas (including WA)

• Derived From Asset database for the Maranoa-Balonne-Condamine subregion on 05 February 2016

• Derived From MBC Groundwater model layer boundaries

• Derived From NSW Catchment Management Authority Boundaries 20130917

• Derived From Baseline drawdown Layer 1 - Condamine Alluvium

• Derived From MBC Assessment unit codified by regional watertable

• Derived From QLD Dept of Natural Resources and Mines, Groundwater Entitlements linked to bores and NGIS v4 28072014

• Derived From MBC Assessment Units 20160714 v02

• Derived From MBC Groundwater model water balance areas

• Derived From Asset database for the Maranoa-Balonne-Condamine subregion on 25 February 2015

• Derived From Australia - Species of National Environmental Significance Database

• Derived From MBC Groundwater model uncertainty analysis

• Derived From Spring vents assessed for the Surat Underground Water Impact Report 2012

• 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 NSW Office of Water GW licence extract linked to spatial locations NIC v2 (28 February 2014)

• Derived From NSW Office of Water Surface Water Entitlements Locations v1_Oct2013

• Derived From MBC Assessment Units 20161211 v01

• Derived From Asset database for the Maranoa-Balonne-Condamine subregion on 26 June 2015

• Derived From Geofabric Surface Catchments - V2.1

• Derived From National Groundwater Information System (NGIS) v1.1

• Derived From Birds Australia - Important Bird Areas (IBA) 2009

• Derived From MBC ZoPHC and component layers 20170117

• Derived From Queensland groundwater dependent ecosystems

• Derived From Gippsland Project boundary

• Derived From Queensland Water Commission, Underground Water Impact Report for the Surat Cumulative Management Area, 2012 - Report and Data

• Derived From Natural Resource Management (NRM) Regions 2010

• Derived From Great Artesian Basin - Hydrogeology and Extent Boundary

• Derived From Species Profile and Threats Database (SPRAT) - Australia - Species of National Environmental Significance Database (BA subset - RESTRICTED - Metadata only)

• Derived From Geological Provinces - Full Extent

• Derived From MBC Analysis Boundaries 20160718 v01

• Derived From MBC Groundwater model mine footprints

• Derived From MBC Groundwater model uncertainty plots

• Derived From Groundwater Preliminary Assessment Extent (PAE) for the Maranoa Balonne Condamine (MBC) subregion - v01

• Derived From National Heritage List Spatial Database (NHL) (v2.1)

• Derived From QLD DNRM Licence Locations Linked to Cadastre Plan - v1 - 20140307

• Derived From NSW Office of Water combined geodatabase of regulated rivers and water sharing plan regions

• Derived From Australia World Heritage Areas

• Derived From New South Wales NSW Regional CMA Water Asset Information WAIT tool databases, RESTRICTED Includes ALL Reports

• Derived From Landscape classification of the Maranoa-Balonne-Condamine preliminary assessment extent v02

• Derived From New South Wales NSW - Regional - CMA - Water Asset Information Tool - WAIT - databases

• Derived From NSW Office of Water Groundwater Licence Extract NIC- Oct 2013

• Derived From Landscape classification of the Maranoa-Balonne-Condamine preliminary assessment extent v03

• Derived From National Groundwater Dependent Ecosystems (GDE) Atlas

• Derived From Directory of Important Wetlands in Australia (DIWA) Spatial Database (Public)

• Derived From MBC Coal mine extents

• Derived From MBC Groundwater model baseline 5th to 95th percentile drawdown

• Derived From Impact and Risk Analysis Database Documentation

• Derived From Preliminary Assessment Extent (PAE) for the Maranoa-Balonne-Condamine subregion - v03

• Derived From NSW Office of Water Surface Water Licences in NIC linked to locations v1 (22 April 2014)

• Derived From Bioregional Assessment areas v04

• Derived From Queensland QLD Regional CMA Water Asset Information WAIT tool databases RESTRICTED Includes ALL Reports

• Derived From Surface water Preliminary Assessment Extent (PAE) for the Maranoa Balonne Condamine (MBC) subregion - v03

• Derived From Landscape classification of the Maranoa-Balonne-Condamine preliminary assessment extent

• Derived From NSW Office of Water Surface Water Offtakes - NIC v1 20131024

• Derived From QLD Dept of Natural Resources and Mines, Groundwater Entitlements linked to bores v3 03122014

• Derived From GEODATA TOPO 250K Series 3

• Derived From Queensland wetland data version 3 - wetland points

• Derived From Queensland wetland data version 3 - wetland lines.

• Derived From Australia, Register of the National Estate (RNE) - Spatial Database (RNESDB) Internal

• Derived From MBC Groundwater model CRDP mine pits

• Derived From Bioregional Assessment areas v05

• Derived From Great Artesian Basin and Laura Basin groundwater recharge areas

• Derived From Landscape classification of the Maranoa-Balonne-Condamine preliminary assessment extent v04

• Derived From Biodiversity status of pre-clearing and remnant regional ecosystems - South East Qld

• Derived From MBC Groundwater model

• Derived From MBC Assessment unit summary tables - groundwater

• Derived From QLD DNRM Surface Water Licences linked to Spatial Locations - v1 20140313

• Derived From NSW Office of Water Groundwater Entitlements Spatial Locations

• Derived From NSW Office of Water Groundwater licences extract linked to spatial locations NIC v3 (13 March 2014)