View In:   ArcGIS Online Map Viewer

Name: Aggregate Resource Mapping Program - Compilation of DNR Test Holes

Display Field: prjct_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: 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.

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: 354219.98029999994
YMin: 4860636.5
XMax: 525180.0625
YMax: 5208265.255000001
Spatial Reference: 26915  (26915)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [155, 34, 151, 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 )
• prjct_id ( type: esriFieldTypeString, alias: MPES Project ID Number, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PRJCT_ID )
• prjct_desc ( type: esriFieldTypeString, alias: MPES Project Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PRJCT_DESC )
• th_id ( type: esriFieldTypeString, alias: Test Hole ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TH_ID )
• th_type ( type: esriFieldTypeString, alias: Test Hole Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TH_TYPE )
• type_desc ( type: esriFieldTypeString, alias: Type Description (Auger Size, Bucket Size, etc.), editable: true, nullable: true, length: 50, defaultValue: null, modelName: TH_ELEV )
• th_depth ( type: esriFieldTypeDouble, alias: Test Hole Depth, editable: true, nullable: true, defaultValue: null, modelName: TH_DEPTH )
• prim_mat ( type: esriFieldTypeString, alias: Primary Material, editable: true, nullable: true, length: 75, defaultValue: null, modelName: PRIM_MAT )
• sec_mat ( type: esriFieldTypeString, alias: Secondary Material, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SEC_MAT )
• end_mat ( type: esriFieldTypeString, alias: End Material, editable: true, nullable: true, length: 75, defaultValue: null, modelName: TH_DESCRPT )
• th_descrpt ( type: esriFieldTypeString, alias: Test Hole Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DEPTH2WT )
• depth2wt ( type: esriFieldTypeString, alias: Depth to Water Table, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SG_THICK )
• sg_thick ( type: esriFieldTypeString, alias: Sand and Gravel Total Thickness, editable: true, nullable: true, length: 12, defaultValue: null, modelName: OVERBURDEN )
• overburden ( type: esriFieldTypeDouble, alias: Overburden, editable: true, nullable: true, defaultValue: null, modelName: SAMPLED )
• sampled ( type: esriFieldTypeString, alias: Sampled (Yes/No), editable: true, nullable: true, length: 5, defaultValue: null, modelName: SAMP_INT )
• samp_int ( type: esriFieldTypeString, alias: Sample Interval, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SAMP_TOT )
• samp_tot ( type: esriFieldTypeDouble, alias: SAMP_TOT, editable: true, nullable: true, defaultValue: null, modelName: LOGFORM )
• geologist ( type: esriFieldTypeString, alias: Geologist, editable: true, nullable: true, length: 75, defaultValue: null, modelName: TH_ELEV2 )
• th_sampid ( type: esriFieldTypeString, alias: Test Hole Sample ID, editable: true, nullable: true, length: 14, defaultValue: null, modelName: TH_SAMPID )
• samp_lab ( type: esriFieldTypeString, alias: Sample Lab, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SAMP_LAB )
• comp_samp ( type: esriFieldTypeString, alias: Was the Sample a Composite? (Yes/No), editable: true, nullable: true, length: 10, defaultValue: null, modelName: COMP_SAMP )
• comp_nmbr ( type: esriFieldTypeSmallInteger, alias: Number of Holes in the Composite?, editable: true, nullable: true, defaultValue: null, modelName: COMP_NMBR )
• comp_desc ( type: esriFieldTypeString, alias: Test Hole IDs Composited, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMP_DESC )
• samp_from ( type: esriFieldTypeSmallInteger, alias: Sample From Interval, editable: true, nullable: true, defaultValue: null, modelName: SAMP_FROM )
• samp_to ( type: esriFieldTypeSmallInteger, alias: Sample To Interval, editable: true, nullable: true, defaultValue: null, modelName: SAMP_TO )
• pct_4in ( type: esriFieldTypeSmallInteger, alias: Percent Passing 4 Inch, editable: true, nullable: true, defaultValue: null, modelName: PCT_4IN )
• pct_3in ( type: esriFieldTypeSmallInteger, alias: Percent Passing 3 Inch, editable: true, nullable: true, defaultValue: null, modelName: PCT_3IN )
• pct_2_5in ( type: esriFieldTypeSmallInteger, alias: Percent Passing 2 1/2 Inch, editable: true, nullable: true, defaultValue: null, modelName: PCT_2_5IN )
• pct_2in ( type: esriFieldTypeSmallInteger, alias: Percent Passing 2 Inch, editable: true, nullable: true, defaultValue: null, modelName: PCT_2IN )
• pct_1_5in ( type: esriFieldTypeSmallInteger, alias: Percent Passing 1 1/2 Inch, editable: true, nullable: true, defaultValue: null, modelName: PCT_1_5IN )
• pct_1_25in ( type: esriFieldTypeSmallInteger, alias: Percent Passing 1 1/4 Inch, editable: true, nullable: true, defaultValue: null, modelName: PCT_1IN )
• pct_1in ( type: esriFieldTypeSmallInteger, alias: Percent Passing 1 Inch, editable: true, nullable: true, defaultValue: null, modelName: PCT_3_4IN )
• pct_3_4in ( type: esriFieldTypeSmallInteger, alias: Percent Passing 3/4 Inch, editable: true, nullable: true, defaultValue: null, modelName: PCT_5_8IN )
• pct_5_8in ( type: esriFieldTypeSmallInteger, alias: Percent Passing 5/8 Inch, editable: true, nullable: true, defaultValue: null, modelName: PCT_1_2IN )
• pct_1_2in ( type: esriFieldTypeSmallInteger, alias: Percent Passing 1/2 Inch, editable: true, nullable: true, defaultValue: null, modelName: PCT_3_8IN )
• pct_3_8in ( type: esriFieldTypeSmallInteger, alias: Percent Passing 3/8 Inch, editable: true, nullable: true, defaultValue: null, modelName: PCT_NUM4 )
• pct_num4 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #4 Sieve, editable: true, nullable: true, defaultValue: null, modelName: PCT_NUM8 )
• pct_num8 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #8 Sieve, editable: true, nullable: true, defaultValue: null, modelName: PCT_NUM10 )
• pct_num10 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #10 Sieve, editable: true, nullable: true, defaultValue: null, modelName: PCT_NUM16 )
• pct_num16 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #16 Sieve, editable: true, nullable: true, defaultValue: null, modelName: PCT_NUM30 )
• pct_num30 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #30 Sieve, editable: true, nullable: true, defaultValue: null, modelName: PCT_NUM40 )
• pct_num40 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #40 Sieve, editable: true, nullable: true, defaultValue: null, modelName: PCT_NUM50 )
• pct_num50 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #50 Sieve, editable: true, nullable: true, defaultValue: null, modelName: PCT_NUM100 )
• pct_num100 ( type: esriFieldTypeSmallInteger, alias: PCT_NUM100, editable: true, nullable: true, defaultValue: null, modelName: PCT_NUM200 )
• pct_num200 ( type: esriFieldTypeDouble, alias: Percent Passing #200 Sieve, editable: true, nullable: true, defaultValue: null, modelName: PCT_GRVL )
• pct_grvl ( type: esriFieldTypeDouble, alias: Percent Gravel, editable: true, nullable: true, defaultValue: null, modelName: PCT_SAND )
• pct_sand ( type: esriFieldTypeDouble, alias: Percent Sand, editable: true, nullable: true, defaultValue: null, modelName: PCT_SILTCLY )
• pctsiltcly ( type: esriFieldTypeDouble, alias: Percent Silt Clay, editable: true, nullable: true, defaultValue: null, modelName: PCTSHLSAND )
• pctshlsand ( type: esriFieldTypeDouble, alias: Percent Shale in Sand, editable: true, nullable: true, defaultValue: null, modelName: PCTTOTSHL4 )
• pcttotshl4 ( type: esriFieldTypeDouble, alias: Percent Total Shale +4, editable: true, nullable: true, defaultValue: null, modelName: PCTSAMPSHL )
• pctsampshl ( type: esriFieldTypeDouble, alias: Pecent Total Sample Shale, editable: true, nullable: true, defaultValue: null, modelName: PCTSNDSTN )
• pctsndstn ( type: esriFieldTypeDouble, alias: Pecent Sandstone, editable: true, nullable: true, defaultValue: null, modelName: PCTSPL_ARG )
• pctspl_arg ( type: esriFieldTypeDouble, alias: Pecent Spall Argillite, editable: true, nullable: true, defaultValue: null, modelName: PCT_CARB )
• pct_carb ( type: esriFieldTypeDouble, alias: Percent Carbonate, editable: true, nullable: true, defaultValue: null, modelName: PCT_IRONOX )
• pct_ironox ( type: esriFieldTypeDouble, alias: Percent Iron Oxide, editable: true, nullable: true, defaultValue: null, modelName: PCT_OCHRE )
• pct_ochre ( type: esriFieldTypeDouble, alias: Percent Ochre, editable: true, nullable: true, defaultValue: null, modelName: PCT_UNCHRT )
• pct_unchrt ( type: esriFieldTypeDouble, alias: Percent Unsound Chert, editable: true, nullable: true, defaultValue: null, modelName: PCT_SCHIST )
• pct_schist ( type: esriFieldTypeDouble, alias: Percent Schist, editable: true, nullable: true, defaultValue: null, modelName: PCTMISCSPL )
• pctmiscspl ( type: esriFieldTypeDouble, alias: Percent Misc. Spall, editable: true, nullable: true, defaultValue: null, modelName: PCT_TS_SPL )
• pct_ts_spl ( type: esriFieldTypeDouble, alias: Percent Total Sample Spall, editable: true, nullable: true, defaultValue: null, modelName: PCTBA_SPL4 )
• pctba_spl4 ( type: esriFieldTypeDouble, alias: Percent BA Spall +4, editable: true, nullable: true, defaultValue: null, modelName: PCTNSPLARG )
• pctnsplarg ( type: esriFieldTypeDouble, alias: Percent NonSpall Argillite, editable: true, nullable: true, defaultValue: null, modelName: PCTDISROCK )
• pctdisrock ( type: esriFieldTypeDouble, alias: Percent Disintegrating Rock, editable: true, nullable: true, defaultValue: null, modelName: PCTDISROCK )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 254, defaultValue: null, modelName: DOCLINK )
• doclink ( type: esriFieldTypeString, alias: Weblink to MnDOT Test, editable: true, nullable: true, length: 254, defaultValue: null, modelName: DOCLINK )

Templates:

• Name: Aggregate Resource Mapping Program - Compilation of DNR Test Holes
  Description:
  Prototype:
  comments: null
  doclink: null
  prjct_id: null
  prjct_desc: null
  th_id: null
  th_type: null
  type_desc: null
  th_depth: null
  prim_mat: null
  sec_mat: null
  end_mat: null
  th_descrpt: null
  depth2wt: null
  sg_thick: null
  overburden: null
  sampled: null
  samp_int: null
  samp_tot: null
  geologist: null
  th_sampid: null
  samp_lab: null
  comp_samp: null
  comp_nmbr: null
  comp_desc: null
  samp_from: null
  samp_to: null
  pct_4in: null
  pct_3in: null
  pct_2_5in: null
  pct_2in: null
  pct_1_5in: null
  pct_1_25in: null
  pct_1in: null
  pct_3_4in: null
  pct_5_8in: null
  pct_1_2in: null
  pct_3_8in: null
  pct_num4: null
  pct_num8: null
  pct_num10: null
  pct_num16: null
  pct_num30: null
  pct_num40: null
  pct_num50: null
  pct_num100: null
  pct_num200: null
  pct_grvl: null
  pct_sand: null
  pctsiltcly: null
  pctshlsand: null
  pcttotshl4: null
  pctsampshl: null
  pctsndstn: null
  pctspl_arg: null
  pct_carb: null
  pct_ironox: null
  pct_ochre: null
  pct_unchrt: null
  pct_schist: null
  pctmiscspl: null
  pct_ts_spl: null
  pctba_spl4: null
  pctnsplarg: null
  pctdisrock: 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