Reported: How the NYC Taxi complaints app was created

The story of honking complaints, rules that taxi drivers have to follow and the penalties if they don’t, how 311 complaints are handled, FOIL requests and lots of data.

Part 1: Introduction to the Reported App

Have you ever witnessed a taxi driver…

Did you know

What the app does

This resonates with New Yorkers

Part 2: How I got interested in taxi complaints

http://webuildthecity.com

I know a thing or two about TLC complaints…

My spreadsheet of taxi complaints.

Complaints don’t end up in a black hole

The life of a TLC complaint

54-20(a)(1)

Part 3: Making sense of TLC data

Note: We plan to publicly release all of the data used in our app.

Complaints t
Violations table
Disposition codes
100*( SUM(CASE WHEN d.disposition_code IN (‘CAD’, ‘CDI’, ‘CGA’, ‘CGH’, ‘CGI’, ‘CGP’, ‘CSA’, ‘CSW’, ‘OGH’, ‘OGI’, ‘OGP’, ‘OOT’, ‘OSA’) THEN 1 ELSE 0 END)) / ( SUM(CASE WHEN d.disposition_code IN (‘CDH’, ‘CDR’, ‘CWC’, ‘CAD’, ‘CDI’, ‘CGA’, ‘CGH’, ‘CGI’, ‘CGP’, ‘CSA’, ‘CSW’, ‘OGH’, ‘OGI’, ‘OGP’, ‘OOT’, ‘OSA’) THEN 1 ELSE 0 END) ) as “Percent guilty outomes”,
Chapter 54 — One of many rules, 54-14(e)(1)
Drivers who lease medallion vehicles. The key to linking drivers and medallion numbers!

Unused, but cool data…

Query for a hashed medallion number
OATH Daily Hearings Report

Part 4: The App and BigApps

https://www.youtube.com/watch?v=hlp1OQP3lXU

Value for New Yorkers

A bit of control in a city that pushes you around

product @ClassPass | husband & dad | Transit & #bikenyc advocate | creator @Reported_NYC

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store