EweTube.space

About EweTube.space

Our project is two-fold:

  • a platform for delivering localised data in appetising formats tailored to each individual consumer; and
  • a proof-of-concept of this toolchain applied to agricultural commodities statistics, particularly the sheep industry.

Why did we choose to build it?

Our project began with the lofty goal of dynamically rendering a video animation with computerised voiceover that summarises tailored statistics to the queries of each individual enduser and their location. Ideally the data is presented with appeal and flair. Data presented in a manner as exciting as Google's YouTube videos, but tailored to the statistics of our government/industry partners. As an example use-case of this workflow, we chose data relevant to the Australian Sheep industry, and so the idea of EweTube.space was born.

Given the time-constraints we reduced the scope of the GovHack weekend prototype to rendering data in browser, and ultimately to a dynamically generated Google Slides presentation via the official API. 

What does it do?

The application we have developed displays specific data sets to the end user in easy to read, mobile responsive, visually appealing graphs/charts. 

The user chooses their location (currently state), their preferred industry (eg. Sheep) and a date range (eg. 2010 - 2011) from a list of available choices in our data. 

On our local machines - we are then able to generate a simple, sharable Google Slide document with the data, including maps, images and text. We have included a sample of a generated slide on the staging server. (See link below)

The user is also able to view live weather forecasts for areas in their state, live from the BOM API. 

Who is it for?

EweTube.Space is designed for farmers and other people who want simple access to easy-to-read data related to the sheep industry here in Australia. It is served up in a clear, easily readable format that doesn't require extensive technical knowledge to access or understand.

What data was used, how was it used?

We collated publicly available data from multiple sources, such as the Australian Bureau of Statistics, Meat & Livestock Australia Statistics Database, and the United Nations Food and Agriculture Organization. This data was then converted into XLS data, to CSV, then into SQL, before being linked into our website.

What Technologies Did We Use?

  • Bootstrap HTML/CSS Framework
  • PHP
  • MySQL
  • Node.js
  • jQuery
  • Github
  • Markdown
  • Google Slides API (https://github.com/googlesamples/md2googleslides)
  • BOM API
  • Hosted on AWS EC2

Links

  • Here is a proof-of-concept artists-impression of what a tailored Google Slide presentation might look like: 

https://ewetube.space/sample

Team name
EweTube.space
State, Territory or Country
Event location
Datasets used
Dataset Name
ABS Agriculture Commodities 2010/11— Land Use — Sheep Population — SA2
Dataset Name
BOM Live Data Feeds
Dataset Name
7218.0.55.001 - Livestock and Meat, Australia
Dataset Name
4618.0 - Water Use on Australian Farms
Project image
Video URL (YouTube/Vimeo)