Capital Projects Explorer Data Schemas

Introduction

Data & Insights' Capital Projects Explorer allows you to visualize the projects that make up your CIP portfolio in a simple, user-friendly interface. The Capital Projects Explorer interface is automatically generated from your data.

Capital Projects Explorer is flexible to your organization’s specific portfolio and needs. The table below shows what data is needed to visualize your portfolio.

 

Dashboard Component

Dataset(s) to Enable Feature

Project Details

Project Map Shapes

Agency District Map Shapes


For your Capital Projects Explorer to work, each dataset must be organized into a flat-file. You can think of this as having all your data on a single tab in Microsoft Excel. This document will explain each of these datasets in detail.

 

Project Details Dataset

The Project Details dataset contains all the descriptive information about your capital projects. The values in this dataset populate the module’s filters as well as the project details page. This dataset must be organized into a flat-file. You can think of this as having all your data on a single tab in Microsoft Excel.

 

Recommended Column Name

Type

Value

Notes

project_id

Required

Text

The ID for a project. Used to join together the project details and project shapes datasets.

project_name

Required

Text

The name of the project.

Project Filters

category_id

Required

Text

The ID of the category that the project is associated with. (e.g. Planning, Design, Construction)

subcategory_id

Optional

Text

The ID of the subcategory that the project is associated with. (eg. Parks, Schools)

district_id

Required

Text

The ID of the district that the project falls within. Can be a comma-separated array for a project that falls in multiple districts.

project_stage_id

Required

Text

The ID for the stage the project is in.

Project Details - Description

project_image

Recommended

Text (URL)

Link to a hosted image that shows up for a project in the project details pane.

project_description

Recommended

Text

The text description of a project that appears in the project details pane.

project_detail (1-n)

Optional

Text

Any number of additional project detail columns may be added to the project details pane (eg, department, fund, etc)

project_start_date

Recommended

Date/Time

The estimated start date of a project. Shows up as Month, Year.

project_end_date

Recommended

Date/Time

The end date of a project. Shows up as Month, Year.

website

Recommended

Text (URL)

Link to an external website for the project. Shows up in the project details pane.

icon

Recommended

Text

The key to the icon for the project. Default is to show the icon associated with its category. The link to a hosted initiative icon is configured in the administration panel.

Initiative icon

Optional

Text

The key to the initiative icon for a project - typically, used to indicate if the project is part of a bond measure or other voter-approved levy. The link to a hosted initiative icon is configured in the administration panel.

Project Details - Budget

budget

Recommended

Number

The budgeted amount for the project.

budget_range

Optional

Number

The range of the budget used for the project. When a project has a budget_range, that value will show appended to budget (eg $ [budget] - $ [budget_range]). Used when a project still has uncertainty about cost/scope.

amount_spent

Optional

Number

The amount spent on the project.

budget_indicator

Recommended

Text

The flag for whether the project schedule is red, yellow or green.

budget_indicator_narrative

Recommended

Text

The description associated with the project’s budget status.

budget_text

Optional

Text

The longer description of the text associated with the project’s budget status.

Project Details - Status

schedule_indicator

Recommended

Text

The flag for whether the project schedule is red, yellow or green.

schedule_indicator_narrative

Recommended

Text

The description associated with the project’s schedule status.

optional_indicator_narrative

Recommended

Text

An optional 3rd indicator narrative if projects are being evaluated in ways besides status and budget.

schedule_text

Optional

Text

 

 CPE_Fields1.png

CPE_sample-project-details.png

Project Shapes Dataset

Capital Projects Explorer expects the shapes for projects to be in a separate dataset than the details of those projects.

 

Recommended Column Name

Type

Value

Notes

project_id

Required

Text

The key used to join shapes with projects.

project_name

Optional

Text

The name of the project.

the_geom

Required

(multi) line, point or polygon

The geometry column that contains the project shapes.

 

Agency Shapes Dataset

Capital Projects Explorer expects projects to be filtered by districts or regions and offers a clickable map of those districts to make navigation more straightforward.

 

Recommended Column Name

Type

Value

Notes

district_id

Required

Text

The key used to join shapes with districts.

project_name

Optional

Text

The name of the project.

the_geom

Required

Multipolygon

The multipolygon column that contains the district shapes.

 

Was this article helpful?
1 out of 1 found this helpful

Comments

0 comments

Article is closed for comments.