Reporting application for exploring demographic, environmental and financial metrics about coffee growers around the world. Project primary is the Watson Creative agency, providing design and specifications.
Application was implemented in object orientated PHP as a Wordpress plugin. The source data is synchronized weekly from the Track Via API, a service used by the field agents to manage the information collected about coffee farmers. The Wordpress command line tool is used to perform the data synchronization via a standard CRON job.
The application implements fine grained access controls to the data set by geographic area down to the resolution of counties. The plug-in provides a dynamic control to site administrators to manage the access granted to users of the site.
The aggregates of the data sets selected by the end user is displayed in multiple useful visualizations including graphs and cluster markers on a Google Map.