NYC Open Data Help Desk: Data Questions and Reported Errors

7304

Data Question

Agency not assigned yet.

I want to know what is going on at the boundary between school districts 17 and 23, on Sutter Ave. The boundary goes into some part of Sutter Ave, which makes me confused if this part is included in district 17 or district 23. Thanks for your reply in advance

No URL Submitted.

District 23 is drawn that way to include address along Sutter Avenue in District 23. The addresses on the streets intersecting Sutter Avenue (Ralph Ave, Union St & west side of Tapscott St) are in District 17. Hope this clarifies your question.

Thank you,
- DCP Open Data Team


NOTE: To respond to this inquiry, you must edit your original submission by opening the following link and selecting "Edit Response": https://nyc-moda.forms.fm/nyc-open-data-team-help-desk/responses/Z0FfgWEDn7pH

Closed

2020-11-23T00:00:00.000

2026-10-02T00:00:00.000

7303

Data Question

Department of Transportation (DOT)

1. methodologies for data collection?
2. I mapped the coordinates in the LINK_POINTS variables. Those multiple points are on a road segment, but the segment could be very long. How should we use the LINK_POINTS?
3. After group by year, day and hour, the number of data rows is 1620 per hour. Why the number is the same for different hour?

DOT Traffic Speeds

https://data.cityofnewyork.us/d/i4gi-tjb9

Thank you for your inquires. The New York City Department of Transportation Traffic Management Center (NYC DOT TMC) receives data from a coalition of transportation and public safety agencies in New York managed by Transcom (vendor) - allowing operations staff to track live traffic conditions at key locations in the City. For more information about the dataset please visit the Real Time Traffic Speed Open Data page and the metadata.pdf under the "attachments" section, which provides additional information about the dataset. You may contact also TMC directly with the provided email- TMCDOT@dot.nyc.gov.

Real Time Traffic Speed: https://data.cityofnewyork.us/Transportation/DOT-T...
NYC DOT TMC: https://www1.nyc.gov/html/dot/html/motorist/atis.s...

Thank you,
- NYC DOT Open Data Team

Closed

2020-11-23T00:00:00.000

2026-10-02T00:00:00.000

7298

Data Question

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

Hello,
I am a graduate student at ***** researching the city's environmental regulations related to heating oil type. I found this "historical" dataset, but it doesn't have a lot of documentary information about what it represents or when it was gathered. I see that it was originally created in 2014 but updated in 2019. Could you tell me which year the data actually represents, or anything else about how this list was composed?

I'm also hoping to locate information on the types of fuel oil used in individual buildings. I can gather some of this information using the Energy and Water Data Disclosure for Local Law 84 annual dataset for the most recent years, but it looks like the pre-2015 datasets don't have information about oil type. Is that data available elsewhere?

Thanks so much for your time!

NYC Clean Heat Dataset (Historical)

https://data.cityofnewyork.us/d/8isn-pgv3

Response not sent yet.

Pending

2020-11-21T00:00:00.000

2026-10-02T00:00:00.000

7293

Data Question

311

Hello,
I'm a Business Analyst for *****. Kindly ask for clarification with regards to the SR volume by Channel on the link provided above. I know New York has an impressive volume of calls per year. However, on the data set the volume for Phone as Channel is around 1.2 mil ave per year. It is correct to assume that the the difference between 40+ mil calls per year and 1.2 is given by the calls that don't create a SR?

Thank you,
*****

311 Service Requests from 2020 to Present

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

Response not sent yet.

Pending

2020-11-19T00:00:00.000

2026-10-02T00:00:00.000

7290

Data Question

Agency not assigned yet.

Where is the data for percent positivity on this site come from? I understand how it is calculated, but I would like to know how it is collected. Is it people that seek out a test? I ask because I I recall the mayor saying that it was random samples at various locations like grocery stores around the city. Is that true? Thanks in advance

No URL Submitted.

Good Afternoon,
The Health Department receives electronic laboratory reports for a number of infectious diseases, including COVID-19, as required by law in the NYC Health Code. When a specimen is collected from a patient who is a NYC resident for SARS-CoV-2 laboratory testing, the laboratory must report all results, whether positive, negative, or inconclusive, to the Health Department. So the citywide percent positivity is derived from all persons tested in NYC.


Thank you,
- NYC Open Data Team

Closed

2020-11-18T00:00:00.000

2026-10-02T00:00:00.000

7286

Data Question

Department of Environmental Protection (DEP)

Hello Office of Data Analytics,

My name is ***** and I am a student at ***** in *****. I am working with the Water Distribution Quality Dataset (https://data.cityofnewyork.us/Environment/Drinking-Water-Quality-Distribution-Monitoring-Dat/bkwf-xfky) for one of my courses this semester. I am having some trouble mapping the sample sites and was wondering if you could provide some assistance. I am given a spreadsheet with x and y coordinates that correspond to the location but I'm not finding information on how these were obtained or how to convert these to latitude/longitude coordinates. The sample site locations are also difficult to work with as they feature multiple indicators of address. Any assistance or direction would be greatly appreciated. I am working to further emphasize how amazing the water quality is in each borough and would like to share my findings with others.

Thank you, *****

Drinking Water Quality Distribution Monitoring Data

https://data.cityofnewyork.us/d/bkwf-xfky

Response not sent yet.

Closed

2020-11-17T00:00:00.000

2026-10-02T00:00:00.000

7285

Data Question

Agency not assigned yet.

I am a bit confused how the data are collected. if for example, I want to download data for parking violations using the dataset in 2020, this also offers historic data before 2020. If I use the dataset in 2015 let's say there is not an exact match in the cases before 2015 for the two datasets + it offers data after 2015. so it is not clear to me which dataset(s) should I use if i want to download all the available cases. I noticed that there is a significant sudden increase of violations since 2019 - while before most of the days there are not any violations. Would that make sense?
I want to use your data for an academic paper in the field of finance.
Thank you.

No URL Submitted.

There are various Open Data Portal pages containing Parking Violation Issuance data.

The following Open Data Portal pages contains Parking Violations issuance data only for each of the Fiscal Years listed. These pages are a static snapshot of issuance data that is not updated after the initial data upload for each Fiscal Year page. The data on these pages reflect the data that has been captured from the parking ticket (be it electronically issued or physically written parking tickets).

Parking Violations Issued - Fiscal Year 2015 (https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2015/c284-tqph)
Parking Violations Issued - Fiscal Year 2016 (https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2016/kiv2-tbus)
Parking Violations Issued - Fiscal Year 2017 (https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2017/2bnn-yakx)
Parking Violations Issued - Fiscal Year 2018 (https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2018/a5td-mswe)
Parking Violations Issued - Fiscal Year 2019 (https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2019/faiq-9dfq)
Parking Violations Issued - Fiscal Year 2020 (https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2021/pvqr-7yc4)
Parking Violations Issued - Fiscal Year 2021 (https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2021/pvqr-7yc4)

In addition, the following Open Data Portal page was created in 2016 and contains all open parking and camera violations issued since January 2016.

Open Parking and Camera Violations (https://data.cityofnewyork.us/City-Government/Open-Parking-and-Camera-Violations/nc67-uf89)

This particular data set gets updated on a regular basis once an action is taken on the issued parking and camera violation (such as the violation being paid). This page is a more comprehensive view of the open Parking and Camera Violations issued since January 2016.

Depending on the nature of your analysis, if you are looking strictly at only issuance data by Fiscal Year, it would be recommended that you refer to the data sets on the Fiscal Year pages. If you are looking at additional data elements such as payment information, it would be recommended that you refer to the Open Parking and Camera Violations page.



Thank you,
- NYC DOF

Closed

2020-11-17T00:00:00.000

2026-10-02T00:00:00.000

7283

Data Question

Agency not assigned yet.

when will nyc ems open data be updated?

No URL Submitted.

Response not sent yet.

Pending

2020-11-13T00:00:00.000

2026-10-02T00:00:00.000

7280

Data Question

Agency not assigned yet.

Is there more information regarding the complaint status for those that were deemed "closed" that would help distinguish whether a violation was found or not or whether the inspection passed or did not pass?

Also, do you have a master list of addresses for NYC that could help us determine the proportion of addresses with an inspection?

Thank you in advance for your help.

No URL Submitted.

Good Morning,
Unfortunately, That information is not posted but can be obtained for specific complaints through a FOIL request. Please submit a FOIL request by contacting foilrequests@health.nyc.gov. Also, our agency does not have or maintain a master list of NYC addresses in our Bureau.

Best,
NYC DOT – Open Data Team

Closed

2020-11-12T00:00:00.000

2026-10-02T00:00:00.000

7279

Data Question

Agency not assigned yet.

In this dataset, the "About" Tab on the upper right of the page says that it was last updated on November 11, 2020 but the actual data has not been updated since 05/02/2020. The column "Last_Updated_Date_Time" shows 05/02/2020 10:00pm as the last updated date & time for every row. Additionally the dates & times in columns 2 - 6 are clearly outdated. In the "Description" section of the "About" tab, it says "This schedule is updated quarterly prior to January, May and September." It looks like the September update never happened. Will the data ever be updated? If so, when?

No URL Submitted.

Thanks for calling this issue to our attention. The updated list will appear today. Please let us know if you have any further questions about this, or any other dataset.

Closed

2020-11-11T00:00:00.000

2026-10-02T00:00:00.000

7278

Data Question

Agency not assigned yet.

Hi,

For my research paper, I need to report how many open data sets do you have.

Best Regards,

No URL Submitted.

We apologize for the delayed response. As of today, there are 3,089 datasets on the portal.

Closed

2020-11-11T00:00:00.000

2026-10-02T00:00:00.000

7275

Reported Error

Agency not assigned yet.

Can you please update this dataset to include bikelane projects completed in 2020?

No URL Submitted.

Thank you for your inquiry. The NYC Department of Transportation Bicycle and Greenways team provides Bicycle Route updates for the Open Data Portal. This dataset updates after the implementation season ends which is at the end of the year, the renewal schedule for this dataset is around February, 2021.
The current metadata has a biannual schedule, this will be update in the coming weeks to reflect the bicycle routes implantation schedule. We apologize for any inconvenience.

Thank you,
- NYC DOT Open Data Team

Closed

2020-11-10T00:00:00.000

2026-10-02T00:00:00.000

7273

Data Question

Department of Health and Mental Hygiene (DOHMH)

Can I get a verification that this data is directly from the NYC Dept. of Health and Mental Hygiene?

DOHMH New York City Restaurant Inspection Results

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

Yes, this data is collected and maintained by NYC DOHMH Environmental Health Services Division

Closed

2020-11-10T00:00:00.000

2026-10-02T00:00:00.000

7272

Data Question

Department of Finance (DOF)

Hi - I need to find J-51 benefits information on a specific block and lot number. The time period was 1984 to 1994. Is there a way to confirm these benefits using the J-51 dataset? I need to be that the records here go back that far. Thanks.

DOF Property Abatement Detail

https://data.cityofnewyork.us/d/rgyu-ii48

The J-51 Exemption and Abatement dataset will have abatements for the period you are searching for. You will need your borough, block, and lot for the search.
Link, https://data.cityofnewyork.us/City-Government/J-51...


Thank you,
- NYC DOF

Closed

2020-11-09T00:00:00.000

2026-10-02T00:00:00.000

7269

Reported Error

Department of Housing Preservation and Development (HPD)

On 11/8 I had a total count of the endpoint and my local db of 6099341 records, and now today I get a count of 6004765. I want to know what happened to the 90k + records.

Housing Maintenance Code Violations

https://data.cityofnewyork.us/d/wvxf-dwi5

We tested the open data file you inquired about and found the correct number of records as expected. Is it possible your connection to the data may have cut off as a one time error? Please let us know if you are still encountering issues.
https://data.cityofnewyork.us/resource/wvxf-dwi5.json

Thank you,
NYC Open Data Team + HPD

Closed

2020-11-09T00:00:00.000

2026-10-02T00:00:00.000

7268

Data Question

Taxi and Limousine Commission (TLC)

The data in this report only goes through July 2020. I am wondering when more recent data will be uploaded to the report. Thanks so much in advance.

FHV Base Aggregate Report

https://data.cityofnewyork.us/d/2v9c-2k7f

Thank you for reaching out about the Taxi and Limousine Commission's open data. We release updates to the FHV Base Aggregate Report on the final Monday of every month, assuming no business interruptions or other delays. TLC granted traditional FHV bases an extra month-long extension to submit trip records through August due to the pandemic, which is why the data is currently on a three month lag. The upcoming data release on November 30 will include both August and September data, as those trip records were both due to the TLC on October 31, when the pandemic extension ended. Hope this helps!

Closed

2020-11-09T00:00:00.000

2026-10-02T00:00:00.000

7261

Data Question

Mayor's Office of Media and Entertainment (MOME)

Is there a way to find out the name of the production companies and the project name?

Film Permits

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

While the information you are asking for isn't available on Open Data, you are free to make a FOIL request to the Mayor’s Office of Media and Entertainment (MOME) for that information via Open Records with this link: https://a860-openrecords.nyc.gov/.

Closed

2020-11-05T00:00:00.000

2026-10-02T00:00:00.000

7257

Reported Error

Taxi and Limousine Commission (TLC)

The car, With TLC license # of
***** (01/12/22) does not appear in the database.

For Hire Vehicles (FHV) - Active

https://data.cityofnewyork.us/d/8wbx-tsch

Thanks for reaching out about the Taxi and Limousine Commission's Open Data, and apologies for the delay-- the TLC does not maintain the inbox you used to ask about your license. I see that as of yesterday 11/5, your vehicle with license ***** is current, and therefore able to drive. This will be reflected on today's open data release, which will be published between 4-7 pm.

In the future, please feel free to use the TLC Upload Portal (TLC UP) to check TLC license status and update documents, and the Licensing Applications, Renewals and Summonses portal (LARS) to apply for a new license, renew a license, or handle a summons. The information on these portals is updated more frequently than NYC Open Data, and is available on-demand 24 hours per day. Links are included below.

TLC UP
www.nyc.gov/tlcup

LARS
https://www1.nyc.gov/lars/

You may also contact the TLC directly using the Licensing Inquiries (licensinginquiries@tlc.nyc.gov) inbox, and someone from TLC will walk you through whatever issue you are having. Hope this helps!

Closed

2020-11-03T00:00:00.000

2026-10-02T00:00:00.000

7244

Data Question

Agency not assigned yet.

Is there a search by address option to pinpoint fire hydrants near a specific address?

No URL Submitted.

No, the hydrants are not tied to individual addresses. The locations are tracked using latitude and longitude in x, y coordinate format. You may be able to combine the GIS layer information with another layer containing address information to identify hydrants nearest to a particular address.

Closed

2020-10-29T00:00:00.000

2026-10-02T00:00:00.000

7243

Reported Error

311

The public dataset seems to be missing entries. None of the Service Requests below can be found in the public dataset but exist in the lookup for sr-details. Is this an error with the transferring the data over?

311-03251811
311-03249981
311-03250233
311-03251138
311-03250157
311-03251214
311-03252374
311-03324645

311 Service Requests from 2020 to Present

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

Response not sent yet.

Pending

2020-10-29T00:00:00.000

2026-10-02T00:00:00.000

7238

Data Question

Agency not assigned yet.

When will aug and sept be available?

No URL Submitted.

Response not sent yet.

Pending

2020-10-24T00:00:00.000

2026-10-02T00:00:00.000

7232

Data Question

Financial Information Services Agency / Office of Payroll Administration (FISA-OPA)

Hello,

I was wondering how far back the city payroll data goes. What is the first year in which the data is available? Are there any records pre-2015? Thanks in advance for any help you can provide.

Citywide Payroll Data (Fiscal Year)

https://data.cityofnewyork.us/d/k397-673e

Response not sent yet.

Pending

2020-10-20T00:00:00.000

2026-10-02T00:00:00.000

7231

Reported Error

Department of Housing Preservation and Development (HPD)

Hello, there are duplicate records throughout this file, e.g. RegistrationID 119770

Registration Contacts

https://data.cityofnewyork.us/d/feu5-w2e2

Thank you for contacting the NYC Open Data help desk. I believe the duplicate issue you identified has now been resolved by our tech team. If you are still seeing this issue please let me know.

Thank you,
The NYC Open Data Team + HPD

Closed

2020-10-20T00:00:00.000

2026-10-02T00:00:00.000

7230

Reported Error

Agency not assigned yet.

Hello, there appear to be duplicate records along with issues with the registration date, which appears to correlate to causing duplicates.

E.g. look up RegistrationID 119770.
The LastRegistrationDate for both entries is 09/18/2019, but the end date is different.

This is happening throughout the entire file.

No URL Submitted.

Thank you for contacting the NYC Open Data help desk. I believe the duplicate issue you identified has now been resolved by our tech team. If you are still seeing this issue please let us know.

Thank you,
The NYC Open Data Team + HPD

Closed

2020-10-20T00:00:00.000

2026-10-02T00:00:00.000

7228

Reported Error

Department of Citywide Administrative Services (DCAS)

I never worked for fire department

City Record Online

https://data.cityofnewyork.us/d/dg92-zbpx

Response not sent yet.

Pending

2020-10-19T00:00:00.000

2026-10-02T00:00:00.000

7224

Data Question

Department of Finance (DOF)

Hi - How can I find out if there was a J-51 tax abatement for my building? I know there was one for 1984-1994, but I would like to find proof of it. The website I used to get the information no longer exists.

J-51 Exemption and Abatement (Historical)

https://data.cityofnewyork.us/d/y7az-s7wc

The most recent abatement data is in the Property Abatement Detail dataset, https://data.cityofnewyork.us/City-Government/DOF-...

Please use your borough, block, and lot information to search this dataset.

Closed

2020-10-17T00:00:00.000

2026-10-02T00:00:00.000

7223

Reported Error

Agency not assigned yet.

misspelled name: correct name is Lieutenant *****
(not *****) - *****

No URL Submitted.

Response not sent yet.

Pending

2020-10-17T00:00:00.000

2026-10-02T00:00:00.000

7218

Reported Error

Agency not assigned yet.

I believe there may be an issue with the ecb violations dataset. I've been attempting to download it for about 2 hours, but the file won't commence download. I was able to successfully download a csv file once, but when I opened the file there was data. The file had an error message that read: {"message":"Internal error: please include code a1946274-90f3-4e83-a01d-cd1332f808d2 if you report the error".

I would really love to be able to access this dataset as soon as possible.

Thanks in advance for any assistance you're able to provide.

No URL Submitted.

The dataset that you inquired about is not an official dataset. It was made by another open data user. The official dataset you might be looking for can be found here: https://data.cityofnewyork.us/City-Government/OATH-Hearings-Division-Case-Status/jz4z-kudi. Let us know if you encounter the same problem with this one.

Closed

2020-10-14T00:00:00.000

2026-10-02T00:00:00.000

7215

Data Question

Agency not assigned yet.

Can you please update BOTH the WalkNYC maps? The data appears to be over a year and a half old.

No URL Submitted.

Apologies for the delay, the WalkNYC map layers were recently updated. The data you've requested can be found here:
WalkNYC Overview BaseMap (2020): https://data.cityofnewyork.us/Transportation/WalkN...
WalkNYC Focus BaseMap (2020): https://data.cityofnewyork.us/Transportation/WalkN...

Thank you for using NYC Open Data Portal.

Closed

2020-10-14T00:00:00.000

2026-10-02T00:00:00.000

7214

Data Question

Department of Transportation (DOT)

Can you please update this dataset? The data is over a year old.

WalkNYC Overview BaseMap 2020

https://data.cityofnewyork.us/d/7jbq-q7je

Apologies for the delay, the WalkNYC map layers were recently updated. The data you've requested can be found here:
WalkNYC Overview BaseMap (2020): https://data.cityofnewyork.us/Transportation/WalkN...

WalkNYC Focus BaseMap (2020): https://data.cityofnewyork.us/Transportation/WalkN...

Thank you for using NYC Open Data Portal.

Closed

2020-10-14T00:00:00.000

2026-10-02T00:00:00.000

7212

Data Question

Agency not assigned yet.

I would like to know why I am not on the list for police officer. I scored very high on exam #0320-0136 and it dosent appear to be on any list? Please help me as I really want to become a police officer.

No URL Submitted.

The list for Exam #0320 has not yet been established. Please log in to Oasys regularly for any updates.

Closed

2020-10-13T00:00:00.000

2026-10-02T00:00:00.000

7211

Data Question

New York City Police Department (NYPD)

Hello! The NYPD arrest data indicates that values coded in the JURISDICTION_CODE column are as follows:
- 0, Patrol
- 1, Transit
- 2, Housing
- 3+, Other (non-NYPD jurisdictions)
Is it possible to get clarification about which value may represent MTA police? Is it 1, or is it in the 3+ category? If so, which?
Thank you!

NYPD Arrest Data (Year to Date)

https://data.cityofnewyork.us/d/uip8-fykc

Hello. MTA police would fall under the 3+ category since MTA is not under NYPD jurisdiction. Thank you for your question.

Closed

2020-10-13T00:00:00.000

2026-10-02T00:00:00.000

7209

Data Question

Agency not assigned yet.

Hello,
Is there a place I can find the column name descriptions? They are not available on github, in the csv or in the shapefile. I am specifically wondering about the units and description for the values in column "shape_area".
Thanks!

No URL Submitted.

Please be advised that this dataset is not an official public asset, but was created by an Open Data user. The Open Data Team does not provide support for community datasets.
The official Building Footprints dataset can be found at this link: https://data.cityofnewyork.us/Housing-Development/Building-Footprints/nqwf-w8eh. The metadata for that dataset can be found at this link: https://github.com/CityOfNewYork/nyc-geo-metadata/blob/master/Metadata/Metadata_BuildingFootprints.md.

Closed

2020-10-13T00:00:00.000

2026-10-02T00:00:00.000

7208

Data Question

Department of Finance (DOF)

Hi, I am trying to plot the parking violations represented in this dataset on a map.
There's no zip code field which makes geocoding impossible (violation post code doesn't do it), so instead I'm trying to figure out what Street Code1, Street Code2, and Street Code3 mean. Can you help me? thanks.

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. The coordinate values are derived from data provided by the Department of City Planning. The BYTES of the BIG APPLE™ family of software, data and geographic base map files can be downloaded here for free. To receive alerts when new data sets or updates are available, subscribe to our BYTES of the BIG APPLE RSS Feed. (http://www1.nyc.gov/site/planning/data-maps/open-data.page).

Closed

2020-10-13T00:00:00.000

2026-10-02T00:00:00.000

7207

Data Question

Department of Investigation (DOI)

Version 1.2 of the Evictions table removed the Schedule Status column with the comment that "the true indicatior of whether eviction was executed is in executed_date column." We would like to know eviction filings that are pending -- an important indicator separate from executed evictions. Is this data available via Open Data or can you put us in contact with someone from DOI to discuss.

Evictions

https://data.cityofnewyork.us/d/6z8x-wfk4

Response not sent yet.

Pending

2020-10-13T00:00:00.000

2026-10-02T00:00:00.000

7204

Data Question

Agency not assigned yet.

I am not finding a way to select my dataset. When I zoom into the block that I want to download the footprint of, and then click download, I am dowloading the entire footprint map for nyc. How do I limit the scope of my download?

No URL Submitted.

Response not sent yet.

Pending

2020-10-12T00:00:00.000

2026-10-02T00:00:00.000

7202

Data Question

Taxi and Limousine Commission (TLC)

Why are FHV bases not up to date with sending trip data to you?
B00448

For Hire Vehicles (FHV) - Active

https://data.cityofnewyork.us/d/8wbx-tsch

Thanks for reaching out about the Taxi and Limousine Commission's open data. Bases that do not complete trips, or that have failed to submit records properly and have been summonsed by our Prosecution division, do not appear in the FHV Base Aggregate list, so it is possible that this base is in one of those two situations. Please keep in mind that the FHV Base Aggregates are only updated through June 2020, so if base B00448 has completed trips and submitted records for any month since then, they won't be represented in the report. Please check back frequently to see updates to this open data list, and let us know if you have any further questions.

Closed

2020-10-11T00:00:00.000

2026-10-02T00:00:00.000

7201

Reported Error

New York City Fire Department (FDNY)

All of the dates in this dataset, per several columns, seem to be from 2008, despite the dataset being last updated October 6, 2020. Possibly an older dataset was uploaded. I'm requesting the most up to date data. Thank you!

EMS Incident Dispatch Data

https://data.cityofnewyork.us/d/76xm-jjuj

The dataset that you are referring to does have data as recent as July 2020. We are not due for another update to this dataset unless explicitly told to do so by the New York City Fire Department.

Closed

2020-10-11T00:00:00.000

2026-10-02T00:00:00.000

7197

Data Question

Department of Health and Mental Hygiene (DOHMH)

we are working on a schoool project and are using this data set. We are curious what rank means in this data set. if all of the other variables are the same except from ethnicity, ranks are different. is rank only based on an isolated group of the ethnicity corresponding to that data point?

Popular Baby Names

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

Please note the title of the dataset: Popular Baby Names by Sex and Ethnic Group, see the data dictionary and look at data itself.

Rank is the rank order of frequency of the baby name being used/given. The most frequent name used is ranked 1, 2nd most frequent, ranked 2, 3rd most frequent, ranked 3, and so on…

In this dataset, the ranks are by sex and Race/Ethnic group.

For example, in 2016, among Black Non-Hispanics girls, Ava is the most frequent baby name given, hence, ranked #1, with 121 babies given that name. Among Asian-Pacific Islanders girls, Olivia is the most frequency baby name given, hence, ranked #1, with 172 babies given that name.

Closed

2020-10-07T00:00:00.000

2026-10-02T00:00:00.000

7190

Data Question

Agency not assigned yet.

What's the unit of tree_dbh(diameter of the tree). Inch or cm?

No URL Submitted.

Thank for your message about the TreesCount! 2015 dataset. DBH is measured in inches. I will make an update to the data dictionary to clarify this field for other users.

Closed

2020-10-04T00:00:00.000

2026-10-02T00:00:00.000

7189

Data Question

Agency not assigned yet.

Hi, we are using this dataset for our spatial analytic project. From the data dictionary, we understand that each record represents a shooting incident in NYC. However, we noticed that the incident key in the dataset is not unique. Would it be possible to enlighten us on how we should interpret this? What's the relationship of perpetrator and victim in this dataset? Is it 1-to-1 or m-to-m? Thanks.

No URL Submitted.

Regarding your question, for one shooting Incident there will be a unique key. In the data there might be several rows with the same key, which means there are multiple victims. There may be multiple perpetrators though which is where it can be disaggregated.

Thank you,
- NYC Police Department

Closed

2020-10-04T00:00:00.000

2026-10-02T00:00:00.000

7186

Reported Error

Agency not assigned yet.

My business with certificate number
*****
is not listed in the current dataset. Please let me know how I may be included. Thank you.

No URL Submitted.

The issue has been resolved. You can now view Imiplex in the M/WBE, LBE, and EBE Certified Business List dataset.

Closed

2020-10-02T00:00:00.000

2026-10-02T00:00:00.000

7176

Data Question

Department of Citywide Administrative Services (DCAS)

How can our homeowners association add our properties to the database about restrictive covenants?

Deed Restriction Database

https://data.cityofnewyork.us/d/rfu7-paqe

Response not sent yet.

Closed

2020-09-29T00:00:00.000

2026-10-02T00:00:00.000

7164

Reported Error

New York City Police Department (NYPD)

Hello,
I'm using this data for my thesis. When I'm trying to download the Excel, all Incidents from 01.01.2019 -12.31.2019 are missing. Please advise how to obtain the whole data as I need to continue working on my research.

NYPD Arrests Data (Historic)

https://data.cityofnewyork.us/d/8h9b-rp9u

Good morning. In response to your question, if you apply the filters to the data set you can view the year 2019 data. I was able to download the 2019 data from the open data portal and I will email it to you for your reference. Thank you.

- NYC Police Department

Closed

2020-09-25T00:00:00.000

2026-10-02T00:00:00.000

7162

Data Question

Department of Finance (DOF)

Hello - I was curious if it was possible to get additional history on this data-set (Tax Lien Sales), as via the website I can only download data back to 2019. However in the data-set description/ meta-data it mentions Date Created = March 4, 2016. I would like to acquire the full historical data-set. Please let me know. Frank Panico ftpanico@gmail.com

Tax Lien Sale Lists

https://data.cityofnewyork.us/d/9rz4-mjek

The Tax Lien Data for 2016 is not available on the portal and it not possible to recreate it going back to that year.


Thank you,
- NYC DOF

Closed

2020-09-25T00:00:00.000

2026-10-02T00:00:00.000

7158

Reported Error

Agency not assigned yet.

Hi,
My name is ***** and I am a PhD Fellow. For my research, I am trying to download a non-geospatial file type about park zones in each ZIP Code of NYC. More specifically, I am trying to get the CSV for Excel as I need the Acres for each ZIP. However, when downloading the table, the Acres Colomn totally loses the comma, as it is just a "." (a point, instead of a ","). In this way, at the end I have very big values of Acres, which wrong and usuable. Can you please help me and tell how I can get correct acres values from your database? Thanks in advance and hope to hear from you soon.
Best regards,
*****

No URL Submitted.

Thank you for your message regarding NYC Parks zones. The dataset you to which linked is actually an archived dataset, meaning it is an old version that must remain on the portal but is not longer updated. The current NYC Parks zones dataset is available as a table and as a map. If you still have issues downloading the data, please let us know.

Closed

2020-09-24T00:00:00.000

2026-10-02T00:00:00.000

7156

Data Question

Agency not assigned yet.

This question regards a police officer using his gun and killing a person based upon incident statistics. Is the probability that a white officer kills a black person greater than the probility that a black officer kills a black person? The data set is complicated to read and understand. Thank you.

No URL Submitted.

Regarding your question, the dataset does not support the type of analysis you requested. Thank you for your inquiry.

- NYC Police Department

Closed

2020-09-23T00:00:00.000

2026-10-02T00:00:00.000

7152

Data Question

New York City Police Department (NYPD)

Hello, I was curious about the most recent update to this data. It says it was updated recently, but the data remains unchanged from the June update. Was wondering if there was a way to request the update. Thank you.

NYPD Complaint Data Current (Year To Date)

https://data.cityofnewyork.us/d/5uac-w243

Good afternoon. The data is updated quarterly, typically around the 15th of the month. The data should be updated later in October. Thank you.

- NYC Police Department

Closed

2020-09-22T00:00:00.000

2026-10-02T00:00:00.000

7147

Data Question

Agency not assigned yet.

Can you please confirm what Asset_X_Co and Asset_Y_Co are referring to? Thank you!

No URL Submitted.

The link you provided does not connect to a current dataset. The Green Infrastructure dataset is located here: https://data.cityofnewyork.us/Environment/DEP-Green-Infrastructure/spjh-pz7h

Please review the data dictionary located from the "About This Dataset" button on the dataset page for information on the column values.

Closed

2020-09-20T00:00:00.000

2026-10-02T00:00:00.000

7146

Data Question

Financial Information Services Agency / Office of Payroll Administration (FISA-OPA)

Hello, I am a student at Columbia Law School and I hope to use this data for a class project. I was wondering if it would be possible to get more details about what data is redacted from the NYPD overtime figures based on FOIL exemptions. Thank you!

Citywide Payroll Data (Fiscal Year)

https://data.cityofnewyork.us/d/k397-673e

Response not sent yet.

Pending

2020-09-18T00:00:00.000

2026-10-02T00:00:00.000