CharlotteJackson/DC_Crash_Bot

Issues

• Create a DC map front end

  #90 opened 4 years ago by banjtheman
  13

• Add/Update Automated Camera Table

  #131 opened 3 years ago by Aisling-C
  2

• Write Blog Post on "Worst State" drivers

  #111 opened 3 years ago by banjtheman
  2

• Blog Post / Op-Ed On Beach Drive Closure

  #122 opened 3 years ago by eichler4dc
  0

• How / when to specify block vs intersection data

  #119 opened 3 years ago by caithammer
  1

• Refreshing data fromFamilies for Safe Streets

  #118 opened 3 years ago by caithammer
  1

• Ingest a Google sheet with traffic fatalities information

  #65 opened 4 years ago by CharlotteJackson
  9

• Establish a web connector for feeding data into Tableau

  #56 opened 4 years ago by meljameson
  13

• Write SQL code to extract the audio transcriptions and match them to Pulsepoint dispatches

  #96 opened 3 years ago by CharlotteJackson
  3

• Given an address, Describe multi‐modal facilities

  #85 opened 3 years ago by banjtheman
  4

• Add new data sources

  #110 opened 3 years ago by banjtheman
  0

• Bike Ped Safety Infrastructure by SMD, ANC, and Ward

  #116 opened 3 years ago by eichler4dc
  0

• Post-Crash Issues Lookup

  #115 opened 3 years ago by eichler4dc
  0

• Given an address, determine the average speed of Waze users on the block and how many of them are speeding

  #112 opened 3 years ago by CharlotteJackson
  1

• Given an address, determine ANC zone

  #109 opened 3 years ago by banjtheman
  2

• Given an address, describe safety concerns

  #108 opened 3 years ago by banjtheman
  2

• Given an address, Describe neighborhood uses

  #84 opened 4 years ago by banjtheman
  1

• Scrape Waze Live Map for incident Data

  #88 opened 3 years ago by banjtheman
  2

• Given an address, get the type of vehicles that pass by

  #86 opened 4 years ago by banjtheman
  0

• Given an address, find previous 311 requests in the past 12 months

  #87 opened 4 years ago by banjtheman
  1

• Determine existing traffic calming features given an address

  #83 opened 4 years ago by banjtheman
  7

• Data Driven Traffic Safety Assessment Prototype

  #75 opened 4 years ago by banjtheman
  1

• Given an address, determine nearby construction projects

  #101 opened 4 years ago by banjtheman
  1

• Given an address, determine most unsafe time

  #82 opened 4 years ago by banjtheman
  3

• Create Onboarding Document

  #79 opened 4 years ago by caithammer
  2

• Populate kanban board

  #77 opened 4 years ago by caithammer
  1

• Write the SQL code to unnest Citizen API data

  #74 opened 4 years ago by CharlotteJackson
  0

• Refactor analysis table creation scripts to run on test db unless specified otherwise

  #99 opened 4 years ago by CharlotteJackson
  0

• Design Mockup for Vision Zero UI

  #102 opened 4 years ago by banjtheman
  0

• Create a Juptyer Notebook for the Vision Zero Model

  #89 opened 4 years ago by banjtheman
  1

• Update get_all_dc_open_data.py to pull in moving violations for 2021 YTD

  #98 opened 4 years ago by CharlotteJackson
  0

• Create project page via Github Pages

  #100 opened 4 years ago by CharlotteJackson
  0

• Label Twitter dataset

  #62 opened 4 years ago by CharlotteJackson
  0

• What are best practices for testing against stateful data?

  #78 opened 4 years ago by caithammer
  1

• Expose data in database via Datasette

  #97 opened 4 years ago by CharlotteJackson
  0

• Write the SQL code to unnest Twitter data from scanner feeds

  #73 opened 4 years ago by CharlotteJackson
  1

• Write script to connect Google sheets and Postgres db

  #61 opened 4 years ago by CharlotteJackson
  25

• Investigate why roadway types aren't matching correctly to Moving Violations table

  #72 opened 4 years ago by CharlotteJackson
  1

• Unresolved Traffic Safety Questions

  #55 opened 4 years ago by banjtheman
  5

• Bing as a potential data source?

  #91 opened 4 years ago by unhott
  1

• Transcibe audio from openmhz

  #81 opened 4 years ago by banjtheman
  5

• Create updated Vision Zero Risk Analysis Model

  #76 opened 4 years ago by banjtheman
  2

• Stream tweets from certain users

  #71 opened 4 years ago by CharlotteJackson
  0

• Make data in database available via an API

  #44 opened 4 years ago by CharlotteJackson
  0

• Data Dictionary

  #57 opened 4 years ago by Aisling-C
  0

• Make a REST API to expose data in database to 3rd parties

  #63 opened 4 years ago by CharlotteJackson
  1

• Finish documentation

  #64 opened 4 years ago by CharlotteJackson
  0

• Test NLP libraries on existing scraped tweets

  #49 opened 4 years ago by CharlotteJackson
  5

• Get WalkScore for all DC addresses

  #48 opened 4 years ago by CharlotteJackson
  1

• Deploy Pulsepoint code to EC2 or Lambda

  #33 opened 4 years ago by CharlotteJackson
  0