Borehole information
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>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:</SPAN></P><P><SPAN>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.</SPAN></P><P><SPAN>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.</SPAN></P><P><SPAN>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.</SPAN></P></DIV></DIV></DIV>
nan
[{'nullable': False, 'editable': False, 'defaultValue': None, 'domain': None, 'name': 'objectid', 'alias': 'Object ID', 'type': 'esriFieldTypeOID'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': None, 'name': 'borehole_id', 'alias': 'Borehole ID', 'type': 'esriFieldTypeInteger'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': None, 'name': 'document_id', 'alias': 'Document ID', 'type': 'esriFieldTypeInteger'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': None, 'name': 'borehole_name', 'length': 50, 'alias': 'Borehole Name', 'type': 'esriFieldTypeString'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': {'splitPolicy': 'esriSPTDefaultValue', 'name': 'Borehole class', 'description': 'Primary category for the borehole.', 'type': 'codedValue', 'codedValues': [{'code': 'Geotechnical', 'name': 'Geotechnical'}, {'code': 'Water well', 'name': 'Water well'}, {'code': 'Test pit', 'name': 'Test pit'}, {'code': 'Lithologic boring', 'name': 'Lithologic boring'}], 'mergePolicy': 'esriMPTDefaultValue'}, 'name': 'borehole_class', 'length': 25, 'alias': 'Borehole Class', 'type': 'esriFieldTypeString'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': {'splitPolicy': 'esriSPTDefaultValue', 'name': 'Borehole type_1', 'description': 'Purpose for which the borehole was created.', 'type': 'codedValue', 'codedValues': [{'code': 'Exposure', 'name': 'Exposure'}, {'code': 'Geotechnical', 'name': 'Geotechnical'}, {'code': 'Other', 'name': 'Other'}, {'code': 'Carbon sequestration', 'name': 'Carbon sequestration'}, {'code': 'Cone penetrometer', 'name': 'Cone penetrometer'}, {'code': 'Earthquake monitoring', 'name': 'Earthquake monitoring'}, {'code': 'Mineral exploration', 'name': 'Mineral exploration'}, {'code': 'Monitoring well', 'name': 'Monitoring well'}, {'code': 'Oil and gas', 'name': 'Oil and gas'}, {'code': 'Test pit', 'name': 'Test pit'}, {'code': 'Water well', 'name': 'Water well'}, {'code': 'Boring / probe', 'name': 'Boring / probe'}], 'mergePolicy': 'esriMPTDefaultValue'}, 'name': 'borehole_type', 'length': 50, 'alias': 'Borehole Type', 'type': 'esriFieldTypeString'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': None, 'name': 'borehole_depth_ft', 'alias': 'Borehole Depth (ft)', 'type': 'esriFieldTypeDouble'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': None, 'name': 'borehole_diameter_in', 'alias': 'Borehole Diameter (in)', 'type': 'esriFieldTypeDouble'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': None, 'name': 'borehole_date', 'length': 29, 'alias': 'Borehole Date', 'type': 'esriFieldTypeDate'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': None, 'name': 'elevation_ft', 'alias': 'Elevation (ft)', 'type': 'esriFieldTypeDouble'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': {'splitPolicy': 'esriSPTDefaultValue', 'name': 'Elevation Method', 'description': 'How the surface elevation values for the boreholes were determined.', 'type': 'codedValue', 'codedValues': [{'code': 'Altimeter', 'name': 'Altimeter'}, {'code': 'DEM', 'name': 'DEM'}, {'code': 'GPS', 'name': 'GPS'}, {'code': 'LiDAR', 'name': 'LiDAR'}, {'code': 'Unknown', 'name': 'Unknown'}, {'code': 'Estimated from Topo', 'name': 'Estimated from topo'}, {'code': 'Land Survey', 'name': 'Land survey'}, {'code': 'Report Text', 'name': 'Report text'}, {'code': 'Site Plan', 'name': 'Site plan'}, {'code': 'Well Log', 'name': 'Well log'}, {'code': 'Not Applicable', 'name': 'Not applicable'}], 'mergePolicy': 'esriMPTDefaultValue'}, 'name': 'elevation_method', 'length': 50, 'alias': 'Elevation Method', 'type': 'esriFieldTypeString'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': None, 'name': 'contractor_name', 'length': 100, 'alias': 'Contractor Name', 'type': 'esriFieldTypeString'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': {'splitPolicy': 'esriSPTDefaultValue', 'name': 'Boring method_1', 'description': 'Technique used to construct the borehole.', 'type': 'codedValue', 'codedValues': [{'code': 'Coring', 'name': 'Coring'}, {'code': 'Odex', 'name': 'Odex'}, {'code': 'Unknown', 'name': 'Unknown'}, {'code': 'Shallow pit', 'name': 'Shallow pit dug by hand or mechanical means'}, {'code': 'Air rotary', 'name': 'Air rotary'}, {'code': 'Becker hammer', 'name': 'Becker hammer'}, {'code': 'Cable tool', 'name': 'Cable tool'}, {'code': 'Direct push', 'name': 'Direct push'}, {'code': 'Hand auger', 'name': 'Hand auger'}, {'code': 'Hollow stem auger', 'name': 'Hollow stem auger'}, {'code': 'Mud rotary', 'name': 'Mud rotary'}, {'code': 'Sonic core', 'name': 'Sonic core'}, {'code': 'Vactor truck', 'name': 'Vactor truck'}, {'code': 'Wash boring', 'name': 'Wash boring'}, {'code': 'Not applicable', 'name': 'Not applicable'}], 'mergePolicy': 'esriMPTDefaultValue'}, 'name': 'boring_method', 'length': 50, 'alias': 'Boring Method', 'type': 'esriFieldTypeString'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': {'splitPolicy': 'esriSPTDefaultValue', 'name': 'Location Confidence', 'description': 'Accuracy of the point location for the borehole.', 'type': 'codedValue', 'codedValues': [{'code': 'Survey', 'name': 'Surveyed'}, {'code': 'High', 'name': 'Less than 20 feet'}, {'code': 'Medium', 'name': 'Between 20 and 100 feet'}, {'code': 'Low', 'name': 'Greater than 100 feet'}], 'mergePolicy': 'esriMPTDefaultValue'}, 'name': 'location_confidence', 'length': 50, 'alias': 'Location Confidence', 'type': 'esriFieldTypeString'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': {'splitPolicy': 'esriSPTDefaultValue', 'name': 'Data Confidence', 'description': 'Usefuleness of the information on the well log.', 'type': 'codedValue', 'codedValues': [{'code': 'High', 'name': 'High'}, {'code': 'Medium', 'name': 'Medium'}, {'code': 'Low', 'name': 'Low'}, {'code': 'Not applicable', 'name': 'Not applicable'}, {'code': 'Medium high', 'name': 'Medium high'}, {'code': 'Medium low', 'name': 'Medium low'}], 'mergePolicy': 'esriMPTDefaultValue'}, 'name': 'data_confidence', 'length': 20, 'alias': 'Data Confidence', 'type': 'esriFieldTypeString'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': {'splitPolicy': 'esriSPTDefaultValue', 'name': 'County name', 'description': 'County in which the borehole was drilled', 'type': 'codedValue', 'codedValues': [{'code': 'Adams', 'name': 'Adams'}, {'code': 'Asotin', 'name': 'Asotin'}, {'code': 'Benton', 'name': 'Benton'}, {'code': 'Chelan', 'name': 'Chelan'}, {'code': 'Clallam', 'name': 'Clallam'}, {'code': 'Clark', 'name': 'Clark'}, {'code': 'Columbia', 'name': 'Columbia'}, {'code': 'Cowlitz', 'name': 'Cowlitz'}, {'code': 'Douglas', 'name': 'Douglas'}, {'code': 'Ferry', 'name': 'Ferry'}, {'code': 'Franklin', 'name': 'Franklin'}, {'code': 'Garfield', 'name': 'Garfield'}, {'code': 'Grant', 'name': 'Grant'}, {'code': 'Grays Harbor', 'name': 'Grays Harbor'}, {'code': 'Island', 'name': 'Island'}, {'code': 'Jefferson', 'name': 'Jefferson'}, {'code': 'King', 'name': 'King'}, {'code': 'Kitsap', 'name': 'Kitsap'}, {'code': 'Kittitas', 'name': 'Kittitas'}, {'code': 'Klickitat', 'name': 'Klickitat'}, {'code': 'Lewis', 'name': 'Lewis'}, {'code': 'Lincoln', 'name': 'Lincoln'}, {'code': 'Mason', 'name': 'Mason'}, {'code': 'Okanogan', 'name': 'Okanogan'}, {'code': 'Pacific', 'name': 'Pacific'}, {'code': 'Pend Oreille', 'name': 'Pend Oreille'}, {'code': 'Pierce', 'name': 'Pierce'}, {'code': 'San Juan', 'name': 'San Juan'}, {'code': 'Skagit', 'name': 'Skagit'}, {'code': 'Skamania', 'name': 'Skamania'}, {'code': 'Snohomish', 'name': 'Snohomish'}, {'code': 'Spokane', 'name': 'Spokane'}, {'code': 'Stevens', 'name': 'Stevens'}, {'code': 'Thurston', 'name': 'Thurston'}, {'code': 'Wahkiakum', 'name': 'Wahkiakum'}, {'code': 'Walla Walla', 'name': 'Walla Walla'}, {'code': 'Whatcom', 'name': 'Whatcom'}, {'code': 'Whitman', 'name': 'Whitman'}, {'code': 'Yakima', 'name': 'Yakima'}], 'mergePolicy': 'esriMPTDefaultValue'}, 'name': 'county_name', 'length': 20, 'alias': 'County Name', 'type': 'esriFieldTypeString'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': None, 'name': 'source_db_code', 'alias': 'Source Database Code', 'type': 'esriFieldTypeSmallInteger'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': None, 'name': 'source_db_id', 'length': 50, 'alias': 'Source Database ID', 'type': 'esriFieldTypeString'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': None, 'name': 'comments', 'length': 255, 'alias': 'Comments', 'type': 'esriFieldTypeString'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': None, 'name': 'ecyid', 'alias': 'Ecology ID', 'type': 'esriFieldTypeInteger'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': None, 'name': 'reported_elevation', 'alias': 'Reported Elevation (ft)', 'type': 'esriFieldTypeDouble'}, {'nullable': True, 'editable': True, 'defaultValue': None, 'domain': None, 'name': 'reported_elevation_method', 'length': 50, 'alias': 'Reported Elevation Method', 'type': 'esriFieldTypeString'}, {'nullable': False, 'editable': False, 'defaultValue': None, 'domain': None, 'name': 'globalid', 'length': 38, 'alias': 'GlobalID', 'type': 'esriFieldTypeGlobalID'}]
[{'name': 'g342borehole_id', 'isUnique': False, 'description': '', 'fields': 'BOREHOLE_ID', 'isAscending': True}, {'name': 'g342document_id', 'isUnique': False, 'description': '', 'fields': 'DOCUMENT_ID', 'isAscending': True}, {'name': 'r178_sde_rowid_uk', 'isUnique': True, 'description': '', 'fields': 'OBJECTID', 'isAscending': True}, {'name': 'a66_ix1', 'isUnique': True, 'description': '', 'fields': 'SHAPE', 'isAscending': True}]
nan
{'renderer': {'field1': 'borehole_class', 'authoringInfo': {'colorRamp': {'colorRamps': [{'toColor': [69, 163, 42, 255], 'fromColor': [69, 163, 42, 255], 'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm'}, {'toColor': [133, 60, 189, 255], 'fromColor': [133, 60, 189, 255], 'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm'}, {'toColor': [196, 43, 48, 255], 'fromColor': [196, 43, 48, 255], 'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm'}, {'toColor': [44, 141, 168, 255], 'fromColor': [44, 141, 168, 255], 'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm'}, {'toColor': [196, 162, 69, 255], 'fromColor': [196, 162, 69, 255], 'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm'}, {'toColor': [161, 64, 108, 255], 'fromColor': [161, 64, 108, 255], 'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm'}, {'toColor': [73, 191, 150, 255], 'fromColor': [73, 191, 150, 255], 'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm'}, {'toColor': [77, 109, 191, 255], 'fromColor': [77, 109, 191, 255], 'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm'}, {'toColor': [161, 95, 64, 255], 'fromColor': [161, 95, 64, 255], 'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm'}, {'toColor': [199, 68, 175, 255], 'fromColor': [199, 68, 175, 255], 'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm'}, {'toColor': [191, 201, 44, 255], 'fromColor': [191, 201, 44, 255], 'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm'}, {'toColor': [53, 47, 153, 255], 'fromColor': [53, 47, 153, 255], 'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm'}, {'toColor': [43, 191, 194, 255], 'fromColor': [43, 191, 194, 255], 'type': 'algorithmic', 'algorithm': 'esriCIELabAlgorithm'}], 'type': 'multipart'}}, 'uniqueValueInfos': [{'symbol': {'outline': {'color': [0, 0, 0, 255], 'width': 0.5}, 'color': [96, 161, 61, 255], 'size': 6, 'yoffset': 0, 'xoffset': 0, 'angle': 0, 'style': 'esriSMSCircle', 'type': 'esriSMS'}, 'label': 'Geotechnical', 'value': 'Geotechnical'}, {'symbol': {'outline': {'color': [0, 0, 0, 255], 'width': 0.5}, 'color': [96, 47, 161, 255], 'size': 6, 'yoffset': 0, 'xoffset': 0, 'angle': 0, 'style': 'esriSMSCircle', 'type': 'esriSMS'}, 'label': 'Lithologic boring', 'value': 'Lithologic boring'}, {'symbol': {'outline': {'color': [0, 0, 0, 255], 'width': 0.5}, 'color': [191, 54, 50, 255], 'size': 6, 'yoffset': 0, 'xoffset': 0, 'angle': 0, 'style': 'esriSMSCircle', 'type': 'esriSMS'}, 'label': 'Test pit', 'value': 'Test pit'}], 'type': 'uniqueValue', 'fieldDelimiter': ','}, 'scaleSymbols': True, 'transparency': 0, 'labelingInfo': [{'symbol': {'backgroundColor': None, 'kerning': True, 'color': [0, 0, 0, 255], 'yoffset': 0, 'xoffset': 0, 'haloColor': None, 'type': 'esriTS', 'borderLineColor': None, 'borderLineSize': None, 'horizontalAlignment': 'left', 'haloSize': None, 'angle': 0, 'rightToLeft': False, 'verticalAlignment': 'bottom', 'font': {'size': 10, 'weight': 'normal', 'style': 'normal', 'family': 'Arial', 'decoration': 'none'}}, 'stackLabel': True, 'stackRowLength': 24, 'maxScale': 0, 'allowOverrun': True, 'lineConnection': 'unambiguousLabels', 'allowOverlapOfFeatureInterior': 'avoid', 'labelExpressionInfo': {'expression': '$feature.BOREHOLE_NAME'}, 'deconflictionStrategy': 'dynamic', 'priority': -1, 'labelPlacement': 'esriServerLinePlacementAboveAlong', 'removeDuplicates': 'none', 'textLayout': 'straight', 'stackSeparators': [], 'name': 'Class 1', 'repeatLabel': False, 'minScale': 500000, 'stackAlignment': 'dynamic', 'useCodedValues': True}]}
[{'templates': [{'name': 'Geotechnical', 'description': '', 'drawingTool': 'esriFeatureEditToolPoint', 'prototype': {'attributes': {'borehole_type': None, 'comments': None, 'data_confidence': None, 'elevation_ft': None, 'ecyid': None, 'source_db_code': None, 'borehole_diameter_in': None, 'document_id': None, 'county_name': None, 'reported_elevation': None, 'source_db_id': None, 'contractor_name': None, 'borehole_name': None, 'elevation_method': None, 'location_confidence': None, 'borehole_date': None, 'reported_elevation_method': None, 'borehole_class': 'Geotechnical', 'borehole_id': None, 'borehole_depth_ft': None, 'boring_method': None}}}], 'name': 'Geotechnical', 'domains': {'borehole_type': {'type': 'inherited'}, 'elevation_method': {'type': 'inherited'}, 'data_confidence': {'type': 'inherited'}, 'location_confidence': {'type': 'inherited'}, 'borehole_class': {'type': 'inherited'}, 'county_name': {'type': 'inherited'}, 'boring_method': {'type': 'inherited'}}, 'id': 'Geotechnical'}, {'templates': [{'name': 'Lithologic boring', 'description': '', 'drawingTool': 'esriFeatureEditToolPoint', 'prototype': {'attributes': {'borehole_type': None, 'comments': None, 'data_confidence': None, 'elevation_ft': None, 'ecyid': None, 'source_db_code': None, 'borehole_diameter_in': None, 'document_id': None, 'county_name': None, 'reported_elevation': None, 'source_db_id': None, 'contractor_name': None, 'borehole_name': None, 'elevation_method': None, 'location_confidence': None, 'borehole_date': None, 'reported_elevation_method': None, 'borehole_class': 'Lithologic boring', 'borehole_id': None, 'borehole_depth_ft': None, 'boring_method': None}}}], 'name': 'Lithologic boring', 'domains': {'borehole_type': {'type': 'inherited'}, 'elevation_method': {'type': 'inherited'}, 'data_confidence': {'type': 'inherited'}, 'location_confidence': {'type': 'inherited'}, 'borehole_class': {'type': 'inherited'}, 'county_name': {'type': 'inherited'}, 'boring_method': {'type': 'inherited'}}, 'id': 'Lithologic boring'}, {'templates': [{'name': 'Test pit', 'description': '', 'drawingTool': 'esriFeatureEditToolPoint', 'prototype': {'attributes': {'borehole_type': None, 'comments': None, 'data_confidence': None, 'elevation_ft': None, 'ecyid': None, 'source_db_code': None, 'borehole_diameter_in': None, 'document_id': None, 'county_name': None, 'reported_elevation': None, 'source_db_id': None, 'contractor_name': None, 'borehole_name': None, 'elevation_method': None, 'location_confidence': None, 'borehole_date': None, 'reported_elevation_method': None, 'borehole_class': 'Test pit', 'borehole_id': None, 'borehole_depth_ft': None, 'boring_method': None}}}], 'name': 'Test pit', 'domains': {'borehole_type': {'type': 'inherited'}, 'elevation_method': {'type': 'inherited'}, 'data_confidence': {'type': 'inherited'}, 'location_confidence': {'type': 'inherited'}, 'borehole_class': {'type': 'inherited'}, 'county_name': {'type': 'inherited'}, 'boring_method': {'type': 'inherited'}}, 'id': 'Test pit'}]
[]