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