{ "currentVersion": 10.8, "id": 6, "name": "TreeKeeperWF.DBO.Maint_tasks", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "task", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "task", "type": "esriFieldTypeString", "alias": "Task", "length": 50, "domain": { "type": "codedValue", "name": "MTNCTASK", "description": "MTNCTASK", "codedValues": [ { "name": "Crown cleaning", "code": "Crown cleaning" }, { "name": "Crown raising", "code": "Crown raising" }, { "name": "Crown reduction or thinning", "code": "Crown reduction or thinning" }, { "name": "Monitor", "code": "Monitor" }, { "name": "None", "code": "None" }, { "name": "Heavy Pruning", "code": "Prune-Hard" }, { "name": "Light Pruning", "code": "Prune-Light" }, { "name": "Remove", "code": "Remove" }, { "name": "Stake small tree", "code": "Stake small tree" }, { "name": "Train small tree", "code": "Train small tree" }, { "name": "Treat pest/disease", "code": "Treat pest/disease" }, { "name": "Water", "code": "Water" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "date_requested", "type": "esriFieldTypeDate", "alias": "Date_Requested", "length": 8, "domain": null }, { "name": "date_completed", "type": "esriFieldTypeDate", "alias": "Date_Completed", "length": 8, "domain": null }, { "name": "guid", "type": "esriFieldTypeGUID", "alias": "GUID", "length": 38, "domain": null }, { "name": "task_recommendation", "type": "esriFieldTypeString", "alias": "Task_Recommendation", "length": 50, "domain": { "type": "codedValue", "name": "MTNCREC", "description": "MTNCREC", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Critical", "code": "Critical" }, { "name": "Immediate", "code": "Immediate" }, { "name": "Routine", "code": "Routine" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "height", "type": "esriFieldTypeSmallInteger", "alias": "Height", "domain": null } ], "indexes": [ { "name": "g40guid", "fields": "guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r28_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_28", "fields": "globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "uuid_oid_28", "fields": "globalid,objectid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "UCF_TreeKeeper", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "GUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }