Layers:

Layer: Test Holes Sampled (0)

Name: Test Holes Sampled

Display Field: PRJCT_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: ee675f914cce4be793a67e915511fb4d

Copyright Text:

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.0566220074331427E7
YMin: 5447574.597332168
XMax: -1.0315825036519714E7
YMax: 5946631.653607843
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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: false
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 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• PRJCT_ID ( type: esriFieldTypeString, alias: MPES Project ID Number, length: 6 )
• PRJCT_DESC ( type: esriFieldTypeString, alias: MPES Project Description, length: 100 )
• TH_ID ( type: esriFieldTypeString, alias: Test Hole ID, length: 10 )
• TH_TYPE ( type: esriFieldTypeString, alias: Test Hole Type, length: 100 )
• TYPE_DESC ( type: esriFieldTypeString, alias: Type Description (Auger Size, Bucket Size, etc.), length: 50 )
• TH_DEPTH ( type: esriFieldTypeDouble, alias: Test Hole Depth )
• PRIM_MAT ( type: esriFieldTypeString, alias: Primary Material, length: 75 )
• SEC_MAT ( type: esriFieldTypeString, alias: Secondary Material, length: 75 )
• END_MAT ( type: esriFieldTypeString, alias: End Material, length: 75 )
• TH_DESCRPT ( type: esriFieldTypeString, alias: Test Hole Description, length: 255 )
• DEPTH2WT ( type: esriFieldTypeString, alias: Depth to Water Table, length: 10 )
• SG_THICK ( type: esriFieldTypeString, alias: Sand and Gravel Total Thickness, length: 12 )
• OVERBURDEN ( type: esriFieldTypeDouble, alias: Overburden )
• SAMPLED ( type: esriFieldTypeString, alias: Sampled (Yes/No), length: 5 )
• SAMP_INT ( type: esriFieldTypeString, alias: Sample Interval, length: 10 )
• SAMP_TOT ( type: esriFieldTypeDouble, alias: SAMP_TOT )
• GEOLOGIST ( type: esriFieldTypeString, alias: Geologist, length: 75 )
• TH_SAMPID ( type: esriFieldTypeString, alias: Test Hole Sample ID, length: 14 )
• SAMP_LAB ( type: esriFieldTypeString, alias: Sample Lab, length: 50 )
• COMP_SAMP ( type: esriFieldTypeString, alias: Was the Sample a Composite? (Yes/No), length: 10 )
• COMP_NMBR ( type: esriFieldTypeSmallInteger, alias: Number of Holes in the Composite? )
• COMP_DESC ( type: esriFieldTypeString, alias: Test Hole IDs Composited, length: 50 )
• SAMP_FROM ( type: esriFieldTypeSmallInteger, alias: Sample From Interval )
• SAMP_TO ( type: esriFieldTypeSmallInteger, alias: Sample To Interval )
• PCT_4IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 4 Inch )
• PCT_3IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 3 Inch )
• PCT_2_5IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 2 1/2 Inch )
• PCT_2IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 2 Inch )
• PCT_1_5IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 1 1/2 Inch )
• PCT_1_25IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 1 1/4 Inch )
• PCT_1IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 1 Inch )
• PCT_3_4IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 3/4 Inch )
• PCT_5_8IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 5/8 Inch )
• PCT_1_2IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 1/2 Inch )
• PCT_3_8IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 3/8 Inch )
• PCT_NUM4 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #4 Sieve )
• PCT_NUM8 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #8 Sieve )
• PCT_NUM10 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #10 Sieve )
• PCT_NUM16 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #16 Sieve )
• PCT_NUM30 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #30 Sieve )
• PCT_NUM40 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #40 Sieve )
• PCT_NUM50 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #50 Sieve )
• PCT_NUM100 ( type: esriFieldTypeSmallInteger, alias: PCT_NUM100 )
• PCT_NUM200 ( type: esriFieldTypeDouble, alias: Percent Passing #200 Sieve )
• PCT_GRVL ( type: esriFieldTypeDouble, alias: Percent Gravel )
• PCT_SAND ( type: esriFieldTypeDouble, alias: Percent Sand )
• PCTSILTCLY ( type: esriFieldTypeDouble, alias: Percent Silt Clay )
• PCTSHLSAND ( type: esriFieldTypeDouble, alias: Percent Shale in Sand )
• PCTTOTSHL4 ( type: esriFieldTypeDouble, alias: Percent Total Shale +4 )
• PCTSAMPSHL ( type: esriFieldTypeDouble, alias: Pecent Total Sample Shale )
• PCTSNDSTN ( type: esriFieldTypeDouble, alias: Pecent Sandstone )
• PCTSPL_ARG ( type: esriFieldTypeDouble, alias: Pecent Spall Argillite )
• PCT_CARB ( type: esriFieldTypeDouble, alias: Percent Carbonate )
• PCT_IRONOX ( type: esriFieldTypeDouble, alias: Percent Iron Oxide )
• PCT_OCHRE ( type: esriFieldTypeDouble, alias: Percent Ochre )
• PCT_UNCHRT ( type: esriFieldTypeDouble, alias: Percent Unsound Chert )
• PCT_SCHIST ( type: esriFieldTypeDouble, alias: Percent Schist )
• PCTMISCSPL ( type: esriFieldTypeDouble, alias: Percent Misc. Spall )
• PCT_TS_SPL ( type: esriFieldTypeDouble, alias: Percent Total Sample Spall )
• PCTBA_SPL4 ( type: esriFieldTypeDouble, alias: Percent BA Spall +4 )
• PCTNSPLARG ( type: esriFieldTypeDouble, alias: Percent NonSpall Argillite )
• PCTDISROCK ( type: esriFieldTypeDouble, alias: Percent Disintegrating Rock )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 254 )
• DOCLINK ( type: esriFieldTypeString, alias: Weblink to MnDOT Test, length: 254 )

Layer: Test Holes Not Sampled (1)

Name: Test Holes Not Sampled

Display Field: PRJCT_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: ee675f914cce4be793a67e915511fb4d

Copyright Text:

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.0566220074331427E7
YMin: 5447574.597332168
XMax: -1.0315825036519714E7
YMax: 5946631.653607843
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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: false
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 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• PRJCT_ID ( type: esriFieldTypeString, alias: MPES Project ID Number, length: 6 )
• PRJCT_DESC ( type: esriFieldTypeString, alias: MPES Project Description, length: 100 )
• TH_ID ( type: esriFieldTypeString, alias: Test Hole ID, length: 10 )
• TH_TYPE ( type: esriFieldTypeString, alias: Test Hole Type, length: 100 )
• TYPE_DESC ( type: esriFieldTypeString, alias: Type Description (Auger Size, Bucket Size, etc.), length: 50 )
• TH_DEPTH ( type: esriFieldTypeDouble, alias: Test Hole Depth )
• PRIM_MAT ( type: esriFieldTypeString, alias: Primary Material, length: 75 )
• SEC_MAT ( type: esriFieldTypeString, alias: Secondary Material, length: 75 )
• END_MAT ( type: esriFieldTypeString, alias: End Material, length: 75 )
• TH_DESCRPT ( type: esriFieldTypeString, alias: Test Hole Description, length: 255 )
• DEPTH2WT ( type: esriFieldTypeString, alias: Depth to Water Table, length: 10 )
• SG_THICK ( type: esriFieldTypeString, alias: Sand and Gravel Total Thickness, length: 12 )
• OVERBURDEN ( type: esriFieldTypeDouble, alias: Overburden )
• SAMPLED ( type: esriFieldTypeString, alias: Sampled (Yes/No), length: 5 )
• SAMP_INT ( type: esriFieldTypeString, alias: Sample Interval, length: 10 )
• SAMP_TOT ( type: esriFieldTypeDouble, alias: SAMP_TOT )
• GEOLOGIST ( type: esriFieldTypeString, alias: Geologist, length: 75 )
• TH_SAMPID ( type: esriFieldTypeString, alias: Test Hole Sample ID, length: 14 )
• SAMP_LAB ( type: esriFieldTypeString, alias: Sample Lab, length: 50 )
• COMP_SAMP ( type: esriFieldTypeString, alias: Was the Sample a Composite? (Yes/No), length: 10 )
• COMP_NMBR ( type: esriFieldTypeSmallInteger, alias: Number of Holes in the Composite? )
• COMP_DESC ( type: esriFieldTypeString, alias: Test Hole IDs Composited, length: 50 )
• SAMP_FROM ( type: esriFieldTypeSmallInteger, alias: Sample From Interval )
• SAMP_TO ( type: esriFieldTypeSmallInteger, alias: Sample To Interval )
• PCT_4IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 4 Inch )
• PCT_3IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 3 Inch )
• PCT_2_5IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 2 1/2 Inch )
• PCT_2IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 2 Inch )
• PCT_1_5IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 1 1/2 Inch )
• PCT_1_25IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 1 1/4 Inch )
• PCT_1IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 1 Inch )
• PCT_3_4IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 3/4 Inch )
• PCT_5_8IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 5/8 Inch )
• PCT_1_2IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 1/2 Inch )
• PCT_3_8IN ( type: esriFieldTypeSmallInteger, alias: Percent Passing 3/8 Inch )
• PCT_NUM4 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #4 Sieve )
• PCT_NUM8 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #8 Sieve )
• PCT_NUM10 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #10 Sieve )
• PCT_NUM16 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #16 Sieve )
• PCT_NUM30 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #30 Sieve )
• PCT_NUM40 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #40 Sieve )
• PCT_NUM50 ( type: esriFieldTypeSmallInteger, alias: Percent Passing #50 Sieve )
• PCT_NUM100 ( type: esriFieldTypeSmallInteger, alias: PCT_NUM100 )
• PCT_NUM200 ( type: esriFieldTypeDouble, alias: Percent Passing #200 Sieve )
• PCT_GRVL ( type: esriFieldTypeDouble, alias: Percent Gravel )
• PCT_SAND ( type: esriFieldTypeDouble, alias: Percent Sand )
• PCTSILTCLY ( type: esriFieldTypeDouble, alias: Percent Silt Clay )
• PCTSHLSAND ( type: esriFieldTypeDouble, alias: Percent Shale in Sand )
• PCTTOTSHL4 ( type: esriFieldTypeDouble, alias: Percent Total Shale +4 )
• PCTSAMPSHL ( type: esriFieldTypeDouble, alias: Pecent Total Sample Shale )
• PCTSNDSTN ( type: esriFieldTypeDouble, alias: Pecent Sandstone )
• PCTSPL_ARG ( type: esriFieldTypeDouble, alias: Pecent Spall Argillite )
• PCT_CARB ( type: esriFieldTypeDouble, alias: Percent Carbonate )
• PCT_IRONOX ( type: esriFieldTypeDouble, alias: Percent Iron Oxide )
• PCT_OCHRE ( type: esriFieldTypeDouble, alias: Percent Ochre )
• PCT_UNCHRT ( type: esriFieldTypeDouble, alias: Percent Unsound Chert )
• PCT_SCHIST ( type: esriFieldTypeDouble, alias: Percent Schist )
• PCTMISCSPL ( type: esriFieldTypeDouble, alias: Percent Misc. Spall )
• PCT_TS_SPL ( type: esriFieldTypeDouble, alias: Percent Total Sample Spall )
• PCTBA_SPL4 ( type: esriFieldTypeDouble, alias: Percent BA Spall +4 )
• PCTNSPLARG ( type: esriFieldTypeDouble, alias: Percent NonSpall Argillite )
• PCTDISROCK ( type: esriFieldTypeDouble, alias: Percent Disintegrating Rock )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 254 )
• DOCLINK ( type: esriFieldTypeString, alias: Weblink to MnDOT Test, length: 254 )

Layer: Field Observations (2)

Name: Field Observations

Display Field: field_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV STYLE="font-size:12pt"><P><SPAN>This spatial dataset of geologic field observations 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 (Aitkin, Stearns, Kanabec, Olmsted) have the most complete attribute table, while the earlier mapped counties (Sherburne, Wright, Isanti) have limited attribute data. Digital Geologic Field Observations started being collected for the Isanti County Project completed in 1991 and continues today</SPAN></P><P><SPAN>This dataset includes information gathered in the field by Aggregate Mapping Resource Program geologists since 1991. It includes 15,957 field observation sites in Minnesota. Observations include, but are not limited to: natural exposures of surficial geologic sediment or bedrock outcrops, artificial and temporary exposures in gravel, borrow, sand pits, or quarries, along road cuts or in excavations and observations of the surface. This spatial dataset may contain a field description of each site, the dominant type of materials encountered, the source of information, geologic unit thickness (if non-aggregate-bearing; aggregate unit thickness and geologic overburden thickness if aggregate is not present at surface).</SPAN></P></DIV></DIV></DIV>

Service Item Id: ee675f914cce4be793a67e915511fb4d

Copyright Text: Minnesota Department of Natural Resources

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.0716561467493318E7
YMin: 5434871.857907248
XMax: -1.0202219636179434E7
YMax: 6094496.567969076
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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 )
• field_id ( type: esriFieldTypeString, alias: FIELD_ID, length: 8 )
• sitetype_1 ( type: esriFieldTypeString, alias: SITETYPE_1, length: 25 )
• sitetype_2 ( type: esriFieldTypeString, alias: SITETYPE_2, length: 25 )
• material_1 ( type: esriFieldTypeString, alias: MATERIAL_1, length: 150 )
• material_2 ( type: esriFieldTypeString, alias: MATERIAL_2, length: 150 )
• fielddesc ( type: esriFieldTypeString, alias: FIELDDESC, length: 254 )
• thickness ( type: esriFieldTypeString, alias: THICKNESS, length: 15 )
• thick_mod ( type: esriFieldTypeString, alias: THICK_MOD, length: 1 )
• thick_min ( type: esriFieldTypeDouble, alias: THICK_MIN )
• thick_max ( type: esriFieldTypeDouble, alias: THICK_MAX )
• overburden ( type: esriFieldTypeString, alias: OVERBURDEN, length: 15 )
• over_mod ( type: esriFieldTypeString, alias: OVER_MOD, length: 1 )
• over_min ( type: esriFieldTypeDouble, alias: OVER_MIN )
• over_max ( type: esriFieldTypeDouble, alias: OVER_MAX )
• sampled ( type: esriFieldTypeString, alias: SAMPLED, length: 3 )
• gravel_pct ( type: esriFieldTypeDouble, alias: GRAVEL_PCT )
• county ( type: esriFieldTypeString, alias: COUNTY, length: 50 )
• sampleid ( type: esriFieldTypeString, alias: SampleID, length: 15 )
• year_current ( type: esriFieldTypeString, alias: YEAR_CURRENT, length: 10 )
• webpage ( type: esriFieldTypeString, alias: WEBPAGE, length: 254 )
• orig_data ( type: esriFieldTypeString, alias: Link to Download Original Project Data Package, length: 254 )
• shape ( type: esriFieldTypeGeometry, alias: shape )