Oakland’s awesome public records request system

Oakland’s employee compensation database is the kind of public record that should be proactively available, even with historical versions, without requiring a formal public records request. But since I couldn’t find it online, I filed a request, and got to interact for the first time with Oakland’s very cool RecordTrac system for handling those requests. RecordTrac is a Code For America fellowship project that launched a year and a half ago, and it ensures the entire process is online and publicly available, so users can see every request that gets filed and what response it received.

The value of that system becomes obvious pretty quickly after you start using it. For example, when I started looking through the compensation database, one fact that jumped out immediately is that some Oakland police officers make significantly more than their base salary in payment for overtime work. In fact, the highest paid Oakland government employee in 2014 is a police officer who got some $165,000 in overtime pay. What could possibly be going on with overtime at OPD?

Searching through the public requests database turns up another person’s request, specifically covering OPD and overtime. Those documents were released in the last few days and are immediately available to me and any other interested member of the public. That’s incredibly helpful to both me and the city. I get the records I’m looking for much faster, and can send follow-up requests without waiting for another round trip, and Oakland doesn’t have to process as many duplicates.

It also comes in handy where there are no responsive documents. Traditionally those requests don’t see a lot of publicity because, well, there are no documents to report on. But sometimes their absence is an interesting data point itself. Take, for example, this request for agreements between the Oakland Public Library and law enforcement on disclosing patron information. It would be a much larger story if there were agreements like that, but it’s nice, too, to be able to refer to the request turning up no responsive documents. ((After I tweeted about this request, the Oakland Public Library reached out to emphasize its opposition to that sort of agreement.))

If all this seems familiar, it may be because services like Muckrock, where I’m a frequent user, have implemented the same kind of thing on the requester end. Every request gets a permanent URL, where all associated documents are connected and made publicly available. Like RecordTrac, it keeps the status of requests updated, and notifies requesters when new information has come in.

Muckrock definitely makes the public records experience better, and has built an impressive collection of returned documents. But there’s an emergent property of the agencies themselves putting all that information online in the first place.

Oakland was lucky to pilot this program, and the avalanche of requests related to Occupy likely taught the city a lesson about handling them efficiently.

RecordTrac is already free software, and as of about six months ago, the developers rolled the software into a hosted product called NextRequest(UPDATE: the main RecordTrac developer reached out to clarify that NextRequest is not affiliated with the original team. Apologies for the error, and I too hope governments embrace the more open solution.) Hopefully that means more pickup by agencies and governments, bringing a much-needed update to the public records requesting process’s usability and transparency. It can be funny to see Muckrock joke about how dated much of our country’s FOIA infrastructure is. But it’d be better to see it fixed.


  1. Richa Agarwal
    Posted 25 May, 2015 at 20:28 | Permalink

    Hey Parker!

    I was the main developer of RecordTrac and I’m super happy to hear you had a great experience with it. I also wanted to clarify that NextRequest is not affiliated with myself/ the original team that created RecordTrac. I think Code for America is in the process of updating its docs (https://www.codeforamerica.org/apps/recordtrac/) but we’re hoping that cities/agencies that decide to adopt RecordTrac decide to go with the open source version, and contribute back if they make any updates (I believe this is what NYC plans to do). NextRequest is not truly a hosted version of RecordTrac since their codebase is separate and closed.


  2. Reed Duecy-Gibbs
    Posted 23 June, 2015 at 14:52 | Permalink

    Hi Parker and Richa,

    I would like to add some clarification to Richa’s comment.

    To give a little context to the situation: Following the 2013 Fellowship, 6 Code for America Fellows (Andy Hull, Tamara Manik-Perlman, Cris Cristina, Richa Agarwal, Reed Duecy-Gibbs and CJ Bryan) created a development company called Postcode.io and participated in Code for America’s incubator for the first 6 months of 2014. While Cris and Richa initially created RecordTrac, everyone in the company continued to maintain and develop RecordTrac along with a number of other applications (CityVoice, Promptly) while at PostCode. At the end of the incubator 3 co-founders (Richa, CJ, and Cris) left the company voluntarily to pursue other endeavors.

    PostCode.io had applied to many grants to continue work on RecordTrac, but were unsuccessful. We felt very torn, but ultimately decided that in order to make a sustainable business and get widespread adoption to cities of all sizes, that a closed source multi-tenant version built in Ruby on Rails was the most viable path forward for the remaining team. This became NextRequest (http://nextrequest.com)

    We believe that for some cities having an open source application that they can maintain and customize on their own, such as RecordTrac, may make the most sense. But for many cities (often the medium to small ones with less staff and $ resources) the easiest and cheapest way to effectively and transparently manage public records requests is to have a cloud hosted service with people who can provide them support.

    At the same time I believe that open and easily portable data standards are crucial to changing civic/gov tech for the better. This prevents vendor/platform lockin regardless of whether the application code is open or not and in my opinion. I’ve talked briefly with Michael from MuckRock about this, but if anyone else wants to help with this effort as it relates to public records requests send a message to @nextrequest on twitter.


Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>