{
"currentVersion": 11.3,
"cimVersion": "3.3.0",
"id": 4,
"name": "Tree Inspection",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "Hindrance",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "INSPECTIONDATE",
"type": "esriFieldTypeDate",
"alias": "LAST INSPECTED",
"length": 8,
"domain": null
},
{
"name": "GUID",
"type": "esriFieldTypeGUID",
"alias": "GUID",
"length": 38,
"domain": null
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38,
"domain": null
},
{
"name": "Hindrance",
"type": "esriFieldTypeString",
"alias": "Hindrance to Tree",
"length": 50,
"domain": {
"type": "codedValue",
"name": "trHINDRANCE",
"description": "anything in the area that hinders the tree",
"codedValues": [
{
"name": "POWERLINE",
"code": "POWERLINE"
},
{
"name": "BUILDING",
"code": "BUILDING"
},
{
"name": "HYDRANT",
"code": "HYDRANT"
},
{
"name": "OTHER",
"code": "OTHER"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "DBH",
"type": "esriFieldTypeString",
"alias": "Diameter At Breast Height",
"length": 50,
"domain": {
"type": "codedValue",
"name": "trDBH",
"description": "Diameter of the tree at breast height",
"codedValues": [
{
"name": "DBH < 3",
"code": "DBH < 3"
},
{
"name": "DBH 3 - 6",
"code": "DBH 3 - 6"
},
{
"name": "DBH 7 - 12",
"code": "DBH 7 - 12"
},
{
"name": "DBH 13 - 18",
"code": "DBH 13 - 18"
},
{
"name": "DBH 19 -24",
"code": "DBH 19 - 24"
},
{
"name": "DBH 25 - 30",
"code": "DBH 25 - 30"
},
{
"name": "DBH 31 - 36",
"code": "DBH 31 - 36"
},
{
"name": "DBH 37 - 42",
"code": "DBH 37 - 42"
},
{
"name": "DBH > 42",
"code": "DBH > 42"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "Tip_Dieback",
"type": "esriFieldTypeDouble",
"alias": "Tip Dieback (deduct up to .5 point)",
"domain": null
},
{
"name": "TotalCrownCon",
"type": "esriFieldTypeDouble",
"alias": "TotalCrownCon",
"domain": null
},
{
"name": "CrownCondDrpDwn",
"type": "esriFieldTypeString",
"alias": "Crown Condition List",
"length": 50,
"domain": {
"type": "codedValue",
"name": "trCrownConditionRating",
"description": "Crown condition rating for tree inventory",
"codedValues": [
{
"name": "BETWEEN 0 - 1",
"code": "BETWEEN 0 - 1"
},
{
"name": "BETWEEN 1 - 2",
"code": "BETWEEN 1 - 2"
},
{
"name": "BETWEEN 2 - 3",
"code": "BETWEEN 2 - 3"
},
{
"name": "BETWEEN 3 - 4",
"code": "BETWEEN 3 - 4"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ExpsdDecayedWood",
"type": "esriFieldTypeDouble",
"alias": "Exposed/Decayed Wood (Deduct .25pt min)",
"domain": null
},
{
"name": "SproutsSuckers",
"type": "esriFieldTypeDouble",
"alias": "Sprouts/Suckers (Deduct up to .5pts)",
"domain": null
},
{
"name": "IncldbranchUnions",
"type": "esriFieldTypeDouble",
"alias": "Included Branch Unions (up to .5pts)",
"domain": null
},
{
"name": "StemCondTotal",
"type": "esriFieldTypeDouble",
"alias": "Stem Condition Total",
"domain": null
},
{
"name": "Diseased",
"type": "esriFieldTypeString",
"alias": "Diseased",
"length": 50,
"domain": {
"type": "codedValue",
"name": "trDiseased",
"description": "Is the tree diseased",
"codedValues": [
{
"name": "YES",
"code": "YES"
},
{
"name": "NO",
"code": "NO"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "TreeDefects",
"type": "esriFieldTypeString",
"alias": "Tree Defects",
"length": 50,
"domain": {
"type": "codedValue",
"name": "trTreeDefects",
"description": "Tree defects",
"codedValues": [
{
"name": "INCLUDED BARK",
"code": "INCLUDED BARK"
},
{
"name": "CO-DOMINANT LEADERS",
"code": "CO-DOMINANT LEADERS"
},
{
"name": "TIP DIE-BACK",
"code": "TIP DIE-BACK"
},
{
"name": "WOOD DECAY",
"code": "WOOD DECAY"
},
{
"name": "DEADWOOD",
"code": "DEADWOOD"
},
{
"name": "CRACK",
"code": "CRACK"
},
{
"name": "STEM GIRDLING ROOTS",
"code": "STEM GIRDLING ROOTS"
},
{
"name": "CANKER",
"code": "CANKER"
},
{
"name": "LEAN",
"code": "LEAN"
},
{
"name": "CAVITY",
"code": "CAVITY"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ProposedMaint",
"type": "esriFieldTypeString",
"alias": "Proposed Maintenance",
"length": 50,
"domain": {
"type": "codedValue",
"name": "trMaintenanceProposedAct",
"description": "Proposed maint actions for a tree",
"codedValues": [
{
"name": "PRUNING",
"code": "PRUNING"
},
{
"name": "DISEASE TREATMENT",
"code": "DESEASE TREATMENT"
},
{
"name": "REMOVAL",
"code": "REMOVAL"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "MaintTaken",
"type": "esriFieldTypeString",
"alias": "Maintenance Taken",
"length": 50,
"domain": {
"type": "codedValue",
"name": "trMaintenanceTakenAction",
"description": "Performed maint actions",
"codedValues": [
{
"name": "PRUNING",
"code": "PRUNING"
},
{
"name": "DISEASE TREATMENT",
"code": "DISEASE TREATMENT"
},
{
"name": "REMOVED",
"code": "REMOVED"
},
{
"name": "PLANTING",
"code": "PLANTING"
},
{
"name": "DAMAGE ASSESSMENT",
"code": "DAMAGE ASSESSMENT"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "MaintDate",
"type": "esriFieldTypeDate",
"alias": "MaintDate",
"length": 8,
"domain": null
},
{
"name": "Field_Notes",
"type": "esriFieldTypeString",
"alias": "Field Notes",
"length": 500,
"domain": null
},
{
"name": "Office_Notes",
"type": "esriFieldTypeString",
"alias": "Office Notes",
"length": 250,
"domain": null
},
{
"name": "StagHead2",
"type": "esriFieldTypeDouble",
"alias": "Stagheading Deduct up to 1pt",
"domain": null
},
{
"name": "Symmetry2",
"type": "esriFieldTypeDouble",
"alias": "Symmetry deduct up to 1pt",
"domain": null
},
{
"name": "LCR2",
"type": "esriFieldTypeDouble",
"alias": "Live Crown Ratio Deduct up to 2pts",
"domain": null
},
{
"name": "CambrialInteg2",
"type": "esriFieldTypeDouble",
"alias": "Cambrial Integrety Deduct up to 3pts",
"domain": null
},
{
"name": "StemCracks2",
"type": "esriFieldTypeDouble",
"alias": "Stem Cracks Deduct up to 2pts",
"domain": null
},
{
"name": "StemConditionDropDown",
"type": "esriFieldTypeString",
"alias": "Stem Condition",
"length": 50,
"domain": {
"type": "codedValue",
"name": "trStemCondition",
"description": "Condition of the stem of the tree",
"codedValues": [
{
"name": "BETWEEN 0 - 1",
"code": "BETWEEN 0 - 1"
},
{
"name": "BETWEEN 1 - 2",
"code": "BETWEEN 1 - 2"
},
{
"name": "BETWEEN 2 - 3",
"code": "BETWEEN 2 - 3"
},
{
"name": "BETWEEN 3 - 4",
"code": "BETWEEN 3 - 4"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "Defects1",
"type": "esriFieldTypeString",
"alias": "Defects1",
"length": 50,
"domain": {
"type": "codedValue",
"name": "trTreeDefects",
"description": "Tree defects",
"codedValues": [
{
"name": "INCLUDED BARK",
"code": "INCLUDED BARK"
},
{
"name": "CO-DOMINANT LEADERS",
"code": "CO-DOMINANT LEADERS"
},
{
"name": "TIP DIE-BACK",
"code": "TIP DIE-BACK"
},
{
"name": "WOOD DECAY",
"code": "WOOD DECAY"
},
{
"name": "DEADWOOD",
"code": "DEADWOOD"
},
{
"name": "CRACK",
"code": "CRACK"
},
{
"name": "STEM GIRDLING ROOTS",
"code": "STEM GIRDLING ROOTS"
},
{
"name": "CANKER",
"code": "CANKER"
},
{
"name": "LEAN",
"code": "LEAN"
},
{
"name": "CAVITY",
"code": "CAVITY"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "Defects2",
"type": "esriFieldTypeString",
"alias": "Defects2",
"length": 50,
"domain": {
"type": "codedValue",
"name": "trTreeDefects",
"description": "Tree defects",
"codedValues": [
{
"name": "INCLUDED BARK",
"code": "INCLUDED BARK"
},
{
"name": "CO-DOMINANT LEADERS",
"code": "CO-DOMINANT LEADERS"
},
{
"name": "TIP DIE-BACK",
"code": "TIP DIE-BACK"
},
{
"name": "WOOD DECAY",
"code": "WOOD DECAY"
},
{
"name": "DEADWOOD",
"code": "DEADWOOD"
},
{
"name": "CRACK",
"code": "CRACK"
},
{
"name": "STEM GIRDLING ROOTS",
"code": "STEM GIRDLING ROOTS"
},
{
"name": "CANKER",
"code": "CANKER"
},
{
"name": "LEAN",
"code": "LEAN"
},
{
"name": "CAVITY",
"code": "CAVITY"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "Defects3",
"type": "esriFieldTypeString",
"alias": "Defects3",
"length": 50,
"domain": {
"type": "codedValue",
"name": "trTreeDefects",
"description": "Tree defects",
"codedValues": [
{
"name": "INCLUDED BARK",
"code": "INCLUDED BARK"
},
{
"name": "CO-DOMINANT LEADERS",
"code": "CO-DOMINANT LEADERS"
},
{
"name": "TIP DIE-BACK",
"code": "TIP DIE-BACK"
},
{
"name": "WOOD DECAY",
"code": "WOOD DECAY"
},
{
"name": "DEADWOOD",
"code": "DEADWOOD"
},
{
"name": "CRACK",
"code": "CRACK"
},
{
"name": "STEM GIRDLING ROOTS",
"code": "STEM GIRDLING ROOTS"
},
{
"name": "CANKER",
"code": "CANKER"
},
{
"name": "LEAN",
"code": "LEAN"
},
{
"name": "CAVITY",
"code": "CAVITY"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "CrownWdth",
"type": "esriFieldTypeDouble",
"alias": "Crown Width (ft)",
"domain": null
}
],
"indexes": [
{
"name": "R70_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_70",
"fields": "GlobalID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "G400GUID",
"fields": "GUID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "UUID_OID_70",
"fields": "GlobalID,OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [
{
"id": 2,
"name": "City_Trees",
"relatedTableId": 0,
"role": "esriRelRoleDestination",
"keyField": "GUID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": false,
"catalogID": "{8926CFC5-1B5F-49B6-88EB-CC60154C390A}"
}
],
"capabilities": "Map,Query,Data",
"maxRecordCount": 2000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, PBF",
"isDataVersioned": true,
"useStandardizedQueries": true,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": false,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": null,
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"serviceItemId": "b2cf95a7b74b4ecc8d1c435bf3779295"
}