OPA Data Liberator: hackathon project for city property records [VIDEO] - Technical.ly Philly

Dev

May 5, 2011 10:00 am

OPA Data Liberator: hackathon project for city property records [VIDEO]

The Open Gov Hackathon presented by Tropo brought together coders and journalists.

The original hackathon team working on the OPA Data Liberator, which became PhillyAddress.com, during the April 2011 BarCamp NewsInnovation News Hackathon.

(Photo by Christopher Wink)

Coders and journalists need to hang out more. It’s becoming something of a mission here at Technically Philly.

On Saturday, at the Open Gov Hackathon presented by Tropo, as a part of the third annual BarCamp NewsInnovation, former Inquirer City Hall reporter and current freelancer Patrick Kerkstra walked into the TV Studio at Temple University’s Annenberg Hall.

In the chilly, cement-floored room, Kerkstra presented a simple problem to a handful of developers there early for the hackathon. On the website of the city’s Office of Property Assessment (the reconstituted Board of Revision of Taxes), the search function is limited to specific address and doesn’t extend to names.

So, say, a small-time property developer wanted neighborhood approval for a zoning variance at a newly purchased property. Until Kerkstra inspired a pack of hackers, there was no easy, online way for concerned neighbors to find out other properties that property developer owned.

Now there is. Visit the OPA Data Liberator.

The OPA Data Liberator showing 35 properties owned by Drew Demarco near Germantown and LaSalle University. This is an example of the application using someone with one of the larger totals of owned properties in the still incomplete database from the Office of Property Assessment. While some have criticized Demarco on Philadelphia Speaks, this should not be seen as anything more than an example of the application’s utility. Click to visit the application.

This very project was called for by Independents Hall co-founder Geoff DiMasi during a February panel discussion on the open data movement, though he expressed dismay at the hurdles to get it done. Like, namely city support. So we should be clear that the OPA, nor any other city agency, endorses this project. It was done by a handful of hobbyist hackers, and to be sure, the project isn’t done.

Advertisement

The search functionality is still a little rough, and the design might leave something to be desired, but there it is. What’s more, of the city’s 560,000 properties, the web application is still, at the moment, downloading and adding ones, hovering around 300,000 as of Wednesday afternoon.

But here’s an example of how a technology community can take data by sheer will.

OPA property details are not openly shared in a downloadable, usable format, says Tim Wisniewski, hobbyist open government enthusiast and Executive Director of the Frankford Special Services District. However, their project has opened up a dialogue with the OPA, which could change course and release its data more freely.

“We certainly are in favor of anything that increases the level of transparency both in terms of our mission and the data available through this department,” Michael Piper, an OPA deputy administrator, wrote Technically Philly in an email. “I am forwarding [these] suggestions to our IT manager in hopes of revisiting this topic.”

If OPA follows through, a regularly updated API of property records would be an ideal addition to OpenDataPhilly.org, unveiled last week, says Wisniewski, who handled the Data Liberator’s back-end PHP. He is currently hosting the tool, but expressed interest in finding its own domain if it grew popular.

To start, the group was given a list of properties, from an anonymous supporter of the project, which they imported into a MySQL database. Then, the group created a Ruby script that scrapes the data from the OPA Property Search site, and puts it into the MySQL database.

Wisniewski was joined by Adam Hinz, Joanne Cheng, Mjumbe Poe and others on the project. Tropo open government developer Mark Headd helped lead the hackathon.

Though natural privacy concerns arise, Wisniewski said an OPA representative seemed to suggest this type of searchability does not breech any legal limitations.

Versioning is available on GitHub here.

Below, watch Headd and Poe discuss the project and compare the struggle for data with when data is available, resulting in a project like the Philadelphia Mural Guide that Poe also assisted on.

-30-
JOIN THE COMMUNITY, BECOME A MEMBER
Already a member? Sign in here

Advertisement

Techstars Startup Weekend Latinx in Tech: a 54-hour dash to launch in University City

This year’s PennApps focuses on emergency preparedness

A healthcare hackathon in South Jersey produced 3 ideas worth exploring

SPONSORED

Philly

Clients and community come first for Vanguard employees

990 Spring Garden Street, Philadelphia, PA - 19123

Azavea

Temporary Cicero Research Specialist

Apply Now
Philadelphia

Perpay

Risk and Strategy Analyst

Apply Now
Philadelphia

Full Stack Engineer

Apply Now

Meet the 5 projects from Code for Philly’s Civic Engagement Launchpad

At NextFab, an accessibility hackathon yields bold ideas

Don’t know code? Don’t be fazed. Code for Philly needs you

SPONSORED

Philly

UX, UArts and the importance of human-centered design

Conshohocken, Pa

ShopRunner

Manager, Partner Success

Apply Now
Philadelphia

Perpay

E-commerce Software Engineer: Magento, PHP, Python

Apply Now
Malvern, PA

Vanguard

Sr. Full Stack Developer-Client Experience Lab

Apply Now

Sign-up for daily news updates from Technical.ly

Do NOT follow this link or you will be banned from the site!