Working with Datasets

Finding the data dictionary for a dataset

On many datasets you can find a data dictionary--a description of fields in a dataset--as an attachment. You can find the data dictionary in two separate places. Option A: On the dataset landing page In t...

Read Article

Using zipped shapefiles

There are a good number of datasets on the open data portal that are made available as zipped shapefiles. The shapefile format was developed by Esri to support interoperability among various Geographic Informat...

Read Article

Getting Started

.video-guide { width: 100%; height: 165px; position: relative; background-repeat: no-repeat; background-position: center 30%; color: #fff; background-color: #d2d2d2; } .video-guide ....

Read Article

Suggesting a dataset for publishing

If you'd like to suggest a dataset for the open data portal, you can do so through our contact form. Just select Suggest a Dataset in the Request Type dropdown.

Read Article

Using OData to connect to desktop software

OData is a tool that let's you connect datasets on data.sfgov.org into tools you use in your day to day work like Excel or Tableau. Follow the steps below to use it. Step 1. Find the dataset you want on data....

Read Article

Using open data in popular analysis tools

This article provides a brief overview of ways to import data into some of the more popular analysis tools. Find and Select your Data. This step is common regardless of the program you choose. The first s...

Read Article

Looking up a record in a dataset

There are two main ways to look for a specific value in the open data portal. One method will search the entire dataset. The other will filter a specific column. 1. Search entire dataset Locate the dataset...

Read Article