Search hundreds of datasets from the City and County of San Francisco
Go to siteHave you ever been curious about the data available in San Francisco? The DataSF API provides you with access to dozens of datasets, giving you powerful insights into the heart of the city. With this data, you can build and create a variety of projects, from visualizations to exploration tools.
The DataSF API provides a wealth of data about San Francisco, from crime statistics to building permits. Here are some example projects you can create with this data:
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
san_francisco_open_data_datasf: {
type: "app",
app: "san_francisco_open_data_datasf",
}
},
async run({steps, $}) {
// Below, we fetch a range of COVID-19 case data from DataSF. You can
// run this to see how the results are displayed on Pipedream, or modify it
// in any way to fetch data from another dataset or modify the Socrata
// query. See the docs below for Socrata docs and examples.
// COVID-19 Cases Summarized by Date, Transmission and Case Disposition
// https://dev.socrata.com/foundry/data.sfgov.org/tvq9-ec9w
return await axios($, {
url: `https://data.sfgov.org/resource/tvq9-ec9w.json`,
headers: {
"X-App-Token": `${this.san_francisco_open_data_datasf.$auth.app_token}`,
},
params: {
"$where": `date between '2020-05-18T00:00:00' and '2020-05-20T00:00:00'`,
},
})
},
})
San Francisco Open Data - DataSF uses API keys for authentication. When you connect your San Francisco Open Data - DataSF account, Pipedream securely stores the keys so you can easily authenticate to San Francisco Open Data - DataSF APIs in both code and no-code steps.
Sign up for a DataSF account, visit your Developer Settings, and click the button to Create New App Token under the App Tokens section.
Once you generate your app token, add it below.