Hi all - here is my feedback on the CPDB QAQC page going from top to bottom. Love how the text is dynamic.
[x] Change ABOUT CAPITAL PROJECTS DATABASE to About the Capital Projects Database
[x] Do we need the text describing what CPDB is or can we link to Medium blog post. If we need the text in the app then change it to the following:
The Capital Projects Database (CPDB), a data product produced by the New York City (NYC) Department of City Planning (DCP) Data Engineering team, captures key data points on potential, planned, and ongoing capital projects sponsored or managed by a capital agency in and around NYC.
Information reported in the Capital Commitment Plan published by the NYC Office of Management and Budget (OMB) three times per year is the foundation that CPDB is built from. Therefore, only capital projects that are in the Capital Commitment Plan are reflected in CPDB. Additional data sources are incorporated to map the capital projects.
CPDB enables Planners to better understand and communicate New York City’s capital project portfolio within and across particular agencies. While not comprehensive, CPDB's spatial data provides a broad understanding of what projects are taking place within a certain area, and is starting point to discovering opportunities for strategic neighborhood planning.
- [x] Update "ABOUT QAQC" to "About the QAQC Reports" and change the text below to the following:
The QAQC page is designed to highlight key measures that can indicate potential data issues in a CPDB build. These graphs report summary statistics at the agency level and there are 3 ways to filter and view the data (w/ additional variation at the graph level):
Agency type: Sponsoring agency OR Managing agency
Aggregation type: the total number of projects OR the total sum ($) of all commitments
Category type: Include projects in all categories (fixed asset, lump sum, ITT, Vehicles & equipment) OR include only projects that are categorized as Fixed Asset
Additionally, there are basic geographic checks to facilitate the QAQC process of the disparate source data we receive from various city agencies. These checks are not meant to be comprehensive, rather they are intended to provide an indication if spatial data is outside of the NYC spatial boundaries or incorrect in some way.
- [x] Add and edit language under "Key CPDB QAQC terms:"
Mapped: refers to a project record that has a geometry / spatial data associated with it.
Agency type: The Managing agency is the NYC Agency that is overseeing the construction of a project. he Sponsoring agency is the NYC Agency that is funding the project. The managing agency and sponsoring agency can be, but are not always the same.
Category type: Fixed Assets, are projects that are place specific and have an impact on the surrounding area, visible or not, such as park improvements or sewer reconstruction. Projects are categorized by DCP based on key works in the project description. Other categories include Lump Sum, and ITT, Vehicles, and Equipment.
A project is a discrete capital investment, and is defined as a record that has a unique FMS ID.
A commitment is an individual contribution to fund a portion of a project. When looking at the "commitment" view you're looking at the sum of a commitments.
[x] Change "Additional Links" to "Additional Resources"
[x] Change the language under the first graph to:
This graph reports the the Number of All and Mapped Projects by Managing Agency for all categories. Typically, large city agencies including DPR (Dept. Parks and Rec.), DEP (Dept. of Environmental Protection), DOT (Dept. of Transportation), and DCAS (Dept of Citywide Admin. Services) have the largest count of projects and, generally, the highest capital expenditure. Some agencies (e.g. HPD [Housing Preservation & Development]) often have fewer total projects but high capital expenditure because of the nature of their projects which are related to building housing across NYC. The purpose of this graph is to get an overview of the distribution of projets or commitments by agency, and a sense of what portion of these are mapped.
[x] Change the language under the second graph to:
This graph visualizes the difference in the Number of Projects by Managing Agency between the current (aka latest) and the previous version of CPDB. While the underlying Capital Commitment Plan data changes between versions, any drastic changes between CPDB versions that are illustrated by this graph can indicate if there is a specific agency or source dataset to look into further that may have introduced these anomalies. Anomalies include, but are not limited to, no projects being mapped for a given agency when there were mapped projects in the previous version, the number of projects doubling for an agency between versions, or the total sum of commitments halving for an agency between versions. This chart also gives the viewer the flexibility to change between all projects by Number of Projects (both mapped and unmapped) along with an option to just view the mapped (geolocated) projects. Click the "Latest Version" and "Previous Version" labels in the legend to display the total Number of Projects for each.
[ ] For "Visualize Geometries" can we add a basemap to the maps?
[x] Change the language under Visualize Geometries to:
The intent of these maps is to guide engineers in figuring out if the shapefiles are corrupted or had been loaded improperly; indicators of this include points or polygons falling outside the NYC boundary, geometries appearing to be oversimplified (i.e. roadbeds look like "noodles"), and spatial data simply not existing. These maps are meant to be used in addition to the Mapped Capital Projects That Are Not in NYC table, as they may help identify which source spatial data files might be causing the issues.
Historically spatial data issues have been introduced when loading spatial files into data library, specifically when the source data projection has changed. If records are falling outside of NYC from a specific agency, that might indicate an issue upstream with how the data is being uploaded into data library
Hi all - here is my feedback on the CPDB QAQC page going from top to bottom. Love how the text is dynamic.
ABOUT CAPITAL PROJECTS DATABASEtoAbout the Capital Projects DatabaseInformation reported in the Capital Commitment Plan published by the NYC Office of Management and Budget (OMB) three times per year is the foundation that CPDB is built from. Therefore, only capital projects that are in the Capital Commitment Plan are reflected in CPDB. Additional data sources are incorporated to map the capital projects.
CPDB enables Planners to better understand and communicate New York City’s capital project portfolio within and across particular agencies. While not comprehensive, CPDB's spatial data provides a broad understanding of what projects are taking place within a certain area, and is starting point to discovering opportunities for strategic neighborhood planning.
The QAQC page is designed to highlight key measures that can indicate potential data issues in a CPDB build. These graphs report summary statistics at the agency level and there are 3 ways to filter and view the data (w/ additional variation at the graph level):
Additionally, there are basic geographic checks to facilitate the QAQC process of the disparate source data we receive from various city agencies. These checks are not meant to be comprehensive, rather they are intended to provide an indication if spatial data is outside of the NYC spatial boundaries or incorrect in some way.
Mapped: refers to a project record that has a geometry / spatial data associated with it.
Agency type: The Managing agency is the NYC Agency that is overseeing the construction of a project. he Sponsoring agency is the NYC Agency that is funding the project. The managing agency and sponsoring agency can be, but are not always the same.
Category type: Fixed Assets, are projects that are place specific and have an impact on the surrounding area, visible or not, such as park improvements or sewer reconstruction. Projects are categorized by DCP based on key works in the project description. Other categories include Lump Sum, and ITT, Vehicles, and Equipment.
A project is a discrete capital investment, and is defined as a record that has a unique FMS ID.
A commitment is an individual contribution to fund a portion of a project. When looking at the "commitment" view you're looking at the sum of a commitments.
[x] Change "Additional Links" to "Additional Resources"
[x] Change the language under the first graph to:
[x] Change the language under the second graph to: