Asset database for the Clarence-Moreton bioregion on 24 February 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. 



The Clarence-Moreton Asset database v8 supersedes the previous versions of the Asset database, especially V6.1 20150819(GUID:  e265e9cf-b3a3-474c-850b-db4616389a24) and V7  20150916 GUID: e7940ec8-ec73-4cc5-bc4e-0c85f98354f1). This dataset contains v8  of the Asset database (CLM_asset_database_20160224.mdb), a Geodatabase version for GIS mapping purposes (CLM_asset_database_20160224_GISOnly.gdb), the draft Water Dependent Asset Register spreadsheet (BA-CLM-CLM-130-WaterDependentAssetRegister-AssetList-v20160224.xlsx), the draft Receptor Register spreadsheet (BA-CLM-CLM-140-ReceptorRegister-v20160224.xlsx), a data dictionary (CLM_asset_database_doc_20160226.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



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 Clarence-Morton 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 Clarence-Morton 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 " CLM_asset_database_doc_20160226.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 "CLM_asset_database_doc_20160226.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 Clarence-Moreton bioregion on 24 February 2016 Public (https://data.gov.au/data/dataset/b3338edb-a6df-47ae-944f-0be927639bca)

## **Dataset History** 

OBJECTID	VersionID	Date_	Notes

1	1	2/07/2014	Initial database.

2	2	15/08/2014	Initial database with new WSP assets

3	3	9/09/2014	add 87 line assets from early  SEQLD WAIT data ; updated NSW RegERiv and GWMP assets, and changed AID (5010 to 5180 to 15010 to 15180)

4	3.1	15/09/2014	" Updated  class ""Groundwater-dependent ecosystems"" to ""Groundwater-dependent ecosystem"""

5	4	20/02/2015	Add additional eight datasets from the community consultation and assessment team: QLD RE 11, NSW GDE, QLD Wetland System 100K, QLD GDE Surface Areas, QLD GDE Line, QLD GDE Terrestrial Areas, NGIS QLD Bores and AHGF Network Stream. Turn off National GDE assets

6	5	3/06/2015	As requested by CLM assessment team, those NGIS economic assets AIDs from17009 and 17013 inclusive replace previous NGIS ecological assets (from same QLD NGIS elements) AIDs from16800 and 16803 inclusive. Turn off assets AIDs from16800 and 16803

7	6	6/07/2015	This v6 CLM Asset database includes M2 test results (Does the asset pass the water dependency test? or WDTest ) from Clarence-Moreton assessment project team.



8	6.1	19/08/2015	"(1) Corrected the spelling error of PAE_Region to Clarence-Moreton for all assets and elements

(2) (a) Extracted long  ( >255 characters) WD rationale  for 2 assets in tab "Water-dependent asset register"  and 4 assets in tab "Asset list " in 1.30 Excel file  (b) recreated in BA-CLM-CLM-130-WaterDependentAssetRegister-AssetList-V20150819.xlsx

(3) Modified queries (Find_All_Asset_List and Find_Waterdependent_asset_register) for (2)(a)"



9	7	16/09/2015	"(1)(a) Add table ReceptorList in CLM_asset_database_20150916.mdb, using the Excel file  from CLM project team  (b) Create draft BA-CLM-CLM-140-ReceptorRegister-V20150916.xlsx

(2) Add table tbl_Receptors in CLM_asset_database_20150916.mdb and GM_CLM_ReceptorList_pt  in CLM_asset_database_20150916_GISOnly.gdb,    using the spatial data from CLM project team;

(3)Add SQL query "Find_used_Receptor" for extracting all used receptor for the register"



10	8	24/02/2016	"(1) Total number of registered water assets was increased by 40 due to:



(a) The 9 assets changed M2 test to "Yes" and 1 asset changed M2 reason from the review done by Ecologist group. The original data is included the database as the table tbl_CLM _Species_TEC_decisions_reveiw_23112015

(b) 31 indigenous water assets from OWS were added. The data and documents from OWS are included in subdirectory Indigenous_doc

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

(2) For Receptors::

(a) Update LandscapeClass 'falls miscellaneous'  to  'waterfalls' fro 24 receptors

(b) Update LandscapeClass 'springs and waterholes miscellaneous' to 'springs and waterholes' for 1277 receptors

(c) Updated LandscapeClass ( derived from CLM land classification  dataset provided by CLM assessment team ) for 10460 receptors

(d) Created the draft Receptor Register file (BA-CLM-CLM-140-ReceptorRegister-v20160224.xlsx)"

## **Dataset Citation** 

Bioregional Assessment Programme (2014) Asset database for the Clarence-Moreton bioregion on 24 February 2016. Bioregional Assessment Derived Dataset. Viewed 10 July 2017, http://data.bioregionalassessments.gov.au/dataset/6d11ffbc-ea57-49cb-8e00-f97761e0c5d6.

## **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** [Combined Surface Waterbodies for the Clarence-Moreton bioregion](https://data.gov.au/data/dataset/9ff7ab58-2e30-4268-bdf3-bc8aa72aa940)

* **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** [Version 02 Asset list for Clarence Morton 8/8/2014 - ERIN ORIGINAL DATA](https://data.gov.au/data/dataset/1f9e74b4-a3b7-4693-acb7-ae29653b6392)

* **Derived From** [Asset database for the Clarence-Moreton bioregion on 11 December 2014, minor version v20150603](https://data.gov.au/data/dataset/248361ac-2495-4228-a4e4-e3c6cabf7433)

* **Derived From** [NSW Office of Water Surface Water Entitlements Locations v1_Oct2013](https://data.gov.au/data/dataset/fc872710-998e-4c76-8b98-1df383c53de6)

* **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** [Geofabric Surface Catchments - V2.1](https://data.gov.au/data/dataset/ea1b6f6c-e8a3-4c78-a463-044c89857fc0)

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

* **Derived From** [CLM - 16swo NSW Office of Water Surface Water Offtakes - Clarence Moreton v1 24102013](https://data.gov.au/data/dataset/2b672f0a-9ca1-455d-b96f-9fe3d2d97bdb)

* **Derived From** [Multi-resolution Valley Bottom  Flatness MrVBF at three second resolution CSIRO 20000211](https://data.gov.au/data/dataset/7dfc93bb-62f3-40a1-8d39-0c0f27a83cb3)

* **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** [Australia - Present Major Vegetation Groups - NVIS Version 4.1 (Albers 100m analysis product)](https://data.gov.au/data/dataset/57c8ee5c-43e5-4e9c-9e41-fd5012536374)

* **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** [Geofabric Surface Network - V2.1.1](https://data.gov.au/data/dataset/d84e51f0-c1c1-4cf9-a23c-591f66be0d40)

* **Derived From** [Queensland wetland data version 3 - wetland areas - WETCLASS: E, L, M, P, R](https://data.gov.au/data/dataset/421fa3ce-36c6-4932-8ec7-2b9bf78acf63)

* **Derived From** [South East Queensland GDE (draft)](https://data.gov.au/data/dataset/3b523838-d2a0-4cdc-a792-8ff38d4651ab)

* **Derived From** [Natural Resource Management (NRM) Regions 2010](https://data.gov.au/data/dataset/1d54e38f-4051-4f0c-a350-c7dbd8eba65b)

* **Derived From** [Version 01 Asset list for Clarence Morton 10/3/2014 - ERIN ORIGINAL DATA](https://data.gov.au/data/dataset/7315f0b8-b9a4-4393-a659-f114a77f5918)

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

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

* **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** [GEODATA TOPO 250K Series 3, File Geodatabase format (.gdb)](https://data.gov.au/data/dataset/96ebf889-f726-4967-9964-714fb57d679b)

* **Derived From** [Ramsar Wetlands of Australia](https://data.gov.au/data/dataset/d65cc156-944d-4961-bfba-eacfd61db63a)

* **Derived From** [CLM - Bore allocations QLD v02](https://data.gov.au/data/dataset/1992e8a9-4f09-4048-9725-7d03ed228751)

* **Derived From** [GEODATA TOPO 250K Series 3](https://data.gov.au/data/dataset/a0650f18-518a-4b99-a553-44f82f28bb5f)

* **Derived From** [NSW Catchment Management Authority Boundaries   20130917](https://data.gov.au/data/dataset/0dc4272e-c081-4ed4-9645-aa336ffacd85)

* **Derived From** [Geological Provinces - Full Extent](https://data.gov.au/data/dataset/0a064b3b-2a1e-4672-80d9-03333be67aad)

* **Derived From** [Geofabric Surface Cartography - V2.1](https://data.gov.au/data/dataset/5342c4ba-f094-4ac5-a65d-071ff5c642bc)

* **Derived From** [Asset database for the Clarence-Moreton bioregion on 19 August 2015.](https://data.gov.au/data/dataset/e265e9cf-b3a3-474c-850b-db4616389a24)

* **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** [CLM16swo NSW Office of Water Surface Water Offtakes processed for Clarence Moreton v2 06032014](https://data.gov.au/data/dataset/e63cc5fd-b3f7-4dad-a9a7-d93ac361beb8)

* **Derived From** [CLM16gwl NSW Office of Water, GW licence extract linked to spatial locations in CLM v2 28022014](https://data.gov.au/data/dataset/ed68451f-8e24-4fed-988d-0aef12a997ee)

* **Derived From** [Bioregional Assessment areas v03](https://data.gov.au/data/dataset/96dbf469-5463-4f4d-8fad-4214c97e5aac)

* **Derived From** [Northern Rivers CMA GDEs (DRAFT DPI pre-release)](https://data.gov.au/data/dataset/ac1bd285-5f50-46e2-bc04-b21e8e182a62)

* **Derived From** [Groundwater Bores Without Licence NGIS QLD CLM 20150211](https://data.gov.au/data/dataset/e1e14c60-480e-4f91-85dc-1b1a7de9fc82)

* **Derived From** [National Heritage List Spatial Database (NHL) (v2.1)](https://data.gov.au/data/dataset/26daa8d7-a90e-47f3-982b-0df362414e65)

* **Derived From** [Asset database for the Clarence-Moreton bioregion on 11 December 2014, minor version v20150220](https://data.gov.au/data/dataset/5c6ea1a6-bc86-4231-b233-00b87cef6254)

* **Derived From** [Land classification for the Clarence-Moreton preliminary assessment extent](https://data.gov.au/data/dataset/a1d97959-d0f9-4deb-ab9b-af88120efd07)

* **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** [NSW Office of Water combined geodatabase of regulated rivers and water sharing plan regions](https://data.gov.au/data/dataset/24157c41-c42f-4e1f-a791-a1ad18c8215d)

* **Derived From** [CLM16swo NSW Office of Water Surface Water Offtakes processed for Clarence Moreton v3 12032014](https://data.gov.au/data/dataset/715a405b-dc50-46ca-9704-1f698e5b66fc)

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

* **Derived From** [Multi-resolution Ridge Top Flatness at 3 second resolution CSIRO 20000211](https://data.gov.au/data/dataset/d29afa3d-2b3e-41c1-8c3f-e1b2500f16cc)

* **Derived From** [New South Wales NSW Regional CMA Water Asset Information WAIT tool databases, RESTRICTED Includes ALL Reports](https://data.gov.au/data/dataset/a2a929ea-2cb3-42ab-86b9-87deac68acae)

* **Derived From** [CLM16gwl NSW Office of Water_GW licence extract linked to spatial locations_CLM_v3_13032014](https://data.gov.au/data/dataset/4b0e74ed-2fad-4608-a743-92163e13c30d)

* **Derived From** [CLM Preliminary Assessment Extent Definition & Report( CLM PAE)](https://data.gov.au/data/dataset/2cdd0e81-026e-4a41-87b0-ec003eddc5c1)

* **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** [New South Wales NSW - Regional - CMA - Water Asset Information Tool - WAIT - databases](https://data.gov.au/data/dataset/330532aa-66ba-44f5-984b-8a21a99661a0)

* **Derived From** [Receptors for the Clarence-Moreton subregion](https://data.gov.au/data/dataset/64b3d356-cfd8-4d23-92da-79396260b0ee)

* **Derived From** [Catchment Scale Land Use of Australia - 2014](https://data.gov.au/data/dataset/6f72f73c-8a61-4ae9-b8b5-3f67ec918826)

* **Derived From** [CLM16gwl NSW Office of Water Groundwater Licence Extract Clarence Moreton-  Oct 2013](https://data.gov.au/data/dataset/d9bd77b6-5bc3-4832-a212-0e8f5ba48076)

* **Derived From** [Asset database for the Clarence-Moreton bioregion on 16 September 2015](https://data.gov.au/data/dataset/e7940ec8-ec73-4cc5-bc4e-0c85f98354f1)

* **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** [QLD Petroleum Leases, 28/11/2013](https://data.gov.au/data/dataset/aac9dbce-f98b-4b95-9a04-d5a5f405d409)

* **Derived From** [Stein Index Classification for Streams National 20150513](https://data.gov.au/data/dataset/8915d14d-7c22-404a-ba11-07f0c25fd177)

* **Derived From** [Bioregional Assessment areas v01](https://data.gov.au/data/dataset/0fd0d820-30b3-451f-a126-a50040426999)

* **Derived From** [Bioregional Assessment areas v02](https://data.gov.au/data/dataset/e414b1b3-c42e-42e9-9cc4-2093054aa35f)

* **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** [QLD Current Exploration Permits for Minerals (EPM) in Queensland 6/3/2013](https://data.gov.au/data/dataset/5d8c8f5c-7ace-40ce-87ce-0b311b028c10)

* **Derived From** [NSW Office of Water Groundwater Entitlements Spatial Locations](https://data.gov.au/data/dataset/0f4da0d0-9e82-42f3-84da-1148e0b730c1)

* **Derived From** [Mitchell Landscapes NSW OEH v3 2011](https://data.gov.au/data/dataset/e64597db-453c-46be-a352-360b775d2852)

* **Derived From** [Commonwealth Heritage List Spatial Database (CHL)](https://data.gov.au/data/dataset/57720684-4948-45db-a2c8-37259d531d87)

* **Derived From** [Geoscience Australia, 1 second SRTM Digital Elevation Model (DEM)](https://data.gov.au/data/dataset/9a9284b6-eb45-4a13-97d0-91bf25f1187b)

* **Derived From** [Collaborative Australian Protected Areas Database (CAPAD) 2010 (Not current release)](https://data.gov.au/data/dataset/7b649c6d-fdbf-40e3-b002-db521665af53)



Tags: Clarence-Moreton bioregion, biota, economy, environment
Organization: Bioregional Assessment Program