{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 4, "name": "Owners", "type": "Table", "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.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 6, "name": "PUBLIC VERSION Attributes", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "WRGT_ID_SEQ", "composite": false, "catalogID": "{ADE947F6-DE4B-4F3B-ABF8-1459CA85C5B6}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "OWNR_ID_SEQ", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "WRGT_ID_SEQ", "type": "esriFieldTypeInteger", "alias": "Water Right ID Sequence", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "WRGT_ID_SEQ" }, { "name": "BOCA_CD", "type": "esriFieldTypeString", "alias": "Administrative Basin", "domain": null, "editable": true, "nullable": false, "length": 4, "defaultValue": null, "modelName": "BOCA_CD" }, { "name": "WTR_ID", "type": "esriFieldTypeInteger", "alias": "Water Right ID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "WTR_ID" }, { "name": "WR_NUMBER", "type": "esriFieldTypeString", "alias": "Water Right Number", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "WR_NUMBER" }, { "name": "WR_TYPE", "type": "esriFieldTypeString", "alias": "Water Right Type", "domain": null, "editable": true, "nullable": false, "length": 30, "defaultValue": null, "modelName": "WR_TYPE" }, { "name": "WR_STATUS", "type": "esriFieldTypeString", "alias": "Water Right Status", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "WR_STATUS" }, { "name": "VERS", "type": "esriFieldTypeInteger", "alias": "Version", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "VERS" }, { "name": "VERS_TYPE", "type": "esriFieldTypeString", "alias": "Version Type", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "VERS_TYPE" }, { "name": "VERS_CNT", "type": "esriFieldTypeInteger", "alias": "Version Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VERS_CNT" }, { "name": "PRTY_DT_DATE", "type": "esriFieldTypeDate", "alias": "Priority Date Date Format", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PRTY_DT_DATE" }, { "name": "PRTY_DT_CHAR", "type": "esriFieldTypeString", "alias": "Priority Date Character Format", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PRTY_DT_CHAR" }, { "name": "ENF_PRTY_DT_DATE", "type": "esriFieldTypeDate", "alias": "Enforceable Priority Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ENF_PRTY_DT_DATE" }, { "name": "ENF_PRTY_DT_CHAR", "type": "esriFieldTypeString", "alias": "Priority Date", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ENF_PRTY_DT_CHAR" }, { "name": "OWNERS", "type": "esriFieldTypeString", "alias": "Owners", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "OWNERS" }, { "name": "PURPOSES", "type": "esriFieldTypeString", "alias": "Purposes", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "PURPOSES" }, { "name": "SOURCE_TYPES", "type": "esriFieldTypeString", "alias": "Source", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "SOURCE_TYPES" }, { "name": "SOURCE_NAMES", "type": "esriFieldTypeString", "alias": "Source Name", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "SOURCE_NAMES" }, { "name": "MEANS_OF_DIVS", "type": "esriFieldTypeString", "alias": "Means of Diversion", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "MEANS_OF_DIVS" }, { "name": "MAX_FLOW", "type": "esriFieldTypeString", "alias": "Max Flow Rate", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "MAX_FLOW" }, { "name": "MAX_VOL", "type": "esriFieldTypeDouble", "alias": "Maximum Volume", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAX_VOL" }, { "name": "MAX_ACRES", "type": "esriFieldTypeDouble", "alias": "Maximum Acres", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAX_ACRES" }, { "name": "POD_CNT", "type": "esriFieldTypeInteger", "alias": "POD Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POD_CNT" }, { "name": "POU_CNT", "type": "esriFieldTypeInteger", "alias": "POU Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POU_CNT" }, { "name": "IRR_CNT", "type": "esriFieldTypeInteger", "alias": "Irrigation Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IRR_CNT" }, { "name": "RESV_CNT", "type": "esriFieldTypeInteger", "alias": "Reservoir Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RESV_CNT" }, { "name": "DITCHES", "type": "esriFieldTypeString", "alias": "Ditches", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "DITCHES" }, { "name": "GEOCODES", "type": "esriFieldTypeString", "alias": "Geocodes", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "GEOCODES" }, { "name": "POD_COUNTIES", "type": "esriFieldTypeString", "alias": "POD County", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "POD_COUNTIES" }, { "name": "POU_COUNTIES", "type": "esriFieldTypeString", "alias": "POU County", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "POU_COUNTIES" }, { "name": "RESV_COUNTIES", "type": "esriFieldTypeString", "alias": "Reservoir County", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "RESV_COUNTIES" }, { "name": "HIST_TYPE", "type": "esriFieldTypeString", "alias": "Historical Right Type", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "HIST_TYPE" }, { "name": "ISSUE_RMK", "type": "esriFieldTypeString", "alias": "Issue Remark", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "ISSUE_RMK" }, { "name": "ASSOC_RMKS", "type": "esriFieldTypeString", "alias": "Association Remark", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "ASSOC_RMKS" }, { "name": "URL_ABSTRACT", "type": "esriFieldTypeString", "alias": "General Abstract", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "URL_ABSTRACT" }, { "name": "URL_SCAN", "type": "esriFieldTypeString", "alias": "Scanned Documents", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "URL_SCAN" }, { "name": "URL_CHAU_SCAN", "type": "esriFieldTypeString", "alias": "Change Authorization Scanned Documents", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "URL_CHAU_SCAN" }, { "name": "WRKEY", "type": "esriFieldTypeString", "alias": "Water Right Key", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "WRKEY" }, { "name": "OWNR_ID_SEQ", "type": "esriFieldTypeInteger", "alias": "Owner ID Sequence", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "OWNR_ID_SEQ" }, { "name": "CUST_ID_SEQ", "type": "esriFieldTypeInteger", "alias": "Customer ID Sequence", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "CUST_ID_SEQ" }, { "name": "CUST_TYPE", "type": "esriFieldTypeString", "alias": "Customer Type", "domain": null, "editable": true, "nullable": false, "length": 25, "defaultValue": null, "modelName": "CUST_TYPE" }, { "name": "LST_NM_OR_BUSN_NM", "type": "esriFieldTypeString", "alias": "Last Name or Business Name", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LST_NM_OR_BUSN_NM" }, { "name": "FST_NM", "type": "esriFieldTypeString", "alias": "First Name", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FST_NM" }, { "name": "MID_INT", "type": "esriFieldTypeString", "alias": "Middle Initial", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "MID_INT" }, { "name": "SUFX", "type": "esriFieldTypeString", "alias": "Suffix", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "SUFX" }, { "name": "REFRESH_DATE", "type": "esriFieldTypeDate", "alias": "Refresh Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REFRESH_DATE" }, { "name": "MAX_FLOW_RT", "type": "esriFieldTypeDouble", "alias": "Max Flow Rate and Unit", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAX_FLOW_RT" }, { "name": "FLOW_RT_UNIT", "type": "esriFieldTypeString", "alias": "Flow Rate Unit", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "FLOW_RT_UNIT" }, { "name": "MAX_FLOW_GPM", "type": "esriFieldTypeDouble", "alias": "Max Flow GPM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAX_FLOW_GPM" }, { "name": "MAX_FLOW_CFS", "type": "esriFieldTypeDouble", "alias": "Max Flow CFS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAX_FLOW_CFS" }, { "name": "AUM_SUM", "type": "esriFieldTypeDouble", "alias": "Animal Units Sum", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AUM_SUM" }, { "name": "URL_ABSTRACT_2190R", "type": "esriFieldTypeString", "alias": "NOI Abstract", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "URL_ABSTRACT_2190R" } ], "indexes": [ { "name": "R19_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "G8WRGT_ID_SEQ", "isAscending": true, "isUnique": false, "description": "", "fields": "WRGT_ID_SEQ" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Owners", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 10000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 10000, "maxRecordCountFactor": 1, "serviceItemId": "afbfc45dac094639b8920ad530d6bd0b" }