View In:   ArcGIS Online Map Viewer

Name: Aggregate Resource Mapping Program - Compilation of Gravel Pits, Quarries, and Prospects

Display Field: pitcomp_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This spatial dataset of pits, quarries, and prospects is based on a compilation of GIS aggregate resources (sand and gravel, crushed stone) reconnaissance scale data spanning twenty county projects completed over a number of years (1987-present) by the DNR's Aggregate Resource Mapping Program (ARMP). The attribute data available varies as a result of the varied years of completion and changes in databases structure and verbiage over time. The past project GIS data has been loaded into the current file geodatabase used by the Aggregate Resource Mapping Program. Therefore the data from the most recent completed counties (Kandiyohi, Aitkin, Stearns, Kanabec, Olmsted) have the most complete attribute table, while the earlier mapped counties (Sherburne, Wright, Isanti) have limited attribute data. This dataset includes information gathered in the field by Aggregate Mapping Resource Program geologists since 1987. It includes 6,393 aggregate resource or prospective sites in Minnesota. There are pits and quarries that are currently being mined or have been mined. Several sources of information identify pit locations: topographic maps, aerial photographs, soil surveys, Mn/DOT (Aggregate Source Information System) ASIS files, LiDAR topographic data, fieldwork, gravel operators, and other miscellaneous sources. Pits range in size from less than 1 acre to greater than 50 acres and may be active, inactive, or reclaimed. The aggregate quality of the pit varies.

Service Item Id: a9c5fa193906424e93226d491da7dce7

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 222065.32210000046
YMin: 4854438.434800001
XMax: 601024.2531000003
YMax: 5307703.2435
Spatial Reference: 26915  (26915)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [120, 158, 64, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• pitcomp_id ( type: esriFieldTypeString, alias: Compilation ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Pit_Q_ID )
• source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 30, defaultValue: null, modelName: source )
• type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: type )
• fieldcheck ( type: esriFieldTypeString, alias: Field_Chk, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FieldCheck )
• asis_numbr ( type: esriFieldTypeString, alias: ASIS_Numbr, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ASIS_numbr )
• material_1 ( type: esriFieldTypeString, alias: Material_1, editable: true, nullable: true, length: 25, defaultValue: null, modelName: material_1 )
• material_2 ( type: esriFieldTypeString, alias: Material_2, editable: true, nullable: true, length: 25, defaultValue: null, modelName: material_2 )
• size ( type: esriFieldTypeString, alias: Size, editable: true, nullable: true, length: 10, defaultValue: null, modelName: size )
• thickness ( type: esriFieldTypeString, alias: Thickness, editable: true, nullable: true, length: 15, defaultValue: null, modelName: thickness )
• overburden ( type: esriFieldTypeString, alias: Overburden, editable: true, nullable: true, length: 15, defaultValue: null, modelName: overburden )
• watertable ( type: esriFieldTypeString, alias: Watertable, editable: true, nullable: true, length: 15, defaultValue: null, modelName: watertable )
• status_1 ( type: esriFieldTypeString, alias: Status_1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: status_1 )
• status_2 ( type: esriFieldTypeString, alias: Status_2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: status_2 )
• dom_litho ( type: esriFieldTypeString, alias: Dom_litho, editable: true, nullable: true, length: 50, defaultValue: null, modelName: dom_litho )
• dom_text ( type: esriFieldTypeString, alias: Dom_text, editable: true, nullable: true, length: 50, defaultValue: null, modelName: dom_text )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 200, defaultValue: null, modelName: comments )
• county ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 50, defaultValue: null, modelName: county )
• year_current ( type: esriFieldTypeString, alias: Year_Current, editable: true, nullable: true, length: 15, defaultValue: null, modelName: year_current )

Templates:

• Name: Aggregate Resource Mapping Program - Compilation of Gravel Pits, Quarries, and Prospects
  Description:
  Prototype:
  county: null
  year_current: null
  pitcomp_id: null
  source: null
  type: null
  fieldcheck: null
  asis_numbr: null
  material_1: null
  material_2: null
  size: null
  thickness: null
  overburden: null
  watertable: null
  status_1: null
  status_2: null
  dom_litho: null
  dom_text: null
  comments: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata