{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "Tree", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CreatedDate", "creatorField": "CreatedBy", "editDateField": "EditDate", "editorField": "EditBy" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Workorder", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Tree_ID", "composite": false } ], "isDataVersioned": true, "isDataArchived": true, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "modelName": "GP_425006266", "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1712830041000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": 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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "SystemID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SystemID", "type": "esriFieldTypeInteger", "alias": "SystemID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SystemID" }, { "name": "ID", "type": "esriFieldTypeInteger", "alias": "ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ID" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Address" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Notes" }, { "name": "Species", "type": "esriFieldTypeString", "alias": "Species", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Species" }, { "name": "Diameter", "type": "esriFieldTypeString", "alias": "Diameter", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "9-18", "modelName": "Diameter" }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Condition", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "GOOD", "modelName": "Condition" }, { "name": "Zone", "type": "esriFieldTypeString", "alias": "Zone", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Zone" }, { "name": "PlantingAreaSize", "type": "esriFieldTypeString", "alias": "PlantingAreaSize", "domain": { "type": "codedValue", "name": "TreePlantArea", "description": "Tree Planing Area Size", "codedValues": [ { "name": "2-4 SMALL", "code": "2-4 SMALL" }, { "name": "5-6 MEDIUM", "code": "5-6 MEDIUM" }, { "name": "7+ LARGE", "code": "7+ LARGE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PlantingAreaSize" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 274, "defaultValue": null, "modelName": "Comments" }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Latitude" }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Longitude" }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "CreatedDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreatedDate" }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "CreatedBy", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CreatedBy" }, { "name": "EditBy", "type": "esriFieldTypeString", "alias": "EditBy", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "EditBy" }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditDate" }, { "name": "Tree_ID", "type": "esriFieldTypeString", "alias": "Tree_ID", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Tree_ID" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "TreeStatus", "description": "Status of the Tree Site", "codedValues": [ { "name": "Active Tree or Stump", "code": "Active Tree or Stump" }, { "name": "Plantable Site", "code": "Plantable Site" }, { "name": "Non-Plantable", "code": "Non-Plantable" }, { "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" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Status" }, { "name": "Failure_Likelihood", "type": "esriFieldTypeString", "alias": "Failure_Likelihood", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Failure_Likelihood" }, { "name": "Impact_Likelihood", "type": "esriFieldTypeString", "alias": "Impact_Likelihood", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Impact_Likelihood" }, { "name": "Failure_Consequences", "type": "esriFieldTypeString", "alias": "Failure_Consequences", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Failure_Consequences" }, { "name": "RiskRating", "type": "esriFieldTypeString", "alias": "RiskRating", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "RiskRating" }, { "name": "AssessmentLevel", "type": "esriFieldTypeString", "alias": "AssessmentLevel", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Windshield", "modelName": "AssessmentLevel" }, { "name": "AssessDate", "type": "esriFieldTypeDate", "alias": "AssessDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "AssessDate" }, { "name": "AssessComments", "type": "esriFieldTypeString", "alias": "AssessComments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AssessComments" }, { "name": "StormDamage", "type": "esriFieldTypeString", "alias": "StormDamage", "domain": { "type": "codedValue", "name": "Tree_StormDamageType", "description": "Storm damage type for trees", "codedValues": [ { "name": "Cleaned up", "code": "Cleaned up" }, { "name": "Blocking whole road", "code": "Blocking whole road" }, { "name": "In the road", "code": "In the road" }, { "name": "Blocking driveway", "code": "Blocking driveway" }, { "name": "Blocking sidewalk", "code": "Blocking sidewalk" }, { "name": "Pushed out of driving lane", "code": "Pushed out of driving lane" }, { "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": "Citizen concered about tree", "code": "Citizen concered about tree" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "StormDamage" }, { "name": "StormNotes", "type": "esriFieldTypeString", "alias": "StormNotes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "StormNotes" }, { "name": "DateStaked", "type": "esriFieldTypeDate", "alias": "DateStaked", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateStaked" }, { "name": "USER1", "type": "esriFieldTypeString", "alias": "USER1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER1" }, { "name": "USER2", "type": "esriFieldTypeString", "alias": "USER2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER2" }, { "name": "USER3", "type": "esriFieldTypeString", "alias": "USER3", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER3" }, { "name": "USER4", "type": "esriFieldTypeString", "alias": "USER4", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER4" }, { "name": "USER5", "type": "esriFieldTypeString", "alias": "USER5", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER5" }, { "name": "USER6", "type": "esriFieldTypeString", "alias": "USER6", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER6" }, { "name": "USER7", "type": "esriFieldTypeString", "alias": "USER7", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER7" }, { "name": "USER8", "type": "esriFieldTypeString", "alias": "USER8", "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" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER8" }, { "name": "USER9", "type": "esriFieldTypeString", "alias": "USER9", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER9" }, { "name": "USER10", "type": "esriFieldTypeString", "alias": "USER10", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER10" }, { "name": "USER11", "type": "esriFieldTypeString", "alias": "USER11", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER11" }, { "name": "USER12", "type": "esriFieldTypeString", "alias": "USER12", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER12" }, { "name": "USER13", "type": "esriFieldTypeString", "alias": "USER13", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER13" }, { "name": "USER14", "type": "esriFieldTypeString", "alias": "USER14", "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" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER14" }, { "name": "USER15", "type": "esriFieldTypeString", "alias": "USER15", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER15" }, { "name": "USER16", "type": "esriFieldTypeString", "alias": "USER16", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "USER16" }, { "name": "USER17", "type": "esriFieldTypeInteger", "alias": "USER17", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "USER17" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Date_Planted", "type": "esriFieldTypeDate", "alias": "Date_Planted", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date_Planted" }, { "name": "TreeWatering", "type": "esriFieldTypeString", "alias": "Tree Watering Sign Up", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TreeWatering" }, { "name": "USER18", "type": "esriFieldTypeDouble", "alias": "USER18", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "USER18" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Tree", "description": "", "prototype": { "attributes": { "TreeWatering": null, "Date_Planted": null, "SystemID": null, "ID": null, "Address": null, "Notes": null, "Species": null, "Diameter": "9-18", "Condition": "GOOD", "Zone": null, "PlantingAreaSize": null, "Comments": null, "Latitude": null, "Longitude": null, "USER18": null, "USER17": null, "USER16": null, "USER15": null, "USER14": null, "Status": null, "Failure_Likelihood": null, "Impact_Likelihood": null, "Failure_Consequences": null, "RiskRating": null, "AssessmentLevel": "Windshield", "AssessDate": null, "AssessComments": null, "StormDamage": null, "StormNotes": null, "DateStaked": null, "USER1": null, "USER2": null, "USER3": null, "USER4": null, "USER5": null, "USER6": null, "USER7": null, "USER8": null, "USER9": null, "USER10": null, "USER11": null, "USER12": null, "USER13": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "75c9e3a803c64dc5b9a8eadb7491f814" } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 4, "name": "Work Orders", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CreateDate", "creatorField": "CreateBy", "editDateField": "EditDate", "editorField": "EditBy" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Tree", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Tree_ID", "composite": false } ], "isDataVersioned": true, "isDataArchived": true, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1712829197000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "CallerName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PRIORITY", "type": "esriFieldTypeString", "alias": "Priority", "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" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Low", "modelName": "PRIORITY" }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "domain": { "type": "codedValue", "name": "WOTYPE_2", "description": "Tree Work Order Type", "codedValues": [ { "name": "Elevating/Deadwood Pruning", "code": "Elevating/Deadwood Pruning" }, { "name": "Removal", "code": "Removal" }, { "name": "Ash Reduction", "code": "Ash Reduction" }, { "name": "Hanger/Branch Down", "code": "Hanger/Branch Down" }, { "name": "Structure/Training Pruning", "code": "Structure/Training Pruning" }, { "name": "Emerald Ash Borer Treatment", "code": "Emerald Ash Borer Treatment" }, { "name": "Site Inspection", "code": "Site Inspection" }, { "name": "Tree Planting", "code": "Tree Planting" }, { "name": "Other", "code": "Other" }, { "name": "Hornet/Wasp Nest", "code": "Hornet/Wasp Nest" }, { "name": "Sucker/Water Spout Pruning", "code": "Sucker/Water Spout Pruning" }, { "name": "Stump Grinding", "code": "Stump Grinding" }, { "name": "Nuisance Tree", "code": "Nuisance Tree" }, { "name": "Emergency Not Reviewed", "code": "Emergency Not Reviewed" }, { "name": "Emergency Reviewed", "code": "Emergency Reviewed" }, { "name": "Test", "code": "Test" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TYPE" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Open", "modelName": "STATUS" }, { "name": "aNOTES", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 265, "defaultValue": null, "modelName": "aNOTES" }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Longitude" }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Latitude" }, { "name": "DateClosed", "type": "esriFieldTypeDate", "alias": "DateClosed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateClosed" }, { "name": "CreateBy", "type": "esriFieldTypeString", "alias": "CreateBy", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CreateBy" }, { "name": "CreateDate", "type": "esriFieldTypeDate", "alias": "CreateDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreateDate" }, { "name": "EditBy", "type": "esriFieldTypeString", "alias": "EditBy", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "EditBy" }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditDate" }, { "name": "CallerName", "type": "esriFieldTypeString", "alias": "Caller Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CallerName" }, { "name": "CallerPhone", "type": "esriFieldTypeString", "alias": "Caller Phone", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CallerPhone" }, { "name": "GUID_WO_A", "type": "esriFieldTypeString", "alias": "GUID_WO_A", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GUID_WO_A" }, { "name": "Address_WO_Table", "type": "esriFieldTypeString", "alias": "Address WO Table", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Address_WO_Table" }, { "name": "Pruning_Info", "type": "esriFieldTypeString", "alias": "Pruning Info", "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" }, { "name": "Prune only during leaf on", "code": "Prune only during leaf on" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Pruning_Info" }, { "name": "Removal_Info1", "type": "esriFieldTypeString", "alias": "Removal Info 1", "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": "Wire Drop - Service", "code": "Wire Drop - Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Removal_Info1" }, { "name": "Removal_Info2", "type": "esriFieldTypeString", "alias": "Removal Info 2", "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": "Wire Drop - Service", "code": "Wire Drop - Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Removal_Info2" }, { "name": "No_Parking_Posted", "type": "esriFieldTypeString", "alias": "No Parking Posted?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "No_Parking_Posted" }, { "name": "Inspection_Notes", "type": "esriFieldTypeString", "alias": "Inspection Notes", "domain": null, "editable": true, "nullable": true, "length": 264, "defaultValue": null, "modelName": "Inspection_Notes" }, { "name": "Leaf_Status", "type": "esriFieldTypeString", "alias": "When should this be completed?", "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" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Leaf_Status" }, { "name": "Tree_ID", "type": "esriFieldTypeString", "alias": "Tree_ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Tree_ID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Work Orders", "description": "", "prototype": { "attributes": { "Tree_ID": null, "Leaf_Status": null, "PRIORITY": "Low", "TYPE": null, "STATUS": "Open", "aNOTES": null, "Longitude": null, "Latitude": null, "DateClosed": null, "Inspection_Notes": null, "No_Parking_Posted": null, "Removal_Info2": null, "Removal_Info1": null, "CallerName": null, "CallerPhone": null, "GUID_WO_A": null, "Address_WO_Table": null, "Pruning_Info": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "75c9e3a803c64dc5b9a8eadb7491f814" } ] }