Wine Industry National Explorer
Grape growing and wine production are key elements of the Australian economy.
The Wine Industry National Explorer provides growers, potential employees, students, policy makers, investors and researchers a valuable, intuitive visual tool for analysis of open datasets of relevance to grape growing. W.I.N.E collates and aggregates information from a variety of disparate open data sets, previously inconveniently saved in spreadsheet form, and further provides an API to assist further development using the information.
With sufficient development and incorporate of a number of disparate datasets, including transformation of data from legacy formats such as spreadsheet into available interfaces with well designed API, the Wine Industry National Explorer will become a valuable decision making tool.
Wine and grape growing in Australia is organised by regions. The tool allows regions to be discovered and explored, drilling down into relevant statistics.
There are many grape varieties, the tool allows varieties to be discovered and explored, drilling down into relevant statistics.
The relationship between varieties and regions can be explored.
Statistics such as number of grape growing business can be explored.
The value of exports from wine products can be explored.
By overlaying data such as the location of bores, soil and salinity profiles, and water sources, and climate data, the availability of resources and impact of threats on wine regions can be explored.
The idea was to search of wine industry in the news via the ABC dataset, however the API does not allow searching, so please consider extending the API to be searchable.
API Preliminary Design
The proof of concept includes an API design document describing a simplified model for accessing consolidated wine industry data.
We used wine regions as a simple beginning.
The W_I_N_E s intended to be supported using a backend providing this API, and code for extracting and transforming the underlying data which is currently saved in spreadsheets on data.sa
This API is documented at https://github.com/pastcompute/w_i_n_e/blob/master/api.md
Open Data Issues
We had to by hand plot out the regions using google earth, because the data has not been made available on data.sa or elsewhere! Please consider adding this as a data set.
The ABC dataset API has no search facility!
We found an error in the Playford LGA historical places geographic data and were able to inform their unleashed volunteer of this.