Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

CDBG exports #1429

Open
damonmcc opened this issue Feb 6, 2025 · 2 comments
Open

CDBG exports #1429

damonmcc opened this issue Feb 6, 2025 · 2 comments
Assignees
@damonmcc

Comments

@damonmcc
Copy link
Member

damonmcc commented Feb 6, 2025 •
edited
Loading

changes requested by @AmandaDoyle before we finalize CDBG for release. likely to submit an ITD change management request after sharing outputs internally and before distributing

changes to all exports

  • replace special characters in column names

changes to excel export

  • Census Tract Long should have leading 0s
  • Total Floor Area and Total Residential Floor Area should be formatted with commas
  • % of Floor Area Residential and % of Low-/ Moderate-Income Persons should include a %
  • add appropriate AMI value in excel export (Low and Moderate 4-Person Family Income Limit)

changes to csv export

  • remove Census Tract Long and Census Tract (with decimal) fields
@damonmcc damonmcc self-assigned this Feb 6, 2025
@damonmcc damonmcc moved this from New to 🏗 In progress in Data Engineering Feb 6, 2025
@damonmcc damonmcc mentioned this issue Feb 6, 2025
Draft
2 tasks
@damonmcc
Copy link
Member Author

damonmcc commented Feb 6, 2025

in relevant products/excel models, Census Tract Long values have leading 0s. they may get lost in the excel file

@damonmcc
Copy link
Member Author

damonmcc commented Feb 7, 2025

shared outputs for review today

@damonmcc damonmcc moved this from 🏗 In progress to 🔍 In review in Data Engineering Feb 7, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@damonmcc damonmcc

Labels
None yet
Projects
Data Engineering
Status: 🔍 In review
Milestone
No milestone
Development

No branches or pull requests
1 participant
@damonmcc