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

Copyright Text: null

Default Visibility: false

MaxRecordCount: 10000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

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

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata