Blog Post

Happy Open Data Day 2018!

Hundreds of events are planned for tomorrow to acknowledge open data day!
Hundreds of events are planned for tomorrow to acknowledge open data day!

March is here already and with it we are excited to celebrate International Open Data Day!

We’ll be joining the our local host, Code for San Francisco, for a day filled with projects and an “unconference” agenda created by participants. We hope YOU will join us there tomorrow, March 3rd, 2018. You can RSVP here.

While you’ll be able to talk about all things open data, there are a couple of general themes from the international organizers. This year, they are:

  1. Open research data
  2. Tracking public money flows
  3. Open mapping
  4. Data for equal development

In anticipation of tomorrow’s event, we wanted to highlight a couple of datasets that are captured by some of these topics.

Tracking public money flows

Nobody tracks public money in SF better than the Controller’s Office and the Ethics Commission.

The Controller’s Office manages the City and County budget datasets as well as data on spending and revenue. Below are some resources published by the Controller’s Office:

  • Budget: This covers the budgets of the various departments
  • Budget - FTE: This dataset provides budget related to salaries for each department and associated department programs.
  • Spending and Revenue: This dataset tracks spending and revenue by department and related programs.

One of the key mandates of the Ethics Commission is in educating the public of campaign and lobbyist spending. While there are a lot of datasets the Ethics Commission publishes, here are some choice selections:

Open mapping

This one is a tough one to hone in on. Nearly 60% of all the datasets on the open data portal include some easy to map geometry (points, lines or polygons).

Here’s a highlight of a handful of interesting datasets in different sub-topics.

Housing and development


  • Street Trees! We have a lovely dataset with the location of street trees maintained by Public Works.
  • Parks! Rec and park has a number of datasets showing the location of parks and facilities in those parks.


There’s so much more to map. You can peruse the portal by department or type and find all sorts of mappable data. You can also browse all the maps and map data on the portal in one list.