{ "currentVersion": 10.91, "id": 2, "name": "VailGISDB.\"VAILGOV\\SKOENIG\".TreeMonitoring_Assessments", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Tree_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Tree_ID", "type": "esriFieldTypeString", "alias": "Tree ID", "length": 20, "domain": null }, { "name": "Evaluation_Treatment_Year", "type": "esriFieldTypeString", "alias": "Year of Evaluation-Treatment", "length": 10, "domain": { "type": "codedValue", "name": "Year", "description": "Year", "codedValues": [ { "name": "2017", "code": "2017" }, { "name": "2018", "code": "2018" }, { "name": "2019", "code": "2019" }, { "name": "2020", "code": "2020" }, { "name": "2021", "code": "2021" }, { "name": "2022", "code": "2022" }, { "name": "2023", "code": "2023" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Height", "type": "esriFieldTypeSmallInteger", "alias": "Height Ft", "domain": null }, { "name": "Diameter", "type": "esriFieldTypeSmallInteger", "alias": "Diameter Inches", "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Existing Condition", "length": 254, "domain": { "type": "codedValue", "name": "Condition", "description": "Condition of Trees", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Impaired", "code": "Impaired" }, { "name": "Other - See Notes", "code": "Other - See Notes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "DamageDefect", "type": "esriFieldTypeString", "alias": "Damage-Defect", "length": 50, "domain": { "type": "codedValue", "name": "Impaired_DamageDefect2", "description": "Defected Damaged", "codedValues": [ { "name": "None Identified", "code": "None Identified" }, { "name": "Crack", "code": "Crack" }, { "name": "Fork", "code": "Fork" }, { "name": "Girdling Root", "code": "Girdling Root" }, { "name": "Included Bark", "code": "Included Bark" }, { "name": "Mechanical", "code": "Mechanical" }, { "name": "Rot", "code": "Rot" }, { "name": "Sweep", "code": "Sweep" }, { "name": "Other - See Notes", "code": "Other - See Notes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Insect", "type": "esriFieldTypeString", "alias": "Insect", "length": 50, "domain": { "type": "codedValue", "name": "Impaired_Insect", "description": "Insect", "codedValues": [ { "name": "None Identified", "code": "None Identified" }, { "name": "Pine Needle Scale", "code": "Pine Needle Scale" }, { "name": "Bud Scale", "code": "Bud Scale" }, { "name": "Mites", "code": "Mites" }, { "name": "Aphids", "code": "Aphids" }, { "name": "Adelgid", "code": "Adelgid" }, { "name": "Pine Bark Beetle", "code": "Pine Bark Beetle" }, { "name": "Spruce Beetle", "code": "Spruce Beetle" }, { "name": "Other - See Notes", "code": "Other - See Notes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Disease", "type": "esriFieldTypeString", "alias": "Disease", "length": 50, "domain": { "type": "codedValue", "name": "Impaired_Disease", "description": "Disease", "codedValues": [ { "name": "None Identified", "code": "None Identified" }, { "name": "Rust", "code": "Rust" }, { "name": "Cytospora", "code": "Cytospora" }, { "name": "Mechanical", "code": "Mechanical" }, { "name": "Disorder", "code": "Disorder" }, { "name": "Other - See Notes", "code": "Other - See Notes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Treatment_Recommended", "type": "esriFieldTypeString", "alias": "Treatment Recommended", "length": 50, "domain": { "type": "codedValue", "name": "Treatment_Recommended", "description": "Recommended Treatment", "codedValues": [ { "name": "No Treatment", "code": "No Treatment" }, { "name": "Foliar Application", "code": "Foliar Application" }, { "name": "Pheromone Treatment", "code": "Pheromone Treatment" }, { "name": "Prune", "code": "Prune" }, { "name": "Remove", "code": "Remove" }, { "name": "Soil Injection", "code": "Soil Injection" }, { "name": "Trunk Spray", "code": "Trunk Spray" }, { "name": "Multiple Treatments - See Notes", "code": "Multiple Treatments - See Notes" }, { "name": "Other - See Notes", "code": "Other - See Notes" }, { "name": "Monitor", "code": "Monitor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Eval_Notes", "type": "esriFieldTypeString", "alias": "Evaluation Notes", "length": 254, "domain": null }, { "name": "TargetRating", "type": "esriFieldTypeString", "alias": "Target Rating", "length": 50, "domain": null }, { "name": "PotentialFailureRating", "type": "esriFieldTypeString", "alias": "Potential Failure Rating", "length": 50, "domain": null }, { "name": "Treatment_Performed", "type": "esriFieldTypeString", "alias": "Treatment Performed", "length": 50, "domain": { "type": "codedValue", "name": "Treatment_Performed", "description": "Treatment Performed", "codedValues": [ { "name": "No Treatment", "code": "No Treatment" }, { "name": "Foliar Application", "code": "Foliar Application" }, { "name": "Pheromone Treatment", "code": "Pheromone Treatment" }, { "name": "Pruned Tree", "code": "Pruned Tree" }, { "name": "Removed Tree", "code": "Removed Tree" }, { "name": "Soil Injection", "code": "Soil Injection" }, { "name": "Trunk Spray", "code": "Trunk Spray" }, { "name": "Multiple Treatments - See Notes", "code": "Multiple Treatments - See Notes" }, { "name": "Other - See Notes", "code": "Other - See Notes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EvaluationDate", "type": "esriFieldTypeDate", "alias": "Date of Evaluation", "length": 8, "domain": null } ], "indexes": [ { "name": "R64_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_64", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G451Tree_ID", "fields": "Tree_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_64", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Assessments_to_TreeMonitoring", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Tree_ID", "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 }