Understanding San Francisco's street-level data

An overview of street-related data on the Open Data Portal. This resource page includes information on streets, intersections, parcels, addresses, and other street characteristics

The basics

Some of the first datasets on the Open Data Portal focused on San Francisco’s streets and addresses. Many departments help produce this data such as Planning, Building Inspection, the Assessor's Office, and the Department of Technology. This resource collection is not exhaustive but highlights key datasets and concepts related to San Francisco streets. But first, two key concepts:

Centerline network number ("CNN")

The CNN is a unique identifier for every street segment and intersection under the jurisdiction of the City and County of San Francisco. Street segments are represented as lines and intersections are represented as points in our datasets.

Parcels ("APN")

A parcel is a piece of land or a lot (real property) identified by a unique Assessor Parcel Number (APN). In datasets, the APN is frequently referred to as "Block and Lot", "Parcel Number", "Parcel ID", or sometimes abbreviated as "blklot" or "mapblklot".

Always review a dataset's metadata before using a dataset and reach out to support@datasf.org with any questions.

Resources

Streets and intersections

A list of official street names, including street type (AVE, BLVD, ST, etc.). This dataset does not contain a geospatial data field.

All active and retired streets

This dataset contains all street segments in San Francisco. The street segments are identified by their CNN. This dataset contains geospatial data (lines).

List of Intersections

A list of Street Intersections. This dataset contains geospatial data (points).

List of Streets and Intersections

This dataset is a combined list of all street segments and intersections. It contains their corresponding Centerline Network Number ("CNN"). It does not have a geospatial data field.

Parcels, building footprints, and land use

Parcels – Active and Retired

Parcels are specific pieces of land with clear boundaries that define property ownership. The final records of these parcels are kept by the Office of the Assessor-Recorder. This dataset includes both current and past parcels, each identified by a unique Assessor Parcel Number (APN).

Building footprints

The building footprints for San Francisco and Treasure Island as of 2010. The middle of each building was used to assign a parcel number to the footprint. "mblr" represents the APN in this dataset.

This dataset, last updated in 2023, shows how each parcel of land is used. Land use categories include residential, mixed residential, vacant, and retail, among others. Each parcel is identified by its Assessor Parcel Number (APN) and is also referred to as 'mapblklot'.

Assessor Historical Tax Rolls

This dataset includes the Office of the Assessor-Recorder’s secured property tax roll from July 1, 2007, to June 30, 2023. It contains all legally disclosable information, such as property location, property value, a unique property identifier, and specific property characteristics. In this dataset, the Assessor Parcel Number (APN) is referred to as the Parcel Number.

Addresses

Addresses from the Enterprise Addressing System

Active addresses from San Francisco's Enterprise Addressing System (EAS). The EAS is a centralized database which aggregates official addresses for the City and County of San Francisco.

Addresses with Units

All active addresses from the City's Enterprise Addressing System (EAS), including sub-addresses, such as units. Includes references to parcel (Parcel Number) and street centerline data (CNN). Note: not all addresses are associated with parcels.

Other Resources

Data Standards: Basemap

The data standards guide for the City and County of San Francisco's basemap

San Francisco Property Information Map (PIM)

A powerful tool that lets you search by address, parcel number, or planning application number to quickly access detailed information about a parcel.

Partner agencies