{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Borehole information", "type": "Feature Layer", "description": "Records in the subsurface database are classified into one of three categories that best characterizes the data contained within the borehole record. The classifications are:Geotechnical: Boreholes and pits created with the intent to gain a detailed understanding of the subsurface lithology and soil or rock properties therein. These records have additional data beyond lithologic descriptions, including penetrometer resistance, shear and strength tests, and density measurements. The additional materials testing allows for a more detailed understanding of subsurface material properties.Lithologic borings: These boreholes are drilled solely for the purpose of identifying subsurface lithology. Unlike geotechnical borings, material testing techniques were not used (or the results are not provided) for lithologic borings.Test pits: Generally shallow excavations with either hand tools or mechanical equipment that are typically less than 20 feet in depth though may expose a greater area or \"working face\" to observe the subsurface lithology. Material testing techniques were not used on these pits, or the results are not provided.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2927, "latestWkid": 2927, "xyTolerance": 2, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "xyUnits": 2048, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 1000000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "BOREHOLE_CLASS", "uniqueValueGroups": [ { "heading": "Borehole class", "classes": [ { "label": "Geotechnical", "description": "Geotechnical", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 96, 161, 61, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "values": [ [ "Geotechnical" ] ] }, { "label": "Lithologic boring", "description": "Lithologic boring", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 96, 47, 161, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "values": [ [ "Lithologic boring" ] ] }, { "label": "Test pit", "description": "Test pit", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 191, 54, 50, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "values": [ [ "Test pit" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 96, 161, 61, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "value": "Geotechnical", "label": "Geotechnical" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 96, 47, 161, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "value": "Lithologic boring", "label": "Lithologic boring" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 191, 54, 50, 255 ], "size": 6, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.5 } }, "value": "Test pit", "label": "Test pit" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 99, 186, 48, 255 ], "toColor": [ 99, 186, 48, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 152, 48, 166, 255 ], "toColor": [ 152, 48, 166, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 40, 42, 255 ], "toColor": [ 189, 40, 42, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 48, 148, 171, 255 ], "toColor": [ 48, 148, 171, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 186, 136, 56, 255 ], "toColor": [ 186, 136, 56, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 201, 71, 119, 255 ], "toColor": [ 201, 71, 119, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 73, 101, 186, 255 ], "toColor": [ 73, 101, 186, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 65, 196, 157, 255 ], "toColor": [ 65, 196, 157, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 34, 36, 161, 255 ], "toColor": [ 34, 36, 161, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 156, 83, 61, 255 ], "toColor": [ 156, 83, 61, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 189, 194, 60, 255 ], "toColor": [ 189, 194, 60, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 48, 156, 79, 255 ], "toColor": [ 48, 156, 79, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 173, 50, 63, 255 ], "toColor": [ 173, 50, 63, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpressionInfo": {"expression": "$feature.BOREHOLE_NAME"}, "lineOrientation": "unconstrained", "labelPlacement": "esriServerLinePlacementAboveAlong", "textLayout": "followFeature", "deconflictionStrategy": "dynamic", "allowOverrun": true, "repeatLabel": false, "lineConnection": "unambiguousLabels", "useClippedGeometry": true, "allowOverlapOfFeatureInterior": "avoid", "stackLabel": true, "stackAlignment": "dynamic", "removeDuplicates": "none", "stackRowLength": 24, "stackSeparators": [], "useCodedValues": true, "maxScale": 0, "minScale": 500000, "name": "Class 1", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Arial", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "defaultVisibility": true, "extent": { "xmin": 687727.732421875, "ymin": 92247.91455078125, "xmax": 2545440.177734375, "ymax": 1351359.1391601562, "spatialReference": { "wkid": 2927, "latestWkid": 2927, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -117498300, "falseY": -98850300, "xyUnits": 2048, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "BOREHOLE_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "BOREHOLE_ID", "type": "esriFieldTypeInteger", "alias": "Borehole ID", "domain": null }, { "name": "DOCUMENT_ID", "type": "esriFieldTypeInteger", "alias": "Document ID", "domain": null }, { "name": "BOREHOLE_NAME", "type": "esriFieldTypeString", "alias": "Borehole Name", "length": 50, "domain": null }, { "name": "BOREHOLE_CLASS", "type": "esriFieldTypeString", "alias": "Borehole Class", "length": 25, "domain": { "type": "codedValue", "name": "Borehole class", "description": "Primary category for the borehole.", "codedValues": [ { "name": "Geotechnical", "code": "Geotechnical" }, { "name": "Water well", "code": "Water well" }, { "name": "Test pit", "code": "Test pit" }, { "name": "Lithologic boring", "code": "Lithologic boring" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BOREHOLE_TYPE", "type": "esriFieldTypeString", "alias": "Borehole Type", "length": 50, "domain": { "type": "codedValue", "name": "Borehole type_1", "description": "Purpose for which the borehole was created.", "codedValues": [ { "name": "Exposure", "code": "Exposure" }, { "name": "Geotechnical", "code": "Geotechnical" }, { "name": "Other", "code": "Other" }, { "name": "Carbon sequestration", "code": "Carbon sequestration" }, { "name": "Cone penetrometer", "code": "Cone penetrometer" }, { "name": "Earthquake monitoring", "code": "Earthquake monitoring" }, { "name": "Mineral exploration", "code": "Mineral exploration" }, { "name": "Monitoring well", "code": "Monitoring well" }, { "name": "Oil and gas", "code": "Oil and gas" }, { "name": "Test pit", "code": "Test pit" }, { "name": "Water well", "code": "Water well" }, { "name": "Boring / probe", "code": "Boring / probe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BOREHOLE_DEPTH_FT", "type": "esriFieldTypeDouble", "alias": "Borehole Depth (ft)", "domain": null }, { "name": "BOREHOLE_DIAMETER_IN", "type": "esriFieldTypeSingle", "alias": "Borehole Diameter (in)", "domain": null }, { "name": "BOREHOLE_DATE", "type": "esriFieldTypeDate", "alias": "Borehole Date", "length": 8, "domain": null }, { "name": "ELEVATION_FT", "type": "esriFieldTypeDouble", "alias": "Elevation (ft)", "domain": null }, { "name": "ELEVATION_METHOD", "type": "esriFieldTypeString", "alias": "Elevation Method", "length": 50, "domain": { "type": "codedValue", "name": "Elevation method", "description": "How the surface elevation for the borehole was determined.", "codedValues": [ { "name": "Altimeter", "code": "Altimeter" }, { "name": "DEM", "code": "DEM" }, { "name": "GPS", "code": "GPS" }, { "name": "LiDAR", "code": "LiDAR" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Report text", "code": "Report text" }, { "name": "Site plan", "code": "Site plan" }, { "name": "Borehole log", "code": "Borehole log" }, { "name": "Not applicable", "code": "Not applicable" }, { "name": "Estimated from topo", "code": "Estimated from topo" }, { "name": "Land survey", "code": "Land survey" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONTRACTOR_NAME", "type": "esriFieldTypeString", "alias": "Contractor Name", "length": 100, "domain": null }, { "name": "BORING_METHOD", "type": "esriFieldTypeString", "alias": "Boring Method", "length": 50, "domain": { "type": "codedValue", "name": "Boring method_1", "description": "Technique used to construct the borehole.", "codedValues": [ { "name": "Coring", "code": "Coring" }, { "name": "Odex", "code": "Odex" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Shallow pit dug by hand or mechanical means", "code": "Shallow pit" }, { "name": "Air rotary", "code": "Air rotary" }, { "name": "Becker hammer", "code": "Becker hammer" }, { "name": "Cable tool", "code": "Cable tool" }, { "name": "Direct push", "code": "Direct push" }, { "name": "Hand auger", "code": "Hand auger" }, { "name": "Hollow stem auger", "code": "Hollow stem auger" }, { "name": "Mud rotary", "code": "Mud rotary" }, { "name": "Sonic core", "code": "Sonic core" }, { "name": "Vactor truck", "code": "Vactor truck" }, { "name": "Wash boring", "code": "Wash boring" }, { "name": "Not applicable", "code": "Not applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCATION_CONFIDENCE", "type": "esriFieldTypeString", "alias": "Location Confidence", "length": 50, "domain": { "type": "codedValue", "name": "Location confidence", "description": "Accuracy of the point location for the borehole.", "codedValues": [ { "name": "Surveyed", "code": "Survey" }, { "name": "Less than 20 feet", "code": "Less than 20 feet" }, { "name": "Between 20 and 100 feet", "code": "Between 20 and 100 feet" }, { "name": "Greater than 100 feet", "code": "Greater than 100 feet" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATA_CONFIDENCE", "type": "esriFieldTypeString", "alias": "Data Confidence", "length": 20, "domain": { "type": "codedValue", "name": "Data confidence", "description": "Estimate on the quality of the the boring log's detail and lithologic accuracy", "codedValues": [ { "name": "High", "code": "High" }, { "name": "Medium high", "code": "Medium high" }, { "name": "Medium", "code": "Medium" }, { "name": "Medium low", "code": "Medium low" }, { "name": "Low", "code": "Low" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNTY_NAME", "type": "esriFieldTypeString", "alias": "County Name", "length": 20, "domain": { "type": "codedValue", "name": "County name", "description": "County in which the borehole was drilled", "codedValues": [ { "name": "Adams", "code": "Adams" }, { "name": "Asotin", "code": "Asotin" }, { "name": "Benton", "code": "Benton" }, { "name": "Chelan", "code": "Chelan" }, { "name": "Clallam", "code": "Clallam" }, { "name": "Clark", "code": "Clark" }, { "name": "Columbia", "code": "Columbia" }, { "name": "Cowlitz", "code": "Cowlitz" }, { "name": "Douglas", "code": "Douglas" }, { "name": "Ferry", "code": "Ferry" }, { "name": "Franklin", "code": "Franklin" }, { "name": "Garfield", "code": "Garfield" }, { "name": "Grant", "code": "Grant" }, { "name": "Grays Harbor", "code": "Grays Harbor" }, { "name": "Island", "code": "Island" }, { "name": "Jefferson", "code": "Jefferson" }, { "name": "King", "code": "King" }, { "name": "Kitsap", "code": "Kitsap" }, { "name": "Kittitas", "code": "Kittitas" }, { "name": "Klickitat", "code": "Klickitat" }, { "name": "Lewis", "code": "Lewis" }, { "name": "Lincoln", "code": "Lincoln" }, { "name": "Mason", "code": "Mason" }, { "name": "Okanogan", "code": "Okanogan" }, { "name": "Pacific", "code": "Pacific" }, { "name": "Pend Oreille", "code": "Pend Oreille" }, { "name": "Pierce", "code": "Pierce" }, { "name": "San Juan", "code": "San Juan" }, { "name": "Skagit", "code": "Skagit" }, { "name": "Skamania", "code": "Skamania" }, { "name": "Snohomish", "code": "Snohomish" }, { "name": "Spokane", "code": "Spokane" }, { "name": "Stevens", "code": "Stevens" }, { "name": "Thurston", "code": "Thurston" }, { "name": "Wahkiakum", "code": "Wahkiakum" }, { "name": "Walla Walla", "code": "Walla Walla" }, { "name": "Whatcom", "code": "Whatcom" }, { "name": "Whitman", "code": "Whitman" }, { "name": "Yakima", "code": "Yakima" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SOURCE_DB_CODE", "type": "esriFieldTypeSmallInteger", "alias": "Source Database Code", "domain": null }, { "name": "SOURCE_DB_ID", "type": "esriFieldTypeString", "alias": "Source Database ID", "length": 50, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "ECYID", "type": "esriFieldTypeInteger", "alias": "Ecology ID", "domain": null }, { "name": "REPORTED_ELEVATION", "type": "esriFieldTypeDouble", "alias": "Reported Elevation (ft)", "domain": null }, { "name": "REPORTED_ELEVATION_METHOD", "type": "esriFieldTypeString", "alias": "Reported Elevation Method", "length": 50, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_SHAPE", "fields": "SHAPE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_102_DOCUMENT_ID", "fields": "DOCUMENT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_102_BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "lithology_logs", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6EAC91F4-D2D1-4F4A-B860-70D574FFD768}" }, { "id": 1, "name": "bedrock", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F9484C85-D169-4DF3-838E-D1983F46D445}" }, { "id": 2, "name": "layer_data", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{AAE36098-5B51-4D42-8255-435BA85F81BF}" }, { "id": 3, "name": "hydrologic", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{90FE31C6-FE90-4E1D-AC79-304F30AF9C75}" }, { "id": 4, "name": "subsurface_documents", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "DOCUMENT_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{3AEB0249-DD02-4997-AAA0-6F7B2AD68DFD}" }, { "id": 5, "name": "in_situ_test_data", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{16E7D5FF-471D-4632-B539-E80846924B8E}" }, { "id": 6, "name": "layer_comments", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8D1BD00E-ADC4-4F67-AB8B-BC0CAEC51E85}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": true, "capabilities": "Map,Query,Data", "maxRecordCount": 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": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "1ab579b14ffa4d9fa2586259293ab23e" }