Asset database for the Galilee subregion on 10 September 2015

## **Abstract** 



The dataset was derived by the Bioregional Assessment Programme. The parent 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 database supersedes Asset database for the Galilee subregion on 22 May 2015, 781e858b-9604-4a9f-adb9-ebbf276a2dd9.



This dataset contains the spatial and non-spatial (attribute) components of the Galilee subregion Asset List as one .mdb file, which is readable as an MS Access database and a personal geodatabase and one .gbb file (personal geodatabase file). It also contains the  "Water-dependent asset register and asset list" (BA-LEB-GAL-130-WaterDependentAssetRegister-AssetList-v20150910.xlsx), a data dictionary document as well as documentation about the WAIT process and development of the initial input data from regional partners (NRM_DOC folder).



Under the BA program, a spatial assets database is developed for each defined Bioregional Assessment subregion. 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 Galilee 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 Galilee subregion are found in the "AssetList" table of the database. In this version of the database, M1 and M2 have both 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 "GAL_asset_database_doc_20150910.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 "GAL_asset_database_doc_20150910.doc.doc" located in the zip file. Some of the source data used in the compilation of this dataset is restricted. 

## **Purpose** 

For creation of asset list for bioregional assessment

## **Dataset History** 

VersionID	Date	Notes

1.0	23/12/2013	Initial database

1.01	3/02/2014	updated 207 Names in table  AssetList using AssetName in table NRM_Water_Asset for those recodes from source WAIT_Burdekin

1.01	3/02/2014	removed the space at the beginning of Unnamed)_South Australian Arid Lands_66329 and  (Unnamed)_South Australian Arid Lands_57834

1.01	20/02/2014	The database is not changed. About 36 self intersect polygons in spatial data were fixed. New shapefile name for polygon is Galilee_AssetList_geoPolygon20140220.shp

3.0	23/04/2014	"Updated universally changing ""AssetID"" to ""ElementID"" and changing the name of the ""AssetList"" table to ""ElementList"". A table to include Queensland threatened species data has also been added, and ElementIDs added to the ""ElementList"" table."

2.0	23/04/2014	Errors found after handover to CSIRO. Updated immediately to v3.0.

4.0	24/04/2014	Queensland threatened species data updated to new sequence of ElementIDs. New spatial data provided \[NAME\]

8	5/05/2014	It is generally ready except calcification and asset area

9.0	28/11/2014	"Add additional datasets such as QLD_DERM  PR Waterbodies, QLD_DERM  PR Waterbodies QLD RegionalEcosystems as request 

Update GDEsub, GDEsur, QLD_ DNRM_ECON_GW QLD_ DNRM_ECON_SW as request"

10	22/05/2015	Updated database tables of  AssetDecisions and AssetList for M2 and M3 test results



11    10/09/2015     

(1) AID 70360 added for potential distribution of Largetooth Sawfish (Pristis pristis (Pristis microdon)). Attributes in additional attribute look-up table tbl_Species_EPBC_PristisPristis.

(2) The (brief) explanation for M2 decisions has been updated based on advice from the project team, replacing detailed explanations which were truncated in the Assetlist and AssetDecisions tables. The detailed explanation is retained in the DecisionReason field of the AssetDecisions table. Note there are no changes to decision outcomes or numbers of assets on the asset register;

(3) The draft BA-LEB-GAL-130-WaterDependentAssetRegister-AssetList-V20150910.xlsx as has been updated as an output of this database. The brief M2_decision replaces the extended decision rationale that was included in the last version of the spreadsheet.

(4) x15 elements associated with the (single) asset named "No_Asset" (AID = 0) were removed from the database (deleted from the AssetList, Element_to_asset and ElementList tables, and also from the element and asset polygon layers). These polygons were exact duplicates of other elements from the same source dataset and had been previously grouped as "No_Asset". This action will not affect the asset count for the asset list or the water dependent asset register.

## **Dataset Citation** 

Bioregional Assessment Programme (2013) Asset database for the Galilee subregion on 10 September 2015. Bioregional Assessment Derived Dataset. Viewed 12 December 2018, http://data.bioregionalassessments.gov.au/dataset/c22a13bf-07ea-4eaa-960d-79d488a50496.

## **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** [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** [Environmental Asset Database - Commonwealth Environmental Water Office](https://data.gov.au/data/dataset/29fd1654-8aa1-4cb3-b65e-0b37698ac9a6)

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

* **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** [QLD Dept of Natural Resources and Mines, Surface Water Entitlements 131204](https://data.gov.au/data/dataset/fc8366ad-46d8-463a-aa79-8e1679a74f1a)

* **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** [Asset database for the Galilee subregion on 2 December 2014](https://data.gov.au/data/dataset/a1af8e47-4ed0-4fc9-b7e3-edd49912d3a6)

* **Derived From** [Key Environmental Assets - KEA - of the Murray Darling Basin](https://data.gov.au/data/dataset/9948195e-3d3b-49dc-96d2-ea7765297308)

* **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** [QLD DNRM Licence Locations Linked to Cadastre Plan - v1 - 20140307](https://data.gov.au/data/dataset/bf1085d8-9752-4533-a65a-820a020907db)

* **Derived From** [Asset database for the Galilee subregion on 22 May 2015](https://data.gov.au/data/dataset/781e858b-9604-4a9f-adb9-ebbf276a2dd9)

* **Derived From** [Australia World Heritage Areas](https://data.gov.au/data/dataset/4927789b-7ba7-4a77-b6fc-be1b29b6590c)

* **Derived From** [Biodiversity status of pre-clearing and remnant regional ecosystems - South East Qld](https://data.gov.au/data/dataset/9b7bcebf-8b7f-4fb4-bc91-d39f1bd960cb)

* **Derived From** [Asset list for Galilee - 20140605](https://data.gov.au/data/dataset/6968b11f-9912-42ca-8536-00cde75e75d9)

* **Derived From** [QLD DNRM Surface Water Licences linked to Spatial Locations - v1 20140313](https://data.gov.au/data/dataset/caf51590-ad61-492d-87b6-89fc95ff842a)

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