Dataset: Asset database for the Clarence-Moreton bioregion on 16 September 2015



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 V7 database has been updated to include the Receptor data from Clarence-Moreton assessment team. The relevant tables of ReceptorList and tbl_Receptors and the spatial data of GM_CLM_ReceptorList_pt were added to this version. The Clarence-Moreton Asset database v7 supersedes the previous version of the Asset database only in Receptor relevant tables/ feature class (i.e. ReceptorList, tbl_Receptors and GM_CLM_ReceptorList_pt ).

This dataset contains v7 of the Asset database (CLM_asset_database_20150916.mdb), a Geodatabase version for GIS mapping purposes (CLM_asset_database_20150916_GISOnly.gdb), the draft Receptor Register spreadsheet (BA-CLM-CLM-140-ReceptorRegister-V20150916.xlsx), a data dictionary (CLM_asset_database_doc_20150916.doc), and a folder (NRM_DOC) containing documentation associated with the 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_20150916.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_20150916.doc" located in the zip file. Some of the source data used in the compilation of this dataset is restricted.

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"

Dataset Citation

Bioregional Assessment Programme (2014) Asset database for the Clarence-Moreton bioregion on 16 September 2015. Bioregional Assessment Derived Dataset. Viewed 10 July 2017,

Dataset Ancestors

General Information