Galilee Water Accounts Table: volumes and purposes

## **Abstract** \n\nThe dataset was derived by the Bioregional Assessment Programme. The parent 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\nThis dataset contains the estimated groundwater use of all non-monitoring bores in the Galilee subregion that have not been reported as abandoned or disused.\n\n## **Purpose** \n\nThis dataset was created to provide information for GAL1.5 Current water accounts and to feed into the Galilee groundwater model.\n\n## **Dataset History** \n\nThis dataset was created using the methodology below:\n\n1.\tCompile a list of all bores in the Galilee subregion using data available from the Queensland groundwater database.\n\n2.\tFor each bore, where data are available incorporate interpreted stratigraphic picks for screened intervals into the dataset.\n\n3.\tFor each bore, where data are available, incorporate the most recent standing water level and bore maximum discharge data into the dataset. Maximum discharge will need to be re-calculated from L/second to ML/year.\n\n4.\tFrom the water licence dataset, incorporate the licensed water allocation volume, bore use and GMA information.\n\n5.\tIncorporate relevant Great Artesian Basin Sustainability Initiative (GABSI) data into the dataset and ensure that information in GABSI dataset is accurately reflected by the bore facility status records.\n\n6.\tInvestigate the bore facility status records. Bore facility status categories include: existing; abandoned but usable; abandoned and destroyed and proposed. Only those classed as 'existing' or 'abandoned but usable' were kept in the dataset. It is assumed that bores in other categories are not functional.\n\n7.\tInterrogate bore use records. Remove any bore from the dataset that is tagged as a monitoring bore. It is assumed that monitoring bores are not being used for any purpose other than groundwater monitoring.\n\n8.\tInsert two new blank columns, 'BA groundwater usage' and 'groundwater use source' in the dataset. The 'BA groundwater usage' column is where the estimate for annual groundwater usage is recorded for a bore in ML/year. The 'groundwater use source' column is where the decision on how yearly groundwater usage is assigned is recorded.\n\n9.\tPopulate the 'BA groundwater usage' and 'groundwater use source' columns.\n\nQueensland Government (2014b) provides some information on the estimation of annual water usage for groundwater bores in Queensland. Some steps to determining an estimate of groundwater usage for each bore are as follows:\n\n1.\tPopulate the BA groundwater usage column with water licence allocations that are greater than 0 ML/year. While the full allocation may not actually be used, this will provide a maximum allowable water allocation that could be pumped from a particular area. This has the potential to conserve the unused allocations when estimating groundwater usage for an area.\n\n2.\tSub-artesian bores - Queensland Government (2014b) suggests 5 ML/year or bore maximum flow rate, whichever is least.\n\n3.\tControlled Artesian Bore - Queensland Government (2014b) suggests 30 ML/year or the maximum flow rate, whichever is least.\n\n4.\tUncontrolled Artesian Bore - Queensland Government (2014b) suggests use the flow rate in ML/year.\n\n5.\tUncontrolled artesian bores missing flow rate information - the average flow rate for all uncontrolled artesian bores was calculated from existing data and used as a nominal value. For Galilee this equated to 124 ML/year.\n\n\n\nReference:\n\nQueensland Government (2014b) Estimating water usage for stock and domestic bores. email from Queensland Government officers to Tim Evans outlining some figures that could be used to estimate stock and domestic use. Email dated Tuesday, 9th September 2014.\n\n## **Dataset Citation** \n\nBioregional Assessment Programme (2015) Galilee Water Accounts Table: volumes and purposes. Bioregional Assessment Derived Dataset. Viewed 10 December 2018, http://data.bioregionalassessments.gov.au/dataset/1eb39a00-f557-4183-9fce-508a5c0e01d6.\n\n## **Dataset Ancestors** \n\n* **Derived From** [QLD Dept of Natural Resources and Mines, Groundwater Entitlements 20131204](https://data.gov.au/data/dataset/fd59894f-06b0-4c6f-9029-488934cfa7ba)\n\n* **Derived From** [QLD Department of Natural Resources and Mines Groundwater Database Extract 20142808](https://data.gov.au/data/dataset/a5c5cbdb-1152-43f7-9533-a123027b7ce1)\n\n* **Derived From** [QLD Dept of Natural Resources and Mines, Groundwater Entitlements linked to bores v3 03122014](https://data.gov.au/data/dataset/68bbd3fb-6e2a-4088-a3dd-55cc44c2f0d6)\n\n

## **摘要**

本数据集由生物区域评估计划（Bioregional Assessment Programme）衍生而来。父数据集在本元数据声明的谱系字段中标识，生成该衍生数据集的过程在本元数据声明的历史字段中描述。

本数据集包含加利利次区域内所有未被报告为废弃或停用的非监测钻孔的地下水使用量估算值。

## **目的**

创建本数据集旨在为GAL1.5当前水账户提供信息，并为加利利地下水模型提供输入数据。

## **数据集历史**

本数据集通过以下方法学创建：

1. 利用昆士兰地下水数据库的可用数据，编制加利利次区域内所有钻孔的清单。

2. 对于每个钻孔，若有可用数据，则将解释的地层岩性点纳入筛管区间的数据集。

3. 对于每个钻孔，若有可用数据，则纳入最新静水位和钻孔最大流量数据，并将流量单位从升/秒转换为百万升/年。

4. 从水许可证数据集纳入许可水分配量、钻孔用途及GMA信息。

5. 纳入相关大自流盆地可持续发展倡议（Great Artesian Basin Sustainability Initiative, GABSI）数据，并确保钻孔设施状态记录准确反映GABSI数据集的信息。

6. 核查钻孔设施状态记录：类别包括现有、废弃但可用、废弃且损毁及拟议。仅保留归类为“现有”或“废弃但可用”的钻孔，假设其他类别钻孔无功能。

7. 审查钻孔用途记录：移除所有标记为监测钻孔的条目，假设监测钻孔仅用于地下水监测，无其他用途。

8. 在数据集中插入两个新空白列：“BA地下水使用量”和“地下水使用来源”。“BA地下水使用量”列记录钻孔年地下水使用量估算值（单位：百万升/年），“地下水使用来源”列记录年地下水使用量分配方式的决策依据。

9. 填充“BA地下水使用量”和“地下水使用来源”列。

昆士兰政府（2014b）提供了昆士兰地下水钻孔年用水量估算的相关信息。每个钻孔用水量估算的步骤如下：

1. 将大于0百万升/年的许可水分配量填入BA地下水使用量列。尽管实际使用量可能未达全额分配，但这提供了特定区域可抽取的最大许可水量，有助于在区域用水量估算中保留未使用的分配额度。

2. 亚自流钻孔：昆士兰政府（2014b）建议取5百万升/年或钻孔最大流量中的较小值。

3. 受控自流钻孔：昆士兰政府（2014b）建议取30百万升/年或最大流量中的较小值。

4. 非受控自流钻孔：昆士兰政府（2014b）建议使用百万升/年单位的流量值。

5. 缺失流量信息的非受控自流钻孔：利用现有数据计算所有非受控自流钻孔的平均流量作为名义值，加利利次区域的该值为124百万升/年。

## **参考文献**

Queensland Government (2014b) 牲畜和生活用水钻孔的用水量估算。昆士兰政府官员致Tim Evans的电子邮件，概述了可用于估算牲畜和生活用水量的部分数据，邮件日期为2014年9月9日（星期二）。

## **数据集引用**

生物区域评估计划（2015）加利利水账户表：水量与用途。生物区域评估衍生数据集。查阅日期：2018年12月10日，网址：http://data.bioregionalassessments.gov.au/dataset/1eb39a00-f557-4183-9fce-508a5c0e01d6。

## **数据集祖先**

* **衍生自** [昆士兰自然资源和矿业部，20131204地下水权益数据集](https://data.gov.au/data/dataset/fd59894f-06b0-4c6f-9029-488934cfa7ba)

* **衍生自** [昆士兰自然资源和矿业部20142808地下水数据库提取数据](https://data.gov.au/data/dataset/a5c5cbdb-1152-43f7-9533-a123027b7ce1)

* **衍生自** [昆士兰自然资源和矿业部，2014年12月3日地下水权益与钻孔关联数据集v3](https://data.gov.au/data/dataset/68bbd3fb-6e2a-4088-a3dd-55cc44c2f0d6)