AGGREGATE RESOURCE POTENTIAL

GRAVEL PITS, AGGREGATE SOURCES, FIELD OBSERVATION SITES

ISANTI COUNTY, MINNESOTA

Field | Description
Main ID Information | Metadata Updated 2007
Title | Aggregate Resources and Quaternary Geology - Gravel Pits and Field Observation Sites, Isanti County, Minnesota. This layer is part of Report 304, from 1992.
Filename | shapefiles: gp92apt3 and gp92bpt3 and Access 97 database, isanapot.mdb
Abstract | This dataset consists of the locations of gravel pits, aggregate sources, and field observation sites from a variety of sources. This work is authorized by Minnesota Statute 84.94.
Place Keywords | Isanti County, MN
Theme Keywords | Aggregate potential, gravel pits, observation sites, aggregate sources
Time Period of Content | 1990-1991
Parent Theme |
Spatial Extent of the Data | Isanti County, Minnesota
Contact Person | Aggregate Resources Mapping Program
Contact Person Organization/Division | Minnesota Department of Natural Resources, Division of Lands and Minerals
Contact Person Position | Geologist or GIS Specialist
Contact Address | 500 Lafayette Road, Box 45
Contact City | St. Paul, MN
Contact Zip Code | 55155-4045
Contact Voice Phone | 651-259-5959
Contact Fax Phone | 651.296.5939
Additional ID Information |
Originator | Department of Natural Resources, Division of Lands and Minerals, Mineral Potential Section.
Purpose | To identify the locations of existing gravel pits, aggregate sources, and field observation sites used in the creation of the 1992 Aggregate Resources and Quaternary Geology, Isanti County, Minnesota map.
Progress | Complete
Currentness Reference | Air photo interpretation 1990-1991, field work summers of 1990 and 1991, USGS quadrangles, and MN/DOT aggregate sources.
Maintenance Frequency | None planned
Access Constraints | NA
Use Constraints | NA
Associated Data Sets | shapefiles: sg92xpy3 - surficial geology and aggregate potential, sg92xln3 - surficial geology mapping unit line symbols, sym92ln3 - surficial geology line symbols Access 97 database: isanapot.mdb
Data Quality |
Attribute Accuracy | Gravel pits were digitized from 1:24,000 USGS quadrangles, located by field work, or obtained from the Minnesota Department of Transportation..
Logical Consistency | NA
Completeness |
Horizontal Positional Accuracy |
Vertical Positional Accuracy | NA
Lineage | These two shapefiles and the Access database are part of Minnesota Department of Natural Resources, Minerals Division, Report 304, Aggregate Resources and Quaternary Geology, 1992, by JD Lehr. Gravel pits locations were gathered from a number of sources, including the Soil Survey of Isanti County (from Soil Conservation Service), 1:24000 USGS topographic maps, Isanti County Highway Department, field observations by the author, JD Lehr, and Minnesota Department of Transportation gravel pit sheets.
Source Scale Denominator | 1:62,500
Spatial Reference |
Horizontal Coordinate Scheme | UTM
Ellipsoid | GRS80
Horizontal Datum | NAD83
Horizontal Units | Meters
Distance Resolution | NA
Altitude Datum | NA
Altitude Units | NA
Depth Datum | NA
Depth Units | NA
UTM Zone Number | 15, extended
Raster only |
Cell Width | NA
Cell Height | NA
Spatial Data Organization |
Geographic Reference for Tabular Data | NA
Native Dataset Environment | ArcView 3.1 / Arc/INFO 7.2.1
Vendor Specific Object Type | NA
Tiling Scheme | County
Spatial Object Type | Point
Transfer Size |
Entities -- Attributes |
Entity-Attribute Overview | Gravel pits, MN/DOT aggregate sources, and field observation sites, with a field in the table to indicate if they were or were not shown on the map.
Entity-Attribute Detailed Citation | The complete table is listed below:

Table Name | Field Name | Begin Column | Definition | Valid Values | Descriptions
gp92apt3 shapefile |  |  |  |  | Gravel pit and observation site locations
| pitno |  | Number,3,0 |  | Gravel pit and/or field observation site, given as a number
|  |  |  | e.g., 12, 26, 27, 69 (i.e., those values less than 90) | Gravel pit and field observation site - locations gathered from several sources. In places single symbols indicate multiple gravel pits. May be active, inactive, depleted, or reclaimed.
|  |  |  | 90 | Gravel pits identified from a number of sources. These gravel pits were not visited by the author and are therefore not field observation sites.
|  |  |  | e.g., 101, 116,138, 175 (i.e., those values greater than 90) | Field observation site at a road cut, natural exposure, excavation. These sites were not plotted on the final map.
| pittype |  | Text, 40 |  | Gravel pit and/or observation site, given as text
|  |  |  | Gravel pit with field observation | Gravel pit locations derived from a number of sources, including the Soil Survey of Isanti County, Isanti County Highway Department files, and 1:24000 USGS topographic maps. These sites were visited by the author. These sites correspond to pitno < 90.
|  |  |  | Gravel pit | Gravel pit locations from a number of different sources, including the Soil Survey of Isanti County, Isanti County Highway Department files, and 1:24000 USGS topographic maps. For these sites, pitno = 90.
|  |  |  | Field observation site | Sites visited by the author. May include road cut, natural exposure, excavation. For these sites, pitno > 100.
| obsite |  | Number,2,0 | Numbers ranging from 1 to 75. | Field observation site number. Use this field to relate to the information stored in isanapot.mdb.
| drawmap |  | Text,1 |  | Indication of if the gravel pit location was drawn on the map
|  |  |  | Y | The gravel pit was drawn on the map
|  |  |  | N | The gravel pit was not drawn on the map because there were several in the same location, so one symbol, not several, was used to represent them. If the site was a field observation site only, the site was not plotted on the map.
gp92bpt3 shapefile |  |  |  |  | MN/DOT aggregate source locations, based on MN/DOT pit sheets. These sites generally include gravel pits.
| dotid |  | Number,5,0 | e.g., 30001, 30008, 30010, 30025, 30034 | MN/DOT assigned aggregate source ID. First two digits (i.e., 30) represent the county, the last three digits the source ID.
| dotid2 |  | Text,1 | e.g., A or B | Where the pits have been further subdivided into parts and mapped on separate pit sheets, MN/DOT differentiated these pits by letter.
| dotpit |  | Text,6 | e.g., 30001A, 30001B, 30017, 30031, 30035 | MN/DOT assigned aggregate source ID combining the numeric and text parts of the ID.
| draw |  | Text,1 |  | Indication of if the aggregate source location was drawn on the map
|  |  |  | Y | The aggregate source location was drawn on the map
|  |  |  | N | The aggregate source location was not drawn on the map because there were several aggregate sources in the same location, so one symbol, not several, was used to represent them.
| obsite |  | Number,2,0 | Numbers ranging from 8 to 36. | Field observation site number. Use this field to relate to the information stored in isanapot.mdb.
isanapot.mdb - individual tables are listed below. |  |  |  |  | Access database containing additional information about the field observation sites, relationships among the mapping units and the major and minor lithologies, texture data at several observation sites, MN/DOT aggregate source data listed on pitsheets and as part of ASIS (Aggregate Source Information System).
notebook |  |  |  |  | Locations and additional information about the field observation sites.
| obsite |  | Number,6,0 |  | Field observation site number. Use this field to relate to the information stored in isanapot.mdb.
| county |  | Text,10 | Isanti, Anoka, Chisago, Kanabec, Mille Lacs | Name of county where field observation site is located.
| township |  | Number,6,0 | 34,35,36,37,38 | Township number from the Public Land Survey, often listed as T.35N.
| range |  | Number,6,0 | 21,22,23,24,25,26 | Range number from the Public Land Survey, often listed as R.25W.
| section |  | Number,6,0 | 1 to 36 | Section number from the Public Land Survey.
| quarter |  | Text,7 | e.g., AB, DCC, ABBBC | The portion of the section where the site is located. Letter combinations are used, where A is the northeast, B is the northwest, C is the southwest, D is the southeast. The first letter represents the 160-acre part of the section, the second letter the 40-acre part, the third letter the 10-acre part, the fourth letter the 2.5-acre part, the fifth letter the .625-acre part, and the sixth letter the .15625-acre part. For example, AB represents the NW-1/4 of the NE-1/4.
| quad_name |  | Text,12 | e.g., Bradford, Dalbo, Isanti, Springvale, Typo Lake | Name of the 1:24000 USGS topographic map
| samples |  | Text,1 | y or n | y - a sample was taken at this location, n - a sample was not taken at this location
| photos |  | Text,1 | y or n | y - a photo was shot at this location, n - a photo was not shot at this location
| date_desc1 |  | Date,8 | e.g., 9/21/1990, 10/26/1990, 11/21/1990 | Date that the site was visited and described
| date_desc2 |  | Date,8 | 11/21/1991 or 11/22/1991 | The second date the site was visited and described.
notes |  |  |  |  | Observation site descriptions from the field notebook.
| obsite |  | Number,6,0 | 1 to 73 | Field observation site number. Use this field to relate to the information stored in isanapot.mdb.
| fieldnote |  | Memo |  | Notes written, describing the site, what was found there, sample number if a sample was taken.
notesexp |  |  |  |  | Observation site descriptions from the field notebook. This table is the same information as the notes table, but the fieldnote field has been subdivided into 7 fields so that the data could be more easily transferred among various software packages, including Arcview.
| obsite |  | Number,6,0 |  | Field observation site number. Use this field to relate to the information stored in isanapot.mdb.
| notes1 |  | Text,200 |  | The first 200 characters of fieldnote.
| notes2 |  | Text,200 |  | The second 200 characters
| notes3 |  | Text,200 |  | The third 200 characters
| notes4 |  | Text,200 |  | The fourth 200 characters
| notes5 |  | Text,200 |  | The fifth 200 characters
| notes6 |  | Text,200 |  | The sixth 200 characters
| notes7 |  | Text,200 |  | The seventh 200 characters
majormat |  |  |  |  | Major lithology, minor lithology, mantle lithology for each mapping unit
| geo_unit |  | Number,6,0 | 10,15, 20,21, 23,25,24, 27,28, 32,33, 34,35,36, 37,39, 89,99 | Quaternary (i.e., surficial) geology units, given as a number
| geo_label |  | Text,4 | O,Al, Dlc,Dlf, Doc,Docm,Di, Dt,Dtl, Som,Soml, Si,Sim,Siml, St,Stml, W,W | Quaternary (i.e., surficial) geology units, given as a character string (presented in the same order as above, for geo_unit)
| major_lith |  | Text,30 | peat, silt, fine sand, sand, sand and gravel, till | The major lithology (i.e., composition) of the mapping unit.
| minor_lith |  | Text,30 | clay, organic-rich silt, silt, silty sand, till | The minor lithology of the mapping unit.
| mantl_lith |  | Text,35 | none (i.e., no mantle); undiff. Grantsburg sublobe deposits; in places, fine sand; in places, silt; silt | The lithology of the mantle in the mapping unit.
textures |  |  |  |  | Sample number, texture data, Munsell colors, field description, and observation site numbers.
| samplenum |  | Number, long integer | e.g., 309001, 309003 | Number of the sample taken at the observation site
| pct_gravel |  | Number, single,2 decimal places | e.g., 1.5, 7.1, .98 | Percentage of gravel in the sample
| pct_sand |  | Number, single, 2 decimal places | e.g., 49.1, 50.9, 1.7, 81.9 | Percentage of sand in the sample
| pct_silt |  | Number, single, 2 decimal places | e.g., 27.9, 60.8, 35.1, 89.4 | Percentage of silt in the sample
| pct_clay |  | Number, single, 2 decimal places | e.g., 28, 16.1, 6.6, 53.9 | Percentage of clay in the sample
| text_class |  | Text,15 | loam, clay loam, silt loam, sandy loam, silty clay, silt, loamy sand | Texture of the sample
| munsell |  | Text,10 | e.g., 10YR 6/6, 5YR 4/6 | Color of the sample based on the Munsell guide
| wet_dry |  | Text,1 | w - wet, d - dry, ? - unknown | The wetness of the sample
| field_desc |  | Text,25 | Grantsburg sublobe till, Lake Grantsburg clay, Lake Grantsburg silt, Superior lobe till, Superior lobe ice-contact | The source of the material in the sample, base on field observation
| obsite |  | Number,6,0 | e.g., 6, 10, 23, 50, 60, 64 | Field observation site number. Use this field to relate to the information stored in isanapot.mdb.
pitsheet |  |  |  |  | Summary table created from the information on the MN/DOT pit sheets in conjunction with the mapping units found in sg92xpy3 shapefile. This information was summarized by the author about 1990.
| geo_label |  | Text,4 | Di, Docm, Dlc, Dt, Si, Sim, Som | Quaternary (i.e., surficial) geology mapping units, given as a character string, from the sg92xpy3 shapefile.
| dotid |  | Number, integer | e.g., 30001, 30017, 30028, 30036 | MN/DOT assigned aggregate source ID. First two digits (i.e., 30) represent the county, the last three digits the source ID.
| dotpit |  | Text,6 | e.g., 30001A, 30001B, 30017, 30028, 30036 | MN/DOT assigned aggregate source ID combining the numeric and text parts of the ID.
| location |  | Text,17 | e.g., 35-23-01AB, 36-23-36DC | The location given in Public Land Survey coordinates in the following format: township-range-section-quarter. Refer to the documentation for the notebook table, above, under the field labelled "quarter" to see a description of what the letter combination means.
| utme27 |  | Number, long integer | e.g., 488250, 464330 | UTM east coordinate, in meters, given in NAD27.
| utmn27 |  | Number, long integer | e.g., 5044625, 5060738 | UTM north coordinate, in meters, given in NAD27.
| utme83 |  | Number, long integer | e.g., 488233, 464313 | UTM east coordinate, in meters, given in NAD83.
| utmn83 |  | Number, long integer | e.g., 5044839, 5060952 | UTM north coordinate, in meters, given in NAD83.
| pct_gravel |  | Number, integer | e.g., 9, 27, 0, 40, 63 | Percent gravel.
| pct_crsand |  | Number, integer | e.g., 33, 46, 22, 5, 36 | Percent coarse sand.
| pct_fines |  | Number, integer | e.g., 58, 20, 95, 33, 19 | Percent fines.
| av_lar |  | Number, double, 2 decimal places | e.g., null (i.e., no value), 21.8, 19, 17.8, 18.1 | Average Los Angeles Rattler test.
| avp_shalp4 |  | Number, double, 2 decimal places | e.g., null (i.e., no value), 0.9, 2.2, 1, 0.4 | Average percentage of shale at plus 4 mesh.
| avp_shalm4 |  | Number, double, 2 decimal places | e.g., null (i.e., no value), 2.5, 0.7, 1.2, 0.4 | Average percentage of shale at minus 4 mesh.
| avp_chert |  | Number, double, 2 decimal places | e.g., null (i.e., no value), 0.3, 0.2, 0 | Average percentage of chert.
| avp_ironox |  | Number, double, 2 decimal places | e.g., null (i.e., no value), 0.3, 2.2, 0.8, 0.2, 0 | Average percentage of iron oxide.
| numvalue |  | Number, integer | e.g., 16, 8, 5, 41, 26 | Number of values for a pit on the pit sheet
isanasis |  |  |  |  | MN/DOT Aggregate Source Information System (i.e., ASIS) data obtained in 1990. It is possible to get newer ASIS data by going to the MN/DOT web site at www.dot.state.mn.us and searching for "ASIS" (as of 4/2001).
| dotid |  | Number, integer | e.g., 30001, 30017, 30028, 30036 | MN/DOT assigned aggregate source ID. First two digits (i.e., 30) represent the county, the last three digits the source ID.
| status |  | Text,1 | A=active, I=inactive, C=commercial gravel source, N=no data available. | ASIS source status, as of last record update (in this case, 1990).
| twp |  | Number, integer | 34, 35, 36, 37 | Public land survey township number. Usually given as T.34N.
| rng |  | Number, integer | 23, 24, 25 | Public land survey range number. Usually given as R.23W.
| sec |  | Number, integer | 1 to 36 | Public land survey section number.
| quarter |  | Text,20 | e.g., W1/2,NE1/4; NE1/4,NE1/4; SW1/4,SE1/4; S1/2,NE1/4,NE1/4 | Public land survey, portion of the section.
| own_oper |  | Text,25 | e.g., Isanti Co., State(DNR), Riteway S&G, Olson P | Name of the owner/operator.
| near_city |  | Text,19 | e.g., Dalbo, Cambridge, Stanchfield | Name of the nearest city.
| class |  | Text,6 | 4; 5; 4,#200; 6,BA-1 | MN/DOT material class for aggregate
| est_quant |  | Number, long integer | e.g., 10000, 34000, 40000, 57200 | Estimated quantity of aggregate
| comments |  | Text,50 | e.g., 9% limestone, Non-commercial, Almost Cl.5... | Additional comments about the aggregate source.