CBBR source data questions
Maintainers usually reply within 1 day
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 35/100
- Issue type
- Feature
- Clarity
- Needs clarification
- Activity status
- Active
- Domain
- data-engineering
Research direction
Start by reviewing the Open Data Preliminary, Executive, and Adopted editions linked in the issue alongside the CAPS export and FY2027 omb_cbbr_agency_responses comparison. Resolve whether trkno can be added to the export and which agency explanations are required. Done means the source fields, joins to dcp_cbbr_requests, and replacement of the OMB-to-CAPS-to-DE handoff are clearly decided.
Written by the indexing model from the issue text.
Description
Two questions for CAPS:
- Can the request export include the OMB tracking code (
trkno)? - Does CBBR need the agency explanations from the Preliminary register, or would the Executive and Adopted text on Open Data do?
OMB publishes all three editions of the Register of Community Board Budget Requests on Open Data. If the answers are yes, we could build CBBR from Open Data plus the CAPS export and drop the OMB -> CAPS -> DE handoff for omb_cbbr_agency_responses.
Comparing our FY2027 omb_cbbr_agency_responses to the Open Data Preliminary edition, all 3,809 rows join on trkno = tracking_code. For the OMB columns the build uses:
| OMB column | Open Data |
|---|---|
trkno, priority, agency_response |
match 100% |
reason, lowsgrp1/2 |
match 99%+ |
type, agency_acronym |
derivable from tracking_code and responsible_agency |
budline1-3, capis1-3 |
missing, but always null in OMB's file |
explanation |
missing |
dcpuniqid |
missing |
Why Open Data can't replace the OMB file today:
- No
dcpuniqid, so no way to join todcp_cbbr_requestsfor title, policy area, and location fields. The CAPS export has no tracking code. Open Data's own location fields don't fill the gap (123 of 3,809 rows have abbl). - The Preliminary edition has only the response category, not the agency explanation (our
agency_responsecolumn). Explanations show up starting with the Executive edition, for 1,831 of 3,809 requests.
- Dominant language
- Python
- Stars
- 2
- Forks
- 0
- Avg merge
- 13h 8m
- Merged PRs (30d)
- 138
Getting set up
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
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from NYCPlanning/data-engineering
-
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
NYCPlanning/data-engineering#2996 ·
Maintainers usually reply within 1 day
-
db-facilities
Difficulty 2/5 1-3 hours Newbie friendliness 64/100
NYCPlanning/data-engineering#2847 · 1 assignee ·
Maintainers usually reply within 1 day
-
db-knownprojects
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
NYCPlanning/data-engineering#2629 ·
Maintainers usually reply within 1 day
-
CSCL - coincident_seg_count double-counts subway/rail crossingsPossibly taken @alexrichey claimed this today. Opendb-cscl
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
NYCPlanning/data-engineering#2616 · 1 assignee ·
Maintainers usually reply within 1 day
-
db-gft
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
NYCPlanning/data-engineering#2532 ·
Maintainers usually reply within 1 day
All issues in NYCPlanning/data-engineering
Similar issues
-
Difficulty 1/5 Under an hour Newbie friendliness 85/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
pearu/agent-sandbox#451 ·
Maintainers usually reply within 1 day
-
run_gate loads a custom tasks file from outside the working directoryPossibly taken @Ru0k3 claimed this today. Openbug
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
MakazhanAlpamys/Soup#3189 · 1 comment ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 80/100
Maintainers usually reply within 1 day