{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "Tree", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 103458, "latestWkid": 103458, "xyTolerance": 0.00328083333333333, "zTolerance": 2, "mTolerance": 2, "falseX": -18187000, "falseY": -48539200, "xyUnits": 3048.00609601219, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "e051293059dc11b6cbb10f6beada4ecf", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAgAAAAICAYAAADED76LAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA4ElEQVQYlVWPLQvCUABFb3jJBRmCZYwXZQhLBge6+VEUzCaxyJrFavIPCEtm/4EDw5hhCuaFJwx5UQbaHbyFJ2JQEU+9hwOX4E3BMFqmopR7eZ5dkyQ4AjgDAAGAarU/sh13rmkmlVKg051iFy5nnEceMYxW3XbceaXSpu9YCaqqw3ayBedRSBSl3NM08zP+oLRWtKzxgOR5dpVSACj9CVIKCHG/kSQJ4kZzAlXV/4Q0ZRfG/DMBEB/2q9nz+VhQWitKKZCm7HJi2zWAmAAA55HHebSxrPFQiPuNMT/+3nwBq9lY8MXZHfoAAAAASUVORK5CYII=", "contentType": "image/png", "width": 6, "height": 6, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 205515.81791317835, "ymin": 152047.11862336844, "xmax": 225241.40214959532, "ymax": 191585.7573936954, "spatialReference": { "wkid": 103458, "latestWkid": 103458, "xyTolerance": 0.00328083333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -18187000, "falseY": -48539200, "xyUnits": 3048.00609601219, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "SystemID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SystemID", "type": "esriFieldTypeInteger", "alias": "SystemID", "domain": null }, { "name": "ID", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 255, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "Species", "type": "esriFieldTypeString", "alias": "Species", "length": 255, "domain": { "type": "codedValue", "name": "TreeSpecies", "description": "Species of tree", "codedValues": [ { "name": "ALDER", "code": "ALDER" }, { "name": "AMUR MAACKIA", "code": "AMUR MAACKIA" }, { "name": "APPLE", "code": "APPLE" }, { "name": "ASH", "code": "ASH" }, { "name": "ASPEN", "code": "ASPEN" }, { "name": "BALDCYPRESS", "code": "BALDCYPRESS" }, { "name": "BEECH", "code": "BEECH" }, { "name": "BIRCH", "code": "BIRCH" }, { "name": "BLACK LOCUST", "code": "BLACK LOCUST" }, { "name": "BOX ELDER", "code": "BOX ELDER" }, { "name": "BUCKEYE", "code": "BUCKEYE" }, { "name": "BUTTERNUT", "code": "BUTTERNUT" }, { "name": "CATALPA", "code": "CATALPA" }, { "name": "CEDAR", "code": "CEDAR" }, { "name": "CHERRY", "code": "CHERRY" }, { "name": "CORK", "code": "CORK" }, { "name": "COTTONWOOD", "code": "COTTONWOOD" }, { "name": "CRABAPPLE", "code": "CRABAPPLE" }, { "name": "DAWN REDWOOD", "code": "DAWN REDWOOD" }, { "name": "DOGWOOD", "code": "DOGWOOD" }, { "name": "ELM", "code": "ELM" }, { "name": "FIR", "code": "FIR" }, { "name": "GINKGO", "code": "GINKGO" }, { "name": "GOLDEN RAIN TREE", "code": "GOLDEN RAIN TREE" }, { "name": "HACKBERRY", "code": "HACKBERRY" }, { "name": "HARDY RUBBER TREE", "code": "HARDY RUBBER TREE" }, { "name": "HAWTHORN", "code": "HAWTHORN" }, { "name": "HAZELNUT", "code": "HAZELNUT" }, { "name": "HICKORY", "code": "HICKORY" }, { "name": "HONEYLOCUST", "code": "HONEYLOCUST" }, { "name": "HORSE CHESTNUT", "code": "HORSE CHESTNUT" }, { "name": "IRONWOOD", "code": "IRONWOOD" }, { "name": "JAPANESE TREE LILAC", "code": "JAPANESE TREE LILAC" }, { "name": "KATSURA", "code": "KATSURA" }, { "name": "KENTUCKY COFFEE", "code": "KENTUCKY COFFEE" }, { "name": "LINDEN", "code": "LINDEN" }, { "name": "LONDON PLANE", "code": "LONDON PLANE" }, { "name": "MAPLE", "code": "MAPLE" }, { "name": "MOUNTAIN-ASH", "code": "MOUNTAIN-ASH" }, { "name": "MULBERRY", "code": "MULBERRY" }, { "name": "MUSCLEWOOD", "code": "MUSCLEWOOD" }, { "name": "OAK", "code": "OAK" }, { "name": "ORNAMENTAL PEAR", "code": "ORNAMENTAL PEAR" }, { "name": "OSAGE ORANGE", "code": "OSAGE ORANGE" }, { "name": "OTHER", "code": "OTHER" }, { "name": "PAWPAW", "code": "PAWPAW" }, { "name": "PINE", "code": "PINE" }, { "name": "PLUM", "code": "PLUM" }, { "name": "REDBUD", "code": "REDBUD" }, { "name": "REMOVED", "code": "REMOVED" }, { "name": "SERVICEBERRY", "code": "SERVICEBERRY" }, { "name": "SEVEN-SON FLOWER", "code": "SEVEN-SON FLOWER" }, { "name": "SPRUCE", "code": "SPRUCE" }, { "name": "SWEET GUM", "code": "SWEET GUM" }, { "name": "TULIP", "code": "TULIP" }, { "name": "UNKNOWN", "code": "UNKNOWN" }, { "name": "WALNUT", "code": "WALNUT" }, { "name": "WILLOW", "code": "WILLOW" }, { "name": "YELLOWWOOD", "code": "YELLOWWOOD" }, { "name": "ZELKOVA", "code": "ZELKOVA" }, { "name": "STEWARTIA", "code": "STEWARTIA" }, { "name": "SILVERBELL", "code": "SILVERBELL" }, { "name": "BLACK GUM", "code": "BLACK GUM" }, { "name": "EUROPEAN HORNBEAM", "code": "EUROPEAN HORNBEAM" }, { "name": "BUCKTHORN", "code": "BUCKTHORN" }, { "name": "HEMLOCK", "code": "HEMLOCK" }, { "name": "YEW", "code": "YEW" }, { "name": "Nannyberry", "code": "Nannyberry" }, { "name": "Juniper", "code": "Juniper" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Diameter", "type": "esriFieldTypeString", "alias": "Diameter", "length": 255, "domain": { "type": "codedValue", "name": "Diameter_Tree", "description": "Tree diameter field", "codedValues": [ { "name": "2\" to 8\"", "code": "2-8" }, { "name": "9\" to 18\"", "code": "9-18" }, { "name": "19\" to 36\"", "code": "19-36" }, { "name": "36\" +", "code": "36+" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "length": 255, "domain": { "type": "codedValue", "name": "TREECOND", "description": "Last known condition of current or previous tree", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Zone", "type": "esriFieldTypeString", "alias": "Zone", "length": 255, "domain": { "type": "codedValue", "name": "TreeSiteChar", "description": "Tree Site Characteristics", "codedValues": [ { "name": "1", "code": "1" }, { "name": "2.01", "code": "2.01" }, { "name": "2.02", "code": "2.02" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" }, { "name": "8", "code": "8" }, { "name": "9", "code": "9" }, { "name": "10", "code": "10" }, { "name": "11", "code": "11" }, { "name": "107", "code": "107" }, { "name": "108", "code": "108" }, { "name": "114", "code": "114" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PlantingAreaSize", "type": "esriFieldTypeString", "alias": "PlantingAreaSize", "length": 255, "domain": { "type": "codedValue", "name": "TreePlantArea", "description": "Tree Planing Area Size", "codedValues": [ { "name": "SMALL", "code": "SMALL" }, { "name": "MEDIUM", "code": "MEDIUM" }, { "name": "LARGE", "code": "LARGE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 274, "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "length": 8, "domain": null }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "length": 255, "domain": null }, { "name": "EditBy", "type": "esriFieldTypeString", "alias": "EditBy", "length": 255, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Tree_ID", "type": "esriFieldTypeString", "alias": "Tree_ID", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": { "type": "codedValue", "name": "TreeStatus", "description": "Status of the Tree Site", "codedValues": [ { "name": "Plantable Site", "code": "Plantable Site" }, { "name": "Previous Tree", "code": "Previous Tree" }, { "name": "Non-City Tree", "code": "Non-City Tree" }, { "name": "Park Tree", "code": "Park Tree" }, { "name": "Cemetery Tree", "code": "Cemetery Tree" }, { "name": "City-Owned Tree", "code": "City-Owned Tree" }, { "name": "Street Tree", "code": "Street Tree" }, { "name": "Removed Private Tree", "code": "Removed Private Tree" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Failure_Likelihood", "type": "esriFieldTypeString", "alias": "Failure_Likelihood", "length": 255, "domain": { "type": "codedValue", "name": "Tree_Failure", "description": "Likelihood of Tree Failure", "codedValues": [ { "name": "Improbable", "code": "Improbable" }, { "name": "Possible", "code": "Possible" }, { "name": "Probable", "code": "Probable" }, { "name": "Imminent", "code": "Imminent" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Impact_Likelihood", "type": "esriFieldTypeString", "alias": "Impact_Likelihood", "length": 255, "domain": { "type": "codedValue", "name": "Tree_Impact", "description": "Likelihood of Tree Impact", "codedValues": [ { "name": "Very Low", "code": "Very Low" }, { "name": "Low", "code": "Low" }, { "name": "Medium", "code": "Medium" }, { "name": "High", "code": "High" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Failure_Consequences", "type": "esriFieldTypeString", "alias": "Failure_Consequences", "length": 255, "domain": { "type": "codedValue", "name": "Tree_Consequence", "description": "Consequence of Tree Failure", "codedValues": [ { "name": "Negligible", "code": "Negligible" }, { "name": "Minor", "code": "Minor" }, { "name": "Significant", "code": "Significant" }, { "name": "Severe", "code": "Severe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RiskRating", "type": "esriFieldTypeString", "alias": "RiskRating", "length": 255, "domain": { "type": "codedValue", "name": "Tree_Risk_Rate", "description": "Tree Risk Rating", "codedValues": [ { "name": "Low", "code": "Low" }, { "name": "Moderate", "code": "Moderate" }, { "name": "High", "code": "High" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AssessmentLevel", "type": "esriFieldTypeString", "alias": "AssessmentLevel", "length": 255, "domain": { "type": "codedValue", "name": "Tree_Assess_Lvl", "description": "Tree Assessment Level", "codedValues": [ { "name": "Windshield", "code": "Windshield" }, { "name": "Walking", "code": "Walking" }, { "name": "Detailed", "code": "Detailed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AssessDate", "type": "esriFieldTypeDate", "alias": "AssessDate", "length": 8, "domain": null }, { "name": "AssessComments", "type": "esriFieldTypeString", "alias": "AssessComments", "length": 255, "domain": null }, { "name": "StormDamage", "type": "esriFieldTypeString", "alias": "StormDamage", "length": 255, "domain": { "type": "codedValue", "name": "Tree_StormDamageType", "description": "Storm damage type for trees", "codedValues": [ { "name": "Blocking whole road", "code": "Blocking whole road" }, { "name": "Blocking driveway", "code": "Blocking driveway" }, { "name": "Blocking sidewalk", "code": "Blocking sidewalk" }, { "name": "Not blocking road or sidewalk", "code": "Not blocking road or sidewalk" }, { "name": "Tree on car", "code": "Tree on car" }, { "name": "Tree on house", "code": "Tree on house" }, { "name": "Tree in power line", "code": "Tree in power line" }, { "name": "Hanger", "code": "Hanger" }, { "name": "Passable but in the driving lane", "code": "Passable but in the driving lane" }, { "name": "In parking lane", "code": "In parking lane" }, { "name": "Citizen concerned about tree", "code": "Citizen concerned about tree" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StormNotes", "type": "esriFieldTypeString", "alias": "StormNotes", "length": 255, "domain": null }, { "name": "DateStaked", "type": "esriFieldTypeDate", "alias": "DateStaked", "length": 8, "domain": null }, { "name": "USER1", "type": "esriFieldTypeString", "alias": "USER1", "length": 255, "domain": null }, { "name": "USER2", "type": "esriFieldTypeString", "alias": "USER2", "length": 255, "domain": null }, { "name": "USER3", "type": "esriFieldTypeString", "alias": "USER3", "length": 255, "domain": null }, { "name": "USER4", "type": "esriFieldTypeString", "alias": "USER4", "length": 255, "domain": null }, { "name": "USER5", "type": "esriFieldTypeString", "alias": "USER5", "length": 255, "domain": null }, { "name": "USER6", "type": "esriFieldTypeString", "alias": "USER6", "length": 255, "domain": null }, { "name": "USER7", "type": "esriFieldTypeString", "alias": "USER7", "length": 255, "domain": null }, { "name": "USER8", "type": "esriFieldTypeString", "alias": "USER8", "length": 255, "domain": { "type": "codedValue", "name": "Tree_JobType", "description": "Tree Work Job Type", "codedValues": [ { "name": "Informed new tree(s) will be planted", "code": "Informed new tree(s) will be planted" }, { "name": "Species preference selected", "code": "Species preference selected" }, { "name": "Didn't want a tree", "code": "Didn't want a tree" }, { "name": "Notice not needed", "code": "Notice not needed" }, { "name": "Need to notify", "code": "Need to notify" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "USER9", "type": "esriFieldTypeString", "alias": "USER9", "length": 255, "domain": null }, { "name": "USER10", "type": "esriFieldTypeString", "alias": "USER10", "length": 255, "domain": null }, { "name": "USER11", "type": "esriFieldTypeString", "alias": "USER11", "length": 255, "domain": null }, { "name": "USER12", "type": "esriFieldTypeString", "alias": "USER12", "length": 255, "domain": null }, { "name": "USER13", "type": "esriFieldTypeString", "alias": "USER13", "length": 255, "domain": null }, { "name": "USER14", "type": "esriFieldTypeString", "alias": "USER14", "length": 255, "domain": { "type": "codedValue", "name": "TreeFailure", "description": "Display the status of newly planted trees to track success.", "codedValues": [ { "name": "Tree Failure - Replace", "code": "Tree Failure - Replace" }, { "name": "Recheck", "code": "Recheck" }, { "name": "Replacement Finished", "code": "Replacement Finished" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "USER15", "type": "esriFieldTypeString", "alias": "USER15", "length": 255, "domain": null }, { "name": "USER16", "type": "esriFieldTypeString", "alias": "USER16", "length": 255, "domain": null }, { "name": "USER17", "type": "esriFieldTypeInteger", "alias": "USER17", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Date_Planted", "type": "esriFieldTypeDate", "alias": "Date_Planted", "length": 8, "domain": null }, { "name": "TreeWatering", "type": "esriFieldTypeString", "alias": "Tree Watering Sign Up", "length": 255, "domain": null }, { "name": "USER18", "type": "esriFieldTypeDouble", "alias": "USER18", "domain": null }, { "name": "StormDamageStatus", "type": "esriFieldTypeString", "alias": "Storm Damage Status", "length": 255, "domain": { "type": "codedValue", "name": "TreeStormStatus", "description": "Storm damage status", "codedValues": [ { "name": "Open - High Priority", "code": "Open - High Priority" }, { "name": "Open - Low Priority", "code": "Open - Low Priority" }, { "name": "Closed (cleaned up)", "code": "Closed (cleaned up)" }, { "name": "Hold (wait on this one)", "code": "Hold (wait on this one)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R504_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_504", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9488_Tree_ID", "fields": "Tree_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_504", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S374_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Workorder", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "Tree_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1712830041000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "792ef0346a7c44a3ae8ebb45f6957aa5" } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 4, "name": "Work Orders", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CallerName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PRIORITY", "type": "esriFieldTypeString", "alias": "Priority", "length": 255, "domain": { "type": "codedValue", "name": "TREE_WO_Priority", "description": "Priority for tree workorders", "codedValues": [ { "name": "Low", "code": "Low" }, { "name": "Medium", "code": "Medium" }, { "name": "High", "code": "High" }, { "name": "Hold", "code": "Hold" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": { "type": "codedValue", "name": "WOTYPE_2", "description": "Tree Work Order Type", "codedValues": [ { "name": "Branch Down", "code": "Branch Down" }, { "name": "Clearance & Deadwood Pruning", "code": "Clearance & Deadwood Pruning" }, { "name": "Emerald Ash Borer Treatment", "code": "Emerald Ash Borer Treatment" }, { "name": "Hanger", "code": "Hanger" }, { "name": "Hornet/Wasp Nest", "code": "Hornet/Wasp Nest" }, { "name": "Nuisance Tree", "code": "Nuisance Tree" }, { "name": "Reduction Pruning", "code": "Reduction Pruning" }, { "name": "Removal", "code": "Removal" }, { "name": "Site Inspection", "code": "Site Inspection" }, { "name": "Stump Grinding", "code": "Stump Grinding" }, { "name": "Sucker Pruning", "code": "Sucker Pruning" }, { "name": "Training Pruning", "code": "Training Pruning" }, { "name": "Tree Planting", "code": "Tree Planting" }, { "name": "Blocked Traffic Sign", "code": "Blocked Traffic Sign" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": { "type": "codedValue", "name": "TREE_WO_Status", "description": "Status for Tree Workorders", "codedValues": [ { "name": "Open", "code": "Open" }, { "name": "Closed", "code": "Closed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "aNOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 265, "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "DateClosed", "type": "esriFieldTypeDate", "alias": "DateClosed", "length": 8, "domain": null }, { "name": "CreateBy", "type": "esriFieldTypeString", "alias": "CreateBy", "length": 255, "domain": null }, { "name": "CreateDate", "type": "esriFieldTypeDate", "alias": "CreateDate", "length": 8, "domain": null }, { "name": "EditBy", "type": "esriFieldTypeString", "alias": "EditBy", "length": 255, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "CallerName", "type": "esriFieldTypeString", "alias": "Caller Name", "length": 255, "domain": null }, { "name": "CallerPhone", "type": "esriFieldTypeString", "alias": "Caller Phone", "length": 255, "domain": null }, { "name": "GUID_WO_A", "type": "esriFieldTypeString", "alias": "GUID_WO_A", "length": 255, "domain": null }, { "name": "Address_WO_Table", "type": "esriFieldTypeString", "alias": "Address WO Table", "length": 255, "domain": null }, { "name": "Pruning_Info", "type": "esriFieldTypeString", "alias": "Pruning Info", "length": 255, "domain": { "type": "codedValue", "name": "Tree_Pruning_Info", "description": "Additional information that may be needed for a tree workorder.", "codedValues": [ { "name": "Pole Saw", "code": "Pole Saw" }, { "name": "Big Bucket Truck Needed", "code": "Big Bucket Truck Needed" }, { "name": "Wires Present", "code": "Wires Present" }, { "name": "Traffic Concerns", "code": "Traffic Concerns" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Removal_Info1", "type": "esriFieldTypeString", "alias": "Removal Info 1", "length": 255, "domain": { "type": "codedValue", "name": "Tree_Removal_Info", "description": "", "codedValues": [ { "name": "Simple, Small, Quick Removal", "code": "Simple, Small, Quick Removal" }, { "name": "Bucket Truck Needed", "code": "Bucket Truck Needed" }, { "name": "Traffic Concerns", "code": "Traffic Concerns" }, { "name": "Press Release Required", "code": "Press Release Required" }, { "name": "Wire Drop - Street Light", "code": "Wire Drop - Street Light" }, { "name": "Wires Present", "code": "Wires Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Removal_Info2", "type": "esriFieldTypeString", "alias": "Removal Info 2", "length": 255, "domain": { "type": "codedValue", "name": "Tree_Removal_Info", "description": "", "codedValues": [ { "name": "Simple, Small, Quick Removal", "code": "Simple, Small, Quick Removal" }, { "name": "Bucket Truck Needed", "code": "Bucket Truck Needed" }, { "name": "Traffic Concerns", "code": "Traffic Concerns" }, { "name": "Press Release Required", "code": "Press Release Required" }, { "name": "Wire Drop - Street Light", "code": "Wire Drop - Street Light" }, { "name": "Wires Present", "code": "Wires Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "No_Parking_Posted", "type": "esriFieldTypeString", "alias": "No Parking Posted?", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspection_Notes", "type": "esriFieldTypeString", "alias": "Inspection Notes", "length": 264, "domain": null }, { "name": "Leaf_Status", "type": "esriFieldTypeString", "alias": "When should this be completed?", "length": 255, "domain": { "type": "codedValue", "name": "Tree_Pruning_Season", "description": "When should a tree workorder be completed.", "codedValues": [ { "name": "Leaf On", "code": "Leaf On" }, { "name": "Leaf Off", "code": "Leaf Off" }, { "name": "Contracted Out", "code": "Contracted Out" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Tree_ID", "type": "esriFieldTypeString", "alias": "Tree_ID", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R503_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_503", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_503", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_9487_Tree_ID", "fields": "Tree_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Tree", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "Tree_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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 }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1712829197000 }, "serviceItemId": "792ef0346a7c44a3ae8ebb45f6957aa5" } ] }