{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 20, "name": "Live Drinking Water - Water System", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "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, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "", "globalIdField": "", "displayField": "SYSTEM_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "REPORTING_YEAR", "type": "esriFieldTypeString", "alias": "REPORTING_YEAR", "domain": null, "editable": false, "nullable": true, "length": 10, "defaultValue": null, "modelName": "REPORTING_YEAR" }, { "name": "SYSTEM_NAME", "type": "esriFieldTypeString", "alias": "SYSTEM_NAME", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SYSTEM_NAME" }, { "name": "SYSTEM_NUMBER", "type": "esriFieldTypeString", "alias": "SYSTEM_NUMBER", "domain": null, "editable": false, "nullable": true, "length": 64, "defaultValue": null, "modelName": "SYSTEM_NUMBER" }, { "name": "SYSTEM_CATEGORY", "type": "esriFieldTypeString", "alias": "SYSTEM_CATEGORY", "domain": null, "editable": false, "nullable": true, "length": 128, "defaultValue": null, "modelName": "SYSTEM_CATEGORY" }, { "name": "SYSTEM_POPULATION_SERVED", "type": "esriFieldTypeString", "alias": "SYSTEM_POPULATION_SERVED", "domain": null, "editable": false, "nullable": true, "length": 64, "defaultValue": null, "modelName": "SYSTEM_POPULATION_SERVED" }, { "name": "SYSTEM_RAW_WATER_SOURCE", "type": "esriFieldTypeString", "alias": "SYSTEM_RAW_WATER_SOURCE", "domain": null, "editable": false, "nullable": true, "length": 64, "defaultValue": null, "modelName": "SYSTEM_RAW_WATER_SOURCE" }, { "name": "SYSTEM_DISTRIBUTION_WATER_PROF", "type": "esriFieldTypeString", "alias": "SYSTEM_DISTRIBUTION_WATER_PROF", "domain": null, "editable": false, "nullable": true, "length": 128, "defaultValue": null, "modelName": "SYSTEM_DISTRIBUTION_WATER_PROF" }, { "name": "SYSTEM_CLASSIFICATION", "type": "esriFieldTypeString", "alias": "SYSTEM_CLASSIFICATION", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SYSTEM_CLASSIFICATION" }, { "name": "SYSTEM_INTRODUCTION", "type": "esriFieldTypeString", "alias": "SYSTEM_INTRODUCTION", "domain": null, "editable": false, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "SYSTEM_INTRODUCTION" }, { "name": "SYSTEM_TREATMENT_DESCRIPTION", "type": "esriFieldTypeString", "alias": "SYSTEM_TREATMENT_DESCRIPTION", "domain": null, "editable": false, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "SYSTEM_TREATMENT_DESCRIPTION" }, { "name": "RECEIVING_SYSTEMS", "type": "esriFieldTypeString", "alias": "RECEIVING_SYSTEMS", "domain": null, "editable": false, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "RECEIVING_SYSTEMS" }, { "name": "WATER_TREATMENT_CHEMICALS", "type": "esriFieldTypeString", "alias": "WATER_TREATMENT_CHEMICALS", "domain": null, "editable": false, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "WATER_TREATMENT_CHEMICALS" }, { "name": "SYSTEM_MONETARY_EXPENSES", "type": "esriFieldTypeDouble", "alias": "SYSTEM_MONETARY_EXPENSES", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SYSTEM_MONETARY_EXPENSES" }, { "name": "SYSTEM_MONETARY_EXPENSES_DESCR", "type": "esriFieldTypeString", "alias": "SYSTEM_MONETARY_EXPENSES_DESCR", "domain": null, "editable": false, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "SYSTEM_MONETARY_EXPENSES_DESCR" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Live Drinking Water - Water System", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }