Layers:

Layer: Borehole information (0)

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)

Layer: Water wells (1)

Name: Water wells

Display Field: borehole_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Water wells have been compiled from various sources, mostly from the Washington Department of Ecology. The selection of wells shown in this dataset have been used in published geologic research by the Washington Geological Survey and were determined to be of high quality. The locations of these wells may have been refined from their original source. For the complete database, visit the Department of Ecology’s website.</SPAN></P></DIV></DIV></DIV>

Service Item Id: fc240cdfaef940ce85377d49802894d6

Copyright Text:

Default Visibility: false

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: 692235.7651367188
YMin: 92247.91455078125
XMax: 2545440.177734375
YMax: 1351359.1391601562
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: Water well
  Label: Water well
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 132, 168, 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: OBJECTID, 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... )
• comments ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )
• ecyid ( nullable: true, editable: true, defaultValue: null, alias: ECY ID, type: esriFieldTypeInteger )
• reported_elevation ( nullable: true, editable: true, defaultValue: null, alias: Reported Elevation, 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: Water well
Name: Water well
Domains:
• borehole_type:
  Inherited
• elevation_method:
  Inherited
• data_confidence:
  Inherited
• location_confidence:
  Inherited
• borehole_class:
  Inherited
• county_name:
  Inherited
• boring_method:
  Inherited
Templates:
• Name: Water well
  Description:
  Prototype:
  borehole_type: null
  comments: null
  data_confidence: null
  elevation_ft: null
  ecyid: null
  borehole_diameter_in: null
  document_id: null
  county_name: null
  reported_elevation: null
  contractor_name: null
  borehole_name: null
  elevation_method: null
  location_confidence: null
  borehole_date: null
  reported_elevation_method: null
  borehole_class: Water well
  borehole_id: null
  borehole_depth_ft: null
  boring_method: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

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

Tables:

Table: Subsurface database bedrock table (2)

Name: Subsurface database bedrock table

Display Field: borehole_id

Type: Table

Geometry Type: N/A

Description:

Service Item Id: fc240cdfaef940ce85377d49802894d6

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

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 )
• depth_to_bedrock_ft ( nullable: true, editable: true, defaultValue: null, alias: Depth to Bedrock (ft), type: esriFieldTypeDouble )
• bedrock_type ( nullable: true, editable: true, defaultValue: null, length: 30, alias: Bedrock Type, type: esriFieldTypeString )
Templates:
• Name: Subsurface database bedrock table
  Description:
  Prototype:
  bedrock_type: null
  depth_to_bedrock_ft: null
  borehole_id: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• water_wells (7) -- Related To: Water wells (1)
• borehole_info (1) -- Related To: Borehole information (0)

Table: Subsurface database hydrologic data (3)

Name: Subsurface database hydrologic data

Display Field: borehole_id

Type: Table

Geometry Type: N/A

Description:

Service Item Id: fc240cdfaef940ce85377d49802894d6

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

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 )
• depth_to_water_ft ( nullable: true, editable: true, defaultValue: null, alias: Depth to Water (ft), type: esriFieldTypeDouble )
• artesian_pressure_psi ( nullable: true, editable: true, defaultValue: null, alias: Artesian Pressure (psi), type: esriFieldTypeDouble )
• drawdown_yield_gpm ( nullable: true, editable: true, defaultValue: null, alias: Drawdown Yield (gpm), type: esriFieldTypeDouble )
• drawdown_distance_ft ( nullable: true, editable: true, defaultValue: null, alias: Drawdown Distance (ft), type: esriFieldTypeDouble )
• airtest_stem_ft ( nullable: true, editable: true, defaultValue: null, alias: Airtest Stem (ft), type: esriFieldTypeDouble )
• drawdown_time_hours ( nullable: true, editable: true, defaultValue: null, alias: Drawdown Time (hrs), type: esriFieldTypeDouble )
• test_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Test Date, type: esriFieldTypeDate )
• water_temperature_c ( nullable: true, editable: true, defaultValue: null, alias: Water Temperature (c), type: esriFieldTypeDouble )
• chemical_test_flag ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Chemical Test Flag, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• comments ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
Templates:
• Name: Subsurface database hydrologic data
  Description:
  Prototype:
  artesian_pressure_psi: null
  comments: null
  water_temperature_c: null
  drawdown_time_hours: null
  depth_to_water_ft: null
  drawdown_yield_gpm: null
  test_date: null
  chemical_test_flag: null
  drawdown_distance_ft: null
  borehole_id: null
  airtest_stem_ft: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• water_wells (10) -- Related To: Water wells (1)
• borehole_info (3) -- Related To: Borehole information (0)

Table: Subsurface database in-situ test data (4)

Name: Subsurface database in-situ test data

Display Field: borehole_id

Type: Table

Geometry Type: N/A

Description:

Service Item Id: fc240cdfaef940ce85377d49802894d6

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

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 )
• start_depth_ft ( nullable: true, editable: true, defaultValue: null, alias: Start Depth (ft), type: esriFieldTypeDouble )
• n_number ( nullable: true, editable: true, defaultValue: null, alias: N Number, type: esriFieldTypeSmallInteger )
• calibrated_n_flag ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Calibrated N Flag, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] , [U: Unknown] )
• count_comment ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Count Comment, type: esriFieldTypeString )
• test_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Test Date, type: esriFieldTypeDate )
• test_type ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Test Type, type: esriFieldTypeString )
• sampler ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Sampler, type: esriFieldTypeString )
• comments ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
Templates:
• Name: Subsurface database in-situ test data
  Description:
  Prototype:
  n_number: null
  count_comment: null
  comments: null
  start_depth_ft: null
  calibrated_n_flag: null
  test_date: null
  borehole_id: null
  test_type: null
  sampler: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• water_wells (8) -- Related To: Water wells (1)
• borehole_info (2) -- Related To: Borehole information (0)

Table: Subsurface database layer comments (5)

Name: Subsurface database layer comments

Display Field: borehole_id

Type: Table

Geometry Type: N/A

Description:

Service Item Id: fc240cdfaef940ce85377d49802894d6

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

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 )
• comment_number ( nullable: true, editable: true, defaultValue: null, alias: Comment Number, type: esriFieldTypeSmallInteger )
• comment_depth_ft ( nullable: true, editable: true, defaultValue: null, alias: Comment Depth (ft), type: esriFieldTypeDouble )
• comments ( nullable: true, editable: true, defaultValue: null, length: 400, alias: Comments, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
Templates:
• Name: Subsurface database layer comments
  Description:
  Prototype:
  comments: null
  comment_depth_ft: null
  comment_number: null
  borehole_id: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• water_wells (9) -- Related To: Water wells (1)
• borehole_info (4) -- Related To: Borehole information (0)

Table: Subsurface database layer data (6)

Name: Subsurface database layer data

Display Field: borehole_id

Type: Table

Geometry Type: N/A

Description:

Service Item Id: fc240cdfaef940ce85377d49802894d6

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

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 )
• layer_number ( nullable: true, editable: true, defaultValue: null, alias: Layer Number, type: esriFieldTypeSmallInteger )
• top_depth_ft ( nullable: true, editable: true, defaultValue: null, alias: Top Depth (ft), type: esriFieldTypeDouble )
• bottom_depth_ft ( nullable: true, editable: true, defaultValue: null, alias: Bottom Depth (ft), type: esriFieldTypeDouble )
• description ( nullable: true, editable: true, defaultValue: null, length: 500, alias: Description, type: esriFieldTypeString )
• layer_type ( nullable: true, editable: true, defaultValue: null, length: 15, alias: Layer Type, type: esriFieldTypeString , Coded Values: [Single: Single] , [Gradational: Gradational] , [Interbedded: Interbedded] , ...1 more... )
• uscs ( nullable: true, editable: true, defaultValue: null, length: 20, alias: USCS, type: esriFieldTypeString )
• symbol_lithology ( nullable: true, editable: true, defaultValue: null, length: 30, alias: Symbol Lithology, type: esriFieldTypeString , Coded Values: [Asphalt / concrete: Asphalt / concrete] , [Topsoil / vegetation: Topsoil / vegetation] , [Debris: Debris] , ...26 more... )
• interpreted_lithology ( nullable: true, editable: true, defaultValue: null, length: 30, alias: Interpreted Lithology, type: esriFieldTypeString )
• geologic_unit ( nullable: true, editable: true, defaultValue: null, length: 12, alias: Geologic Unit, type: esriFieldTypeString )
• geologic_unit_confidence ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Geologic Unit Confidence, type: esriFieldTypeString , Coded Values: [Low: Low] , [Medium: Medium] , [High: High] )
• geologist ( nullable: true, editable: true, defaultValue: null, length: 30, alias: Geologist, type: esriFieldTypeString )
• comments ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
Templates:
• Name: Subsurface database layer data
  Description:
  Prototype:
  geologic_unit_confidence: null
  comments: null
  symbol_lithology: null
  layer_number: null
  bottom_depth_ft: null
  description: null
  layer_type: null
  geologic_unit: null
  interpreted_lithology: null
  top_depth_ft: null
  uscs: null
  geologist: null
  borehole_id: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• borehole_info (6) -- Related To: Borehole information (0)
• water_wells (11) -- Related To: Water wells (1)

Table: Subsurface database lithology logs (7)

Name: Subsurface database lithology logs

Display Field: borehole_id

Type: Table

Geometry Type: N/A

Description:

Service Item Id: fc240cdfaef940ce85377d49802894d6

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, alias: OBJECTID, type: esriFieldTypeOID )
• borehole_id ( nullable: true, editable: true, defaultValue: null, alias: Borehole ID, type: esriFieldTypeInteger )
• url ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Hyperlink, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
Templates:
• Name: Subsurface database lithology logs
  Description:
  Prototype:
  borehole_id: null
  url: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• water_wells (12) -- Related To: Water wells (1)
• borehole_info (0) -- Related To: Borehole information (0)

Table: Subsurface database documents (8)

Name: Subsurface database documents

Display Field: document_id

Type: Table

Geometry Type: N/A

Description:

Service Item Id: fc240cdfaef940ce85377d49802894d6

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, alias: OBJECTID, type: esriFieldTypeOID )
• document_id ( nullable: true, editable: true, defaultValue: null, alias: Document ID, type: esriFieldTypeInteger )
• document_author ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Document Author, type: esriFieldTypeString )
• document_source ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Document Source, type: esriFieldTypeString )
• document_type ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Document Type, type: esriFieldTypeString , Coded Values: [Report: Report] , [Other: Other] , [Boring Log: Boring log] , ...2 more... )
• document_title ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Document Title, type: esriFieldTypeString )
• document_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Document Date, type: esriFieldTypeDate )
• project_type ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Project Type, type: esriFieldTypeString , Coded Values: [Transportation - non-roadway: Transportation - non-roadway] , [Residential: Residential] , [Retail / commercial building: Retail / commercial building] , ...16 more... )
• project_address ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Project Address, type: esriFieldTypeString )
• borehole_count ( nullable: true, editable: true, defaultValue: null, alias: Borehole Count, type: esriFieldTypeSmallInteger )
• document_link ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Document Link, type: esriFieldTypeString )
• geoprofile_flag ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Geoprofile Flag, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• slope_stability_flag ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Slope Stability Flag, type: esriFieldTypeString , Coded Values: [Y: Yes] , [N: No] )
• comments ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
Templates:
• Name: Subsurface database documents
  Description:
  Prototype:
  document_title: null
  document_link: null
  project_type: null
  comments: null
  project_address: null
  document_date: null
  document_id: null
  document_author: null
  borehole_count: null
  geoprofile_flag: null
  document_source: null
  slope_stability_flag: null
  document_type: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• water_wells (13) -- Related To: Water wells (1)
• borehole_info (5) -- Related To: Borehole information (0)