GreenInfo-Network / nyc-crash-mapper-etl-script

Extract, Transform, and Load script for fetching new data from the NYC Open Data Portal's vehicle collision data and loading into the NYC Crash Mapper table on CARTO.
3 stars 0 forks source link

Intersections crashcount: change to last 24 months #11

Closed gregallensworth closed 6 years ago

gregallensworth commented 6 years ago

Relevant to https://github.com/GreenInfo-Network/nyc-crash-mapper-chart-view/issues/81

Client's focus has changed from past 36 months to past 24 months. Update the ETL script to calculate intersections' crashcount from the last 24, not the last 36.