{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 0,
"name": "Workorder",
"type": "Feature Layer",
"description": "Cityworks Workorders - UFA Trees",
"geometryType": "esriGeometryPoint",
"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
},
"copyrightText": "DDOT, UFA",
"parentLayer": null,
"subLayers": [],
"minScale": 10000,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriPMS",
"url": "d3429412da4d016d7f701ad18537118c",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAYCAYAAAD+vg1LAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAB+ElEQVRIid3UwUvTYRzH8fczf3Obc6Vjy0rIig6CdOgSFJIOokORUaG1TOoY4jUIuqxLB/sDoi4hJKXGJDtERTo61EWoLgV5kQorlhmu38+c+z3f2DBo4fbz1/TSBx748n3gxfPA93kM1inG/wcfGOfwzhjj09NgzHGkdQ+jCYWuCO4ULqLpN2Ehuh1Lmgi/yjBw0uKxrTmkTS6NNfBlVXCnEABuAAeBTXgK7XwvoBR4Q3QJnPOCyik6ECIoxBFWcEGgp8xFatRyURVgw3GTQb5za7SOJyXh84Lfgt1l0OJDKAwjSBxNvCPN2bEogyvCs1+Z9EdowW08sDRHH5SAq0PMukaBnMlbXc+JP3tFsPjoFuhXEHcla9KPonwqCScVH08JCe0GFhCbScepGFK86xKuCFxe3k8C/s8Pac5ZbGs8xrwyCNsmz0S4roX39+t57gjnM6xInBZuCkSHFK/zvb0DPM1MsSPcSltNgJnkRr7xLy/vrmIGCqsQAf/vesQBLQv/Hb1IRHnAEOd/whW8lGFrlQ+dtZlfM7hlmOrsS4KBLSzUNhaPVUVwnZfedBalPNgj+aldC3jfA5ozb7iar60PhGIvuD0B3RXB7RPU/kxzLdjEPV8Du/Qim80p9renuJNq48xK3+Wq4FSMH8BRp9O5hivJusG/ANdBm+kGJxkRAAAAAElFTkSuQmCC",
"contentType": "image/png",
"width": 16,
"height": 18,
"angle": 0,
"xoffset": 0,
"yoffset": 0
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": true,
"extent": {
"xmin": -8580041.814,
"ymin": 127298.21999999881,
"xmax": 9974632.524999999,
"ymax": 4715448.042999998,
"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
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "WORKORDERID",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "WORKORDERID",
"type": "esriFieldTypeString",
"alias": "WORKORDERID",
"length": 60,
"domain": null
},
{
"name": "ENTITYUID",
"type": "esriFieldTypeString",
"alias": "ENTITYUID",
"length": 50,
"domain": null
},
{
"name": "MATERIALID",
"type": "esriFieldTypeString",
"alias": "MATERIALID",
"length": 50,
"domain": null
},
{
"name": "PROJECTID",
"type": "esriFieldTypeInteger",
"alias": "PROJECTID",
"domain": null
},
{
"name": "DESCRIPTION",
"type": "esriFieldTypeString",
"alias": "DESCRIPTION",
"length": 60,
"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"
}
},
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "STATUS",
"length": 50,
"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"
}
},
{
"name": "INITIATEDDATE",
"type": "esriFieldTypeDate",
"alias": "INITIATEDDATE",
"length": 8,
"domain": null
},
{
"name": "WORKORDERCLOSEDDATE",
"type": "esriFieldTypeDate",
"alias": "WORKORDERCLOSEDDATE",
"length": 8,
"domain": null
},
{
"name": "ACTUALSTARTDATE",
"type": "esriFieldTypeDate",
"alias": "ACTUALSTARTDATE",
"length": 8,
"domain": null
},
{
"name": "ACTUALFINISHDATE",
"type": "esriFieldTypeDate",
"alias": "ACTUALFINISHDATE",
"length": 8,
"domain": null
},
{
"name": "PROJECTNAME",
"type": "esriFieldTypeString",
"alias": "PROJECTNAME",
"length": 130,
"domain": null
},
{
"name": "WORKORDERMATERIALCOST",
"type": "esriFieldTypeDouble",
"alias": "WORKORDERMATERIALCOST",
"domain": null
},
{
"name": "UNITSACCOMPLISHED",
"type": "esriFieldTypeDouble",
"alias": "UNITSACCOMPLISHED",
"domain": null
},
{
"name": "UNITSACCOMPISHEDDESCRIPTION",
"type": "esriFieldTypeString",
"alias": "UNITSACCOMPISHEDDESCRIPTION",
"length": 40,
"domain": null
},
{
"name": "PRIORITY",
"type": "esriFieldTypeString",
"alias": "PRIORITY",
"length": 2,
"domain": null
},
{
"name": "INITIATEDBY",
"type": "esriFieldTypeString",
"alias": "INITIATEDBY",
"length": 50,
"domain": null
},
{
"name": "WORKORDERCLOSEDBY",
"type": "esriFieldTypeString",
"alias": "WORKORDERCLOSEDBY",
"length": 50,
"domain": null
},
{
"name": "PEPCONEEDED",
"type": "esriFieldTypeString",
"alias": "PEPCONEEDED",
"length": 1,
"domain": null
},
{
"name": "SENTTOCONTRACTOR",
"type": "esriFieldTypeString",
"alias": "SENTTOCONTRACTOR",
"length": 1,
"domain": null
},
{
"name": "ISCANCELED",
"type": "esriFieldTypeString",
"alias": "ISCANCELED",
"length": 1,
"domain": null
},
{
"name": "CANCELEDBY",
"type": "esriFieldTypeString",
"alias": "CANCELEDBY",
"length": 50,
"domain": null
},
{
"name": "CANCELEDDATE",
"type": "esriFieldTypeDate",
"alias": "CANCELEDDATE",
"length": 8,
"domain": null
},
{
"name": "CONTRACTORID",
"type": "esriFieldTypeInteger",
"alias": "CONTRACTORID",
"domain": null
},
{
"name": "WORKCOMPLETEDBY",
"type": "esriFieldTypeString",
"alias": "WORKCOMPLETEDBY",
"length": 50,
"domain": null
},
{
"name": "ADDRESS",
"type": "esriFieldTypeString",
"alias": "ADDRESS",
"length": 130,
"domain": null
},
{
"name": "FISCALYEAR",
"type": "esriFieldTypeSmallInteger",
"alias": "FISCALYEAR",
"domain": null
},
{
"name": "WARD",
"type": "esriFieldTypeString",
"alias": "WARD",
"length": 1,
"domain": null
},
{
"name": "QUADRANT",
"type": "esriFieldTypeString",
"alias": "QUADRANT",
"length": 2,
"domain": null
},
{
"name": "ZIPCODE",
"type": "esriFieldTypeString",
"alias": "ZIPCODE",
"length": 5,
"domain": null
},
{
"name": "ANC",
"type": "esriFieldTypeString",
"alias": "ANC",
"length": 2,
"domain": null
},
{
"name": "SMD",
"type": "esriFieldTypeString",
"alias": "SMD",
"length": 4,
"domain": null
},
{
"name": "NEIGHBORHOODCLUSTERS",
"type": "esriFieldTypeString",
"alias": "NEIGHBORHOODCLUSTERS",
"length": 50,
"domain": null
},
{
"name": "NEIGHBORHOODNAMES",
"type": "esriFieldTypeString",
"alias": "NEIGHBORHOODNAMES",
"length": 50,
"domain": null
},
{
"name": "BID",
"type": "esriFieldTypeString",
"alias": "BID",
"length": 100,
"domain": null
},
{
"name": "AWI",
"type": "esriFieldTypeString",
"alias": "AWI",
"length": 100,
"domain": null
},
{
"name": "EDZ",
"type": "esriFieldTypeString",
"alias": "EDZ",
"length": 100,
"domain": null
},
{
"name": "NIF",
"type": "esriFieldTypeString",
"alias": "NIF",
"length": 100,
"domain": null
},
{
"name": "HISTORICDISTRICT",
"type": "esriFieldTypeString",
"alias": "HISTORICDISTRICT",
"length": 100,
"domain": null
},
{
"name": "ZONING",
"type": "esriFieldTypeString",
"alias": "ZONING",
"length": 10,
"domain": null
},
{
"name": "PUD",
"type": "esriFieldTypeString",
"alias": "PUD",
"length": 100,
"domain": null
},
{
"name": "CFAR",
"type": "esriFieldTypeString",
"alias": "CFAR",
"length": 100,
"domain": null
},
{
"name": "PSA",
"type": "esriFieldTypeString",
"alias": "PSA",
"length": 5,
"domain": null
},
{
"name": "PD",
"type": "esriFieldTypeString",
"alias": "PD",
"length": 5,
"domain": null
},
{
"name": "ARBORIST",
"type": "esriFieldTypeString",
"alias": "ARBORIST",
"length": 50,
"domain": null
},
{
"name": "TEAM",
"type": "esriFieldTypeSmallInteger",
"alias": "TEAM",
"domain": null
},
{
"name": "DAYSTOCLOSE",
"type": "esriFieldTypeInteger",
"alias": "DAYSTOCLOSE",
"domain": null
},
{
"name": "XCOORD",
"type": "esriFieldTypeDouble",
"alias": "XCOORD",
"domain": null
},
{
"name": "YCOORD",
"type": "esriFieldTypeDouble",
"alias": "YCOORD",
"domain": null
},
{
"name": "ONSEGX",
"type": "esriFieldTypeDouble",
"alias": "ONSEGX",
"domain": null
},
{
"name": "ONSEGY",
"type": "esriFieldTypeDouble",
"alias": "ONSEGY",
"domain": null
},
{
"name": "UPDATEDATE",
"type": "esriFieldTypeDate",
"alias": "UPDATEDATE",
"length": 8,
"domain": null
},
{
"name": "DAYSELAPSEDTOCLOSE",
"type": "esriFieldTypeDouble",
"alias": "DAYSELAPSEDTOCLOSE",
"domain": null
},
{
"name": "CONTRACTORNAME",
"type": "esriFieldTypeString",
"alias": "CONTRACTORNAME",
"length": 50,
"domain": null
},
{
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE",
"domain": null
},
{
"name": "EXISTINGSPECIES",
"type": "esriFieldTypeString",
"alias": "EXISTINGSPECIES",
"length": 100,
"domain": null
},
{
"name": "PLANTINGSPECIES",
"type": "esriFieldTypeString",
"alias": "PLANTINGSPECIES",
"length": 100,
"domain": null
},
{
"name": "TREEOWNER",
"type": "esriFieldTypeString",
"alias": "TREEOWNER",
"length": 50,
"domain": null
},
{
"name": "DBH",
"type": "esriFieldTypeString",
"alias": "DBH",
"length": 6,
"domain": null
},
{
"name": "DBH1",
"type": "esriFieldTypeSmallInteger",
"alias": "DBH1",
"domain": null
}
],
"geometryField": {
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "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": ""
}
],
"subtypes": [],
"relationships": [],
"canModifyLayer": true,
"canScaleSymbols": false,
"hasLabels": false,
"capabilities": "Map,Query,Data",
"maxRecordCount": 1000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"isDataVersioned": false,
"ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
"useStandardizedQueries": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsPagination": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"supportsDatumTransformation": true,
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": null,
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
}