Carbonate RCN Spring and Karst Data Resources

These files were derived from the map that Michael Jones created for identifying data available from the USGS NWIS site related to karst resources.

NWIS_Springs_With_Conductance.xlsx This file was posted by Laura Toran. This file summarizes a search of the USGS NWIS database for springs that have conductivity logger data.

NWIS_Sites_With_Nitrate.xlsx This file was posted by Laura Toran. This file summarizes a search of the online GIS maps for NWIS sites in carbonate terrain that have nitrate data and includes history of the datasets (length of record). The file contains all of the other water chemistry data available when nitrate is available. The file was created by downloading the attribute table when nitrate was the selected parameter.

NWIS_Sites_Nitrate_DataCounts.xlsx This file was posted by Laura Toran. This file summarizes the NWIS_Sites_With_Nitrate.xlxs file by counting how many nitrate records are available at each site and plotting the data. Most sites have only 1 or 2 data points but there are sites with up to 151 data points. This file was created using a python script described below.

ArcGIS_NWISData_Sort2.ipynb is a Python Collab (runs on google drive) that takes the file NWIS_Sites_With_Nitrate and sort out how much data is in each site. Although the script runs on google drive, it can be adapted for a Jupyter Notebook. If you run on Google Collab, you don't need to download Python onto your computer.

/WATER_QUALITY_GIS/AVERAGES: This shapefile is a shapefile that contains an attribute table with the averages of selected water quality parameters by site. For example, the attribute table contains columns for water quality parameters such as Calcium, specific conductance, Magnesium, etc. The table has the averages at each site for each of the water quality parameters.

/WATER_QUALITY_GIS/WQ_COUNT: This shapefile is a shapefile that contains an attribute table with the number of samples that exist for selected water quality parameters by site. For example, use \"Select by Attributes\" to find sites that have Calcium measured over x number of times.

/WATER_QUALITY_GIS/States.shp: Shapefile of the US states

MATLAB: See MATLAB DESCRIPTIONS documentation in the MATLAB folder for more information

本系列数据集文件均衍生自迈克尔·琼斯（Michael Jones）为识别美国地质调查局（USGS，United States Geological Survey）国家水信息系统（NWIS，National Water Information System）站点中与喀斯特资源（karst resources）相关的可用数据所制作的地图。

NWIS_Springs_With_Conductance.xlsx：该文件由劳拉·托兰（Laura Toran）发布，汇总了针对USGS NWIS数据库中搭载电导率记录仪数据的泉水站点的检索结果。

NWIS_Sites_With_Nitrate.xlsx：该文件由劳拉·托兰发布，汇总了针对碳酸盐岩地貌区且带有硝酸盐数据的NWIS站点的在线GIS地图检索结果，同时包含数据集的历史信息（记录时长）。文件收录了与硝酸盐数据同步可用的全部其他水化学数据，其生成方式为：当以硝酸盐作为选定参数时，下载对应的属性表得到该文件。

NWIS_Sites_Nitrate_DataCounts.xlxs：该文件由劳拉·托兰发布，通过统计NWIS_Sites_With_Nitrate.xlsx中每个站点的硝酸盐记录数量并绘制数据分布，完成了对该文件的汇总分析。多数站点仅存有1至2条数据，但部分站点的记录数最高可达151条。该文件通过下述Python脚本生成。

ArcGIS_NWISData_Sort2.ipynb 为Python协作脚本（可在谷歌云端硬盘运行），用于读取NWIS_Sites_With_Nitrate文件并统计各站点的数据量。尽管该脚本依托谷歌云端硬盘运行，但也可适配至Jupyter Notebook环境。若使用谷歌Colab运行，则无需在本地计算机安装Python。

/WATER_QUALITY_GIS/AVERAGES：该Shapefile包含一张属性表，其中存储了各站点选定水化学参数的平均值。例如，属性表中包含钙、比电导率、镁等水化学参数的列，记录了每个站点各对应参数的平均值。

/WATER_QUALITY_GIS/WQ_COUNT：该Shapefile包含一张属性表，其中存储了各站点选定水化学参数的样本数量。例如，可通过"按属性选择"工具筛选出钙测量次数达到指定x次的站点。

/WATER_QUALITY_GIS/States.shp：美国各州矢量Shapefile。

MATLAB：详细信息请参阅MATLAB文件夹中的MATLAB说明文档。