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 (

## 摘要

本数据集由生物区域评估计划（Bioregional Assessment Programme）从多源数据集衍生而来。源数据集的相关信息已在本元数据声明的谱系（Lineage）字段中注明。生成该衍生数据集的具体处理流程已在本元数据声明的历史记录（History）字段中说明。

佩迪卡（Pedirka）次区域资产数据库（v4）取代了此前版本的阿卡林加（Arckaringa）资产数据库（即2015年8月27日发布的佩迪卡次区域资产数据库，全局唯一标识符（GUID）：62dc178f-65ae-4e6a-b5d4-12895b37d04c）。经生态学家团队开展的M2测试评审后，有2项资产将其M2测试结果从"否"更改为"是"，因此本v4数据库中已注册的水资产总数量增加了2项。

本数据集包含以下内容：v4版本的资产数据库文件（PED_asset_database_20160308.mdb）、用于地理信息系统（GIS, Geographic Information System）制图的地理数据库（Geodatabase）版本文件（PED_asset_database_20160308_GISOnly.gdb）、更新后的《水依赖资产登记册》草案电子表格（BA-LEB-PED-130-WaterDependentAssetRegister-AssetList-v20160308.xlsx）、数据字典文件（PED_asset_database_doc_20160308.doc），以及一个名为NRM_DOC的文件夹，该文件夹内包含与水资产信息工具（WAIT, Water Asset Information Tool）流程相关的文档资料。

可通过"AID"字段，将表格属性数据与该.mdb数据库中的"Assetlist"（资产列表）表进行关联，以查看资产属性（BA属性）。若要查看元素级别的更详细属性，则可通过AID字段将中间表"Element_to_asset"（元素-资产关联表）与资产空间数据集进行关联，随后通过公共字段"ElementID"（元素ID）将Access数据库中的各单独属性表进行关联。或者，也可直接通过"ElementID"字段，将代表元素的空间要素图层与Access数据库中的各单独属性表进行关联，但此种关联方式无法保留资产级别的分组信息。

更多详细信息可参阅本数据集中附带的文档《PED_asset_database_20160308.doc》。

本资产数据库的公开版本可通过以下数据集获取：2016年3月8日发布的佩迪卡次区域资产数据库（公开版）（https://data.gov.au/data/dataset/c104deb9-5969-4427-977a-12f284564c93）。

## 数据集历史记录

VersionID 日期 备注

1.0 13/03/2015 初始数据库

1.1 19/03/2015 添加南澳州点生态数据（2项资产与28个元素），并修复了资产决策表（AssetDecisions）中的备注字段值

2 7/08/2015 "(1) 根据佩迪卡评估团队提供的M2测试结果更新数据库，并生成了草案文件BA-LEB-PED-130-WaterDependentAssetRegister-AssetList-V20150807.xlsx
(2) 更新了最多67项NRM WAIT资产的分组、子分组、类别与深度信息，以响应南澳州自然保护管理办公室（NRM, Natural Resource Management）相关人员（此前未参与资产研讨会）向OWS提交的反馈意见。相关资产的AID与名称已列在PED_asset_database_20150807.mdb中的LUT_changed_asset_class_20150807表内。
(3) 《PED_asset_database_doc_201500807.doc》中的附录C说明了当前分组与子分组下的总元素/资产数量。
(4) PED_asset_database_20150807.mdb中的4个SQL查询（Find_All_Used_Assets、Find_All_WD_Assets、Find_Amount_Asset_in_Class与Find_Amount_Elements_in_Class）可用于统计总资产数与总元素数。
(5) 佩迪卡次区域存在1项资产与MBC次区域的1项资产完全一致。该资产的AID、资产名称、分组、子分组、深度、来源与列表日期均沿用了MBC资产的对应值。此项资产已列在PED_asset_database_20150807.mdb中的LUT_DUP_PED_MBC表内。
(6) 对数据库（尤其是空间数据库PED_asset_database_20150807Only.gdb）进行了优化，例如移除了空间数据中重复的属性字段，仅保留ID字段。用户需将资产列表表（Assetlist）或元素列表表（Elementlist）与相关空间数据进行关联。"

3 27/08/2015 已为资产列表表（Assetlist）中的M2_Reason字段与资产决策表（AssetDecisions）中的DecisionBrief字段添加了简短说明（