The Hunter 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 Hunter 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) HUN Impact and Risk Analysis Database v01. Bioregional Assessment Derived Dataset. Viewed 28 August 2018, http://data.bioregionalassessments.gov.au/dataset/298e1f89-515c-4389-9e5d-444a5053cc19.
Derived From Groundwater Dependent Ecosystems supplied by the NSW Office of Water on 13/05/2014
Derived From HUN ZoPHC and component layers 20171115
Derived From NSW Office of Water - National Groundwater Information System 20140701
Derived From Greater Hunter Native Vegetation Mapping with Classification for Mapping
Derived From NSW Wetlands
Derived From Geofabric Surface Network - V2.1
Derived From HUN AWRA-R simulation nodes v01
Derived From Hunter AWRA Hydrological Response Variables (HRV)
Derived From Surface Geology of Australia, 1:1 000 000 scale, 2012 edition
Derived From HUN SW footprint shapefiles v01
Derived From HUN Groundwater footprint polygons v01
Derived From Asset database for the Hunter subregion on 24 February 2016
Derived From BA All Regions BILO cells in subregions shapefile
Derived From NSW Office of Water Surface Water Entitlements Locations v1_Oct2013
Derived From HUN AWRA-R River Reaches Simulation v01
Derived From HUN AWRA-L simulation nodes v02
Derived From GEODATA TOPO 250K Series 3, File Geodatabase format (.gdb)
Derived From Bioregional_Assessment_Programme_Catchment Scale Land Use of Australia - 2014
Derived From Hunter subregion boundary
Derived From Interim Biogeographic Regionalisation for Australia (IBRA), Version 7 (Regions)
Derived From Atlas of Living Australia NSW ALA Portal 20140613
Derived From Bioregional Assessment areas v03
Derived From HUN AWRA-R calibration catchments v01
Derived From HUN AWRA-R Observed storage volumes Glenbawn Dam and Glennies Creek Dam
Derived From Selected streamflow gauges within and near the Hunter subregion
Derived From Groundwater Entitlement Hunter NSW Office of Water 20150324
Derived From Asset database for the Hunter subregion on 20 July 2015
Derived From BA ALL Assessment Units 1000m 'super set' 20160516_v01
Derived From HUN Alluvium (1:1m Geology)
Derived From HUN River Perenniality v01
Derived From Mean Annual Climate Data of Australia 1981 to 2012
Derived From Hunter bioregion (IBRA Version 7)
Derived From Climate Change Corridors (Moist Habitat) for North East NSW
Derived From HUN Riverine Landscape Classes subject to hydrological change
Derived From Asset database for the Hunter subregion on 22 September 2015
Derived From Bioregional Assessment areas v01
Derived From Bioregional Assessment areas v02
Derived From HUN bores v01
Derived From NSW Office of Water Groundwater Licence Extract, North and South Sydney - Oct 2013
Derived From HUN SW GW Mine Footprints for IMIA 20170303 v03
Derived From Climate model 0.05x0.05 cells and cell centroids
Derived From HUN AWRA-LR Model v01
Derived From HUN Landscape Classification v02
Derived From Historical Mining footprints DTIRIS HUN 20150707
Derived From Darling River Hardyhead Predicted Distribution in Hunter River Catchment NSW 2015
Derived From HUN SW GW Mine Footprints for IMIA 20160908
Derived From Communities of National Environmental Significance Database - RESTRICTED - Metadata only
Derived From Bioregional Assessment areas v06
Derived From Geofabric Surface Network - V2.1.1
Derived From R-scripts for uncertainty analysis v01
Derived From NSW Office of Water Surface Water Offtakes - Hunter v1 24102013
Derived From National Groundwater Dependent Ecosystems (GDE) Atlas (including WA)
Derived From Hunter Surface Water data extracted 20140718
Derived From HUN AWRA-R Irrigation Area Extents and Crop Types v01
Derived From HUN Assessment Units 1000m 20160725 v02
Derived From NSW Catchment Management Authority Boundaries 20130917
Derived From IQQM Model Simulation Regulated Rivers NSW DPI HUN 20150615
Derived From HUN GW tables 20170421
Derived From BILO Gridded Climate Data: Daily Climate Data for each year from 1900 to 2012
Derived From HUN Landscape Classification v03
Derived From National Surface Water sites Hydstra
Derived From HUN Mine footprints for timeseries
Derived From ASRIS Continental-scale soil property predictions 2001
Derived From Victoria - Seamless Geology 2014
Derived From BA ALL Assessment Units 1000m Reference 20160516_v01
Derived From NSW Office of Water GW licence extract linked to spatial locations for NorthandSouthSydney v3 13032014
Derived From Natural Resource Management (NRM) Regions 2010
Derived From NSW Office of Water - GW licence extract linked to spatial locations for North and South Sydney v2 20140228
Derived From HUN AssetList Database v1p2 20150128
Derived From Australia - Species of National Environmental Significance Database
Derived From Australia, Register of the National Estate (RNE) - Spatial Database (RNESDB) Internal
Derived From Collaborative Australian Protected Areas Database (CAPAD) 2010 (Not current release)
Derived From HUN GW Model code v01
Derived From Travelling Stock Route Conservation Values
Derived From HUN GW Model v01
Derived From Ramsar Wetlands of Australia
Derived From HUN AWRA-R simulation catchments v01
Derived From HUN Groundwater footprint kmz files v01
Derived From Birds Australia - Important Bird Areas (IBA) 2009
Derived From Estuarine Macrophytes of Hunter Subregion NSW DPI Hunter 2004
Derived From Spatial Threatened Species and Communities (TESC) NSW 20131129
Derived From Gippsland Project boundary
Derived From Fauna Corridors for North East NSW
Derived From River Styles Spatial Layer for New South Wales
Derived From Hunter Surface Water data v2 20140724
Derived From Hunter River Salinity Scheme Discharge NSW EPA 2006-2012
Derived From Asset list for Hunter - CURRENT
Derived From Threatened migratory shorebird habitat mapping DECCW May 2006
Derived From Geological Provinces - Full Extent
Derived From HUN GW Quantiles Interpolation v01
Derived From NSW Office of Water Surface Water Licences Processed for Hunter v1 20140516
Derived From GW Element Bores with Unknown FTYPE Hunter NSW Office of Water 20150514
Derived From HUN SW Model nodes 20170110
Derived From National Heritage List Spatial Database (NHL) (v2.1)
Derived From HUN SW Modelling Reaches and HRV lookup 20171121 v05
Derived From NSW Office of Water combined geodatabase of regulated rivers and water sharing plan regions
Derived From Asset database for the Hunter subregion on 16 June 2015
Derived From Australia World Heritage Areas
Derived From Lower Hunter Spotted Gum Forest EEC 2010
Derived From New South Wales NSW Regional CMA Water Asset Information WAIT tool databases, RESTRICTED Includes ALL Reports
Derived From Greater Hunter Native Vegetation Mapping
Derived From HUN AWRA-R calibration nodes v01
Derived From New South Wales NSW - Regional - CMA - Water Asset Information Tool - WAIT - databases
Derived From HUN SW Quantiles Interpolation for IMIA Database 20170421
Derived From NSW Office of Water - National Groundwater Information System 20141101v02
Derived From HUN Historical Landsat Images Mine Foot Prints v01
Derived From HUN AWRA-L ASRIS soil properties v01
Derived From HUN GW Model simulate ua999 pawsey v01
Derived From Northern Rivers CMA GDEs (DRAFT DPI pre-release)
Derived From National Groundwater Dependent Ecosystems (GDE) Atlas
Derived From Directory of Important Wetlands in Australia (DIWA) Spatial Database (Public)
Derived From HUN GW Quantiles Interpolation for IMIA Database v01
Derived From Impact and Risk Analysis Database Documentation
Derived From HUN AWRA-L simulation nodes_v01
Derived From Climate Change Corridors Coastal North East NSW
Derived From Climate Change Corridors for Nandewar and New England Tablelands
Derived From GEODATA 9 second DEM and D8: Digital Elevation Model Version 3 and Flow Direction Grid 2008
Derived From Asset database for the Hunter subregion on 27 August 2015
Derived From Hunter CMA GDEs (DRAFT DPI pre-release)
Derived From Bioregional Assessment areas v04
Derived From Camerons Gorge Grassy White Box Endangered Ecological Community (EEC) 2008
Derived From HUN AWRAR restricted input 01
Derived From Gosford Council Endangered Ecological Communities (Umina woodlands) EEC3906
Derived From HUN Analysis boundaries 20170106 v03
Derived From HUN groundwater flow rate time series v01
Derived From HUN GW Uncertainty Analysis v01
Derived From Native Vegetation Management (NVM) - Manage Benefits
Derived From GEODATA TOPO 250K Series 3
Derived From BA SYD selected GA TOPO 250K data plus added map features
Derived From Commonwealth Heritage List Spatial Database (CHL)
Derived From Groundwater Economic Elements Hunter NSW 20150520 PersRem v02
Derived From Bioregional Assessment areas v05
Derived From Climate Change Corridors (Dry Habitat) for North East NSW
Derived From Hydstra Groundwater Measurement Update - NSW Office of Water, Nov2013
Derived From Asset database for the Hunter subregion on 12 February 2015
Derived From Operating Mines OZMIN Geoscience Australia 20150201
Derived From HUN AWRA-L Site Station Cross Sections v01
Derived From Groundwater Economic Assets Hunter NSW 20150331 PersRem
Derived From Monitoring Power Generation and Water Supply Bores Hunter NOW 20150514
Derived From HUN AWRA-R Gauge Station Cross Sections v01
Derived From HUN GW Model Mines raw data v01
Derived From NSW Office of Water Groundwater Entitlements Spatial Locations
Derived From HUN Historical Landsat Derived Mine Foot Prints v01
Derived From HUN Mine footprints for GW modelling v01
Derived From HUN AWRA-R Simulation Node Cross Sections v01