{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 4, "name": "Tree Inventory Data", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SpeciesID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "SpeciesID", "type": "esriFieldTypeString", "alias": "Species", "length": 255, "domain": { "type": "codedValue", "name": "UrbanTree_TreeID", "description": "Treed Species ID", "codedValues": [ { "name": "Balsam fir", "code": "ABBA" }, { "name": "White fir", "code": "ABCO" }, { "name": "Maple", "code": "AC" }, { "name": "Hedge maple", "code": "ACCA" }, { "name": "Freeman maple", "code": "ACFR" }, { "name": "Amur maple", "code": "ACGI" }, { "name": "Boxelder", "code": "ACNE" }, { "name": "Norway maple", "code": "ACPL" }, { "name": "Red maple", "code": "ACRU" }, { "name": "Silver maple", "code": "ACSA1" }, { "name": "Sugar maple", "code": "ACSA2" }, { "name": "Tatar maple", "code": "ACTA" }, { "name": "Three-flowered maple", "code": "ACTR1" }, { "name": "Ohio buckeye", "code": "AEGL" }, { "name": "Horsechestnut", "code": "AEHI" }, { "name": "Tree of Heaven", "code": "AIAL" }, { "name": "Alder", "code": "AL" }, { "name": "Serviceberry", "code": "AM" }, { "name": "Birch", "code": "BE" }, { "name": "Yellow birch", "code": "BEAL" }, { "name": "River birch", "code": "BENI" }, { "name": "Paper birch", "code": "BEPA" }, { "name": "European white birch", "code": "BEPE" }, { "name": "Black birch", "code": "BELE" }, { "name": "Broadleaf Deciduous Large", "code": "BDL OTHER" }, { "name": "Broadleaf Deciduous Medium", "code": "BDM OTHER" }, { "name": "Broadleaf Deciduous Small", "code": "BDS OTHER" }, { "name": "Broadleaf Evergreen Large", "code": "BEL OTHER" }, { "name": "Broadleaf Evergreen Medium", "code": "BEM OTHER" }, { "name": "Broadleaf Evergreen Small", "code": "BES OTHER" }, { "name": "European hornbeam", "code": "CABE" }, { "name": "American hornbeam", "code": "CACA" }, { "name": "Hickory", "code": "CA1" }, { "name": "Bitternut hickory", "code": "CACO" }, { "name": "Shagbark hickory", "code": "CAOV" }, { "name": "American chesnut", "code": "CADE" }, { "name": "Catalpa", "code": "CA3" }, { "name": "Northern catalpa", "code": "CASP" }, { "name": "Northern hackberry", "code": "CEOC" }, { "name": "Katsura ", "code": "CEJA" }, { "name": "Eastern redbud", "code": "CECA" }, { "name": "Conifer Evergreen Large", "code": "CEL OTHER" }, { "name": "Conifer Evergreen Medium", "code": "CEM OTHER" }, { "name": "Conifer Evergreen Small", "code": "CES OTHER" }, { "name": "Dogwood", "code": "CO1" }, { "name": "Turkish hazelnut", "code": "COCO2" }, { "name": "Hawthorn", "code": "CR" }, { "name": "Russian olive", "code": "ELAN" }, { "name": "Beech", "code": "FA" }, { "name": "American beech", "code": "FAGR" }, { "name": "European beech", "code": "FASY" }, { "name": "Ash", "code": "FR" }, { "name": "White ash", "code": "FRAM" }, { "name": "Green ash", "code": "FRPE" }, { "name": "Ginkgo", "code": "GIBI" }, { "name": "Honeylocust", "code": "GLTR" }, { "name": "Kentucky coffeetree", "code": "GYDI" }, { "name": "American holly", "code": "ILOP" }, { "name": "Butternut", "code": "JUCI" }, { "name": "Black walnut", "code": "JUNI" }, { "name": "Juniper", "code": "JU" }, { "name": "Common juniper", "code": "JUCO1" }, { "name": "Eastern red cedar", "code": "JUVI" }, { "name": "Tamarack", "code": "LALA" }, { "name": "Sweetgum", "code": "LIST" }, { "name": "Tulip tree", "code": "LITU" }, { "name": "Honeysuckle", "code": "LOSP" }, { "name": "Southern magnolia", "code": "MAGR" }, { "name": "Magnolia species", "code": "MA1" }, { "name": "Apple", "code": "MADO" }, { "name": "Crabapple", "code": "MA2" }, { "name": "Dawn redwood", "code": "MEGL" }, { "name": "Red mulberry", "code": "MORU" }, { "name": "Black tupelo", "code": "NYSY" }, { "name": "American hophornbeam", "code": "OSVI" }, { "name": "Amur corktree", "code": "PHAM" }, { "name": "Spruce", "code": "PI1" }, { "name": "Norway spruce", "code": "PIAB" }, { "name": "Engelmann spruce", "code": "PIEN" }, { "name": "White spruce", "code": "PIGL1" }, { "name": "Black spruce", "code": "PIMA" }, { "name": "Blue spruce", "code": "PIPU" }, { "name": "Red spruce", "code": "PIRU" }, { "name": "Pine", "code": "PI2" }, { "name": "Jack pine", "code": "PIBA" }, { "name": "Lodgepole pine", "code": "PICO" }, { "name": "Pinyon pine", "code": "PIED" }, { "name": "Austrian pine", "code": "PINI" }, { "name": "Ponderosa pine", "code": "PIPO" }, { "name": "Pitch pine", "code": "PIRI" }, { "name": "Red pine", "code": "PIRE" }, { "name": "Eastern white pine", "code": "PIST" }, { "name": "Scotch pine", "code": "PISY" }, { "name": "American sycamore", "code": "PLOC" }, { "name": "Cottonwood", "code": "PO" }, { "name": "White poplar", "code": "POAL" }, { "name": "Eastern cottonwood", "code": "PODE" }, { "name": "Bigtooth aspen", "code": "POGR" }, { "name": "Balsam poplar", "code": "POBA" }, { "name": "Quaking aspen", "code": "POTR1" }, { "name": "Plum", "code": "PR" }, { "name": "Black cherry", "code": "PRSE1" }, { "name": "Pin cherry", "code": "PRPE1" }, { "name": "Cherry plum", "code": "PRCE" }, { "name": "Peach", "code": "PRPE2" }, { "name": "European bird cherry", "code": "PRPA" }, { "name": "Common chokecherry", "code": "PRVI" }, { "name": "Douglas fir", "code": "PSME" }, { "name": "Pear", "code": "PY" }, { "name": "Callery Pear", "code": "PYCA" }, { "name": "Oak", "code": "QU" }, { "name": "White oak", "code": "QUAL" }, { "name": "Swamp white oak", "code": "QUBI" }, { "name": "Scarlet oak", "code": "QUCO" }, { "name": "Bur oak", "code": "QUMA1" }, { "name": "Chinkapin oak", "code": "QUMU" }, { "name": "Water oak", "code": "QUNI" }, { "name": "Pin oak", "code": "QUPA" }, { "name": "English oak", "code": "QURO" }, { "name": "Northern red oak", "code": "QURU" }, { "name": "Shumard oak", "code": "QUSH" }, { "name": "European buckthorn", "code": "RHCA" }, { "name": "Smooth sumac", "code": "RHGL" }, { "name": "Sumac", "code": "RHSP" }, { "name": "Staghorn sumac", "code": "RHTY" }, { "name": "Black locust", "code": "ROPS" }, { "name": "Willow", "code": "SA" }, { "name": "Black willow", "code": "SANI" }, { "name": "White willow", "code": "SAAL4" }, { "name": "Crack willow", "code": "SAFR" }, { "name": "Mountain ash", "code": "SO" }, { "name": "American mountain ash", "code": "SOAM" }, { "name": "European mountain ash", "code": "SOAU" }, { "name": "Japanese tree lilac", "code": "SYRE" }, { "name": "Lilac", "code": "SYSP" }, { "name": "Yew", "code": "TA" }, { "name": "Red cedar", "code": "TH9" }, { "name": "Western redcedar", "code": "THPL" }, { "name": "Northern white cedar", "code": "THOC" }, { "name": "American basswood", "code": "TIAM" }, { "name": "Littleleaf linden", "code": "TICO" }, { "name": "Silver linden", "code": "TITO" }, { "name": "Eastern hemlock", "code": "TSCA" }, { "name": "American elm", "code": "ULAM" }, { "name": "Chinese elm", "code": "ULPA" }, { "name": "Siberian elm", "code": "ULPU" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Diameter", "type": "esriFieldTypeInteger", "alias": "Diameter", "domain": { "type": "codedValue", "name": "UrbanTree_DiaClass", "description": "Urban Tree Diameter Class", "codedValues": [ { "name": "0-3\"", "code": 1 }, { "name": "3-6\"", "code": 3 }, { "name": "6-12\"", "code": 6 }, { "name": "12-18\"", "code": 12 }, { "name": "18-24\"", "code": 18 }, { "name": "24-30\"", "code": 24 }, { "name": "30-36\"", "code": 30 }, { "name": "36-42\"", "code": 36 }, { "name": "42+\"", "code": 42 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ConditionID", "type": "esriFieldTypeString", "alias": "Condition", "length": 8, "domain": { "type": "codedValue", "name": "UrbanTree_Condition", "description": "Tree Conditions", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Dead", "code": "Dead" }, { "name": "Vacant", "code": "Vacant" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Remove", "type": "esriFieldTypeString", "alias": "Remove", "length": 20, "domain": { "type": "codedValue", "name": "UrbanTree_Remove", "description": "Urban Tree Removal Status", "codedValues": [ { "name": "No removal", "code": "No" }, { "name": "Yes, private", "code": "YPRIV" }, { "name": "Yes, public", "code": "YPUB" }, { "name": "Yes, town", "code": "Ytown" }, { "name": "Yes, utility", "code": "YUTIL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Consult", "type": "esriFieldTypeString", "alias": "Consult", "length": 6, "domain": { "type": "codedValue", "name": "TreeInventory_TextYesNo", "description": "Yes/No for Tree Inventory Text Fields", "codedValues": [ { "name": "No", "code": "0" }, { "name": "Yes", "code": "1" }, { "name": "N/A", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Needs", "type": "esriFieldTypeString", "alias": "Needs", "length": 6, "domain": { "type": "codedValue", "name": "TreeInventory_TextYesNo", "description": "Yes/No for Tree Inventory Text Fields", "codedValues": [ { "name": "No", "code": "0" }, { "name": "Yes", "code": "1" }, { "name": "N/A", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DD_deadwood", "type": "esriFieldTypeInteger", "alias": "Deadwood", "domain": { "type": "codedValue", "name": "UrbanTree_YesNo", "description": "Yes/No for Urban Tree Long Integer", "codedValues": [ { "name": "NO", "code": 0 }, { "name": "YES", "code": 1 }, { "name": "N/A", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DD_crowndiebk", "type": "esriFieldTypeInteger", "alias": "Crown Dieback", "domain": { "type": "codedValue", "name": "UrbanTree_YesNo", "description": "Yes/No for Urban Tree Long Integer", "codedValues": [ { "name": "NO", "code": 0 }, { "name": "YES", "code": 1 }, { "name": "N/A", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DD_decay", "type": "esriFieldTypeInteger", "alias": "Decay", "domain": { "type": "codedValue", "name": "UrbanTree_YesNo", "description": "Yes/No for Urban Tree Long Integer", "codedValues": [ { "name": "NO", "code": 0 }, { "name": "YES", "code": 1 }, { "name": "N/A", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DD_roots", "type": "esriFieldTypeInteger", "alias": "Root Problems", "domain": { "type": "codedValue", "name": "UrbanTree_YesNo", "description": "Yes/No for Urban Tree Long Integer", "codedValues": [ { "name": "NO", "code": 0 }, { "name": "YES", "code": 1 }, { "name": "N/A", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "GreenspaceName", "type": "esriFieldTypeString", "alias": "Greenspace Name", "length": 50, "domain": null }, { "name": "SiteHistory", "type": "esriFieldTypeString", "alias": "Site History", "length": 250, "domain": null }, { "name": "treeGUID", "type": "esriFieldTypeGUID", "alias": "treeGUID", "length": 38, "domain": null }, { "name": "Infestation", "type": "esriFieldTypeInteger", "alias": "Infestation", "domain": { "type": "codedValue", "name": "UrbanTree_YesNo", "description": "Yes/No for Urban Tree Long Integer", "codedValues": [ { "name": "NO", "code": 0 }, { "name": "YES", "code": 1 }, { "name": "N/A", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PlantingDate", "type": "esriFieldTypeDate", "alias": "Planting Date", "length": 8, "domain": null }, { "name": "ShadeTree", "type": "esriFieldTypeInteger", "alias": "Shade Tree", "domain": { "type": "codedValue", "name": "UrbanTree_YesNo", "description": "Yes/No for Urban Tree Long Integer", "codedValues": [ { "name": "NO", "code": 0 }, { "name": "YES", "code": 1 }, { "name": "N/A", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MemorialTree", "type": "esriFieldTypeInteger", "alias": "Memorial Tree", "domain": { "type": "codedValue", "name": "UrbanTree_YesNo", "description": "Yes/No for Urban Tree Long Integer", "codedValues": [ { "name": "NO", "code": 0 }, { "name": "YES", "code": 1 }, { "name": "N/A", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UtilityROW", "type": "esriFieldTypeInteger", "alias": "Utility ROW", "domain": { "type": "codedValue", "name": "UrbanTree_YesNo", "description": "Yes/No for Urban Tree Long Integer", "codedValues": [ { "name": "NO", "code": 0 }, { "name": "YES", "code": 1 }, { "name": "N/A", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AshTree", "type": "esriFieldTypeInteger", "alias": "AshTree", "domain": { "type": "codedValue", "name": "UrbanTree_YesNo", "description": "Yes/No for Urban Tree Long Integer", "codedValues": [ { "name": "NO", "code": 0 }, { "name": "YES", "code": 1 }, { "name": "N/A", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Private", "type": "esriFieldTypeInteger", "alias": "Private", "domain": { "type": "codedValue", "name": "UrbanTree_YesNo", "description": "Yes/No for Urban Tree Long Integer", "codedValues": [ { "name": "NO", "code": 0 }, { "name": "YES", "code": 1 }, { "name": "N/A", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "newTreeGUID", "type": "esriFieldTypeGUID", "alias": "newTreeGUID", "length": 38, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 255, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "Date of Last Edit", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 255, "domain": null }, { "name": "CreateDate", "type": "esriFieldTypeDate", "alias": "Date of Creation", "length": 8, "domain": null }, { "name": "InventoryDate", "type": "esriFieldTypeDate", "alias": "InventoryDate", "length": 8, "domain": null }, { "name": "DUPE", "type": "esriFieldTypeSmallInteger", "alias": "DUPE", "domain": null }, { "name": "TreeHealthSurveyGUID", "type": "esriFieldTypeGUID", "alias": "TreeHealthSurveyGUID", "length": 38, "domain": null }, { "name": "SyncDate", "type": "esriFieldTypeDate", "alias": "SyncDate", "length": 8, "domain": null } ], "indexes": [ { "name": "UUID_2227", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_247434_treeG", "fields": "treeGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_2227", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_247434_newTr", "fields": "newTreeGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "EcologicFlora_TreeInventory_point", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "treeGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{3973A89D-295C-4D85-B58A-AFBC03D43423}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1638812680000 } }