Berkeley’s open data portal leverages city’s legacy data

Berkeley’s open data portal leverages city’s legacy data

Berkeley, Calif., has officially launched its open data website,  an effort to make city information more accessible for citizens and to reduce the staff time devoted to extracting and formatting data.

Started last December as part of a pilot program, the site was officially launched in early August and includes datasets that range from 311 requests, crime incidents, business license information and the city's tree inventory to restaurant inspections, certified green businesses and utility consumption within city limits.

The information can be filtered, manipulated and downloaded in a range of formats to facilitate mapping, data visualizations and additional analysis. The site also includes tutorials on how to access and use the data.

The city’s IT department and staff members from all city departments worked with Socrata, which helped launched the White House’s open data site and has created almost 90 percent of open data portals in the United States public sector, Donna LaSala, the city’s outgoing director of information technology told Berkeley Side

According to LaSala, the hardest part of the effort was getting the city’s legacy data into a format that could be fed into the new platform.   “Getting those data extractions to update automatically: It’s a big effort,” she told the paper.

“I’m just really proud that we’ve gotten to the point where some of our legacy data can be presented in a way that’s useful,” LaSala said.

About the Author

Derek Major is a former reporter for GCN.


  • business meeting (Monkey Business Images/

    Civic tech volunteers help states with legacy systems

    As COVID-19 exposed vulnerabilities in state and local government IT systems, the newly formed U.S. Digital Response stepped in to help. Its successes offer insight into existing barriers and the future of the civic tech movement.

  • data analytics (

    More visible data helps drive DOD decision-making

    CDOs in the Defense Department are opening up their data to take advantage of artificial intelligence and machine learning tools that help surface insights and improve decision-making.

Stay Connected