Asset database for the Namoi subregion on 18 February 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 Namoi (NAM) dataset contains v5 of the Asset database (NAM_asset_database_20160218.mdb), a Geodatabase version for GIS mapping purposes (NAM_asset_database_20160218_GISOnly.gdb), the draft Water Dependent Asset Register spreadsheet (BA-NIC-NAM-130-WaterDependentAssetRegister-AssetList-v20160218.xlsx), a data dictionary (NAM_asset_database_doc_20160218.doc), a folder (Indigenous_doc) containing documentation associated with Indigenous water asset project, and  a folder (NRM_DOC) containing documentation associated with the Water Asset Information Tool (WAIT) process as outlined below. 

The Asset database for the Namoi subregion on 18 February 2016 supersedes the previous version of the Asset database v4 "Asset database for the Namoi subregion on 15 January 2015" GUID: c32e70ad-9357-4297-a5dd-e1f1e1f5255f. Updates in this v5 database include:

(1) Total number of registered water assets was increased by 7 due to:

(a) The 6 assets changed M2 test to "Yes" and 1 assets changed reason from the review done by Ecologist group. The original data is included the database as the table tbl_NAM _Species_TEC_decisions_reveiw_23112015

(b) One indigenous water asset from OWS were added. The data and documents from OWS are included in subdirectory Indigenous_doc

(c)The draft new Water Dependent Asset Register file (BA-NIC-NAM-130-WaterDependentAssetRegister-AssetList-v20160218.xlsx) was created

(2) The databases, especially spatial   database, were changed such as (a) spatial data are saved in a separated file geodatabase, (b) duplicated attributes fields in spatial data were removed and only ID field is kept in the spatial data. The user can use AID or ElementID to join the table in personal geodatabase with relevant spatial data

The user can join the Table Assetlist (in NAM_asset_database_20160218.mdb) to the spatial data (GM_NAM_AssetList_ln, GM_NAM_AssetList_poly and  GM_NAM_AssetList_pt in NAM_asset_database_20160218_GISOnly.gdb) from ArcMap by AID to get those attributes for assets. The user can join the Table Elementlist  (in NAM_asset_database_20160218.mdb) to the spatial data (GM_NAM_ElementsList_ln, GM_NAM_ElementsList_poly and  GM_NAM_ElementsList_pt in NAM_asset_database_20160218_GISOnly.gdb)  from ArcMap by ElementID to get those attributes for elements . Element_to_asset (in NAM_asset_database_20160218.mdb) can join to above the spatial data or above two joined results for more information.



Detailed attribution does not exist at the asset level. Asset attribution includes only the core set of BA-derived attributes reflecting the BA classification hierarchy, as described in Appendix A of " NAM_asset_database_doc_20160218.doc", located in the zip file as part of this dataset. The "Element_to_Asset" table contains the relationships and identifies the elements that were grouped to create each asset. Detailed information describing the database structure and content can be found in the document "NAM_asset_database_doc_20160218.doc doc" located in the zip file.

The public version of this asset database can be accessed via the following dataset:  Asset database for the Namoi subregion on 18 February 2016 Public (https://data.gov.au/data/dataset/3134fa6b-f876-46dd-b26b-88d46d424185).

## **Purpose** 

The Asset List Database was developed to spatially identify water dependent assets found within the Namoi subregion.

The public version of this asset database can be accessed via the following dataset:  Asset database for the Namoi subregion on 18 February 2016 Public (https://data.gov.au/data/dataset/3134fa6b-f876-46dd-b26b-88d46d424185).

## **Dataset History** 

On 20 April 2015 the title of this database was changed from "Namoi_AssetList_Database_v4_20150115".



This dataset replicates the spatial and tabular content and structure of the previous version of the Namoi asset list ("Asset list for Namoi - CURRENT"; ID: 538c717c-c04a-4720-8bcd-96fbdf7f0d80) with the exception that decisions made by the Namoi Project Team concerning Materiality Test 2 (water dependency) have been incorporated into the AssetList table, which are used to define the water dependent asset register.



Date    	        Notes

22/07/2014	Initial database for asset related tables and feature classes, and imported element data from element list database

5/09/2014	Updated database with updated WSP/GWMP/RegRiv assets/elements; additional WSP plus point  water volume data and additional RegRiv plus point  water volume data

18/11/2014	Merge some assets with non standard classification to standard classification

18/11/2014	add additional point groundwater economic data ( 121 new elements)

18/11/2014	add additional point surface water economic data (49 new elements)

15/01/2015	Incorporate materiality decisions (M2) from project team into AssetList table



18/02/2016	"(1)Total number of registered water assets was increased by 7 due to:

                            (a) The 6 assets changed M2 test to "Yes" and 1 assets changed reason from the review done by Ecologist 

                          group. The original data is included the database as the table tbl_NAM _Species_TEC_decisions_reveiw_23112015

                          (b) One indigenous water asset from OWS were added. The data and documents from OWS are included in 

                          subdirectory Indigenous_doc

                          (c)The draft new Water Dependent Asset Register file (BA-NIC-NAM-130-WaterDependentAssetRegister-

                            AssetList-v20160218.xlsx) was created

                         (2) The databases, especially spatial   database, were changed such as (a) spatial data are saved in a separated file 

                            geodatabase, (b) duplicated attributes fields in spatial data were removed and only ID field is kept in the spatial

                            data."

## **Dataset Citation** 

Bioregional Assessment Programme (2016) Asset database for the Namoi subregion on 18 February 2016. Bioregional Assessment Derived Dataset. Viewed 11 December 2018, http://data.bioregionalassessments.gov.au/dataset/22061f2c-e86d-4ca8-9860-c349c2513fd8.

## **Dataset Ancestors** 

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

* **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** [Communities of National Environmental Significance Database - RESTRICTED - Metadata only](https://data.gov.au/data/dataset/c01c4693-0a51-4dbc-bbbd-7a07952aa5f6)

* **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** [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** [Missing  SW Licensing Data in the Namoi PAE 20140711](https://data.gov.au/data/dataset/131b847c-7fe3-4b5f-a610-e969b2e54ca4)

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

* **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** [Collaborative Australian Protected Areas Database (CAPAD) 2010 - External Restricted](https://data.gov.au/data/dataset/47312aee-722e-4c6e-bef8-9e439480503e)

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

* **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** [Key Environmental Assets - KEA - of the Murray Darling Basin](https://data.gov.au/data/dataset/9948195e-3d3b-49dc-96d2-ea7765297308)

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

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

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

* **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** [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** [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** [Australia - Species of National Environmental Significance Database](https://data.gov.au/data/dataset/4eff885b-0d68-45e8-b4b1-e3e5448354eb)

* **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** [Australia, Register of the National Estate (RNE) - Spatial Database (RNESDB) Internal](https://data.gov.au/data/dataset/878f6780-be97-469b-8517-54bd12a407d0)

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

* **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** [Collaborative Australian Protected Areas Database (CAPAD) 2010 (Not current release)](https://data.gov.au/data/dataset/7b649c6d-fdbf-40e3-b002-db521665af53)



Tags: Namoi subregion, New South Wales, biota, environment, inlandWaters, society, structure
Organization: Bioregional Assessment Program