Dataset: Asset database for the Central West subregion on 16 February 2016


Description

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

General Information

Distributions