Asset database for the Galilee subregion on 04 January 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 Galilee dataset contains v13+V12 of the GAL Asset database (GAL_asset_database_20160104.mdb), a Geodatabase version for GIS mapping purposes (GAL_asset_database_20160104_GISONLY.gdb), the draft Water Dependent Asset Register spreadsheet (BA-LEB-GAL-130-WaterDependentAssetRegister-AssetList-v20160104.xlsx), the draft Receptor Register spreadsheet (BA-LEB-GAL-140-ReceptorRegister-v20160104.xlsx), a data dictionary (GAL_asset_database_doc_20160104.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 below 

This database supersedes Asset database for the Galilee subregion on 10 September 2015 (GUID: c22a13bf-07ea-4eaa-960d-79d488a50496). 

The updating in this V13+V12 GAL asset database 201600104 includes: 

(1) Total number of registered water assets was increased by 79 due to: (a) The 9 assets changed their M2 test to "Yes" from the review done by Ecologist group. (b) 69 indigenous water assets from OWS were added. 

(2) GAL receptor was included 

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



The public version of this asset database can be accessed via the following dataset:  Asset database for the Galilee subregion on 04 January 2016 Public (https://data.gov.au/data/dataset/eb4cf797-9b8f-4dff-9d7a-a5dfbc8d2bed)

## **Purpose** 

For creation of asset list for bioregional assessment

The public version of this asset database can be accessed via the following dataset:  Asset database for the Galilee subregion on 04 January 2016 Public (https://data.gov.au/data/dataset/eb4cf797-9b8f-4dff-9d7a-a5dfbc8d2bed)

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





12	24/12/2015	"Area calculations were removed from the spatial data and added to the assetList and elementList tables in   

                                            this .mdb database. Area calculations were included for assets and elementlist line features.

                                            A total of 69 Indigenous elements were added to the ElementList table in the database, translating into an  

                                             additional 69 indigenous assets which were added to the AssetList table. 

                                             Of these 69 indigenous assets: 

                                                      40 intersect the PAE and are included in the ""asset list"".

                                                      5 did not intersect the PAE, so did not pass ""M1"". These are retained in the AssetList table but 

                                                       are ""switched off"" at M1 (i.e. M1 = 'No'). These are not considered part of the ""asset list"".

                                                      24 have no meaningful spatial component. These were added to the AssetList table, but ""switched  

                                                        off"" at ""M0"" (i.e. not fit for purpose, M0 = 'No') and therefore are not consodered part of 

                                                       the ""asset list""."



13	4/01/2016	"(1)(a) Added table ReceptorList in GAL_asset_database_20160104.mdb, using the data file from GAL project

                                                team (b) Created draft BA-LEB-GAL-140-ReceptorRegister-v20160104.xlsx (c) Added table 

                                                 tbl_Receptors in GAL_asset_database_20160104.mdb and GM_GAL_ReceptorList_pt (created by ERIN 

                                                  using the location data from GAL project team)  in GAL_asset_database_20160104_GISONLY.gdb,; (d)

                                                 Add SQL query "Find_used_Receptor_a" and "Find_used_Receptor_b" for extracting all used receptor for 

                                                   the register.

                                              (2)(a)Updated M2 test for GAL from GAL_Species_TEC_decisions_reveiw_23112015.(b) Created draftBA-

                                                   LEB-GAL-130-WaterDependentAssetRegister-AssetList-v20160104.xlsx"

## **Dataset Citation** 

Bioregional Assessment Programme (2013) Asset database for the Galilee subregion on 04 January 2016. Bioregional Assessment Derived Dataset. Viewed 12 December 2018, http://data.bioregionalassessments.gov.au/dataset/12ff5782-a3d9-40e8-987c-520d5fa366dd.

## **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** [Asset database for the Galilee subregion on 10 September 2015](https://data.gov.au/data/dataset/c22a13bf-07ea-4eaa-960d-79d488a50496)

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