20160414
13175600
1.0
Item Description
FALSE
DOCUMENTS
467332.087891
2545460.177734
65497.841797
1351379.139160
1
-
Borehole_Info_to_Documents
Relationship
-
Borehole_Info_to_Documents
Relationship
002
Projected
GCS_North_American_1983_HARN
Linear Unit: Foot_US (0.304801)
NAD_1983_HARN_StatePlane_Washington_South_FIPS_4602_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.4'><WKT>PROJCS["NAD_1983_HARN_StatePlane_Washington_South_FIPS_4602_Feet",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1640416.666666667],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-120.5],PARAMETER["Standard_Parallel_1",45.83333333333334],PARAMETER["Standard_Parallel_2",47.33333333333334],PARAMETER["Latitude_Of_Origin",45.33333333333334],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2927]]</WKT><XOrigin>-117498300</XOrigin><YOrigin>-98850300</YOrigin><XYScale>2048</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>2</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2927</WKID><LatestWKID>2927</LatestWKID></ProjectedCoordinateSystem>
20170816
08144700
20170816
08144700
150000000
5000
FGDC
Washington Geologic Surveys
360-902-1450
360-902-1785
MS 47007
Olympia
WA
98504-7007
geology@dnr.wa.gov
US
Washington Division of Geology and Earth Resources
ArcGIS Metadata
1.0
Washington Geologic Survey
360-902-1450
360-902-1785
MS 47007
Olympia
WA
98504-7007
geology@dnr.wa.gov
US
ESRI file geodatabase table
http://www.dnr.wa.gov/publications/ger_portal_subsurface_database.zip
File Geodatabase Feature Class
2017-08-01T00:00:00
version 2.0
Washington Geologic Survey
MS 47007
Olympia
WA
98504-7007
geology@dnr.wa.gov
US
360-902-1450
360-902-1785
Washington Geologic Survey
MS 47007
Olympia
WA
98504-7007
geology@dnr.wa.gov
US
360-902-1450
360-902-1785
vector digital data
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]
Documents
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>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>
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.
Washington Geologic Survey
360-902-1450
360-902-1785
MS 47007
Olympia
WA
98504-7007
geology@dnr.wa.gov
US
USGS Geographic Names Information System (GNIS) http://geonames.usgs.gov/
2017-02-01T00:00:00
Washington State, USA
Monitoring well
transportation
Borehole
Class B well
ECY
Boring
Water well
Geomap Northwest
Well
Class A well
Geotechnical well
geoscientificInformation
GeoMapNW
Subsurface
WSDOT
Washington State
Geotechnical boring
Geotechnical
Subsurface geology
USA
Washington State Department of Ecology
Washington State Department of Transportation
Boring log
Test pit
Resource protection
Resource protection well
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.
<DIV STYLE="text-align:Left;"><DIV><DIV><P><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></P></DIV></DIV></DIV>
publication date
2017-02-03T00:00:00
1
-124.394681
-116.926998
45.570954
49.003330
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
Monitoring well, Borehole, Class B well, ECY, Boring, Water well, Geomap Northwest, Well, Class A well, Geotechnical well, GeoMapNW, Subsurface, WSDOT, Geotechnical boring, Geotechnical, Subsurface geology, Washington State Department of Ecology, Washington State Department of Transportation, Boring log, Test pit, Resource protection, Resource protection well
Version 6.2 (Build 9200) ; Esri ArcGIS 10.4.1.5686
1
-125.379886
-116.733187
49.037794
45.419718
These data were spot checked against the related documents for completeness and accuracy.
Attribution of each document is as complete as can be discerned by the person who is scanning the document and entering the associated attributes into this table.
The attributes for each document are obtained from the document itself. The accuracy of this dataset varies based on the accuracy of the data entry process.
Horizontal accuracy is determined by the RMS error produced when georeferencing a map into GIS. RMS error was reduce as much as possible to produce the most accurate feature that the source scale would allow.
RMS errors are not reported
not applicable
The data included in this feature class 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-02-03T00:00:00
DOCUMENTS
Project area: location where drilling or boring(s) provide subsurface information
Washington Geological Survey
Feature Class
33622
OBJECTID
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
OBJECTID
OID
4
0
0
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Numerical values that are automoatically generated.
DOCUMENT_ID
Unique identifier for document. Identifier is used to link document information to the borehole record in the borehole feature class.
Washington Geological Survey
unique numeric identifiers
DOCUMENT_ID
Integer
4
0
0
DOCUMENT_AUTHOR
Company or individual that wrote the document
Washington Geological Survey
textual descriptions
DOCUMENT AUTHOR
String
100
0
0
DOCUMENT_SOURCE
Organization from which the document was obtained
Washington Geological Survey
textual descriptions
DOCUMENT_SOURCE
String
100
0
0
DOCUMENT_DATE
The date of the document
Washington Geological Survey
value field
DOCUMENT_DATE
Date
8
0
0
DOCUMENT_TITLE
Title of the document
Washington Geological Survey
textual descriptions
DOCUMENT_TITLE
String
255
0
0
PROJECT_ADDRESS
The street address where the borehole was drilled
Washington Geological Survey
textual descriptions
PROJECT_ADDRESS
String
100
0
0
DOCUMENT_TYPE
The type of document or report
Washington Geological Survey
DOCUMENT_TYPE
String
20
0
0
Boring log
Log showing descriptions of materials and depths at which they were found
Washington Geological Survey
Report
Report of any type
Washington Geological Survey
Other
Other type of document
Washington Geological Survey
Field notes
Notes collected by geologist or drilling companies in the field
Washington Geological Survey
Geologic map
Geologic map or publication
Washington Geological Survey
BOREHOLE_COUNT
The number of boreholes described in the document
Washington Geological Survey
value field
BOREHOLE_COUNT
SmallInteger
2
0
0
PROJECT_TYPE
The project for which the borehole was drilled
Washington Geological Survey
PROJECT_TYPE
String
50
0
0
Transportation - non-roadway
Transportation infrastructure not related to roads or rails
Washington Geological Survey
Residential
Residental property varies from single-family to multi-family structures
Washington Geological Survey
Retail / commercial building
Typically larger building or used for non-residental purposes
Washington Geological Survey
Automotive / fueling depot
Commercial property related to storage and distribution of hydrocarbons, commonly associated with groundwater quality concerns
Washington Geological Survey
Water well
Descrete location for extracting or monitoring water
Washington Geological Survey
Industrial
Typically larger building or facility used for industrial purposes
Washington Geological Survey
Landfill
Property where inorganic wastes are buried
Washington Geological Survey
Landslide
Project to study or mitigate landslides and other slope instabilities
Washington Geological Survey
Dry cleaner / laundry
Commercial property related to cleaning of clothing products, commonly associated with groundwater quality concerns
Washington Geological Survey
Military
Building or facility owned or operated by an military organization
Washington Geological Survey
Mine
Property or facility designed with the intention to extract natural earth resources
Washington Geological Survey
Park / recreation
Recreation facility
Washington Geological Survey
Railroad
Right-of-way or structures related to or owned by a railroad
Washington Geological Survey
Retaining wall
Study or report specifically related to the construction or maintenance of a retaining wall
Washington Geological Survey
Roadway
Right-of-way or facility related to automobile usage
Washington Geological Survey
Tunnel
Specific roadway case where the right-of-way extends entirely underground
Washington Geological Survey
Unknown
Project or purpose of the document is unknown
Washington Geological Survey
Bridge
Specific case of roadway structure typically designed to resist substantial lateral and vertical forces
Washington Geological Survey
DOCUMENT_LINK
URL to the PDF of the document
Washington Geological Survey
unique alphanumeric identifiers
DOCUMENT_LINK
String
255
0
0
GEOPROFILE_FLAG
GEOPROFILE_FLAG
String
5
0
0
Flag field to indicate if the report includes a linear type subsurface dataset such as a cross section or geophysical testing.
Washington Geological Survey
Yes
Document has a geoprofile type object
Washington Geological Survey
No
Document does not have a geoprofile type object
Washington Geological Survey
Unknown
Unclear if document has geoprofile type object
Washington Geological Survey
SLOPE_STABILITY_FLAG
SLOPE_STABILITY_FLAG
String
5
0
0
Flag field to indicate if the document addresses any slop stability or landslide concerns
Washington Geological Survey
Yes
Document contains slope stability features
Washington Geological Survey
No
Document does not contain slope stability features
Washington Geological Survey
Unknown
Unclear if document contains slope stability features
Washington Geological Survey
COMMENTS
COMMENTS
String
255
0
0
Free text field to make comments related to the document
Washington Geological Survey
textual description
Shape_Length
Shape_Length
Double
8
0
0
Length of feature in internal units.
Esri
Positive real numbers that are automatically generated.
Shape_Area
Shape_Area
Double
8
0
0
Area of feature in internal units squared.
Esri
Positive real numbers that are automatically generated.
dataset
EPSG
6.13(9.0.0)
33622
Simple
FALSE
33622
TRUE
FALSE
20170816