Name: Owners

Display Field: OWNR_ID_SEQ

Type: Table

Geometry Type: N/A

Description: Owners - Water Right Query System is the owner index behind water right owner search in the Water Right Query System. It contains one record for each current owner of the public version of each Montana water right, so a right held by multiple owners produces multiple records. Owner names are carried in parsed form - last name or business name, first name, middle initial, and suffix - along with the customer type (individual, business, or government entity) and the internal ownership and customer identifiers, which makes the table usable for exact-match, partial-match, and grouped owner queries. Each record also repeats the full summary attribution of the parent water right, including basin and water right number, type and status, priority dates, purposes, sources, quantities, counties, remarks, and abstract, scan, authorization, and case links, so an owner search can return complete results without a further join. The table is non-spatial.

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: false, length: 4, defaultValue: null, modelName: BOCA_CD )
• WTR_ID ( type: esriFieldTypeInteger, alias: Water Right ID, editable: true, nullable: false, defaultValue: null, modelName: WTR_ID )
• WR_NUMBER ( type: esriFieldTypeString, alias: Water Right Number, editable: true, nullable: false, length: 20, defaultValue: null, modelName: WR_NUMBER )
• WR_TYPE ( type: esriFieldTypeString, alias: Water Right Type, editable: true, nullable: false, 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 )
• VERS ( type: esriFieldTypeInteger, alias: Version, editable: true, nullable: false, defaultValue: null, modelName: VERS )
• VERS_TYPE ( type: esriFieldTypeString, alias: Version Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VERS_TYPE )
• VERS_CNT ( type: esriFieldTypeInteger, alias: Version Count, editable: true, nullable: true, defaultValue: null, modelName: VERS_CNT )
• PRTY_DT_DATE ( type: esriFieldTypeDate, alias: Priority Date Date Format, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PRTY_DT_DATE )
• PRTY_DT_CHAR ( type: esriFieldTypeString, alias: Priority Date Character Format, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PRTY_DT_CHAR )
• ENF_PRTY_DT_DATE ( type: esriFieldTypeDate, alias: Enforceable Priority Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ENF_PRTY_DT_DATE )
• ENF_PRTY_DT_CHAR ( type: esriFieldTypeString, alias: Priority Date, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ENF_PRTY_DT_CHAR )
• OWNERS ( type: esriFieldTypeString, alias: Owners, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: OWNERS )
• PURPOSES ( type: esriFieldTypeString, alias: Purposes, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: PURPOSES )
• SOURCE_TYPES ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: SOURCE_TYPES )
• SOURCE_NAMES ( type: esriFieldTypeString, alias: Source Name, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: SOURCE_NAMES )
• MEANS_OF_DIVS ( type: esriFieldTypeString, alias: Means of Diversion, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: MEANS_OF_DIVS )
• MAX_FLOW ( type: esriFieldTypeString, alias: Max Flow Rate, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MAX_FLOW )
• MAX_VOL ( type: esriFieldTypeDouble, alias: Maximum Volume, editable: true, nullable: true, defaultValue: null, modelName: MAX_VOL )
• MAX_ACRES ( type: esriFieldTypeDouble, alias: Maximum Acres, editable: true, nullable: true, defaultValue: null, modelName: MAX_ACRES )
• POD_CNT ( type: esriFieldTypeInteger, alias: POD Count, editable: true, nullable: true, defaultValue: null, modelName: POD_CNT )
• POU_CNT ( type: esriFieldTypeInteger, alias: POU Count, editable: true, nullable: true, defaultValue: null, modelName: POU_CNT )
• IRR_CNT ( type: esriFieldTypeInteger, alias: Irrigation Count, editable: true, nullable: true, defaultValue: null, modelName: IRR_CNT )
• RESV_CNT ( type: esriFieldTypeInteger, alias: Reservoir Count, editable: true, nullable: true, defaultValue: null, modelName: RESV_CNT )
• DITCHES ( type: esriFieldTypeString, alias: Ditches, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: DITCHES )
• GEOCODES ( type: esriFieldTypeString, alias: Geocodes, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: GEOCODES )
• POD_COUNTIES ( type: esriFieldTypeString, alias: POD County, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: POD_COUNTIES )
• POU_COUNTIES ( type: esriFieldTypeString, alias: POU County, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: POU_COUNTIES )
• RESV_COUNTIES ( type: esriFieldTypeString, alias: Reservoir County, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: RESV_COUNTIES )
• HIST_TYPE ( type: esriFieldTypeString, alias: Historical Right Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HIST_TYPE )
• ISSUE_RMK ( type: esriFieldTypeString, alias: Issue Remark, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ISSUE_RMK )
• ASSOC_RMKS ( type: esriFieldTypeString, alias: Association Remark, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: ASSOC_RMKS )
• URL_ABSTRACT ( type: esriFieldTypeString, alias: General Abstract, editable: true, nullable: true, length: 500, defaultValue: null, modelName: URL_ABSTRACT )
• URL_SCAN ( type: esriFieldTypeString, alias: Scanned Documents, editable: true, nullable: true, length: 500, defaultValue: null, modelName: URL_SCAN )
• URL_CHAU_SCAN ( type: esriFieldTypeString, alias: Change Authorization Scanned Documents, editable: true, nullable: true, length: 500, defaultValue: null, modelName: URL_CHAU_SCAN )
• WRKEY ( type: esriFieldTypeString, alias: Water Right Key, editable: true, nullable: true, length: 15, defaultValue: null, modelName: WRKEY )
• OWNR_ID_SEQ ( type: esriFieldTypeInteger, alias: Owner ID Sequence, editable: true, nullable: false, defaultValue: null, modelName: OWNR_ID_SEQ )
• CUST_ID_SEQ ( type: esriFieldTypeInteger, alias: Customer ID Sequence, editable: true, nullable: false, defaultValue: null, modelName: CUST_ID_SEQ )
• CUST_TYPE ( type: esriFieldTypeString, alias: Customer Type, editable: true, nullable: false, length: 25, defaultValue: null, modelName: CUST_TYPE )
• LST_NM_OR_BUSN_NM ( type: esriFieldTypeString, alias: Last Name or Business Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LST_NM_OR_BUSN_NM )
• FST_NM ( type: esriFieldTypeString, alias: First Name, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FST_NM )
• MID_INT ( type: esriFieldTypeString, alias: Middle Initial, editable: true, nullable: true, length: 2, defaultValue: null, modelName: MID_INT )
• SUFX ( type: esriFieldTypeString, alias: Suffix, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SUFX )
• REFRESH_DATE ( type: esriFieldTypeDate, alias: Refresh Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REFRESH_DATE )
• MAX_FLOW_RT ( type: esriFieldTypeDouble, alias: Max Flow Rate and Unit, editable: true, nullable: true, defaultValue: null, modelName: MAX_FLOW_RT )
• FLOW_RT_UNIT ( type: esriFieldTypeString, alias: Flow Rate Unit, editable: true, nullable: true, length: 3, defaultValue: null, modelName: FLOW_RT_UNIT )
• MAX_FLOW_GPM ( type: esriFieldTypeDouble, alias: Max Flow GPM, editable: true, nullable: true, defaultValue: null, modelName: MAX_FLOW_GPM )
• MAX_FLOW_CFS ( type: esriFieldTypeDouble, alias: Max Flow CFS, editable: true, nullable: true, defaultValue: null, modelName: MAX_FLOW_CFS )
• AUM_SUM ( type: esriFieldTypeDouble, alias: Animal Units Sum, editable: true, nullable: true, defaultValue: null, modelName: AUM_SUM )
• URL_ABSTRACT_2190R ( type: esriFieldTypeString, alias: NOI Abstract, editable: true, nullable: true, length: 500, defaultValue: null, modelName: URL_ABSTRACT_2190R )

Templates:

• Name: Owners
  Description:
  Prototype:
  AUM_SUM: null
  WRGT_ID_SEQ: 0
  BOCA_CD:
  WTR_ID: 0
  WR_NUMBER:
  WR_TYPE:
  WR_STATUS: null
  VERS: 0
  VERS_TYPE: null
  VERS_CNT: null
  PRTY_DT_DATE: null
  PRTY_DT_CHAR: null
  ENF_PRTY_DT_DATE: null
  ENF_PRTY_DT_CHAR: null
  OWNERS: null
  PURPOSES: null
  SOURCE_TYPES: null
  SOURCE_NAMES: null
  MEANS_OF_DIVS: null
  MAX_FLOW: null
  MAX_VOL: null
  MAX_ACRES: null
  POD_CNT: null
  POU_CNT: null
  IRR_CNT: null
  RESV_CNT: null
  DITCHES: null
  GEOCODES: null
  POD_COUNTIES: null
  POU_COUNTIES: null
  RESV_COUNTIES: null
  HIST_TYPE: null
  ISSUE_RMK: null
  ASSOC_RMKS: null
  URL_ABSTRACT: null
  URL_SCAN: null
  URL_CHAU_SCAN: null
  WRKEY: null
  OWNR_ID_SEQ: 0
  CUST_ID_SEQ: 0
  CUST_TYPE:
  LST_NM_OR_BUSN_NM: null
  FST_NM: null
  MID_INT: null
  SUFX: null
  REFRESH_DATE: null
  MAX_FLOW_RT: null
  FLOW_RT_UNIT: null
  MAX_FLOW_GPM: null
  MAX_FLOW_CFS: null
  URL_ABSTRACT_2190R: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PUBLIC VERSION Attributes (6) -- Related To: Public Versions (0)

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   Query Related Records   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata