Layers:

Layer: Lithologic Borings (0)

Name: Lithologic Borings

Display Field: BOREHOLE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: These data contain point locations of boreholes in Washington State along with detailed attribution concerning each. An associated table provides information concerning the well log or geotechnical report and a hyperlink to connect the user of the data to this document. Some of the boreholes have relationships with additional tables that provide information concerning geologic layers the borehole passes through, the depth to groundwater, or other information.

Copyright Text: Washington Division of Geology and Earth Resources

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

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:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [230, 230, 0, 255]
Size: 4.5
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[79, 79, 79, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: OBJECTID )
• 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... )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE )
• 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_DB_CODE )
• SOURCE_DB_ID ( type: esriFieldTypeString, alias: SOURCE_DB_ID, length: 50 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• ECYID ( type: esriFieldTypeInteger, alias: ECYID )
• REPORTED_ELEVATION ( type: esriFieldTypeDouble, alias: REPORTED_ELEVATION )
• REPORTED_ELEVATION_METHOD ( type: esriFieldTypeString, alias: REPORTED_ELEVATION_METHOD, length: 50 )

Relationships:

• Documents (0) -- Related To: documents (3)
• Hydrologic (1) -- Related To: Subsurface database hydrologic data (5)
• Bedrock (2) -- Related To: Subsurface database bedrock table (4)
• Layer Data (3) -- Related To: Layer Data (7)
• Layer Comments (4) -- Related To: Subsurface database layer comments (6)

Layer: Geotechnical Borings (1)

Name: Geotechnical Borings

Display Field: BOREHOLE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: These data contain point locations of boreholes in Washington State along with detailed attribution concerning each. An associated table provides information concerning the well log or geotechnical report and a hyperlink to connect the user of the data to this document. Some of the boreholes have relationships with additional tables that provide information concerning geologic layers the borehole passes through, the depth to groundwater, or other information.

Copyright Text: Washington Division of Geology and Earth Resources

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

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:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [166, 128, 255, 255]
Size: 4.5
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[128, 0, 255, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: OBJECTID )
• 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... )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE )
• 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_DB_CODE )
• SOURCE_DB_ID ( type: esriFieldTypeString, alias: SOURCE_DB_ID, length: 50 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• ECYID ( type: esriFieldTypeInteger, alias: ECYID )
• REPORTED_ELEVATION ( type: esriFieldTypeDouble, alias: REPORTED_ELEVATION )
• REPORTED_ELEVATION_METHOD ( type: esriFieldTypeString, alias: REPORTED_ELEVATION_METHOD, length: 50 )

Relationships:

• Documents (5) -- Related To: documents (3)
• Hydrologic (6) -- Related To: Subsurface database hydrologic data (5)
• Bedrock (7) -- Related To: Subsurface database bedrock table (4)
• Layer Data (8) -- Related To: Layer Data (7)
• Layer Comments (9) -- Related To: Subsurface database layer comments (6)

Layer: Water Wells (2)

Name: Water Wells

Display Field: BOREHOLE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: These data contain point locations of boreholes in Washington State along with detailed attribution concerning each. An associated table provides information concerning the well log or geotechnical report and a hyperlink to connect the user of the data to this document. Some of the boreholes have relationships with additional tables that provide information concerning geologic layers the borehole passes through, the depth to groundwater, or other information.

Copyright Text: Washington Division of Geology and Earth Resources

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

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:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [102, 205, 171, 255]
Size: 4.5
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 115, 77, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: OBJECTID )
• 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... )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE )
• 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_DB_CODE )
• SOURCE_DB_ID ( type: esriFieldTypeString, alias: SOURCE_DB_ID, length: 50 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• ECYID ( type: esriFieldTypeInteger, alias: ECYID )
• REPORTED_ELEVATION ( type: esriFieldTypeDouble, alias: REPORTED_ELEVATION )
• REPORTED_ELEVATION_METHOD ( type: esriFieldTypeString, alias: REPORTED_ELEVATION_METHOD, length: 50 )

Relationships:

• Documents (10) -- Related To: documents (3)
• Hydrologic (11) -- Related To: Subsurface database hydrologic data (5)
• Bedrock (12) -- Related To: Subsurface database bedrock table (4)
• Layer Data (13) -- Related To: Layer Data (7)
• Layer Comments (14) -- Related To: Subsurface database layer comments (6)

Layer: documents (3)

Name: documents

Display Field: DOCUMENT_ID

Type: Feature Layer

Geometry Type: esriGeometryPolygon

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

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 467332.087890625
YMin: 65497.841796875
XMax: 2545460.177734375
YMax: 1351379.1391601562
Spatial Reference: 2927  (2927)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [189, 189, 252, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• DOCUMENT_ID ( type: esriFieldTypeInteger, alias: DOCUMENT_ID )
• DOCUMENT_AUTHOR ( type: esriFieldTypeString, alias: DOCUMENT AUTHOR, length: 100 )
• DOCUMENT_SOURCE ( type: esriFieldTypeString, alias: DOCUMENT_SOURCE, length: 100 )
• DOCUMENT_TYPE ( type: esriFieldTypeString, alias: DOCUMENT_TYPE, length: 20 , Coded Values: [Report: Report] , [Other: Other] , [Boring log: Boring log] , ...2 more... )
• DOCUMENT_TITLE ( type: esriFieldTypeString, alias: DOCUMENT_TITLE, length: 255 )
• DOCUMENT_DATE ( type: esriFieldTypeDate, alias: DOCUMENT_DATE, length: 8 )
• PROJECT_TYPE ( type: esriFieldTypeString, alias: PROJECT_TYPE, length: 50 , Coded Values: [Transportation - non-roadway: Transportation - non-roadway] , [Residential: Residential] , [Retail / commercial building: Retail / commercial building] , ...16 more... )
• PROJECT_ADDRESS ( type: esriFieldTypeString, alias: PROJECT_ADDRESS, length: 100 )
• BOREHOLE_COUNT ( type: esriFieldTypeSmallInteger, alias: BOREHOLE_COUNT )
• DOCUMENT_LINK ( type: esriFieldTypeString, alias: DOCUMENT_LINK, length: 255 )
• GEOPROFILE_FLAG ( type: esriFieldTypeString, alias: GEOPROFILE_FLAG, length: 5 , Coded Values: [Y: Yes] , [N: No] )
• SLOPE_STABILITY_FLAG ( type: esriFieldTypeString, alias: SLOPE_STABILITY_FLAG, length: 5 , Coded Values: [Y: Yes] , [N: No] )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• Shape_Length ( type: esriFieldTypeDouble, alias: Shape_Length )
• Shape_Area ( type: esriFieldTypeDouble, alias: Shape_Area )

Relationships:

• Borehole Info (0) -- Related To: Lithologic Borings (0)
• Borehole Info (5) -- Related To: Geotechnical Borings (1)
• Borehole Info (10) -- Related To: Water Wells (2)

Tables:

Table: Subsurface database bedrock table (4)

Name: Subsurface database bedrock table

Display Field: BOREHOLE_ID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: 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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• BOREHOLE_ID ( type: esriFieldTypeInteger, alias: BOREHOLE_ID )
• DEPTH_TO_BEDROCK_FT ( type: esriFieldTypeSingle, alias: DEPTH_TO_BEDROCK_FT )
• BEDROCK_TYPE ( type: esriFieldTypeString, alias: BEDROCK_TYPE, length: 30 )

Relationships:

• Borehole Info (2) -- Related To: Lithologic Borings (0)
• Borehole Info (7) -- Related To: Geotechnical Borings (1)
• Borehole Info (12) -- Related To: Water Wells (2)

Table: Subsurface database hydrologic data (5)

Name: Subsurface database hydrologic data

Display Field: BOREHOLE_ID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: 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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• BOREHOLE_ID ( type: esriFieldTypeInteger, alias: BOREHOLE_ID )
• DEPTH_TO_WATER_FT ( type: esriFieldTypeDouble, alias: DEPTH_TO_WATER_FT )
• ARTESIAN_PRESSURE_PSI ( type: esriFieldTypeSingle, alias: ARTESIAN_PRESSURE_PSI )
• DRAWDOWN_YIELD_GPM ( type: esriFieldTypeSingle, alias: DRAWDOWN_YIELD )
• DRAWDOWN_DISTANCE_FT ( type: esriFieldTypeSingle, alias: DROWDOWN_DISTANCE_FT )
• AIRTEST_STEM_FT ( type: esriFieldTypeSingle, alias: AIRTEST_STEM_FT )
• DRAWDOWN_TIME_HOURS ( type: esriFieldTypeSingle, alias: DRAWDOWN_TIME_HOURS )
• TEST_DATE ( type: esriFieldTypeDate, alias: TEST_DATE, length: 8 )
• WATER_TEMPERATURE_C ( type: esriFieldTypeSingle, alias: WATER_TEMPERATURE_C )
• CHEMICAL_TEST_FLAG ( type: esriFieldTypeString, alias: CHEMICAL_TEST_FLAG, length: 5 , Coded Values: [Y: Yes] , [N: No] )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )

Relationships:

• Borehole Info (1) -- Related To: Lithologic Borings (0)
• Borehole Info (6) -- Related To: Geotechnical Borings (1)
• Borehole Info (11) -- Related To: Water Wells (2)

Table: Subsurface database layer comments (6)

Name: Subsurface database layer comments

Display Field: BOREHOLE_ID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: 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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• BOREHOLE_ID ( type: esriFieldTypeInteger, alias: BOREHOLE_ID )
• COMMENT_NUMBER ( type: esriFieldTypeSmallInteger, alias: COMMENT_NUMBER )
• COMMENT_DEPTH_FT ( type: esriFieldTypeSingle, alias: COMMENT_DEPTH_FT )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 400 )

Relationships:

• Borehole Info (4) -- Related To: Lithologic Borings (0)
• Borehole Info (9) -- Related To: Geotechnical Borings (1)
• Borehole Info (14) -- Related To: Water Wells (2)

Table: Layer Data (7)

Name: Layer Data

Display Field: BOREHOLE_ID

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: 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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• BOREHOLE_ID ( type: esriFieldTypeInteger, alias: BOREHOLE_ID )
• LAYER_NUMBER ( type: esriFieldTypeSmallInteger, alias: LAYER_NUMBER )
• TOP_DEPTH_FT ( type: esriFieldTypeSingle, alias: TOP_DEPTH_FT )
• BOTTOM_DEPTH_FT ( type: esriFieldTypeSingle, alias: BOTTOM_DEPTH_FT )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, length: 500 )
• LAYER_TYPE ( type: esriFieldTypeString, alias: LAYER_TYPE, length: 15 , Coded Values: [Single: Single] , [Gradational: Gradational] , [Interbedded: Interbedded] , ...1 more... )
• USCS ( type: esriFieldTypeString, alias: USCS, length: 20 )
• SYMBOL_LITHOLOGY ( type: esriFieldTypeString, alias: SYMBOL_LITHOLOGY, length: 30 , Coded Values: [Asphalt / concrete: Asphalt / concrete] , [Topsoil / vegetation: Topsoil / vegetation] , [Debris: Debris] , ...26 more... )
• INTERPRETED_LITHOLOGY ( type: esriFieldTypeString, alias: INTERPRETED_LITHOLOGY, length: 30 )
• GEOLOGIC_UNIT ( type: esriFieldTypeString, alias: GEOLOGIC_UNIT, length: 12 )
• GEOLOGIC_UNIT_CONFIDENCE ( type: esriFieldTypeString, alias: GEOLOGIC_UNIT_CONFIDENCE, length: 20 , Coded Values: [Low: Low] , [Medium: Medium] , [High: High] )
• GEOLOGIST ( type: esriFieldTypeString, alias: GEOLOGIST, length: 30 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• Start_Depth ( type: esriFieldTypeDouble, alias: Start_Depth )
• End_Depth ( type: esriFieldTypeDouble, alias: End_Depth )
• Material ( type: esriFieldTypeString, alias: Material, length: 50 )

Relationships:

• Borehole Info (3) -- Related To: Lithologic Borings (0)
• Borehole Info (8) -- Related To: Geotechnical Borings (1)
• Borehole Info (13) -- Related To: Water Wells (2)