What is the Capital Projects Dashboard?
The Capital Projects Dashboard (CPD) provides a comprehensive market view of all planned infrastructure spending in one single view with powerful filters such as population, project value, fiscal year, project status, project description, geography, and more. The dashboard will help identify opportunity hot spots, create data-driven forecasts you can be confident in with bottom-up data for the next 5 years of planned infrastructure spend, and uncover true market needs.
Key Terms
Capital Improvement Plan
A Capital Improvement Plan (CIP) contains all the individual capital projects, equipment purchases, and major studies for a public infrastructure owner; in conjunction with construction and completion schedules, and in consort with financing plans. The plan provides a working blueprint for sustaining and improving the community’s infrastructure. It coordinates strategic planning, financial capacity, and physical development. A CIP stands at the epicenter of an infrastructure owner’s Planning, Public Works, and Finance departments.
Owner
The name of the infrastructure-owning public entity that published the CIP containing the capital project.
Owner Type
The classification of owners based on their governance structure and the services they provide. While cities and counties are the most common types of owners, any public entity that publishes capital projects can be included in a CPD.
Population
The total population served by the owner.
Document Status
The adoption stage of the CIP. Proposed CIPs are in a draft stage and may be subject to revisions before final publishing. Adopted CIPs are final and will not see additional revisions.
Project Title
The given name for a capital project.
Project Start Year
The first year that money was been allocated to a capital project.
Project Description
A general overview of a capital project. Only included when documented in a CIP.
Project Justification
The rationale for a capital project. Only included when documented in a CIP.
Market
The sector of the capital project. Capital project keywords are used to group the projects into different industry categories.
Project Status
The current completion stage of the capital project. When available in a CIP, the project status is extracted exactly as is. However, often the project status is not provided and is instead inferred and assigned as one of the following catch-all's:
-
Ongoing - A project that has a project start year prior or equal to the current year.
-
Not Started - A project that has a project start year in the future.
Page Number
The file reader page number for a capital project extracted from a PDF formatted CIP. The page number is only provided for capital projects retrieved from PDF files. Opening the hyperlink will direct the user to the location of the capital project within the PDF.
Project Spend/Value
The total amount of money allocated for a capital project.
Dashboard Features
Project Keyword Search
Entering text into the keyword box will filter the dashboard by searching for string matches within the Project Title, Project Description, Project Justification, & Project Industry fields. Only capital projects with matching character strings will be returned. Search by multiple keywords at once by entering them individually or as a string separated by commas. This field is not case sensitive.
Regex Search
For more advanced CPD filtering, regular expression queries can be entered into the Regex Search to filter the dashboard based on matching values contained in the Project Title, Project Description, Project Justification, & Project Industry fields. Please only use lowercase when using the Regex Search. When crafting customized regular expression queries, feel free to reach out to the Citylitics team or check out our summary page on the use of regular expressions here: How to use Regex to search your Capital Projects Dashboard
Owner & Document Data Table
This table summarizes projects by count and value, grouped by owner and segment. It provides a clear overview of each owner's portfolio.
To use this table:
-
Scroll through project owners using the side scroll bar.
-
Use navigation arrows at the bottom to move between pages.
-
Adjust results per page with the “Page Size” dropdown.
Capital Projects Data Table
This table contains all extracted capital projects and their details. Each row represents an individual project.
Capital Projects Data Table Formatting
Adjust the information displayed by clicking the display columns button. This allows you to configure which data appears in your table, adding or removing relevant intelligence (e.g., project justification, owner type, county
Capital Projects Table Download
Select the “Export to CSV” button to instantly export your capital projects data.
Project Count Viewer Map
This chart shows the number of projects across states and provinces. Darker blue shades indicate more projects. The chart is interactive; click states to select or unselect them.
For a county-level view, choose “County” from the dropdown menu in the map's top right corner.
