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.

Transcript

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
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