NYCPlanning / NYCPlanning/data-engineering

investigate NYCEM FacDB records

Open
#1,386 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

db-facilities
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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.