Gleaning Collective Data Gathering and Management Tools

1. Gleaning CollectiveData Gathering and Management Tools Mike, Tray, Chris, Tim, Paul

2. Gleaningthe act of collecting leftover crops from farmers' fields after they have been commercially harvested or on fields where it is not economically profitable to harvest

3. Over 2000000 lbs of viable produce are tilled under every year for various reasons.

4. Problem Definition • Gleaning coordinators need an easy tool to notify volunteers of an upcoming gleaning event • Volunteers need an easy tool to register for, accept or decline gleaning events • Gleaning coordinator needs to be able perform data collection and reporting

5. Current Solution • Gleaning coordinator manually calls volunteers and handles scheduling • Gleaning coordinator hand writes data on paper and manually enters into spreadsheet • Gleaning coordinator manually compiles reporting information for Food Bank This leaves the gleaning coordinator no time to setup relationship with the farmers

6. Proposed Solution • Allow volunteers to electronically signup for gleaning events in their surrounding area. • Allow volunteers to be automatically notified of gleaning events in their area • Allow gleaning coordinators the ability to run standardized reports • Historical data collection

7. Technology Choice • Python (CGI) dynamic creation of web pages and interaction with database. • Django module • SQLAlchemy module • MySQL database for backend.

8. Database Structure

9. Data Flow Gleaning Coordinator Web Front End Location Farmer Information New Gleaning Event Local Volunteers Crop Type Volunteer Information Amount to Glean Farmer Details

10. Confirmed Gleaning Event Flow Gleaning Coordinator Web Front End Volunteer A Email Location Volunteer B SMS Local Volunteers Crop Type Volunteer C Phone List Phone Call Amount to Glean Farmer Details Volunteer D Call

11. Post-Gleaning Data Logging Gleaning Coordinator Gleaning Data Collection