Upgrade to Pro — share decks privately, control downloads, hide ads and more …

The Real Junk Food Project data plans

67b1027cca3877a76a9024425519ddde?s=47 Robin
December 12, 2015

The Real Junk Food Project data plans

Talk at the TRJFP gathering in Leeds on how to create a unified, continuously updated global database for tracking food diverted from the waste stream and into healthy, affordable meals.



December 12, 2015


  1. TRJFP Data Plans Robin Lovelace, University of Leeds. Created with

    open source software Slides: speakerdeck.com/robinlovelace
  2. 1: Context

  3. Academic paper on TRJFP

  4. None
  5. None
  6. 2: The data See the updated 'master' schema here: http://tinyurl.com/trjfp-data

    3 main tables: Cafe, Donation and Intercept
  7. tblCafe • Basic info on cafes: – Name – Location

    – Created – Closed – Contact?
  8. tblDonation • Daily totals: – Donations – Belies – Date

    – N. people? – Other stuff?
  9. tblIntercept • Biggest table – Type of food – Grams

    – Barcode? – Comments?
  10. Take a look and modify this table: http://tinyurl.com/trjfp-data

  11. 3: 'Front end'

  12. What platform?

  13. 4: 'Back end'

  14. 5: How will it work Front end Cafe manager Cafe

    manager Back end database (in CDRC) Data flow All data back to TRJFP Online infographics TRJFP analysis Some data 'open access' for research Data manager Data manager Data manager
  15. Data manager job • See https://github.com/Robinlovelace/trjfp-paper/blob/mast er/data-manager-jd.Rmd • • Essential:

    Database management skills • System administration experience, including maintaining an up-to-date list of usernames and passwords for outlets • Ability to work with people from a range of backgrounds (technical and non-technical) to ensure understanding and correct use of the database