Capital Improvements Program (CIP) Actuals by fiscal year
About this dataset
Actual expenditures for the City's Capital Improvements Program by fiscal year.
CIP actuals contain costs to build and upgrade City infrastructure. Some CIP projects span multiple fiscal years.
Rows in this dataset show actuals at the expense account level. Each row includes the corresponding project and fund type information, but additional corresponding information is available in separate reference datasets. Read our explanation on how to join the reference datasets to the actuals datasets.
For the actuals that show how much the City spent to fund operations and services, see the dataset for the Operating actuals.
Get the data
Browse the table below for all files available for this dataset
Data Downloads
| File name | Download actions | File Format | File size |
|---|---|---|---|
| CIP Actuals | Download |
CSV |
63.05 MB |
View a data sample
Showing 1 transposed sample row. Download the full dataset or a view to get the data.
Data Sample
| Field | Sample Value |
|---|---|
| project_number_parent | AAA00002 |
| project_number_child | B00652 |
| report_fy | 12 |
| fund_type | Federal Grants |
| fund_number | C710000 |
| asset_owning_dept | Airport Management |
| project_name | Brown Field |
| account | Construction Contract |
| account_number | 512025 |
Understand the data
Each field in the data is defined in the table below. Use this information to inform usage of the data.
Download dictionaryData Dictionary
| Field | Description | Possible_values |
|---|---|---|
| amount | Amount spent | |
| fund_type | Groups funds by general purpose | |
| fund_number | Uniquely identifies the fund. Capital funds are preceded by the letter C in the data. | |
| asset_owning_dept | Indicates the City department that owns the project asset | |
| project_name | Indicates the specific purpose of a project | |
| 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. | |
| account | Describes the smallest subset of an account group, typically defined by a specific function, service, or item | |
| account_number | Uniquely identifies an expense or revenue account. Revenue accounts begin with a 4 while expense accounts begin with a 5. |
- PublisherDepartment of Finance
- Last Updated May 22, 2026
- Update Frequency As needed
- Date Issued Oct 15, 2018
- Available Formats .CSV
- License View License
Data & Analytics
data@sandiego.gov