Asset database for the Pedirka subregion on 08 March 2016

## **Abstract** \n\n\n\nThe 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. \n\n\n\nThe asset database for Pedirka subregion (v4) supersedes previous versions of the Arckaringa Asset database (Asset database for the Pedirka subregion on 27 August 2015, GUID: 62dc178f-65ae-4e6a-b5d4-12895b37d04c). Total number of registered water assets in this V4 database was increased by 2 because two assets changed M2 test from "No" to "Yes" from M2 test review done by Ecologist group.\n\n\n\nThis dataset contains v4 of the Asset database (PED_asset_database_20160308.mdb), a Geodatabase version for GIS mapping purposes (PED_asset_database_20160308_GISOnly.gdb), an updated draft Water Dependent Asset Register spreadsheet (BA-LEB-PED-130-WaterDependentAssetRegister-AssetList-v20160308.xlsx), a data dictionary (PED_asset_database_doc_20160308.doc), and a folder (NRM_DOC) containing documentation associated with the Water Asset Information Tool (WAIT) process.\n\n \n\nThe tabular attribute data can be joined in a GIS to the "Assetlist" table in the mdb database using the "AID" field to view asset attributes (BA attribution). To view the more detailed attribution at the element-level, the intermediate table "Element_to_asset" can be joined to the assets spatial datasets using AID, and then joining the individual attribute tables from the Access database using the common "ElementID" fields. Alternatively, the spatial feature layers representing elements can be linked directly to the individual attribute tables in the Access database using "ElementID", but this arrangement will not provide the asset-level groupings.\n\n\n\nFurther information is provided in the accompanying document, "PED_asset_database_doc_20160308.doc" located within this dataset.\n\n\n\nThe public version of this asset database can be accessed via the following dataset: Asset database for the Pedirka subregion on 08 March 2016 Public (https://data.gov.au/data/dataset/c104deb9-5969-4427-977a-12f284564c93).\n\n## **Dataset History** \n\nVersionID\tDate\tNotes\n\n1.0\t13/03/2015\tInitial database\n\n\n\n1.1\t19/03/2015\tAdd SA point Eco data (2 assets and 28 Elements) and fixed Note field value in table AssetDecisions\n\n\n\n2\t7/08/2015\t"(1) Updated the database for M2 test results provided from PED assessment team and created the draft BA-LEB-PED-130-WaterDependentAssetRegister-AssetList-V20150807.xlsx \n\n(2) Updated the group, subgroup, class and depth for (up to) 67 NRM WAIT assets to cooperate the feedback to OWS from relevant SA NRM office (whose staff missed the asset workshop). The AIDs and names of those assets are listed in table LUT_changed_asset_class_20150807 in PED_asset_database_20150807.mdb\n\n(3) Appendix C in PED_asset_database_doc_201500807.doc is about total elements/assets in current Group and subgroup\n\n(4) Four SQL queries (Find_All_Used_Assets, Find_All_WD_Assets, Find_Amount_Asset_in_Class and Find_Amount_Elements_in_Class) in PED_asset_database_20150807.mdb can be used for total assets and total numbers\n\n(5)There are 1 asset (in PED subregion), which is same as 1 asset in MBC subregion. Its AID, Asset Name, Group, SubGroup, Depth, Source and ListDate is using values from MBC asset. This asset is listed in table LUT_DUP_PED_MBC in PED_asset_database_20150807.mdb\n\n(6)The databases, especially spatial database (PED_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."\n\n\n\n3 27/08/2015 M2_Reason in the Assetlist table and DecisionBrief in the AssetDecisions table have been updated with short descriptions (