{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "WaterCons20_23", "type": "Table", "description": "", "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, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "ACCOUNTID", "type": "esriFieldTypeString", "alias": "ACCOUNTID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "ACCOUNTID" }, { "name": "SERVICETYPE", "type": "esriFieldTypeString", "alias": "SERVICETYPE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SERVICETYPE" }, { "name": "JAN20", "type": "esriFieldTypeDouble", "alias": "JAN20", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JAN20" }, { "name": "FEB20", "type": "esriFieldTypeDouble", "alias": "FEB20", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FEB20" }, { "name": "MAR20", "type": "esriFieldTypeDouble", "alias": "MAR20", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAR20" }, { "name": "APR20", "type": "esriFieldTypeDouble", "alias": "APR20", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "APR20" }, { "name": "MAY20", "type": "esriFieldTypeDouble", "alias": "MAY20", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAY20" }, { "name": "JUN20", "type": "esriFieldTypeDouble", "alias": "JUN20", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JUN20" }, { "name": "JUL20", "type": "esriFieldTypeDouble", "alias": "JUL20", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JUL20" }, { "name": "AUG20", "type": "esriFieldTypeDouble", "alias": "AUG20", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AUG20" }, { "name": "SEP20", "type": "esriFieldTypeDouble", "alias": "SEP20", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SEP20" }, { "name": "OCT20", "type": "esriFieldTypeDouble", "alias": "OCT20", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OCT20" }, { "name": "NOV20", "type": "esriFieldTypeDouble", "alias": "NOV20", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NOV20" }, { "name": "DEC20", "type": "esriFieldTypeDouble", "alias": "DEC20", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEC20" }, { "name": "JAN21", "type": "esriFieldTypeDouble", "alias": "JAN21", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JAN21" }, { "name": "FEB21", "type": "esriFieldTypeDouble", "alias": "FEB21", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FEB21" }, { "name": "MAR21", "type": "esriFieldTypeDouble", "alias": "MAR21", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAR21" }, { "name": "APR21", "type": "esriFieldTypeDouble", "alias": "APR21", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "APR21" }, { "name": "MAY21", "type": "esriFieldTypeDouble", "alias": "MAY21", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAY21" }, { "name": "JUN21", "type": "esriFieldTypeDouble", "alias": "JUN21", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JUN21" }, { "name": "JUL21", "type": "esriFieldTypeDouble", "alias": "JUL21", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JUL21" }, { "name": "AUG21", "type": "esriFieldTypeDouble", "alias": "AUG21", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AUG21" }, { "name": "SEP21", "type": "esriFieldTypeDouble", "alias": "SEP21", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SEP21" }, { "name": "OCT21", "type": "esriFieldTypeDouble", "alias": "OCT21", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OCT21" }, { "name": "NOV21", "type": "esriFieldTypeDouble", "alias": "NOV21", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NOV21" }, { "name": "DEC21", "type": "esriFieldTypeDouble", "alias": "DEC21", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEC21" }, { "name": "JAN22", "type": "esriFieldTypeDouble", "alias": "JAN22", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JAN22" }, { "name": "FEB22", "type": "esriFieldTypeDouble", "alias": "FEB22", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FEB22" }, { "name": "MAR22", "type": "esriFieldTypeDouble", "alias": "MAR22", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAR22" }, { "name": "APR22", "type": "esriFieldTypeDouble", "alias": "APR22", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "APR22" }, { "name": "MAY22", "type": "esriFieldTypeDouble", "alias": "MAY22", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAY22" }, { "name": "JUN22", "type": "esriFieldTypeDouble", "alias": "JUN22", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JUN22" }, { "name": "JUL22", "type": "esriFieldTypeDouble", "alias": "JUL22", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JUL22" }, { "name": "AUG22", "type": "esriFieldTypeDouble", "alias": "AUG22", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AUG22" }, { "name": "SEP22", "type": "esriFieldTypeDouble", "alias": "SEP22", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SEP22" }, { "name": "OCT22", "type": "esriFieldTypeDouble", "alias": "OCT22", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OCT22" }, { "name": "NOV22", "type": "esriFieldTypeDouble", "alias": "NOV22", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NOV22" }, { "name": "DEC22", "type": "esriFieldTypeDouble", "alias": "DEC22", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEC22" }, { "name": "JAN23", "type": "esriFieldTypeDouble", "alias": "JAN23", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JAN23" }, { "name": "TOT23", "type": "esriFieldTypeDouble", "alias": "TOT23", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOT23" }, { "name": "TOT20", "type": "esriFieldTypeDouble", "alias": "TOT20", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOT20" }, { "name": "TOT21", "type": "esriFieldTypeDouble", "alias": "TOT21", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOT21" }, { "name": "TOT22", "type": "esriFieldTypeDouble", "alias": "TOT22", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOT22" }, { "name": "FEB23", "type": "esriFieldTypeDouble", "alias": "FEB23", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FEB23" }, { "name": "MAR23", "type": "esriFieldTypeDouble", "alias": "MAR23", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAR23" }, { "name": "APR23", "type": "esriFieldTypeDouble", "alias": "APR23", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "APR23" }, { "name": "MAY23", "type": "esriFieldTypeDouble", "alias": "MAY23", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAY23" }, { "name": "JUN23", "type": "esriFieldTypeDouble", "alias": "JUN23", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JUN23" }, { "name": "AUG23", "type": "esriFieldTypeDouble", "alias": "AUG23", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AUG23" }, { "name": "JUL23", "type": "esriFieldTypeDouble", "alias": "JUL23", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JUL23" }, { "name": "SEP23", "type": "esriFieldTypeDouble", "alias": "SEP23", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SEP23" }, { "name": "OCT23", "type": "esriFieldTypeDouble", "alias": "OCT23", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OCT23" }, { "name": "NOV23", "type": "esriFieldTypeDouble", "alias": "NOV23", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NOV23" }, { "name": "DEC23", "type": "esriFieldTypeDouble", "alias": "DEC23", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEC23" } ], "indexes": [ { "name": "R228_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_584_ACCOUNTI", "fields": "ACCOUNTID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "WaterCons20_23", "description": "", "prototype": { "attributes": { "NOV23": null, "DEC23": null, "FACILITYID": null, "ACCOUNTID": null, "SERVICETYPE": null, "JAN20": null, "FEB20": null, "MAR20": null, "APR20": null, "MAY20": null, "JUN20": null, "JUL20": null, "AUG20": null, "SEP20": null, "OCT20": null, "NOV20": null, "DEC20": null, "JAN21": null, "FEB21": null, "MAR21": null, "APR21": null, "MAY21": null, "JUN21": null, "JUL21": null, "AUG21": null, "SEP21": null, "OCT21": null, "NOV21": null, "DEC21": null, "JAN22": null, "FEB22": null, "MAR22": null, "APR22": null, "MAY22": null, "JUN22": null, "JUL22": null, "AUG22": null, "SEP22": null, "OCT22": null, "NOV22": null, "DEC22": null, "JAN23": null, "TOT23": null, "TOT20": null, "TOT21": null, "TOT22": null, "FEB23": null, "MAR23": null, "APR23": null, "MAY23": null, "JUN23": null, "AUG23": null, "JUL23": null, "SEP23": null, "OCT23": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "57baa80ad74d4ba39a8a0e1bce30b9c6" }