CLM16gwl NSW Office of Water, GW licence extract linked to spatial locations in CLM v2 28022014

## **Abstract** \n\nThe dataset was derived by the Bioregional Assessment Programme. This dataset was derived from multiple datasets. You can find a link to the parent datasets in the Lineage Field in this metadata statement. The History Field in this metadata statement describes how this dataset was derived.\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 CLM PAE, therefore the number of economic assets/ relevant licences will drastically reduce once this occurs. \n\n\n\nThe Clarence Moreton groundwater licences includes an extract of all licences that fell within the data management acquisition area as provided by BA to NSW Office of Water.\n\n\n\nAim: To get a one to one ratio of licences numbers to bore IDs. \n\nImportant notes about data:\n\nData has not been clipped to the PAE.\n\n\n\nClarence Moreton worksheet links the individual licence to a works and a volumetric entitlement. For most sites, this can be linked to a bore which can be found in the NGIS through the HydroID. (National_Groundwater_Information_System_v1.1_Sept2013 GUID = e157b1cd-3cb7-4cf9-a13c-a6bed576b8c7). This will allow analysis of depths, lithology and hydrostratigraphy where the data exists.\n\nWe can aggregate the data based on water source and water management zone as can be seen in the other worksheets. \n\n\n\nData available: \n\n\n\nOriginal Data: Any data that was bought in from NSW Offcie of Water, includes\n\nSpatial locations provided by NoW- This is a exported data from the submitted shape files. Includes the licence (LICENCE) numbers and the bore ID (WORK_NUO). (Refer to lineage NSW Office of Water Groundwater Entitlements Spatial Locations).\n\nSpreadsheet_WAL - The spread sheet from the submitted data, WLS-EXTRACT_WALs_volume. (Refer to Lineage NSW Office of Water Groundwater Licence Extract CLM- Oct 2013)\n\nWLS_extracts - The combined spread sheets from the submitted data, WLS-EXTRACT . (Refer to Lineage NSW Office of Water Groundwater Licence Extract CLM- Oct 2013)\n\n\n\nProcessed Data: The two final products, includes\n\nCLM_Draft - this includes cancelled licences and licences where the old licence has been replaced by a share component (essentially a repeat)\n\nCLM_final- The final working linking all licences to bore IDs, removal of cancelled licences and licences that have been replaced in the new WaterAct. Also includes the volume of the licence per works \n\nAggregated share component to water sharing plan, water source and water management zone\n\n## **Purpose** \n\nNo decision have been made in regards to what purpose of groundwater should be protected. Therefore the purpose currently includes groundwater bores that have been drilled for non-extractive purposes including experimental research, test, monitoring bore, teaching, mineral explore and groundwater explore\n\nNo volume has been included for domestic & stock as it is a basic right. Therefore an arbitrary volume could be applied to account for D&S use.\n\nLicence Number - Each sheet in the Original Data has a licence number, this is assumed to be the actual licence number. Some are old because they have not been updated to the new WA. Some are new (From_Spreadsheet_WALs). This is the reason for the different codes.\n\nWA/CA - This number is the 'works' number. It is assumed that the number indicates the bore permit or works approval. This is why there can be multiple works to licence and licences to works number.\n\n## **Dataset History** \n\nInstructions\n\n\n\nProcedure: \n\n\n\n1) Original spread sheets from the licence extract ( GUID d9bd77b6-5bc3-4832-a212-0e8f5ba48076) have mulitple licence instances if there are more than one WA/CA (works) number. This means that there are more than one works or permit to the licence. The aim is to only have one licence instance. \n\n\n\n2) The individual licence numbers were combined into one column \n\n\n\n3) Using the new column of licence numbers, several vlookups were created to bring in other data. Where the columns are identical in the original spreadsheets, 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) All 'cancelled' licences were removed\n\n\n\n6) A count of the number of works per licence and number of bores were included in the spreadsheet.\n\n\n\n7) Where the ShareComponent = NA, the Entitlement = 0, Allocation = 0 and there was more than one instance of the same bore, this means that the original licence assigned to the bore has been replaced by a new licence with a share component. Where these criteria were met, the instances were removed\n\n\n\n8) a volume per works ensures that the volume of the licence is not repeated for each works, but is divided by the number of works\n\n\n\n\n\nPlease refer to the Bioregional assessment data conversion script for methodology.\n\n## **Dataset Citation** \n\nBioregional Assessment Programme (2014) CLM16gwl NSW Office of Water, GW licence extract linked to spatial locations in CLM v2 28022014. Bioregional Assessment Derived Dataset. Viewed 28 September 2017, http://data.bioregionalassessments.gov.au/dataset/ed68451f-8e24-4fed-988d-0aef12a997ee.\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** [CLM16gwl NSW Office of Water Groundwater Licence Extract Clarence Moreton- Oct 2013](https://data.gov.au/data/dataset/d9bd77b6-5bc3-4832-a212-0e8f5ba48076)\n\n

**摘要**

本数据集由生物区域评估计划（Bioregional Assessment Programme）衍生而来，其数据源为多份公开数据集。本元数据记录的「谱系字段（Lineage Field）」中提供了父数据集的链接，「历史字段（History Field）」则说明了本数据集的衍生流程。

本数据集的构建目标为：实现各地下水工程与水量许可额度的一一匹配，避免水量重复统计，并可根据最终使用需求对数据进行聚合与拆解。

本数据集尚未裁剪至CLM PAE范围，完成该裁剪操作后，其中涉及的经济资产与相关许可数量将大幅缩减。

克拉伦斯-莫顿（Clarence Moreton, CLM）地下水许可数据集提取了由澳大利亚生物区域评估局（BA）提供给新南威尔士州水资源办公室（NSW Office of Water）的数据管理采集范围内的全部许可条目。

**核心目标**：实现许可编号与钻孔编号的一一对应关系。

**重要数据说明**：

数据尚未裁剪至PAE范围。

克拉伦斯-莫顿工作表将单个许可与对应工程及水量许可额度绑定。多数站点可通过HydroID在国家地下水信息系统（National Groundwater Information System, NGIS）中查询到对应的钻孔信息。（2013年9月发布的v1.1版国家地下水信息系统全局唯一标识符（Globally Unique Identifier, GUID）为e157b1cd-3cb7-4cf9-a13c-a6bed576b8c7）。若数据可用，可借此开展钻孔深度、岩性及水文地层学相关分析。

可根据水源与水管理分区对数据进行聚合统计，具体实现逻辑可参考其他工作表。

### 可用数据

#### 原始数据
所有从新南威尔士州水资源办公室导入的数据，包含：
1. 新南威尔士州水资源办公室（NSW Office of Water，简称NoW）提供的空间位置数据：该数据由提交的矢量形状文件导出，包含许可编号（LICENCE）与钻孔编号（WORK_NUO）。（详见谱系信息：新南威尔士州水资源办公室地下水许可空间位置数据集）
2. 电子表格_WAL：来自提交数据的电子表格`WLS-EXTRACT_WALs_volume`。（详见谱系信息：新南威尔士州水资源办公室2013年10月克拉伦斯-莫顿地下水许可提取数据集）
3. WLS提取数据集：来自提交数据的合并电子表格`WLS-EXTRACT`。（详见谱系信息：新南威尔士州水资源办公室2013年10月克拉伦斯-莫顿地下水许可提取数据集）

#### 处理后数据
最终产出的两类成果，包含：
1. CLM草案版本（CLM_Draft）：包含已注销许可，以及旧许可被份额组件（本质为重复条目）替代的许可条目
2. CLM最终版本（CLM_final）：完成所有许可与钻孔编号关联的最终可用数据集，已移除已注销许可及《新南威尔士州水法》（Water Act）中被替代的许可条目，同时包含每项工程对应的许可水量额度。
此外还完成了按水份额计划、水源及水管理分区的份额组件聚合。

## **数据用途**

目前尚未明确应当优先保护何种用途的地下水，因此当前数据集中包含了用于非开采目的的地下水钻孔，包括实验研究、测试钻孔、监测钻孔、教学用途钻孔、矿产勘探钻孔及地下水勘探钻孔。

家庭与畜牧用水（Domestic & Stock, D&S）属于公民基本权利，未纳入许可水量额度统计，因此可通过设定任意基准值来核算家庭与畜牧用水的占比。

**许可编号**：原始数据的各工作表均包含许可编号字段，默认其为真实有效的许可编号。部分编号为旧版编码，未更新至新版《新南威尔士州水法》编码体系；部分为新版编码（来自电子表格_WALs），这也是编码存在差异的核心原因。

**WA/CA编号**：该编号为「工程编号」，默认其代表钻孔许可或工程审批编号，因此可能出现一项许可对应多项工程、或一项工程对应多个许可编号的情况。

## **数据集处理历史**

### 处理流程说明

1. 来自许可提取数据集（全局唯一标识符：d9bd77b6-5bc3-4832-a212-0e8f5ba48076）的原始电子表格中，若同一许可关联多个WA/CA（工程）编号，则会生成多条许可实例条目，即一项许可可能对应多项工程或审批许可。本流程的核心目标是将同一许可的多条实例合并为单一条目。

2. 将分散的许可编号合并至单列中。

3. 基于合并后的许可编号列，通过多组VLOOKUP函数关联其他数据字段。原始电子表格中字段一致的列将进行合并，仅份额/许可量/分配量字段除外，三者含义各不相同。

4. 创建HydroID字段，该编码可将本数据集与国家地下水信息系统关联，其格式为在钻孔编码末尾添加`.1.1`。

5. 移除所有已注销的许可条目。

6. 在电子表格中新增「每项许可对应的工程数量」及「钻孔总数」统计字段。

7. 当份额组件（ShareComponent）为空值、许可量（Entitlement）与分配量（Allocation）均为0，且同一钻孔存在多条实例条目时，代表原绑定至该钻孔的许可已被带有份额组件的新许可替代。满足上述全部条件的条目将被移除。

8. 按工程拆分许可水量额度，确保同一许可的总水量不会因关联多项工程而被重复统计，而是将总水量按关联的工程数量均分。

详细处理方法可参考生物区域评估计划提供的数据转换脚本。

## **数据集引用**

生物区域评估计划（Bioregional Assessment Programme）（2014）：《CLM16gwl 新南威尔士州水资源办公室地下水许可提取与空间位置关联数据集（CLM v2 2014年2月28日版）》，生物区域评估衍生数据集。查阅时间：2017年9月28日，访问链接：http://data.bioregionalassessments.gov.au/dataset/ed68451f-8e24-4fed-988d-0aef12a997ee

## **数据集溯源**

* **衍生自** [新南威尔士州水资源办公室地下水许可空间位置数据集](https://data.gov.au/data/dataset/0f4da0d0-9e82-42f3-84da-1148e0b730c1)
* **衍生自** [CLM16gwl 新南威尔士州水资源办公室2013年10月克拉伦斯-莫顿地下水许可提取数据集](https://data.gov.au/data/dataset/d9bd77b6-5bc3-4832-a212-0e8f5ba48076)