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

Resources: Data

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.

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

Meter operating schedule data, March 2014

Operating schedules and time limits for all meters owned by SFMTA and the Port of SF as of March 10, 2014. Tow periods and Alternate schedules trump all base Operating Schedules. The zipped data folder contains a PDF data dictionary and a CSV of the data. By downloading the file below, you are agreeing to…

Meter rate schedule data, March 2014

Meter rate schedules for all meters owned by SFMTA and the Port of SF as of March 2014. Base rates describe the standard rate for parking at the meter. Overrides to the Base Rate apply on the given days at the given times. Rates are subject to operating schedules, available here: https://data.sfgov.org/Transportation/Meter-Operating-Schedules/6cqg-dxku When the time…