20170809 14261300 1.0 FALSE LAYER_DATA Borehole_Info_to_Layer_Data Relationship Borehole_Info_to_Layer_Data Relationship 002 20170816 08515600 20170816 08515600 150000000 5000 FGDC FGDC CSDGM Metadata Washington Geological Survey MS 47007 Olympia WA 98504-7007 geology@dnr.wa.gov US 360-902-1450 360-902-1785 Washington Division of Geology and Earth Resources Washington Geological Survey MS 47007 Olympia WA 98504-7007 geology@dnr.wa.gov US 360-902-1450 360-902-1785 Washington Division of Geology and Earth Resources File Geodatabase Table tabular digital data 2017-08-01T00:00:00 Digital Data Series 11 DS-11 Jeschke, D. A.; Eungard, D. W.; Troost, K. G.; Wisher, A. P, 2017, Subsurface database of Washington State - GIS data: Washington Geological Survey Digital Data Series 11, version 2.0, previously released September, 2016 [http://www.dnr.wa.gov/publications/ger_portal_subsurface_database.zip] Washington Geological Survey MS 47007 Olympia WA 98504-7007 geology@dnr.wa.gov US 360-902-1450 360-902-1785 Washington Geological Survey Washington Division of Geology and Earth Resources Layer Data version 2.0 These data are intended to be used by used by geologists, engineers, planners, private-sector geoscientists, and the general public to identify geologic hazards, perform analyses of slope stability, downslope and downstream impacts, storm water management, and identify mitigation opportunities for construction or other land-development projects. Subsurface data is also used in mining, oil and gas exploration, carbon sequestration, and geothermal exploration. <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN><SPAN>These data contain detailed attribution related to point locations for boreholes. An associated feature class provides information concerning the well log or geotechnical report and a hyperlink to connect the user of the data to this document. This tabular data has relationships with borehole records and project reports that provide information concerning the spatial location of, construction details, and project details for boreholes.</SPAN></SPAN></P></DIV></DIV></DIV> Boring log Resource protection Monitoring well WSDOT Washington State Department of Ecology geoscientificInformation USA Class A well Well Subsurface Washington State Department of Transportation Borehole Geotechnical boring Test pit Resource protection well Washington state GeoMapNW ECY Water well Class B well Geotechnical Geotechnical well Boring Subsurface geology transportation Geomap Northwest <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN><SPAN>The Washington Division of Geology and Earth Resources (DGER) shall not be held liable for improper or incorrect use of the data described and/or contained herein. This product is provided 'as is' without warranty of any kind, either expressed or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular use. The Washington State Department of Natural Resources and the authors of this product will not be liable to the user of this product for any activity involving the product with respect to the following: (a) lost profits, lost savings, or any other consequential damages; (b) the fitness of the product for a particular purpose; or (c) use of the product or results obtained from use of the product. Although these data have been processed successfully on computers of DGER, no warranty, expressed or implied, is made by DGER regarding the use of these data on any other system, nor does the fact of distribution constitute or imply any such warranty.</SPAN></SPAN></P><P><SPAN /></P></DIV></DIV></DIV> Jackson, Julia A. (ed.), Mehl, James P., Jr. (ed.), Neuendorf, Klaus K. E. (ed.), 2005, Glossary of Geology; 5th ed.: American Geological Institute, 779 p. 2005-01-01T00:00:00 Boring log, Resource protection, Monitoring well, WSDOT, Washington State Department of Ecology, Class A well, Well, Subsurface, Washington State Department of Transportation, Borehole, Geotechnical boring, Test pit, Resource protection well, GeoMapNW, ECY, Water well, Class B well, Geotechnical, Geotechnical well, Boring, Subsurface geology, Geomap Northwest Washington Geological Survey MS 47007 Olympia WA 98504-7007 geology@dnr.wa.gov US 360-902-1450 360-902-1785 Washington Division of Geology and Earth Resources This digital data and metadata, (hereinafter collectively referred to as the "information"), are provided on an "AS IS", "AS AVAILABLE" and "WITH ALL FAULTS" basis. Neither Department of Natural Resources nor any of its officials and employees makes any warranty of any kind for this information, express or implied, including but not limited to any warranties of merchantability or fitness for a particular purpose, nor shall the distribution of this information constitute any warranty. The information is collected from various sources and will change over time without notice. DNR and its officials and employees assume no responsibility or legal liability for the accuracy, completeness, reliability, timeliness, or usefulness of any of the information provided nor do they represent that the use of any of the information will not infringe privately owned rights. The information is not intended to constitute advice nor is it to be used as a substitute for specific advice from a licensed professional. You should not act (or refrain from acting) based upon the information without independently verifying the information and, as necessary, obtaining professional advice regarding your particular facts and circumstances. References to any specific commercial product, process, and service by trade name, trademark, or manufacturer do not constitute or imply endorsement, recommendation, or favoring by DNR and its officials and employees. IN NO EVENT WILL DNR BE LIABLE TO YOU OR ANY THIRD PARTY FOR ANY DAMAGES ARISING OUT OF THE USE OF OR INABILITY TO USE THE DIGITAL DATA, EVEN IF DNR IS ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Version 6.2 (Build 9200) ; Esri ArcGIS 10.4.1.5686 Publication date 2017-08-01T00:00:00 Attribution is as complete as the associated documentation allows. Where an attribute is not available in the documentation, the field remains blank. The attributes are obtained from the associated well log or geotechnical report. The accuracy of this dataset varies based on the accuracy of the source materials. Frequent cross-checks were performed periodically to ensure consistency between original documents and attributes. Minor formatting changes were made to ensure internal consistency within the dataset. These data were spot checked against the related documents for completeness and accuracy. The depth values reported are taken from the related documents. The accuracy varies based on who recorded this observation. The data included in this attribute table are obtained from a variety of sources which are in different stages of completion. The process steps indicated here assume that the data come from paper copies of geotechnical reports, as this requires all of the steps. Some data sources have been scanned geotechnical reports, and others have had point locations already digitized. In these instances, some of the process steps are not followed as they have already been completed. 1. Scan the geotechnical report and save it to the file system. This file will be made available to the public using an internet hyperlink. 2. Georeference maps in the report that show locations of borings. 3. Digitize the point locations of each boring while noting carefully the horizontal accuracy that can be expected from the particular georeferenced map. 4. Enter all attributes from this feature class that are available in the report. 5. If the elevation of the borehole is not included in the report, it is obtained from lidar (if available), or from DEM (if there is no lidar coverage of the area). Version history: Version 2.0, August 2017 New attribute tables added and schema adjustments made to the tabular data, document, and borehole feature class. Approximately 4,000 boreholes found to be either duplicate, mis-located, or lacking any quality data were removed from the database. Roughly 4,500 additional boreholes added to the database. Version 1.2, September 2016 Approximately 4,000 new geotechnical borings were digitized and added to this dataset. This work was funded by the National Geological and Geophysical Data Preservation Program. Version 1.1, October 2015 Approximately 5,000 new geotechnical borings were digitized and added to this dataset. This work was funded by the National Geological and Geophysical Data Preservation Program. Version 1.0, October 2014 Data digitized by GeoMap Northwest and newly digitized data from the Division of Geology and Earth Resources were combined for this release. A more concise schema than that used by GeoMap Northwest was used to improve the readabilty and usefulness of these data. 2017-06-21T00:00:00 LAYER_DATA Table 390668 Lithologic and geologic information recorded on a borehole log Washington Geological Survey OBJECTID OBJECTID OID 4 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. BOREHOLE_ID BOREHOLE_ID Integer 4 0 0 Identification number for borehole Washington Geological Survey unique identifiers LAYER_NUMBER LAYER_NUMBER SmallInteger 2 0 0 Number indicating a unique lithologic layer increasing by one with each lithology identified on the borehole log. Washington Geological Survey value field TOP_DEPTH_FT TOP_DEPTH_FT Single 4 0 0 Depth in feet below the ground surface (positive down) to the top of the the lithologic layer described. Washington Geological Survey value field BOTTOM_DEPTH_FT BOTTOM_DEPTH_FT Single 4 0 0 Depth in feet below the ground surface (positive down) to the bottom of the the lithologic layer described. Washington Geological Survey value field DESCRIPTION DESCRIPTION String 500 0 0 Textual description of the lithologic layer. Washington Geological Survey textual description LAYER_TYPE LAYER_TYPE String 15 0 0 Field to describe the type of contact between the described layer and its surroundings. Washington Geological Survey Single Single descrete layer with sharp upper and lower contacts Washington Geological Survey Gradational Layer where the upper or lower contact is gradational to the layers surrounding it Washington Geological Survey Interbedded Layer that is a descrete layer or series of layers within a more dominant lithology Washington Geological Survey Unknown The upper or lower contacts of the layer are not known or defined Washington Geological Survey USCS USCS String 20 0 0 A field reporting the Unified Soil Classification System value for the lithology of the layer as identified by the driller or geotechnical firm. Washington Geological Survey textual descriptions SYMBOL_LITHOLOGY SYMBOL_LITHOLOGY String 30 0 0 Field reporting a descrete, simplistic lithology for the layer. Reports only the two most major constituents (where reported) for a layer. Washington Geological Survey Asphalt / concrete A layer primarily consisting of asphalt, concrete, or other similar materials Washington Geological Survey Topsoil / vegetation A layer primarily consisting of topsoil or vegital matter Washington Geological Survey Debris A layer primarily consisting of miscellaneous debris Washington Geological Survey Fill A layer primarily consisting of unengineered or engineered fill Washington Geological Survey Cobbles / boulders A layer primarily consisting of cobble or boulder size (greater than 3 inch diameter) components Washington Geological Survey Gravel A layer primarily consisting of gravel sized components Washington Geological Survey Gravelly sand A layer primarily consisting of sand with a major sub-component of gravel Washington Geological Survey Gravelly silt A layer primarily consisting of silt with a major sub-component of gravel Washington Geological Survey Gravelly clay A layer primarily consisting of clay with a major sub-component of gravel Washington Geological Survey Sand A layer primarily consisting of sand Washington Geological Survey Sandy gravel A layer primarily consisting of gravel with a major sub-component of sand Washington Geological Survey Sandy silt A layer primarily consisting of silt with a major sub-component of gravel Washington Geological Survey Sandy clay A layer primarily consisting of clay with a major sub-component of sand Washington Geological Survey Silt A layer primarily consisting of silt Washington Geological Survey Silty gravel A layer primarily consisting of gravel with a major sub-component of silt Washington Geological Survey Silty sand A layer primarily consisting of sand with a major sub-component of silt Washington Geological Survey Silty clay A layer primarily consisting of clay with a major sub-component of silt Washington Geological Survey Clay A layer primarily consisting of clay components Washington Geological Survey Clayey gravel A layer primarily consisting of gravel with a major sub-component of clay Washington Geological Survey Clayey sand A layer primarily consisting of sand with a major sub-component of clay Washington Geological Survey Clayey silt A layer primarily consisting of silt with a major sub-component of clay Washington Geological Survey Peat A layer primarily consisting of peat, swamp, or bog deposits Washington Geological Survey Volcanic ash A layer primarily consisting of volcanic ash and/or altered ash (clays) Washington Geological Survey Sedimentary bedrock A layer primarily consisting of bedrock whose lithology can be classified as a sedimentary rock type Washington Geological Survey Metamorphic bedrock A layer primarily consisting of bedrock whose lithology can be classified as a metamorphic rock type Washington Geological Survey Plutonic bedrock A layer primarily consisting of bedrock whose lithology can be classified as a igneous plutonic rock type Washington Geological Survey Volcanic bedrock A layer primarily consisting of bedrock whose lithology can be classified as a igneous volcanic rock type Washington Geological Survey Undifferentiated rock A layer primarily consisting of rock of varying type which is not, or uncertain, to be bedrock Washington Geological Survey Undefined A layer primarily consisting of materials which cannot be classified as any standard rock or soil lithology Washington Geological Survey INTERPRETED_LITHOLOGY INTERPRETED_LITHOLOGY String 30 0 0 Lithologic or geologic unit interpreted by the driller or geotechnical firm that produced the borehole. Washington Geological Survey textual description GEOLOGIC_UNIT GEOLOGIC_UNIT String 12 0 0 A geologic unit classified with either the DGER or USGS naming convention standard by geologists working for DGER, USGS, University of Washinton, or other organizations having enough experience to make accurate unit calls in Washington State. Washington Geological Survey textual description GEOLOGIC_UNIT_CONFIDENCE GEOLOGIC_UNIT_CONFIDENCE String 20 0 0 A qualitative confidence given to the "Geologic Unit " by the geologist who made the call. Washington Geological Survey Low Geologic unit call has a low confidence indicating poorly described or complex lithology that is not well understood within a geologic framework Washington Geological Survey Medium Geologic unit call has medium confidence indicating a reasonable understanding of the lithology and how it fits within a geologic framework Washington Geological Survey High Geologic unit call has high confidence indicated a well understood lithology that clearly fits within a geologic framework Washington Geological Survey GEOLOGIST GEOLOGIST String 30 0 0 The name of the geologist, and represented organization who made the geologic unit call on the layer. Washington Geological Survey textual description COMMENTS COMMENTS String 255 0 0 Miscellaneous comments that provide further information about the layer's lithology. Washington Geological Survey textual descriptions dataset 20170816