This DS002-dataset01-readme.txt file was generated on 2023-03-24.


GENERAL INFORMATION

1. Title of publication: Central sands nitrate and neonicotinoids database

2. Title of dataset: Central sands nitrate and neonicotinoids database [dataset 1]

3. Author information
	A. Author contact information
		Name: Carla R. Romano
		Institution: Wisconsin Geological and Natural History Survey
	B. Corresponding author
		Name: Michael J. Parsen
		Institution: Wisconsin Geological and Natural History Survey
		Email: mike.parsen@wisc.edu	
	C. Author contact information
		Name: Nathan D. Sandwick
		Institution: Division of Extension, University of Wisconsin−Madison
	D. Author contact information
		Name: Jennifer L. McNelly
		Institution: Planning and Zoning Department, Portage County
	E. Author contact information
		Name: Kenneth R. Bradbury
		Institution: Wisconsin Geological and Natural History Survey
	F. Alternate contact information
		Role: Information Manager
		Institution: Wisconsin Geological and Natural History Survey
		Address: 3817 Mineral Point Road, Madison, Wisconsin 53705
		Email: data@wgnhs.wisc.edu
		
4. Date of data publication: 2023-04-05 


SHARING/ACCESS INFORMATION

1. Digital data sharing, terms of use: These data are provided by the Wisconsin Geological and Natural History Survey (WGNHS) on an "as is" basis. WGNHS will not be liable for any damages of any kind arising from the use of these data, including, but not limited to direct, indirect, punitive, and consequential. WGNHS makes no warranties on these data, express, implied, statutory, or in any other provision of any agreement or communication, and specifically disclaims any implied warranties of merchantability or fitness for a particular purpose.

2. Disclaimer: Any use of trade, firm, or product names is for descriptive purposes only and does not imply endorsement by the Wisconsin Geological and Natural History Survey. All trademarks are the property of their respective owners.

3. Links to parent or accompanying publications that cite or use the data: https://doi.org/10.48358/dwhy7257

4. Links to other publicly accessible locations of the data: https://doi.org/10.48358/dwhy7257

5. Source document: Romano, C.R., Parsen, M.J., Sandwick, N.D., McNelly, J.L., Bradbury, K.R., 2023, Central Sands nitrate and neonicotinoids database: Wisconsin Geological and Natural History Survey Data Series 002, https://doi.org/10.48358/dwhy7257.

6. Recommended citation for this dataset: Romano, C.R., Parsen, M.J., Sandwick, N.D., McNelly, J.L., Bradbury, K.R., 2023, Central Sands nitrate and neonicotinoids database: Wisconsin Geological and Natural History Survey Data Series 002, https://doi.org/10.48358/dwhy7257.

7. Alternative file formats: If you need this information in an alternative format, contact the Wisconsin Geological and Natural History Survey (telephone 608.262.1705).


DATASET CONTENT & FILE OVERVIEW

1. File list: 

DS002-dataset01-readme.txt (this file).

CSGCC_Nitrate_Neonicotinoids.gdb: File geodatabase containing feature classes organized in feature datasets, and tables:
	
	Feature datasets and contents:
		
	1.	Address_points: File Geodatabase Feature Class including the count of address points per section in the CSGCC region in 2014 and in 2021. Data for 2014 were retrieved from the Public Service Commission of Wisconsin and data for 2021 were received from each County of the CSGCC region.
	
	2.	AG_LAND_USE: Feature dataset with several File Geodatabase Feature Classes pertaining to agriculture and land-use. Feature classes include recent and historical agricultural land-uses, a comparison between areas of the CSGCC that have been changed from agricultural to non-agricultural and from non-agricultural to agricultural, and areas that have had an agricultural land-use since the 1930s.

	3.	Areas_served_by_Municipal_Water_Systems: File Geodatabase Feature Class of areas served by Municipal Community systems. Most of the study area shares the boundaries with a city, a village, or a town. Polygons were retrieved from Wisconsin Legislative Technology Service Bureau and from private communications with staff from counties, cities, villages, or towns.
	
	4.	Bedrock_depth: File Geodatabase Feature Class including depth to bedrock for the CSGCC area.

	5.	Biosolids_spreading: File Geodatabase Feature Class including the count of biosolids spreading per section from 1996 to 2021. The minimum, maximum, mean, median, and standard deviation of the total nitrate applied (lbs per acre) is also estimated per section. Data were retrieved from private communication with the Wisconsin Department of Natural Resources (WI DNR).

	6.	Manure_storage_locations: File Geodatabase Feature Class of the count of manure storage locations per section. Data were retrieved from private communications with the CSGCC counties. 

	7.	Neonicotinoids_sections: Feature dataset with several File Geodatabase Feature Classes, which include clothianidin, imidacloprid, and thiamethoxam concentrations in groundwater (private and monitoring wells) and surface water. The minimum, maximum, mean, std, and median concentration values are reported for each section. Also included are the number of measurements exceeding EPA or Morrissey benchmarks, the data source, sampling date, and accuracy of location. Whenever available we also included well properties and their respective accuracy of measurement. Data sources: Wisconsin Department of Agriculture, Trade and Consumer Protection (DATCP), the United States Geological Survey (USGS), and UW− Stevens Point.

	8.	Nitrate_sections_NON_PWS (Nitrate sections Non-Public Water Systems): Feature dataset with several File Geodatabase Feature Classes of nitrate concentrations in groundwater from private and monitoring wells. Data include the minimum, maximum, mean, std, and median concentration values reported for each section. Additional data include the number of measurements, the number of wells exceeding the drinking water standard of 10 mg/L, the data source, sampling date, and accuracy of location. Whenever available well properties and respective accuracy of measurement are also included. Data sources: CSGCC counties, DATCP, DNR, USGS, UW−Madison, UW−Stevens Point.
	
	9.	Nitrate_sections_PWS_NO_DUPLICATES (Nitrate section Public Water Systems): Feature dataset with several File Geodatabase Feature Classes of nitrate concentrations in groundwater in Public Water Systems. The minimum, maximum, mean, std, and median concentration values were reported for each section. Additional data include the number of measurements, the number of wells exceeding the drinking water standard of 10 mg/L, the data source, sampling date, and accuracy of location. Well properties and respective accuracy of measurement are included whenever available. Data sources: CSGCC counties, DNR, USGS. 

	10.	Spills: Feature dataset with several File Geodatabase Feature Classes of the locations and details on spills and remediation sites in the CSGCC counties. Data source: DNR.

	11.	SSURGO: File Geodatabase Feature Class of the weighted average hydraulic conductivity, clay content, and organic matter content per section. Data retrieved from the USDA Web Soil Survey. Explanations of weighted average calculations are included in the metadata.

	12.	WELLS_SEPTIC (Wells and septic systems): Feature dataset with several File Geodatabase Feature Classes of the count of wells or septic systems per section and a layer with all the wells of the CSGCC region with information on their respective properties. The total number of wells is a product of a merging process of several datasets and therefore an approximation. Data sources: the CSGCC counties, DNR, WGNHS.

	Tables:

	13.	CSGCC_SSURGO_additional_info: A table containing data on soil properties of the CSGCC region. The statistical summary of this table produced Dataset 11: SSURGO.

	14.	No_Duplicates_Non_PWS_all: A table containing nitrate data collected from non-public water systems (private, monitoring, wells, etc.). This table includes all the data, including data collected from wells whose location information has a resolution lower than that of a single section. 
	
	15.	No_Duplicates_PWS_all: No duplicates Non-Public Water Systems – good location: A table containing nitrate data collected from non-public water systems (private, monitoring, wells, etc.). The statistical summary of this table produced Dataset 8: Nitrate section Non-Public Water Systems – no duplicates. This table includes only data collected from wells which have location information at a resolution of at least that of a single section.
	
	16.	No_Duplicates_PWS_all: A table containing nitrate data collected from public water systems. This table includes all the data, including data collected from wells whose location information has a resolution is worse than that of a single section.

	17.	No_Duplicates_PWS_good_location_not_treated: A table containing nitrate data collected from public water systems. The statistical summary of this table produced Dataset 9: Nitrate section Public Water Systems – no duplicates. This table includes only data collected from wells that have location information of  at least that of a single a section.

	18.	Wells_all_datasets_combined: A table containing information on the wells located within the CGSCC region. The statistical summary of this table produced the Well layer of Dataset 13: Wells and septic systems.	

	Metadata folder: Geospatial metadata for feature classes and tables in TXT and XML formats.


