{
"layers": [
{
"currentVersion": 11.2,
"cimVersion": "3.2.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,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsCurrentUserQueries": 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,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON"
},
"hasMetadata": 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
}
},
"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": "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
},
"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"
},
{
"name": "DBH1",
"type": "esriFieldTypeSmallInteger",
"alias": "DBH1",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "DBH1"
}
],
"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": {
"DBH": 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,
"TREEOWNER": null,
"DBH1": null
}
},
"drawingTool": "esriFeatureEditToolPoint"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 8000,
"standardMaxRecordCountNoGeometry": 32000,
"maxRecordCountFactor": 1
},
{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 1,
"name": "Service Request",
"type": "Feature Layer",
"parentLayer": null,
"defaultVisibility": true,
"minScale": 10000,
"maxScale": 0,
"canScaleSymbols": false,
"geometryType": "esriGeometryPoint",
"description": "Cityworks Service Request - 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,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsCurrentUserQueries": 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,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON"
},
"hasMetadata": true,
"extent": {
"xmin": -8577086.254,
"ymin": 0,
"xmax": 407828.7281565732,
"ymax": 4710251.9750000015,
"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": "c497efa6da6c2bdc7f39fa4fa842bdc1",
"imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAYCAYAAAD+vg1LAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACRklEQVRIid3UXUiTURgH8P+Zc+/m1MmYMpPCymy2giIQtqAPiIg+lJLFlosIzMKiiyIIFvRGtAujoC6KhFjCllFREhGY5EWUUIy+I4oCldpKKZts7ePd3ifeSdDH1jY3b/rDgcNz4Mc5D+ccOaYp8v8P3nB48bpbcysGajEE08cF6+fHG2/wPC/mB18yHbwtohOyaHgI1d+H54xrm8Kj3caLLXcqqWyNOT7vkHOn43N28BWTCgLOg2E1gCpRlqyqpEEAbiqfbIGMbSfysQiEJiLSMcYoM5yg3WBsW7pDEEMJaNJ5zI2Ur+1u99hdB1zuHSf708OulUpQZBGyTAxxeZ/ipU1NnK2jy2E/237ckxKuFqJeP8eMyDEhFkUoOLwXQGr4m0r8Akw2NZcsj9W/rlHXb/619hscZmgF0AnAlgusSajGnLsc/rQw7A8/4HIjD7Eoa7iIZNBQiTfzrbA+eguP+SgYOZLrDNdBpNz0ImQojYmz+pfMnPgkC2hXxRruEYnn9FQ+4m47NZgZltI6yKNnWRcYq4T1/jOppN9juNswKsw21zWv6C32+vraLnzFlF6e7YEPgDSSYYDy5zwT+m/4j3Bx6KRnwRjL+E/kBFdExBnRYiayWGyiYLCFNyqqnofVfg0XrtXr/QWD5UGxQ5EgRjIkLBZLYVrRwi81LHwXcErzmvFo2f5jVrd0b/KCLbyxVBsQTrzXcdd8mkSdUiA9jb0x7+Obe04f6d2a6rvMCr7KvwoC2Pj3ylOc4dnUd5xPpg3+AQa4y7m9vpyrAAAAAElFTkSuQmCC",
"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": "REQUESTID",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "REQUESTID",
"type": "esriFieldTypeInteger",
"alias": "REQUESTID",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "REQUESTID"
},
{
"name": "WORKORDERID",
"type": "esriFieldTypeString",
"alias": "WORKORDERID",
"domain": null,
"editable": true,
"nullable": true,
"length": 60,
"defaultValue": null,
"modelName": "WORKORDERID"
},
{
"name": "CSRNUMBER",
"type": "esriFieldTypeString",
"alias": "CSRNUMBER",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "CSRNUMBER"
},
{
"name": "DESCRIPTION",
"type": "esriFieldTypeString",
"alias": "DESCRIPTION",
"domain": {
"type": "codedValue",
"name": "CWUFAServiceRequest",
"description": "CW UFA Service Request",
"codedValues": [
{
"name": "General Tree Inspection Request",
"code": "TREE INSPECTION"
},
{
"name": "Tree Removal Request",
"code": "TREE REMOVAL"
},
{
"name": "Tree Pruning Request",
"code": "TREE PRUNING"
},
{
"name": "Tree Planting Request",
"code": "TREE PLANTING"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "DESCRIPTION"
},
{
"name": "STATUS",
"type": "esriFieldTypeString",
"alias": "STATUS",
"domain": {
"type": "codedValue",
"name": "CWRequestStatus",
"description": "Cityworks Request Status",
"codedValues": [
{
"name": "Cancel",
"code": "CANCEL"
},
{
"name": "Closed",
"code": "CLOSED"
},
{
"name": "Completed",
"code": "COMPLETE"
},
{
"name": "Inspection Completed",
"code": "INSPCOMP"
},
{
"name": "Open",
"code": "OPEN"
},
{
"name": "Pending",
"code": "PENDING"
}
],
"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": "CLOSEDDATE",
"type": "esriFieldTypeDate",
"alias": "CLOSEDDATE",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "CLOSEDDATE"
},
{
"name": "INSPECTIONDATE",
"type": "esriFieldTypeDate",
"alias": "INSPECTIONDATE",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "INSPECTIONDATE"
},
{
"name": "INSPECTIONCOMPLETE",
"type": "esriFieldTypeString",
"alias": "INSPECTIONCOMPLETE",
"domain": null,
"editable": true,
"nullable": true,
"length": 1,
"defaultValue": null,
"modelName": "INSPECTIONCOMPLETE"
},
{
"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": "CLOSEDBY",
"type": "esriFieldTypeString",
"alias": "CLOSEDBY",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "CLOSEDBY"
},
{
"name": "ADDRESS",
"type": "esriFieldTypeString",
"alias": "ADDRESS",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"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": "DAYSTOINSPECT",
"type": "esriFieldTypeInteger",
"alias": "DAYSTOINSPECT",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "DAYSTOINSPECT"
},
{
"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": "COMMENTS",
"type": "esriFieldTypeString",
"alias": "COMMENTS",
"domain": null,
"editable": true,
"nullable": true,
"length": 250,
"defaultValue": null,
"modelName": "COMMENTS"
},
{
"name": "UPDATEDATE",
"type": "esriFieldTypeDate",
"alias": "UPDATEDATE",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "UPDATEDATE"
},
{
"name": "ResolutionTimeFrame",
"type": "esriFieldTypeString",
"alias": "ResolutionTimeFrame",
"domain": null,
"editable": true,
"nullable": true,
"length": 20,
"defaultValue": null,
"modelName": "ResolutionTimeFrame"
},
{
"name": "DAYSELAPSEDTOCLOSE",
"type": "esriFieldTypeDouble",
"alias": "DAYSELAPSEDTOCLOSE",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "DAYSELAPSEDTOCLOSE"
},
{
"name": "DAYSELAPSEDTOINSPECT",
"type": "esriFieldTypeDouble",
"alias": "DAYSELAPSEDTOINSPECT",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "DAYSELAPSEDTOINSPECT"
}
],
"geometryField": {
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE",
"domain": null,
"editable": false,
"nullable": true,
"defaultValue": null,
"modelName": "SHAPE"
},
"indexes": [
{
"name": "R136_pk",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "I587REQUESTID",
"fields": "REQUESTID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "I587WORKORDERID",
"fields": "WORKORDERID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "I587DESCRIPTION",
"fields": "DESCRIPTION",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "I587STATUS",
"fields": "STATUS",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "I587UPDATEDATE",
"fields": "UPDATEDATE",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "S105_idx",
"fields": "SHAPE",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "Service Request",
"description": "",
"prototype": {
"attributes": {
"DAYSELAPSEDTOCLOSE": null,
"REQUESTID": null,
"WORKORDERID": null,
"CSRNUMBER": null,
"DESCRIPTION": null,
"STATUS": null,
"INITIATEDDATE": null,
"CLOSEDDATE": null,
"INSPECTIONDATE": null,
"INSPECTIONCOMPLETE": null,
"PRIORITY": null,
"INITIATEDBY": null,
"CLOSEDBY": 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,
"DAYSTOINSPECT": null,
"XCOORD": null,
"YCOORD": null,
"ONSEGX": null,
"ONSEGY": null,
"COMMENTS": null,
"UPDATEDATE": null,
"ResolutionTimeFrame": null,
"DAYSELAPSEDTOINSPECT": null
}
},
"drawingTool": "esriFeatureEditToolPoint"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 8000,
"standardMaxRecordCountNoGeometry": 32000,
"maxRecordCountFactor": 1
}
],
"tables": []
}