際際滷

際際滷Share a Scribd company logo

Gleaning

Download as PPTX, PDF
M
Michael Davidson

The document discusses developing tools to help coordinate food gleaning events. It proposes a web application that allows volunteers to sign up for gleaning events electronically and coordinators to manage data and generate reports. The application would use Python, Django, SQLAlchemy and a MySQL database. It outlines database and data flow designs including storing farmer information, gleaning events, volunteer details and post-event logging of gleaning data.

1 of 12
Download to read offline
Gleaning Collective Data Gathering and Management Tools Mike, Tray, Chris, Tim, Paul
Gleaning the 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
Over 2000000 lbs of viable produce are tilled under every year for various reasons.
Problem Definition 1) Gleaning coordinators need an easy tool to notify volunteers of an upcoming gleaning event 2) Volunteers need an easy tool to register for, accept or decline gleaning events 3) Gleaning coordinator needs to be able perform data collection and reporting
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
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
Technology Choice Python (CGI) dynamic creation of web pages and interaction with database. Django module SQLAlchemy module MySQL database for backend.
Database Structure
Data Flow Gleaning Coordinator Web Front End Farmer Location Information Local Volunteers New Gleaning Event Volunteer Crop Type Information Amount to Glean Farmer Details
Confirmed Gleaning Event Flow Gleaning Email Volunteer A Coordinator Web Front End Location SMS Volunteer B Local Volunteers Crop Type Phone Call Volunteer C Amount to Glean Phone List Farmer Details Call Volunteer D
Post-Gleaning Data Logging Gleaning Coordinator Gleaning Data Collection
Gleaning

More Related Content

Gleaning

  • 1. Gleaning Collective Data Gathering and Management Tools Mike, Tray, Chris, Tim, Paul
  • 2. Gleaning the 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 1) Gleaning coordinators need an easy tool to notify volunteers of an upcoming gleaning event 2) Volunteers need an easy tool to register for, accept or decline gleaning events 3) 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.
  • 9. Data Flow Gleaning Coordinator Web Front End Farmer Location Information Local Volunteers New Gleaning Event Volunteer Crop Type Information Amount to Glean Farmer Details
  • 10. Confirmed Gleaning Event Flow Gleaning Email Volunteer A Coordinator Web Front End Location SMS Volunteer B Local Volunteers Crop Type Phone Call Volunteer C Amount to Glean Phone List Farmer Details Call Volunteer D
  • 11. Post-Gleaning Data Logging Gleaning Coordinator Gleaning Data Collection

Editor's Notes

  • #9: Volunteer DB list of all volunteersFramers DB list of farmersData Collection list of all data. (# of food donated, who attended, ect)Volunteer Going
  • #10: Volunteer DB list of all volunteersFramers DB list of farmersData Collection list of all data. (# of food donated, who attended, ect)Volunteer Going
  • #11: Mobile App is used in the field to gather data in real time on how much food is gathered, who attended, and any additional relative data.
  • #12: Farmer Just inform the organization that there is a surplusOrganization Functionality that organization