{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 8, "name": "Cases", "type": "Table", "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.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "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": "BOCA_CD", "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": true, "length": 4, "defaultValue": null, "modelName": "BOCA_CD" }, { "name": "WTR_ID", "type": "esriFieldTypeInteger", "alias": "Water Right ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WTR_ID" }, { "name": "WR_NUMBER", "type": "esriFieldTypeString", "alias": "Water Right Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "WR_NUMBER" }, { "name": "WR_TYPE", "type": "esriFieldTypeString", "alias": "Water Right Type", "domain": null, "editable": true, "nullable": true, "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": "CASE_VERS", "type": "esriFieldTypeInteger", "alias": "Case Version", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CASE_VERS" }, { "name": "CASE_VERS_TYPE", "type": "esriFieldTypeString", "alias": "Case Version Type", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CASE_VERS_TYPE" }, { "name": "CASE_ID_SEQ", "type": "esriFieldTypeInteger", "alias": "Case ID Sequence", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "CASE_ID_SEQ" }, { "name": "CASE_TYPE", "type": "esriFieldTypeString", "alias": "Case Type", "domain": null, "editable": true, "nullable": false, "length": 35, "defaultValue": null, "modelName": "CASE_TYPE" }, { "name": "CASE_NUMBER", "type": "esriFieldTypeString", "alias": "Case Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CASE_NUMBER" }, { "name": "CASE_STATUS", "type": "esriFieldTypeString", "alias": "Case Status", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "CASE_STATUS" }, { "name": "REFRESH_DATE", "type": "esriFieldTypeDate", "alias": "Refresh Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REFRESH_DATE" } ], "indexes": [ { "name": "R15_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Cases", "description": "", "prototype": { "attributes": { "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 } }, "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" }