View In:   ArcGIS Online Map Viewer

Name: Subsurface documents

Display Field: document_id

Type: Feature Layer

Geometry Type: esriGeometryPolygon

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

Service Item Id: bab4827215c24e8da66933762f408012

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: [248, 252, 186, 0]
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: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: true
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:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: Object ID )
• document_id ( modelName: document_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Document ID, type: esriFieldTypeString )
• document_author ( modelName: DOCUMENT_AUTHOR, nullable: true, editable: true, defaultValue: null, length: 100, alias: Document Author, type: esriFieldTypeString )
• document_source ( modelName: DOCUMENT_SOURCE, nullable: true, editable: true, defaultValue: null, length: 100, alias: Document Source, type: esriFieldTypeString )
• document_type ( modelName: 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 ( modelName: DOCUMENT_TITLE, nullable: true, editable: true, defaultValue: null, length: 255, alias: Document Title, type: esriFieldTypeString )
• document_date ( modelName: DOCUMENT_DATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Document Date, type: esriFieldTypeDate )
• project_type ( modelName: 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 ( modelName: PROJECT_ADDRESS, nullable: true, editable: true, defaultValue: null, length: 100, alias: Project Address, type: esriFieldTypeString )
• borehole_count ( modelName: BOREHOLE_COUNT, nullable: true, editable: true, defaultValue: null, alias: Borehole Count, type: esriFieldTypeSmallInteger )
• document_link ( modelName: DOCUMENT_LINK, nullable: true, editable: true, defaultValue: null, length: 255, alias: Document Link, type: esriFieldTypeString )
• comments ( modelName: COMMENTS, nullable: true, editable: true, defaultValue: null, length: 255, alias: Comments, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GLOBALID )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )

Templates:

• Name: Subsurface documents
  Description:
  Prototype:
  document_link: null
  document_title: null
  project_type: null
  comments: null
  project_address: null
  borehole_count: null
  document_date: null
  document_source: null
  document_id: null
  document_author: null
  document_type: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Relationships:

• subsurface_water_wells (11) -- Related To: Water wells (1)
• subsurface_borehole_info (5) -- Related To: Borehole information (0)

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