{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "ESR_PROD", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LoggedByName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "ServiceRequestID", "type": "esriFieldTypeString", "alias": "ServiceRequestID", "length": 100, "domain": null }, { "name": "LoggedByName", "type": "esriFieldTypeString", "alias": "LoggedByName", "length": 50, "domain": null }, { "name": "Logged_Date", "type": "esriFieldTypeDate", "alias": "Logged_Date", "length": 8, "domain": null }, { "name": "TypeName", "type": "esriFieldTypeString", "alias": "TypeName", "length": 50, "domain": null }, { "name": "DepartmentName", "type": "esriFieldTypeString", "alias": "DepartmentName", "length": 80, "domain": null }, { "name": "GroupName", "type": "esriFieldTypeString", "alias": "GroupName", "length": 50, "domain": null }, { "name": "IssueID", "type": "esriFieldTypeInteger", "alias": "IssueID", "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 128, "domain": null }, { "name": "AssignedToName", "type": "esriFieldTypeString", "alias": "AssignedToName", "length": 100, "domain": null }, { "name": "Assigned_Date", "type": "esriFieldTypeDate", "alias": "Assigned_Date", "length": 8, "domain": null }, { "name": "StatusName", "type": "esriFieldTypeString", "alias": "StatusName", "length": 6, "domain": null }, { "name": "Opened_Date", "type": "esriFieldTypeDate", "alias": "Opened_Date", "length": 8, "domain": null }, { "name": "Resolved_Date", "type": "esriFieldTypeDate", "alias": "Resolved_Date", "length": 8, "domain": null }, { "name": "Closed_Date", "type": "esriFieldTypeDate", "alias": "Closed_Date", "length": 8, "domain": null }, { "name": "ClosedByName", "type": "esriFieldTypeString", "alias": "ClosedByName", "length": 50, "domain": null }, { "name": "Duration", "type": "esriFieldTypeInteger", "alias": "Duration", "domain": null }, { "name": "BohRoadOpsAssignment", "type": "esriFieldTypeString", "alias": "BohRoadOpsAssignment", "length": 150, "domain": null }, { "name": "BohAddressNo", "type": "esriFieldTypeString", "alias": "BohAddressNo", "length": 50, "domain": null }, { "name": "BohAddressStreet", "type": "esriFieldTypeString", "alias": "BohAddressStreet", "length": 150, "domain": null }, { "name": "BohAddressStreetType", "type": "esriFieldTypeString", "alias": "BohAddressStreetType", "length": 50, "domain": null }, { "name": "BohAddressCity", "type": "esriFieldTypeString", "alias": "BohAddressCity", "length": 50, "domain": null }, { "name": "BohAddressZip", "type": "esriFieldTypeString", "alias": "BohAddressZip", "length": 50, "domain": null }, { "name": "BohSubdivision", "type": "esriFieldTypeString", "alias": "BohSubdivision", "length": 150, "domain": null }, { "name": "BohIntersection1", "type": "esriFieldTypeString", "alias": "BohIntersection1", "length": 150, "domain": null }, { "name": "BohIntersection2", "type": "esriFieldTypeString", "alias": "BohIntersection2", "length": 150, "domain": null }, { "name": "BohLocationDescription", "type": "esriFieldTypeString", "alias": "BohLocationDescription", "length": 1024, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 2048, "domain": null }, { "name": "BohAdcMapPageGrid", "type": "esriFieldTypeString", "alias": "BohAdcMapPageGrid", "length": 50, "domain": null }, { "name": "BohEsrRoadPassable", "type": "esriFieldTypeString", "alias": "BohEsrRoadPassable", "length": 150, "domain": null }, { "name": "BohEsrRoadClosedby", "type": "esriFieldTypeString", "alias": "BohEsrRoadClosedby", "length": 50, "domain": null }, { "name": "BohEsrSnowIce", "type": "esriFieldTypeSmallInteger", "alias": "BohEsrSnowIce", "domain": null }, { "name": "BohEsrTrees", "type": "esriFieldTypeSmallInteger", "alias": "BohEsrTrees", "domain": null }, { "name": "BohEsrFlooded", "type": "esriFieldTypeSmallInteger", "alias": "BohEsrFlooded", "domain": null }, { "name": "BohEsrWires", "type": "esriFieldTypeSmallInteger", "alias": "BohEsrWires", "domain": null }, { "name": "BohEsrBgeContacted", "type": "esriFieldTypeSmallInteger", "alias": "BohEsrBgeContacted", "domain": null }, { "name": "BohEsrBgeRef", "type": "esriFieldTypeString", "alias": "BohEsrBgeRef", "length": 50, "domain": null }, { "name": "BohSnowContractorCode", "type": "esriFieldTypeString", "alias": "BohSnowContractorCode", "length": 50, "domain": null }, { "name": "BohSnowRemovalPriorityLos", "type": "esriFieldTypeString", "alias": "BohSnowRemovalPriorityLos", "length": 50, "domain": null }, { "name": "BohSegidNo", "type": "esriFieldTypeString", "alias": "BohSegidNo", "length": 50, "domain": null }, { "name": "BohRoadOwnership", "type": "esriFieldTypeString", "alias": "BohRoadOwnership", "length": 50, "domain": null }, { "name": "BuoWaterEmergency", "type": "esriFieldTypeSmallInteger", "alias": "BuoWaterEmergency", "domain": null }, { "name": "BuoSewerEmergency", "type": "esriFieldTypeSmallInteger", "alias": "BuoSewerEmergency", "domain": null }, { "name": "BuoRoadClosedBy", "type": "esriFieldTypeString", "alias": "BuoRoadClosedBy", "length": 150, "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null } ], "indexes": [ { "name": "FDO_ID", "fields": "ID", "isAscending": true, "isUnique": true, "description": "" } ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "d50fc7a53a1a4a4db0279a4ae66833fc" }