search

hackoregon / emergency-response

Simulations, Models, and Visualizations of Portland Fire and Rescue data
11 stars 10 forks source link

Compute various time roll-ups #28

Closed futurechris closed 7 years ago

futurechris commented 7 years ago

Incidents by hour/day of week/time/moon phase/holiday

kielejocain commented 7 years ago

Blocked by #1

hannahkane commented 7 years ago

@qingdatascience is going to start working on this :)

qingdatascience commented 7 years ago

I found the sql scripts for moon phase https://mudlthru.wordpress.com/tag/sql-datetime/ and holidays http://www.joebooth-consulting.com/sqlServer/sqlServer.html#CalendFunc Not sure how to insert into my query.

qingdatascience commented 7 years ago

Finished exploratory analysis, uploaded Notebook.