Name: Borehole information

Display Field: BOREHOLE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: 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: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.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.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.

Service Item Id: 1ab579b14ffa4d9fa2586259293ab23e

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1000000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 687727.732421875
YMin: 92247.91455078125
XMax: 2545440.177734375
YMax: 1351359.1391601562
Spatial Reference: 2927  (2927)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: BOREHOLE_CLASS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Geotechnical
  Label: Geotechnical
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [96, 161, 61, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Lithologic boring
  Label: Lithologic boring
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [96, 47, 161, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: Test pit
  Label: Test pit
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [191, 54, 50, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 500000.0
Max. Scale: 0.0

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: Object ID )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• BOREHOLE_ID ( type: esriFieldTypeInteger, alias: Borehole ID )
• DOCUMENT_ID ( type: esriFieldTypeInteger, alias: Document ID )
• BOREHOLE_NAME ( type: esriFieldTypeString, alias: Borehole Name, length: 50 )
• BOREHOLE_CLASS ( type: esriFieldTypeString, alias: Borehole Class, length: 25 , Coded Values: [Geotechnical: Geotechnical] , [Water well: Water well] , [Test pit: Test pit] , ...1 more... )
• BOREHOLE_TYPE ( type: esriFieldTypeString, alias: Borehole Type, length: 50 , Coded Values: [Exposure: Exposure] , [Geotechnical: Geotechnical] , [Other: Other] , ...9 more... )
• BOREHOLE_DEPTH_FT ( type: esriFieldTypeDouble, alias: Borehole Depth (ft) )
• BOREHOLE_DIAMETER_IN ( type: esriFieldTypeSingle, alias: Borehole Diameter (in) )
• BOREHOLE_DATE ( type: esriFieldTypeDate, alias: Borehole Date, length: 8 )
• ELEVATION_FT ( type: esriFieldTypeDouble, alias: Elevation (ft) )
• ELEVATION_METHOD ( type: esriFieldTypeString, alias: Elevation Method, length: 50 , Coded Values: [Altimeter: Altimeter] , [DEM: DEM] , [GPS: GPS] , ...8 more... )
• CONTRACTOR_NAME ( type: esriFieldTypeString, alias: Contractor Name, length: 100 )
• BORING_METHOD ( type: esriFieldTypeString, alias: Boring Method, length: 50 , Coded Values: [Coring: Coring] , [Odex: Odex] , [Unknown: Unknown] , ...12 more... )
• LOCATION_CONFIDENCE ( type: esriFieldTypeString, alias: Location Confidence, length: 50 , Coded Values: [Survey: Surveyed] , [Less than 20 feet: Less than 20 feet] , [Between 20 and 100 feet: Between 20 and 100 feet] , ...1 more... )
• DATA_CONFIDENCE ( type: esriFieldTypeString, alias: Data Confidence, length: 20 , Coded Values: [High: High] , [Medium high: Medium high] , [Medium: Medium] , ...2 more... )
• COUNTY_NAME ( type: esriFieldTypeString, alias: County Name, length: 20 , Coded Values: [Adams: Adams] , [Asotin: Asotin] , [Benton: Benton] , ...36 more... )
• SOURCE_DB_CODE ( type: esriFieldTypeSmallInteger, alias: Source Database Code )
• SOURCE_DB_ID ( type: esriFieldTypeString, alias: Source Database ID, length: 50 )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 255 )
• ECYID ( type: esriFieldTypeInteger, alias: Ecology ID )
• REPORTED_ELEVATION ( type: esriFieldTypeDouble, alias: Reported Elevation (ft) )
• REPORTED_ELEVATION_METHOD ( type: esriFieldTypeString, alias: Reported Elevation Method, length: 50 )

Relationships:

• lithology_logs (0) -- Related To: Subsurface database lithology logs (7)
• bedrock (1) -- Related To: Subsurface database bedrock table (2)
• layer_data (2) -- Related To: Subsurface database layer data (6)
• hydrologic (3) -- Related To: Subsurface database hydrologic data (3)
• subsurface_documents (4) -- Related To: Subsurface database documents (8)
• in_situ_test_data (5) -- Related To: Subsurface database in-situ test data (4)
• layer_comments (6) -- Related To: Subsurface database layer comments (5)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata