San Francisco Open Data - DataSF API Integrations

Build and run workflows using the San Francisco Open Data - DataSF API. Use 1000s of source-available triggers and actions across 2,000+ apps. Or write custom code to integrate any app or API in seconds.

Overview#

The San Francisco Open Data - DataSF API unlocks a wealth of government data spanning multiple domains such as transportation, housing, and public health. It provides developers with access to rich datasets, which can be integrated into applications to derive insights, inform decision-making, and power data-driven solutions. Pipedream's serverless platform amplifies this potential by enabling users to create automated workflows that leverage this data in concert with other apps and services.

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'`,
      },
    })
  },
})

Example Use Cases#

Automated Alert System for Street Cleaning Schedules: Extract street cleaning schedules from DataSF and use Twilio SMS integration on Pipedream to notify residents the day before their street is scheduled for cleaning, minimizing parking fines and improving urban cleanliness.
Real-Time Public Health Dashboard: Use DataSF's public health datasets to trigger a workflow on Pipedream that aggregates the latest health metrics, processes them, and then sends the data to a Google Sheets dashboard, providing real-time insights for public health officials and the public.
Housing Market Analysis Bot: Combine housing data available through DataSF with Pipedream's Slack integration to create a bot that delivers weekly updates on housing market trends to realtors, investors, or interested buyers in a dedicated Slack channel.

Authentication#

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.