{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "Aggregate Resource Mapping Program - Compilation of DNR Test Holes", "type": "Feature Layer", "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.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "spatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 155, 34, 151, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 354219.98029999994, "ymin": 4860636.5, "xmax": 525180.0625, "ymax": 5208265.255000001, "spatialReference": { "wkid": 26915, "latestWkid": 26915, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "prjct_id", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "prjct_id", "type": "esriFieldTypeString", "alias": "MPES Project ID Number", "length": 6, "domain": null }, { "name": "prjct_desc", "type": "esriFieldTypeString", "alias": "MPES Project Description", "length": 100, "domain": null }, { "name": "th_id", "type": "esriFieldTypeString", "alias": "Test Hole ID", "length": 10, "domain": null }, { "name": "th_type", "type": "esriFieldTypeString", "alias": "Test Hole Type", "length": 100, "domain": null }, { "name": "type_desc", "type": "esriFieldTypeString", "alias": "Type Description (Auger Size, Bucket Size, etc.)", "length": 50, "domain": null }, { "name": "th_depth", "type": "esriFieldTypeDouble", "alias": "Test Hole Depth", "domain": null }, { "name": "prim_mat", "type": "esriFieldTypeString", "alias": "Primary Material", "length": 75, "domain": null }, { "name": "sec_mat", "type": "esriFieldTypeString", "alias": "Secondary Material", "length": 75, "domain": null }, { "name": "end_mat", "type": "esriFieldTypeString", "alias": "End Material", "length": 75, "domain": null }, { "name": "th_descrpt", "type": "esriFieldTypeString", "alias": "Test Hole Description", "length": 255, "domain": null }, { "name": "depth2wt", "type": "esriFieldTypeString", "alias": "Depth to Water Table", "length": 10, "domain": null }, { "name": "sg_thick", "type": "esriFieldTypeString", "alias": "Sand and Gravel Total Thickness", "length": 12, "domain": null }, { "name": "overburden", "type": "esriFieldTypeDouble", "alias": "Overburden", "domain": null }, { "name": "sampled", "type": "esriFieldTypeString", "alias": "Sampled (Yes/No)", "length": 5, "domain": null }, { "name": "samp_int", "type": "esriFieldTypeString", "alias": "Sample Interval", "length": 10, "domain": null }, { "name": "samp_tot", "type": "esriFieldTypeDouble", "alias": "SAMP_TOT", "domain": null }, { "name": "geologist", "type": "esriFieldTypeString", "alias": "Geologist", "length": 75, "domain": null }, { "name": "th_sampid", "type": "esriFieldTypeString", "alias": "Test Hole Sample ID", "length": 14, "domain": null }, { "name": "samp_lab", "type": "esriFieldTypeString", "alias": "Sample Lab", "length": 50, "domain": null }, { "name": "comp_samp", "type": "esriFieldTypeString", "alias": "Was the Sample a Composite? (Yes/No)", "length": 10, "domain": null }, { "name": "comp_nmbr", "type": "esriFieldTypeSmallInteger", "alias": "Number of Holes in the Composite?", "domain": null }, { "name": "comp_desc", "type": "esriFieldTypeString", "alias": "Test Hole IDs Composited", "length": 50, "domain": null }, { "name": "samp_from", "type": "esriFieldTypeSmallInteger", "alias": "Sample From Interval", "domain": null }, { "name": "samp_to", "type": "esriFieldTypeSmallInteger", "alias": "Sample To Interval", "domain": null }, { "name": "pct_4in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 4 Inch", "domain": null }, { "name": "pct_3in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 3 Inch", "domain": null }, { "name": "pct_2_5in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 2 1/2 Inch", "domain": null }, { "name": "pct_2in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 2 Inch", "domain": null }, { "name": "pct_1_5in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 1 1/2 Inch", "domain": null }, { "name": "pct_1_25in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 1 1/4 Inch", "domain": null }, { "name": "pct_1in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 1 Inch", "domain": null }, { "name": "pct_3_4in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 3/4 Inch", "domain": null }, { "name": "pct_5_8in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 5/8 Inch", "domain": null }, { "name": "pct_1_2in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 1/2 Inch", "domain": null }, { "name": "pct_3_8in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 3/8 Inch", "domain": null }, { "name": "pct_num4", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing #4 Sieve", "domain": null }, { "name": "pct_num8", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing #8 Sieve", "domain": null }, { "name": "pct_num10", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing #10 Sieve", "domain": null }, { "name": "pct_num16", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing #16 Sieve", "domain": null }, { "name": "pct_num30", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing #30 Sieve", "domain": null }, { "name": "pct_num40", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing #40 Sieve", "domain": null }, { "name": "pct_num50", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing #50 Sieve", "domain": null }, { "name": "pct_num100", "type": "esriFieldTypeSmallInteger", "alias": "PCT_NUM100", "domain": null }, { "name": "pct_num200", "type": "esriFieldTypeDouble", "alias": "Percent Passing #200 Sieve", "domain": null }, { "name": "pct_grvl", "type": "esriFieldTypeDouble", "alias": "Percent Gravel", "domain": null }, { "name": "pct_sand", "type": "esriFieldTypeDouble", "alias": "Percent Sand", "domain": null }, { "name": "pctsiltcly", "type": "esriFieldTypeDouble", "alias": "Percent Silt Clay", "domain": null }, { "name": "pctshlsand", "type": "esriFieldTypeDouble", "alias": "Percent Shale in Sand", "domain": null }, { "name": "pcttotshl4", "type": "esriFieldTypeDouble", "alias": "Percent Total Shale +4", "domain": null }, { "name": "pctsampshl", "type": "esriFieldTypeDouble", "alias": "Pecent Total Sample Shale", "domain": null }, { "name": "pctsndstn", "type": "esriFieldTypeDouble", "alias": "Pecent Sandstone", "domain": null }, { "name": "pctspl_arg", "type": "esriFieldTypeDouble", "alias": "Pecent Spall Argillite", "domain": null }, { "name": "pct_carb", "type": "esriFieldTypeDouble", "alias": "Percent Carbonate", "domain": null }, { "name": "pct_ironox", "type": "esriFieldTypeDouble", "alias": "Percent Iron Oxide", "domain": null }, { "name": "pct_ochre", "type": "esriFieldTypeDouble", "alias": "Percent Ochre", "domain": null }, { "name": "pct_unchrt", "type": "esriFieldTypeDouble", "alias": "Percent Unsound Chert", "domain": null }, { "name": "pct_schist", "type": "esriFieldTypeDouble", "alias": "Percent Schist", "domain": null }, { "name": "pctmiscspl", "type": "esriFieldTypeDouble", "alias": "Percent Misc. Spall", "domain": null }, { "name": "pct_ts_spl", "type": "esriFieldTypeDouble", "alias": "Percent Total Sample Spall", "domain": null }, { "name": "pctba_spl4", "type": "esriFieldTypeDouble", "alias": "Percent BA Spall +4", "domain": null }, { "name": "pctnsplarg", "type": "esriFieldTypeDouble", "alias": "Percent NonSpall Argillite", "domain": null }, { "name": "pctdisrock", "type": "esriFieldTypeDouble", "alias": "Percent Disintegrating Rock", "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 254, "domain": null }, { "name": "doclink", "type": "esriFieldTypeString", "alias": "Weblink to MnDOT Test", "length": 254, "domain": null }, { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "r8114_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a4295_ix1", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Data,Query", "maxRecordCount": 2000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "1dbb7e347ce74af5ac310179374790d4" }