NYCPlanning / NYCPlanning/data-engineering
Standardize formatting for facility operator names
Open
@damonmcc is already working on this.
Since Jun 22, 2026.
db-facilities
- Dominant language
- Python
- Stars
- 43
- Forks
- 3
- Avg merge
- 23h 3m
- Merged PRs (30d)
- 44
Description
Copying content from this comment
I also see that we have multiple rows for what seem to be the same operator, but they're formatted differently (including/excluding punctuation, different case, etc)
What do you think is a good way to consolidate these operators so that if we wanted to get all the facilities of a single operator, we can (instead of the facilities being split up between the same operator)? I'm nearing the end of my SQL data clean up skills...
The two main needs for standardization are
- Facility operator names e.g.
ZMI Foundation, Inc.should be same asZMI Foundation, Inc - Abbreviation and type should be consistent across these operators
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.