NYCPlanning / NYCPlanning/data-engineering
FacDB refactor
Open
@damonmcc is already working on this.
Since May 21, 2026.
db-facilities
- Dominant language
- Python
- Stars
- 43
- Forks
- 3
- Avg merge
- 23h 3m
- Merged PRs (30d)
- 44
Description
In FacDB there are a lot of mappings of source data values to facility types and groups, but they're spread out across many sql files and hard to manage. We also want to use dbt for builds whenever possible and FacDB doesn't yet.
planned changes
- use centralized csvs for facility type and facility group mappings instead of disparate sql queries
- convert (at least) staging and product table creation to dbt models and test them
- (bonus) use dbt freshness feature to test source data freshness
Contributor guide
No contributing guide indexed for this repository
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.
Assessment
This issue has not been assessed yet.