Asset database for the Cooper subregion on 12 May 2016

## **Abstract** 





The dataset was derived by the Bioregional Assessment Programme. This dataset was derived from multiple datasets. You can find a link to the parent datasets in the Lineage Field in this metadata statement. The History Field in this metadata statement describes how this dataset was derived.



The asset database for Cooper subregion (v4) supersedes previous version (v3) of the Cooper Asset database (Asset database for the Cooper subregion on 27 August 2015, GUID: 0b122b2b-e5fe-4166-93d1-3b94fc440c82).  It contains the Asset database (COO_asset_database_20160512.mdb), a Geodatabase version for GIS mapping purposes (COO_asset_database_GISOnly_20160512.gdb), the draft Water Dependent Asset Register spreadsheet (BA-LEB-COO-130-WaterDependentAssetRegister-AssetList-v20160512.xlsx), a data dictionary (COO_asset_database_doc_20160512.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 



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 separate file geodatabase joined by AID/ElementID. 



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. A report on the WAIT process for the Cooper is 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. Descriptions of the assets identified in the Cooper subregion are found in the "AssetList" table of the database. 



Assets are the spatial features used by project teams to model scenarios under the BA program. 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 " COO_asset_database_doc_20160512.doc ", located in this 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 Cooper subregion on 12 May 2016 Public (https://data.gov.au/data/dataset/bffa0c44-c86f-4f81-8070-2f0b13e0b774)

## **Dataset History** 

Version ID	Date	Notes

1.0	27/03/2015	Initial database



2.0	14/08/2015	"(1) Updated the database for M2 test results provided from COO assessment team and created the draft BA-LEB-COO-130-WaterDependentAssetRegister-AssetList-V20150814.xlsx 

(2) updated the group, subgroup, class and depth for (up to) 2 NRM WAIT assets to cooperate the feedback to OWS from relevant SA NRM regional office (whose staff missed the asset workshop). The AIDs and names of those assets are listed in table LUT_changed_asset_class_20150814 in COO_asset_database_20150814.mdb

 (3) As a result of (2), added one new asset separated from one existing asset. This asset and its parent are listed in table LUT_ADD_1_asste_20150814 in COO_asset_database_20150814.mdb. The M2 test result for this asset is inherited from its parent in this version

 (5) Added Appendix C in COO_asset_database_doc_201500814.doc is about total elements/assets in current Group and subgroup

(6)Added Four SQL queries (Find_All_Used_Assets, Find_All_WD_Assets, Find_Amount_Asset_in_Class  and Find_Amount_Elements_in_Class) in COO_asset_database_20150814.mdb.mdb for total assets and total numbers

(7)The databases, especially spatial   database (COO_asset_database_20150814Only.gdb), were changed such as duplicated attribute fields in spatial data were removed and only ID field is kept. The user needs to join the Table Assetlist or Elementlist  to the relevant spatial data"



3.0 27/08/2015     M2_Reason in the Assetlist table and DecisionBrief in the AssetDecisions table have been updated with short descriptions (<255 characters) provided by project team 21/8, and the draft  "water-dependent asset register and asset list" (BA-LEB-COO-130-WaterDependentAssetRegister-AssetList-V20150827) also updated accordingly. No changes to asset numbers.





4.0 12/05/2016     "Total number of registered water assets was increased by 26(1+25) due to:

(a) The one asset changed M2 test to "Yes" from the review done by Ecologist group. The original data is included the database as the table tbl_COO _Species_TEC_decisions_reveiw_23112015

(b) 53 indigenous water assets from OWS were added ( but only 25 assets meet the criteria of the registration and are registered) . The data and documents from OWS are included in subdirectory Indigenous_doc

(c)The draft new Water Dependent Asset Register file (BA-LEB-COO-130-WaterDependentAssetRegister-AssetList-v20160512.xlsx) was created.

"

## **Dataset Citation** 

Bioregional Assessment Programme (2014) Asset database for the Cooper subregion on 12 May 2016. Bioregional Assessment Derived Dataset. Viewed 07 February 2017, http://data.bioregionalassessments.gov.au/dataset/90230311-b2e7-4d4d-a69a-03daab0d03cc.

## **Dataset Ancestors** 

* **Derived From** [QLD Dept of Natural Resources and Mines, Groundwater Entitlements 20131204](https://data.gov.au/data/dataset/fd59894f-06b0-4c6f-9029-488934cfa7ba)

* **Derived From** [Queensland QLD - Regional - NRM - Water Asset Information Tool - WAIT - databases](https://data.gov.au/data/dataset/675afffd-5f42-49f0-9e24-9d6cca41621e)

* **Derived From** [Matters of State environmental significance (version 4.1), Queensland](https://data.gov.au/data/dataset/ef6b54d9-6a1f-44cc-bf8c-ca3de4818a0f)

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

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

* **Derived From** [South Australia SA - Regional - NRM Board - Water Asset Information Tool - WAIT - databases](https://data.gov.au/data/dataset/bb5a044a-889c-40a0-bf65-e4826ae72e43)

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

* **Derived From** [National Groundwater Information System (NGIS) v1.1](https://data.gov.au/data/dataset/e157b1cd-3cb7-4cf9-a13c-a6bed576b8c7)

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

* **Derived From** [Queensland  QLD Regional CMA Water Asset Information WAIT tool databases RESTRICTED Includes ALL Reports](https://data.gov.au/data/dataset/aad90a9c-0101-4a44-af07-9eb458cb5e37)

* **Derived From** [Queensland wetland data version 3 - wetland areas.](https://data.gov.au/data/dataset/2a187a00-b01e-4097-9ca4-c9683e7f4786)

* **Derived From** [SA Department of Environment, Water and Natural Resources (DEWNR) Water Management Areas 141007](https://data.gov.au/data/dataset/d0730582-5225-4293-8da6-43ab3ec3b20d)

* **Derived From** [South Australian Wetlands - Groundwater Dependent Ecosystems (GDE) Classification](https://data.gov.au/data/dataset/fc35d75a-f12e-494b-a7d3-0f27e7159b05)

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

* **Derived From** [Asset database for the Cooper subregion on 14 August 2015](https://data.gov.au/data/dataset/5c3697e6-8077-4de7-b674-e0dfc33b570c)

* **Derived From** [QLD Dept of Natural Resources and Mines, Groundwater Entitlements linked to bores v3 03122014](https://data.gov.au/data/dataset/68bbd3fb-6e2a-4088-a3dd-55cc44c2f0d6)

* **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** [Ramsar Wetlands of Australia](https://data.gov.au/data/dataset/d65cc156-944d-4961-bfba-eacfd61db63a)

* **Derived From** [Permanent and Semi-Permanent Waterbodies of the Lake Eyre Basin (Queensland and South Australia) (DRAFT)](https://data.gov.au/data/dataset/7d46c916-926f-41e8-b6ee-6a48b878d9d3)

* **Derived From** [SA EconomicElements v1 20141201](https://data.gov.au/data/dataset/fe5b60af-67a4-4062-b5d1-80b9ea001776)

* **Derived From** [QLD Dept of Natural Resources and Mines, Groundwater Entitlements linked to bores and NGIS v4 28072014](https://data.gov.au/data/dataset/b1ba5370-2c60-485f-9620-ddad39498999)

* **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** [SA Department of Environment, Water and Natural Resources (DEWNR) Groundwater Licences 141007](https://data.gov.au/data/dataset/ce98b07d-1aea-44f6-8900-482ee49565b0)

* **Derived From** [Lake Eyre Basin (LEB) Aquatic Ecosystems Mapping and Classification](https://data.gov.au/data/dataset/9be10819-0e71-4d8d-aae5-f179012b6906)

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

* **Derived From** [Asset database for the Cooper subregion on 27 March 2015](https://data.gov.au/data/dataset/a9ff5fc2-00c0-4da5-91af-94def934243f)

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