NSW Office of Water GW licence extract linked to spatial locations GLOv3 12032014
收藏资源简介：
## **Abstract** \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 difference between NSW Office of Water GW licences - GLO v2 and v3 is that an additional column has been added, 'Asset Class' that aggregates the purpose of the licence into the set classes for the Asset Database. Also the 'Completed_Depth' has been added, which is the total depth of the groundwater bore. These columns were added for the purpose of the Asset Register.\n\n\n\nThe aim of this dataset was to be able to map each groundwater works with the volumetric entitlement without double counting the volume and to aggregate/ disaggregate the data depending on the final use.\n\n\n\nThis has not been clipped to the Gloucester PAE, therefore the number of economic assets/ relevant licences will drastically reduce once this occurs.\n\n## **Dataset History** \n\nProcedure\n\n\n\n1) Original spread sheets provided by the NSW Office of Water have mulitple licence instances if there are more than one WA/CA number. This means that there are more than 1 works or permit to each licence. The aim is to only have one licence instance. \n\n\n\n2) Using the pivot results, the individual licence numbers were combined into one colume in the 2.1 Linked Licence Number spreadsheet. \n\n\n\n3) Using the new column of licence numbers, several vlookups were created to bring in other data. This includes the bore number from 1.1 From_Arc Spreadsheet and the original data from the 1.2 From_Spreadsheet_WALS and 1.3 From_Spreadsheet_OLD spreadsheets. (Please note, columns of the two spreadsheets 1.2 From_Spreadsheet_WALS and 1.3 From_Spreadsheet_OLD spreadsheets overlap. Where they do they are combined. The only ones that dont are the Share/Entitlement/allocation, these mean different things. \n\n\n\n4) A hydro ID column was created, this is a code that links this NSW to the NGIS, which is basically a ".1.1" at the end of the bore code.\n\n\n\n5) A quality check "3.4 QA Check Arc and Spreadsheet" was to make sure that all the shape file licences are reperesented in the WALs and Old spreadsheets, which they are.\n\n\n\nPlease Note\n\n1) The WA/CA column will not include all the WA/CAs attached to the Licence. A vlookup will only get the top one if the multiple which is adequte for this purpose.\n\n\n\n2) A "null" value means that there was nothing from the orginal table that could be put into the new table. Blanks can be problematic in Arc so a null is put in place instead. A "0" value means that there was a "0" in the table, to avoid assumptions. \n\n\n\n3) The share componant/entitlement/ allocation is per licence AND per bore. Any licence that had more than one bore had no volumetric amoutn attached so it can be assumed that the licenced has only one bore and the volume is from licence and bore.\n\n## **Dataset Citation** \n\nBioregional Assessment Programme (2014) NSW Office of Water GW licence extract linked to spatial locations GLOv3 12032014. Bioregional Assessment Derived Dataset. Viewed 18 July 2018, http://data.bioregionalassessments.gov.au/dataset/587c6834-09aa-4cd8-8972-5632880f5ae5.\n\n## **Dataset Ancestors** \n\n* **Derived From** [NSW Office of Water Groundwater Entitlements Spatial Locations](https://data.gov.au/data/dataset/0f4da0d0-9e82-42f3-84da-1148e0b730c1)\n\n* **Derived From** [NSW Office of Water Groundwater licence extract linked to spatial locations GLOv2 19022014](https://data.gov.au/data/dataset/38c9e2c9-02ac-45a8-a188-936f91a58391)\n\n* **Derived From** [NSW Office of Water Groundwater Licence Extract Gloucester - Oct 2013](https://data.gov.au/data/dataset/56a49393-abaa-43f2-8b7d-97c5d414c1cf)\n\n
**摘要** 本数据集由生物区域评估计划（Bioregional Assessment Programme）从多份源数据集衍生而来。源数据集的标识信息已列于本元数据声明的谱系（Lineage）字段中，该衍生数据集的制作流程则记载于历史（History）字段内。 新南威尔士州水务局（NSW Office of Water）地下水许可证GLO v2与v3版本的差异在于，新增了“资产类别（Asset Class）”列，该列用于将许可证用途归集至资产数据库的预设类别中；同时新增了“完钻深度（Completed_Depth）”列，其指代地下水钻孔的总深度。上述两列均为资产登记册的需求而增设。 本数据集的设计目标为，实现每个地下水工程与容积权限的精准匹配，避免容积重复统计，并可根据最终使用需求对数据进行聚合或拆解。 本数据集尚未裁剪至格洛斯特PAE区域，因此一旦完成裁剪，其中涉及的经济资产/相关许可证数量将大幅缩减。 **数据集历史** 制作流程 1) 原由新南威尔士州水务局提供的原始电子表格中，若存在多个取水许可（WA/CA）编号，则对应多条许可证实例，即单个许可证可对应多个工程或许可。本次处理的目标为将每条许可证仅保留一个实例。 2) 基于透视表结果，在2.1《关联许可证编号》电子表格中，将多个独立许可证编号合并为一列。 3) 依托新增的许可证编号列，通过多组vlookup引入其他数据，包括来自1.1《Arc源电子表格》的钻孔编号，以及来自1.2《WALS源电子表格》与1.3《旧版源电子表格》的原始数据。需注意：1.2《WALS源电子表格》与1.3《旧版源电子表格》的列存在重叠，重叠列已进行合并；仅份额/权限/分配列除外，此类列含义存在差异。 4) 新增水文标识（hydro ID）列，该编码用于将本数据集与NGIS建立关联，具体为在钻孔代码末尾添加“.1.1”后缀。 5) 开展“3.4 ArcGIS与电子表格质量检查”工作，以确保所有形状文件（Shapefile）中的许可证记录均在WALS与旧版电子表格中完整收录，本次处理已达成该校验目标。 注意事项 1) WA/CA列不会涵盖许可证关联的全部取水许可编号，使用vlookup仅能获取首个匹配项，但该结果已满足本次任务需求。 2) “null”值指代原始表格中无可用于填充至新表格的数据。由于ArcGIS中空白值易引发问题，故采用null值替代空白。而“0”值则对应原始表格中的“0”记录，以避免产生不合理假设。 3) 份额组件/权限/分配均按许可证及钻孔进行划分。若某许可证关联多个钻孔，则未附带容积数值，此时可默认该许可证仅对应单个钻孔，容积取自该许可证及其关联钻孔。 **数据集引用** 生物区域评估计划（Bioregional Assessment Programme）（2014）：新南威尔士州水务局地下水许可证提取数据及空间关联位置GLOv3 12032014。生物区域评估衍生数据集。查阅日期：2018年7月18日，链接：http://data.bioregionalassessments.gov.au/dataset/587c6834-09aa-4cd8-8972-5632880f5ae5. **数据集溯源** * **衍生自** [新南威尔士州水务局地下水权限空间位置数据集](https://data.gov.au/data/dataset/0f4da0d0-9e82-42f3-84da-1148e0b730c1) * **衍生自** [新南威尔士州水务局地下水许可证提取数据及空间关联位置GLOv2 19022014](https://data.gov.au/data/dataset/38c9e2c9-02ac-45a8-a188-936f91a58391) * **衍生自** [新南威尔士州水务局地下水许可证提取数据（格洛斯特，2013年10月）](https://data.gov.au/data/dataset/56a49393-abaa-43f2-8b7d-97c5d414c1cf)
