{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Cityworks Workorders", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 500000, "maxScale": 0, "canScaleSymbols": true, "referenceScale": 144447.638572, "geometryType": "esriGeometryPoint", "description": "Cityworks Workorders", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "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": false, "supportsASyncCalculate": false, "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": -9431717.794, "ymin": 1395243.46487468, "xmax": 1426047.151, "ymax": 9328784.1097475, "spatialReference": { "wkid": 102658, "latestWkid": 2236, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -17791300, "falseY": -41645400, "xyUnits": 1.372494229425764E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102658, "latestWkid": 2236, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -17791300, "falseY": -41645400, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 10000, "falseM": 0, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "6136339dadbfefbba458156accdab375", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABJklEQVQokWNhIBOwUFujIoO8qhbDx/ffGD68OcnAwPANv0YeHlEG94Q+hpAcZwY5dUmGv3/+MhzZfI5h/YwlDKd3TcKlkZEhtnYGQ0xZEFyEmYWZwT7QlMHQTouhMY6Z4cS2fkyN7jHJDOH5/lgdzifMzRCUkcxwYttMmLMRGvWsHRlY2Zlx+JmBwcJTm8HA1pXhwuGNqBrZOPlxaoI4m4FBSEoI06kfXj3Fq/HJnd8Mb5+cwtT46u5EhivHQxl0LAWxaty94jjDxaNXMTWunnmNQVC2joGRsY1B24IXLv77JwPDzqUXGZ7cjUc2BzUeZ9VMYfjy7QjD7fNVDPyiigx/fn9jeHbvCIPUn1qGHQv+4dbIwMDAsKztAgMDQxhe/2LVSCQAAML5UzAzGkKeAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "ESRI_OID", "globalIdField": "", "displayField": "WORKORDERID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "WORKORDERID", "type": "esriFieldTypeString", "alias": "WORKORDERID", "domain": null, "editable": true, "nullable": false, "length": 60, "defaultValue": null, "modelName": "WORKORDERID" }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "SUPERVISOR", "type": "esriFieldTypeString", "alias": "SUPERVISOR", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SUPERVISOR" }, { "name": "REQUESTEDBY", "type": "esriFieldTypeString", "alias": "REQUESTEDBY", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "REQUESTEDBY" }, { "name": "INITIATEDBY", "type": "esriFieldTypeString", "alias": "INITIATEDBY", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "INITIATEDBY" }, { "name": "INITIATEDATE", "type": "esriFieldTypeDate", "alias": "INITIATEDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INITIATEDATE" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "LOCATION" }, { "name": "PROJSTARTDATE", "type": "esriFieldTypeDate", "alias": "PROJSTARTDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PROJSTARTDATE" }, { "name": "PROJFINISHDATE", "type": "esriFieldTypeDate", "alias": "PROJFINISHDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PROJFINISHDATE" }, { "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": "WOCLOSEDBY", "type": "esriFieldTypeString", "alias": "WOCLOSEDBY", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WOCLOSEDBY" }, { "name": "CANCEL", "type": "esriFieldTypeString", "alias": "CANCEL", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "CANCEL" }, { "name": "PRIORITY", "type": "esriFieldTypeString", "alias": "PRIORITY", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "PRIORITY" }, { "name": "NUMDAYSBEFORE", "type": "esriFieldTypeSmallInteger", "alias": "NUMDAYSBEFORE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NUMDAYSBEFORE" }, { "name": "DATETOBEPRINTED", "type": "esriFieldTypeDate", "alias": "DATETOBEPRINTED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATETOBEPRINTED" }, { "name": "DATEPRINTED", "type": "esriFieldTypeDate", "alias": "DATEPRINTED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEPRINTED" }, { "name": "SOURCEWOID", "type": "esriFieldTypeString", "alias": "SOURCEWOID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SOURCEWOID" }, { "name": "WOXCOORDINATE", "type": "esriFieldTypeDouble", "alias": "WOXCOORDINATE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WOXCOORDINATE" }, { "name": "WOYCOORDINATE", "type": "esriFieldTypeDouble", "alias": "WOYCOORDINATE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WOYCOORDINATE" }, { "name": "SHOP", "type": "esriFieldTypeString", "alias": "SHOP", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "SHOP" }, { "name": "WOCATEGORY", "type": "esriFieldTypeString", "alias": "WOCATEGORY", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WOCATEGORY" }, { "name": "WOCOST", "type": "esriFieldTypeDouble", "alias": "WOCOST", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WOCOST" }, { "name": "WOLABORCOST", "type": "esriFieldTypeDouble", "alias": "WOLABORCOST", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WOLABORCOST" }, { "name": "WOMATCOST", "type": "esriFieldTypeDouble", "alias": "WOMATCOST", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WOMATCOST" }, { "name": "WOEQUIPCOST", "type": "esriFieldTypeDouble", "alias": "WOEQUIPCOST", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WOEQUIPCOST" }, { "name": "WOPERMITCOST", "type": "esriFieldTypeDouble", "alias": "WOPERMITCOST", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WOPERMITCOST" }, { "name": "SUBMITTO", "type": "esriFieldTypeString", "alias": "SUBMITTO", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SUBMITTO" }, { "name": "DATESUBMITTO", "type": "esriFieldTypeDate", "alias": "DATESUBMITTO", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATESUBMITTO" }, { "name": "SUBMITTOOPENBY", "type": "esriFieldTypeString", "alias": "SUBMITTOOPENBY", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SUBMITTOOPENBY" }, { "name": "DATESUBMITTOOPEN", "type": "esriFieldTypeDate", "alias": "DATESUBMITTOOPEN", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATESUBMITTOOPEN" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STATUS" }, { "name": "WORKCOMPLETEDBY", "type": "esriFieldTypeString", "alias": "WORKCOMPLETEDBY", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WORKCOMPLETEDBY" }, { "name": "DATEWOCLOSED", "type": "esriFieldTypeDate", "alias": "DATEWOCLOSED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEWOCLOSED" }, { "name": "MAPPAGE", "type": "esriFieldTypeString", "alias": "MAPPAGE", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "MAPPAGE" }, { "name": "LEGALBILLABLE", "type": "esriFieldTypeString", "alias": "LEGALBILLABLE", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "LEGALBILLABLE" }, { "name": "CONTRBILLABLE", "type": "esriFieldTypeString", "alias": "CONTRBILLABLE", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "CONTRBILLABLE" }, { "name": "CANCELLEDBY", "type": "esriFieldTypeString", "alias": "CANCELLEDBY", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CANCELLEDBY" }, { "name": "DATECANCELLED", "type": "esriFieldTypeDate", "alias": "DATECANCELLED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATECANCELLED" }, { "name": "APPLYTOENTITY", "type": "esriFieldTypeString", "alias": "APPLYTOENTITY", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "APPLYTOENTITY" }, { "name": "ASSETGROUP", "type": "esriFieldTypeString", "alias": "ASSETGROUP", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ASSETGROUP" }, { "name": "WOADDRESS", "type": "esriFieldTypeString", "alias": "WOADDRESS", "domain": null, "editable": true, "nullable": true, "length": 130, "defaultValue": null, "modelName": "WOADDRESS" }, { "name": "CREATEDBYCYCLE", "type": "esriFieldTypeString", "alias": "CREATEDBYCYCLE", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "CREATEDBYCYCLE" }, { "name": "TRANSTOWOID", "type": "esriFieldTypeString", "alias": "TRANSTOWOID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "TRANSTOWOID" }, { "name": "EXPENSETYPE", "type": "esriFieldTypeString", "alias": "EXPENSETYPE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "EXPENSETYPE" }, { "name": "CANCELREASON", "type": "esriFieldTypeString", "alias": "CANCELREASON", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "CANCELREASON" }, { "name": "DISTRICT", "type": "esriFieldTypeString", "alias": "DISTRICT", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DISTRICT" }, { "name": "RESOLUTION", "type": "esriFieldTypeString", "alias": "RESOLUTION", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "RESOLUTION" }, { "name": "ISREACTIVE", "type": "esriFieldTypeString", "alias": "ISREACTIVE", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "ISREACTIVE" }, { "name": "SUPERVISORSID", "type": "esriFieldTypeInteger", "alias": "SUPERVISORSID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SUPERVISORSID" }, { "name": "REQUESTEDBYSID", "type": "esriFieldTypeInteger", "alias": "REQUESTEDBYSID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "REQUESTEDBYSID" }, { "name": "INITIATEDBYSID", "type": "esriFieldTypeInteger", "alias": "INITIATEDBYSID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INITIATEDBYSID" }, { "name": "SUBMITTOSID", "type": "esriFieldTypeInteger", "alias": "SUBMITTOSID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SUBMITTOSID" }, { "name": "SUBMITTOOPENBYSID", "type": "esriFieldTypeInteger", "alias": "SUBMITTOOPENBYSID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SUBMITTOOPENBYSID" }, { "name": "WORKCOMPLETEDBYSID", "type": "esriFieldTypeInteger", "alias": "WORKCOMPLETEDBYSID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WORKCOMPLETEDBYSID" }, { "name": "CANCELLEDBYSID", "type": "esriFieldTypeInteger", "alias": "CANCELLEDBYSID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CANCELLEDBYSID" }, { "name": "CLOSEDBYSID", "type": "esriFieldTypeInteger", "alias": "CLOSEDBYSID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CLOSEDBYSID" }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "ESRI_OID" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "Shape", "fields": "Shape", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Cityworks Workorders", "description": "", "prototype": { "attributes": { "CANCELLEDBYSID": null, "WORKORDERID": " ", "DESCRIPTION": null, "SUPERVISOR": null, "REQUESTEDBY": null, "INITIATEDBY": null, "INITIATEDATE": null, "LOCATION": null, "PROJSTARTDATE": null, "PROJFINISHDATE": null, "ACTUALSTARTDATE": null, "ACTUALFINISHDATE": null, "WOCLOSEDBY": null, "CANCEL": null, "PRIORITY": null, "NUMDAYSBEFORE": null, "DATETOBEPRINTED": null, "DATEPRINTED": null, "SOURCEWOID": null, "WOXCOORDINATE": null, "WOYCOORDINATE": null, "SHOP": null, "WOCATEGORY": null, "WOCOST": null, "WOLABORCOST": null, "WOMATCOST": null, "WOEQUIPCOST": null, "WOPERMITCOST": null, "SUBMITTO": null, "DATESUBMITTO": null, "SUBMITTOOPENBY": null, "DATESUBMITTOOPEN": null, "STATUS": null, "WORKCOMPLETEDBY": null, "DATEWOCLOSED": null, "MAPPAGE": null, "LEGALBILLABLE": null, "CONTRBILLABLE": null, "CANCELLEDBY": null, "DATECANCELLED": null, "APPLYTOENTITY": null, "ASSETGROUP": null, "WOADDRESS": null, "CREATEDBYCYCLE": null, "TRANSTOWOID": null, "EXPENSETYPE": null, "CANCELREASON": null, "DISTRICT": null, "RESOLUTION": null, "ISREACTIVE": null, "SUPERVISORSID": null, "REQUESTEDBYSID": null, "INITIATEDBYSID": null, "SUBMITTOSID": null, "SUBMITTOOPENBYSID": null, "WORKCOMPLETEDBYSID": null, "CLOSEDBYSID": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "bd08ea42a316460a9c304d4d43903950" }