New function: intersections crashcount

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

New function: intersections crashcount #10

Closed gregallensworth closed 6 years ago

gregallensworth commented 6 years ago

We have the go-ahead on the logic for crashcount calculations to be performed on the nyc_intersections table.

Changes to ETL script:

new utility function get_date_monthsago_from_carto() to fetch a date X months ago
new updater function update_intersections_crashcount()