Asset database for the Gwydir subregion on 11 March 2016

Abstract

The dataset was derived by the Bioregional Assessment Programme from multiple source datasets. The source datasets are identified in the Lineage field in this metadata statement. The processes undertaken to produce this derived dataset are described in the History field in this metadata statement.

This Gwydir (DWY) dataset contains v23 of the Asset database (GWY_asset_database_20160311.mdb), a Geodatabase version for GIS mapping purposes (GWY_asset_database_GISOnly_21060311.gdb), the draft Water Dependent Asset Register spreadsheet (BA-NIC-GWY-130-WaterDependentAssetRegister-AssetList-v20160311.xlsx), a data dictionary (GWY_asset_database_doc_20160311.docx), a folder (NRM_DOC) and a folder (NRM_DOC) containing documentation associated with the Water Asset Information Tool (WAIT) process.

This Asset database supersedes the previous version of Asset database for the Gwydir subregion on 24 August 2015 (GUID: 7350df87-5103-40f5-b82c-42b0fc59a6a5). Updating in this v3 GWY database includes total number of GWY registered water assets was increased by 1 (= +2-1) because two assets changed M2 test from "No" to "Yes", but one asset changed M2 test from "Yes" to "No" from M2 test decision review done by Ecologist group.

The tabular attribute data can be joined in a GIS to the "Assetlist" table in the mdb database using the "AID" field to view asset attributes (BA attribution). To view the more detailed attribution at the element-level, the intermediate table "Element_to_asset" can be joined to the assets spatial datasets using AID, and then joining the individual attribute tables from the Access database using the common "ElementID" fields. Alternatively, the spatial feature layers representing elements can be linked directly to the individual attribute tables in the Access database using "ElementID", but this arrangement will not provide the asset-level groupings.

Further information is provided in the accompanying document, "GWY_asset_database_doc_20160311.docx" located within this dataset.

The public version of this asset database can be accessed via the following dataset: Asset database for the Gwydir subregion on 11 March 2016 Public (https://data.gov.au/data/dataset/cce59770-99b8-46d1-87c6-582920e0687a)

Purpose

This Asset database is developed for BA

The public version of this asset database can be accessed via the following dataset: Asset database for the Gwydir subregion on 11 March 2016 Public (https://data.gov.au/data/dataset/cce59770-99b8-46d1-87c6-582920e0687a)

Dataset History

VersionID Date Notes

1.0 8/05/2015 Initial database

2.0 24/08/2015 v2 - additions as follows:

(1) At the request of NSW OEH, data identifying species and ecological communities listed under NSW legislation has been included in two additional attribute tables "NSW_TS" and "NSW_TEC" (a total of 110 elements and assets, AIDs 70150-70259). However, given the extremely course catchment-scale resolution of the data as compared to the relatively fine-scale of the PAE, it is essentially a non-spatial list of species and communities which may or may not occur within the PAE. As the data was unable to be meaningfully used as a spatial dataset it was subsequently "turned off" at decision M0 (not fit for purpose), with the decision reflected in the "Assetlist"and "AssetDecisions" tables. Although they are included in the asset database, these new assets are not included in the asset count for GWY.

(2) The database has been updated to include M2 (water dependency) test results from the GWY project team, and a draft "Water-dependent asset register and asset list" spreadsheet (BA-NIC-GWY-130-WaterDependentAssetRegister-AssetList-V20150824.xlsx) has been created and is included in this dataset.

(3) Four queries have been added to the non-spatial database (mdb) (Find_All_Used_Assets, Find_All_WD_Assets, Find_Amount_Asset_in_Class and Find_Amount_Elements_in_Class) to assist project teams to identify and calculate figures to be published.

3 11/03/2016 "(1) Total number of registered water assets was increased by 1 (+2-1) due to:

Two assets changed M2 test from "No" to "Yes" and one asset changed M2 test from "Yes" to "No" from M2 test review done by Ecologist group.

(2) The draft new Water Dependent Asset Register file (BA-LEB-PED-130-WaterDependentAssetRegister-AssetList-V20160308.xlsx) was created"

Further information is contained in the associate document GWY_asset_database_doc_20160311.docx".

Dataset Citation

Bioregional Assessment Programme (2013) Asset database for the Gwydir subregion on 11 March 2016. Bioregional Assessment Derived Dataset. Viewed 08 February 2017, http://data.bioregionalassessments.gov.au/dataset/089f3ab8-74cf-41b8-9597-c6e55b0adcef.

Dataset Ancestors

• 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 Travelling Stock Route Conservation Values

• Derived From NSW Wetlands

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

• Derived From Climate Change Corridors for Nandewar and New England Tablelands

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

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

• Derived From Spatial Threatened Species and Communities (TESC) NSW 20131129

• Derived From Environmental Asset Database - Commonwealth Environmental Water Office

• Derived From Ecological assets of the Gwydir wetlands and floodplain 2008 VIS_ID 3923

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

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

• Derived From Ramsar Wetlands of Australia

• Derived From Native Vegetation Management (NVM) - Manage Benefits

• Derived From Asset database for the Gwydir subregion on 24 August 2015

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

• Derived From Asset database for the Gwydir subregion on 8 May 2015

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

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

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

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

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

• Derived From Collaborative Australian Protected Areas Database (CAPAD) 2010 (Not current release)

• Derived From Australia - Species of National Environmental Significance Database

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

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

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

• Derived From NSW Office of Water Groundwater Entitlements Spatial Locations

• Derived From National Groundwater Dependent Ecosystems (GDE) Atlas

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

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