Commits · 470c38b367ddeaa7b0cf084104b9dbef8f9d13e0 · Data Science / emergency-calls

Nov 05, 2016
- added a view to replace most of the latitude longitude query in datavis.py · 470c38b3
  Craig Earley authored 8 years ago
  
  470c38b3
Nov 03, 2016
- added views for call,city and complaint,type,cat,group · a13a0f80
  Craig Earley authored 8 years ago
  
  a13a0f80
Nov 01, 2016
- added view to show call_id, agency_name rather than agency_id · aa18d48b
  Craig Earley authored 8 years ago
  
  aa18d48b
- fixed response table foreign keys and data types · f985acbd
  Craig Earley authored 8 years ago
  
  f985acbd
Oct 29, 2016
- tables populate automatically without errors, script to generate a clean... · ffdfcf89
  Craig Earley authored 8 years ago
```
tables populate automatically without errors, script to generate a clean geocodes file, aesthetic improvements
```
  ffdfcf89
Oct 14, 2016
- type_name populated in calls · aaeaaf41
  Craig Earley authored 8 years ago
  
  aaeaaf41
- made use of OR to trim down the populate code; lowercased ems · 73b3d4b0
  Craig Earley authored 8 years ago
  
  73b3d4b0
Oct 09, 2016
- drop tables now cascades so views also drop · b1b66272
  Craig Earley authored 8 years ago
  
  b1b66272
Aug 02, 2016
- tables and populate are more modular, still need work · b0620e1a
  Craig Earley authored 8 years ago
  
  b0620e1a
Aug 01, 2016
- scripts to create, populate, and drop tables all work · 63ef90dc
  Craig Earley authored 8 years ago
  
  63ef90dc
Jul 28, 2016
- split sql script for modularity, added types and categories, still needs QA · c6026618
  Craig Earley authored 8 years ago
  
  c6026618
Jul 27, 2016
- sql script that creates tables and populates some of them from the raw csv files of the 911 data · 27a4cdb8
  Craig Earley authored 8 years ago
  
  27a4cdb8
Jun 24, 2016
- Commented the psql queries · a8abd1e9
  Ahsan Ali Khoja authored 8 years ago
  
  a8abd1e9
Jun 23, 2016
- added the most basic code · 183c5ce9
  Craig Earley authored 8 years ago
  
  183c5ce9
- now uploading two files · 7003fc1c
  Craig Earley authored 8 years ago
  
  7003fc1c
- Craig told me not to tell him · d379b438
  Ahsan Ali Khoja authored 8 years ago
  
  d379b438
- Added creators of project · a78d9962
  Shana Weissman authored 8 years ago
  
  a78d9962
- teaching Ahsan and Shana about git · ec0d851f
  Craig Earley authored 8 years ago
  
  ec0d851f
- README skeleton created · 1396bfb0
  Craig Earley authored 8 years ago
  
  1396bfb0