{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 1,
 "name": "SDE.DBO.veDefect",
 "type": "Table",
 "description": "This standalone table relates the City ID to a Feature ID which shows the tree defect.",
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "COGID",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "TREEDEFECT",
   "type": "esriFieldTypeString",
   "alias": "Defect",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "veDefects",
    "description": "Defects of the tree.",
    "codedValues": [
     {
      "name": "Basal Decay",
      "code": "BasalDecay"
     },
     {
      "name": "Branch Broken",
      "code": "BranchBroken"
     },
     {
      "name": "Branch Tear",
      "code": "BranchTear"
     },
     {
      "name": "Broken Top",
      "code": "BrokenTop"
     },
     {
      "name": "Crack",
      "code": "Crack"
     },
     {
      "name": "Crown Decay",
      "code": "CrownDecay"
     },
     {
      "name": "Crown Wound",
      "code": "CrownWound"
     },
     {
      "name": "Dead Top",
      "code": "DeadTop"
     },
     {
      "name": "Deadwood",
      "code": "Deadwood"
     },
     {
      "name": "Dieback Major",
      "code": "DiebackMajor"
     },
     {
      "name": "Dieback Minor",
      "code": "DiebackMinor"
     },
     {
      "name": "Disease",
      "code": "Disease"
     },
     {
      "name": "Included Bark",
      "code": "IncludedBark"
     },
     {
      "name": "Lean",
      "code": "Lean"
     },
     {
      "name": "Restricted",
      "code": "Restricted"
     },
     {
      "name": "Root Collar",
      "code": "RootCollar"
     },
     {
      "name": "Storm Damage",
      "code": "StormDamage"
     },
     {
      "name": "Topped",
      "code": "Topped"
     },
     {
      "name": "Trunk Decay",
      "code": "TrunkDecay"
     },
     {
      "name": "Utility",
      "code": "Utility"
     },
     {
      "name": "Detached Bark",
      "code": "DetachedBark"
     },
     {
      "name": "Basal Damage",
      "code": "BasalDamage"
     },
     {
      "name": "Insects",
      "code": "Insects"
     },
     {
      "name": "Foreign Object",
      "code": "ForeignObject"
     },
     {
      "name": "Girdling",
      "code": "Girdling"
     },
     {
      "name": "Hanging Branch",
      "code": "HangingBranch"
     },
     {
      "name": "Trunk Damage",
      "code": "TrunkDamage"
     },
     {
      "name": "Root Damage",
      "code": "RootDamage"
     },
     {
      "name": "Codominant Stem",
      "code": "CodominantStem"
     },
     {
      "name": "Sidewalk",
      "code": "Sidewalk"
     },
     {
      "name": "One Sided",
      "code": "OneSided"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DEFECTDATE",
   "type": "esriFieldTypeDate",
   "alias": "Defect Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "REL_GLOBALID",
   "type": "esriFieldTypeGUID",
   "alias": "Parent ID",
   "length": 38,
   "domain": null
  },
  {
   "name": "COMMENT",
   "type": "esriFieldTypeString",
   "alias": "GIS Comment",
   "length": 100,
   "domain": null
  },
  {
   "name": "COGID",
   "type": "esriFieldTypeString",
   "alias": "City ID",
   "length": 38,
   "domain": null
  },
  {
   "name": "FeatureID",
   "type": "esriFieldTypeString",
   "alias": "Feature ID",
   "length": 38,
   "domain": null
  },
  {
   "name": "LASTUPDATE",
   "type": "esriFieldTypeDate",
   "alias": "Last Update Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "LASTEDITOR",
   "type": "esriFieldTypeString",
   "alias": "Last Editor",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "veEditors",
    "description": "Editor List For Trees",
    "codedValues": [
     {
      "name": "Wendy Clements",
      "code": "Wendy"
     },
     {
      "name": "Micaiah Huff",
      "code": "Micaiah"
     },
     {
      "name": "Janie Kuntz",
      "code": "Janie"
     },
     {
      "name": "Adan Aguilar",
      "code": "Adan"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R18481_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_116689_REL_G",
   "fields": "REL_GLOBALID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 1,
   "name": "tree...",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "REL_GLOBALID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{4F668411-EA5A-417A-8B56-92A85DEA0399}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "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": {
  "timeZone": "Mountain Standard Time",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": false,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "1212b1b6946b4e318201c01a58578314"
}