bids-collaborative / the-carpool-project

A mobility marketplace enabled by cars and mobile phones.

Data Project Slides

Vivek Hutheesing: http://vivekhutheesing.com/

the-carpool-project's Issues

Set up relational database

1. Create a new account for Carpool database on AWS
2. setup postgres database on AWS RDS
3. upload a dummy data

Attend Big Ideas networking session

If anyone would like to join me tomorrow, i'll be at this event:

http://events.berkeley.edu/index.php/calendar/sn/blum.html?event_ID=93902&date=2015-10-19

database setup

Database setup

database setup

Is every Carpool Project team member on GitHub now?

To indicate, please add your name here so I know all eight of us have access. This will be a good way to do issue tracking against our milestones, and for Dav Clark to look over our shoulders.

Create granular issues

First, we should make a high level milestone for a near-term achievable, like initial ability to examine the data - summary stats or viz. We'll break that down into achievable issues that we'll assign to undergrad teams.

We can have this conversation below in the comments for this issue (and elsewhere), but please communicate with me here once you've got specific goals.

Present Shiny and its Capabilities

@jessicajji @reginacpp Will you both be able to review shiny (see link) and present its capabilities at our group meeting this Friday? This will help us to decide if it is the best tool for our purposes, and see how it compares to the templates Jessica presented to the class last Thursday. Please let me know, thanks!

http://shiny.rstudio.com/gallery/

Move link for Google drive somewhere more standard

The repository URL is meant to be a project info URL. For example, The twitter bootstrap repo links to their public facing docs site.

So, a link to google drive should go either in a text / markdown file (e.g., in the README) or in the wiki. It's confusing and presented in a "misleading" context now.

If you want less choices, move the URL to the README. The README also has way too much content.

Trifold Draft

Trifold Sample.pdf

@vhutheesing @sherlockjjj
Here is the trifold draft. Please comment here so I can revise it :)

Feedback?

Just checking in here - I'm expecting something from @dilekuz here. I'm guessing it just hasn't been posted yet? I'll also check in on Gitter.

Where is data?

If the data is not linked or explained how to get it in the repo, then it's not available!

Data Management Tool

A data management tool that enables our project to collect, measure, analyze and visualize mobility data for the purpose of evaluating our hypothesis - namely, that our common locations lead to common routes. The tool will enable anyone using Moves to export and upload their data in two easy steps to our project's hosted data management tool, a combination of RDS on AWS, R Studio and Shiny.

In addition to the survey, this is the other deliverable our team will present to the class on 12/3

We'll present the multiple factors that created the need for and influenced the design of this all important tool:

1. privacy - instead of offering to anonymize their data, we enable them to submit it anonymously - furthermore, instead of sharing all of their "quantified self" we upload a small subset of their collected data and parse it into a chronologically-sorted list of trips across all users, preventing us from doing pattern analyses on the mobility data of any single user
2. ease of use - a simple website for The Carpool Project enables users to do all the things we need them to do to participate in our project, so we envision a website with four buttons: 1) Download Moves; 2) Export Your Moves to Your Device; 3) Upload Trips to Our Server; and 4) View our Project Data
3. transparency - the fourth button above enables users to see the entire data set of anonymous, parsed data that's used by our data management tool.

Data Model

@zhuwr0423 @luyangyi Could you both discuss at our meeting Friday how we can adapt the spreadsheet on google drive (the one that has my Moves data for September) to our data model? Please let me know, thanks. Some of the issues you should cover are:

1. how can the anonymous data be parsed in order to further protect the user ID's privacy
2. how can the data be cleansed/restructured before applying proximity filter to entire data set of trips
3. how can we show the data once we've applied a proximity filter to it?

Sign Up First Five Location Leaders

User Guide

Our evolving marketing and advertising piece that will enable us to convert ordinary, mobility constrained citizens into mobility data collectors (see link). This will be our third deliverable on 12/3

Survey

Survey a sample of car owners by asking them a series of questions related to carpooling. The survey would ask them to select the circumstances under which they would be willing to use a mobile app that enables them to offer rides to others, provided they never have to change their routes or their timings. These circumstances would include questions on the following considerations and perhaps others:

1. driver safety
2. driver preference
3. driver cancel-ability
4. rider accountability
5. rider payment
6. rider review-ability

Any others?

Joseph, will you lead this exercise with help from me, others in our group, and Dilek? Dilek from the Air-Quality project has already created and run a survey (see link).

https://berkeley.qualtrics.com/jfe/form/SV_2lgCKBD82nT1Mrj

We will present our survey results and their implications on our model in class on 12/3

Best!

Start IRB application

Need to clarify what data will be collected and what will be done, what might be shared in aggregate.

Also need to check on if undergrads can be listed as investigators.

Factors driving the content of the PDF user guide

What user guide content might compel someone to become a location leader and 1) download Moves and 2) persuade their location peers to do the same. Four key content areas are:

1. convince them that their efforts will lead to a a new approach to carpooling in which they will be in the driver's seat and be able to...
   • save money
   • save time
   • save the environment
2. tell them what they have to do:
   • download the app
   • allow the app to access their location, even when they are not using it
   • create an account on the app (this will allow them to export their data to their laptop)
3. address their concerns:
   • assure their anonymity
   • assure their privacy
4. offer them some tangible benefits in exchange for their help
   • let them know how many carpools they might have participated in during the period
   • visualize their mobility for them (optional, and only if they request it)
   • give them raffle tickets to win valuable prizes

Test Gitter integration

Gitter doesn't seem to be showing any activity... why?