Name: Cases

Display Field: BOCA_CD

Type: Table

Geometry Type: N/A

Description: Cases - Water Right Query System indexes the legal and administrative cases attached to Montana water rights. It contains one record for each administrative water case or Montana Water Court case associated with a water right version, identifying the water right (basin, water right number, type, and status), the version to which the case is attached, and the case itself - internal case identifier, public case number, case type, and current case status. Because cases attach at the version level, a single water right can produce multiple records. The table is non-spatial and is used together with the case link in the version-level WRQS tables.

Service Item Id: afbfc45dac094639b8920ad530d6bd0b

Copyright Text:

Default Visibility: false

MaxRecordCount: 10000

MaxSelectionCount: 0

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

Feature Draw Order:

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

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• WRGT_ID_SEQ ( type: esriFieldTypeInteger, alias: Water Right ID Sequence, editable: true, nullable: false, defaultValue: null, modelName: WRGT_ID_SEQ )
• BOCA_CD ( type: esriFieldTypeString, alias: Administrative Basin, editable: true, nullable: true, length: 4, defaultValue: null, modelName: BOCA_CD )
• WTR_ID ( type: esriFieldTypeInteger, alias: Water Right ID, editable: true, nullable: true, defaultValue: null, modelName: WTR_ID )
• WR_NUMBER ( type: esriFieldTypeString, alias: Water Right Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WR_NUMBER )
• WR_TYPE ( type: esriFieldTypeString, alias: Water Right Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WR_TYPE )
• WR_STATUS ( type: esriFieldTypeString, alias: Water Right Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WR_STATUS )
• CASE_VERS ( type: esriFieldTypeInteger, alias: Case Version, editable: true, nullable: true, defaultValue: null, modelName: CASE_VERS )
• CASE_VERS_TYPE ( type: esriFieldTypeString, alias: Case Version Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CASE_VERS_TYPE )
• CASE_ID_SEQ ( type: esriFieldTypeInteger, alias: Case ID Sequence, editable: true, nullable: false, defaultValue: null, modelName: CASE_ID_SEQ )
• CASE_TYPE ( type: esriFieldTypeString, alias: Case Type, editable: true, nullable: false, length: 35, defaultValue: null, modelName: CASE_TYPE )
• CASE_NUMBER ( type: esriFieldTypeString, alias: Case Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CASE_NUMBER )
• CASE_STATUS ( type: esriFieldTypeString, alias: Case Status, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CASE_STATUS )
• REFRESH_DATE ( type: esriFieldTypeDate, alias: Refresh Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REFRESH_DATE )

Templates:

• Name: Cases
  Description:
  Prototype:
  CASE_STATUS: null
  REFRESH_DATE: null
  WRGT_ID_SEQ: 0
  BOCA_CD: null
  WTR_ID: null
  WR_NUMBER: null
  WR_TYPE: null
  WR_STATUS: null
  CASE_VERS: null
  CASE_VERS_TYPE: null
  CASE_ID_SEQ: 0
  CASE_TYPE:
  CASE_NUMBER: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata