Permeability-Depth (K-Z) Database by Ranjram, Gleeson, and Luijendijk (2015).

/\/\/\/A Modest Permeability-Depth Database\/\/\/\ Assembled by Mark Ranjram, MSc Candidate, McGill University, 2014.<br>contact: [e-mail] Reference:<br>Ranjram M, Gleeson T &amp; Luijendijk E (2015) Is the permeability of crystalline rock in the shallow crust related to depth, lithology or tectonic setting? Geofluids, 15,106-119.<br>-------------------------------------------------------------------- The database is provided in its entirety in the excel file "Ranjram_Gleeson_Luijendijk_KZ_Database.xls" The cleanest representation of the data is provided in the sheet labelled "Main Database." -------------------------------------------------------------------- The excel file is composed of five Sheets: 1. "Table of Contents"<br>This sheet provides a brief description of each sheet. 2. "Data Grab"<br>This sheet presents the raw data which makes up the database. The information here is roughly presented and should only be used if the user thinks there is an error in the main database (Although contacting the author is probably the best first step to take if an error is apparent). 3. "Methods"<br>This sheet provides a qualitative description of the data assembled from each reference in the main database. A Y/N indicator is provided for each reference describing whether the data are included in the main database (Volcanic rocks are excluded from the main database). Individual depth-permeability data are listed for references which provide a compilation of permeability-depth values. An 'x' under Salinity and Temperature indicates that the reference provides measurements of Hydraulic Conductivity but has no indication of tempearture or salinity with depth. Salinity-depth and temperature-depth relationships for these data are inferred from salinity-depth and temperature-depth relationships provided by studies in similar or nearby regions. Where possible, a "root reference" is provided if the referenced study collected its permeability data from another study. 4. "Main Database"<br>This sheet provides the cleanest presentation of the assembled data and is the main sheet in this file. This sheet indicates the Location, reference, rock type, depth, and permeability information for every point included in our study. All conductivity values are converted to permeability in units of m² and each conversion is described in the sheet. The columns labelled "RESULTS/WORKING VALUES" provide the information analyzed and considered in our study. "k error" describes the range of uncertainty in permeability centred at the "working value" of permeability. "depth error" provides the depth range over which the permeability measurement is taken, with the range centred at the value in the "Depth" column. The "BOUNDED DEPTH DATA" columns explicitly indicate the upper and lower depths at which the corresponding permeability measurement was made. 5. "Jump Off Sheet"<br>This sheet lists the data in the Main Database into sortable columns of Location, Reference, Lithology, permeability-depth values, and maximum depth. This sheet is useful for sorting and extracting desired permeability values. The columns filled in green are the "RESULTS/WORKING VALUES" described in the "Main Database" sheet. The Max Depth column indicates the deepest depth associated with each point, and our study excluded points deeper than 2.5 km.

**浅部结晶岩适度渗透率-深度数据集**
由麦吉尔大学硕士研究生马克·兰杰拉姆（Mark Ranjram）于2014年汇编。
联系方式：[e-mail]
参考文献：
Ranjram M, Gleeson T & Luijendijk E (2015) 浅部结晶岩的渗透率是否与深度、岩性或构造背景相关？《Geofluids》，15卷，106-119页。
--------------------------------------------------------------------
本数据集完整收录于Excel文件"Ranjram_Gleeson_Luijendijk_KZ_Database.xls"中，其中数据呈现最规范的工作表为"Main Database（主数据集表）"。
--------------------------------------------------------------------
本Excel文件共包含5个工作表：
1. 「目录表（Table of Contents）」：简要说明各工作表的内容与用途。
2. 「原始数据抓取表（Data Grab）」：收录构成数据集的原始未整理数据。本表数据呈现较为粗糙，仅当用户发现主数据集存在错误时方可参考（若发现明显错误，优先建议直接联系作者）。
3. 「研究方法表（Methods）」：对主数据集中各参考文献来源的数据进行定性说明。本表为每条参考文献设置了「是否纳入主数据集」的Y/N标识（注：火山岩未纳入主数据集）。对于提供了渗透率-深度值汇总的参考文献，将单独列出其单条深度-渗透率数据。若「盐度（Salinity）」与「温度（Temperature）」列下标注「x」，则代表该参考文献仅提供了导水率（Hydraulic Conductivity）的测量结果，未给出深度相关的温度与盐度数据，此类数据的盐度-深度、温度-深度关系通过相似或邻近区域的相关研究推导得出。若参考文献的渗透率数据源自其他研究，则尽可能标注其「原始参考文献（root reference）」。
4. 「主数据集表（Main Database）」：为本文件中数据整理最规范的核心工作表，记录了本研究纳入的所有数据点的位置、参考文献来源、岩石类型、深度以及渗透率（permeability）信息。所有导水率数值均已转换为以平方米（m²）为单位的渗透率，具体转换方法已在本表中说明。标注为「结果/可用工作值（RESULTS/WORKING VALUES）」的列，为本研究中用于分析与考量的核心数据。「k误差（k error）」表示以渗透率工作值为中心的渗透率不确定性范围；「深度误差（depth error）」表示渗透率测量对应的深度区间，该区间以「Depth」列的数值为中心。「限定深度数据（BOUNDED DEPTH DATA）」列则明确标注了对应渗透率测量的上下限深度。
5. 「快速筛选表（Jump Off Sheet）」：将主数据集的数据整理为可排序列，包括位置、参考文献、岩性（Lithology）、渗透率-深度值以及最大深度。本表可用于快速筛选与提取所需的渗透率数据，其中填充绿色的列对应「主数据集表」中提及的「结果/可用工作值」。「最大深度（Max Depth）」列标注了每个数据点对应的最深深度，本研究排除了深度超过2.5 km的数据点。