search

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

Missing crashes since 11/26 #21

Closed danrademacher closed 4 years ago

danrademacher commented 4 years ago

Christine reported we had no data since 11/26, though the script was running fine as recently as 12/1 (though given Thanksgiving, I was not surprised that there was no new data yet.

But now the script is failing.

danrademacher commented 4 years ago

In this commit, https://github.com/GreenInfo-Network/nyc-crash-mapper-etl-script/commit/7c057a3273496e47f7ce5904a8665b6464d24002, in addition to adding API keys, @fahadkirmani had to change important field names from date and time to accident_date and accident_time. Now they changed again to crash_date and crash_time -- done in https://github.com/GreenInfo-Network/nyc-crash-mapper-etl-script/commit/ef6d639936267a62bf4438b3338cab97202c2c96

Ran locally, caught up the site, and also deployed update to Heroku