Skip to content
Analysis of motor vehicle collisions in New York City
Branch: master
Clone or download
Latest commit edb559f Feb 18, 2019
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
analysis
augment_data
setup_files
shapefiles nyc motor vehicle collisions Feb 10, 2019
.gitignore nyc motor vehicle collisions Feb 10, 2019
LICENSE nyc motor vehicle collisions Feb 10, 2019
README.md Update README.md Feb 18, 2019
download_raw_data.sh
import_data.sh
initialize_database.sh nyc motor vehicle collisions Feb 10, 2019

README.md

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

You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.