Author：Taiwan Agricultural Research Institute, Council of Agriculture, Executive Yuan
In order to enhance the safety of ingredients used in school lunch, the government advocates for the use of domestic traceable agricultural products with open information of traceability for real time access through webpages. To achieve this goal, the Agricultural Research Institute of the Council of Agriculture has collected, on the SMART AGRI platform, 10 categories of traceability data (Three Labels and One QR Code; 3L1Q) to provide instant access for school lunch registration. With the visualized big data analysis tool, the data from the food producers and the schools are quickly integrated and easily obtained. The human workload is considerably reduced so the work that would take a week in the past can now be done in just one minute. This is like a real-time situation room for tracing food safety in which health inspectors control and statistically analyze the food ingredients.
As the “Three Labels and One QR Code” (3L1Q) data are managed by different offices in different storage formats, users need to make a lot of effort to access and interpret them. The Open API big data environment on the SMART AGRI platform is an integrated service center that has the 3L1Q information all collected and provided to the Campus Food Ingredient Registration Platform of the Ministry of Education. The latest 3L1Q information is presented in conjunction with the big data visualized analysis tool and 3L1Q heterogeneous data including those of school food ingredients, drug testing, and school registration, to serve as a situation room of traceable agricultural food safety. The service provided on audit control, risk control, or crisis management is valuable and reliable to schools, catering service operators, and the students’ parents.
The Open API big data environment of the common information platform is open to over 3,000 elementary and secondary schools across the country for food ingredients registration, with an average of more than 20,000 uses per month. The inspectors can quickly obtain the analysis results by selecting relevant parameters on a visualized operation interface. Unlike the former version in which the data are presented in Excel format and limited to a certain month only, the new version now has data presented multi-laterally in the format of Sankey Chart, so that data can be retrieved for different dates or months, of different labels, of different areas and schools. School teachers can easily follow the source of food ingredients of the school lunch operators through the platform, and this makes the ideal of “local production and local consumption” and “food education” more easily realized. The system is also open to parents who are concerned about the food safety of their children.
