{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 8, "name": "Active Work Orders table", "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, "supportsReturningGeometryEnvelope": 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,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "AssetID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "AssetID" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 101, "defaultValue": null, "modelName": "Address" }, { "name": "AssignedTo", "type": "esriFieldTypeString", "alias": "AssignedTo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AssignedTo" }, { "name": "AssignedDate", "type": "esriFieldTypeDate", "alias": "AssignedDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "AssignedDate" }, { "name": "MaintStatus", "type": "esriFieldTypeString", "alias": "MaintStatus", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "MaintStatus" }, { "name": "MaintType", "type": "esriFieldTypeString", "alias": "MaintType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MaintType" }, { "name": "CB_HouseDrop", "type": "esriFieldTypeString", "alias": "CB_HouseDrop", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CB_HouseDrop" }, { "name": "CB_SecWire", "type": "esriFieldTypeString", "alias": "CB_SecWire", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CB_SecWire" }, { "name": "WireClearance", "type": "esriFieldTypeString", "alias": "WireClearance", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "WireClearance" }, { "name": "Deadwood", "type": "esriFieldTypeString", "alias": "Deadwood", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Deadwood" }, { "name": "LimbRemoval", "type": "esriFieldTypeString", "alias": "LimbRemoval", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "LimbRemoval" }, { "name": "Stubs", "type": "esriFieldTypeString", "alias": "Stubs", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Stubs" }, { "name": "CB_Fence", "type": "esriFieldTypeString", "alias": "CB_Fence", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CB_Fence" }, { "name": "CB_House", "type": "esriFieldTypeString", "alias": "CB_House", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CB_House" }, { "name": "CB_lawn", "type": "esriFieldTypeString", "alias": "CB_lawn", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CB_lawn" }, { "name": "CB_Property", "type": "esriFieldTypeString", "alias": "CB_Property", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CB_Property" }, { "name": "CB_Roof", "type": "esriFieldTypeString", "alias": "CB_Roof", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CB_Roof" }, { "name": "CB_Tree", "type": "esriFieldTypeString", "alias": "CB_Tree", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CB_Tree" }, { "name": "Sucker", "type": "esriFieldTypeString", "alias": "Sucker", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Sucker" }, { "name": "ThinCrown", "type": "esriFieldTypeString", "alias": "ThinCrown", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "ThinCrown" }, { "name": "UpBranch", "type": "esriFieldTypeString", "alias": "UpBranch", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "UpBranch" }, { "name": "Deferred", "type": "esriFieldTypeString", "alias": "Deferred", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Deferred" }, { "name": "RouteSection", "type": "esriFieldTypeSmallInteger", "alias": "RouteSection", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RouteSection" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "Active Work Orders table", "description": "", "prototype": { "attributes": { "RouteSection": null, "AssetID": null, "Address": null, "AssignedTo": null, "AssignedDate": null, "MaintStatus": null, "MaintType": null, "CB_HouseDrop": null, "CB_SecWire": null, "WireClearance": null, "Deadwood": null, "LimbRemoval": null, "Stubs": null, "CB_Fence": null, "CB_House": null, "CB_lawn": null, "CB_Property": null, "CB_Roof": null, "CB_Tree": null, "Sucker": null, "ThinCrown": null, "UpBranch": null, "Deferred": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "3ddc512a5c694ae3a9e68169666d36fd" }