{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "Aggregate Resource Mapping Program - Compilation of DNR Test Holes", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "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.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": 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 } }, "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 }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "objectid", "globalIdField": "", "displayField": "prjct_id", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "prjct_id", "type": "esriFieldTypeString", "alias": "MPES Project ID Number", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "PRJCT_ID" }, { "name": "prjct_desc", "type": "esriFieldTypeString", "alias": "MPES Project Description", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PRJCT_DESC" }, { "name": "th_id", "type": "esriFieldTypeString", "alias": "Test Hole ID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "TH_ID" }, { "name": "th_type", "type": "esriFieldTypeString", "alias": "Test Hole Type", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "TH_TYPE" }, { "name": "type_desc", "type": "esriFieldTypeString", "alias": "Type Description (Auger Size, Bucket Size, etc.)", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TH_ELEV" }, { "name": "th_depth", "type": "esriFieldTypeDouble", "alias": "Test Hole Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TH_DEPTH" }, { "name": "prim_mat", "type": "esriFieldTypeString", "alias": "Primary Material", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "PRIM_MAT" }, { "name": "sec_mat", "type": "esriFieldTypeString", "alias": "Secondary Material", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "SEC_MAT" }, { "name": "end_mat", "type": "esriFieldTypeString", "alias": "End Material", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "TH_DESCRPT" }, { "name": "th_descrpt", "type": "esriFieldTypeString", "alias": "Test Hole Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DEPTH2WT" }, { "name": "depth2wt", "type": "esriFieldTypeString", "alias": "Depth to Water Table", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SG_THICK" }, { "name": "sg_thick", "type": "esriFieldTypeString", "alias": "Sand and Gravel Total Thickness", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "OVERBURDEN" }, { "name": "overburden", "type": "esriFieldTypeDouble", "alias": "Overburden", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SAMPLED" }, { "name": "sampled", "type": "esriFieldTypeString", "alias": "Sampled (Yes/No)", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SAMP_INT" }, { "name": "samp_int", "type": "esriFieldTypeString", "alias": "Sample Interval", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SAMP_TOT" }, { "name": "samp_tot", "type": "esriFieldTypeDouble", "alias": "SAMP_TOT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LOGFORM" }, { "name": "geologist", "type": "esriFieldTypeString", "alias": "Geologist", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "TH_ELEV2" }, { "name": "th_sampid", "type": "esriFieldTypeString", "alias": "Test Hole Sample ID", "domain": null, "editable": true, "nullable": true, "length": 14, "defaultValue": null, "modelName": "TH_SAMPID" }, { "name": "samp_lab", "type": "esriFieldTypeString", "alias": "Sample Lab", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SAMP_LAB" }, { "name": "comp_samp", "type": "esriFieldTypeString", "alias": "Was the Sample a Composite? (Yes/No)", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "COMP_SAMP" }, { "name": "comp_nmbr", "type": "esriFieldTypeSmallInteger", "alias": "Number of Holes in the Composite?", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COMP_NMBR" }, { "name": "comp_desc", "type": "esriFieldTypeString", "alias": "Test Hole IDs Composited", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "COMP_DESC" }, { "name": "samp_from", "type": "esriFieldTypeSmallInteger", "alias": "Sample From Interval", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SAMP_FROM" }, { "name": "samp_to", "type": "esriFieldTypeSmallInteger", "alias": "Sample To Interval", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SAMP_TO" }, { "name": "pct_4in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 4 Inch", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_4IN" }, { "name": "pct_3in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 3 Inch", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_3IN" }, { "name": "pct_2_5in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 2 1/2 Inch", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_2_5IN" }, { "name": "pct_2in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 2 Inch", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_2IN" }, { "name": "pct_1_5in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 1 1/2 Inch", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_1_5IN" }, { "name": "pct_1_25in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 1 1/4 Inch", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_1IN" }, { "name": "pct_1in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 1 Inch", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_3_4IN" }, { "name": "pct_3_4in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 3/4 Inch", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_5_8IN" }, { "name": "pct_5_8in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 5/8 Inch", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_1_2IN" }, { "name": "pct_1_2in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 1/2 Inch", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_3_8IN" }, { "name": "pct_3_8in", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing 3/8 Inch", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_NUM4" }, { "name": "pct_num4", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing #4 Sieve", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_NUM8" }, { "name": "pct_num8", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing #8 Sieve", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_NUM10" }, { "name": "pct_num10", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing #10 Sieve", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_NUM16" }, { "name": "pct_num16", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing #16 Sieve", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_NUM30" }, { "name": "pct_num30", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing #30 Sieve", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_NUM40" }, { "name": "pct_num40", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing #40 Sieve", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_NUM50" }, { "name": "pct_num50", "type": "esriFieldTypeSmallInteger", "alias": "Percent Passing #50 Sieve", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_NUM100" }, { "name": "pct_num100", "type": "esriFieldTypeSmallInteger", "alias": "PCT_NUM100", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_NUM200" }, { "name": "pct_num200", "type": "esriFieldTypeDouble", "alias": "Percent Passing #200 Sieve", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_GRVL" }, { "name": "pct_grvl", "type": "esriFieldTypeDouble", "alias": "Percent Gravel", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_SAND" }, { "name": "pct_sand", "type": "esriFieldTypeDouble", "alias": "Percent Sand", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_SILTCLY" }, { "name": "pctsiltcly", "type": "esriFieldTypeDouble", "alias": "Percent Silt Clay", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCTSHLSAND" }, { "name": "pctshlsand", "type": "esriFieldTypeDouble", "alias": "Percent Shale in Sand", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCTTOTSHL4" }, { "name": "pcttotshl4", "type": "esriFieldTypeDouble", "alias": "Percent Total Shale +4", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCTSAMPSHL" }, { "name": "pctsampshl", "type": "esriFieldTypeDouble", "alias": "Pecent Total Sample Shale", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCTSNDSTN" }, { "name": "pctsndstn", "type": "esriFieldTypeDouble", "alias": "Pecent Sandstone", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCTSPL_ARG" }, { "name": "pctspl_arg", "type": "esriFieldTypeDouble", "alias": "Pecent Spall Argillite", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_CARB" }, { "name": "pct_carb", "type": "esriFieldTypeDouble", "alias": "Percent Carbonate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_IRONOX" }, { "name": "pct_ironox", "type": "esriFieldTypeDouble", "alias": "Percent Iron Oxide", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_OCHRE" }, { "name": "pct_ochre", "type": "esriFieldTypeDouble", "alias": "Percent Ochre", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_UNCHRT" }, { "name": "pct_unchrt", "type": "esriFieldTypeDouble", "alias": "Percent Unsound Chert", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_SCHIST" }, { "name": "pct_schist", "type": "esriFieldTypeDouble", "alias": "Percent Schist", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCTMISCSPL" }, { "name": "pctmiscspl", "type": "esriFieldTypeDouble", "alias": "Percent Misc. Spall", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCT_TS_SPL" }, { "name": "pct_ts_spl", "type": "esriFieldTypeDouble", "alias": "Percent Total Sample Spall", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCTBA_SPL4" }, { "name": "pctba_spl4", "type": "esriFieldTypeDouble", "alias": "Percent BA Spall +4", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCTNSPLARG" }, { "name": "pctnsplarg", "type": "esriFieldTypeDouble", "alias": "Percent NonSpall Argillite", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCTDISROCK" }, { "name": "pctdisrock", "type": "esriFieldTypeDouble", "alias": "Percent Disintegrating Rock", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PCTDISROCK" }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "DOCLINK" }, { "name": "doclink", "type": "esriFieldTypeString", "alias": "Weblink to MnDOT Test", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "DOCLINK" } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "r8114_sde_rowid_uk", "isAscending": true, "isUnique": true, "description": "", "fields": "objectid" }, { "name": "a4295_ix1", "isAscending": true, "isUnique": true, "description": "", "fields": "shape" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Aggregate Resource Mapping Program - Compilation of DNR Test Holes", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "a9c5fa193906424e93226d491da7dce7" }