Home | GitHub | Meetup | Blog | Our Data | Slack

WIP WIKI: Making ongoing contributions to SavBook


(Carl V. Lewis) #1

This brief overview aims to provide details and tips on how best to finish SavBook’s data entry process, how to keep SavBook up-to-date, and how to ensure it is properly-maintained


SavBook - Powered by this Google Workbook

After reading the below tasks and understanding the basics of the app, feel free to make your changes to the underlying Google Workbook that defines the data for the app. This should be the only maintenance work needed.


SavBook is a hybrid mobile web-app built during Open Savannah’s Community Engagement Launchpad event April 13, 2017. It aims to serve as a one-stop resource for community social services and resources. The data is powered by a Google Sheets workbook, and uses Tabletop.js to provide API endpoints for the data from Google Sheets to be consumed by the app.

Ongoing contributions to SavBook!

To keep SavBook maintained and get it in perfect order, we will need an individual or a group of volunteers to serve as Project Maintainers. This would consist essentially of writing documentation for the project, ensuring new data is correct and using your own unique skills to keep improving the project.

Interested in helping maintain/curate data for SavBook? Sign up using this quick form to become a project maintainer! :book:

Rolling list of fixes, improvements and additions to be made

NOTE: All data powering the SavBook app is located in this publicly viewable, publicly editable Google Sheet workbook. Anyone can contribute new data, correct incorrect data, add new categories or fill in gaps in the data. Fields may be left blank or field names retitled, EXCEPT for the Organization Name fieldname. This fieldname must stay the same.



Remove/consolidate/rearrange any and all duplicate and/or highly similarOrganization Names. This field is the only field whose field name shouldn’t be changed, but its values can stand for anything that summarizes to the viewer what the program generally is, and the field name isn’t displayed in the app (thus, don’t get too hung up on the value being an organization per se). The data should be structured with the notion in mind at all times that the value set for theOrganization Name is the only part of the data the user will see without expanding to see more.

For example, these are two rows of dozens of examples in the workbook currently that are not NOT conducive to the app:

Organization Name Program Name
City of Savannah After School Group: Eastside Regional Center Tutoring
City of Savannah After School Group: Tremont Center Tutoring

(**DON'T do it like that!**) ^

This is how structuring the data like above appears in the app. It’s hard to see the difference in each value immediately, because City of Savannah precedes each program. Instead, consider for the purposes of classification the Organization to be the physical location/center of the social service.

Organization Name Program Name
Eastside Regional Community Center After-School Tutoring Program
Tremont Center Community Center After-School Tutoring Program

Because these entries are already categorized under the After-School Programs worksheet and because it is assumed that a community center is operated by the City of Savannah anyway, the City of Savannah prefix simply causes information overload and confusion.



We need to fill in the many gaps in the data that could be easily found on, say, AuntBertha.com.

Some of the sheets in the workbook significantly lacking include:

  • Neighborhood Association Contacts, which are available in full as a spreadsheet in this forum category.

Additional sources to find data:

  • United Way of the Coastal Empire
  • Carliss Bates, of City of Savannah, who helps run savannahyouthnet.com
  • Tara Jennings of Coastal Ga. Indicators

Research on the issue SavBook addresses


(Carl V. Lewis) #2