Skip to content

wavelets/nyc-motor-vehicle-collisions

 
 

Repository files navigation

NYC Motor Vehicle Collisions

Code in support of this post: Mapping Motor Vehicle Collisions in New York City

Raw data comes from the NYPD: https://data.cityofnewyork.us/Public-Safety/NYPD-Motor-Vehicle-Collisions/h9gi-nx95

Instructions

  1. Download and install PostgreSQL and PostGIS (both are available via Homebrew)
  2. ./download_raw_data.sh
  3. ./initialize_database.sh
  4. ./import_data.sh

Additional code to fill in missing coordinates for collisions that have cross streets or addresses but no lat/lon lives in the augment_data/ subfolder

Assorted SQL and R scripts to analyze data and draw maps are in the analysis/ subfolder

About

Analysis of motor vehicle collisions in New York City

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • HTML 50.2%
  • R 40.5%
  • Ruby 7.2%
  • Shell 2.1%