NYC Open Data Help Desk: Data Questions and Reported Errors

10810

Reported Error

Department of Finance (DOF)

Why does a search for the violation Detached Trailer show 108,018 parking tickets, whereas a search for the license type (plate type) TRL shows only 43,387 tickets? ALL the Detached Trailer tickets should have the license type TRL. Therefore, a search for the license type TRL should show more than 108,018 since Detached Trailer is only one of various parking violations vehicles with the the license type TRL receive.

Open Parking and Camera Violations

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

The difference can be attributed to the way in which the violation was issued. Not all the Detached trailer violations were issued using a plate type of TRL; the issuing agent may used a plate type of COM or some other value.

Thank you,
NYC Department of Finance (DOF)

Closed

2024-04-10T00:00:00.000

2026-10-02T00:00:00.000

10803

Data Question

New York City Police Department (NYPD)

I work for the San Francisco Controller's Office and we are doing a project for our Vision Zero effort. I would like to be able to separate this dataset into the violations from automated cameras and those issued by officers directly. Is that possible?
Thank you in advance,
Sarah

Moving Violation B Summons (Historic)

https://data.cityofnewyork.us/d/bme5-7ty4

Thank you for contacting the Open Data HelpDesk! Unfortunately, at present there is no indication on the summons as to the source. It is likely that if an individual location has hundreds of events, the summonses were automatically generated.

Thank you,
The NYC Open Data

Closed

2024-04-05T00:00:00.000

2026-10-02T00:00:00.000

10802

Data Question

The NYC Open Data Team

I can't download the csv and also am struggling with timeouts in this dataset

311 Service Requests from 2020 to Present

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

Thank you for contacting the Open Data Helpdesk! 311 Service Requests from 2010 to Present is a very large dataset with about 36 million rows. Most computer programs will not be able to handle processing that amount of data. We suggest filtering the dataset to only show the fields that you are most interested in. For help with filtering, please consult this guide: https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View.

If you'd like assistance with using the Open Data Platform in general, consider signing up for a "Discovering Open Data" class. These classes are free of charge and take place virtually via Zoom. Learn more by using this link: https://opendata.cityofnewyork.us/learn-open-data/.

Hope this helps!

Thank you,
NYC Open Data Team

Closed

2024-04-05T00:00:00.000

2026-10-02T00:00:00.000

10800

Data Question

School Construction Authority (SCA)

Hello I used this dataset for my doctoral computation. I wanted to understand how this data get updated on the NYC website. Does SCA agency update it manually quarterly or is it system to system automatically update. I'm surprised at the low count of construction phase that are complete. I want to understand how the excel data get updated. It was last updated on May 1, 2023 then again on December 6, 2023. Thank You

Capital Project Schedules and Budgets

https://data.cityofnewyork.us/d/2xh6-psuq

Thank you for contacting the NYC Open Data Helpdesk! We update this dataset manually every quarter before it is sent to Open Data. We hope this information is helpful.

Thank you,
NYC School Construction Authority (SCA)

Closed

2024-04-05T00:00:00.000

2026-10-02T00:00:00.000

10799

Data Question

The NYC Open Data Team

I wanted to ask if the NY TLC trip data can be used for commercial purposes. For example, if I write and publish an article about processing the trip data via a programming language and receive payment for that article, is this permissible? I do not come from or live in New York.

https://www.nyc.gov/site/tlc/about/tlc-trip-record-data.page

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 analysis, once they're done, please submit any project that uses NYC Open Data to be featured on our Project Gallery via this submission form.

Thank you,
NYC Open Data Team

Closed

2024-04-05T00:00:00.000

2026-10-02T00:00:00.000

10797

Data Question

Department of Transportation (DOT)

the columns sign_x_coord and sign_y_coord are documented as longitude, latitude. However, the data provided doesn't seem to be valid. latitude ranges from -90 to 90, and longitude -180 to 180.

Example:
1006449, 219326

So how do I convert sign_x_coord and sign_y_coord to longitude, latitude values?

Parking Regulation Locations and Signs

https://data.cityofnewyork.us/d/nfid-uabd

Thank you for your request on Parking Regulation Sign locations. The coordinate system for the signs are in X,Y, you will need to convert to Latitude and Longitude. One method is to use a Geographic Information Systems (GIS) system application like ArcMap or QGIS, note: some basic GIS knowledge required.
ArcMap-:
1. Download the data as CSV or shapefile
2. If using CSV, load the data into the application as a CSV. Or load the shapefile.
3. Right click on the layer to open an attribute table. Add two new columns in the attribute table, "Lat", "Long".
4. 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

QGIS-: Free and Open Source
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

2024-04-04T00:00:00.000

2026-10-02T00:00:00.000

10781

Data Question

Agency not assigned yet.

Interestingly, there is an abundance of "anti - jewish" bias-motivated hate crimes; however, there are almost none reported for "anti - arab". As a resident of NYC and NJ, I can assure you there have been multiple NYPD-reported bias-motivated hate crimes against Arabs. Fix your site and stop feeding into the zionist propaganda. Do better.

NYPD Hate Crimes

https://data.cityofnewyork.us/d/bqiq-cu78

Response not sent yet.

Open

2024-03-30T00:00:00.000

2026-10-02T00:00:00.000

10777

Data Question

Department of Finance (DOF)

How can we retrieve property subtype or building class from Acris data, ex: if a document states property type as CR and if we want to understand what kind of commercial real estate property this is , is there a way to get this information from any of the datasets on Acris?

ACRIS - Personal Property Legals

https://data.cityofnewyork.us/d/uqqa-hym2

Response not sent yet.

Pending

2024-03-28T00:00:00.000

2026-10-02T00:00:00.000

10776

Reported Error

Department of Finance (DOF)

Weigh in Motion violations replaced Blue Zone violations as of October 1, 2023, yet this table still refers to them as Blue Zone violations.

Compare https://data.cityofnewyork.us/resource/pvqr-7yc4.json?summons_number=4500008287 to https://data.cityofnewyork.us/resource/uvbq-3m68.json?$where=summons_number=4500008287 (both refer to the same summons).

Thank you,
Brian Howald

Open Parking and Camera Violations

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

Response not sent yet.

Pending

2024-03-28T00:00:00.000

2026-10-02T00:00:00.000

10774

Data Question

Department of Parks and Recreation (PARKS)

What is the coordinate system you used to map the tree points? I am working on a project, and this information would be very helpful! Thank you.

Forestry Tree Points

https://data.cityofnewyork.us/d/k5ta-2trh

Thank you for contacting the Open Data HelpDesk! We use the NY State Plane Coordinate System, NAD_1983_StatePlane_New_York_Long_Island_FIPS_3104_Feet. The ID is 2263.

Thank you,
NYC Department of Parks and Recreation (PARKS)

Closed

2024-03-27T00:00:00.000

2026-10-02T00:00:00.000

10772

Data Question

Department of Finance (DOF)

Can you help me understand which column I should be looking at to find the number I'm looking for? I'm looking for the current market value of a given property, but the data dictionary references so many column names that seem relevant to that I don't know which one to be looking at. please help!

Property Valuation and Assessment Data Tax Classes 1,2,3,4

https://data.cityofnewyork.us/d/8y4t-faws

Thank you for contacting the NYC Open Data Helpdesk! 
The column titled “FINMKTTOT” / Final Market Assessed Total Value should be used, that would be the most current FINAL value which is as of May 2023 for Tax year 2024.

Tax year 2025 TENTATIVE values are also available, the column titled “TENMKTTOT” / Tentative Market Assessed Total Value should then be used.


Thank you,
NYC Department of Finance (DOF)

Closed

2024-03-27T00:00:00.000

2026-10-02T00:00:00.000

10767

Data Question

Department of Health and Mental Hygiene (DOHMH)

Hello, I am looking for food safety inspection reports for the major stadiums. For Yankee Stadium, I could not find any inspections after 2019. Are they to be found elsewhere?

DOHMH New York City Restaurant Inspection Results

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

Response not sent yet.

Pending

2024-03-26T00:00:00.000

2026-10-02T00:00:00.000

10761

Data Question

Department of Transportation (DOT)

Hello, I hope this message finds you well! My name is Nick, and I'm a Student Research Assistant at Hofstra University working on a comprehensive research project about severe street flooding's effect on traffic congestion in Queens.

I want to inquire about the Automated Traffic Volume Counts. dataset, which has been extremely useful for understanding traffic flows and congestion volumes in past years. However, my team and I are looking to obtain data on traffic volumes from 2023 (January to December); but it appears that the dataset has not been updated to include the counts from 2023 yet.

According to the metadata, the last update to the dataset was made on January 20, 2023, roughly 1 year and 2 months ago. Since the Update Frequency is listed as "Annually", we wanted to wait a short period of time for 2023 data to be posted. However, as of today, the most recent data in the dataset is still from December 2022.
We thought it would be good to reach out and ask directly if an updated dataset including 2023 traffic counts is planned. If so, would it be possible to obtain that data in the near future? I understand that data collection on a large scale is complex and time-consuming; the time-frame of our project currently would require us to have the data by mid-April, so we thought asking would help us adjust if needed.

Thanks for your time!

Automated Traffic Volume Counts

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

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/data_preview

Thank you,
NYC Department of Transportation

Closed

2024-03-25T00:00:00.000

2026-10-02T00:00:00.000

10760

Data Question

Department of Buildings (DOB)

Hi Open Data team, Hope all is well. My name is Fiona Qiu, an employee from DKCM. I hope to inquire about your Build Elevator Device Details dataset:
1) For the column elevator_manufacturer, does it refer to the manufacturer of the entire elevator or some parts? As I saw GAL as one value, but GAL as a company doesn’t produce whole elevators.
2) For all the device manufacturer columns, do they refer to the manufacturer of the original/old elevator parts or the new/renovated parts if the job is an alternation/replacement job?
3) Some manufacturer columns show as “Existing” whereas others show the brand names. What does “Existing” mean in those cases?
4) Some work descriptions show incomplete sentences. Are descriptions in the data incomplete information of the actual job being conducted?
5) Do you have a column for door manufacturers?
Thank you. I look forward to hearing from you.
Best,
*****

DOB NOW: Build Elevator Device Details

https://data.cityofnewyork.us/d/juyv-2jek

Response not sent yet.

Pending

2024-03-25T00:00:00.000

2026-10-02T00:00:00.000

10759

Data Question

Department of Social Services (DSS)

Hello! When will more current data be released? I'm specifically interested in the number of leases signed per year. Is there anywhere else I might be able to find that data? Thank you!

Local Law 217 of 2017 Report

https://data.cityofnewyork.us/d/rkad-22be

Response not sent yet.

Pending

2024-03-25T00:00:00.000

2026-10-02T00:00:00.000

10758

Reported Error

New York City Fire Department (FDNY)

Hi, I was looking for closed and completed fire investigations and noticed that while it says this dataset is updated annually there has not been a submission since the database creation in 2021.

When can we expect this dataset to become compliant with open data?

Bureau of Fire Investigations - Fire Causes

https://data.cityofnewyork.us/d/ii3r-svjz

Thank you for bringing this to our attention and we appreciate your patience as we resolved your inquiry. The dataset has now been updated with the latest available information.

Thank you,
NYC Open Data Team

Closed

2024-03-25T00:00:00.000

2026-10-02T00:00:00.000

10749

Reported Error

Mayor's Office of Citywide Event Coordination and Management (CECM)

The data does not seem to have been updated in a while.

NYC Permitted Event Information

https://data.cityofnewyork.us/d/tvpp-9vvx

Response not sent yet.

Pending

2024-03-22T00:00:00.000

2026-10-02T00:00:00.000

10748

Data Question

Department of Finance (DOF)

what are these three fields - "street code1", ""street code2"", "street code3" in the Parking Violations Dataset, e.g., "Parking Violations Issued - Fiscal Year 2017" ? Is it able to use it to locate the geographic location?

Parking Violations Issued - Fiscal Year 2017

https://data.cityofnewyork.us/d/2bnn-yakx

Thank you for contacting the Open Data Helpdesk! The three data fields (Street Code1/Code2/Code3) are GIS coordinates of the location where the violation was issued and intersecting street boundaries. The values stored in the three fields are calculated by software (provided by City Planning) using the location referenced on the summons. When a location cannot be translated into the GIS coordinates, the fields are null or blank.

Thank you,
NYC Department of Finance (DOF)

Closed

2024-03-21T00:00:00.000

2026-10-02T00:00:00.000

10747

Data Question

Agency not assigned yet.

Hello,

We're students at Douglas College in British Columbia Canada. We were looking at this restaurant data set and were wondering what the fields "Census Tract", "BIN", "BBL" and "NTA" mean. Is census tract some sort of unit of area?

DOHMH New York City Restaurant Inspection Results

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

Response not sent yet.

Pending

2024-03-21T00:00:00.000

2026-10-02T00:00:00.000

10745

Data Question

Department of Transportation (DOT)

Hello,
Would it be possible to add latitude and longitude fields for the measuring point to the traffic volume counts table.
I'm working on a project linking bike lanes in an area to traffic (and collisions). And it would really help to be able to link on geotags, rather than to have to go through all the locations and create the tags myself.
Thank you so much for your consideration.
Kind regards
Koenraad

Traffic Volume Counts (Historical)

https://data.cityofnewyork.us/d/btm5-ppia

Thank you for your request on Automated Traffic Volume Counts dataset. Well-known Text (WKT) represents coordinate reference systems in machine and human readable language. This dataset contains X,Y coordinates. You may search for mapping WktGeom or use a GIS software to convert the coordinates from X,Y to Lat, Long. Examples of GIS applications are ESRI ArcGIS or the free open-source platform QGIS, some basic application knowledge is required, see options below:

ArcGIS- 
ESRI community: (https://community.esri.com/t5/arcgis-api-for-flex-questions/how-to-convert-x-y-to-lat-long/td-p/353854).
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

QGIS- 
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:
a. Format: CSV
b. CRS: EPSG:4326- WGS 84
c. Layer Option- Geometry: AS_XY

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/arcpy-functions/fromwkt.htm
ESRI GIS forum: https://community.esri.com/t5/python-questions/exporting-wkt-string-from-csv-to-shapefile/td-p/521430

Thank you,
NYC Department of Transportation

Closed

2024-03-21T00:00:00.000

2026-10-02T00:00:00.000

10744

Data Question

Office of Technology and Innovation (OTI)

I noticed that the MIDBLOCK_CURBCUT features in the CURB CUT data set is not included in the NYC Planimetric Database as noted in the 2022 Capture Rules. Is it possible to get this?

No URL Submitted.

Response not sent yet.

Pending

2024-03-21T00:00:00.000

2026-10-02T00:00:00.000

10739

Reported Error

The NYC Open Data Team

The data on govsalaries.com is Incorrect. Looking for information on how to update they system.

http://govsalaries.com

Thank you for contacting the NYC Open Data Helpdesk. GovSalaries is not a website affiliated with NYC Open Data. Please redirect this question to their contact page here: https://govsalaries.com/contact.

Thank you,
NYC Open Data Team

Closed

2024-03-20T00:00:00.000

2026-10-02T00:00:00.000

10738

Reported Error

Department of Sanitation (DSNY)

P Vazzana 686281 - erroneously used my name on a summons for the building which has 5 units and 5 owners. It is condo building and my name should NOT be used for a summons against the building. Remove my name from summons 048205904L. I await a response. Thank you.

http://nyc.gov/oath

Thank you for contacting the NYC Open Data Helpdesk! There was an issue of who is the building owner vs. the unit owner. This ticket has been withdrawn and a new one has been reassigned, no longer referencing you as the owner.

Thank you,
NYC Department of Sanitation (DSNY)

Closed

2024-03-20T00:00:00.000

2026-10-02T00:00:00.000

10737

Reported Error

Department of Finance (DOF)

I do not live at the residence listed in this link from tidal force (19 Russek drive SI NY 10312)
Can you please remove my information/ name from this data

https://app.tidalforce.org/nyc/property/tax/owner/daniel-e-nuzzolo

To update your Property and Billing Information with the Department of Finance (DOF) please see the following: https://www.nyc.gov/site/finance/property/property-update-property-and-billing-information.page.

DOF has no affiliation with Tidalforce and no ability to update their website.

Thank you,
NYC Department of Finance (DOF)

Closed

2024-03-20T00:00:00.000

2026-10-02T00:00:00.000

10734

Data Question

The NYC Open Data Team

hi is there a tutorial on datasets class?

http://www.311.com

We’re so glad to hear that you’re interested in learning how to use NYC Open Data! We teach Open Data 101 classes that are virtual and open to the public! Feel free to sign up here: https://opendata.cityofnewyork.us/learn-open-data/. You can also sign up for the NYC Open Data mailing list to stay abreast of upcoming in-person training opportunities. Please reach back out to us if you have any more questions.

Thank you,
NYC Open Data Team

Closed

2024-03-19T00:00:00.000

2026-10-02T00:00:00.000

10722

Reported Error

The NYC Open Data Team

Can you please remove the address 19 russek drive and Daniel Nuzzolo from your data base and being pulled by Tidal Force .org

https://app.tidalforce.org/nyc/property/tax/owner/daniel-e-nuzzolo

Thank you for contacting the NYC Open Data Helpdesk.

This information is public data under New York State’s Freedom of Information Law (FOIL). The New York City Open Data Law requires City Agencies to make their public datasets, such as payroll records for City employees (https://data.cityofnewyork.us/City-Government/Citywide-Payroll-Data-Fiscal-Year-/k397-673e), available on NYC Open Data.

Additionally, datasets on Open Data are published without restrictions on their use, and third-party websites are allowed to access this data and/or share it via their individual platforms.

We hope this information is useful.

Thank you,
NYC Open Data Team

Closed

2024-03-18T00:00:00.000

2026-10-02T00:00:00.000

10717

Reported Error

The NYC Open Data Team

Can you please remove this property record of in the URL from your data base?

https://app.tidalforce.org/nyc/property/tax/owner/daniel-e-nuzzolo

Thank you for contacting the NYC Open Data Helpdesk.

This information is public data under New York State’s Freedom of Information Law (FOIL). The New York City Open Data Law requires City Agencies to make their public datasets, such as payroll records for City employees (https://data.cityofnewyork.us/City-Government/Citywide-Payroll-Data-Fiscal-Year-/k397-673e), available on NYC Open Data.

Additionally, datasets on Open Data are published without restrictions on their use, and third-party websites are allowed to access this data and/or share it via their individual platforms.

We hope this information is useful.

Thank you,
NYC Open Data Team

Closed

2024-03-15T00:00:00.000

2026-10-02T00:00:00.000

10714

Data Question

Office of Administrative Trials and Hearings (OATH)

I am a data analysist for Jones Lang Lasalle and we have technicians operating in the NYC area who have received idling violations.
In an effort to be proactive and notify our technicians of new violations, I'm pulling data from the NYC Open Data OATH database. (OATH Hearings Division Case Status | NYC Open Data (cityofnewyork.us))

I'm filtering the data to our company and specifically idling violations.

I had a few questions around the NYC Open Data OATH and was hoping someone could help me. Below are my questions:
How long does it take for an idling violation to appear within the OATH NYC open data?
When looking at violations for idling, I'm seeing 5 fields that are charge/penalty fields, could someone help me understand how they total up?
Charge 1 Infraction amount
Additional Penalties or Late Fees
Penalty Imposed
Total Violation Amount
Balance Due

For example, summons number 000766944Y has the following values

Charge 1 Infraction amount = $350
Additional Penalties or Late Fees = $300
Penalty Imposed = $1,000
Total Violation Amount = $350
Balance Due = $1,300

I believe the Total Violation would be the sum total of charge 1 (or charge 2, 3 etc). Is this correct?
Assuming this is correct, Then the initial amount due would be $350. The "Additional Penalties or Late Fees" being $300, would now total up to $650.
Why is the "Penalty Imposed" at $1,000? And then the Balance Due = $1,300?

Wouldn't it be Total Violation Amount + Additional Penalties + Penalty Imposed = Balance Due?
Making this $350 + $300 + $1000 = $1650?

I'm just trying to understand the penalty and additional fee data from the NYC Open Data OATH data set so that we can account for the fees correctly.

My final question would be once a violation is paid; how long does it take to show "Paid" in the NYC Open Data OATH dataset?

Thank you for your help.

OATH Hearings Division Case Status

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

Thank you for contacting the NYC Open Data Helpdesk. The total balance of $1,300 on Open Data is correct. The face amount of violation totaling $350 increased to $1,000 at default (based on the default penalty schedule) when the respondent did not show up for the hearing. Thereafter, there were late fees at 10% ($100) for each month in arrears, presumably for 3 months, which totaled $300. Therefore, the total balance due of $1,300 is the total of the default amount for $1,000 and the late fees of $300.

Thank you,
NYC Office of Administrative Trials and Hearings (OATH)

Closed

2024-03-14T00:00:00.000

2026-10-02T00:00:00.000

10712

Data Question

Department of Finance (DOF)

Who at Finance could we talk to about a history of NOPV data? This is Sarah Sayavong, Senior Data Manager at IBO, and we work with data that predates the PTS conversion. Specifically, we want to ask about certain inconsistencies in prior year NOPV data and were told by DOF to ask Open Data to refer us to the right DOF person. Confusing, I know. Anyway, please reach contact me via email and I can provide more info. Thanks!

Revised Notice of Property Value (RNOPV)

https://data.cityofnewyork.us/d/8vgb-zm6e

Response not sent yet.

Pending

2024-03-14T00:00:00.000

2026-10-02T00:00:00.000

10707

Data Question

Department of Health and Mental Hygiene (DOHMH)

To whom it may concern,

My name is Joey Yoo, and I am with Compass Group USA. I am looking for the inspection results of two of our restaurants in NYC. The CAMIS numbers are 50058568 and 50103864.

DOHMH New York City Restaurant Inspection Results

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

Response not sent yet.

Pending

2024-03-13T00:00:00.000

2026-10-02T00:00:00.000

10705

Data Question

Department of Buildings (DOB)

How do I find a violation which resulted from a complaint?

I imagine it should appear in either the DOB Violations or DOB ECB database but I am not sure whether there is any ID# that can tie the complaint database to either violation database.

DOB Complaints Received

https://data.cityofnewyork.us/d/eabe-havv

Response not sent yet.

Pending

2024-03-13T00:00:00.000

2026-10-02T00:00:00.000

10698

Reported Error

Agency not assigned yet.

Hello,
this vendor Canwell MTS LLC is SBS certified as shown here
https://sbsconnect.nyc.gov/vendor-profile/?guid=e58f5188-9edd-ea11-a813-001dd801892c
but it is not included in the SBS Certified Business data set
https://data.cityofnewyork.us/Business/SBS-Certified-Business-List/ci93-uc8s/about_data
Please help.

SBS Certified Business List

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

Response not sent yet.

Open

2024-03-11T00:00:00.000

2026-10-02T00:00:00.000

10695

Reported Error

Office of Administrative Trials and Hearings (OATH)

Dear NYC Open Data,
In comparing hearing status between the OATH Hearings Division Case Status (base data https://data.cityofnewyork.us/City-Government/OATH-Hearings-Division-Case-Status/jz4z-kudi/data, extracted for just idling tickets at the Dataset URL given in the form) and the ECB ticket finder (https://a820-ecbticketfinder.nyc.gov/searchHome.action), I found over 1000 rows that are marked PAID IN FULL in the ECB ticket finder but not in Open Data.

As this status field is used to request payment from the City for citizen's idling submissions, this is of material impact on citizen reporters.

If you would not mind opening a ticket, I will email you the CSV of the 1089 rows with ticket number and other metadata.

I'm very grateful for your help in assisting with this request. I hope everyone had a great weekend and stayed dry!

Best,
Jonah Scheib

https://data.cityofnewyork.us/City-Government/idling-DEP/4agj-k4jv/data

Response not sent yet.

Pending

2024-03-09T00:00:00.000

2026-10-02T00:00:00.000

10694

Data Question

Department of Health and Mental Hygiene (DOHMH)

Why is there no wastewater report since 1/30 for NYC? thank you!

SARS-CoV-2 concentrations measured in NYC Wastewater

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

Response not sent yet.

Pending

2024-03-09T00:00:00.000

2026-10-02T00:00:00.000

10692

Data Question

Department of Transportation (DOT)

Hi We would like explanations on the fields of the dataset. None is to be found in the excel.
and, also,
do you have other similar datasets (on bike paths in nyc?) with the area (not length) of the paths (approximately even.). What about COMMUTER LOTS and related?
thank you.

https://data.cityofnewyork.us/Transportation/New-York-City-Bike-Routes/7vsa-caz7

We received your inquiry from the NYC Open Data Helpdesk. Our response is as follows:
New York City Bike Routes was recently updated with historical records: https://data.cityofnewyork.us/dataset/New-York-City-Bike-Routes/mzxg-pwib/about_data
The explanation of the fields are in an Excel document under the attachment section, also attached.
The area of the paths are not calculated. New York City commuter lots are not managed by the Department of Transportation but the agency does manage and maintain municipal lots you can find the locations here:
Brooklyn: https://data.cityofnewyork.us/Transportation/Municipal-Parking-Facilities-Brooklyn-/evdj-a5z2/about_data
Manhattan: https://data.cityofnewyork.us/Transportation/Municipal-Parking-Facilities-Manhattan-/i8d5-5ciu/about_data
Queens: https://data.cityofnewyork.us/Transportation/Municipal-Parking-Facilities-Queens-/qfxy-c6k3/about_data
Bronx: https://data.cityofnewyork.us/Transportation/Municipal-Parking-Facilities-Bronx-/7xqy-uv7r/about_data
Staten Island: https://data.cityofnewyork.us/Transportation/Municipal-Parking-Facilities-Staten-Island-/udt3-taj7/about_data
Best,
Department of Transportation (DOT) 

Closed

2024-03-08T00:00:00.000

2026-10-02T00:00:00.000

10681

Reported Error

Department of Finance (DOF)

Hi! This dataset (NYC Citywide Annualized Calendar Sales Update) says that it was updated in July of 2023, but there are no records in the data set prior to 12/2022.

Obviously there have been sales in New York City since 12/2022 :-), so I am thinking that something is wrong with how the data is getting published to the open data portal.

Please let me know your thoughts and if this can be repaired? Thank you so much! --Jonathan Feldman

NYC Citywide Annualized Calendar Sales Update

https://data.cityofnewyork.us/d/w2pb-icbu

Response not sent yet.

Open

2024-03-06T00:00:00.000

2026-10-02T00:00:00.000

10680

Data Question

Department of Parks and Recreation (PARKS)

Good morning,

I have a question regarding the APPENDIX D – A table of Restrictive Declarations indicating requirements applicable to identified tax lots associated with an adopted zoning map amendment, that I hope you can answer for me.

What is the difference between the pdf file:

https://zr.planning.nyc.gov/sites/default/files/appendix/21241/APPENDIX%20D%20%E2%80%94%20Zoning%20Map%20Amendment%20%28%22D%22%29%20Restrictive%20Declarations.pdf

and the Open Data file?
https://data.cityofnewyork.us/Recreation/Restrictive-Declaration-Sites/cmni-fvnx/about_data

Please let me know

Thank you

Restrictive Declaration Sites

https://data.cityofnewyork.us/d/cmni-fvnx

Thank you for contacting the NYC Open Data Helpdesk! We appreciate your patience as we worked on this response. A restrictive declaration (RD) is a covenant recorded against a specific property that places conditions on a property’s future use and development.
- Parks RD GIS Layer https://data.cityofnewyork.us/Recreation/Restrictive-Declaration-Sites/cmni-fvnx/about_data
- This is a Parks general layer that shows built privately maintained sites that are subject a Parks M&O agreements which is usually an attachment to a RD. Most were triggered by zoning actions such as waterfront certification and large-scale development and the M&O codifies the developer’s obligation to build and maintain the open space.
- https://zr.planning.nyc.gov/sites/default/files/appendix/21241/APPENDIX%20D%20%E2%80%94%20Zoning%20Map%20Amendment%20%28%22D%22%29%20Restrictive%20Declarations.pdf
- These sites are subject to RD which indicates specific requirements related to adopted zoning map amendment. The requirements are not necessarily related open space. For example, RD # D-37 (Block 13957 Lot 12) requires the property owner to maintain a brick wall along the parcel’s 92nd St boundary. Not relevant for tracking RDs with a park obligations.    
 
There is no standalone list of RD sites not maintained by Parks.

Thank you,
NYC Department of Parks and Recreation (PARKS)

Closed

2024-03-06T00:00:00.000

2026-10-02T00:00:00.000

10676

Data Question

Mayor's Office of Media and Entertainment (MOME)

Film Permit data is only available between January 2023 and December 2023. Where is the data between 2016 and 2022 and is there data from Jan/Feb 2024?

Film Permits

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

Response not sent yet.

Pending

2024-03-05T00:00:00.000

2026-10-02T00:00:00.000

10674

Data Question

Department of Housing Preservation and Development (HPD)

Do buildings/properties get removed from databases after they are vacated? Are the properties on the dataset currently vacated? We are looking for which buildings are currently vacated if possible. Thanks

Order to Repair/Vacate Orders

https://data.cityofnewyork.us/d/tb8q-a3ar

Hi Ira,

Thank you for your inquiry and for your patience as we looked into this. Please see our response below for your questions:
- Do buildings/properties get removed from databases after they are vacated?
- No, they do not.
- Are the properties on the dataset currently vacated? We are looking for which buildings are currently vacated if possible.
- This dataset provides information about HPD Order to Repair/Vacate Orders issued since January 1 2017. Some of the vacate orders have since been rescinded. If the vacate has a Rescind_Date, the vacate order is no longer in effect.

If you have any additional questions, please do not hesitate to reach out to us directly at OpenData@hpd.nyc.gov.

Best,
HPD Open Data Team

Closed

2024-03-05T00:00:00.000

2026-10-02T00:00:00.000

10672

Data Question

Department of Finance (DOF)

When was this dataset last updated? Where can I find more DOF taxmap data?

Department of Finance Digital Tax Map

https://data.cityofnewyork.us/d/smk3-tmxj

Hey Matt, thanks for the inquiry.

The most recent version of the DTM data is available on NYC Open Data. You can find the official collection in this link the official collection layer: Digital Tax Map Data Collection

The collection also links to the Department of Finance’s Map Feature Server with direct links to Digital Tax Map tables and map layers.

Feel free to reach out again if you have further questions or feedback.

Best regards,
NYC Open Data Team

Closed

2024-03-05T00:00:00.000

2026-10-02T00:00:00.000

10669

Reported Error

Mayor's Office of Operations (OPS)

Hi there - the January 2024 data for Temporary Housing assistance appears to be the wrong date for rows where agency is the Department of Youth and Community Development (DYCD). They are labeled 202301 instead of 202401

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

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

Thank you for contacting the NYC Open Data Helpdesk and bringing this to our attention. The dataset has now been updated with the latest available information.

Thank you,
NYC Mayor's Office of Operations (OPS)

Closed

2024-03-04T00:00:00.000

2026-10-02T00:00:00.000

10668

Data Question

The NYC Open Data Team

I am finding it impossible to navigate your system. My daughter lives in one of my buildings and she incurred a ticket for not removing snow (IN JANUARY!) which she says she paid some time ago. I don't know if this site is broken, but I have been unable to confirm payment of Dept of Sanitation ticket number 048095944L at 36-21 30th Street 11106 in Queens NY.

OATH Hearings Division Case Status

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

We received your inquiry about your daughter’s Sanitation ticket. I was able to use our OATH Hearings Division Case Status dataset to find out some more information. I filtered this data for the ticket number you sent (048095944L) and saw that the hearing status of the ticket is “PAID IN FULL.” Click here to see the filtered results on your end.
 
You can use this article to learn how to filter the datasets on NYC Open Data. You may also sign up for one our Open Data 101 classes, if you wish to learn more about how to navigate our website – we’d love to have you join!
 
Feel free to reach back out should you have any more questions or concerns.

Closed

2024-03-04T00:00:00.000

2026-10-02T00:00:00.000

10667

Data Question

Department of Education (DOE)

No Inquiry Submitted

2021 DOE High School Directory

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

Response not sent yet.

Pending

2024-03-04T00:00:00.000

2026-10-02T00:00:00.000

10664

Reported Error

Department of Health and Mental Hygiene (DOHMH)

This file is not up to date...last permit issued date and inspection date is april 24 2023

DOHMH Childcare Center Inspections (Historical)

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

Response not sent yet.

Pending

2024-03-04T00:00:00.000

2026-10-02T00:00:00.000

10661

Data Question

Department of Transportation (DOT)

The location of street signs on this dataset (sign_x_coord, sign_y_coord) are given in a unque format (e.g. "sign_x_coord": "1033748", "sign_y_coord": "195599"). What is this coordinate system? How can I convert those coordinates into standard format of DEGREES, MINUTES, AND SECONDS (DMS)? Thank you.

Parking Regulation Locations and Signs

https://data.cityofnewyork.us/d/nfid-uabd

The Parking Regulation Locations and Signs dataset offers X,Y coordinate system in the tracking system, the coordinates you've requested are in decimal degree, which are Latitude and Longitude. Example: "sign_x_coord": "1033748", "sign_y_coord": "195599" is converts to Latitude: 40.7034, Longitude: -73.8215
A Geographic Information Systems (GIS) software can be used to convert these coordinates, using ESRI ArcGIS or the free open-source platform QGIS, some basic application knowledge is required, see options below.
1) Using ArcGIS- license required
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
Additional information: More information about the tool on the ArcGIS website:https://desktop.arcgis.com/en/arcmap/latest/manage...
ESRI community forum (https://community.esri.com/t5/arcgis-api-for-flex-questions/how-to-convert-x-y-to-lat-long/td-p/353854).

2) Using QGIS- free to install
More information from this blog: https://www.gisoutlook.com/2020/05/coordinate-conv...
To do:
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
Export layer+ Conversion: Export-> Save Feature As-> File Name: (select where to save the new file) Fill in as follows:
a. Format: CSV
b. CRS: EPSG:4326- WGS 84
c. Layer Option- Geometry: AS_XY 
d. Ok
Thank you,
NYC Department of Transportation

Closed

2024-03-02T00:00:00.000

2026-10-02T00:00:00.000

10660

Data Question

Department of Transportation (DOT)

The Agency Authorized Parking Permits Data Sheet states it was last updated January 11, 2024, but the Data set "Year" shows up to 2022. How can one tell if a Placard issued in 2024 is valid and authenitc?

Agency Authorized Parking Permits

https://data.cityofnewyork.us/d/a23q-dmjn

Response not sent yet.

Pending

2024-03-02T00:00:00.000

2026-10-02T00:00:00.000

10659

Reported Error

Office of Administrative Trials and Hearings (OATH)

Fine was paid for this, and now showing a new hearing date.

OATH Hearings Division Case Status

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

Thank you for bringing this to our attention. We are working with the NYC Office of Administrative Trials and Hearings (OATH) to help resolve this issue. In the meantime you may also reach out to the OATH Help Center: https://www.nyc.gov/site/oath/help-center/email-the-help-center.page

Thank you,
NYC Open Data Team

Pending

2024-03-01T00:00:00.000

2026-10-02T00:00:00.000

10655

Data Question

New York City Police Department (NYPD)

When will the NYPD Hate Crimes dataset be updated to include at least the full year of 2023?

NYPD Hate Crimes

https://data.cityofnewyork.us/d/bqiq-cu78

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

Thank you,
The NYC Open Data Team

Closed

2024-02-29T00:00:00.000

2026-10-02T00:00:00.000

10653

Reported Error

The NYC Open Data Team

Columns 'Submitted Date' and 'C of O Issuance Date' have had all data deleted

DOB NOW: Certificate of Occupancy

https://data.cityofnewyork.us/d/pkdm-hqz6

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

2024-02-28T00:00:00.000

2026-10-02T00:00:00.000

10651

Reported Error

The NYC Open Data Team

Hello. Please provide me with information on how to remove my personal data including where I work and my compensation from a site called tidalforce.org. Having this information so public and readily available puts me and my family in danger. Thank You

https://app.tidalforce.org/nyc/salary/name/shila_b_jones

Thank you for contacting the NYC Open Data Helpdesk.

Payroll records that identify New York City employees by name, public office address, title and salary are public data under New York State’s Freedom of Information Law (FOIL). The New York City Open Data Law requires City Agencies to make their public datasets, such as payroll records for City employees (https://data.cityofnewyork.us/City-Government/Citywide-Payroll-Data-Fiscal-Year-/k397-673e), available on NYC Open Data.

Additionally, datasets on Open Data are published without restrictions on their use, and third-party websites are allowed to access this data and/or share it via their individual platforms.

We hope this information is useful. 

Thank you,
NYC Open Data Team

Closed

2024-02-27T00:00:00.000

2026-10-02T00:00:00.000