Download Center for San Francisco-Oakland

If you would like to create your own visualizations or conduct your own analysis, you can download bulk datasets for San Francisco-Oakland using the links tabulated below. Data is provided without any warranty. For a given date, individual result calculations by block group are downloadable as a CSV file. Static spatial overlay files are downloadable in GeoJSON format. Population weighted summaries used to populate the story page are also provided for download.

Due to the size of the data, bulk block-group level scores across all destinations and measures are not available for direct download. You can access and download the block-group specific scores for a single destination and measure via the following steps:

  1. Visit the map page for San Francisco-Oakland
  2. Use the map configuration panel to choose the dataset you would like to download, and update the map.
  3. Click the download tab on the side panel and choose whether to download as CSV or as a spatial dataset.

If you would like to request a larger portion of the dataset for research or analysis, please email [email protected]

Population Weighted Regional Summaries

Summaries are population weighted scores aggregated across all block groups in MSA and Urban Cores for different access measures, dates, and socioeconomic groups. Data is in CSV format.

Note: Data issues may be influencing the low-cost fare access measures. Until we can resolve this issue, we caution against using the low-cost fare access metrics. If you have cited or used the low-cost fare data previously, we cannot verify its accuracy. Please contact [email protected] with questions.

cloud_downloadDownload Regional Summaries

Static Geospatial Files

These files contain spatial data on block groups, transit layers, and demographics. You can use these as base layers for maps and analysis. All geospatial files are in GeoJSON format.

Block Groups Transit Layer Demographics: 1 dot = 100 Asian/Pacific Islanders Demographics: 1 dot = 100 Black people Demographics: 1 dot = 100 Latinx people Demographics: 1 dot = 100 White people Demographics: 1 dot = 100 people at/below 200% poverty line (low-income) Demographics: 1 dot = 50 essential workers Demographics: 1 dot = 50 single-mother households

Static Population Profiles

These files contain population demographic values for all block groups in the region.

cloud_downloadDownload Population Profiles

Reliability Data

Where possible, reliability data has been collected for a number of agencies accross all regions. We provide the following fields:

  • timestamp: The time when the data was collected (UTC timezone)
  • agency: The agency name
  • mode: The mode of transit (Bus or Rail)
  • otp: The on-time performance, or the percent of vehicles which departed their most recent stop between 1 minute early and 5 minutes late.
  • delay_abs: The average punctuality in seconds accross all measured vehicles (average schedule deviation).
  • delay_late: The average delay in seconds of all vehicles more than 5 minutes late.
  • delay_early: The average schedule deviation in seconds of all vehicles more than 1 minute early.
  • fraction: The percent of buses sampled that had appropriate data.
cloud_downloadDownload Reliability Data

Data Definitons

Acccess and Transit Scores

Access and transit scores (and the shareable map URLs) use a unique code to identify the parameter configuration being measured:

[opportunity]_[parameter]_[period]_[autoFlag]_[fareFlag]

Where period is one of AM (weekday morning peak), PM (weekday evening), or WE (weekend). Transit service column names are in the form los_trips_[period], where period is one of WKD for a weekday measure and SAT for a Saturday measure. The table below provides a reference for the other various options in the score keys. You can refer to the how it works page for more detail on the scores.

Opportunity Measure Type Unit Code Parameter 1 Parameter 2 Parameter 3 Auto Ratio Fare Capped
Description Code Description Code Description Code Yes No Yes No
Jobs Cumulative Jobs C000_P 30 min c30 45 minutes c45 60 minutes c60 autoY autoN fareY fareN
Low-Income Jobs Cumulative Jobs CE01_P 30 min c30 45 minutes c45 60 minutes c60 autoY autoN fareY fareN
Groceries Travel Time Minutes snap_M Closest t1 3rd Closest t3 - autoY autoN - fareN
Hospitals Travel Time Minutes hospitals_M Closest t1 3rd Closest t3 - autoY autoN - fareN
Urgent Care Travel Time Minutes urgentcare_M Closest t1 3rd Closest t3 - autoY autoN - fareN
Pharmacies Travel Time Minutes pharmacies_M Closest t1 3rd Closest t3 - autoY autoN - fareN
Parks Cumulative Acres parks_P 15 minutes c15 30 minutes c30 - autoY autoN fareY fareN
Post-Secondary Institutions Travel Time Minutes schools_M Closest t1 3rd Closest t3 - autoY autoN - fareN
Transit Service Intensity Trips Per Day Trips los_trips Options are WKD for weekday service, SAT for Saturday service.

Note: An additional gravity-based accessibility score is included for access to jobs, both low-income and all. A gravity-based accessibility measure that uses a continuous decay function to weight opportunities based on how quickly they can be reached. These scores are represented with the paremeter nexp. These scores are not included in the summary data as they are not used in the story page.