{ "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 0, "name": "Leaks with Employees and Equipment", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "location", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "location", "type": "esriFieldTypeString", "alias": "location", "length": 250, "domain": null }, { "name": "type", "type": "esriFieldTypeString", "alias": "type", "length": 50, "domain": null }, { "name": "pipe_type", "type": "esriFieldTypeString", "alias": "pipe_type", "length": 50, "domain": null }, { "name": "repair_type", "type": "esriFieldTypeString", "alias": "repair_type", "length": 50, "domain": null }, { "name": "pipe_size", "type": "esriFieldTypeDouble", "alias": "pipe_size", "domain": null }, { "name": "valve_size", "type": "esriFieldTypeDouble", "alias": "valve_size", "domain": null }, { "name": "rep_month", "type": "esriFieldTypeString", "alias": "rep_month", "length": 25, "domain": null }, { "name": "rep_year", "type": "esriFieldTypeString", "alias": "rep_year", "length": 25, "domain": null }, { "name": "rep_date", "type": "esriFieldTypeDate", "alias": "rep_date", "length": 8, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "length": 1073741822, "domain": null }, { "name": "cause", "type": "esriFieldTypeString", "alias": "cause", "length": 50, "domain": null }, { "name": "depth", "type": "esriFieldTypeString", "alias": "depth", "length": 50, "domain": null }, { "name": "distance", "type": "esriFieldTypeString", "alias": "distance", "length": 50, "domain": null }, { "name": "main_or_service", "type": "esriFieldTypeString", "alias": "main_or_service", "length": 25, "domain": null }, { "name": "depthtemp", "type": "esriFieldTypeDouble", "alias": "depthtemp", "domain": null }, { "name": "flushamt", "type": "esriFieldTypeDouble", "alias": "flushamt", "domain": null }, { "name": "streetrepair", "type": "esriFieldTypeString", "alias": "streetrepair", "length": 10, "domain": null }, { "name": "dnrrequired", "type": "esriFieldTypeString", "alias": "dnrrequired", "length": 10, "domain": null }, { "name": "bactsample", "type": "esriFieldTypeString", "alias": "bactsample", "length": 10, "domain": null }, { "name": "waterloss", "type": "esriFieldTypeDouble", "alias": "waterloss", "domain": null }, { "name": "parts", "type": "esriFieldTypeString", "alias": "parts", "length": 500, "domain": null }, { "name": "lessthansix", "type": "esriFieldTypeString", "alias": "lessthansix", "length": 10, "domain": null }, { "name": "streetcutsize", "type": "esriFieldTypeDouble", "alias": "streetcutsize", "domain": null }, { "name": "streetcutmaterial", "type": "esriFieldTypeString", "alias": "streetcutmaterial", "length": 50, "domain": null }, { "name": "sidewalkrepairyn", "type": "esriFieldTypeString", "alias": "sidewalkrepairyn", "length": 10, "domain": null }, { "name": "sidewalkrepairsize", "type": "esriFieldTypeDouble", "alias": "sidewalkrepairsize", "domain": null }, { "name": "sidewalkrepairmaterial", "type": "esriFieldTypeString", "alias": "sidewalkrepairmaterial", "length": 50, "domain": null }, { "name": "employee", "type": "esriFieldTypeString", "alias": "employee", "length": 4000, "domain": null }, { "name": "hours", "type": "esriFieldTypeDouble", "alias": "hours", "domain": null }, { "name": "equipment", "type": "esriFieldTypeString", "alias": "equipment", "length": 4000, "domain": null }, { "name": "hours_qty", "type": "esriFieldTypeDouble", "alias": "hours_qty", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 6000, "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 }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }