Asset database for the Central West subregion on 16 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 Central West (CEN) dataset contains v2.2 of the Asset database (CEN_asset_database_20160216.mdb), a Geodatabase version for GIS mapping purposes (CEN_asset_database_GISOnly_20160216.gdb), the draft Water Dependent Asset Register spreadsheet (BA-NIC-CEN-130-WaterDependentAssetRegister-AssetList-v20160216.xlsx), a data dictionary (CEN_asset_database_doc_20160216.doc), a folder (Indigenous_doc) containing documentation associated with Indigenous water asset project,  a folder (NRM_DOC) and a folder (NRM_DOC) containing documentation associated with the Water Asset Information Tool (WAIT) process as outlined below.

The Asset database supersedes the previous version of Asset database for the Central West subregion on 21 August 2015 (GUID: 5e90d2ee-a551-48c5-ba48-83e3a907fcf9). Updates to this database compared to the previous database include:

V2.2

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

(a) The 2 assets changed M2 test to "Yes" from the review done by Ecologist group. 

(b) 4 indigenous water assets from OWS were added. 

V2.1

(2) Change "PAE_Region" to "Central West BA subregion boundary" for 149 NSW TS assets in field PAE_Region of table assetlist



The Asset database is registered to the BA repository as an ESRI personal goedatabase (.mdb - doubling as a MS Access database) that can store, query, and manage non-spatial data while the spatial data is in a separated file geodatabase joined by AID/Element ID/BARID. Under the BA program, a spatial assets database is developed for each defined bioregional assessment project. The spatial elements that underpin the identification of water dependent assets are identified in the first instance by regional NRM organisations (via the WAIT tool) and supplemented with additional elements from national and state/territory government datasets. All reports received associated with the WAIT process for Central Westare included in the zip file as part of this dataset. Elements are initially included in the preliminary assets database if they are partly or wholly within the subregion's preliminary assessment extent (Materiality Test 1, M1). Elements are then grouped into assets which are evaluated by project teams to determine whether they meet the second Materiality Test (M2). Assets meeting both Materiality Tests comprise the water dependent asset list.Asset attribution includes only the core set of BA-derived attributes reflecting the BA classification hierarchy, as described in Appendix A of " CEN_asset_database_doc_20160216.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 " CEN_asset_database_doc_20160216.doc" located in the zip file. Some of the source data used in the compilation of this dataset is restricted.



The public version of this asset database can be accessed via the following dataset:  Asset database for the Central West subregion on 16 February 2016 Public (https://data.gov.au/data/dataset/546107ad-27b0-4432-b17e-8876e7c9769d)

## **Dataset History** 

VersionID	Date                Notes

1.0	        29/04/2015	                 Initial database

2.0	        21/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 149 new elements and assets, AIDs 70001-70149). 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.

(2) The database has been updated to include M2 (water dependency) test results from the CEN project team, and a draft "Water-dependent asset register and asset list" spreadsheet (BA-NIC-CEN-130-WaterDependentAssetRegister-AssetList-V20150814.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.



2.1	           29/09/2015	"Change ""PAE_Region"" to ""Central West BA subregion boundary"" for 149 NSW TS assets in field 

                                                         PAE_Region of table assetlist"



2.2	             16/02/2016	"Total number of registered water assets was increased by 6 due to:

                                                             (a) The 2 assets changed M2 test to "Yes" from the review done by Ecologist group. 

                                                             (b) 4 indigenous water assets from OWS were added."

## **Dataset Citation** 

Bioregional Assessment Programme (2013) Asset database for the Central West subregion on 16 February 2016. Bioregional Assessment Derived Dataset. Viewed 08 February 2017, http://data.bioregionalassessments.gov.au/dataset/8ac1d434-7697-4a8f-9908-814e8daf4604.

## **Dataset Ancestors** 

* **Derived From** [Macquarie Marshes Vegetation 1991-2008 VIS_ID 3920](https://data.gov.au/data/dataset/d6e2570f-ad3a-4786-83ba-35e20e87b12e)

* **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** [Travelling Stock Route Conservation Values](https://data.gov.au/data/dataset/198900d5-0d06-4bd0-832b-e30a7c4e8873)

* **Derived From** [NSW Wetlands](https://data.gov.au/data/dataset/90476e12-77a2-4970-a0be-942eeb84e95e)

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

* **Derived From** [Asset database for the Central West subregion on 29 April 2015](https://data.gov.au/data/dataset/5c3f9a56-7a48-4c26-a617-a186c2de5bf7)

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

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

* **Derived From** [Spatial Threatened Species and Communities (TESC) NSW 20131129](https://data.gov.au/data/dataset/a6664894-1489-46d1-a6ca-16f9ab519a28)

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

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

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

* **Derived From** [Asset database for the Central West subregion on 21 August 2015](https://data.gov.au/data/dataset/5e90d2ee-a551-48c5-ba48-83e3a907fcf9)

* **Derived From** [Ramsar Wetlands of Australia](https://data.gov.au/data/dataset/d65cc156-944d-4961-bfba-eacfd61db63a)

* **Derived From** [Native Vegetation Management (NVM) - Manage Benefits](https://data.gov.au/data/dataset/b299e256-1d37-4f89-8c51-93567ebf3753)

* **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** [Climate Change Corridors (Dry Habitat) for North East NSW](https://data.gov.au/data/dataset/8871574a-62ac-4b59-9cc3-bc991a6abd57)

* **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** [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** [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: Central West subregion, economy, environment
Organization: Bioregional Assessment Program