{
 "currentVersion": 10.71,
 "cimVersion": "2.4.0",
 "id": 1,
 "name": "Street Tree Reports",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "name",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "Report_ID",
   "type": "esriFieldTypeString",
   "alias": "Report ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "submit_date",
   "type": "esriFieldTypeDate",
   "alias": "Date Submitted",
   "length": 8,
   "domain": null
  },
  {
   "name": "treeCommName",
   "type": "esriFieldTypeString",
   "alias": "Tree Common Name",
   "length": 500,
   "domain": {
    "type": "codedValue",
    "name": "SPCIES",
    "description": "SPCIES",
    "codedValues": [
     {
      "name": "ABIES FRASERI (FRASER FIR)",
      "code": "ABIES FRASERI (FRASER FIR)"
     },
     {
      "name": "ACER NEGUNDO (MANITOBA MAPLE)",
      "code": "ACER NEGUNDO (MANITOBA MAPLE)"
     },
     {
      "name": "ACER PLATANOIDES (NORWAY MAPLE)",
      "code": "ACER PLATANOIDES (NORWAY MAPLE)"
     },
     {
      "name": "ACER RUBRUM (RED MAPLE)",
      "code": "ACER RUBRUM (RED MAPLE)"
     },
     {
      "name": "ACER SACCHARINUM (SILVER MAPLE)",
      "code": "ACER SACCHARINUM (SILVER MAPLE)"
     },
     {
      "name": "ACER SACCHARUM (SUGAR MAPLE)",
      "code": "ACER SACCHARUM (SUGAR MAPLE)"
     },
     {
      "name": "AESCULUS GLABRA (OHIO BUCKEYE)",
      "code": "AESCULUS GLABRA (OHIO BUCKEYE)"
     },
     {
      "name": "AESCULUS HIPPOCASTANUM (HORSECHESTNUT)",
      "code": "AESCULUS HIPPOCASTANUM (HORSECHESTNUT)"
     },
     {
      "name": "AMELANCHIER SPP.",
      "code": "AMELANCHIER SPP."
     },
     {
      "name": "BETULA PAPYRIFERA (WHITE BIRCH)",
      "code": "BETULA PAPYRIFERA (WHITE BIRCH)"
     },
     {
      "name": "CELTIS OCCIDENTALIS (NATIVE HACKBERRY)",
      "code": "CELTIS OCCIDENTALIS (NATIVE HACKBERRY)"
     },
     {
      "name": "FRAXINUS SPP. (ASH SPECIES)",
      "code": "FRAXINUS SPP. (ASH SPECIES)"
     },
     {
      "name": "GINKGO BILOBA (GINKGO)",
      "code": "GINKGO BILOBA (GINKGO)"
     },
     {
      "name": "GLEDITSIA TRIACANTHOS (HONEY LOCUST)",
      "code": "GLEDITSIA TRIACANTHOS (HONEY LOCUST)"
     },
     {
      "name": "GYMNOCLADUS DIOICUS (KENTUCKY COFFEE TREE)",
      "code": "GYMNOCLADUS DIOICUS (KENTUCKY COFFEE TREE)"
     },
     {
      "name": "JUGLANS NIGRA (BLACK WALNUT)",
      "code": "JUGLANS NIGRA (BLACK WALNUT)"
     },
     {
      "name": "JUNIPERUS VIRGINIANA (EASTERN RED CEDAR)",
      "code": "JUNIPERUS VIRGINIANA (EASTERN RED CEDAR)"
     },
     {
      "name": "LARIX DECIDUA (EUROPEAN LARCH)",
      "code": "LARIX DECIDUA (EUROPEAN LARCH)"
     },
     {
      "name": "LIRIODENDRON TULIPIFERA (TULIP TREE)",
      "code": "LIRIODENDRON TULIPIFERA (TULIP TREE)"
     },
     {
      "name": "MALUS SPP. (APPLE SPECIES)",
      "code": "MALUS SPP. (APPLE SPECIES)"
     },
     {
      "name": "PICEA ABIES (NORWAY SPRUCE)",
      "code": "PICEA ABIES (NORWAY SPRUCE)"
     },
     {
      "name": "PICEA GLAUCA (WHITE SPRUCE)",
      "code": "PICEA GLAUCA (WHITE SPRUCE)"
     },
     {
      "name": "PICEA PUNGENS (COLORADO BLUE SPRUCE)",
      "code": "PICEA PUNGENS (COLORADO BLUE SPRUCE)"
     },
     {
      "name": "PINUS BANKSIANA (JACK PINE)",
      "code": "PINUS BANKSIANA (JACK PINE)"
     },
     {
      "name": "PINUS NIGRA (AUSTRIAN PINE)",
      "code": "PINUS NIGRA (AUSTRIAN PINE)"
     },
     {
      "name": "POPULUS SPP. (POPLAR SPECIES)",
      "code": "POPULUS SPP. (POPLAR SPECIES)"
     },
     {
      "name": "PRUNUS SPP. (CHERRY SPECIES)",
      "code": "PRUNUS SPP. (CHERRY SPECIES)"
     },
     {
      "name": "PRUNUS VIRGINIANA (CHOKE CHERRY)",
      "code": "PRUNUS VIRGINIANA (CHOKE CHERRY)"
     },
     {
      "name": "PYRUS CALLERYANA (PEAR)",
      "code": "PYRUS CALLERYANA (PEAR)"
     },
     {
      "name": "QUERCUS ALBA (WHITE OAK)",
      "code": "QUERCUS ALBA (WHITE OAK)"
     },
     {
      "name": "QUERCUS BICOLOR (SWAMP WHITE OAK)",
      "code": "QUERCUS BICOLOR (SWAMP WHITE OAK)"
     },
     {
      "name": "QUERCUS MACROCARPA (BUR OAK)",
      "code": "QUERCUS MACROCARPA (BUR OAK)"
     },
     {
      "name": "QUERCUS PALUSTRIS (PIN OAK)",
      "code": "QUERCUS PALUSTRIS (PIN OAK)"
     },
     {
      "name": "QUERCUS ROBUR (ENGLISH OAK)",
      "code": "QUERCUS ROBUR (ENGLISH OAK)"
     },
     {
      "name": "QUERCUS RUBRA (RED OAK)",
      "code": "QUERCUS RUBRA (RED OAK)"
     },
     {
      "name": "ROBINIA PSEUDOACACIA (BLACK LOCUST (PURPLE ROBE))",
      "code": "ROBINIA PSEUDOACACIA (BLACK LOCUST (PURPLE ROBE))"
     },
     {
      "name": "SORBUS AMERICANA (AMERICAN MOUNTAIN ASH)",
      "code": "SORBUS AMERICANA (AMERICAN MOUNTAIN ASH)"
     },
     {
      "name": "SORBUS AUCUPARIA (EUROPEAN MOUNTAIN ASH)",
      "code": "SORBUS AUCUPARIA (EUROPEAN MOUNTAIN ASH)"
     },
     {
      "name": "SORBUS SPP. (MOUNTAIN ASH SPECIES)",
      "code": "SORBUS SPP. (MOUNTAIN ASH SPECIES)"
     },
     {
      "name": "SYNINGA SPP.",
      "code": "SYNINGA SPP."
     },
     {
      "name": "SYRINGA RETICULATA (TREE LILAC)",
      "code": "SYRINGA RETICULATA (TREE LILAC)"
     },
     {
      "name": "THUJA OCCIDENTALIS (EASTERN WHITE CEDAR)",
      "code": "THUJA OCCIDENTALIS (EASTERN WHITE CEDAR)"
     },
     {
      "name": "TILIA CORDATA (LITTLELEAF LINDEN)",
      "code": "TILIA CORDATA (LITTLELEAF LINDEN)"
     },
     {
      "name": "ULMUS AMERICANA (WHITE ELM)",
      "code": "ULMUS AMERICANA (WHITE ELM)"
     },
     {
      "name": "ULMUS PUMILA (SIBERIAN ELM)",
      "code": "ULMUS PUMILA (SIBERIAN ELM)"
     },
     {
      "name": "ULMUS SPP. (ELM SPECIES)",
      "code": "ULMUS SPP. (ELM SPECIES)"
     },
     {
      "name": "UNIDENTIFIED SPECIES",
      "code": "UNIDENTIFIED SPECIES"
     },
     {
      "name": "CRATAEGUS (HAWTHRONE SPECIES)",
      "code": "CRATAEGUS (HAWTHRONE SPECIES)"
     },
     {
      "name": "PLATANUS OCCIDENTALIS (LONDON PLANE SPECIES)",
      "code": "PLATANUS OCCIDENTALIS (LONDON PLANE SPECIES)"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "TREENUMB",
   "type": "esriFieldTypeInteger",
   "alias": "Tree Number",
   "domain": null
  },
  {
   "name": "Address",
   "type": "esriFieldTypeString",
   "alias": "Address",
   "length": 255,
   "domain": null
  },
  {
   "name": "message",
   "type": "esriFieldTypeString",
   "alias": "Message",
   "length": 250,
   "domain": null
  },
  {
   "name": "Concern",
   "type": "esriFieldTypeString",
   "alias": "Concern",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "treeConcern",
    "description": "",
    "codedValues": [
     {
      "name": "Hanging Branch",
      "code": "Hanging Branch"
     },
     {
      "name": "Overgrown",
      "code": "Overgrown"
     },
     {
      "name": "Dead",
      "code": "Dead"
     },
     {
      "name": "Pest Infestation",
      "code": "Pest Infestation"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Planting",
      "code": "Planting"
     },
     {
      "name": "Stump Removal",
      "code": "Stump Removal"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "RecTreat",
   "type": "esriFieldTypeString",
   "alias": "Recommended Treatment",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "treeMaintType",
    "description": "",
    "codedValues": [
     {
      "name": "Assessment",
      "code": "Assessment"
     },
     {
      "name": "Mulching",
      "code": "Mulching"
     },
     {
      "name": "Reinstatement",
      "code": "Reinstatement"
     },
     {
      "name": "Removal - Ash Removal",
      "code": "Removal - Ash Removal"
     },
     {
      "name": "Removal - Basic Removal",
      "code": "Removal - Basic Removal"
     },
     {
      "name": "Removal - Stump Removal",
      "code": "Removal - Stump Removal"
     },
     {
      "name": "Trimming - Deadwood",
      "code": "Trimming - Deadwood"
     },
     {
      "name": "Trimming - Elevation",
      "code": "Trimming - Elevation"
     },
     {
      "name": "Trimming - General",
      "code": "Trimming - General"
     },
     {
      "name": "Trimming - Hazards",
      "code": "Trimming - Hazards"
     },
     {
      "name": "Trimming - House / Driveway Clearance",
      "code": "Trimming - House / Driveway Clearance"
     },
     {
      "name": "Trimming - Weight Reduction",
      "code": "Trimming - Weight Reduction"
     },
     {
      "name": "Watering",
      "code": "Watering"
     },
     {
      "name": "Planting",
      "code": "Planting"
     },
     {
      "name": "Town Inspection",
      "code": "Town Inspection"
     },
     {
      "name": "Trees to be replaced under Warranty",
      "code": "Trees to be replaced under Warranty"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "SubBy",
   "type": "esriFieldTypeString",
   "alias": "Submitted By",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "treeSubmittedBy",
    "description": "A list of who submits tree assessments",
    "codedValues": [
     {
      "name": "Resident",
      "code": "Resident"
     },
     {
      "name": "IS Staff",
      "code": "IS Staff"
     },
     {
      "name": "Contractor",
      "code": "Contractor"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Verification",
   "type": "esriFieldTypeString",
   "alias": "Verification",
   "length": 150,
   "domain": {
    "type": "codedValue",
    "name": "treeVerification",
    "description": "Verification Types for Street Tree Assessments",
    "codedValues": [
     {
      "name": "Unverified - Resident Submission",
      "code": "Unverified - Resident Submission"
     },
     {
      "name": "Verified - Confirmed by SME",
      "code": "Verified - Confirmed by SME"
     },
     {
      "name": "Required SME Field Verification",
      "code": "Required SME Field Verification"
     },
     {
      "name": "Required Contractor Field Verification",
      "code": "Required Contractor Field Verification"
     },
     {
      "name": "Verified - Confirmed by Contractor",
      "code": "Verified - Confirmed by Contractor"
     },
     {
      "name": "Not Verified - Closed",
      "code": "Not Verified - Closed"
     },
     {
      "name": "Required PW Field Verification",
      "code": "Required PW Field Verification"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "LedtoMaintenance",
   "type": "esriFieldTypeString",
   "alias": "Led to Maintenance?",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Notes",
   "type": "esriFieldTypeString",
   "alias": "Notes",
   "length": 250,
   "domain": null
  },
  {
   "name": "Status",
   "type": "esriFieldTypeString",
   "alias": "Status",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "TreeReportStatus",
    "description": "A list of status for tree reports",
    "codedValues": [
     {
      "name": "Pending",
      "code": "Pending"
     },
     {
      "name": "Closed",
      "code": "Closed"
     },
     {
      "name": "Received",
      "code": "Received"
     },
     {
      "name": "Submitted",
      "code": "Submitted"
     },
     {
      "name": "Complete",
      "code": "Complete"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "WarrantyReplace",
   "type": "esriFieldTypeString",
   "alias": "Replaced Under Warranty?",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "A yes/no indicator",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "UUID_471",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GlobalID",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "gdb_ct3_471",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "bioStreetTree",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "TREENUMB",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "dateFieldsTimeReference": null,
 "hasMetadata": true,
 "isDataArchived": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1676406603000
 }
}