Big Data. Big Decisions
InformationWeek
Special Coverage Series

Commentary

Fritz Nelson

Fritz Nelson

Vice President, Editorial Director InformationWeek Business Technology Network

Full Nelson: Video: San Francisco Goes Open, Transparent

An interview with the city’s mayor and IT principals about DataSF.org and its groundbreaking applications

Open and transparent government, when it's more than a political platitude, goes far beyond getting building permits online. The next phase of the Web could be the ultimate manifestation of Abraham Lincoln's Gettysburg Address, but without a messy civil war. San Francisco's DataSF.Org takes a few giant leaps, and has already turned its citizens into active city participants.

DataSF.org is San Francisco's major foray into open and transparent government; it is the city giving its vital data back to its citizens. InformationWeek talked with the city's mayor, Gavin Newsom, several members of his technology team, led by CTO Blair Adams, and some of the early developers who have already built applications around the data -- all available in the video documentary below.

The city built DataSF.org on the wings of Data.gov, the federal government's initiative. San Francisco Mayor Newsom was surprised by how quickly citizens and developers embraced it. He can only ask, he said in retrospect, what took the city so long. With any major technology initiative, business leaders must examine the payback, the return on investment. Newsom says that it is all about the reciprocal relationship with citizens, that if he is truly governing on behalf of the people, then it's their data, If his job is to be a conduit for their ideas, what better way to let those ideas flow than by empowering them with this data. Newsom was emphatic that efforts like Data.Gov and DataSF.org are part of one of the most transformational points in the history of government.

CTO Adams and the city of San Francisco are looking to share the technology, which is built on an open source platform. While neither the mayor nor Adams talked about specific cities, they have had inquiries about the project from around the country. By opening up its work to others, the city hopes that new ideas come back to San Francisco in kind.

Jay Nath, manager of innovation for San Francisco's department of technology, said that open source provided other advantages. For one, the department members have a good deal of open source background. Also, it provides agility: the team can quickly and easily modify code. And, of course, there's the elimination of procurement processes. Nath also said that the team didn't have a significant budget to work with.

One key technology Nath leaned heavily on was virtualization -- again, important for keeping costs low and for agility. Instead of going the normal hypervisor route, Nath and the team used Parallel's Virtuozzo , which is strong in the Web hosting world, he said. With that, the city has been able to host hundreds of applications on a single server.

The innovation team rolled out the first data feeds in about two months. Applications came two months later. Adams and Nath were surprised at the speed with which the application developer community embraced the system. They also focused on how to prioritize what data to make available, relying on the public to vote on data sets. Nath said the overwhelming majority of people want quality-of-life information -- where to park, bus schedules, and so on. He said street sweeping data (which tells people when and where they can park, thus saving them costly tickets) was the most recent popular request, and they were working on getting that data online (we are told that information is now available).

There are already a host of new applications taking advantage of crime data, restaurant health scores, and more. Two examples: EcoFinder helps citizens recycle or dispose of materials that cannot go curbside. This application uses your location, lets you select from categories of material you want to get rid of, and then lists businesses and services that can help (and categorizes them by free, paid, those you have to drive to, and those who will come directly to you). Vendors Haku Wale and Nextive teamed up on EcoFinder. Haku Wale designed the user interface in about six weeks; the product took about a month to develop (the engineering happened at Nextive) and was approved in a week. It launched the first week of June.

Routesy also uses your location as context, but its job is to help you find public transportation -- namely, the next BART or Muni train. It can tell you, based on where you are, when the next one is coming, and also let you view other routes, and pinpoint where the stop is based on where you are. You can also bookmark your most frequent stops and routes. Where EcoFinder is free, Routesy costs $3.99. The product's developer, Steve Peterson, says that there are about 1,000 active users. He's working on expanding to AC Transit and Caltrain data, and is considering whether to port the application to the BlackBerry and whether to build something similar for Washington, D.C.



Related Reading


More Insights




Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

BYTE encourages readers to engage in spirited, healthy debate, including taking us to task. However, BYTE moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing/SPAM. BYTE further reserves the right to disable the profile of any commenter participating in said activities.

Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.

Follow InformationWeek

By The Numbers

What Are Your Primary Concerns About Using Big Data Software?

Base: 417 respondents at organizations using or planning to deploy data analytics, BI or statistical analysis software
Data: InformationWeek 2013 Analytics, Business Intelligence and Information Management Survey of 541 business technology professionals, October 2012

What Do You Think?

What's your attitude about SQL analysis on top of Hadoop?
We want fast, standard SQL analysis capabilities on Hadoop ASAP
Hadoop is for unstructured data; SQL is for relational databases
We'll give SQL on Hadoop a try, but relational DBs will remain the mainstay
Given strong SQL support on Hadoop, we'd nix the data warehouse
We're not interested in Hadoop
No opinion



Related Content

From Our Sponsor

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Business leaders often need a visual snapshot of data to quickly grasp and use it. This paper identifies five challenges in presenting data and how visual analytics can resolve them. Solutions are suggested to overcome the challenges of: speed, data clarity, data quality, displaying meaningful results, and dealing with outliers.

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Today's competitive advantage requires a deeper understanding of your business, your market and your customers. As an IT executive, you can drive that knowledge transformation. In this white paper, learn how to make decisions as a strategic business leader and three steps to begin an analytics initiative within your enterprise.

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

High-performance data visualization turns sophisticated analyses into meaningful graphics, leading to faster and smarter decision making. In this white paper, learn how visual analytics can transform big data, with additional features such as real-time functionality, mobile compatibility, robust applications for technical groups and accessibility for nontechnical users.

Big Data: Lessons from the Leaders

Big Data: Lessons from the Leaders

Financial performance, competitive advantage, operational efficiency, strategic decision making - every business goal can extract value from big data, and the time for doubt or inaction has long passed. In this Economist Intelligence Unit report, in-depth interviews with data pioneers reveal the link between the effective use of big data and the bottom line among other results.

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Which came first, the data or the decision? This white paper makes the case for having a decision in mind, then tailoring big data's volume, variety and velocity to achieve business results such as overcoming customer dissatisfaction or creating well-informed strategies in real time.

Informationweek Reports

Research: The Big Data Management Challenge

Research: The Big Data Management Challenge

The challenge of big data is real, but most organizations don't differentiate 'big data' from traditional data, and nearly 90% of respondents to our survey use conventional databases as the primary means of handling data. We'll help you understand what constitutes big data (it's not just size) and the numerous management challenges it poses.