Natalie

Regarding 26_16: neighbourhood demographic, apparently its no longer gonna be there but we can request a csv with parameters we want from the census from someone in Community & Social...

Update on progress: - Audit tables and partition tables are now created, audit tables and partition tables functions works, the function has been tested on the `bqu` schema Next Steps:...

@qu-xiang Can you update the table name for municipalities to `gis_core.municipalities` ?

To create a list of all routes with no data:

Python package for pulling env canada data https://pypi.org/project/env-canada/#description

Historical Daily Weather script here: https://github.com/Toronto-Big-Data-Innovation-Team/activeto/blob/jasonlee/weekend_closures/scripts/import_weather.py Things to add/change: - [x] change destination table to a table in `weather` schema - [x] change table name to `historical_daily` - [x] change...

Currently the historical table has the following columns: `weather_uid, climate_id, dt, temp_max, temp_min, temp_mean, total_precip_mm` @tankedman mentioned that there are condition (e.g. Partly Cloudy), and wind speed, so we are...

ahh I see, yea I think we can exclude the weather_uid and climate_id

Added a `weather_bot` for the DAG, connection added on airflow

As per discussion with @tahaislam @tankedman, modification needed on :meow_salute: : Prediction script: - [x] change from pulling 1 day of data to pull for all 5 available days -...