{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "Public Versions", "type": "Table", "description": "Public Versions - Water Right Query System is the primary summary table of Montana water rights published through the Water Right Query System (WRQS). It contains one record for each water right, representing the single version of that right currently designated as the public version by the WRD business rules. Each record rolls the full version up into a flat, map- and report-ready row: basin and water right number, water right type and status, version type, priority and enforceable priority dates, current owners, purposes of use, source types and names, means of diversion, maximum flow rate (in native units and converted to both gallons per minute and cubic feet per second), maximum volume and acres, animal units, counts of points of diversion, places of use, irrigated places of use and reservoirs, associated ditches and Department of Revenue geocodes, the counties in which the right's features fall, issue and associated remarks, and hyperlinks to the public abstract report, the scanned water right file in FileNet, and the WRQS authorization and case views. The table is non-spatial; join it to WRQS_PODS, WRQS_POUS, or WRQS_RESERVOIRS on WRGT_ID_SEQ or WRKEY to map its contents.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "RESERVOIR Attributes", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "WRKEY", "composite": false, "catalogID": "{823A20AA-0CC1-4097-A7C5-2F3BBD3E4ADB}" }, { "id": 3, "name": "OTHER VERSION Attributes", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "WRGT_ID_SEQ", "composite": false, "catalogID": "{8DD94341-154A-404B-87B1-B56ED6C2BB38}" }, { "id": 0, "name": "POD Attributes", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "WRKEY", "composite": false, "catalogID": "{847AB8F6-33D6-4EDE-888E-9ABD3B0AB7B9}" }, { "id": 4, "name": "CHANGE AUTHORIZATION Attributes", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "WRGT_ID_SEQ", "composite": false, "catalogID": "{1B88B4EB-56A0-4998-84FB-91C46C2295BD}" }, { "id": 5, "name": "GEOCODE Attributes", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "WRGT_ID_SEQ", "composite": false, "catalogID": "{9040BF2B-CB8D-4111-9318-2EE4DB389FB7}" }, { "id": 1, "name": "POU Attributes", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "WRKEY", "composite": false, "catalogID": "{4A4BA683-87DF-46FC-A98C-EEA5F36C3901}" }, { "id": 6, "name": "OWNER Attributes", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "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": "WRGT_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 Date Format", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ENF_PRTY_DT_DATE" }, { "name": "ENF_PRTY_DT_CHAR", "type": "esriFieldTypeString", "alias": "Enforceable priority Date Character Format", "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": "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": "R22_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "G11WRGT_ID_SEQ", "isAscending": true, "isUnique": false, "description": "", "fields": "WRGT_ID_SEQ" }, { "name": "G11WRKEY", "isAscending": true, "isUnique": false, "description": "", "fields": "WRKEY" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Public Versions", "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, "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" }