{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Parking Stalls to Paint Query", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "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": 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": -85.86782836899994, "ymin": 41.23765564000007, "xmax": -85.86782836899994, "ymax": 41.23765564000007, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "a837628e37be1c76db0d1115610027e9", "imageData": "iVBORw0KGgoAAAANSUhEUgAAACIAAAAiCAYAAAA6RwvCAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACaklEQVRYhe3WS2sTURTA8f9JioKgbmq3FZe29TNUUKSIG21m1A9QRHx02abVpt258l1qCShYqJnEghTcZVJ3LvwQ6kJolYIuFB+Z48JpnEwzcyfT0Cr0QBY5uefe3zxy7+niH4munQZsxC4kHKkhqggV7EDqm+R4se0QVsiiLAYyq7ATkA6HEaIVjuFRBIbF4n07k2uFPjweU8eSC7xNDdFn9ONRBbqBmjocT4rxES7QQ5aaPmdQzvGubYgu0cMvXB8BcCQpxr8AFzjkpw5Tx9VlBuQMX9uCyFnW1GEemAikGxjgQyQi04TYiNtRiFgIgFhMahlByYcxrHMyMUK4JjkexK1lfFklx4SWEITxJkwdNzR0f0uEcl0s7pvWSfT3FZu8OggwFkj3hobt8z/BGBWbe0nWSLyPiMW4OhDCxMWoWNxNOv8miJa5inI6puY7sNcw7xdgSB2GWv6qLIjNQiwEjz6EU4aFTHEAYud4HU78P1v8dsVmSJ0p9nCn5WhlAOUp5nfkM3CeTMT58oNPRohcZJU/R3qzwWEAeJgAAXAQmOMng6bDLhLSKnxElebNSgGJ+d5LlhVdTIYxtwHRiEvAo0BuDZgFptNg4tuAKIQwQjdP+NgEQSxmtEQGYapdjKkNaHknJEdRa61rxaagZTIoN0IYV5fpT9cGlJgNXJ2iXBab+aiaRm2Om+qQ4W8LoQi30rcBNgV18IBphCtiMWdCNGotJv3HNIYwIjmKcePNbYDFjFZ4KcO8SYpo1NrktcJSktpkbUAKRLu16bf4V3gcpRrIrKeeaysQKeABJ7ayeEcgnY5dSDh+A+viz50+fErDAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 25, "height": 25, "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": "TaskID", "globalIdField": "", "displayField": "CompletedByFirstName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "TaskID", "type": "esriFieldTypeOID", "alias": "TaskID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "TaskID" }, { "name": "ServiceOrderDetailID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ServiceOrderDetailID" }, { "name": "CreatedByID", "type": "esriFieldTypeInteger", "alias": "CreatedByID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CreatedByID" }, { "name": "DateCreated", "type": "esriFieldTypeDate", "alias": "DateCreated", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "DateCreated" }, { "name": "ScheduledStartDate", "type": "esriFieldTypeDate", "alias": "ScheduledStartDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ScheduledStartDate" }, { "name": "ScheduledEndDate", "type": "esriFieldTypeDate", "alias": "ScheduledEndDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ScheduledEndDate" }, { "name": "ActualStartDate", "type": "esriFieldTypeDate", "alias": "ActualStartDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ActualStartDate" }, { "name": "ActualEndDate", "type": "esriFieldTypeDate", "alias": "ActualEndDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ActualEndDate" }, { "name": "Priority", "type": "esriFieldTypeString", "alias": "Priority", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Priority" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Status" }, { "name": "TaskType", "type": "esriFieldTypeString", "alias": "TaskType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TaskType" }, { "name": "Completed", "type": "esriFieldTypeSmallInteger", "alias": "Completed", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "Completed" }, { "name": "IsWorkItemType", "type": "esriFieldTypeSmallInteger", "alias": "IsWorkItemType", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsWorkItemType" }, { "name": "ServiceOrderNumber", "type": "esriFieldTypeString", "alias": "ServiceOrderNumber", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "ServiceOrderNumber" }, { "name": "ServiceOrderID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ServiceOrderID" }, { "name": "IsLocation", "type": "esriFieldTypeSmallInteger", "alias": "IsLocation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsLocation" }, { "name": "LocationID", "type": "esriFieldTypeString", "alias": "LocationID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "LocationID" }, { "name": "LocationNo", "type": "esriFieldTypeString", "alias": "LocationNo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LocationNo" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Location" }, { "name": "IsCustomer", "type": "esriFieldTypeSmallInteger", "alias": "IsCustomer", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsCustomer" }, { "name": "CustomerID", "type": "esriFieldTypeString", "alias": "CustomerID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "CustomerID" }, { "name": "CustomerNo", "type": "esriFieldTypeString", "alias": "CustomerNo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CustomerNo" }, { "name": "Customer", "type": "esriFieldTypeString", "alias": "Customer", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Customer" }, { "name": "IsService", "type": "esriFieldTypeSmallInteger", "alias": "IsService", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsService" }, { "name": "ServiceID", "type": "esriFieldTypeString", "alias": "ServiceID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "ServiceID" }, { "name": "Service", "type": "esriFieldTypeString", "alias": "Service", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Service" }, { "name": "IsMeter", "type": "esriFieldTypeSmallInteger", "alias": "IsMeter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsMeter" }, { "name": "MeterID", "type": "esriFieldTypeString", "alias": "MeterID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "MeterID" }, { "name": "MeterNo", "type": "esriFieldTypeString", "alias": "MeterNo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MeterNo" }, { "name": "IsGISAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsGISAsset", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsGISAsset" }, { "name": "GISFileID", "type": "esriFieldTypeInteger", "alias": "GISFileID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GISFileID" }, { "name": "GISLayer", "type": "esriFieldTypeString", "alias": "GISLayer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GISLayer" }, { "name": "IsAsset", "type": "esriFieldTypeSmallInteger", "alias": "IsAsset", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsAsset" }, { "name": "SchemaDocGuid", "type": "esriFieldTypeGUID", "alias": "SchemaDocGuid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "SchemaDocGuid" }, { "name": "UtilityBillingServiceCodeTypeID", "type": "esriFieldTypeInteger", "alias": "UtilityBillingServiceCodeTypeID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UtilityBillingServiceCodeTypeID" }, { "name": "IsUtilityBillingServiceOrder", "type": "esriFieldTypeSmallInteger", "alias": "IsUtilityBillingServiceOrder", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsUtilityBillingServiceOrder" }, { "name": "FeePosted", "type": "esriFieldTypeSmallInteger", "alias": "FeePosted", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FeePosted" }, { "name": "PriorityColor", "type": "esriFieldTypeString", "alias": "PriorityColor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PriorityColor" }, { "name": "FeeAmount", "type": "esriFieldTypeDouble", "alias": "FeeAmount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FeeAmount" }, { "name": "CompletedByFirstName", "type": "esriFieldTypeString", "alias": "CompletedByFirstName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CompletedByFirstName" }, { "name": "CompletedByLast", "type": "esriFieldTypeString", "alias": "CompletedByLast", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CompletedByLast" }, { "name": "LastModifiedByID", "type": "esriFieldTypeInteger", "alias": "LastModifiedByID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LastModifiedByID" }, { "name": "LastModified", "type": "esriFieldTypeDate", "alias": "LastModified", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LastModified" }, { "name": "PriorityID", "type": "esriFieldTypeInteger", "alias": "PriorityID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PriorityID" }, { "name": "StatusID", "type": "esriFieldTypeInteger", "alias": "StatusID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "StatusID" }, { "name": "TaskTypeID", "type": "esriFieldTypeInteger", "alias": "TaskTypeID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TaskTypeID" }, { "name": "ServiceOrderDetailTypeID", "type": "esriFieldTypeInteger", "alias": "ServiceOrderDetailTypeID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceOrderDetailTypeID" }, { "name": "LOC_Address", "type": "esriFieldTypeString", "alias": "LOC_Address", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "LOC_Address" }, { "name": "LOC_City", "type": "esriFieldTypeString", "alias": "LOC_City", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "LOC_City" }, { "name": "CUST_Name", "type": "esriFieldTypeString", "alias": "CUST_Name", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "CUST_Name" }, { "name": "GIS_AssetTag", "type": "esriFieldTypeString", "alias": "GIS_AssetTag", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "GIS_AssetTag" }, { "name": "AssetNo", "type": "esriFieldTypeInteger", "alias": "AssetNo", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AssetNo" }, { "name": "ASSET_AssetTag", "type": "esriFieldTypeString", "alias": "ASSET_AssetTag", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "ASSET_AssetTag" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AssetID" }, { "name": "AssetLocation", "type": "esriFieldTypeString", "alias": "AssetLocation", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "AssetLocation" }, { "name": "AssetStatus", "type": "esriFieldTypeString", "alias": "AssetStatus", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AssetStatus" }, { "name": "AssetType", "type": "esriFieldTypeString", "alias": "AssetType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AssetType" }, { "name": "TaskAssignmentCrews", "type": "esriFieldTypeString", "alias": "TaskAssignmentCrews", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "TaskAssignmentCrews" }, { "name": "TaskAssignmentUsers", "type": "esriFieldTypeString", "alias": "TaskAssignmentUsers", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "TaskAssignmentUsers" }, { "name": "TaskAssignmentContacts", "type": "esriFieldTypeString", "alias": "TaskAssignmentContacts", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "TaskAssignmentContacts" }, { "name": "GISAssetNo", "type": "esriFieldTypeString", "alias": "GISAssetNo", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "GISAssetNo" }, { "name": "DivisionID", "type": "esriFieldTypeInteger", "alias": "DivisionID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "DivisionID" }, { "name": "Expr1", "type": "esriFieldTypeInteger", "alias": "Expr1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Expr1" }, { "name": "NoteCount", "type": "esriFieldTypeInteger", "alias": "NoteCount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NoteCount" }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null, "modelName": "Division" }, { "name": "Problem", "type": "esriFieldTypeString", "alias": "Problem", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Problem" }, { "name": "ResourcesCount", "type": "esriFieldTypeInteger", "alias": "ResourcesCount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ResourcesCount" }, { "name": "ServiceOrderCategory", "type": "esriFieldTypeString", "alias": "ServiceOrderCategory", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ServiceOrderCategory" }, { "name": "ServiceOrderDescription", "type": "esriFieldTypeString", "alias": "ServiceOrderDescription", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "ServiceOrderDescription" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Type" }, { "name": "Resolution", "type": "esriFieldTypeString", "alias": "Resolution", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Resolution" }, { "name": "Total_Labor_Hours", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Labor_Hours" }, { "name": "Total_Labor_Cost", "type": "esriFieldTypeDouble", "alias": "Total_Labor_Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Labor_Cost" }, { "name": "Total_Inventory_fCost", "type": "esriFieldTypeDouble", "alias": "Total_Inventory_fCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Total_Inventory_fCost" } ], "geometryField": { "name": "GeoShape", "type": "esriFieldTypeGeometry", "alias": "GeoShape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GeoShape" }, "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Parking Stalls to Paint Query", "description": "", "prototype": { "attributes": {} }, "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": "7944f6c6cff34b69b6ec160aab2b14af" }