Projects in the City's annual budget

Department of Finance Updated May 29, 2026 As needed

About this dataset

Additional information about projects in the City's annual budget. Use this to supplement the CIP budget dataset.

Read our explanation on how to join the reference datasets to the budget datasets.

Browse the table below for all files available for this dataset

Data Downloads

File name	Download actions	File Format	File size
Project hierarchy	Download Copy URL	CSV	116.92 KB

Showing 1 transposed sample row. Download the full dataset or a view to get the data.

Data Sample

Data preview - first row of dataset transposed
Field	Sample Value
project_number	S00877
asset_type	Transportation
asset_subtype	Roadway - Erosion/Slope/Ret Wall
project_name	Torrey Pines Road Slope Restoration

Each field in the data is defined in the table below. Use this information to inform usage of the data.

Data Dictionary

Data dictionary - field definitions for this dataset
Field	Description	Possible_values
project_number	Uniquely identifies a Capital Improvement Project. The letter denotes the type of project, and the first two numbers represent the fiscal year the project began.
asset_owning_dept	Indicates the City department that owns the project asset
asset_type	Describes the general category of asset
asset_subtype	Describes a subasset, or a more specific category of asset
project_name	Indicates the specific purpose of a project

Data & Analytics