NYC Open Data Help Desk: Data Questions and Reported Errors

10263

Data Question

New York City Police Department (NYPD)

This map seems to have divided the map into areas (possibly a Vornoi map) in advance and counted the number of crimes in the area, how are these small areas divided, and can you provide an SHP file or other information about the area?

NYPD Complaint Map (Year to Date)

https://data.cityofnewyork.us/d/2fra-mtpn

The data you've requested can be found here:
NYPD Complaint Data Current (Year To Date) | NYC Open Data (cityofnewyork.us)
It contains Latitude and Longitude coordinates as well as NY State Plane coordinates for mapping. The dataset can be exported as a shapefile.

Thank you,
The NYC Open Data Team

Closed

2023-11-01T00:00:00.000

2026-10-02T00:00:00.000

10262

Data Question

Mayor's Office of Climate and Environmental Justice (MOCEJ)

We previously requested some NYC building energy audit reports from NYSERDA via FOIL. We would like to know which agency collects the LL87 Energy Audit Data and which department is responsible for it? (For example: Is it audited and reported by the building owners themselves, or is it audited and collected uniformly by the DOB?)

LL87 Energy Audit Data

https://data.cityofnewyork.us/d/au6c-jqvf

Thank you for reaching out to the NYC Open Data Helpdesk! The Mayor's Office of Climate and Environmental Justice (MOCEJ) provides this data. You can learn more about this agency here: https://climate.cityofnewyork.us/.

Thank you,
NYC Open Data Team

Closed

2023-11-01T00:00:00.000

2026-10-02T00:00:00.000

10255

Data Question

Department of Environmental Protection (DEP)

This data set was last updated Feb 28, 2023 however the update frequency says every 6 months (which was August 28, 2023). It's now October 30, 2023. Has the source of the data given any indication of when the update will occur? Please advise.

Lead Service Line Location Coordinates

https://data.cityofnewyork.us/d/bnkq-6un4

Thank you for bringing this to our attention. The dataset has now been updated with the latest available information.

Thank you,
NYC Open Data Team

Closed

2023-10-30T00:00:00.000

2026-10-02T00:00:00.000

10252

Reported Error

Department of Health and Mental Hygiene (DOHMH)

I'm building a wastewater covid tracking application and I noticed the dataset says it was updated a few days ago but the latest samples are from over a month ago.

Also the state-level dataset does not include NYC data for some reason: https://health.data.ny.gov/Health/New-York-State-Statewide-COVID-19-Wastewater-Surve/hdxs-icuh

Even though the state-provided dashboard has data for NYC: https://coronavirus.health.ny.gov/covid-19-wastewater-surveillance

And the data they have for NYC appears to be more up-to-date than your dataset.

My questions are:
- Will the NYC dataset be updated with new samples from October?
- Is it possible to incorporate the NYC dataset into the NYS dataset so we only need to consume one of the two.
- Where is the state-level dashboard getting their data for NYC? Is there a different dataset I should be using which is kept more up to date?

Thanks!

SARS-CoV-2 concentrations measured in NYC Wastewater

https://data.cityofnewyork.us/d/f7dc-2q9f

Response not sent yet.

Pending

2023-10-29T00:00:00.000

2026-10-02T00:00:00.000

10251

Data Question

Department of Youth and Community Development (DYCD)

Hi,
I see the dataset is described as being demographic statistics. But I'm curious as to what the column names mean. Particularly the 'COUNT PARTICIPANTS' column and the 'COUNT NRECEIVES PUBLIC ASSISTANCE' column.

Should these be viewed as sample size and the number of participants that do NOT receive public assistance, respectively?

Regards,
Kayvis Damptey
Tactical Foresight Consulting, LLC

Demographic Statistics By Zip Code

Please note that the data set is only DYCD participant demographic statistics by ZIP Code. ‘COUNT PARTICIPANTS’ is the total number of DYCD participants living in that ZIP Code, and ‘COUNT RECEIVES PUBLIC ASSISTANCE’ is the number of DYCD participants from that ZIP Code who self-identified as receiving public assistance.

For demographic statistics on the full population of NYC, you can refer to the Population FactFinder (https://popfactfinder.planning.nyc.gov/) put forward by the Department of City Planning based on the American Community Survey. While the information there is not aggregated at the ZIP Code level, there is a ZIP Code map layer and Census Tracts can be aggregated to approximate.

Thank you,
NYC Department of Youth and Community Development (DYCD)

Closed

2023-10-27T00:00:00.000

2026-10-02T00:00:00.000

10244

Data Question

Department of Investigation (DOI)

can you update this? the 2022 data is available: https://www.nyc.gov/site/doi/offices/cmar.page

City Marshals Revenue

https://data.cityofnewyork.us/d/7ewi-9cdf

Thank you for bringing this to our attention. The dataset has now been updated with the latest available information.

Thank you,
NYC Open Data Team

Closed

2023-10-25T00:00:00.000

2026-10-02T00:00:00.000

10243

Reported Error

Department of Buildings (DOB)

The penality_imposed, amount_paid, and balance_due are off by a factor of 100.

Example
opendata reads 2.5 million for balance due
https://data.cityofnewyork.us/Housing-Development/DOB-ECB-Violations/6bgk-3dad/explore/query/SELECT%0A%20%20%60isn_dob_bis_extract%60%2C%0A%20%20%60ecb_violation_number%60%2C%0A%20%20%60ecb_violation_status%60%2C%0A%20%20%60dob_violation_number%60%2C%0A%20%20%60bin%60%2C%0A%20%20%60boro%60%2C%0A%20%20%60block%60%2C%0A%20%20%60lot%60%2C%0A%20%20%60hearing_date%60%2C%0A%20%20%60hearing_time%60%2C%0A%20%20%60served_date%60%2C%0A%20%20%60issue_date%60%2C%0A%20%20%60severity%60%2C%0A%20%20%60violation_type%60%2C%0A%20%20%60respondent_name%60%2C%0A%20%20%60respondent_house_number%60%2C%0A%20%20%60respondent_street%60%2C%0A%20%20%60respondent_city%60%2C%0A%20%20%60respondent_zip%60%2C%0A%20%20%60violation_description%60%2C%0A%20%20%60penality_imposed%60%2C%0A%20%20%60amount_paid%60%2C%0A%20%20%60balance_due%60%2C%0A%20%20%60infraction_code1%60%2C%0A%20%20%60section_law_description1%60%2C%0A%20%20%60infraction_code2%60%2C%0A%20%20%60section_law_description2%60%2C%0A%20%20%60infraction_code3%60%2C%0A%20%20%60section_law_description3%60%2C%0A%20%20%60infraction_code4%60%2C%0A%20%20%60section_law_description4%60%2C%0A%20%20%60infraction_code5%60%2C%0A%20%20%60section_law_description5%60%2C%0A%20%20%60infraction_code6%60%2C%0A%20%20%60section_law_description6%60%2C%0A%20%20%60infraction_code7%60%2C%0A%20%20%60section_law_description7%60%2C%0A%20%20%60infraction_code8%60%2C%0A%20%20%60section_law_description8%60%2C%0A%20%20%60infraction_code9%60%2C%0A%20%20%60section_law_description9%60%2C%0A%20%20%60infraction_code10%60%2C%0A%20%20%60section_law_description10%60%2C%0A%20%20%60aggravated_level%60%2C%0A%20%20%60hearing_status%60%2C%0A%20%20%60certification_status%60%0AWHERE%20caseless_one_of%28%60ecb_violation_number%60%2C%20%2235645876K%22%29/page/filter

While BIS reads 25k
https://a810-bisweb.nyc.gov/bisweb/ECBQueryByNumberServlet?requestid=3&ecbin=35645876K

DOB ECB Violations

https://data.cityofnewyork.us/d/6bgk-3dad

Response not sent yet.

Pending

2023-10-25T00:00:00.000

2026-10-02T00:00:00.000

10240

Data Question

Department of Health and Mental Hygiene (DOHMH)

1. What was the lower limit of detection for arsenic, lead, and mercury?
2. the description says "Certain consumer products are also tested for other metals such as arsenic and mercury." How was it decided to test for other metals?

Metal Content of Consumer Products Tested by the NYC Health Department

https://data.cityofnewyork.us/d/da9u-wz3r

Thank you for your inquiries! We believe that these are the answers you are looking for:

What was the lower limit of detection for arsenic, lead, and mercury?
If you are asking about the amount of metal found in the sample of product tested under the "concentration" column, a sample with a metal concentration of "-1" means that there is no detection of metal concentration.

The description says, "certain consumer products are also tested for other metals such as arsenic and mercury". How was it decided to test for other metals?
This is collected as part of the DOHMH surveillance activities and entered into an internal Health Department application called Non-Paint Samples Datastore (NPSD). The metal concentrations of those tested products are then uploaded into NPSD. It's also being used by national and international public health authorities, such as poisoning prevention programs and non-governmental organizations (NGO's) to learn about potential hazardous consumer products associated with poisonings. This data has also triggered broader actions (see https://www.nature.com/articles/s41370-023-00525-1... The surveillance data also informs risk communication messaging (see www.nyc.gov/hazardousproducts)

Thank you,
DOHMH Open Data Team

Closed

2023-10-24T00:00:00.000

2026-10-02T00:00:00.000

10239

Data Question

Department of Finance (DOF)

What are the varying options for "Street Code1", "Street Code2", "Street Code3", and "Violation Location" defined as? For example, what location does "Street Code1" correspond to?

Parking Violations Issued - Fiscal Year 2027

https://data.cityofnewyork.us/d/pvqr-7yc4

The three data fields (Street Code1/Code2/Code3) are GIS coordinates of the location where the violation was issued and intersecting street boundaries.

Thank you,
NYC Department of Finance (DOF)

Closed

2023-10-24T00:00:00.000

2026-10-02T00:00:00.000

10237

Data Question

Department of Buildings (DOB)

This NYC boiler inspection dataset is under the "Housing and Development" category but where are all the other boiler inspections for other building types (commercial, school, hospital, etc.) logged? Where can I find those?

DOB NOW: Safety Boiler

https://data.cityofnewyork.us/d/52dp-yji6

Response not sent yet.

Pending

2023-10-24T00:00:00.000

2026-10-02T00:00:00.000

10231

Reported Error

Department of Finance (DOF)

When I sorted the issue dates in descending order, I realised that it contains wrong dates. There are dates present such as 99/02/205 or 78/17/2012. Please explain why is it so?

Open Parking and Camera Violations

https://data.cityofnewyork.us/d/nc67-uf89

Thank you for contacting the NYC Open Data Helpdesk! The dataset can contain invalid issue dates because whatever value is exhibited on the summons must be reflected in the database, edits cannot be performed to try and correct invalid dates.

Thank you,
NYC Department of Finance (DOF)

Closed

2023-10-22T00:00:00.000

2026-10-02T00:00:00.000

10223

Reported Error

Office of Administrative Trials and Hearings (OATH)

Good morning,

I observed a missing DOB-ECB Violation:

Address: 230 73 STREET, Brooklyn
Violation: 035671109Z
Issuing Agency: DEPT. OF BUILDINGS

BIN: 3147808
Block: 5917
Lot: 16

Thanks,

Matt

OATH Hearings Division Case Status

https://data.cityofnewyork.us/d/jz4z-kudi

Thank you for bringing this to our attention. The dataset has now been updated with the latest available information.

Thank you,
NYC Open Data Team

Closed

2023-10-19T00:00:00.000

2026-10-02T00:00:00.000

10220

Data Question

Department of Finance (DOF)

I downloaded the CSV and CSV for Excel versions of this file but am unable to open either on my desktop or online versions of Excel. Is it because the file is so large? Is there a known workaround? I only need it for The Bronx. Thank you, Dan Hickey

ACRIS - Real Property Parties

https://data.cityofnewyork.us/d/636b-3b5g

Thank you for contacting the Open Data Helpdesk! Yes, it does seem that this dataset being too large is what's crashing Excel. Excel can only handle up to 1 million rows and this dataset has over 44 million. We suggest that you filter this dataset to only work with a subset of it that Excel will be able to handle.
Since you mentioned that you only need this data for the Bronx, try filtering so that the dataset only shows where the CITY column is equal to "Bronx" and the STATE column is equal to "NYC." If that subset is still too large, consider narrowing down even further with other filters such as the date or zip code columns, if applicable.
You can follow this how-to guide (https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View) for more help with filtering datasets.
Feel free to reach back out to us should you have anymore questions or comments.

Thank you,
NYC Open Data Team

Closed

2023-10-18T00:00:00.000

2026-10-02T00:00:00.000

10218

Reported Error

Department of Buildings (DOB)

The penalties are missing the decimal resulting in the amounts being 100 times what they actually are. 120,000 should be 1,200.00

DOB ECB Violations

https://data.cityofnewyork.us/d/6bgk-3dad

Response not sent yet.

Pending

2023-10-17T00:00:00.000

2026-10-02T00:00:00.000

10217

Reported Error

Department of Citywide Administrative Services (DCAS)

Hello, I am a candidate for FDNY Lieutenant exam 0569 and I am reporting an error on the final test scores. The numbers dont add up correctly as my final adjusted score does not match what I have on my records, I need some clarification as the last time it was established there was an error and I think it happened again. a coworker has less seniority points AND test score and he has jumped me 20 spots which does not make sense. I need full disclosed reasons or will have to further my compliant. Please get back to me at your earliest convenience, thank you.

Stephen McGowan

Civil Service List (Active)

https://data.cityofnewyork.us/d/vx8i-nprf

Good afternoon,
We are in receipt of your request.
Please forward your request and any future list inquiries directly to LMACustomerService@dcas.nyc.gov
Be sure to include:
- Your Full Name
- Your Employee ID or Profile number
- Your Exam No., Title, and List Number
- And the reason for your inquiry


Thank you,
NYC Department of Citywide Administrative Services (DCAS)

Closed

2023-10-16T00:00:00.000

2026-10-02T00:00:00.000

10215

Data Question

Department of Parks and Recreation (PARKS)

1. Does the dataset cover all parks within NYC, regardless of their management/ownership—whether federal, state, city, or non-profit organizations? Or is it limited to parks under the city's ownership or management?

2. Does the "acquisition date" indicate the date the park property was officially acquired by the city government?

3. Is there a distinction between the "acquisition date" and the year a park was established? If so, could you elucidate the difference?

Parks Properties

https://data.cityofnewyork.us/d/enfh-gkve

Please see the responses to your questions below. If you have any follow up questions, you can reach out to *****.
 
1. Acquisition date refers to the date it came under NYC Park’s jurisdiction/management. When it is private property acquired for a park purpose, the acquisition date and the title vesting date is the same. We acquire property that is often already city-owned, and perhaps used initially for a different purpose, in that case the acquisition date still only reflects the date our agency took control of the parcel.
2. Jurisdiction refers to management, it may have nothing to do with the land acquisition process. For instance, land for jointly-operated playgrounds was usually acquired for school and park purposes. The land acquisition process was approved by the other government bodies, typically the Board of Estimate (BOE) up until the early 1980s, after consulting with NYC Parks. Upon the BOE’s approval, the City’s Law Department would acquire the property through whatever legal channels necessary, and upon vesting title, the land came under the control of the Department of Education and NYC Parks to execute the purpose for which the parcel was acquired. In other instances, NYC Parks may directly seek out a parcel of land for a park-related purpose and lobby for its acquisition with elected officials, community stakeholders, and seek official city authorization to acquire through the acquisition process outlined on our website, ULURP.
3. If a parcel is acquired through a negotiated purchase with a private entity, a council member may choose to allocate funding towards that acquisition. If funding has already been secured by other means, the Council’s role in the ULURP process is to either vote on the action or allow it to pass by taking no action. The roles of the Council, the City Planning Commission, the community board, the borough president, and mayor’s in the ULURP process are outline on City Planning’s website here: https://www.nyc.gov/site/planning/applicants/applicant-portal/step5-ulurp-process.page
 
Thanks,
NYC Parks Open Data Team

Closed

2023-10-16T00:00:00.000

2026-10-02T00:00:00.000

10212

Data Question

Department of Buildings (DOB)

I'm trying to figure out data discrepancies and missing data points between this dataset and the DOB NOW website.

For example, 1682 weeks avenue BIN#2007361, Plans/Work (PW1) states 9909.79 sq. ft. but Zoning Information states 9621.30 sq. ft.

Also, there are many data points on the DOB NOW website that I do not see in any of the DOB NOW datasets. An example is the "job description" field.

DOB NOW: Build – Job Application Filings

https://data.cityofnewyork.us/d/w9ak-ipjd

Response not sent yet.

Pending

2023-10-16T00:00:00.000

2026-10-02T00:00:00.000

10207

Data Question

Department of Finance (DOF)

Hello, I made a submission about a month ago related to the referenced dataset. To date, I have not recieved a response. See my question below
Can NYC OpenData extend the Tax Period lookback from 2021 to 1990s? Or even 2000? This is only limited to the last three years

Property Exemption Detail

https://data.cityofnewyork.us/d/muvi-b6kx

Response not sent yet.

Open

2023-10-12T00:00:00.000

2026-10-02T00:00:00.000

10206

Reported Error

Department of Buildings (DOB)

Please go to https://a810-dobnow.nyc.gov/publish/Index.html#!/search and do a search on job number "B00349703-I1," it shows Work Type as "SP/SD/PL." If you look at the DOB NOW API, https://data.cityofnewyork.us/resource/w9ak-ipjd.json?job_filing_number=B00349703-I1, all of the Work Type shows "False"

DOB NOW: Build – Job Application Filings

https://data.cityofnewyork.us/d/w9ak-ipjd

Response not sent yet.

Open

2023-10-12T00:00:00.000

2026-10-02T00:00:00.000

10202

Reported Error

Department of Finance (DOF)

The file has the column "OWNER2" which is mainly empty for the exemptions I pulled, but there is not OWNER or OWNER1 field. Should OWNER be in the file?

Property Exemption Detail

https://data.cityofnewyork.us/d/muvi-b6kx

The OWNER2 field represents the secondary exemption applicant name while the EXNAME field represents the primary exemption applicant name. These fields may contain a property owners name but should not be confused as property owner fields.

Thank you,
NYC Department of Finance (DOF)

Closed

2023-10-10T00:00:00.000

2026-10-02T00:00:00.000

10200

Data Question

New York City Police Department (NYPD)

Hello, I am a student at Northern Kentucky University. We would like to use your dataset for our class project. For that, we need some information regarding how the dataset was collected and the frequency of the collection. I hope to hearing back from you regarding this information. Thank you.

Motor Vehicle Collisions - Crashes

https://data.cityofnewyork.us/d/h9gi-nx95

Thank you for contacting the NYC Open Data Helpdesk! It looks like you are viewing our "Motor Vehicle Collisions - Crashes" dataset from data.gov. For the best results, we suggest accessing our datasets from our main site, opendata.cityofnewyork.us. When accessing this dataset directly from our platform, you will see a section called "About this Dataset" that lists some categories of metadata for this dataset. There will also be a link to down this dataset's accompanying data dictionary.
If you still have questions about this dataset, feel free to reach back out to us.

Thank you,
NYC Open Data Team

Closed

2023-10-10T00:00:00.000

2026-10-02T00:00:00.000

10198

Reported Error

Department of Transportation (DOT)

We are using the traffic counts in this dataset to validate our own computed traffic counts from a computer vision approach with dash cam data, but the dataset hasn't been updated since January 2023 (whereas our data is updated daily). If we could get an updated version of this dataset, that would be great - thanks!

Automated Traffic Volume Counts

https://data.cityofnewyork.us/d/7ym2-wayt

Apologies for the delay, thank you for bringing this to our attention. The Automated Traffic Volume Counts dataset has now been updated with the latest available information.
https://data.cityofnewyork.us/Transportation/Automated-Traffic-Volume-Counts/7ym2-wayt/about_data


Thank you,
NYC Department of Transportation

Closed

2023-10-10T00:00:00.000

2026-10-02T00:00:00.000

10196

Reported Error

Department of Small Business Services (SBS)

Hello,
FDNY MWBE team reports that some MWBE certified vendors are missing from the open data SBS Certified Business List. For example,
Globallink Holdings Incorporated

SBS Certified Business List

https://data.cityofnewyork.us/d/ci93-uc8s

Thank you for bringing this to our attention. The dataset has now been updated with the latest available information.

Thank you,
NYC Open Data Team

Closed

2023-10-10T00:00:00.000

2026-10-02T00:00:00.000

10195

Reported Error

Department of Transportation (DOT)

We are looking for the automated traffic volume count dataset maintained by the DOT. The current dataset (found at https://data.cityofnewyork.us/Transportation/Automated-Traffic-Volume-Counts/7ym2-wayt) was last updated in Jan 2023. We are looking for the updated dataset that includes the recent months (up to and including Sep 2023). We are developing a novel, machine-learning-aided technique to characterize city traffic data based on dashcam footage, and the USDOT traffic count data will help us validate or invalidate our approach by comparing it with the ground truth.

Automated Traffic Volume Counts

https://data.cityofnewyork.us/d/7ym2-wayt

Apologies for the delay, thank you for bringing this to our attention. The dataset has now been updated with the latest available information.
https://data.cityofnewyork.us/Transportation/Automated-Traffic-Volume-Counts/7ym2-wayt/about_data

Thank you,
NYC Department of Transportation

Closed

2023-10-10T00:00:00.000

2026-10-02T00:00:00.000

10194

Reported Error

Department of Buildings (DOB)

Hi NYC Open Data Team,

There appears to be a glitch recently rolled out in the DOB ECB Dataset where balance fields: "PENALITY_IMPOSED",
"AMOUNT_PAID", and "BALANCE_DUE" are displaying incorrect values.
It appears as if the decimal preceding the final two digits has been removed from these fields.

For Example
for Violation: 39040395N
ON DOB BIS
The penalty imposed is: "$60,000.00"
However, in the Socrata dataset the "PENALITY_IMPOSED" is listed as "6,000,000" The removal of the decimal in "60,000.00" Has resulted in a penalty imposed that is $5,940,000 higher on the NYC Open Data/ Socrata dataset. The same issue extends to the "AMOUNT_PAID"
"BALANCE_DUE" fields, and as far as I can tell it extends to every record in this data set. It appears as if field level changes have resulted in this error. I confirmed in a snapshot of this dataset from 4/11/23 that this error did not exist. So it seems to have been introduced within the last few months. Please correct this issue as soon as possible!

The link below contains a sample of a few more records that are affected by the same issue:
https://data.cityofnewyork.us/Housing-Development/DOB-ECB-Violations/6bgk-3dad/explore/query/SELECT%0A%20%20%60isn_dob_bis_extract%60%2C%0A%20%20%60ecb_violation_number%60%2C%0A%20%20%60ecb_violation_status%60%2C%0A%20%20%60bin%60%2C%0A%20%20%60boro%60%2C%0A%20%20%60block%60%2C%0A%20%20%60lot%60%2C%0A%20%20%60hearing_date%60%2C%0A%20%20%60hearing_time%60%2C%0A%20%20%60served_date%60%2C%0A%20%20%60issue_date%60%2C%0A%20%20%60severity%60%2C%0A%20%20%60violation_type%60%2C%0A%20%20%60respondent_name%60%2C%0A%20%20%60respondent_city%60%2C%0A%20%20%60penality_imposed%60%2C%0A%20%20%60amount_paid%60%2C%0A%20%20%60balance_due%60%2C%0A%20%20%60infraction_code1%60%2C%0A%20%20%60section_law_description1%60%2C%0A%20%20%60infraction_code2%60%2C%0A%20%20%60section_law_description2%60%2C%0A%20%20%60infraction_code3%60%2C%0A%20%20%60section_law_description3%60%2C%0A%20%20%60infraction_code4%60%2C%0A%20%20%60section_law_description4%60%2C%0A%20%20%60infraction_code5%60%2C%0A%20%20%60section_law_description5%60%2C%0A%20%20%60infraction_code6%60%2C%0A%20%20%60section_law_description6%60%2C%0A%20%20%60infraction_code7%60%2C%0A%20%20%60section_law_description7%60%2C%0A%20%20%60infraction_code8%60%2C%0A%20%20%60section_law_description8%60%2C%0A%20%20%60infraction_code9%60%2C%0A%20%20%60section_law_description9%60%2C%0A%20%20%60infraction_code10%60%2C%0A%20%20%60section_law_description10%60%2C%0A%20%20%60aggravated_level%60%2C%0A%20%20%60hearing_status%60%2C%0A%20%20%60certification_status%60%0AWHERE%0A%20%20%28%60amount_paid%60%20%3E%200%29%0A%20%20AND%20%28%28%60balance_due%60%20%3E%200%29%0A%20%20%20%20%20%20%20%20%20AND%20%28%28%60penality_imposed%60%20%3E%200%29%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20AND%20caseless_one_of%28%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%60ecb_violation_number%60%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%2239040395N%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%2235069219H%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%2235125094R%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%2235151630K%22%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%29%29%29%0AORDER%20BY%20%60amount_paid%60%20DESC%20NULL%20LAST/page/filter

Best,
*****

DOB ECB Violations

https://data.cityofnewyork.us/d/6bgk-3dad

Response not sent yet.

Pending

2023-10-09T00:00:00.000

2026-10-02T00:00:00.000

10189

Reported Error

Department of Small Business Services (SBS)

Hello,
we are using the SBS Certified Business List data report to load the MWBE business. This vendor is not on the open data report:

• A & A Plumbing Systems, Inc.
This vendor is listed in the SBS directory
https://sbsconnect.nyc.gov/vendor-profile/?guid=bb9b9830-afdb-e811-814c-005056b6686e

Please help. Thank you

SBS Certified Business List

https://data.cityofnewyork.us/d/ci93-uc8s

Thank you for bringing this to our attention. The dataset has now been updated with the latest available information.

Thank you,
NYC Open Data Team

Closed

2023-10-06T00:00:00.000

2026-10-02T00:00:00.000

10188

Data Question

Office of Administrative Trials and Hearings (OATH)

We at the CUNY UPFI are conducting a study on the NYC Green Carts Program. New York City Green Carts are food carts and trucks that bring fresh fruits and vegetables and other healthy foods to neighborhoods that have lacked access to fresh produce. Green Cart vendors must have a New York City Department of Health and Mental Hygiene valid mobile food vending license to operate.
The question is, in the street vendor's violation dataset, how do we get to know that the particular vendor belongs to Green Cart? Are there any specific characteristics/codes that might apply only to Green Carts vendors. I can see one of the column in the data set is the issuing agency. So, if the DOHMH issues a particular code to the Green Cart vendors then it will be helpful to us.

street vendors

Response not sent yet.

Pending

2023-10-05T00:00:00.000

2026-10-02T00:00:00.000

10187

Data Question

Department of Health and Mental Hygiene (DOHMH)

How was the dataset collected initially?
What is the frequency of data collection or updates?
Who were the contacts or entities involved in data collection?

Popular Baby Names

https://data.cityofnewyork.us/d/25th-nujf

The data information you've requested can be found here: Popular Baby Names | NYC Open Data (cityofnewyork.us). You can find more information/answers to your questions in the data dictionary found in the attachments section.

Thank you,
DOHMH Open Data Team

Closed

2023-10-05T00:00:00.000

2026-10-02T00:00:00.000

10186

Data Question

Taxi and Limousine Commission (TLC)

My name is ***** and I am writing you from Japan.
I have a question regarding the open datasets.

I live in Japan now and not a New　Yorker. Is it possible to use your datasets for my research?

I look forward to hearing from you soon.
Yours sincerely,

*****

2016 Green Taxi Trip Data

https://data.cityofnewyork.us/d/hvrh-b6nb

Thank you for contacting the NYC Open Data Helpdesk! Per the Open Data Law, users do not need a license in order to copy, reuse, or share the data on the open data portal. New York City's open data is free for anyone to use for any purpose they see fit.

We do not require, but encourage users to cite the data and share the results under a similarly permissive license.

Our team would love to see the results of your research! Once it's done, please submit any project that uses our data to be featured on our Project Gallery via this submission form.
‎
Thank you for being a part of the NYC Open Data community!

All the best,
NYC Open Data Team

Closed

2023-10-04T00:00:00.000

2026-10-02T00:00:00.000

10185

Data Question

Department of City Planning (DCP)

Hi, Is it possible to get earlier versions of this data? I am looking for the Assembly District 69 (AD69) data for 2016 and 2018. My information from other sources - https://vote.nyc/sites/default/files/pdf/maps/ad/ad69.pdf - is that AD69 used to have 115 Election Districts EDs) within it. The data in https://data.cityofnewyork.us/City-Government/Election-Districts/h2n3-98hq only lists 86 EDs.

Election Districts

https://data.cityofnewyork.us/d/h2n3-98hq

The Department of City Planning (DCP) open data collection is available on our website on the BYTES of the BIG APPLE archive page. Search 'assembly district' than click on the version (i.e. 16a, 18b, etc.) from the year and quarter you want. The NYS Assembly and all other political districts are generally released quarterly. Major redistricting is usually done three years after a decennial census, the quarterly releases track minor changes to the NYC street grid which the Assembly and most political districts are aligned with.

Thank you,
-DCP Open Data Team

Closed

2023-10-04T00:00:00.000

2026-10-02T00:00:00.000

10182

Reported Error

Department of Housing Preservation and Development (HPD)

It appears that this dataset only has data for 2021 and 2022, but on the HPD website it has PDF lists of building starting in 2013. Can these additional years be added?
Also, a large number of records have typos in the ORDER_ISSUE_DATE field ("0202", "0221")

Buildings Selected for the Underlying Conditions Program

https://data.cityofnewyork.us/d/xpbf-ithr

Thank you for your inquiry. We will reach out to our ENS/Tech Team to see if it is possible to release additional years. We will email you directly once we hear back. Thank you for flagging the typo issue as well. We are currently working on fixing this type of issue in our datasets.

Thank you,
NYC Department of Housing Preservation and Development (HPD)

Closed

2023-10-04T00:00:00.000

2026-10-02T00:00:00.000

10181

Reported Error

Department of Small Business Services (SBS)

Hello,
FDNY receives the daily data load of the MWBE vendors from SBS via open data. We are missing multiple venors in tht data load, for example:
Butterfly Counseling Services
DILIGENT MECHANICAL SERVICES INCORPORATED
Go Creative Studios LLC
Please advise.

SBS Certified Business List

https://data.cityofnewyork.us/d/ci93-uc8s

Thank you for bringing this to our attention. The dataset has now been updated with the latest available information.

Thank you,
NYC Open Data Team

Closed

2023-10-04T00:00:00.000

2026-10-02T00:00:00.000

10171

Reported Error

Department of Education (DOE)

In the latest school demographic snapshot available on the DOE InfoHub (see Excel download at: https://infohub.nyced.org/reports/students-and-schools/school-quality/information-and-data-overview)
there are 2 new columns not in previous demographic data:
"# Neither Female nor Male",
"% Neither Female nor Male"

These columns are not available in the Data Portal dataset. I am requesting that they be added to the data available via the API.

Thanks.

Matt

2017-18 - 2021-22 Demographic Snapshot

https://data.cityofnewyork.us/d/c7ru-d68s

Response not sent yet.

Pending

2023-10-03T00:00:00.000

2026-10-02T00:00:00.000

10167

Data Question

New York City Police Department (NYPD)

I am using this dataset for my senior thesis in Sociology. I had three clarifying questions before beginning my analysis:
1. When will the dataset be next updated and what time frame of complaints will that include?
2. At what point in time does the NYPD transition from using HADEVELOPMENT to HOUSING_PSA to track whether the complaint took place in public housing?
3. Does a (null) value in HADEVELOPMENT or HOUSING_PSA mean that the complaint did not take place in public housing, that the officer did not record whether the complaint took place in public housing, or either?

I am also happy to clarify any of these questions myself. Thank you!

NYPD Complaint Data Historic

https://data.cityofnewyork.us/d/qgea-i56i

Response not sent yet.

Pending

2023-10-02T00:00:00.000

2026-10-02T00:00:00.000

10165

Reported Error

Department of Health and Mental Hygiene (DOHMH)

DOHMH Childcare Center Inspections file lastest inispection date is 4/24/23. This file has not been refresjhed since april

DOHMH Childcare Center Inspections (Historical)

https://data.cityofnewyork.us/d/dsg6-ifza

Response not sent yet.

Pending

2023-10-02T00:00:00.000

2026-10-02T00:00:00.000

10163

Reported Error

Department of Education (DOE)

I just checked the dataset for the 2005-2019 Graduation Rates Citywide, and it only goes up to 2015. Not 2019. Can you please update the title of the dataset? Thanks.

2005-2019 Graduation Rates Citywide - ALL

https://data.cityofnewyork.us/d/mmnq-4hxa

Response not sent yet.

Pending

2023-09-30T00:00:00.000

2026-10-02T00:00:00.000

10161

Data Question

Department of Health and Mental Hygiene (DOHMH)

when I use API to fetch data, DBA column is somehow missing. What should I do with it

DOHMH New York City Restaurant Inspection Results

https://data.cityofnewyork.us/d/43nn-pn8j

Since this is not an inquiry about the data itself, but rather our website's functionality, we have added the support team for Tyler Data & Insights, the vendor for the NYC Open Data Platform, to this email thread in order to help address this issue.

Thank you,
DOHMH Open Data Team

Closed

2023-09-29T00:00:00.000

2026-10-02T00:00:00.000

10160

Data Question

Department of Buildings (DOB)

If we can't use this data for building information (i.e. DOB BIN # information), which dataset can we use? I would like to have this information to connect building information (e.g. address, owner) to permitting and violation information...

Property Data (Buildings Information System) - Now Retired

https://data.cityofnewyork.us/d/e98g-f8hy

Response not sent yet.

Pending

2023-09-28T00:00:00.000

2026-10-02T00:00:00.000

10148

Reported Error

Department of Education (DOE)

Hello, the data dictionary is a little bit out of whack with the columns in the actual data set. Some fields in the dictionary don't exist anymore in the dataset (for example, location is one field in the dataset, but the dictionary has unique fields for street address, zip, etc.). The dictionary is also hard to reference because the column orders aren't aligned. Occasionally, fields are named slightly different, for example, boro vs borocode.

2021 DOE High School Directory

https://data.cityofnewyork.us/d/8b6c-7uty

Response not sent yet.

Pending

2023-09-26T00:00:00.000

2026-10-02T00:00:00.000

10145

Data Question

Department of Finance (DOF)

This inquiry is regarding "DOF: Property Charges Balance" file. The last file update on Open Data shows as Sep 2023 while the dataset has records up to 2022. Is it possible to update the dataset to make sure 2023 data is also included within the file? Thanks

DOF: Property Charges Balance

https://data.cityofnewyork.us/d/scjx-j6np

Response not sent yet.

Pending

2023-09-25T00:00:00.000

2026-10-02T00:00:00.000

10143

Data Question

Mayor's Office of Media and Entertainment (MOME)

Looking for updated records for https://data.cityofnewyork.us/City-Government/Film-Permits/tg4x-b46p/explore, Who was filming in Astoria on 30th ave under the train station on 9/14/2023

Film Permits

https://data.cityofnewyork.us/d/tg4x-b46p

Thank you for contacting the NYC Open Data Help Desk. Please be advised that for public safety reasons, we do not include a film's Project Title and delay posting by 3 months, a schedule which we agreed upon with City Council.

Thank you,
NYC Mayor’s Office of Media and Entertainment

Closed

2023-09-25T00:00:00.000

2026-10-02T00:00:00.000

10142

Data Question

Department of Buildings (DOB)

Is there a dataset available that only contains new building permits (NB). We're looking for a database to search for new buildings and projects in a specific area.

DOB Permit Issuance

Response not sent yet.

Pending

2023-09-25T00:00:00.000

2026-10-02T00:00:00.000

10140

Data Question

311

Hi. I am doing some analysis on the 311 SR data. Am I correct in assuming that the "status" of an SR is updated daily? So, for example, if I export the SR data for August 2023 I may find 80% of the SRs are in "closed" status. And if I extract that same data set later say 60 days later, I might find 95% of the SRs closed. Is that correct? Thank you.

311 Service Requests from 2020 to Present

https://data.cityofnewyork.us/d/erm2-nwe9

You are correct. The data set gets updated daily, so when an agency updates a status – it will be reflected in the daily data update.

Thank you,
NYC 311

Closed

2023-09-24T00:00:00.000

2026-10-02T00:00:00.000

10139

Reported Error

311

City Council district numbers appear to be off in the 311-Service-Requests-from-2010-to-Present dataset.

For example, complaint 58872445 which should be in Council District 7 is listed as part of Council District 23, complaint 58879910 which should be in Council District 6 is listed as part of Council District 19 in the data.

311 Service Requests from 2020 to Present

https://data.cityofnewyork.us/d/erm2-nwe9

Response not sent yet.

Pending

2023-09-23T00:00:00.000

2026-10-02T00:00:00.000

10135

Reported Error

Department of Citywide Administrative Services (DCAS)

My name is not found on the list at all. I earned a 92% on the Firefighter's Lieutenant Exam. My score was also released later due to having testing accommodations and I am concerned that this impacted my place on the list. Thank you.

Civil Service List (Active)

https://data.cityofnewyork.us/d/vx8i-nprf

We are in receipt of your request.
Please forward your request and any future list inquiries directly to LMACustomerService@dcas.nyc.gov

Be sure to include:

1. Your Full Name
2. Your Employee ID or Profile number
3. Your Exam No., Title, and List Number
4. And the reason for your inquiry


Thank you,
NYC Department of Citywide Administrative Services

Closed

2023-09-23T00:00:00.000

2026-10-02T00:00:00.000

10133

Data Question

Department of Transportation (DOT)

I am hoping to know what coordinate reference system is used to generate the WktGeom column? It is not listed in the data dictionary and is different than that used in the other datasets I've used from NYC OpenData. Thanks!

Automated Traffic Volume Counts

https://data.cityofnewyork.us/d/7ym2-wayt

Apologies for the delay. Thank you for contacting NYC Open Data on Automated Traffic Recorder dataset. Well-known text (WKT) represents coordinate reference systems in machine and human readable language. The dataset contains X, Y coordinates. You need a GIS application to convert X,Y to Lat, Long coordinates such as ArcGIS or the open source QGIS.

) Using ArcGIS- license required
Use the Calculate Geometry tool in the attribute table. More information about the tool on the ArcGIS website:https://desktop.arcgis.com/en/arcmap/latest/manage...
1. Export data to CSV and format the WktGeom column (remove "POINT" and parentheses). Separate the X,Y into two columns (use the space as the break.)
2. Load the data into the application as a CSV, add two new columns in the attribute table (long, lat).
3. Use the Calculate Geometry tool in the attribute table (right click on the column header) to process the conversion. Fill in as follows:
a. Coordinates system of the data sources: NAD1983 State Plane New York Long Island FIPS 3104 Feet
b. Use coordinate system of the data frame: WGS 1984
c. Units: Decimal Degree

2) You may use ArcPy to convert the data into geometry, see information from ESRI below.
ArcPy function WKT: https://desktop.arcgis.com/en/arcmap/10.6/analyze/...

3) Using QGIS- free to download

1. Import CSV file: Layer -> Add Layer -> Add Delaminated Text Layer (CSV file)-> (keep everything else as default) only change Geometry CRS: EPSG:2263- NAD83/ New York Long Island (ftUS) -> add
2. Export layer+ Conversion: Export-> Save Feature As-> File Name: (select where to save the new file) Fill in as follows:
3. a. Format: CSV
4. b. CRS: EPSG:4326- WGS 84
5. c. Layer Option- Geometry: AS_XY
Thank you,
NYC Department of Transportation

Closed

2023-09-22T00:00:00.000

2026-10-02T00:00:00.000

10132

Reported Error

Office of Administrative Trials and Hearings (OATH)

Good morning,

I observed a missing DSNY Violation - 048023853N

1881 Walton Avenue
Borough: Bronx
BIN: 2008239
Block: 2852
Lot: 27

Thanks,

Matt

OATH Hearings Division Case Status

https://data.cityofnewyork.us/d/jz4z-kudi

Thank you for bringing this to our attention. The dataset has now been updated with the latest available information. Also, please note that there is a slight delay (usually no longer than a day) in between OATH updating this data on their website and the corresponding dataset being updated on the NYC Open Data Platform, due to the volume of records.

Thank you,
NYC Open Data Team

Closed

2023-09-22T00:00:00.000

2026-10-02T00:00:00.000

10130

Data Question

Mayor's Office of Operations (OPS)

How can I compare numbers between this dataset and the LL37 dataset. The description said they should be comparable, but I'm noticing big jumps in the number of individuals in DHS facilities between the historical data and the new data

Local Law 79/2022 and 136/2024 - Temporary Housing Assistance Usage

https://data.cityofnewyork.us/d/jiwc-ncpi

We are closing out this inquiry since a representative from its assigned agency responded to you directly. Should you have any more questions, feel free to reach out to us again!

Thank you,
NYC Open Data Team

Closed

2023-09-21T00:00:00.000

2026-10-02T00:00:00.000

10129

Data Question

Department of Finance (DOF)

Can NYC OpenData extend the lookback Tax Period lookback period from 2021 to 1990s? Or even 2000? This is only limited to the last three years

Property Exemption Detail

https://data.cityofnewyork.us/d/muvi-b6kx

The three year period coincides with the migration to DOF’s new Property Tax System and as a result, the data cannot be extended prior to the advent of the new system.

Thank you,
NYC Department of Finance (DOF)

Closed

2023-09-20T00:00:00.000

2026-10-02T00:00:00.000

10127

Data Question

Mayor's Office of Operations (OPS)

Hi there! The Mayor's Management Report Dataset says that it will be updated monthly, but I haven't seen any updates since July. Especially since the FY2023 MMR just came out I was wondering when this might be updated with that new info. All the best.

Mayor's Management Report - Agency Performance Indicators

https://data.cityofnewyork.us/d/rbed-zzin

Thank you for bringing this to our attention. The dataset has now been updated with the latest available information.

Thank you,
NYC Open Data Team

Closed

2023-09-20T00:00:00.000

2026-10-02T00:00:00.000