The Namoi 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 Namoi 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) NAM Impact and Risk Analysis Database v01. Bioregional Assessment Derived Dataset. Viewed 11 December 2018, http://data.bioregionalassessments.gov.au/dataset/1549c88d-927b-4cb5-b531-1d584d59be58.
Derived From River Styles Spatial Layer for New South Wales
Derived From Geofabric Surface Network - V2.1
Derived From HUN SW footprint shapefiles v01
Derived From HUN Groundwater footprint polygons v01
Derived From Namoi CMA Groundwater Dependent Ecosystems
Derived From Bioregional Assessment areas v03
Derived From Mean Annual Climate Data of Australia 1981 to 2012
Derived From Asset list for Namoi - CURRENT
Derived From Bioregional Assessment areas v01
Derived From Bioregional Assessment areas v02
Derived From Namoi bore locations, depth to water for June 2012
Derived From Victoria - Seamless Geology 2014
Derived From HUN SW GW Mine Footprints for IMIA 20170303 v03
Derived From Climate model 0.05x0.05 cells and cell centroids
Derived From Namoi hydraulic conductivity measurements
Derived From Namoi groundwater uncertainty analysis
Derived From Historical Mining footprints DTIRIS HUN 20150707
Derived From Namoi NGIS Bore analysis for 2012
Derived From Australian 0.05Âº gridded chloride deposition v2
Derived From Bioregional Assessment areas v06
Derived From NAM Analysis Boundaries 20160908 v01
Derived From Namoi groundwater drawdown grids
Derived From National Surface Water sites Hydstra
Derived From HUN Mine footprints for timeseries
Derived From BA ALL Assessment Units 1000m Reference 20160516_v01
Derived From Natural Resource Management (NRM) Regions 2010
Derived From HUN Groundwater footprint kmz files v01
Derived From Birds Australia - Important Bird Areas (IBA) 2009
Derived From Gippsland Project boundary
Derived From Missing SW Licensing Data in the Namoi PAE 20140711
Derived From Namoi AWRA-L model
Derived From Geological Provinces - Full Extent
Derived From National Heritage List Spatial Database (NHL) (v2.1)
Derived From Namoi AWRA-R (restricted input data implementation)
Derived From Namoi groundwater model alluvium extent
Derived From Namoi ZoPHC and component layers 20170629
Derived From HUN Historical Landsat Images Mine Foot Prints v01
Derived From Groundwater Zone of Impact for the Namoi subregion
Derived From Impact and Risk Analysis Database Documentation
Derived From Namoi GW mine footprints for IMIA 20170516
Derived From Bioregional Assessment areas v04
Derived From Namoi Leapfrog geological model
Derived From Historical Mining Footprints DTIRIS NAM 20150914
Derived From NAM Assessment Units 20160908 v01
Derived From GEODATA TOPO 250K Series 3
Derived From Bioregional Assessment areas v05
Derived From Namoi dryland diffuse groundwater recharge
Derived From Namoi Surface Water Mine Footprints - digitised
Derived From Namoi PAE - Pilliga IBRA subregion
Derived From HUN Mine footprints for GW modelling v01
Derived From HUN Historical Landsat Derived Mine Foot Prints v01
Derived From Namoi groundwater model