Hong-Kong-Districts-Info / hktrafficcollisions

Shiny app dashboard of HK traffic collisions that result in injury. | 香港車禍傷亡資料庫:利用互動地圖和儀表版,將香港車禍位置和相關數據可視化。
Other
8 stars 2 forks source link

Feat: Add 2020 and 2021 collision data #113

Closed KHwong12 closed 10 months ago

KHwong12 commented 10 months ago

Summary

This branch adds 2020 and 2021 collision data into the dataset, with major changes in the column names.

Changes

The changes made in this PR are:

  1. Add cleaned and manipulated 2020 and 2021 collision data to the 4 datasets used in the app (hk_collisions, hk_vehicles, hk_casualties and hk_collisions_valid_sf)
  2. Renamed accidents related variables to collision. It is to follow the “collision not accident” campaign in naming collisions/crashes, although TD still refers to the relevant tables as ‘accidents’ data.
  3. Revise column names of raw collision data. Following the tidyverse variable naming convention, all variables are in lowercase and separated by underscore.
  4. Update default collisions shown in the map to those in 2021. Originally collisions that happened in 2016 are shown in default.
  5. Update the default district dashboard range to 2017-2021. The original range is from 2015 to 2019.
  6. Added translation of Unknown vehicle collision type. It is a new collision type in 2020 and 2021 raw data.

Check