NYCPlanning / NYCPlanning/data-engineering
investigate NYCEM FacDB records
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 43
- Forks
- 3
- Avg merge
- 23h 3m
- Merged PRs (30d)
- 44
Description
With the latest release of FacDB, NYCEM noticed issues with four records and emailed us on 1/2. They may be due to inherent limitation of the dataset. COLP/DCAS source data is lot-based, so facilities on the same lot may be aggregated.
During the next release, we should investigate these records to confirm that this is a limitation of the source data and determine if there's precedent to make these types of corrections.
records
NYPD 49th Precinct Station
- UID: 415055980a66a2e046e5ca35c9b987b0
- The correct address should be 2121 Eastchester Rd, Bronx (BIN: 2097543, BBL: 2042050001).
FDNY EMS Battalion 20
- UID: 3c7b30a2edc738865f3c81450c873a96
- The address we have from FDNY is 1401 Pelham Pkwy South (BIN: 2097546, BBL: 2042050001).
NYPD 116th Precinct Station
- This is a new police station just opened in December 2024.
- The address is 244-04 North Conduit Ave in Queens (BIN: 4518258, BBL: 4132650030).
NYPD Queens South Task Force Station
- UID: 78e896e9a89198b09e454956935ca257
- This has the same address as the 116th Precinct, but the point is located in the next building (BIN: 4620957, BBL: 4132650030).
- QSTF maybe have been disbanded and organized into Strategic Response Group (SRG). But SRG is not located in that building anymore.
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.
Research direction
Start by comparing the four listed FacDB records with the COLP/DCAS and FDNY source data using their UIDs, BINs, and BBLs. Check whether lot-based aggregation explains the address and point discrepancies, then review any project precedent for correcting similar records. Done means documenting the limitation or applying and verifying justified corrections, including the potentially disbanded QSTF/SRG record.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- data-engineering, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100