syncthecity / shinymap

A web application to syncronize nonprofit efforts in Baltimore City.

shinymap

Who are we?

Code for Baltimore and members of the Baltimore tech/data community

What is Sync the City?

A tool to connect organizations in Baltimore to improve impact

Why are we making it?

Organizations don't know who is working on what and with whom

Who is it meant for?

• Nonprofit leaders who need to collaborate to more effectively serve their communities
• Funding institutions who want to identify where they should invest their funds

How are we making it?

Shiny web application developed in R

What does the application consist of?

• A map with the location of all nonprofit organizations in Baltimore City
• A table that reacts to filtering and tabulates organizations on the map
• A network graph of organizations and who they work with

Where are we getting this data from?

• We are currently using publically available data published by the IRS
• Some of our data model has been appended ourselves

What are some major milestones to come?

• Deploying on a cloud service (GCP, AWS) and switching to a new domain name
• Building a database to allow for user input
• Re-assessing map design to account for where organizations work, not where they are
• Getting user feedback from using the tool as well as survey feedback

Basic instructions to run local with docker

Requires:

• docker

Steps if using prebuilt:

1. docker pull madhuravius/shinymap-baltimore
2. docker run -p 3838:3838 madhuravius/shinymap-baltimore

Warning: Build takes > 30 minutes on an i5 8-threaded machine.

Steps if building:

1. docker build -t shinymap-baltimore .
2. docker run -p 3838:3838 shinymap-baltimore

Go to browser (http://localhost:3838) to access.

Basic instructions on deploying image to heroku

1. Install heroku toolbelt
2. heroku create (store this somewhere, ex, personal one is: mysterious-earth-28048)
3. heroku container:login
4. Get the image id tag of the docker image (from pulling the docker image with docker image ls -- ex: 2890e2cb9de3)
5. Tag the docker image: example based on image and tags: docker tag 2890e2cb9de3 registry.heroku.com/mysterious-earth-28048/web
6. Push the docker image to heroku example based on image: docker push registry.heroku.com/mysterious-earth-28048/web
7. Release the image for use: heroku container:release web --app mysterious-earth-28048
8. heroku open to view it

My current docker build can be found here: https://mysterious-earth-28048.herokuapp.com

To view logs, follow it with heroku logs.

shinymap's Issues

Re-configure deployment

Switch from shinyapps.io to GCP, AWS, Azure, or Heroku

Refactor Docker build

• Remove unnecessary dependencies

https://hub.docker.com/r/madhuravius/shinymap-baltimore

Test DT formatting alternatives

• currently using responsive extension
• test alternatives such as scrollX or others
• would like to use scroller extension to replace paged table

SSL on heroku custom domain

Network tab second pass

• Fix crashing error
• Extend visible nodes to those connected to groups currently filtered

Firebase authentication

https://www.tychobra.com/posts/2019-01-03-firebasse-auth-wtih-shiny/

Zip Code Popup

Add popup on hover for zip code polygons

Save Favorites button

Search bar to find organizations or topics

Create network connections

• Create dummy connections between organizations
• Create network visualization
• Create new tab for network viz
• Possibly re-develop UI in tabbed shiny webpage instead of shinydashboard

Re-build UI using argonDash

https://github.com/RinteRface/argonDash

Testimonials

Create a banner that has people's testimonials glide across the page at slow two second time intervals.

Ex: " Sync the City helped me match with ____, now we're working together on ___." - John Doe

Set up CI

• Travis CI?
• Automated Docker builds?

Fix table formatting

Fix number formatting in table while retaining ability to sort

Create landing page

Integrate landing page through ShinyLP

Add additional IRS Codes

Update data model with lookup table for IRS codes, append to DT

CD

Integrate continuous deployment pipeline to automatically re-deploy Heroku app with newest Docker image.

Possibly useful resources:
https://hackernoon.com/ci-cd-pipeline-using-github-docker-circleci-heroku-ef7f8a90a6f9

https://devcenter.heroku.com/articles/container-registry-and-runtime

Update copy on home page

Currently, the home page has placeholder text for the who/what/when/why sections. Update those sections with final copy from Karina. (Possibly related to #2)