Name: DNR Pits, Quarries, and Prospects

Display Field: pitcomp_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><P><SPAN>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.</SPAN></P><P><SPAN>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.</SPAN></P></DIV>

Service Item Id: 08f31299c98245b2877e338b4646ddaa

Copyright Text: Minnesota Department of Natural Resources, Division of Lands & Minerals

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.0766408400429182E7
YMin: 5433124.352122843
XMax: -1.0202200739517445E7
YMax: 6093997.721100657
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: type
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Dimension Stone Quarry
  Label: Aggregate Quarry
  Description: N/A
  Symbol:
  
• Value: Borrow Pit
  Label: Borrow Pit
  Description: N/A
  Symbol:
  
• Value: Clay Pit
  Label: Clay Pit
  Description: N/A
  Symbol:
  
• Value: Dimension Stone Quarry
  Label: Aggregate Quarry
  Description: N/A
  Symbol:
  
• Value: Gravel Pit
  Label: Gravel Pit
  Description: N/A
  Symbol:
  
• Value: Industrial Sand Quarry
  Label: Industrial Sand Quarry
  Description: N/A
  Symbol:
  
• Value: Pit/Quarry
  Label: Pit/Quarry
  Description: N/A
  Symbol:
  
• Value: Prospect
  Label: Prospect
  Description: N/A
  Symbol:
  
• Value: Quarry
  Label: Quarry
  Description: N/A
  Symbol:
  
• Value: Sand Pit
  Label: Sand Pit
  Description: N/A
  Symbol:
  
• Value: Stone Quarry
  Label: Stone Quarry
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID_1 )
• pitcomp_id ( type: esriFieldTypeString, alias: Compilation ID, length: 15 )
• source ( type: esriFieldTypeString, alias: Source, length: 30 )
• type ( type: esriFieldTypeString, alias: Type, length: 100 )
• fieldcheck ( type: esriFieldTypeString, alias: Field_Chk, length: 30 )
• asis_numbr ( type: esriFieldTypeString, alias: ASIS_Numbr, length: 8 )
• material_1 ( type: esriFieldTypeString, alias: Material_1, length: 25 )
• material_2 ( type: esriFieldTypeString, alias: Material_2, length: 25 )
• size ( type: esriFieldTypeString, alias: Size, length: 10 )
• thickness ( type: esriFieldTypeString, alias: Thickness, length: 15 )
• overburden ( type: esriFieldTypeString, alias: Overburden, length: 15 )
• watertable ( type: esriFieldTypeString, alias: Watertable, length: 15 )
• status_1 ( type: esriFieldTypeString, alias: Status_1, length: 50 )
• status_2 ( type: esriFieldTypeString, alias: Status_2, length: 50 )
• dom_litho ( type: esriFieldTypeString, alias: Dom_litho, length: 50 )
• dom_text ( type: esriFieldTypeString, alias: Dom_text, length: 50 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 200 )
• county ( type: esriFieldTypeString, alias: County, length: 50 )
• year_current ( type: esriFieldTypeString, alias: Year_Current, length: 15 )
• shape ( type: esriFieldTypeGeometry, alias: Shape )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata