Asset database for the Arckaringa subregion on 07 August 2015

## **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.

Asset Database v3 in Arckaringa subregions supersedes previous versions:

(1) Updated the database for M2 test results provided from ARC assessment team and created the draft BA-LEB-ARC-130-WaterDependentAssetRegister-AssetList-V20150807.xlsx 

(2) updated the group, subgroup, class and depth for (up to) 141 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_20150807 in ARC_asset_database_20150807.mdb

 (3) As a result of (2), added three new assets separated from three exiting assets. Those assets and their parents are listed in table LUT_ADD_3_asstes_20150807 in ARC_asset_database_20150807.mdb. The M2 and M3 test results for those 3 assets are inherited from their parents in this version

(4) Four assets' names from RNE data source were changed for confidential reason and they are listed in table LUT_changed_RNE_20150807 in ARC_asset_database_20150807.mdb

(5) Added Appendix C in ARC_asset_database_doc_201500807.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 ARC_asset_database_20150807.mdb for total assets and total numbers

(7)The databases, especially spatial   database (ARC_asset_database_20150807Only.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.



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. All reports received associated with the WAIT process for Arckaringa are 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 Arckaringa subregion are found in the "AssetList" table of the database. In this version of the database only M1 has been assessed. 

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 "ARC_asset_database_doc_20150807.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 "ARC_asset_database_doc_20150807.doc" located in the zip file.

## **Dataset History** 

VersionID	Date	Notes

1.0	17/03/2015	Initial database

1.1	19/03/2015	Add SA point Eco data ( 2 assets and 67 Elements) and fix  some AIDs  in table AssetDecisions

2	16/04/2015	remove 6 elements ('NGIS_Bore_HydroID_30020907','NGIS_Bore_HydroID_30020908','NGIS_Bore_HydroID_30020921','Unit No 633800074_South Australian Arid Lands_56231','Unit No 633800075_South Australian Arid Lands_56239','Unit No 633900013_South Australian Arid Lands_56243')  from relevant tables  and reprocess  two assets with AIDs 17632 and 17648 without above 3 elements for each, base on SA state information after asset community workshop

3	7/08/2015	(1) Updated the database for M2 test results provided from ARC assessment team and created the draft BA-LEB-ARC-130-WaterDependentAssetRegister-AssetList-V20150807.xlsx 

(2) updated the group, subgroup, class and depth for (up to) 141 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_20150807 in ARC_asset_database_20150807.mdb

 (3) As a result of (2), added three new assets separated from three exiting assets. Those assets and their parents are listed in table LUT_ADD_3_asstes_20150807 in ARC_asset_database_20150807.mdb. The M2 and M3 test results for those 3 assets are inherited from their parents in this version

(4) Four assets' names from RNE data source were changed for confidential reason and they are listed in table LUT_changed_RNE_20150807 in ARC_asset_database_20150807.mdb

(5) Added Appendix C in ARC_asset_database_doc_201500807.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 ARC_asset_database_20150807.mdb for total assets and total numbers

(7)The databases, especially spatial   database (ARC_asset_database_20150807Only.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.





('NGIS_Bore_HydroID_30020907','NGIS_Bore_HydroID_30020908','NGIS_Bore_HydroID_30020921','Unit No 633800074_South Australian Arid Lands_56231','Unit No 633800075_South Australian Arid Lands_56239','Unit No 633900013_South Australian Arid Lands_56243')  from relevant tables  and reprocess  two assets with AIDs 17632 and 17648 without above 3 elements for each, base on SA state information after asset community workshop.



Source codes for input datasets not yet registered and currently unable to be linked to this dataset via BADMS are:

- NT_LEB_Wetlandmap_incl_floodplain_ex_Bclifford

## **Dataset Citation** 

Bioregional Assessment Programme (2014) Asset database for the Arckaringa subregion on 07 August 2015. Bioregional Assessment Derived Dataset. Viewed 07 February 2017, http://data.bioregionalassessments.gov.au/dataset/dccce39e-5f23-43bc-bc89-86ee8b678312.

## **Dataset Ancestors** 

* **Derived From** [Asset database for the Arckaringa subregion on 16 April 2015](https://data.gov.au/data/dataset/1eaf5c9c-7122-4169-b68c-61cc3439feb6)

* **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** [Asset database for the Arckaringa subregion on 18 March 2015](https://data.gov.au/data/dataset/c22009ca-d363-486b-ac2b-e084d53260fd)

* **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** [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** [Asset database for the Arckaringa subregion on 19 March 2015](https://data.gov.au/data/dataset/16ab2026-3995-40f7-b588-88c3fe62adb6)

* **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** [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** [Northern Territory Groundwater Management Units 20140630](https://data.gov.au/data/dataset/01c48600-f9d3-42b6-8449-d2c5f40ef26f)

* **Derived From** [Northern Territory - Lake Eyre Basin - Wetlands Mapping - METADATA ONLY](https://data.gov.au/data/dataset/41d2ecc8-7700-4cc5-b80c-2092596d6f7e)

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