{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Workorder", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 10000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "Cityworks Workorders - UFA Trees", "copyrightText": "DDOT, UFA", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": 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, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "extent": { "xmin": 390098.6019999981, "ymin": 127298.21999999881, "xmax": 419114.6950000003, "ymax": 160192.39499999955, "spatialReference": { "wkid": 26985, "latestWkid": 26985, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -36747100, "falseY": -29091500, "xyUnits": 1.2123691021292362E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26985, "latestWkid": 26985, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -36747100, "falseY": -29091500, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "12bbf265b16f5213bcdd57853060004a", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAYCAYAAAD+vg1LAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAB90lEQVRIid3UwUvTYRjA8e87f3P7OZc6tqyErOggiAcvQSHpIDoUGRVay6KOEV2DoMu8dLA/IOoSQlJqTLJDVKSjQ12E6lKQF6lYxTLD9fuZc3ufLhbO3H77Mb30nB7eFz48z8vzPgYbFMb/B++f4NCuKBMzM2DMcbijnbG4QlcE9wiX0QxYsBDZgS3NhF5nGDxh8ySvOagtrow38rUsuEcwgZvAAWAzHgBMwFQKvEF6Bc55QeUU3QhhFOIIK7ggcLZEIzVqOaky2XTMYogf3B6r52lR+Lzgt6GtBFpYhMIwAsTQxLrTnBmPMLQmPPuNKX+Y1nLhv+GBpTkuQRG4OsisaxTIWbzTDRxfeVYAi48+gQEFMVeyJv04wueicELx6aQQ125gARGmVh//MxXDive9Qr/A1eX7BOD/8oiWnM32pqPMK4NQ3uK5CDe08OFBHS8cYYARRfyUcEsgMqx4A7BnkGeZaXaGOuisMUkl6vheqpGiP++eIgWkVnTs/5OPOqAl4dWhFwkrDxjivCdcwUsZtlX50Nk88+sGt45QnX1FwNzKQm1T4VhVBNd7uZjOopSH/Cjr9BR7H9KSecs1APsjwehL7kxCX0Vw1yS1v9JcDzRz39fIbr3IFmuafV1J7iY7Ob3WuiwLTkb5CRxxqs41XElsGPwb1/Ob6aEkvQYAAAAASUVORK5CYII=", "contentType": "image/png", "width": 16, "height": 18, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "WORKORDERID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "WORKORDERID", "type": "esriFieldTypeString", "alias": "WORKORDERID", "domain": null, "editable": true, "nullable": false, "length": 60, "defaultValue": null, "modelName": "WORKORDERID" }, { "name": "ENTITYUID", "type": "esriFieldTypeString", "alias": "ENTITYUID", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "ENTITYUID" }, { "name": "MATERIALID", "type": "esriFieldTypeString", "alias": "MATERIALID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MATERIALID" }, { "name": "PROJECTID", "type": "esriFieldTypeInteger", "alias": "PROJECTID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PROJECTID" }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "domain": { "type": "codedValue", "name": "CWUFAWorkorder", "description": "UFA Cityworks Workorder", "codedValues": [ { "name": "Injection to control fruiting of Female Ginkgo", "code": "GINKGO INJECTION" }, { "name": "Inspection Work Order", "code": "INSPECTION" }, { "name": "Work Order related to Permit Review", "code": "PERMITS" }, { "name": "Tree Planting related to Special Tree Permit", "code": "PLANTING (SPECIAL PERMIT)" }, { "name": "Tree Pruning", "code": "PRUNING" }, { "name": "American Elm Pruning (Seasonal Service)", "code": "PRUNING (ELM)" }, { "name": "Sanitation Pruning for Infected American Elm", "code": "PRUNING (ELM-SANITATION)" }, { "name": "Tree Debris Pile generated during a storm event", "code": "STORM (DEBRIS PILE)" }, { "name": "Hazard Mitigation Tree Pruning Resulting From Storm", "code": "STORM (HAZARD PRUNE)" }, { "name": "Stump Removal generated during a strom event", "code": "STORM (STUMP)" }, { "name": "Tree Removal generated during a storm event", "code": "STORM (TREE REMOVAL)" }, { "name": "Routine Tree Stump Removal", "code": "STUMP REMOVAL" }, { "name": "Special Tree Law-related Work Order", "code": "TREE BILL" }, { "name": "Routine Tree Removal", "code": "TREE REMOVAL" }, { "name": "Expedited Removal of Diseased American Elm", "code": "TREE REMOVAL (ELM - DED)" }, { "name": "Unspecified Work Order Category", "code": "UNSPECIFIED TASK" }, { "name": "Fungicide injection of american elm", "code": "ELM INJECTION" }, { "name": "Tree Planting", "code": "PLANTING" }, { "name": "Replacement Tree Planting Work Order", "code": "WARRANTY" }, { "name": "Emergency Work Order", "code": "EMERGENCY" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": { "type": "codedValue", "name": "CWWorkorderStatus", "description": "Cityworks Workorder Status", "codedValues": [ { "name": "Approved", "code": "APPROVED" }, { "name": "Cancel", "code": "CANCEL" }, { "name": "Closed", "code": "CLOSED" }, { "name": "Completed", "code": "COMPLETE" }, { "name": "Incomplete", "code": "INCMPLT" }, { "name": "MCP", "code": "MCP" }, { "name": "Open", "code": "OPEN" }, { "name": "Pending", "code": "PENDING" }, { "name": "Scheduled", "code": "SCHEDULED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STATUS" }, { "name": "INITIATEDDATE", "type": "esriFieldTypeDate", "alias": "INITIATEDDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INITIATEDDATE" }, { "name": "WORKORDERCLOSEDDATE", "type": "esriFieldTypeDate", "alias": "WORKORDERCLOSEDDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WORKORDERCLOSEDDATE" }, { "name": "ACTUALSTARTDATE", "type": "esriFieldTypeDate", "alias": "ACTUALSTARTDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ACTUALSTARTDATE" }, { "name": "ACTUALFINISHDATE", "type": "esriFieldTypeDate", "alias": "ACTUALFINISHDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ACTUALFINISHDATE" }, { "name": "PROJECTNAME", "type": "esriFieldTypeString", "alias": "PROJECTNAME", "domain": null, "editable": true, "nullable": true, "length": 130, "defaultValue": null, "modelName": "PROJECTNAME" }, { "name": "WORKORDERMATERIALCOST", "type": "esriFieldTypeDouble", "alias": "WORKORDERMATERIALCOST", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WORKORDERMATERIALCOST" }, { "name": "UNITSACCOMPLISHED", "type": "esriFieldTypeDouble", "alias": "UNITSACCOMPLISHED", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UNITSACCOMPLISHED" }, { "name": "UNITSACCOMPISHEDDESCRIPTION", "type": "esriFieldTypeString", "alias": "UNITSACCOMPISHEDDESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "UNITSACCOMPISHEDDESCRIPTION" }, { "name": "PRIORITY", "type": "esriFieldTypeString", "alias": "PRIORITY", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "PRIORITY" }, { "name": "INITIATEDBY", "type": "esriFieldTypeString", "alias": "INITIATEDBY", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INITIATEDBY" }, { "name": "WORKORDERCLOSEDBY", "type": "esriFieldTypeString", "alias": "WORKORDERCLOSEDBY", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WORKORDERCLOSEDBY" }, { "name": "PEPCONEEDED", "type": "esriFieldTypeString", "alias": "PEPCONEEDED", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "PEPCONEEDED" }, { "name": "SENTTOCONTRACTOR", "type": "esriFieldTypeString", "alias": "SENTTOCONTRACTOR", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "SENTTOCONTRACTOR" }, { "name": "ISCANCELED", "type": "esriFieldTypeString", "alias": "ISCANCELED", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "ISCANCELED" }, { "name": "CANCELEDBY", "type": "esriFieldTypeString", "alias": "CANCELEDBY", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CANCELEDBY" }, { "name": "CANCELEDDATE", "type": "esriFieldTypeDate", "alias": "CANCELEDDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CANCELEDDATE" }, { "name": "CONTRACTORID", "type": "esriFieldTypeInteger", "alias": "CONTRACTORID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CONTRACTORID" }, { "name": "WORKCOMPLETEDBY", "type": "esriFieldTypeString", "alias": "WORKCOMPLETEDBY", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WORKCOMPLETEDBY" }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "domain": null, "editable": true, "nullable": true, "length": 130, "defaultValue": null, "modelName": "ADDRESS" }, { "name": "FISCALYEAR", "type": "esriFieldTypeSmallInteger", "alias": "FISCALYEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FISCALYEAR" }, { "name": "WARD", "type": "esriFieldTypeString", "alias": "WARD", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "WARD" }, { "name": "QUADRANT", "type": "esriFieldTypeString", "alias": "QUADRANT", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "QUADRANT" }, { "name": "ZIPCODE", "type": "esriFieldTypeString", "alias": "ZIPCODE", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "ZIPCODE" }, { "name": "ANC", "type": "esriFieldTypeString", "alias": "ANC", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "ANC" }, { "name": "SMD", "type": "esriFieldTypeString", "alias": "SMD", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "SMD" }, { "name": "NEIGHBORHOODCLUSTERS", "type": "esriFieldTypeString", "alias": "NEIGHBORHOODCLUSTERS", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NEIGHBORHOODCLUSTERS" }, { "name": "NEIGHBORHOODNAMES", "type": "esriFieldTypeString", "alias": "NEIGHBORHOODNAMES", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NEIGHBORHOODNAMES" }, { "name": "BID", "type": "esriFieldTypeString", "alias": "BID", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "BID" }, { "name": "AWI", "type": "esriFieldTypeString", "alias": "AWI", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "AWI" }, { "name": "EDZ", "type": "esriFieldTypeString", "alias": "EDZ", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "EDZ" }, { "name": "NIF", "type": "esriFieldTypeString", "alias": "NIF", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "NIF" }, { "name": "HISTORICDISTRICT", "type": "esriFieldTypeString", "alias": "HISTORICDISTRICT", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "HISTORICDISTRICT" }, { "name": "ZONING", "type": "esriFieldTypeString", "alias": "ZONING", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ZONING" }, { "name": "PUD", "type": "esriFieldTypeString", "alias": "PUD", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PUD" }, { "name": "CFAR", "type": "esriFieldTypeString", "alias": "CFAR", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "CFAR" }, { "name": "PSA", "type": "esriFieldTypeString", "alias": "PSA", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "PSA" }, { "name": "PD", "type": "esriFieldTypeString", "alias": "PD", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "PD" }, { "name": "ARBORIST", "type": "esriFieldTypeString", "alias": "ARBORIST", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ARBORIST" }, { "name": "TEAM", "type": "esriFieldTypeSmallInteger", "alias": "TEAM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TEAM" }, { "name": "DAYSTOCLOSE", "type": "esriFieldTypeInteger", "alias": "DAYSTOCLOSE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DAYSTOCLOSE" }, { "name": "XCOORD", "type": "esriFieldTypeDouble", "alias": "XCOORD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "XCOORD" }, { "name": "YCOORD", "type": "esriFieldTypeDouble", "alias": "YCOORD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YCOORD" }, { "name": "ONSEGX", "type": "esriFieldTypeDouble", "alias": "ONSEGX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ONSEGX" }, { "name": "ONSEGY", "type": "esriFieldTypeDouble", "alias": "ONSEGY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ONSEGY" }, { "name": "UPDATEDATE", "type": "esriFieldTypeDate", "alias": "UPDATEDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "UPDATEDATE" }, { "name": "DAYSELAPSEDTOCLOSE", "type": "esriFieldTypeDouble", "alias": "DAYSELAPSEDTOCLOSE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DAYSELAPSEDTOCLOSE" }, { "name": "CONTRACTORNAME", "type": "esriFieldTypeString", "alias": "CONTRACTORNAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CONTRACTORNAME" }, { "name": "EXISTINGSPECIES", "type": "esriFieldTypeString", "alias": "EXISTINGSPECIES", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "EXISTINGSPECIES" }, { "name": "PLANTINGSPECIES", "type": "esriFieldTypeString", "alias": "PLANTINGSPECIES", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PLANTINGSPECIES" }, { "name": "TREEOWNER", "type": "esriFieldTypeString", "alias": "TREEOWNER", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TREEOWNER" }, { "name": "DBH", "type": "esriFieldTypeString", "alias": "DBH", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "DBH" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R139_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I590UPDATEDATE", "fields": "UPDATEDATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I590STATUS", "fields": "STATUS", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I590DESCRIPTION", "fields": "DESCRIPTION", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I590WORKORDERID", "fields": "WORKORDERID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S107_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Workorder", "description": "", "prototype": { "attributes": { "TREEOWNER": null, "WORKORDERID": " ", "ENTITYUID": " ", "MATERIALID": null, "PROJECTID": null, "DESCRIPTION": null, "STATUS": null, "INITIATEDDATE": null, "WORKORDERCLOSEDDATE": null, "ACTUALSTARTDATE": null, "ACTUALFINISHDATE": null, "PROJECTNAME": null, "WORKORDERMATERIALCOST": null, "UNITSACCOMPLISHED": null, "UNITSACCOMPISHEDDESCRIPTION": null, "PRIORITY": null, "INITIATEDBY": null, "WORKORDERCLOSEDBY": null, "PEPCONEEDED": null, "SENTTOCONTRACTOR": null, "ISCANCELED": null, "CANCELEDBY": null, "CANCELEDDATE": null, "CONTRACTORID": null, "WORKCOMPLETEDBY": null, "ADDRESS": null, "FISCALYEAR": null, "WARD": null, "QUADRANT": null, "ZIPCODE": null, "ANC": null, "SMD": null, "NEIGHBORHOODCLUSTERS": null, "NEIGHBORHOODNAMES": null, "BID": null, "AWI": null, "EDZ": null, "NIF": null, "HISTORICDISTRICT": null, "ZONING": null, "PUD": null, "CFAR": null, "PSA": null, "PD": null, "ARBORIST": null, "TEAM": null, "DAYSTOCLOSE": null, "XCOORD": null, "YCOORD": null, "ONSEGX": null, "ONSEGY": null, "UPDATEDATE": null, "DAYSELAPSEDTOCLOSE": null, "CONTRACTORNAME": null, "EXISTINGSPECIES": null, "PLANTINGSPECIES": null, "DBH": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }