GAL Aquifer Formation Extents v01

## **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\nThis dataset is a model of the extent of aquifers in the Galilee geologic basin that is Moolyember Formation, Clematis Formation, Rewan Formation, Bandanna/Betts Creek Formation, Joe Joe Group, Basement (bottom of Galilee Basin).\n\n## **Purpose** \n\nThis dataset was created to provide formation extents for aquifers in the Galilee geological basin\n\n## **Dataset History** \n\nA Quality Assurance (QA) and validation process was conducted on the original well and bore data to choose wells/bores that are within 25 kilometres of the BA Galilee Region extent.\n\nThe QA/Validation process is as follows:\n\n1.\tWell data\n\n a.\tObtained excel file "QPED_July_2013_galilee.xlsx" from GA\n\n b.\tBased on stratigraphic information in "BH_costrat" tab formation names were regularised and simplified based on current naming conventions. \n\n c.\tSimplified names added to QPED_July_2013_galileet.xlsx as "Steve_geo" and "Steve_group"\n\n d.\tProduced new file "GSQ_Geology.xlsx" contained decimal latitude and longitude, KB elevation, top of unit in metres from KB, top of unit in metres AHD, bottom of unit in metres from KB, bottom of unit in metres AHD, original geology, simplified geology, simplified Group geology.\n\n i.\tKB obtained from "BH_wellhist"\n\n ii.\tWhere no KB information was available ie KB=0, sample the 1S DEM at the well's location to obtain height. KB=DEM+10. Marked well as having lower reliability.\n\n iii.\tCalculated Top_m_AHD = KB - Top_m_KB\n\n iv.\tCalculated Bottom_m_AHD = KB - Bottom_m_KB\n\n e.\tBrought GSQ_Geology.xlsx into ArcGIS\n\n f.\tSelected wells based on "Steve_geo" field for each model layer to produce a geodatabase for layer\n\n i.\tGSQ_basement_wells\n\n ii.\tGSQ_top_joe_joe_group\n\n iii.\tGSQ_top_bandanna_merge\n\n iv.\tGSQ_rewan_group\n\n v.\tGSQ_clematis\n\n vi.\tGSQ_moolyember\n\n g.\tAdditional wells and reinterpreted tops added to appropriate geodatabase based on well completion reports\n\n h.\tAdditional wells added to coverages to help model building process\n\n i.\tWell_name listed as Fake\n\n ii.\tException being GSQ_top_basement_fake which was created as a separate geodatabase\n\n i.\tCreated additional geodatabase for each model layer to highlight wells where the relevant model layer does not exist.to guide extent definition\n\n i.\tGSQ_joejoe_null\n\n ii.\tGSQ_rewan_ggroup_null\n\n iii.\tGSQ_clematis_null\n\n iv.\tGSQ_moolyember_null\n\n2.\tBore data\n\n a.\tObtained QLD_DNRM_GroundwaterDatabaseExtract_20131111 from GA\n\n b.\tUsed files REGISTRATIONS.txt, ELEVATIONS.txt and AQUIFER.txt to build GW_stratigraphy.xlsx\n\n i.\tBased on RN\n\n ii.\tLatitude from GIS_LAT (REGISTRATIONS.txt)\n\n iii.\tLongitude from GIS_LNG (REGISTRATIONS.txt)\n\n iv.\tElevation from (ELEVATIONS.txt)\n\n v.\tFORM_DESC from (AQUIFER.txt)\n\n vi.\tTop from (AQUIFER.txt)\n\n vii.\tBottom from (AQUIFER.txt)\n\n c.\tBrought GW_stratigraphy.xlsx into ArcGIS\n\n d.\tCreated gw_bores_galilee_dem\n\n i.\tSampled 1S DEM to obtain ground level elevation column RASTERVALU\n\n ii.\tCreated column top_m_AHD by RASTERVALU - Top\n\n e.\tSelected bores based on "FORM_DESC" field for each model layer to produce a geodatabase for each layer.\n\n i.\tGw_basement\n\n ii.\tGW_bores_joe_joe_group\n\n iii.\tGW_bores_bandanna\n\n iv.\tGw_bores_rewan\n\n v.\tGw_bores_clematis\n\n vi.\tGw_bores_moolyember\n\n3.\tSurface geology\n\n a.\tExtracted surface geology from QUEENSLAND GEOLOGY_AUGUST_2012 using Galilee BA region boundary with 25 kilometre boundary to form geodatabase QLD_geology_galilee\n\n b.\tSelected relevant surface geology from QLD_geology_galilee based on field "Name" for each model layer and created new geodatabase layers\n\n i.\tBasement_geology: Argentine Metamorphics,Running River Metamorphics,Charters Towers Metamorphics; Bimurra Volcanics, Foyle Volcanics, Mount Wyatt Formation, Saint Anns Formation, Silver Hills Volcanics, Stones Creek Volcanics; Bulliwallah Formation, Ducabrook Formation, Mount Rankin Formation, Natal Formation, Star of Hope Formation; Cape River Metamorphics; Einasleigh Metamorphics; Gem Park Granite; Macrossan Province Cambrian-Ordovician intrusives; Macrossan Province Ordovician-Silurian intrusives; Macrossan Province Ordovician intrusives; Mount Formartine, unnamed plutonic units; Pama Province Silurian-Devonian intrusives; Seventy Mile Range Group; and Kirk River beds, Les Jumelles beds.\n\n ii.\tJoe_joe_geology: Joe Joe Group\n\n iii.\tGalilee_permian_geology: Back Creek Group, Betts Creek Group, Blackwater Group\n\n iv.\tRewan_geology: Rewan Group\n\n 1.\tLater also made dunda_beds_geology to be included in Rewan model: Dunda beds\n\n v.\tClematis_geology: Clematis Group\n\n 1.\tLater also made warang_sandstone_geology to be included in Clematis model: Warang Sandstone\n\n vi.\tMoolyember_surface_geology: Moolyember Formation\n\n\n\nThe formation extents were derived as follows:\n\n1.\tWhere surface geology outcropped primarily on eastern margin of the basin. The aquifer extent was confined to the eastern margin of the outcrop geology.\n\n2.\tUsing the well and bore datasets, the extent was edited to include all wells/bores where the relevant layer was present and to exclude wells/bores where the relevant layer was absent.\n\n3.\tWhere no other information was present, the aquifer extent was guided by the shape of the Galilee Basin as shown in OZ SEEBASE.\n\n4.\tThe extents were saved as polygons and converted to grids using the Polygon to Raster tool.\n\n## **Dataset Citation** \n\nBioregional Assessment Programme (2014) GAL Aquifer Formation Extents v01. Bioregional Assessment Derived Dataset. Viewed 12 December 2018, http://data.bioregionalassessments.gov.au/dataset/e77f61d8-86d1-442a-a6ba-4256ae470595.\n\n## **Dataset Ancestors** \n\n* **Derived From** [Queensland Geological Digital Data - Detailed state extent, regional. November 2012](https://data.gov.au/data/dataset/03ea9d87-55f1-400e-86c0-b8f7492984c4)\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** [Phanerozoic OZ SEEBASE v2 GIS](https://data.gov.au/data/dataset/26e0fbd9-d8d0-4212-be52-ca317e27b3bd)\n\n* **Derived From** [Queensland petroleum exploration data - QPED](https://data.gov.au/data/dataset/cb357721-bf22-45c9-a82e-828807912dd4)\n\n

## 摘要

本数据集由生物区域评估计划（Bioregional Assessment Programme）基于多源数据集衍生而来。本元数据声明的**谱系（Lineage）**字段中已标注源数据集信息，其衍生制作流程则收录于本元数据声明的**历史（History）**字段中。

本数据集为加利利地质盆地（Galilee geologic basin）内含水层分布范围的建模成果，涉及的地层包括穆利恩伯组（Moolyember Formation）、克莱马蒂斯组（Clematis Formation）、里万组（Rewan Formation）、班丹纳/贝茨溪组（Bandanna/Betts Creek Formation）、乔乔群（Joe Joe Group）以及基底（加利利盆地底部）。

## 目的

本数据集的制作目的是为加利利地质盆地内的含水层提供对应地层的分布范围数据。

## 数据集历史

我们针对原始井数据与钻孔数据开展了质量保证（QA）与验证流程，以筛选出位于BA加利利区域范围内25千米以内的井/钻孔。

本次QA/验证流程如下：

1. 井数据

a. 从澳大利亚地球科学局（GA）获取Excel文件"QPED_July_2013_galilee.xlsx"。

b. 基于"BH_costrat"工作表中的地层信息，根据现行命名规范对地层名称进行标准化与简化处理。

c. 将简化后的地层名称以"Steve_geo"与"Steve_group"字段添加至"QPED_July_2013_galileet.xlsx"中。

d. 生成新文件"GSQ_Geology.xlsx"，其中包含十进制度格式的纬度与经度、补心高程（KB）、以KB为基准的地层顶界埋深（米）、澳大利亚高程基准（AHD）下的地层顶界高程（米）、以KB为基准的地层底界埋深（米）、AHD下的地层底界高程（米）、原始地层信息、简化后地层信息以及简化后的群级地层信息。

i. 补心高程数据从"BH_wellhist"工作表中获取。

ii. 若未获取到补心高程数据（即KB=0），则在井位处采样1秒分辨率数字高程模型（1S DEM）以获取高程值，计算公式为KB=DEM+10，并将该井标记为可靠性较低。

iii. 计算Top_m_AHD = KB - Top_m_KB。

iv. 计算Bottom_m_AHD = KB - Bottom_m_KB。

e. 将"GSQ_Geology.xlsx"导入ArcGIS。

f. 针对每个模型图层，基于"Steve_geo"字段筛选井数据，为各图层生成地理数据库：

i. GSQ_basement_wells

ii. GSQ_top_joe_joe_group

iii. GSQ_top_bandanna_merge

iv. GSQ_rewan_group

v. GSQ_clematis

vi. GSQ_moolyember

g. 根据完井报告，将额外的井数据与重新解释的地层顶界信息添加至对应的地理数据库中。

h. 添加额外的井数据至覆盖范围图层，以辅助模型构建：

i. 井名称标注为"Fake"。

ii. 例外情况为GSQ_top_basement_fake，该图层被创建为独立的地理数据库。

i. 为每个模型图层创建额外的地理数据库，以标注不存在对应模型图层的井数据，用于指导分布范围的界定：

i. GSQ_joejoe_null

ii. GSQ_rewan_ggroup_null

iii. GSQ_clematis_null

iv. GSQ_moolyember_null

2. 钻孔数据

a. 从GA获取QLD_DNRM_GroundwaterDatabaseExtract_20131111数据集。

b. 利用REGISTRATIONS.txt、ELEVATIONS.txt与AQUIFER.txt文件构建GW_stratigraphy.xlsx：

i. 以RN为关联字段。

ii. 纬度数据取自REGISTRATIONS.txt中的GIS_LAT字段。

iii. 经度数据取自REGISTRATIONS.txt中的GIS_LNG字段。

iv. 高程数据取自ELEVATIONS.txt。

v. FORM_DESC字段取自AQUIFER.txt。

vi. 地层顶界深度取自AQUIFER.txt。

vii. 地层底界深度取自AQUIFER.txt。

c. 将GW_stratigraphy.xlsx导入ArcGIS。

d. 创建gw_bores_galilee_dem图层：

i. 采样1S DEM以获取地面高程字段RASTERVALU。

ii. 通过公式RASTERVALU - Top计算得到top_m_AHD字段。

e. 针对每个模型图层，基于"FORM_DESC"字段筛选钻孔数据，为各图层生成地理数据库：

i. Gw_basement

ii. GW_bores_joe_joe_group

iii. GW_bores_bandanna

iv. Gw_bores_rewan

v. Gw_bores_clematis

vi. Gw_bores_moolyember

3. 地表地质数据

a. 以加利利BA区域边界向外扩展25千米的范围为裁剪边界，从2012年8月版昆士兰州地质数据（QUEENSLAND GEOLOGY_AUGUST_2012）中提取地表地质信息，生成地理数据库QLD_geology_galilee。

b. 针对每个模型图层，基于"Name"字段从QLD_geology_galilee中筛选对应的地表地质数据，创建新的地理数据库图层：

i. 基底地质（Basement_geology）：阿根廷变质岩系（Argentine Metamorphics）、朗廷河变质岩系（Running River Metamorphics）、查特斯堡变质岩系（Charters Towers Metamorphics）；比穆拉火山岩（Bimurra Volcanics）、福伊尔火山岩（Foyle Volcanics）、怀亚特山组（Mount Wyatt Formation）、圣安斯组（Saint Anns Formation）、西尔弗希尔火山岩（Silver Hills Volcanics）、斯通斯克里克火山岩（Stones Creek Volcanics）；布利沃拉组（Bulliwallah Formation）、杜卡布鲁克组（Ducabrook Formation）、兰金山组（Mount Rankin Formation）、纳塔尔组（Natal Formation）、希望之星组（Star of Hope Formation）；凯普河变质岩系（Cape River Metamorphics）；艾纳斯利变质岩系（Einasleigh Metamorphics）；宝石公园花岗岩（Gem Park Granite）；麦克拉桑省寒武纪-奥陶纪侵入岩（Macrossan Province Cambrian-Ordovician intrusives）、麦克拉桑省奥陶纪-志留纪侵入岩（Macrossan Province Ordovician-Silurian intrusives）、麦克拉桑省奥陶纪侵入岩（Macrossan Province Ordovician intrusives）；福尔马廷山、未命名深成岩体（Mount Formartine, unnamed plutonic units）；帕马省志留纪-泥盆纪侵入岩（Pama Province Silurian-Devonian intrusives）；七十英里岭群（Seventy Mile Range Group）；以及柯克河层（Kirk River beds）、莱茹梅尔层（Les Jumelles beds）。

ii. 乔乔群地质（Joe_joe_geology）：乔乔群（Joe Joe Group）。

iii. 加利利二叠纪地质（Galilee_permian_geology）：贝克溪群（Back Creek Group）、贝茨溪群（Betts Creek Group）、布莱克沃特群（Blackwater Group）。

iv. 里万群地质（Rewan_geology）：里万群（Rewan Group）。

1. 后续还创建了dunda_beds_geology图层用于里万群模型：当达层（Dunda beds）。

v. 克莱马蒂斯群地质（Clematis_geology）：克莱马蒂斯群（Clematis Group）。

1. 后续还创建了warang_sandstone_geology图层用于克莱马蒂斯群模型：瓦朗砂岩（Warang Sandstone）。

vi. 穆利恩伯地表地质（Moolyember_surface_geology）：穆利恩伯组（Moolyember Formation）。

地层分布范围的衍生流程如下：

1. 若地表地质主要出露于盆地东缘，则将含水层分布范围限定为该出露地质的东缘区域。

2. 利用井数据与钻孔数据集，对分布范围进行编辑：保留所有存在对应模型图层的井/钻孔，剔除不存在对应模型图层的井/钻孔。

3. 若无其他可用信息，则以OZ SEEBASE中展示的加利利盆地轮廓作为含水层分布范围的参考依据。

4. 将分布范围以多边形格式保存，并通过"多边形转栅格（Polygon to Raster）"工具转换为栅格数据。

## 数据集引用

生物区域评估计划（2014）《GAL含水层地层分布范围v01》，生物区域评估衍生数据集。查阅日期：2018年12月12日，来源链接：http://data.bioregionalassessments.gov.au/dataset/e77f61d8-86d1-442a-a6ba-4256ae470595。

## 数据集溯源

* **衍生自** [昆士兰州地质数字数据——详细州域范围与区域范围，2012年11月](https://data.gov.au/data/dataset/03ea9d87-55f1-400e-86c0-b8f7492984c)

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

* **衍生自** [显生宙OZ SEEBASE v2 GIS数据集](https://data.gov.au/data/dataset/26e0fbd9-d8d0-4212-be52-ca317e27b3bd)

* **衍生自** [昆士兰州石油勘探数据——QPED](https://data.gov.au/data/dataset/cb357721-bf22-45c9-a82e-828807912dd4)