View In:   ArcGIS Online Map Viewer

Name: Borehole information

Display Field: borehole_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

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

Service Item Id: fc240cdfaef940ce85377d49802894d6

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1000000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 687727.732421875
YMin: 97682.68994140625
XMax: 2505476.8657226562
YMax: 1345776.1469726562
Spatial Reference: 2927  (2927)

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: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: borehole_class

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, alias: Object ID, type: esriFieldTypeOID )
• borehole_id ( nullable: true, editable: true, defaultValue: null, alias: Borehole ID, type: esriFieldTypeInteger )
• document_id ( nullable: true, editable: true, defaultValue: null, alias: Document ID, type: esriFieldTypeInteger )
• borehole_name ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Borehole Name, type: esriFieldTypeString )
• borehole_class ( nullable: true, editable: true, defaultValue: null, length: 25, alias: Borehole Class, type: esriFieldTypeString , Coded Values: [Geotechnical: Geotechnical] , [Water well: Water well] , [Test pit: Test pit] , ...1 more... )
• borehole_type ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Borehole Type, type: esriFieldTypeString , Coded Values: [Exposure: Exposure] , [Geotechnical: Geotechnical] , [Other: Other] , ...9 more... )
• borehole_depth_ft ( nullable: true, editable: true, defaultValue: null, alias: Borehole Depth (ft), type: esriFieldTypeDouble )
• borehole_diameter_in ( nullable: true, editable: true, defaultValue: null, alias: Borehole Diameter (in), type: esriFieldTypeDouble )
• borehole_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Borehole Date, type: esriFieldTypeDate )
• elevation_ft ( nullable: true, editable: true, defaultValue: null, alias: Elevation (ft), type: esriFieldTypeDouble )
• elevation_method ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Elevation Method, type: esriFieldTypeString , Coded Values: [Altimeter: Altimeter] , [DEM: DEM] , [GPS: GPS] , ...8 more... )
• contractor_name ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Contractor Name, type: esriFieldTypeString )
• boring_method ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Boring Method, type: esriFieldTypeString , Coded Values: [Coring: Coring] , [Odex: Odex] , [Unknown: Unknown] , ...12 more... )
• location_confidence ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Location Confidence, type: esriFieldTypeString , Coded Values: [Survey: Surveyed] , [High: Less than 20 feet] , [Medium: Between 20 and 100 feet] , ...1 more... )
• data_confidence ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Data Confidence, type: esriFieldTypeString , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] , ...3 more... )
• county_name ( nullable: true, editable: true, defaultValue: null, length: 20, alias: County Name, type: esriFieldTypeString , Coded Values: [Adams: Adams] , [Asotin: Asotin] , [Benton: Benton] , ...36 more... )
• source_db_code ( nullable: true, editable: true, defaultValue: null, alias: Source Database Code, type: esriFieldTypeSmallInteger )
• source_db_id ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Source Database ID, type: esriFieldTypeString )
• comments ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )
• ecyid ( nullable: true, editable: true, defaultValue: null, alias: Ecology ID, type: esriFieldTypeInteger )
• reported_elevation ( nullable: true, editable: true, defaultValue: null, alias: Reported Elevation (ft), type: esriFieldTypeDouble )
• reported_elevation_method ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Reported Elevation Method, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )

Types:

ID: Geotechnical
Name: Geotechnical
Domains:
• borehole_type:
  Inherited
• elevation_method:
  Inherited
• data_confidence:
  Inherited
• location_confidence:
  Inherited
• borehole_class:
  Inherited
• county_name:
  Inherited
• boring_method:
  Inherited
Templates:
• Name: Geotechnical
  Description:
  Prototype:
  borehole_type: null
  comments: null
  data_confidence: null
  elevation_ft: null
  ecyid: null
  source_db_code: null
  borehole_diameter_in: null
  document_id: null
  county_name: null
  reported_elevation: null
  source_db_id: null
  contractor_name: null
  borehole_name: null
  elevation_method: null
  location_confidence: null
  borehole_date: null
  reported_elevation_method: null
  borehole_class: Geotechnical
  borehole_id: null
  borehole_depth_ft: null
  boring_method: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Lithologic boring
Name: Lithologic boring
Domains:
• borehole_type:
  Inherited
• elevation_method:
  Inherited
• data_confidence:
  Inherited
• location_confidence:
  Inherited
• borehole_class:
  Inherited
• county_name:
  Inherited
• boring_method:
  Inherited
Templates:
• Name: Lithologic boring
  Description:
  Prototype:
  borehole_type: null
  comments: null
  data_confidence: null
  elevation_ft: null
  ecyid: null
  source_db_code: null
  borehole_diameter_in: null
  document_id: null
  county_name: null
  reported_elevation: null
  source_db_id: null
  contractor_name: null
  borehole_name: null
  elevation_method: null
  location_confidence: null
  borehole_date: null
  reported_elevation_method: null
  borehole_class: Lithologic boring
  borehole_id: null
  borehole_depth_ft: null
  boring_method: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Test pit
Name: Test pit
Domains:
• borehole_type:
  Inherited
• elevation_method:
  Inherited
• data_confidence:
  Inherited
• location_confidence:
  Inherited
• borehole_class:
  Inherited
• county_name:
  Inherited
• boring_method:
  Inherited
Templates:
• Name: Test pit
  Description:
  Prototype:
  borehole_type: null
  comments: null
  data_confidence: null
  elevation_ft: null
  ecyid: null
  source_db_code: null
  borehole_diameter_in: null
  document_id: null
  county_name: null
  reported_elevation: null
  source_db_id: null
  contractor_name: null
  borehole_name: null
  elevation_method: null
  location_confidence: null
  borehole_date: null
  reported_elevation_method: null
  borehole_class: Test pit
  borehole_id: null
  borehole_depth_ft: null
  boring_method: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

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

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata