DATA STRUCTURE, WORKFLOW, AND DISPLAY OF SUBSURFACE DATA FROM GEOTECHNICAL REPORTS IN WASHINGTON STATE

The Washington Geological Survey maintains a state-wide publicly available database of subsurface data contained within over 35,000 documents. These documents hold over 100,000 borehole logs that survey geologists, local municipality, public works, planning offices, and private consultants use to satisfy their business needs. This includes development of resource maps, subsurface interpretation of geologic maps, and production of 3D geologic models. The centralization of these data represents a significant effort that benefits the entire geologic and geophysical community in Washington. The logs are processed into ArcGIS for highly accurate horizontal and vertical spatial referencing. Layer information from the logs, including lithology, hydrology, and in-situ testing data are digitized into a standard schema. This information is displayed on our geologic information portal which allows for easy searching, viewing (both in 2D-3D), and downloading the data. A simplified version of the dataset is also available on a mobile app allowing for use in the field. Future progress includes production of small-scale 3D geologic models, tools for improved visualization of the data, and on-going data updates on a regular bi-annual cycle.