James Olson Minnesota DNR - Lands and Minerals GIS Analyst 651-259-5429 500 Lafayette Rd Saint Paul MN 55155 james.olson@state.mn.us 2018-07-13 12:24:29 http://www.dnr.state.mn.us/lands_minerals/aggregate_maps/completed/index.html Aggregate Resource Mapping Program - Compilation of DNR Test Holes 2018-01-10 Minnesota Department of Natural Resources: Division of Lands and Minerals, Mineral Potential Evaluation Section Minnesota DNR - Lands and Minerals This spatial dataset of test holes and samples is based on a compilation of GIS aggregate resources (sand and gravel, crushed stone) reconnaissance scale data spanning seven county projects completed since 2000 by the DNR's Aggregate Resource Mapping Program (ARMP). The test hole site and sample data was collected to verify the presence or absence of sand and gravel at selected test hole sites from 7 completed Aggregate Mapping Program counties and continues presently. Selected test holes were sampled for aggregate gradations and/or construction aggregate quality specifications. The Minnesota Department of Transportation completed the lithological exam for construction aggregate quality. To summarize the test hole sites and samples taken in 7 of the Aggregate Mapping Completed Counties. About the Aggregate Resource Mapping Program: The Aggregate Resource Mapping Program (ARMP) began in 1984 when the Minnesota Legislature passed a law (Minnnesota Statutes, section 84.94) to: Identify and classify aggregate resources out side of the Twin Cities metropolitan area; Give aggregate resource information to local units of government and others for making comprehensive land-use and zoning plans; Introduce aggregate resource protection; and Promote orderly and environmentally sound development of the resource. Aggregate Mapping Home Page: http://www.dnr.state.mn.us/lands_minerals/aggregate_maps/index.html Aggregate Mapping Methodology: http://www.dnr.state.mn.us/lands_minerals/aggregate_maps/methodology.html James Olson Minnesota DNR - Lands and Minerals GIS Analyst 651-259-5429 500 Lafayette Rd Saint Paul MN 55155 james.olson@state.mn.us http://images.dnr.state.mn.us/lands_minerals/aggregate/testhole_image.jpg Test hole drilling, aggregate quality, sieve, gradations, aggregate resources, surficial geology Test hole drilling, aggregate quality, sieve, gradations, aggregate resources, surficial geology Use Disclaimer: Every reasonable effort has been made to ensure the accuracy of the factual data on which this map interpretation is based. However, the Department of Natural Resources does not warrant the accuracy, completeness, or any implied uses of these data. Users may wish to verify critical information; sources include both the references here and information on file in the offices of the Minnesota Department of Natural Resources. Every effort has been made to ensure the interpretation shown conforms to sound geologic and cartographic principles. No claim is made that the interpretation shown is rigorously correct, however, and it should not be used to guide engineering-scale decisions without site-specific verification. This information should not be used to establish legal title, boundaries, or locations of improvements. Data Disclaimer The Minnesota Department of Natural Resources makes no representation or warranties, express or implied, with respect to the reuse of data provided herewith, regardless of its format or the means of its transmission. There is no guarantee or representation to the user as to the accuracy, currency, suitability, or reliability of this data for any purpose. The user accepts the data 'as is', and assumes all risks associated with its use. By accepting this data, the user agrees not to transmit this data or provide access to it or any part of it to another party unless the user shall include with the data a copy of this disclaimer. The Minnesota Department of Natural Resources assumes no responsibility for actual or consequential damage incurred as a result of any user's reliance on this data. Please read accompanying document: Minnesota DNR Data and Software License Agreement.pdf Other Compiled Aggregate Mapping GIS Datasets: Sand and Gravel Resource Potential; Crushed Stone Resource Potential; Geologic Field Observations; and Status Map of Completed, In-Progress, and Requested Projects List of Completed DNR Aggregate Mapping Project's Web Pages to Download Maps and Original GIS Data and Metadata at: http://www.dnr.state.mn.us/lands_minerals/aggregate_maps/completed/index.html Aitkin County (2014) Stearns County (2012) Kanabec County (2012) Portions of Northern St. Louis and Northern Lake Counties (2010) Olmsted County (2010) Carlton County and Fond du Lac Reservation (2009) Mille Lacs County (2007) Meeker County (2006) Renville County (2003) Le Sueur County (2003) Itasca County (2003) - Contracted with MGS Benton County (2002) Dodge County (2002) Chisago County (2000) - Contracted with MGS Nicollet County (1999) Blue Earth County (1999) Clay County (1995) Isanti County (1991) Wright County (1989) Sherburne County (1987) Completed MGS Aggregate Endowment of the 7-County Twin Cities Metropolitan Area 7-County Mapping Web page: Information and links to view and download report, maps, and original GIS data and metadata for this MGS mapping project. true -97.23 -89.53 49.37 43.5 Data were collected since 2000 2018-01-10 State of Minnesota The data points were gathered at the location where the test holes were drilled. Additional information is given in the Lineage section. The differential correction of the GPS unit for GPS located sites is +/- 3 meters. None This varies since the data is a compilation of points collected since 2000. Please consult the original project metadata found at the Aggregate Mapping Program's completed project page at: http://www.dnr.state.mn.us/lands_minerals/aggregate_maps/completed/index.html Generally speaking, a tablet PC, a Garmin GPS Bluetooth unit, ArcGIS software, and the GPS toolbar in ArcMap were used in the field to determine the track and location of the observer collecting the points. Testhole points and associated tabular attribute were updated in real time as much as possible. The combination of the GPS unit's location, USGS topographic maps (1:24,000), and aerial photographs (1:3,000 - 1:12,000) were used to assist in determining the observation's site location on screen. At other times a portable Garmin Etrex or a GPS equipped iPhone were used instead of the above mentioned hardware and software. The GPS unit (with differential correction) is accurate to approximately a few meters. http://www.mngeo.state.mn.us/committee/standards/mgmg/metadata.htm Fields and Attributes PitComp_ID A Unique ID for each record (ex. AM-xxxx) Source Construction aggregate pit data source compiled from or observed (ex: topographic map- found on the topographic map). Where multiple records existed for a single gravel pit, data points were removed based on a constructed hierarchy of source information. The following sources of information are listed according to rank. Minnesota Department of Transportation database called Aggregate Source Information Systems. If the location did intersect a gravel pit, the locations were interpreted off of existing gravel pit sheets to relocate the mines to as specified on the sheet. This was ranked highest because of associated quality and texture data. Some locations were modified to better correlate to present gravel pit boundaries and on top of USGS 7.5 Minute Topographic Map symbols. Topographic Map These gravel pits are located from USGS 7.5 minute quadrangles. This was ranked second highest because of the widespread use of the maps. Where field checked, some of these pit types were changed from gravel to borrow or sand pits to reflect the material excavated. Field Work These pits were located while in the field. These pits were ranked third highest due to the fact they were directly observed for quality, texture, and spatial accuracy. Soil Survey The records for these pits are from the Soil Survey Geographic Database (SSURGO) Aitkin County. The dataset was downloaded in June 2010. These pits were ranked fourth highest. Air Photo Gravel mines were also located and some attributes were interpreted with air photography. These pits were ranked last because they were remotely interpreted. LiDAR LiDAR is giving an opportunity to see disturbed surfaces like never before. This is a new source. Type The type of pit, quarry, or prospect observed FieldCheck A new field asking the question was the pit or quarry field checked. If so, how? Observed on Site Observed from Road Observed from Air Photo ASIS_numbr Aggregate Source Information System Number (MN/DOT Database). An empty field means that it does not have an ASIS number. Material_1 Primary material observed in the gravel pit. Material_2 Secondary material observed in the gravel pit. Size Refers to the relative size of the pit. Small Small pits are less than five acres. These pits are usually used by private landowners or for small jobs. Medium Between 5 and 15 acres in size. These pits are used by landowners and for small construction jobs. Large These pits are generally greater than 15 acres and are typically used by commercial aggregate operators. Thickness The thickness of the deposit expressed in combination with a modifier. Not Available indicates that the measurement does not apply or was not observed. Overburden Expresses overburden thickness in the pit by using a value in combination with a modifier if appropriate. Not Available indicates that the measurement does not apply or was not observed. Watertable The depth of the water table expressed in combination with a modifier. Not Available indicates that the measurement does not apply or was not observed. Status_1 Refers to the status of the pit at the time of mapping. Status_2 Associated with the field 'Status_1'. This field further explains the condition of a partially or fully reclaimed gravel pit. The status could be a combination of more than one use. Dom_litho Dominant lithology of the pit. Dom_text The dominant texture of the pit. Comments Geologist comments related to the pit. County The county or project area that the data was collected for. Year Current The year the aggregate data was published. Test hole site data contains information about the test hole id, type, size, depth, materials, geologic description, depth to water, sand and gravel thickness, overburden, sampled, sample interval, link to MnDOT sampling form, and geologist. Test hole sampling data contains information about sample lab, ids, intervals, gradation data, and aggregate quality data. An example attribute table with descriptions for test holes and samples is provided here from the Kanabec County Aggregate Map: http://files.dnr.state.mn.us/lands_minerals/aggregate/aggregate_testholes_attribute_example_kanabeccounty.pdf If you need more information please consult the original project data and metadata found at the Aggregate Mapping Program's completed project page at: http://www.dnr.state.mn.us/lands_minerals/aggregate_maps/completed/index.html 1.0 20260331 04395600 TRUE