Department of Population Medicine, Ontario Veterinary College, University of Guelph, Guelph, Ontario, Canada.
Animal Health Laboratory, University of Guelph, Guelph, Ontario, Canada.
J Vet Diagn Invest. 2023 Nov;35(6):727-736. doi: 10.1177/10406387231190076. Epub 2023 Aug 4.
The advancement of web-based technologies makes it possible to build user interfaces or web pages that present and summarize complex data in easy-to-read graphical formats that emphasize key information. Taking advantage of this technologic progress, we addressed the need for real-time visualizations of trends for major pathogens in the largest livestock industries in Ontario: poultry, swine, and cattle. These visualizations were built using test data from the laboratory information management system of the Animal Health Laboratory at the University of Guelph, a large veterinary diagnostic laboratory in Ontario. The data were processed using R software and used to construct interactive and dynamic visualizations using Tableau Desktop v.2021.4 (Tableau Software). We designed 12 dashboards: in chickens-influenza A virus, fowl adenovirus, infectious bronchitis virus, and infectious laryngotracheitis virus; in turkeys-influenza A virus; in swine, influenza A virus, rotavirus, and porcine reproductive and respiratory syndrome virus; in cattle-bovine viral diarrhea virus, , Dublin in individual samples, and Dublin in bulk tank milk samples. Data for each pathogen are presented in 2 dashboards. One shows the data of the last 10 y (general view) and the other the data of the last 3 y, but in more detail (comprehensive view). Information on gaining access to all dashboards is available at https://iapd.lsd.uoguelph.ca/. The visualizations provide near-real-time access to aggregated assay results for selected pathogens for veterinarians, animal health regulatory agencies, researchers, and other users who are interested in livestock pathogen surveillance.
基于网络的技术进步使得构建用户界面或网页成为可能,这些界面或网页以易于阅读的图形格式呈现和总结复杂数据,突出关键信息。利用这一技术进步,我们满足了安大略省最大的畜牧业(家禽、猪和牛)中主要病原体趋势的实时可视化需求。这些可视化效果是利用圭尔夫大学动物健康实验室的实验室信息管理系统中的测试数据构建的,该实验室是安大略省的一个大型兽医诊断实验室。数据使用 R 软件进行处理,并使用 Tableau Desktop v.2021.4(Tableau Software)构建交互式和动态可视化效果。我们设计了 12 个仪表板:在鸡中-流感 A 病毒、禽腺病毒、传染性支气管炎病毒和传染性喉气管炎病毒;在火鸡中-流感 A 病毒;在猪中-流感 A 病毒、轮状病毒和猪繁殖与呼吸综合征病毒;在牛中-牛病毒性腹泻病毒、 、 都柏林病毒在个体样本中和 都柏林病毒在批量牛奶样本中。每个病原体的数据都在 2 个仪表板中呈现。一个显示过去 10 年的数据(概览),另一个显示过去 3 年的数据,但更详细(综合视图)。有关访问所有仪表板的信息可在 https://iapd.lsd.uoguelph.ca/ 上获取。这些可视化效果为兽医、动物健康监管机构、研究人员和其他对牲畜病原体监测感兴趣的用户提供了选定病原体的近实时聚合检测结果。