San Francisco Open Data - DataSF

Search hundreds of datasets from the City and County of San Francisco

Integrate the San Francisco Open Data - DataSF API with the Data Stores API

Setup the San Francisco Open Data - DataSF API trigger to run a workflow which integrates with the Data Stores API. Pipedream's integration platform allows you to integrate San Francisco Open Data - DataSF and Data Stores remarkably fast. Free for developers.

Add or update a single record with the Data Stores API

Add or update a single record in your Pipedream Data Store.

 
Try it
Add or update multiple records with the Data Stores API

Add or update multiple records to your Pipedream Data Store.

 
Try it
Append to record with the Data Stores API

Append to a record in your data store Pipedream Data Store. If the record does not exist, a new record will be created in an array format.

 
Try it
Check for existence of key with the Data Stores API

Check if a key exists in your Pipedream Data Store or create one if it doesn't exist.

 
Try it
Delete a single record with the Data Stores API

Delete a single record in your Pipedream Data Store.

 
Try it

Overview of San Francisco Open Data - DataSF

Have 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:

  • A map that visualizes live crime data
  • A tool to search for available housing
  • A comprehensive transportation app
  • An interactive dashboard for budget data
  • A tool that compares various industry trends in different areas of the city
  • A tool to explore San Francisco's population and demographics
  • A tool to compare different public services in the area

Connect San Francisco Open Data - DataSF

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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'`,
      },
    })
  },
})

Overview of Data Stores

With the Data Stores API, you can build applications that:

  • Store data for later retrieval
  • Retrieve data from a store
  • Update data in a store
  • Delete data from a store

Connect Data Stores

1
2
3
4
5
6
7
8
9
10
11
export default defineComponent({
  props: {
    myDataStore: {
      type: "data_store",
    },
  },
  async run({ steps, $ }) {
    await this.myDataStore.set("key_here","Any serializable JSON as the value")
    return await this.myDataStore.get("key_here")
  },
})