An IoT-Based Encapsulated Design System for Rapid Model Identification of Plant Development

Actual and upcoming climate changes will evidently have the largest impact on agriculture crop cultivation in terms of reduced harvest, increased costs, and necessary deviations from traditional farming. The aggravating factor for the successful applications of precision and predictive agriculture is the lack of granulated historical data due to slow, year-round cycles of crops, as a prerequisite for further analysis and modeling. A methodology of plant growth observation with the rapid performance of experiments is presented in this paper. The proposed system enables the collection of data with respect to various climate conditions, which are artificially created and permuted in the encapsulated design, suitable for further correlation with plant development identifiers. The design is equipped with a large number of sensors and connected to the central database in a computer cloud, which enables the interconnection and coordination of multiple geographically distributed devices and related experiments in a remote, autonomous, and real-time manner. Over 40 sensors and up to 24 yearly harvests per device enable the yearly collection of approximately 750,000 correlated database entries, which it is possible to independently stack with higher numbers of devices. Such accumulated data is exploited to develop mathematical models of wheat in different growth stages by applying the concepts of artificial intelligence and utilizing them for the prediction of crop development and harvest.

Application of virtualisation environment for data security in operational data processing systems

This paper presents a concept, developed and tested by the authors, of a virtualisation environment enabling the protection of aggregated data through the use of high availability (HA) of IT systems. The presented solution allows securing the central database system and virtualised server machines by using a scalable environment consisting of physical servers and disk arrays. The authors of this paper focus on ensuring the continuity of system operation and on minimising the risk of failures related to the availability of the operational data analysis system.

A Study on the Usability of Open Spatial Data for Road Network-Based Analysis – Using Openstreetmap as an Example

For several years GIS software users could use for any purpose a dataset being to some extent an alternative to both products offered by commercial providers and official databases. It is OpenStreetMap (OSM for short) – a worldwide spatial dataset, created and edited by interested individuals and available for use by anyone with no limitations. It is built on the basis of data recorded with consumer grade GPS receivers, obtained through vectorization of aerial photographs and from other usable sources, including even sketches made in the field. The collected information is stored in a central database, the content of which is not only presented on the website as a digital map, but also offered for download as vector data. Such data can be used for, among other things, performing various analyses based on road networks, of which the most frequently used is the function of determining the optimal route connecting selected locations. The results of such analyses can only be considered reliable if the data used are of adequate quality. As the OSM database is built by enthusiasts, no plans for its systematic development are formulated and there are no built-in quality control mechanisms. Therefore, the paper proposes methods and tools to verify the usefulness of the data collected so far, as well as to correct detected errors. It focuses on the following categories of geographic data quality: location accuracy, topological consistency and temporal validity. In addition, a problem with determining the length of individual road network segments was noticed, related to data acquisition methods and ways of recording the shape of lines. Therefore, in order to carry out the so-called route calibration, it was suggested to use kilometer and hectometer posts used in transportation networks, the locations of which are successively added to the OSM database. BADANIE UŻYTECZNOŚCI OTWARTYCH DANYCH PRZESTRZENNYCH DO ANALIZ OPARTYCH NA SIECIACH DROGOWYCH – NA PRZYKŁADZIE OPENSTREETMAP Od kilkunastu już lat użytkownicy oprogramowania GIS mogą używać do dowolnych celów zbioru danych będącego do pewnego stopnia alternatywą zarówno dla produktów oferowanych przez dostawców komercyjnych, jak i urzędowych baz danych. Jest nim OpenStreetMap (w skrócie OSM) – obejmujący cały świat zbiór danych przestrzennych, tworzony i edytowany przez zainteresowane osoby i dostępny do stosowania przez każdego chętnego bez żadnych ograniczeń. Budowany jest na podstawie danych rejestrowanych turystycznymi odbiornikami GPS, pozyskiwanych poprzez wektoryzację zdjęć lotniczych oraz pochodzących z innych nadających się do wykorzystania źródeł, w tym nawet szkiców wykonywanych w terenie. Zgromadzona GEOINFORMATICA POLONICA 20: 2021 DOI 10.4467/21995923GP.21.007.14978 informacja zapisywana jest w centralnej bazie danych, której zawartość jest nie tylko prezentowana na stronie internetowej w postaci cyfrowej mapy, lecz również oferowana do pobrania jako dane wektorowe. Takie dane mogą mieć zastosowanie między innymi do przeprowadzania różnorodnych analiz bazujących na sieciach drogowych, z których najczęściej wykorzystywana jest funkcja wyznaczania optymalnej trasy łączącej wybrane lokalizacje. Wyniki takich analiz można uznać za wiarygodne tylko wtedy, gdy użyte w nich dane będą się charakteryzować odpowiednią jakością. Ponieważ baza danych OSM budowana jest przez pasjonatów, nie są formułowane żadne plany jej systematycznego rozwoju oraz brak jest wbudowanych mechanizmów kontroli jakości. Dlatego w artykule zaproponowano metody i narzędzia, które pozwolą na weryfikację przydatności zgromadzonych do tej pory danych, jak również na poprawę wykrytych błędów. Skupiono się na następujących kategoriach jakości danych geograficznych: dokładności położenia, spójności topologicznej oraz ważności czasowej. Dodatkowo dostrzeżono problem z wyznaczaniem długości poszczególnych obiektów sieci drogowej, związany z metodami pozyskiwania danych i sposobami rejestracji kształtu linii. W związku z tym do przeprowadzenia tak zwanej kalibracji trasy zasugerowano użycie stosowanych w sieciach transportowych słupków kilometrowych i hektometrowych, których lokalizacje są sukcesywnie wprowadzane do bazy danych OSM.

Telepharmacy during COVID-19: A Scoping Review

The objective of this scoping review is to summarize the implementation of telepharmacy during the surge of COVID-19. This review will focus on answering four questions: During the COVID-19 pandemic, (1) what were the various telepharmacy initiatives implemented? (2) what were the challenges faced when implementing telehealth initiatives? (3) what were the strategies used by pharmacies to overcome the challenges, and (4) what were some of the innovative methods used by pharmacies to implement telepharmacy? A literature search was conducted to include publications post-March 2020 about telepharmacy implementation via PubMed Central database and Google searches. All articles were examined for inclusion or exclusion based on pre-determined criteria. A total of 33 articles were reviewed. The most commonly observed telepharmacy initiatives were virtual consultations, home delivery of medicines and patient education. Limited access to technology and lack of digital access and literacy were major barriers in the implementation of telepharmacy. New protocols were developed by healthcare systems and regulations were relaxed by countries to accommodate telepharmacy. Pharmacies that successfully implemented telepharmacy overcame these challenges through patient and pharmacist education. The review also revealed the steps that can be taken by pharmacy organizations, payers and entrepreneurs in leveraging the convenience of telepharmacy.

IFSG: Intelligence agriculture crop-pest detection system using IoT automation system

The agricultural and technological combination is blessed for modern world life. Internet of things (IoT) is essential for comfort and development to our agriculture side. In our study, we detected the various pest using different types of sensors and this information has automatically sent to the farmer's mobile for the alert. All these sensors had a central database. Those sensors collect all the data and display the results compared to the central data. The High-image sensor will be able to detect all the rays emitted from the plant and another one is the gas sensor which is able to detect all the gases coming from the diseased plant. We mainly use sound sensor, MQ138, CMOSOV-7670, AMG-8833 for a better automation system. We test it with real-time environment conditions (40°C≤TA≤14°C). Crop pest detection automatic process is more efficient than the other detection process according to testing output. As a result, far-reaching changes in the agricultural sector are possible. To reduce extra cost and increasing more farming ability we need to IoT and Agriculture combinations more.

Semantic IFC Data Model for Automatic Safety Risk Identification in Deep Excavation Projects

Safety risk identification throughout deep excavation construction is an information-intensive task, involving construction information scattered in project planning documentation and dynamic information obtained from different field sensors. However, inefficient information integration and exchange have been an important obstacle to the development of automatic safety risk identification in actual applications. This research aims to achieve the requirements for information integration and exchange by developing a semantic industry foundation classes (IFC) data model based on a central database of Building Information Modeling (BIM) in dynamic deep excavation process. Construction information required for risk identification in dynamic deep excavation is analyzed. The relationships among construction information are identified based on the semantic IFC data model, involved relationships (i.e., logical relationships and constraints among risk events, risk factors, construction parameters, and construction phases), and BIM elements. Furthermore, an automatic safety risk identification approach is presented based on the semantic data model, and it is tested through a construction risk identification prototype established under the BIM environment. Results illustrate the effectiveness of the BIM-based central database in accelerating automatic safety risk identification by linking BIM elements and required construction information corresponding to the dynamic construction process.

SP10.2.11 Horses for Courses – do surgical courses exist outside of the Royal Colleges?

Aims Educational courses supplement deanery-led teaching, and may be mandatory for training progression. The Royal College websites are the first contact for trainees to search for courses, with other courses identified by word of mouth. This project aimed to collate a first comprehensive database of courses available for core and higher general surgical trainees and to identify areas requiring development. Methods A snowballing approach was used to systematically search all online available resources. This includes, but was not limited to, websites of the Royal Colleges, sub-speciality societies, trainee organisations, regional centres, deaneries and surgical technology companies. Course target grade, price, provider and dates were collated into a database. Conferences and symposiums were excluded. Results 47 sources yielded 173 courses, priced between £50 to £1600 (median £450). Technical skills (89/173) and clinical courses (45/173) entailed the majority; only 3 courses developed non-technical skills and 4 developed surgical leadership. Other categories include revision (11.6%), teaching (5.2%), and research skills (1.7%). The Royal Colleges provided 27.7% of all available courses, with the majority developed and delivered by other institutions. There was significant variability in available course information. Conclusions There are a wide variety of courses available for surgical trainees, however this information is fragmented, duplicated and incomplete. A central database requires maintenance, but would provide a reliable source of information. Leadership, research and non-technical skills are critical skills for surgeons – the lack of courses in these areas was surprising and require development as only 4 courses are endorsed by the Royal Colleges.

Development of mobile and desktop applications for a fingerprint-based attendance management system

Mobile application technology has been at the forefront of technological advancement in recent years. This has made life easier, and tasks that were considered herculean have been made easier and executable in a much shorter time than ever. One of such tasks is the process of taking attendance during events (such as lectures and conferences) by scribbling one’s signature and other personal details on a central register. This manual process is cumbersome and inconvenient, especially when a large number of participants are involved. To address this problem, this paper presents an automated solution in which a Java-based mobile application was developed and connected wirelessly to a central database that was created using My structured query language (MySQL) application whose task, among others, was to record attendance information. The database was connected to the backend of the web-based software program which was coded in hypertext pre-processor (PHP) programming language. Authentication was achieved through username, password, and fingerprint information. The system was deployedin a university to log students’ details, time absent, time present and cumulative attendances per month and it was realised that the system was highly effective, efficient and 5 times faster than the conventional paper-based attendance logging technique.

Electronic data collection to enhance disease surveillance at the slaughterhouse in a smallholder production system

Globally, meat inspection provides data for animal health surveillance. However, paper-based recording of data is often not reported through to higher authorities in sufficient detail. We trialled the use of an electronic meat inspection form in Kenyan slaughterhouses, in lieu of the currently used paper-based format. Meat inspectors in two ruminant slaughterhouses completed and submitted an electronic report for each animal slaughtered at their facility. The reports, which captured information on the animal demographics and any eventual condemnations, were stored in a central database and available in real-time. A stakeholder meeting was held towards the end of the study. Over the 2.75 year study period, 16,386 reports were submitted; a downward linear trend in the monthly submissions was noted. There was a week effect, whereby more reports were submitted on the market day. Of the slaughtered animals, 23% had at least a partial condemnation. The most frequently condemned organs were the liver, lungs and intestines; the primary reasons for condemnations were parasitic conditions. Lack of feedback and difficulty capturing animal origin information were the primary challenges highlighted. The study demonstrated that electronic data capture is feasible in such challenging environments, thereby improving the timeliness and resolution of the data collected.

Comparison of functional outcome of simultaneous and staged bilateral total knee arthroplasty : systematic review of literature

Safety of simultaneous bilateral TKA (simBTKA) and staged BTKA (staBTKA) have been compared in previous systematic reviews but functional outcome remains neglected aspect of the debate. We performed a systematic review of contemporary literature to compare the functional outcome of simBTKA and staBTKA. We searched PubMed/MEDLINE, EMBASE and Cochrane Central Database to identify all articles published between 2000 and July 2020 that evaluated the outcome of patients undergoing BTKA either in simultaneous or staged manner. Ten articles were identified which met the inclusion criteria. Functional outcome was reported in terms of Knee Society score (KSS), range of motion (ROM), Oxford Knee Score (OKS) and Western Ontario and McMaster University score (WOMAC) in seven, five, four and two studies respectively. KSS gained on average 66.6 points (47.5-95.3) for simBTKA and 65.1 points (44.4-97.2) for staBTKA without significant difference between two groups. There was no difference in post-operative ROM (maximum post-operative flexion being 124.4 and 125.1 for simBTKA and staBTKA groups respectively). Mean improvement in OKS ranged from 20 to 32.6 for simBTKA and 21.6 to 33.1 for staBTKA. There was moderate evidence to suggest that both simultaneous BTKA and staged BTKA produce equivalent improvement in functional scores.