{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "dbo.ViewSnowRoute_GIS_12HR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SnowRouteNameNumber", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "WorkOrderID", "type": "esriFieldTypeInteger", "alias": "WorkOrderID", "domain": null }, { "name": "WODate", "type": "esriFieldTypeDate", "alias": "WODate", "length": 8, "domain": null }, { "name": "StatuReference", "type": "esriFieldTypeString", "alias": "StatuReference", "length": 75, "domain": null }, { "name": "SnowRouteNameNumber", "type": "esriFieldTypeString", "alias": "SnowRouteNameNumber", "length": 81, "domain": null }, { "name": "RouteName", "type": "esriFieldTypeString", "alias": "RouteName", "length": 75, "domain": null }, { "name": "RouteNumber", "type": "esriFieldTypeInteger", "alias": "RouteNumber", "domain": null }, { "name": "AssetIDNumber", "type": "esriFieldTypeString", "alias": "AssetIDNumber", "length": 50, "domain": null }, { "name": "DriverLastName", "type": "esriFieldTypeString", "alias": "DriverLastName", "length": 75, "domain": null }, { "name": "DriverFirstName", "type": "esriFieldTypeString", "alias": "DriverFirstName", "length": 75, "domain": null }, { "name": "TimeComplete", "type": "esriFieldTypeString", "alias": "TimeComplete", "length": 10, "domain": null }, { "name": "SolidApplicationRate", "type": "esriFieldTypeSingle", "alias": "SolidApplicationRate", "domain": null }, { "name": "LiquidApplicationRate", "type": "esriFieldTypeSingle", "alias": "LiquidApplicationRate", "domain": null }, { "name": "IsPlowOnly", "type": "esriFieldTypeSmallInteger", "alias": "IsPlowOnly", "domain": null }, { "name": "IsIceBlade", "type": "esriFieldTypeSmallInteger", "alias": "IsIceBlade", "domain": null }, { "name": "SolidMeasure", "type": "esriFieldTypeString", "alias": "SolidMeasure", "length": 50, "domain": null }, { "name": "LiquidApplicationType", "type": "esriFieldTypeString", "alias": "LiquidApplicationType", "length": 75, "domain": null }, { "name": "SolidApplicationType", "type": "esriFieldTypeString", "alias": "SolidApplicationType", "length": 75, "domain": null }, { "name": "LiquidMeasure", "type": "esriFieldTypeString", "alias": "LiquidMeasure", "length": 50, "domain": null }, { "name": "CreateDate", "type": "esriFieldTypeDate", "alias": "CreateDate", "length": 8, "domain": null }, { "name": "RowNumber", "type": "esriFieldTypeDouble", "alias": "RowNumber", "domain": null }, { "name": "PassNumber", "type": "esriFieldTypeInteger", "alias": "PassNumber", "domain": null }, { "name": "LabelName", "type": "esriFieldTypeString", "alias": "LabelName", "length": 36, "domain": null }, { "name": "DateComplete", "type": "esriFieldTypeDate", "alias": "DateComplete", "length": 8, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "30437e4526964fc5813908219d9e0535" }