NAM Impact and Risk Analysis Database v01

Brief description

## **Abstract**

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

## **Purpose**

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.

## **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) 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.

## **Dataset Ancestors**

* **Derived From** [River Styles Spatial Layer for New South Wales](https://data.gov.au/data/dataset/06fb694b-d2f1-4338-ab65-a707c02f11d7)

* **Derived From** [Geofabric Surface Network - V2.1](https://data.gov.au/data/dataset/ed3acf9b-888c-4d53-b376-ecab89781651)

* **Derived From** [Surface Geology of Australia, 1:1 000 000 scale, 2012 edition](https://data.gov.au/data/dataset/8284767e-b5b1-4d8b-b8e6-b334fa972611)

* **Derived From** [HUN SW footprint shapefiles v01](https://data.gov.au/data/dataset/2a9520c8-1569-4e0e-8bd8-26e2c7b9e9e0)

* **Derived From** [HUN Groundwater footprint polygons v01](https://data.gov.au/data/dataset/c7672a9d-422e-425e-82ef-11afc5fb7ba6)

* **Derived From** [Namoi Environmental Impact Statements - Mine footprints](https://data.gov.au/data/dataset/493a47cd-4228-4dec-bb72-bcf4495fa306)

* **Derived From** [Namoi CMA Groundwater Dependent Ecosystems](https://data.gov.au/data/dataset/a3e21ec4-ae53-4222-b06c-0dc2ad9838a8)

* **Derived From** [Landscape classification of the Namoi preliminary assessment extent](https://data.gov.au/data/dataset/360c39e5-1225-401d-930b-f5462fdb8005)

* **Derived From** [Environmental Asset Database - Commonwealth Environmental Water Office](https://data.gov.au/data/dataset/29fd1654-8aa1-4cb3-b65e-0b37698ac9a6)

* **Derived From** [Soil and Landscape Grid National Soil Attribute Maps - Clay 3 resolution - Release 1](https://data.gov.au/data/dataset/f8640540-4bb7-42ee-995a-219881e67705)

* **Derived From** [GEODATA TOPO 250K Series 3, File Geodatabase format (.gdb)](https://data.gov.au/data/dataset/96ebf889-f726-4967-9964-714fb57d679b)

* **Derived From** [Bioregional_Assessment_Programme_Catchment Scale Land Use of Australia - 2014](https://data.gov.au/data/dataset/6f72f73c-8a61-4ae9-b8b5-3f67ec918826)

* **Derived From** [Interim Biogeographic Regionalisation for Australia (IBRA), Version 7 (Regions)](https://data.gov.au/data/dataset/70bb7ab7-e8a9-4be5-aa73-85bb22c2cb88)

* **Derived From** [Key Environmental Assets - KEA - of the Murray Darling Basin](https://data.gov.au/data/dataset/9948195e-3d3b-49dc-96d2-ea7765297308)

* **Derived From** [Bioregional Assessment areas v03](https://data.gov.au/data/dataset/96dbf469-5463-4f4d-8fad-4214c97e5aac)

* **Derived From** [GIS analysis of HYDMEAS - Hydstra Groundwater Measurement Update: NSW Office of Water - Nov2013](https://data.gov.au/data/dataset/d414c703-aabd-43af-81e0-30aab4d9dfb1)

* **Derived From** [BA ALL Assessment Units 1000m 'super set' 20160516_v01](https://data.gov.au/data/dataset/6c1aa99e-c973-4472-b434-756e60667bfa)

* **Derived From** [Mean Annual Climate Data of Australia 1981 to 2012](https://data.gov.au/data/dataset/02418c67-f8bb-48a8-88a3-2a5c6b485f78)

* **Derived From** [Asset list for Namoi - CURRENT](https://data.gov.au/data/dataset/538c717c-c04a-4720-8bcd-96fbdf7f0d80)

* **Derived From** [Bioregional Assessment areas v01](https://data.gov.au/data/dataset/0fd0d820-30b3-451f-a126-a50040426999)

* **Derived From** [Bioregional Assessment areas v02](https://data.gov.au/data/dataset/e414b1b3-c42e-42e9-9cc4-2093054aa35f)

* **Derived From** [Namoi bore locations, depth to water for June 2012](https://data.gov.au/data/dataset/1deed9de-9299-4092-a68d-57852acf1a0c)

* **Derived From** [Victoria - Seamless Geology 2014](https://data.gov.au/data/dataset/2872d02e-66cb-42b6-9e5a-63abc8ad871b)

* **Derived From** [Murray-Darling Basin Aquatic Ecosystem Classification](https://data.gov.au/data/dataset/a854a25c-8820-455c-9462-8bd39ca8b9d6)

* **Derived From** [HUN SW GW Mine Footprints for IMIA 20170303 v03](https://data.gov.au/data/dataset/1a3b09ab-4dcb-4ea0-bbbd-8c4d9176f51d)

* **Derived From** [Climate model 0.05x0.05 cells and cell centroids](https://data.gov.au/data/dataset/3df5188b-f027-4d51-99a8-45e2800f29c8)

* **Derived From** [Namoi hydraulic conductivity measurements](https://data.gov.au/data/dataset/5f88517d-8154-411d-907f-4e2c2d12a912)

* **Derived From** [Namoi groundwater uncertainty analysis](https://data.gov.au/data/dataset/36bd27e9-58d2-4bf2-8e4a-54b22ac98cfb)

* **Derived From** [Historical Mining footprints DTIRIS HUN 20150707](https://data.gov.au/data/dataset/7b91b53c-2f09-4cd7-a38b-746446c06a72)

* **Derived From** [Namoi NGIS Bore analysis for 2012](https://data.gov.au/data/dataset/1c828f1b-3e9c-46ae-983a-6ea2218dba48)

* **Derived From** [Australian 0.05º gridded chloride deposition v2](https://data.gov.au/data/dataset/c1649bd7-227f-41ff-9964-b55479bef640)

* **Derived From** [Communities of National Environmental Significance Database - RESTRICTED - Metadata only](https://data.gov.au/data/dataset/c01c4693-0a51-4dbc-bbbd-7a07952aa5f6)

* **Derived From** [Bioregional Assessment areas v06](https://data.gov.au/data/dataset/54d7cc96-5129-450a-aef4-73197f9bc09d)

* **Derived From** [NAM Analysis Boundaries 20160908 v01](https://data.gov.au/data/dataset/b71e38ac-a7cd-4781-a255-0b13548e6a90)

* **Derived From** [Namoi groundwater drawdown grids](https://data.gov.au/data/dataset/38b6fd6e-631c-4b3c-830b-0b449ad32d62)

* **Derived From** [National Groundwater Dependent Ecosystems (GDE) Atlas (including WA)](https://data.gov.au/data/dataset/6dbaee0d-8813-46b1-9c13-1b796e7ed3bf)

* **Derived From** [NSW Catchment Management Authority Boundaries 20130917](https://data.gov.au/data/dataset/0dc4272e-c081-4ed4-9645-aa336ffacd85)

* **Derived From** [BOM, Australian Average Rainfall Data from 1961 to 1990](https://data.gov.au/data/dataset/fd91f2d4-2cc8-4d5d-9f67-8fe8af1e2676)

* **Derived From** [Namoi Existing Mine Development Surface Water Footprints](https://data.gov.au/data/dataset/d4875816-4184-4579-8194-8aff6efe7d9a)

* **Derived From** [Surface water Preliminary Assessment Extent (PAE) for the Namoi (NAM) subregion - v03](https://data.gov.au/data/dataset/b4a6ad8e-c61a-44e6-8879-f7143acd1791)

* **Derived From** [BILO Gridded Climate Data: Daily Climate Data for each year from 1900 to 2012](https://data.gov.au/data/dataset/7aaf0621-a0e5-4b01-9333-53ebcb1f1c14)

* **Derived From** [National Surface Water sites Hydstra](https://data.gov.au/data/dataset/f7edc5e5-93ee-4527-bed5-a118b4017623)

* **Derived From** [HUN Mine footprints for timeseries](https://data.gov.au/data/dataset/1e18f597-c8dd-4dae-b460-de9f5ebb1c6a)

* **Derived From** [BA ALL Assessment Units 1000m Reference 20160516_v01](https://data.gov.au/data/dataset/d044b1d9-40b0-4fc3-ae43-099cc7b96497)

* **Derived From** [Collaborative Australian Protected Areas Database (CAPAD) 2010 - External Restricted](https://data.gov.au/data/dataset/47312aee-722e-4c6e-bef8-9e439480503e)

* **Derived From** [Natural Resource Management (NRM) Regions 2010](https://data.gov.au/data/dataset/1d54e38f-4051-4f0c-a350-c7dbd8eba65b)

* **Derived From** [Australia - Species of National Environmental Significance Database](https://data.gov.au/data/dataset/4eff885b-0d68-45e8-b4b1-e3e5448354eb)

* **Derived From** [Australia, Register of the National Estate (RNE) - Spatial Database (RNESDB) Internal](https://data.gov.au/data/dataset/878f6780-be97-469b-8517-54bd12a407d0)

* **Derived From** [Collaborative Australian Protected Areas Database (CAPAD) 2010 (Not current release)](https://data.gov.au/data/dataset/7b649c6d-fdbf-40e3-b002-db521665af53)

* **Derived From** [NSW Office of Water GW licence extract linked to spatial locations NIC v2 (28 February 2014)](https://data.gov.au/data/dataset/505e8a67-90b4-408a-aa0d-038a9fb14f42)

* **Derived From** [NSW Office of Water Surface Water Entitlements Locations v1_Oct2013](https://data.gov.au/data/dataset/fc872710-998e-4c76-8b98-1df383c53de6)

* **Derived From** [HUN Groundwater footprint kmz files v01](https://data.gov.au/data/dataset/a16c503d-4ec7-4319-b8e1-c8e8a629d71a)

* **Derived From** [Birds Australia - Important Bird Areas (IBA) 2009](https://data.gov.au/data/dataset/5d488350-83b6-4e71-8d17-687ad8ff9941)

* **Derived From** [Asset database for the Namoi subregion on 15 January 2015](https://data.gov.au/data/dataset/c32e70ad-9357-4297-a5dd-e1f1e1f5255f)

* **Derived From** [NAM Riverstyles Stream Reaches for Impact and Risk Analysis 20170601](https://data.gov.au/data/dataset/bd215969-6537-40ea-8efc-9440414c8a3b)

* **Derived From** [Gippsland Project boundary](https://data.gov.au/data/dataset/27413de5-d13a-4231-ac79-fc77f4cbb5f7)

* **Derived From** [Missing SW Licensing Data in the Namoi PAE 20140711](https://data.gov.au/data/dataset/131b847c-7fe3-4b5f-a610-e969b2e54ca4)

* **Derived From** [Namoi AWRA-L model](https://data.gov.au/data/dataset/0d58109a-f3b3-4f3a-9bc0-f8d8398d4da8)

* **Derived From** [Namoi Surface Water ecological HRV quantiles for Impact and Risk Analysis 20170830](https://data.gov.au/data/dataset/e9cbfe45-768e-4496-bf05-3a3c5872332e)

* **Derived From** [Species Profile and Threats Database (SPRAT) - Australia - Species of National Environmental Significance Database (BA subset - RESTRICTED - Metadata only)](https://data.gov.au/data/dataset/7276dd93-cc8c-4c01-8df0-cef743c72112)

* **Derived From** [Geological Provinces - Full Extent](https://data.gov.au/data/dataset/0a064b3b-2a1e-4672-80d9-03333be67aad)

* **Derived From** [Namoi Surface Water model nodes for impact and risk analysis 20170515](https://data.gov.au/data/dataset/05b51f13-47ac-410b-bee2-6a233674fee3)

* **Derived From** [NAM ZOPHC Master for impact and risk analysis 20170629](https://data.gov.au/data/dataset/00d84f32-82ef-46ae-908b-880a727fafaf)

* **Derived From** [Namoi GW exceedance probability and drawdown quantile aspatial summary tables](https://data.gov.au/data/dataset/6bb27b9c-7d0f-4f55-8c49-f76b92288911)

* **Derived From** [National Heritage List Spatial Database (NHL) (v2.1)](https://data.gov.au/data/dataset/26daa8d7-a90e-47f3-982b-0df362414e65)

* **Derived From** [Namoi Hydstra surface water time series v1 extracted 140814](https://data.gov.au/data/dataset/10fc9dd2-fc95-4357-86f1-c59e69678c5c)

* **Derived From** [Namoi AWRA-R (restricted input data implementation)](https://data.gov.au/data/dataset/04fc0b56-ba1d-4981-aaf2-ca6c8eaae609)

* **Derived From** [Namoi groundwater model alluvium extent](https://data.gov.au/data/dataset/e7e79c42-89aa-4278-b14c-d7c67ebd4d89)

* **Derived From** [New South Wales NSW Regional CMA Water Asset Information WAIT tool databases, RESTRICTED Includes ALL Reports](https://data.gov.au/data/dataset/a2a929ea-2cb3-42ab-86b9-87deac68acae)

* **Derived From** [Namoi ZoPHC and component layers 20170629](https://data.gov.au/data/dataset/170e608f-da0d-4fce-889c-cdd0ab137cea)

* **Derived From** [New South Wales NSW - Regional - CMA - Water Asset Information Tool - WAIT - databases](https://data.gov.au/data/dataset/330532aa-66ba-44f5-984b-8a21a99661a0)

* **Derived From** [HUN Historical Landsat Images Mine Foot Prints v01](https://data.gov.au/data/dataset/28de7771-28f5-4d24-943f-0addea07c8c4)

* **Derived From** [NSW Office of Water Groundwater Licence Extract NIC- Oct 2013](https://data.gov.au/data/dataset/808fd05a-f451-4170-a1d3-8439105c0273)

* **Derived From** [National Groundwater Dependent Ecosystems (GDE) Atlas](https://data.gov.au/data/dataset/e358e0c8-7b83-4179-b321-3b4b70df857d)

* **Derived From** [Directory of Important Wetlands in Australia (DIWA) Spatial Database (Public)](https://data.gov.au/data/dataset/6636846e-e330-4110-afbb-7b89491fe567)

* **Derived From** [Groundwater Zone of Impact for the Namoi subregion](https://data.gov.au/data/dataset/51aed716-276b-477f-ba48-ff99ffce7c4e)

* **Derived From** [Impact and Risk Analysis Database Documentation](https://data.gov.au/data/dataset/05e851cf-57a5-4127-948a-1b41732d538c)

* **Derived From** [Groundwater Preliminary Assessment Extent for the Namoi subregion](https://data.gov.au/data/dataset/e58298c8-dc0b-48da-aeca-50b86974954d)

* **Derived From** [Asset database for the Namoi subregion on 18 February 2016](https://data.gov.au/data/dataset/22061f2c-e86d-4ca8-9860-c349c2513fd8)

* **Derived From** [Border Rivers Gwydir / Namoi Regional Native Vegetation Map Version 2.0. VIS_ID 4204](https://data.gov.au/data/dataset/b3ca03dc-ed6e-4fdd-82ca-e9406a6ad74a)

* **Derived From** [NSW Office of Water Surface Water Licences in NIC linked to locations v1 (22 April 2014)](https://data.gov.au/data/dataset/5f0f242b-3f0f-4c7d-bdb2-5ce7b1af6976)

* **Derived From** [Namoi groundwater node locations for impact and risk analysis 20170720](https://data.gov.au/data/dataset/3520c903-dc04-4161-bc88-72aedd7881ae)

* **Derived From** [GEODATA 9 second DEM and D8: Digital Elevation Model Version 3 and Flow Direction Grid 2008](https://data.gov.au/data/dataset/ebcf6ca2-513a-4ec7-9323-73508c5d7b93)

* **Derived From** [Namoi GW mine footprints for IMIA 20170516](https://data.gov.au/data/dataset/dbf358a6-70aa-490e-9dd2-f0c3b857d678)

* **Derived From** [Bioregional Assessment areas v04](https://data.gov.au/data/dataset/e8a2d577-c5c5-4e2c-b0fa-53e4b2d4a034)

* **Derived From** [Namoi Leapfrog geological model](https://data.gov.au/data/dataset/26747362-8e20-49df-ab2c-918fba839aa4)

* **Derived From** [Historical Mining Footprints DTIRIS NAM 20150914](https://data.gov.au/data/dataset/fb0a43f1-9022-4844-b5b5-b91f72a1d9f9)

* **Derived From** [NAM Assessment Units 20160908 v01](https://data.gov.au/data/dataset/f657111b-c10e-4e12-918c-60249a1a5555)

* **Derived From** [NSW Office of Water Surface Water Offtakes - NIC v1 20131024](https://data.gov.au/data/dataset/7dd7c978-299f-4d20-8c66-6c951d26fac8)

* **Derived From** [Namoi AWRA-R model implementation (post groundwater input)](https://data.gov.au/data/dataset/8681bd56-1806-40a8-892e-4da13cda86b8)

* **Derived From** [GEODATA TOPO 250K Series 3](https://data.gov.au/data/dataset/a0650f18-518a-4b99-a553-44f82f28bb5f)

* **Derived From** [Bioregional Assessment areas v05](https://data.gov.au/data/dataset/25f89049-839d-4736-bd81-97d8e8a40f8e)

* **Derived From** [Great Artesian Basin and Laura Basin groundwater recharge areas](https://data.gov.au/data/dataset/8c646031-9765-4d7b-97df-a0869d66eabe)

* **Derived From** [Namoi Surface Water standard HRV quantiles for Impact and Risk Analysis 20170718](https://data.gov.au/data/dataset/1f61bfdf-4dc1-4a35-9b80-f0f6554d27ee)

* **Derived From** [Preliminary Assessment Extent (PAE) for the Namoi subregion - v04](https://data.gov.au/data/dataset/6b8e415f-03f8-4b2d-a022-f6ef1e9e73a8)

* **Derived From** [Hydstra Groundwater Measurement Update - NSW Office of Water, Nov2013](https://data.gov.au/data/dataset/08b34518-c947-4665-82e5-c144b5b24e01)

* **Derived From** [Namoi dryland diffuse groundwater recharge](https://data.gov.au/data/dataset/858327d1-a558-4edc-9315-8779924f3632)

* **Derived From** [Namoi Surface Water Mine Footprints - digitised](https://data.gov.au/data/dataset/fa0a0d09-3780-498a-a412-242b25130291)

* **Derived From** [Namoi PAE - Pilliga IBRA subregion](https://data.gov.au/data/dataset/d95831cb-8cb7-47e6-8a86-32450d59f390)

* **Derived From** [HUN Mine footprints for GW modelling v01](https://data.gov.au/data/dataset/93f99710-e84a-41c0-9c4f-4da9712c3263)

* **Derived From** [Namoi NSW Office of Water groundwater licence BA purpose](https://data.gov.au/data/dataset/15a48026-27f1-4239-b278-32a23e34db5f)

* **Derived From** [NSW Office of Water Groundwater Entitlements Spatial Locations](https://data.gov.au/data/dataset/0f4da0d0-9e82-42f3-84da-1148e0b730c1)

* **Derived From** [HUN Historical Landsat Derived Mine Foot Prints v01](https://data.gov.au/data/dataset/e852e582-d0e7-4543-ac70-feba694597c0)

* **Derived From** [NSW Office of Water Groundwater licences extract linked to spatial locations NIC v3 (13 March 2014)](https://data.gov.au/data/dataset/b0ea1363-4603-463a-b82e-fc586db6b967)

* **Derived From** [Namoi groundwater model](https://data.gov.au/data/dataset/5ad7be74-e091-4f95-a2bf-6033ae7b933a)

* **Derived From** [NSW Office of Water combined geodatabase of regulated rivers and water sharing plan regions](https://data.gov.au/data/dataset/24157c41-c42f-4e1f-a791-a1ad18c8215d)