{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Lithologic Borings", "type": "Feature Layer", "description": "These data contain point locations of boreholes in Washington State along with detailed attribution concerning each. An associated table provides information concerning the well log or geotechnical report and a hyperlink to connect the user of the data to this document. Some of the boreholes have relationships with additional tables that provide information concerning geologic layers the borehole passes through, the depth to groundwater, or other information.", "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": "Washington Division of Geology and Earth Resources", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 230, 230, 0, 255 ], "size": 4.5, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 79, 79, 79, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "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": "OBJECTID", "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": "LATITUDE", "type": "esriFieldTypeDouble", "alias": "LATITUDE", "domain": null }, { "name": "LONGITUDE", "type": "esriFieldTypeDouble", "alias": "LONGITUDE", "domain": null }, { "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_DB_CODE", "domain": null }, { "name": "SOURCE_DB_ID", "type": "esriFieldTypeString", "alias": "SOURCE_DB_ID", "length": 50, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "ECYID", "type": "esriFieldTypeInteger", "alias": "ECYID", "domain": null }, { "name": "REPORTED_ELEVATION", "type": "esriFieldTypeDouble", "alias": "REPORTED_ELEVATION", "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": "Documents", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "DOCUMENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A72D775D-082A-4F3B-80F9-AF1A568F95C8}" }, { "id": 1, "name": "Hydrologic", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4D6191E8-9B21-47B2-96E2-A3310DF2A4FA}" }, { "id": 2, "name": "Bedrock", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{AAEF8D07-9B00-4D87-8BC7-7F7C428F47BA}" }, { "id": 3, "name": "Layer Data", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{989D3C0F-B219-4E24-BD95-7BCB5C9F7453}" }, { "id": 4, "name": "Layer Comments", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F1B84C0F-2DDF-4A86-B968-6C59D29D66A3}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "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": "5435859311db483783f0a6fc4ee84b1c" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Geotechnical Borings", "type": "Feature Layer", "description": "These data contain point locations of boreholes in Washington State along with detailed attribution concerning each. An associated table provides information concerning the well log or geotechnical report and a hyperlink to connect the user of the data to this document. Some of the boreholes have relationships with additional tables that provide information concerning geologic layers the borehole passes through, the depth to groundwater, or other information.", "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": "Washington Division of Geology and Earth Resources", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 166, 128, 255, 255 ], "size": 4.5, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 128, 0, 255, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "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": "OBJECTID", "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": "LATITUDE", "type": "esriFieldTypeDouble", "alias": "LATITUDE", "domain": null }, { "name": "LONGITUDE", "type": "esriFieldTypeDouble", "alias": "LONGITUDE", "domain": null }, { "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_DB_CODE", "domain": null }, { "name": "SOURCE_DB_ID", "type": "esriFieldTypeString", "alias": "SOURCE_DB_ID", "length": 50, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "ECYID", "type": "esriFieldTypeInteger", "alias": "ECYID", "domain": null }, { "name": "REPORTED_ELEVATION", "type": "esriFieldTypeDouble", "alias": "REPORTED_ELEVATION", "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": 5, "name": "Documents", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "DOCUMENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A72D775D-082A-4F3B-80F9-AF1A568F95C8}" }, { "id": 6, "name": "Hydrologic", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4D6191E8-9B21-47B2-96E2-A3310DF2A4FA}" }, { "id": 7, "name": "Bedrock", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{AAEF8D07-9B00-4D87-8BC7-7F7C428F47BA}" }, { "id": 8, "name": "Layer Data", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{989D3C0F-B219-4E24-BD95-7BCB5C9F7453}" }, { "id": 9, "name": "Layer Comments", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F1B84C0F-2DDF-4A86-B968-6C59D29D66A3}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "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": "5435859311db483783f0a6fc4ee84b1c" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Water Wells", "type": "Feature Layer", "description": "These data contain point locations of boreholes in Washington State along with detailed attribution concerning each. An associated table provides information concerning the well log or geotechnical report and a hyperlink to connect the user of the data to this document. Some of the boreholes have relationships with additional tables that provide information concerning geologic layers the borehole passes through, the depth to groundwater, or other information.", "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": "Washington Division of Geology and Earth Resources", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 102, 205, 171, 255 ], "size": 4.5, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 115, 77, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "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": "OBJECTID", "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": "LATITUDE", "type": "esriFieldTypeDouble", "alias": "LATITUDE", "domain": null }, { "name": "LONGITUDE", "type": "esriFieldTypeDouble", "alias": "LONGITUDE", "domain": null }, { "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_DB_CODE", "domain": null }, { "name": "SOURCE_DB_ID", "type": "esriFieldTypeString", "alias": "SOURCE_DB_ID", "length": 50, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "ECYID", "type": "esriFieldTypeInteger", "alias": "ECYID", "domain": null }, { "name": "REPORTED_ELEVATION", "type": "esriFieldTypeDouble", "alias": "REPORTED_ELEVATION", "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": 10, "name": "Documents", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "DOCUMENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A72D775D-082A-4F3B-80F9-AF1A568F95C8}" }, { "id": 11, "name": "Hydrologic", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4D6191E8-9B21-47B2-96E2-A3310DF2A4FA}" }, { "id": 12, "name": "Bedrock", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{AAEF8D07-9B00-4D87-8BC7-7F7C428F47BA}" }, { "id": 13, "name": "Layer Data", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{989D3C0F-B219-4E24-BD95-7BCB5C9F7453}" }, { "id": 14, "name": "Layer Comments", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F1B84C0F-2DDF-4A86-B968-6C59D29D66A3}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "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": "5435859311db483783f0a6fc4ee84b1c" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "documents", "type": "Feature Layer", "description": "

This dataset contains attribute information about geotechnical reports, boring logs, and other documentation concerning boreholes in Washington State. This table is connected to the boreholes feature class by a relationship class. Each record in this table documents one or more boreholes. Hyperlinks are provided to the documents allowing a user to open the scanned document. These data build upon the work of Kathy Troost and Aaron Wisher of the Pacific Northwest Center for Geologic Mapping Studies (GeoMapNW). Their database of ~80,000 boreholes in the central Puget Sound region are included here. As time and funding allow, the Washington Division of Geology and Earth Resources is adding to these data.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "geometryType": "esriGeometryPolygon", "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": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 189, 189, 252, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 467332.087890625, "ymin": 65497.841796875, "xmax": 2545460.177734375, "ymax": 1351379.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": "DOCUMENT_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "DOCUMENT_ID", "type": "esriFieldTypeInteger", "alias": "DOCUMENT_ID", "domain": null }, { "name": "DOCUMENT_AUTHOR", "type": "esriFieldTypeString", "alias": "DOCUMENT AUTHOR", "length": 100, "domain": null }, { "name": "DOCUMENT_SOURCE", "type": "esriFieldTypeString", "alias": "DOCUMENT_SOURCE", "length": 100, "domain": null }, { "name": "DOCUMENT_TYPE", "type": "esriFieldTypeString", "alias": "DOCUMENT_TYPE", "length": 20, "domain": { "type": "codedValue", "name": "Document type", "description": "The type of scanned document that the record is linked to.", "codedValues": [ { "name": "Report", "code": "Report" }, { "name": "Other", "code": "Other" }, { "name": "Boring log", "code": "Boring log" }, { "name": "Field notes", "code": "Field notes" }, { "name": "Geologic map", "code": "Geologic Map" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DOCUMENT_TITLE", "type": "esriFieldTypeString", "alias": "DOCUMENT_TITLE", "length": 255, "domain": null }, { "name": "DOCUMENT_DATE", "type": "esriFieldTypeDate", "alias": "DOCUMENT_DATE", "length": 8, "domain": null }, { "name": "PROJECT_TYPE", "type": "esriFieldTypeString", "alias": "PROJECT_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "Project type", "description": "Primary subsequent use of land or design intent.", "codedValues": [ { "name": "Transportation - non-roadway", "code": "Transportation - non-roadway" }, { "name": "Residential", "code": "Residential" }, { "name": "Retail / commercial building", "code": "Retail / commercial building" }, { "name": "Automotive / fueling depot", "code": "Automotive / fueling depot" }, { "name": "Water well", "code": "Water well" }, { "name": "Industrial", "code": "Industrial" }, { "name": "Landfill", "code": "Landfill" }, { "name": "Landslide", "code": "Landslide" }, { "name": "Dry cleaner / laundry", "code": "Dry cleaner / laundry" }, { "name": "Military", "code": "Military" }, { "name": "Mine", "code": "Mine" }, { "name": "Park / recreation", "code": "Park / recreation" }, { "name": "Railroad", "code": "Railroad" }, { "name": "Retaining wall", "code": "Retaining wall" }, { "name": "Roadway", "code": "Roadway" }, { "name": "Utility", "code": "Utility" }, { "name": "Tunnel", "code": "Tunnel" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Bridge", "code": "Bridge" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PROJECT_ADDRESS", "type": "esriFieldTypeString", "alias": "PROJECT_ADDRESS", "length": 100, "domain": null }, { "name": "BOREHOLE_COUNT", "type": "esriFieldTypeSmallInteger", "alias": "BOREHOLE_COUNT", "domain": null }, { "name": "DOCUMENT_LINK", "type": "esriFieldTypeString", "alias": "DOCUMENT_LINK", "length": 255, "domain": null }, { "name": "GEOPROFILE_FLAG", "type": "esriFieldTypeString", "alias": "GEOPROFILE_FLAG", "length": 5, "domain": { "type": "codedValue", "name": "Flag field", "description": "Identifies if the item of interest exists in the data entry.", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SLOPE_STABILITY_FLAG", "type": "esriFieldTypeString", "alias": "SLOPE_STABILITY_FLAG", "length": 5, "domain": { "type": "codedValue", "name": "Flag field", "description": "Identifies if the item of interest exists in the data entry.", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "Shape_Length", "type": "esriFieldTypeDouble", "alias": "Shape_Length", "domain": null }, { "name": "Shape_Area", "type": "esriFieldTypeDouble", "alias": "Shape_Area", "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": "DOCUMENT_ID", "fields": "DOCUMENT_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Borehole Info", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "DOCUMENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A72D775D-082A-4F3B-80F9-AF1A568F95C8}" }, { "id": 5, "name": "Borehole Info", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "DOCUMENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A72D775D-082A-4F3B-80F9-AF1A568F95C8}" }, { "id": 10, "name": "Borehole Info", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "DOCUMENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A72D775D-082A-4F3B-80F9-AF1A568F95C8}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "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, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape_Area", "shapeLengthFieldName": "Shape_Length", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "5435859311db483783f0a6fc4ee84b1c" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "Subsurface database bedrock table", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BOREHOLE_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "BOREHOLE_ID", "type": "esriFieldTypeInteger", "alias": "BOREHOLE_ID", "domain": null }, { "name": "DEPTH_TO_BEDROCK_FT", "type": "esriFieldTypeSingle", "alias": "DEPTH_TO_BEDROCK_FT", "domain": null }, { "name": "BEDROCK_TYPE", "type": "esriFieldTypeString", "alias": "BEDROCK_TYPE", "length": 30, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_59_BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Borehole Info", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{AAEF8D07-9B00-4D87-8BC7-7F7C428F47BA}" }, { "id": 7, "name": "Borehole Info", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{AAEF8D07-9B00-4D87-8BC7-7F7C428F47BA}" }, { "id": 12, "name": "Borehole Info", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{AAEF8D07-9B00-4D87-8BC7-7F7C428F47BA}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "5435859311db483783f0a6fc4ee84b1c" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Subsurface database hydrologic data", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BOREHOLE_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "BOREHOLE_ID", "type": "esriFieldTypeInteger", "alias": "BOREHOLE_ID", "domain": null }, { "name": "DEPTH_TO_WATER_FT", "type": "esriFieldTypeDouble", "alias": "DEPTH_TO_WATER_FT", "domain": null }, { "name": "ARTESIAN_PRESSURE_PSI", "type": "esriFieldTypeSingle", "alias": "ARTESIAN_PRESSURE_PSI", "domain": null }, { "name": "DRAWDOWN_YIELD_GPM", "type": "esriFieldTypeSingle", "alias": "DRAWDOWN_YIELD", "domain": null }, { "name": "DRAWDOWN_DISTANCE_FT", "type": "esriFieldTypeSingle", "alias": "DROWDOWN_DISTANCE_FT", "domain": null }, { "name": "AIRTEST_STEM_FT", "type": "esriFieldTypeSingle", "alias": "AIRTEST_STEM_FT", "domain": null }, { "name": "DRAWDOWN_TIME_HOURS", "type": "esriFieldTypeSingle", "alias": "DRAWDOWN_TIME_HOURS", "domain": null }, { "name": "TEST_DATE", "type": "esriFieldTypeDate", "alias": "TEST_DATE", "length": 8, "domain": null }, { "name": "WATER_TEMPERATURE_C", "type": "esriFieldTypeSingle", "alias": "WATER_TEMPERATURE_C", "domain": null }, { "name": "CHEMICAL_TEST_FLAG", "type": "esriFieldTypeString", "alias": "CHEMICAL_TEST_FLAG", "length": 5, "domain": { "type": "codedValue", "name": "Flag field", "description": "Identifies if the item of interest exists in the data entry.", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_62_BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Borehole Info", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4D6191E8-9B21-47B2-96E2-A3310DF2A4FA}" }, { "id": 6, "name": "Borehole Info", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4D6191E8-9B21-47B2-96E2-A3310DF2A4FA}" }, { "id": 11, "name": "Borehole Info", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4D6191E8-9B21-47B2-96E2-A3310DF2A4FA}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "5435859311db483783f0a6fc4ee84b1c" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "Subsurface database layer comments", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BOREHOLE_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "BOREHOLE_ID", "type": "esriFieldTypeInteger", "alias": "BOREHOLE_ID", "domain": null }, { "name": "COMMENT_NUMBER", "type": "esriFieldTypeSmallInteger", "alias": "COMMENT_NUMBER", "domain": null }, { "name": "COMMENT_DEPTH_FT", "type": "esriFieldTypeSingle", "alias": "COMMENT_DEPTH_FT", "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 400, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_64_BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Borehole Info", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F1B84C0F-2DDF-4A86-B968-6C59D29D66A3}" }, { "id": 9, "name": "Borehole Info", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F1B84C0F-2DDF-4A86-B968-6C59D29D66A3}" }, { "id": 14, "name": "Borehole Info", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F1B84C0F-2DDF-4A86-B968-6C59D29D66A3}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "5435859311db483783f0a6fc4ee84b1c" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "Layer Data", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "BOREHOLE_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "BOREHOLE_ID", "type": "esriFieldTypeInteger", "alias": "BOREHOLE_ID", "domain": null }, { "name": "LAYER_NUMBER", "type": "esriFieldTypeSmallInteger", "alias": "LAYER_NUMBER", "domain": null }, { "name": "TOP_DEPTH_FT", "type": "esriFieldTypeSingle", "alias": "TOP_DEPTH_FT", "domain": null }, { "name": "BOTTOM_DEPTH_FT", "type": "esriFieldTypeSingle", "alias": "BOTTOM_DEPTH_FT", "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 500, "domain": null }, { "name": "LAYER_TYPE", "type": "esriFieldTypeString", "alias": "LAYER_TYPE", "length": 15, "domain": { "type": "codedValue", "name": "Layer type", "description": "Nature of the contact with the described layer and it's surroundings.", "codedValues": [ { "name": "Single", "code": "Single" }, { "name": "Gradational", "code": "Gradational" }, { "name": "Interbedded", "code": "Interbedded" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "USCS", "type": "esriFieldTypeString", "alias": "USCS", "length": 20, "domain": null }, { "name": "SYMBOL_LITHOLOGY", "type": "esriFieldTypeString", "alias": "SYMBOL_LITHOLOGY", "length": 30, "domain": { "type": "codedValue", "name": "Symbol lithology", "description": "General classification of the layer's lithology.", "codedValues": [ { "name": "Asphalt / concrete", "code": "Asphalt / concrete" }, { "name": "Topsoil / vegetation", "code": "Topsoil / vegetation" }, { "name": "Debris", "code": "Debris" }, { "name": "Fill", "code": "Fill" }, { "name": "Gravel", "code": "Gravel" }, { "name": "Gravelly sand", "code": "Gravelly sand" }, { "name": "Gravelly silt", "code": "Gravelly silt" }, { "name": "Gravelly clay", "code": "Gravelly clay" }, { "name": "Sand", "code": "Sand" }, { "name": "Sandy gravel", "code": "Sandy gravel" }, { "name": "Sandy silt", "code": "Sandy silt" }, { "name": "Sandy clay", "code": "Sandy clay" }, { "name": "Silt", "code": "Silt" }, { "name": "Silty gravel", "code": "Silty gravel" }, { "name": "Silty sand", "code": "Silty sand" }, { "name": "Silty clay", "code": "Silty clay" }, { "name": "Clay", "code": "Clay" }, { "name": "Clayey gravel", "code": "Clayey gravel" }, { "name": "Clayey sand", "code": "Clayey sand" }, { "name": "Clayey silt", "code": "Clayey silt" }, { "name": "Peat", "code": "Peat" }, { "name": "Volcanic ash", "code": "Volcanic ash" }, { "name": "Sedimentary bedrock", "code": "Sedimentary bedrock" }, { "name": "Metamophic bedrock", "code": "Metamophic bedrock" }, { "name": "Plutonic bedrock", "code": "Plutonic bedrock" }, { "name": "Volcanic bedrock", "code": "Volcanic bedrock" }, { "name": "Cobbles / boulders", "code": "Cobbles / boulders" }, { "name": "Undifferentiated rock", "code": "Undifferentiated rock" }, { "name": "Undefined", "code": "Undefined" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INTERPRETED_LITHOLOGY", "type": "esriFieldTypeString", "alias": "INTERPRETED_LITHOLOGY", "length": 30, "domain": null }, { "name": "GEOLOGIC_UNIT", "type": "esriFieldTypeString", "alias": "GEOLOGIC_UNIT", "length": 12, "domain": null }, { "name": "GEOLOGIC_UNIT_CONFIDENCE", "type": "esriFieldTypeString", "alias": "GEOLOGIC_UNIT_CONFIDENCE", "length": 20, "domain": { "type": "codedValue", "name": "Geologic unit confidence", "description": "Certainty estimate for the selected geologic unit and contact depth.", "codedValues": [ { "name": "Low", "code": "Low" }, { "name": "Medium", "code": "Medium" }, { "name": "High", "code": "High" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GEOLOGIST", "type": "esriFieldTypeString", "alias": "GEOLOGIST", "length": 30, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "Start_Depth", "type": "esriFieldTypeDouble", "alias": "Start_Depth", "domain": null }, { "name": "End_Depth", "type": "esriFieldTypeDouble", "alias": "End_Depth", "domain": null }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_109_BOREHOLE_ID", "fields": "BOREHOLE_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Borehole Info", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{989D3C0F-B219-4E24-BD95-7BCB5C9F7453}" }, { "id": 8, "name": "Borehole Info", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{989D3C0F-B219-4E24-BD95-7BCB5C9F7453}" }, { "id": 13, "name": "Borehole Info", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "BOREHOLE_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{989D3C0F-B219-4E24-BD95-7BCB5C9F7453}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "5435859311db483783f0a6fc4ee84b1c" } ] }