Skip to Main Content | Font Size | Web Accessibility | Video Transcript

Resources: Data

Meter rate adjustment spreadsheet, September 2015

This document provides a spreadsheet overview of all meter rate adjustments occurring September 2015.

Meter rate adjustment spreadsheet, May 2015

This document provides a spreadsheet overview of all meter rate adjustments occurring May 2015.


Meter data reconciliation process

This document describes the process developed by the SFpark team to reconcile parking meter configuration data moving between heterogeneous database systems.


Parking sensor data guide

This document describes how transactional parking sensor data is collected and processed for analysis in the SFMTA’s SFpark data warehouse, particularly for the purpose of conducting demand-responsive rate adjustments.  Additionally, it explains the assumptions and decisions made when interpreting and analyzing the data.  The document concludes with a guide to be used in conjunction with…


Meter rate adjustment spreadsheet, June 2014

This document provides a spreadsheet overview of all meter rate adjustments occurring June 2014.


SFpark Parking Garage Data Guide

This document describes how garage occupancy, usage, and payment data is collected and processed for analysis by SFpark. It also describes how garage rates and information about garage locations and policies are collected and stored.


Complete listing of ODS SQL code (Data Definition Language)

This file contains all the code the SFMTA used to deploy its operational data store (ODS). Because it uses industry-standard SQL language, it should be easily understandable to any city’s DBA, and should be a significantly aid in developing a similar system.


SFMTA parking sensor data storage and communication standards

These are the XML protocols that the SFMTA has developed with parking sensor vendors to receive parking sensor data. These XML standards should enable IT developers to reverse engineer the SFpark operational data store, reducing the time and money necessary to implement that technical ability of an agency to receive real-time parking data.

On-street parking census data and map (April 2014)

April 2014 shapefile, tabular data, data guide, fact sheet, and map of publicly available on-street parking in San Francisco.

Parking meters – GIS data, March 2014

This dataset includes all parking meters owned by the SFMTA and the Port of San Francisco as of March 2014. The zipped data folder contains the dataset as a shapefile and a CSV, a PDF data dictionary, and a PDF map as a dataset preview. This data provides: Locations of meters Meter characteristics, such as:…