Looking for Collaborators

I’m thinking about starting a project to develop an application that uses crime incident data from the City of San Francisco and allows people to identify crimes that occur close to their homes and/or places of business. I worked on a similar project for the original Apps for Democracy contest last year.

Crime incident data from the SF Police Department is available in KML format here. I’d like to take the data in these files – which appears to be updated daily – and populate a relational database with information on specific crime incidents, including locational information.

I’d also like to develop an application that citizens can access to identify the crime incidents that occur closest to their specific locations (home, work, or wherever they happen to be at the moment). The application would be accessible through a range of modalities – standard cell phone, micro-browser, Twitter, IM client, etc. – and would query the relational database storing crime incidents.

If anyone is interested in working on such a project, give me a shout. I’ll post updates on any progress made on such a project going forward.

Looking forward to hearing from other civic coders!


  1. Jay · August 31, 2009

    Just sent an email to Stamen to see if they’re interested in working with you. Also let me know if you have any questions on the data.

  2. Mark Headd · September 1, 2009

    Thanks, Jay!

    I’ve got some work to finish up on another open gov project and then this will be my primary focus.

    Very excited about working on this – I have some neat ideas that I’m interested in sharing with other developers looking to use SF data.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s