In 2004, the U.S. Department of Homeland Security established the National Center for Food Protection and Defense (NCFPD), headquartered at the University of Minnesota. (In September 2015, the Center was renamed the Food Protection and Defense Institute (FPDI).) One of the agencies with which FPDI works is U.S. Customs and Border Patrol, (CBP) which monitors shipments of food into the U.S. MSI was contacted by FPDI to develop tools that they could use to store and analyze this data.
The first objective of this project was to create a local database to organize data from CBP. The second objective was to create an automated process to ingest additional data. The final objective was to create a web application to visualize and analyze CBP import data.
MSI created a database to store the CBP data and a tool to automatically import new data. A private web interface was developed that allows FPDI researchers to select and perform statistical analyses on selected datasets using their own algorithms. The interface generates plots and other summaries. Visualizations of imported food was accomplished using the Google Maps API. Researchers can select countries and food products to see what is entering the country. They can view entry to specific ports or the view can show a single connection to the country exporting the food with a line thickness proportional to the weight of the imported food. The graphic shows importation information for apples.