CityCampSF Outcomes

What happened at CityCampSF Hackathon 2011 on Saturday and Sunday? Lots of great discussion about technology and open government, folks meeting for the first time over pizza, Red Bull and Peanut M&Ms, and some civic hacking on online lobbyists filings, timber harvest plans and text notifications for public meeting agenda keyword alerts. CityCampSF participants:
- Discovered some very interesting tidbits in the SF Ethics database, including a company that pays the City's biggest lobbying firm $3,800 a month, while the firm reports zero contacts with officials since Jan. 2010;
- Made a polite and official request for a complete raw data set of the entire lobbyist database, since the online version is a minor disaster (biggest recipient of lobbyist political contributions? "Not Applicable, Not Applicable"; third biggest? "NA, NA"). See my screenshots for more odd results in the SF Ethics lobbyists data display. Image here is from Ted Louie, looking at how an app might connect open data from various city agencies responsible for storing development, contracting, lobbying, political donation and legislative data;
- Built a demo app for public hearing agenda item alerts by text message. Interested in local liquor licenses or development projects in your neighborhood? With a little more municipal legislative open government (the tech is already in place), you can get a text every time those items are up for a vote;
- Discovered that forest timber harvest plans include geospatial-data rich MXD format files, then are turned into scanned and unsearchable PDFs before the state publishes them on an obscure FTP server;
- Built an interactive map of pending clear cuts and forest thinning in Northern California with Google Maps and research from the THP Tracking Center. See the great work by Granicus CTO Javier Muniz at forestsforever.heroku.com
Briefing Doc
This is the briefing document I've provided for prospective lead legislative sponsors (see questions and comments below):
Along with a number of other open government advocates, I've launched a campaign to put a definition of "open data online" into California and San Francisco law. The issue is that often when documents and data are published online, they cannot be accessed or used in a meaningful fashion because they cannot be searched, indexed by Google, or combined in a meaningful way with other documents for analysis. I want to tackle this not by mandating that certain documents and data be published online, but simply by creating a reference standard so that when new mandates pass, or new documents are published online as a matter of course under existing law or regular business, they are in accessible formats.
This has the benefits of making things easier for people who use screen readers, for developer who want to use public data to build applications, for transparency advocates, and is simply good policy. Publishing data in formats that can't be searched, compared to other documents or reused in a meaningful way is as useless as keeping it tucked away in an obscured file cabinets. Publishing in accessible formats online is as simply as education employees in how to properly save and store documents for online publication using the same software they already have on their computers. In an ironic demonstration of the current problem, San Francisco's current open data law was published by the Board of Supervisors as an unsearchable PDF.
- Javier Muniz, CTO and co-founder, Granicus (based in SoMa and one of the greatest open gov tech company success stories in the U.S.)
- Steve Ressler, founder, GovLoop
- Rep. Jason Murphey, Chairman of the House Goverment Modernization Committee, Oklahoma
- Scott Primeau, OpenColorado
- Luke Frewell, founder and publisher, GovFresh
- and many more who can be viewed online - http://www.wiredtoshare.com/structured_open_data_campaign
Structured Open Data Campaign - Sign On!
Here's the FAQ on SB 1002 (pdf)
And here's the draft bill text for SB 1002 (pdf)
Comments meant for official consideration should be directed to Alicia Lewis, alicia.lewis [at] sen.ca.gov
_________________________________________
Open data in San Francisco, the state of California, and throughout much of the U.S. and the world remains hobbled by a lack of legal definition. San Francisco's own open data law, for example, is posted online by the Board of Supervisors as a non-searchable PDF. On December 10-11, at the winter CityCampSF Hackathon, Gov 2.0 advocates will publicly launch an advocacy campaign to institute an open data standard in San Francisco municipal and California state law. The primary goal of this advocacy will be to achieve a clear and reasonable definition of open data for all materials required by law to be published online.
Please join us in endorsing this advocacy campaign, and encourage your friends and legislators to sign on as well.
Use our recruiting tools to rally your friends to this important cause.
For more backgound on open data laws, check out Civic Commons - Data Policy Policy; and Open Standards Policy.
For another definition of open data online that we will consider, see the CityCamp model Open Government directive, which describes open data as being published online in an "open format that can be retrieved, downloaded, indexed, sorted, searched, and reused by commonly used Web search applications and commonly used software."
This legislation should also encompass the goals of increased transparency in responses to SF Sunshine Ordinance requests and California Public Records Act requests - documents released in an electronic format after implementation of this ordinance would have to follow its standards of accessibility.
Machine-readability: Data should be published in structured formats easily processed by machines/software.







