Project Proposal

[IYCI]

Purpose and problems

Existing Dashboards:

1. JHU: ARCGIS, Map with scatterplot to province level, single line chart for all countries, list of numbers by country.
2. 一亩三分地: copy of 丁香园, basic SVG map with choropleth for only US and Canada(separate), has city level stats for US in table below.
3. https://covid19.locale.ai/: perfect map view, vue, mapbox, scatterplot and choropleth, 3 layers: confirm/death/recovered, has hover but not click, only map view.
4. https://covid19.health/: svg choropleth map and charts, has transmissions path, has province level data for korea, italy, france and US. City level data for China, has time line and playback feature.
5. https://covid19.tk/#tab=cities-map svg chropleth map with timeline playback feature

Interesting Ones

6. https://stayinghome.club/companies.html
7. datawrapper: some interesting charts that we can borrow from
8. some other charts & map

Better solution:

• Use Mapbox GL(based on WebGL), more complex interactions and easier layer manipulation.
• Use choropleth to show the intensity of our numbers(current cases, death cases, cured cases and accumulative cases), but also provide scatterplot as a second choice. Just like Existing Dasboard show USA data in state level #3^. Reason is that with scatterplot map, area with a large number can have a huge circle that blocks other areas nearby, such as Hubei and Europe. Also area name can come on top of choropleth.
• Provide more interactive map experience than JHU one, like hover to show number stats and click to show side panel with detailed time-series chart for that province/country
• More interactive map experience than JHU: show country level stats at a certain zoom level range and show province level stats at another zoom level range. same for city level as well. Disable zooming in beyond a certain zoom level.
• Remove unnecessary map layers like roads and only keep province borders.
• Be able to view affected density as compare to absolute case numbers: current_case / area _population. Currently no one does that.
• May have feature like timeline playback(https://kepler.gl/demo/nyctrips) to show how virus spread and develop.
• Can stack other type of layers like Company remote rate(dashboard [G2M] Generalize layer building #6^) or even economy stats.

Possible data source

• https://github.com/CSSEGISandData/COVID-19 https://covid19.mathdro.id/api data for JHU dashboard, has province level current data for all countries.
• https://raw.githubusercontent.com/haxzie/covid19-layers-api/master/data/layers/geo.json?ts=1584210033599 geojson for each country with 3 metrics updates everyday. temporary solution
• https://www.worldometers.info/coronavirus/ https://www.who.int/emergencies/diseases/novel-coronavirus-2019/situation-reports new cases

we will need more data source for:

• global time series data (JHU has this so should be easy to find)
• country level time series data
• province level time series data for certain countries

Project Division:

• dashboard web app
  • map, legend and control panel
  • side stats panel: all kinds of charts
  • host, deploy and other devOps things
• API server (not final yet)
  • serve geological data
  • serve cached stats from other source
  • serve aggregated stats from other source or own DB
  • host and deploy
• Data Mining
  • search and find usable API
  • store into our desirable format if needed

Initial Plan

• Research, try and record possible solution to each roadblock on each side.
• Start building a basic dashboard with only map
• Show charts in side panel when area gets clicked
• Show finer granularity for certain countries when data source is found
• Be able to switch and add other layers onto the map
• Show a timeline and be able to playback the stats

MVP

• Start building a basic dashboard with only map
• Show provinces for certain countries when data source is found
• Show stats summary and time-series charts in side panel when country gets clicked

Available domain

covid-19-report.com