{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 39, "name": "MLI", "type": "Table", "description": "", "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": false, "supportsCalculate": true, "supportsASyncCalculate": 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, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "inspection_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "mli_id", "type": "esriFieldTypeDouble", "alias": "MLI_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "mli_id" }, { "name": "ml_id", "type": "esriFieldTypeDouble", "alias": "ML_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ml_id" }, { "name": "inspection_name", "type": "esriFieldTypeString", "alias": "Inspection_Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "inspection_name" }, { "name": "operator", "type": "esriFieldTypeString", "alias": "Operator", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "operator" }, { "name": "remark", "type": "esriFieldTypeString", "alias": "Remark", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "remark" }, { "name": "reason_of_inspection", "type": "esriFieldTypeString", "alias": "Reason_of_Inspection", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "reason_of_inspection" }, { "name": "wo_number", "type": "esriFieldTypeString", "alias": "WO_Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "wo_number" }, { "name": "cleaned", "type": "esriFieldTypeString", "alias": "Cleaned", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "cleaned" }, { "name": "clean_date", "type": "esriFieldTypeString", "alias": "Clean_Date", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "clean_date" }, { "name": "flow_control", "type": "esriFieldTypeString", "alias": "Flow_Control", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "flow_control" }, { "name": "inspection_direction", "type": "esriFieldTypeString", "alias": "Inspection_Direction", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "inspection_direction" }, { "name": "inspected_length", "type": "esriFieldTypeDouble", "alias": "Inspected_Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "inspected_length" }, { "name": "start_time", "type": "esriFieldTypeDate", "alias": "Start_Time", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "start_time" }, { "name": "po_number", "type": "esriFieldTypeString", "alias": "PO_Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "po_number" }, { "name": "creation_date", "type": "esriFieldTypeDate", "alias": "Creation_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "creation_date" }, { "name": "sheet_number", "type": "esriFieldTypeString", "alias": "Sheet_Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "sheet_number" }, { "name": "weather", "type": "esriFieldTypeString", "alias": "Weather", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "weather" }, { "name": "present", "type": "esriFieldTypeString", "alias": "Present", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "present" }, { "name": "completed", "type": "esriFieldTypeDouble", "alias": "Completed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "completed" }, { "name": "camera", "type": "esriFieldTypeString", "alias": "Camera", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "camera" }, { "name": "end_time", "type": "esriFieldTypeDate", "alias": "End_Time", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "end_time" }, { "name": "inspection_date", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "inspection_date" }, { "name": "last_modified_date", "type": "esriFieldTypeDate", "alias": "Last_Modified_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_modified_date" }, { "name": "status", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "status" }, { "name": "vehicle", "type": "esriFieldTypeString", "alias": "Vehicle", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "vehicle" }, { "name": "van", "type": "esriFieldTypeString", "alias": "Van", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "van" }, { "name": "tally_4", "type": "esriFieldTypeDouble", "alias": "Tally_4", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "tally_4" }, { "name": "tally_3", "type": "esriFieldTypeDouble", "alias": "Tally_3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "tally_3" }, { "name": "tally_2", "type": "esriFieldTypeDouble", "alias": "Tally_2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "tally_2" }, { "name": "tally_1", "type": "esriFieldTypeDouble", "alias": "Tally_1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "tally_1" }, { "name": "spri", "type": "esriFieldTypeString", "alias": "SPRI", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "spri" }, { "name": "mpri", "type": "esriFieldTypeString", "alias": "MPRI", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "mpri" }, { "name": "mpr", "type": "esriFieldTypeString", "alias": "MPR", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "mpr" }, { "name": "opr", "type": "esriFieldTypeString", "alias": "OPR", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "opr" }, { "name": "spr", "type": "esriFieldTypeString", "alias": "SPR", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "spr" }, { "name": "total_gallon", "type": "esriFieldTypeString", "alias": "Total_Gallon", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "total_gallon" }, { "name": "joint_unrepair", "type": "esriFieldTypeString", "alias": "Joint_Unrepair", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "joint_unrepair" }, { "name": "joint_failed", "type": "esriFieldTypeString", "alias": "Joint_Failed", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "joint_failed" }, { "name": "pressure_value", "type": "esriFieldTypeDouble", "alias": "Pressure_Value", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pressure_value" }, { "name": "situation", "type": "esriFieldTypeString", "alias": "Situation", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "situation" }, { "name": "joint_tested", "type": "esriFieldTypeString", "alias": "Joint_Tested", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "joint_tested" }, { "name": "joint_passed", "type": "esriFieldTypeString", "alias": "Joint_Passed", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "joint_passed" }, { "name": "opri", "type": "esriFieldTypeString", "alias": "OPRI", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "opri" }, { "name": "inspection_result", "type": "esriFieldTypeString", "alias": "Inspection_Result", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "inspection_result" }, { "name": "customer", "type": "esriFieldTypeString", "alias": "Customer", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "customer" }, { "name": "client_id", "type": "esriFieldTypeString", "alias": "Client_ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "client_id" }, { "name": "wo_status", "type": "esriFieldTypeString", "alias": "WO_Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "wo_status" }, { "name": "grade", "type": "esriFieldTypeDouble", "alias": "Grade", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "grade" }, { "name": "mli_level", "type": "esriFieldTypeString", "alias": "MLI_Level", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "mli_level" }, { "name": "measure_1", "type": "esriFieldTypeString", "alias": "Measure_1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "measure_1" }, { "name": "additional_info", "type": "esriFieldTypeString", "alias": "Additional_Info", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "additional_info" }, { "name": "tally_5", "type": "esriFieldTypeDouble", "alias": "Tally_5", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "tally_5" }, { "name": "isimperial", "type": "esriFieldTypeDouble", "alias": "IsImperial", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "isimperial" }, { "name": "insp_notes", "type": "esriFieldTypeString", "alias": "INSP_NOTES", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "insp_notes" }, { "name": "certificate_number", "type": "esriFieldTypeString", "alias": "Certificate_Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "certificate_number" }, { "name": "media_number", "type": "esriFieldTypeString", "alias": "Media_Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "media_number" }, { "name": "template_name", "type": "esriFieldTypeString", "alias": "Template_Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "template_name" }, { "name": "current_status", "type": "esriFieldTypeString", "alias": "Current_Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "current_status" }, { "name": "qor", "type": "esriFieldTypeString", "alias": "QOR", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "qor" }, { "name": "qsr", "type": "esriFieldTypeString", "alias": "QSR", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "qsr" }, { "name": "qmr", "type": "esriFieldTypeString", "alias": "QMR", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "qmr" }, { "name": "reverse_setup", "type": "esriFieldTypeString", "alias": "Reverse_Setup", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "reverse_setup" }, { "name": "merge_guid", "type": "esriFieldTypeString", "alias": "Merge_GUID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "merge_guid" }, { "name": "qc_status", "type": "esriFieldTypeString", "alias": "QC_Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "qc_status" }, { "name": "ams_inspectiontype", "type": "esriFieldTypeString", "alias": "AMS_InspectionType", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ams_inspectiontype" }, { "name": "inspection_time", "type": "esriFieldTypeDouble", "alias": "Inspection_Time", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "inspection_time" }, { "name": "inspection_valid", "type": "esriFieldTypeString", "alias": "Inspection_Valid", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "inspection_valid" }, { "name": "inspection_sync_error", "type": "esriFieldTypeString", "alias": "Inspection_Sync_Error", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "inspection_sync_error" }, { "name": "syncdate", "type": "esriFieldTypeString", "alias": "SyncDate", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "syncdate" }, { "name": "ml_assetid", "type": "esriFieldTypeString", "alias": "ML_ASSETID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ml_assetid" }, { "name": "needs_lining", "type": "esriFieldTypeString", "alias": "NEEDS_LINING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "needs_lining" } ], "indexes": [ { "name": "r97_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "MLI", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "d207dd603c2642efb6c9064e4806e244" }