sca_capacity_project update needed for "capital_plan" column

Open
#2,164 1 comment 0 reactions 1 assignee View on GitHub

Maintainers usually reply within 1 day

@damonmcc is already working on this.

Since Jan 12, 2026.

Assessment

This issue has not been assessed yet.

Description

https://github.com/NYCPlanning/data-engineering/blob/2ff36fe2ad846532ff48e3c349431f57ad5ed8f0/products/ceqr/ceqr_app/recipes/sca_capacity_projects/build.sql#L59

current output shared has column L "capital_plan" hardcoded with years "15-19"/"20-24" even though column K "start_date" has years after these capital plan years - it would be extremely helpful to update the code for the future to prevent confusion on capital plan years. Thanks!

Image
Dominant language
Python
Stars
2
Forks
0
Avg merge
13h 8m
Merged PRs (30d)
138

Getting set up

Open in Codespaces

Starts the project's dev container in your browser, under your own GitHub account.

  • No Dockerfile or Docker Compose file
  • Has a pull request template
  • No contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from NYCPlanning/data-engineering

All issues in NYCPlanning/data-engineering

Similar issues

More Python issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.