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

Resources: Data

Meter rate adjustment spreadsheet, June 2016

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

Meter rate adjustment spreadsheet, December 2015

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

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.

dataset_icon_rate_meter_adjustment_July2011_image

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.

thumb_doc1

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…

dataset_icon_rate_meter_adjustment_July2011_image

Meter rate adjustment spreadsheet, June 2014

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

resource-data

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.

resource-data

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.

dataset_icon_rate_meter_adjustment_July2011_image

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.