NYC Open Data Help Desk: Data Questions and Reported Errors

9868

Data Question

Agency not assigned yet.

Dear NYSDOT:


Hi, this is *****, a ***** researcher, optimizing the bus school system in NYC. I have question concerning the dataset on this webpage:
https://www.dot.ny.gov/divisions/engineering/technical-services/highway-data-services/hdsb.
Especially concerning the Count Statistics Datasets.
I found in the csv files, location information is not provided (segments/stations). Could you please give me a link to download a profile so that I can join/merge and therefore get the locations of those Count Statistics Records?

I will be more than grateful if you could kindly let me know how I can get the data.

Best regards,
*****

No URL Submitted.

This question should be routed to the New York State Open Data. You've reached the New York City Open Data Team. You can contact the New York State Traffic Monitoring Section via MO-TrafficDataViewer@dot.state.ny.us or (518) 457-1965.

Thank you,
NYC Open Data Team

Closed

2023-06-13T00:00:00.000

2026-10-02T00:00:00.000

9863

Data Question

Department of Transportation (DOT)

I was wondering what the coordinates are? and what the_geom is? i was trying to find the latitude and longitude of each open street was

Open Streets Locations

https://data.cityofnewyork.us/d/uiay-nctu

Thank you for your request on Open Streets Locations dataset. The Geom field specifies this dataset is downloadable into a multi-line shapefile (mapping file). Open Streets Locations is block (line) based data, and does not have latitude and longitude data (usually point based).
You may use the NYC Department of City Planning (NYC DCP) Geographic Online Address Translator (GOAT) application to input a street intersection to obtain the latitude and longitude.
NYC DCP GOAT:https://a030-goat.nyc.gov/goat
Thank you,
DOT ODC - Team email address

Closed

2023-06-12T00:00:00.000

2026-10-02T00:00:00.000

9862

Reported Error

Agency not assigned yet.

The link to get the topobathymetric lidar data is broken.

No URL Submitted.

The link you sent directs to New York State GIS data. This is the helpdesk for New York City Open Data. You can contact New York State's GIS Program Office here: https://gis.ny.gov/about-us. Hope this helps!

Thank you,
NYC Open Data Team

Closed

2023-06-12T00:00:00.000

2026-10-02T00:00:00.000

9860

Data Question

Department of Transportation (DOT)

What is the coordinate reference system used by the column WktGeom? Is there any way I can transform it into Latitude and longitude? And is there another dataset for segmentID and Latitude-longitude informations?

Best regards,
Cleon

Automated Traffic Volume Counts

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

Thank you for contacting NYC Open Data regarding Automated Traffic Recorder dataset.
SegmentID are unique IDs assigned to each New York City street block by the NYC Department of City Planning, the information can be found in the LION dataset, and you may use that field to join with the
Automated Traffic Volume Counts dataset.
LION data: https://data.cityofnewyork.us/City-Government/LION...
Well-known text (WKT) represents coordinate reference systems in machine and human readable language. The dataset contains X,Y coordinates. You may also search mapping WktGeom or convert the coordinates from X,Y to Lat, Long using Geographic Information System (GIS) applications. Examples of GIS applications are ESRI ArcGIS, ArcPy or the free open-source platform QGIS, some basic application knowledge is required, see options below:

A) 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...
ESRI community forum (https://community.esri.com/t5/arcgis-api-for-flex-questions/how-to-convert-x-y-to-lat-long/td-p/353854).
To do:
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 new columns in the attribute table (long and 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

B) 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/...
ESRI GIS forum: https://community.esri.com/t5/python-questions/exp...

C) Using QGIS- free to download
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
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. Geometry: AS_XY

Thank you,
DOT ODC - Team email address

Closed

2023-06-12T00:00:00.000

2026-10-02T00:00:00.000

9858

Reported Error

Department of City Planning (DCP)

I've just seen that the boroughs linked (tqmj-j8zm) is rendering a different dataset.

In fact, the Census Tracts dataset (fxpq-c8ku) is rendering the Boroughs 🤔

Hope it helps!
Cheers!

Borough Boundaries

https://data.cityofnewyork.us/d/tqmj-j8zm

Response not sent yet.

Pending

2023-06-12T00:00:00.000

2026-10-02T00:00:00.000

9857

Data Question

Department of Health and Mental Hygiene (DOHMH)

Bringing to your attention challenges a regular person (especially the immune compromised) will have in using the data sets to make well-informed choices.

The data set defaults to ascending. The public may not see that they can select descending to see most recent values.

Using Coney Island as an example, a regular person will not know what these values mean for 3/15/23 -- and if the values are trending higher or lower.

Coney Island | CI | 2,093.00 |
1,070,000.00

Asking that you provide plain-language wording as done in consent for experimental treatment, such as the data suggests that for every 1,000 persons living in this region, 1 to 10 show signs of COVID infection (down or up by x - x from the previous readings)

SARS-CoV-2 concentrations measured in NYC Wastewater

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

Response not sent yet.

Open

2023-06-11T00:00:00.000

2026-10-02T00:00:00.000

9855

Data Question

New York City Police Department (NYPD)

What do the values '1' and '80' mean in the column 'CONTRIBUTING FACTOR VEHICLE 1'

Motor Vehicle Collisions - Crashes

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

Thank you for your question related to the contributing factor information in the collisions dataset. The values '1' and '80' are not valid and considered errors likely due to data entry.

Thank you,
Open Data Team

Closed

2023-06-09T00:00:00.000

2026-10-02T00:00:00.000

9840

Reported Error

Department of City Planning (DCP)

Hi!

This dataset used to indicate which community district an area had but now it is showing a mysterious hurricane parameter. One of our clients is using this dataset and cannot use this anymore.

Could you look into this please?

Thank you!

Community Districts

https://data.cityofnewyork.us/d/yfnk-k7r4

The Department of City Planning (DCP) publishes this dataset to the NYC Open Data porta and we cannot reproduce the error reported. When we go to Community District (https://data.cityofnewyork.us/City-Government/Community-Districts/yfnk-k7r4) page on the NYC Open Data portal it is indeed the NYC Community Districts.

Thank you,
-DCP Open Data Team

Closed

2023-06-06T00:00:00.000

2026-10-02T00:00:00.000

9839

Reported Error

Department of City Planning (DCP)

This appears to have been replaced with a fire districts dataset. this is not borough boundaries

Borough Boundaries

https://data.cityofnewyork.us/d/tqmj-j8zm

Response not sent yet.

Pending

2023-06-05T00:00:00.000

2026-10-02T00:00:00.000

9838

Reported Error

Department of Sanitation (DSNY)

The drop-off hours reported is 11:30am-2pm, which is incorrect. The correct hours are Sundays 12:30pm-2pm.

Food Scrap Drop-Off Locations in NYC (Map)

Response not sent yet.

Pending

2023-06-05T00:00:00.000

2026-10-02T00:00:00.000

9836

Data Question

Department of Health and Mental Hygiene (DOHMH)

When will the data be updated and why is it not being updated on a regular basis?

SARS-CoV-2 concentrations measured in NYC Wastewater

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

Response not sent yet.

Pending

2023-06-03T00:00:00.000

2026-10-02T00:00:00.000

9835

Reported Error

Department of Transportation (DOT)

Hi, the data has a "LINK_POINTS" column that contains a list of pairs of coordinates (latitudes and longitudes) as a string. Unfortunately, the number of characters in the string cannot be more than 255, and not all the coordinates are recorded. How should I access the complete list of coordinates?

DOT Traffic Speeds

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

Response not sent yet.

Pending

2023-06-03T00:00:00.000

2026-10-02T00:00:00.000

9831

Data Question

Department of Health and Mental Hygiene (DOHMH)

It looks like this data set hasn't been updated since 4/26/23. Is there a way to have it updated? Thanks!

DOHMH Childcare Center Inspections (Historical)

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

Response not sent yet.

Pending

2023-06-01T00:00:00.000

2026-10-02T00:00:00.000

9828

Data Question

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

Dear Sir/Madam,

My name is *****, and I am doing research at ***** with Prof. *****, Prof. *****, and Prof. ***** on the impact of socially responsible investors on the energy consumption of properties.
For this research, I have tried to link Local Law 87 energy data to properties owned by REITs.
To my great surprise, there seemed to be almost no overlap between the properties covered in LL87 and the properties owned by REITs.

Would you be able to tell me whether our merge is correct and LL87 does not cover them or whether we made a flaw in the matching?

Warm regards,
*****

LL87 Energy Audit Data

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

Response not sent yet.

Pending

2023-06-01T00:00:00.000

2026-10-02T00:00:00.000

9824

Data Question

New York City Police Department (NYPD)

I'm trying to create a map visualization of this data, but the Socrata team tells me that I cannot do this because there isn't a georeferenced column. I see that latitude and longitude are two different columns, and I think if you created a column that simply had both of them in it, the Socrata visualization tool would work with this dataset. Can you create a georeferenced column so that I can create a map of this data?

NYPD Calls for Service (Historic)

https://data.cityofnewyork.us/d/d6zx-ckhd

The new "Location" column has been added to NYPD Calls for Service (Historic). You should now be able to make a map based off of this dataset. Please let us know if you have any more questions or concerns.

Thank you,
NYC Open Data Team

Closed

2023-05-31T00:00:00.000

2026-10-02T00:00:00.000

9820

Data Question

Department of Buildings (DOB)

Would it be possible to add the boiler address to this list?

DOB NOW: Safety Boiler

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

Response not sent yet.

Pending

2023-05-31T00:00:00.000

2026-10-02T00:00:00.000

9819

Data Question

Department of Citywide Administrative Services (DCAS)

Hello,
I am not on CSM with any agency currenlty. Neither have I received any interview call or the pool call . But my record shows that I am currently with NY Retirement System. Could you please clarify?

https://data.cityofnewyork.us/City-Government/Civil-Service-List-Active-/vx8i-nprf/explore/query/SELECT%0A%20%20%60exam_no%60%2C%0A%20%20%60list_no%60%2C%0A%20%20%60first_name%60%2C%0A%20%20%60mi%60%2C%0A%20%20%60last_name%60%2C%0A%20%20%60adj_fa%60%2C%0A%20%20%60list_title_code%60%2C%0A%20%20%60list_title_desc%60%2C%0A%20%20%60group_no%60%2C%0A%20%20%60list_agency_code%60%2C%0A%20%20%60list_agency_desc%60%2C%0A%20%20%60list_div_code%60%2C%0A%20%20%60published_date%60%2C%0A%20%20%60established_date%60%2C%0A%20%20%60anniversary_date%60%2C%0A%20%20%60extension_date%60%2C%0A%20%20%60veteran_credit%60%2C%0A%20%20%60parent_lgy_credit%60%2C%0A%20%20%60sibling_lgy_credit%60%2C%0A%20%20%60residency_credit%60%0AWHERE%20%60last_name%60%20IN%20%28%22MULABAGAL%22%29/page/filter

1. I am currenlty working with ***** on IT Service Management title. I want to know why I have not received any pool call or an interview call for my CSM listing. 2. My CSM listing shows NYC Employee's retirement system as list agency but, I have never been with that agency. Please help me understand my CSM civil service list status.
Sincerely,
*****

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:
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-05-30T00:00:00.000

2026-10-02T00:00:00.000

9817

Reported Error

Office of Administrative Trials and Hearings (OATH)

OATH Trials dataset missing cases from NYC Dept of Consumer and Worker Protection (distinct from NYC Dept of Consumer Affairs)

OATH Trials Division Case Status

https://data.cityofnewyork.us/d/y3hw-z6bm

Response not sent yet.

Open

2023-05-30T00:00:00.000

2026-10-02T00:00:00.000

9814

Data Question

New York City Police Department (NYPD)

Hi there. Thanks for the great dataset.

Would you please define the "contributing_factor": 'Driver Inattention/Distraction"? I have asked the NYPD but haven't received a response. This is for a ***** data science certification program research project.

Thank you.

Motor Vehicle Collisions - Crashes

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

The National Highway Traffic Safety Administration (NHTSA) definition of distracted driving is any activity that diverts attention from driving, including talking or texting on your phone, eating and drinking, talking to people in your vehicle, fiddling with the stereo, entertainment or navigation system — anything that takes your attention away from the task of safe driving.


Thank you,
The NYC Open Data Team

Closed

2023-05-30T00:00:00.000

2026-10-02T00:00:00.000

9806

Data Question

Department of City Planning (DCP)

To Whom It May Concern -

I'm wondering if you have the updated numbers (2020) for this dataset. I'm also wondering if you have a dataset that shows which zip codes and Census Tracts are in each NYC City Council district.

Thank you for your help.

Census Demographics at the NYC City Council district (CNCLD) level

https://data.cityofnewyork.us/d/ye4r-qpmp

in several resources but we do not have a direct update to the Census Demographics by NYC City Council profile that was created for 2010.
1. NYC 2020 decennial census table available for download (use the GeoType field to filter by preferred geography like city council district)
2. NYC Population Fact Finder application: tool that allows users to easily create study areas, or choose a pre-defined geography (like a Community District), and examine associated population data showing the latest demographic, social, economic, and housing characteristics, and how these characteristics have changed over time.
3. Census Tract, NYC City Council*, and Zip Codes are not aligned and all overlap one another so there is not a table that lists how they relate to one another. If you have GIS capabilities, you could download each shapefile individually and spatially join them. Use the download links to each on NYC Open Data above and export to shapefile.
*Note: the NYC City Council district listed above is the redistricted version for the upcoming NYC City Council elections in 2023 and will become the official NYC City Council districts in 2024. If you want a version of the current City Council districts that are still in effect until 12/31/2023 please download the 22C version from City Planning archive here (Filter by Dataset = Administrative and Political Districts, select Administrative and Political Districts - City Council Districts (Clipped to Shoreline), version 22C)

Thank you,
-DCP Open Data Team

Closed

2023-05-25T00:00:00.000

2026-10-02T00:00:00.000

9802

Data Question

Department of Citywide Administrative Services (DCAS)

Data is unsearchable on mobile devices. With so much data what good is it if it can not be searched. Anyone accountable for that?

Civil Service List (Active)

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

Hi Thomas collado,

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,
NYC Open Data Team

Closed

2023-05-23T00:00:00.000

2026-10-02T00:00:00.000

9798

Reported Error

Department of Finance (DOF)

There appear to be duplicates in the data. Refer to PARID 1018461501 for tax year 2024.

Property Exemption Detail

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

Response not sent yet.

Open

2023-05-22T00:00:00.000

2026-10-02T00:00:00.000

9795

Reported Error

Taxi and Limousine Commission (TLC)

Hi,
I am from ***** opening a ticket on behalf of our client *****. They are having issues using open data https://data.cityofnewyork.us/Transportation/For-Hire-Vehicles-FHV-Active/8wbx-tsch/data
when entering plate data nothing is showing up no matter what plate data is entered. For example, Searching for ***** is not showing any data. User also mentioned on phone worked this morning, but even on the phone it is now no longer working. Is the system down on your guys end? Please let me know so I may pass it along to our client. Have a great day!!

Thanks, *****

For Hire Vehicles (FHV) - Active

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

Response not sent yet.

Pending

2023-05-19T00:00:00.000

2026-10-02T00:00:00.000

9794

Reported Error

Agency not assigned yet.

RE
*****
I am confused. The permit issued has been changed to pending. I gather my electrician, *****, was issued a permit. The name on the permit was *****. This is incorrect, as my name is *****, shareholder of co-op apartment ***** at *****. I would appreciate your attention to this matter.

No URL Submitted.

Response not sent yet.

Pending

2023-05-19T00:00:00.000

2026-10-02T00:00:00.000

9793

Data Question

311

I am a professor at Stony Brook, my students tried to download the dataset "311 Service Requests from 2010 to Present" but failed. The dataset seems to be too large. And the web query interface is too slow. Is there some way that we can download it in multiple separate files? Is there any way that we can have access to the dataset? Thanks!

311 Service Requests from 2020 to Present

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

Thanks for contacting the NYC Open Data HelpDesk! To clarify, are you using the new "explore" query tool or the "grid view?" You can tell by looking at the difference in the URLs:
- Main Landing Page/Primer Page: https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9
- Explore View:https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9/explore...
- Grid View: https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9/data
The explore view packs a lot more functionality than the grid view and can take longer to load with larger datasets. We recommend trying with the grid view to download smaller, more manageable versions of the data. You can use this guide to help with filtering on the portal: Creating a Filtered View – Data & Insights Client Center (socrata.com).
Hope this helps! Feel free to reach back out to us with any more questions/concerns.

Thank you,
NYC Open Data Team

Closed

2023-05-19T00:00:00.000

2026-10-02T00:00:00.000

9791

Reported Error

Agency not assigned yet.

*****
My correct name is *****.
The incorrect name on the permit is *****.
-------------------------------------------------------
Edited Response:
*****
I'd like to cancel this error-correction request. I don't know what my 'Dataset URL' is.
Please disregard my initial request concerning a mistake on the permit. It seems that the electrician's boss, *****, submitted the request for this permit. I wasn't familiar with his name. So, I was alarmed.
My name is *****. I have no experience with applying for permits from DOB. Sorry for the misunderstanding.

No URL Submitted.

Thank you for clarifying, here. We will close out this request. Just so you know, there are many datasets on the Open Data portal that deal with this topic. A few of them are listed here: https://data.cityofnewyork.us/browse?q=dob+permits. You can find out more about NYC Open Data and how to use it by viewing our "How-To" page: https://opendata.cityofnewyork.us/how-to/. Should you have any more questions about Open Data or want to learn more, you can sign up for a class (as soon as the dates are released) here: https://opendata.cityofnewyork.us/learn-open-data/. Hope this helps!

Thank you,
NYC Open Data Team

Closed

2023-05-17T00:00:00.000

2026-10-02T00:00:00.000

9789

Reported Error

Agency not assigned yet.

The page is not found when we try and download the Topobathymetric LiDAR Data (2017)

No URL Submitted.

Thank you for contacting the New York City Open Data HelpDesk. The link you provided is from New York State. Please contact them directly here: https://gis.ny.gov/about-us. Hope this helps!

Thank you,
NYC Open Data Team

Closed

2023-05-17T00:00:00.000

2026-10-02T00:00:00.000

9788

Data Question

Agency not assigned yet.

Hello I'm trying to get a understanding of this list on open data. As i requested to be put back on the list for my exam 7604 list number 4834, I received an email that my requested was granted to be added back on the list 03/26/2023, following me missing my medical hold I answered back too late. My main question is, My certification date is not saying 3/26/2023 or no official date has been given to me as yet?

No URL Submitted.

Response not sent yet.

Pending

2023-05-15T00:00:00.000

2026-10-02T00:00:00.000

9783

Reported Error

Department of Buildings (DOB)

There appear to be a lot of duplicate Job #s within the data and many are missing doc 01. E.g. Job # 101384459.

DOB Job Application Filings

https://data.cityofnewyork.us/d/ic3t-wcy2

Response not sent yet.

Open

2023-05-13T00:00:00.000

2026-10-02T00:00:00.000

9781

Data Question

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

What does the fiscal year column mean? Does fiscal year 2021 mean the person received the money between 1/1/21 and 12/31/21? Why doesn't this data square with documents I've obtained through FOIL?

Citywide Payroll Data (Fiscal Year)

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

The fiscal year as used in the Citywide Payroll Data dataset is measured from July 1st to June 30th.

Thank you,
NYC Financial Information Services Agency & Office of Payroll Administration (FISA-OPA)

Closed

2023-05-11T00:00:00.000

2026-10-02T00:00:00.000

9779

Data Question

New York City Tax Commission (TAXCOMM)

The last time this was updated was in 2020. Is there something I have to do to push an update? Please help.

Assessment Actions

https://data.cityofnewyork.us/d/4nft-bihw

Response not sent yet.

Open

2023-05-11T00:00:00.000

2026-10-02T00:00:00.000

9778

Data Question

Department of Consumer and Worker Protection (DCWP)

Why are some tobacco retailers missing a census track value?

Active Tobacco Retail Dealer Licenses

https://data.cityofnewyork.us/d/adw8-wvxb

Response not sent yet.

Pending

2023-05-11T00:00:00.000

2026-10-02T00:00:00.000

9777

Data Question

Department of Transportation (DOT)

what formula dictates the values of sign_x_coord and sign_y_coord? I am interested in converting these values to long/lat coordinates.

Street Sign Work Orders

https://data.cityofnewyork.us/d/qt6m-xctn

Thank you for your inquiry. Unfortunately, the Street Sign Work Order dataset does not provide latitude (lat) and longitude (long) information, only in X,Y.
New York City Department of Transportation (NYC DOT) maintains a website for all Street Signs mapped, please visit: https://nycdotsigns.net/.

You may also use Geographic Information System (GIS) applications such as ESRI ArcGIS or the free open-source platform QGIS to process X,Y conversions to Lat, Long, some basic application knowledge is required, see information below:

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

To do:
1. Load the data into the application as a CSV, add new columns in the attribute table (long and lat).
2. 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) Using QGIS- free to download
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
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. Geometry: AS_XY

Thank you,
DOT ODC - Team email address

Closed

2023-05-10T00:00:00.000

2026-10-02T00:00:00.000

9773

Reported Error

Department of City Planning (DCP)

The NYC zoning datasets were mixed up again in a recent update. Zoning districts shows commercial overlays. All should be checked. This is at least the third time this has happened in about a year.

Zoning GIS Data: Shapefile

https://data.cityofnewyork.us/d/kdig-pewd

I'm sorry you keep running into issues with the links you reported. The Department of City Planning (DCP) does not directly publish to the NYC Open Data portal and did not intend for the individual zoning file pages to be on the portal. The official zoning data can be accessed via the following pages on open data portal:
Georeferenced NYC Zoning Maps
Zoning GIS Data: Shapefile
Zoning GIS Data: Geodatabase
You can also access the NYC GIS Zoning files directly form City Planning's open data page.
If you are looking to connect to the individual files like zoning districts, commercial overlay, etc please see the REST or GeoJSON services on our download page listed above. We are working with the NYC Open Data team to remove the links you have been having issues with. If you have any other questions related to NYC Department of City Planning datasets please contact us directly via DCPopendata@planning.nyc.gov.
Thank you,
-DCP Open Data Team

Closed

2023-05-09T00:00:00.000

2026-10-02T00:00:00.000

9772

Data Question

Office of Administrative Trials and Hearings (OATH)

This dataset pulls into the website below
idling.nyc/check.html
Who submits this data to NYC Open Data and how often do they update the data set?

OATH Hearings Division Case Status

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

Response not sent yet.

Open

2023-05-09T00:00:00.000

2026-10-02T00:00:00.000

9771

Data Question

Department of Buildings (DOB)

Data was last updated Dec 8, 2022. Is that correct?
Thanks.

DOB NOW: Build – Limited Alteration Applications

https://data.cityofnewyork.us/d/xxbr-ypig

Response not sent yet.

Pending

2023-05-08T00:00:00.000

2026-10-02T00:00:00.000

9769

Data Question

311

I exported the 311 SRs for 1-31 March 2023. I was looking at the field "Open Data Channel Type". The data dictionary indicates this field captures "how the service request was submitted to 311". My understanding was that the only methods to submit an SR to 311 was via the web app, the mobile app, via a 311 phone call, or from another City agency.

However, the Mar 2023 data indicates only 43 "other" (0.02%) but a large number of "Unknown" (20,072: ~9%). How can such a large number of SRs come from an "Unknown" source. I would think the source would be automatically provided during the "submit" process. Thanks.

BTW...here are the counts for Open Data Channel Type for Mar 2023:
Open Data Channel Type Count Percentage
UNKNOWN 20,072 8.92%
MOBILE 41,231 18.33%
ONLINE 100,682 44.76%
PHONE 62,928 27.97%
OTHER 43 0.02%

Thank you. So glad this data is available. Very rare for a city. Thx

311 Service Requests from 2020 to Present

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

We appreciate your interest in Open Data and thank you for pointing this out! Some of these "UNKNOWN" requests likely come from other City reporting systems that feed into 311 but do not contain the "Channel Type" data shown here. We will look into this discrepancy and see if we can clarify it in the data or provide more context on it in the data dictionary.

Thank you,
NYC Open Data Team

Closed

2023-05-06T00:00:00.000

2026-10-02T00:00:00.000

9768

Reported Error

Taxi and Limousine Commission (TLC)

This is what comes up instead of the TLC Authorized Wheelchair Passenger Assistance Training Provider "Page Not Found
We're really sorry, but the page you requested cannot be found.
The page either does not exist or has moved. We think the best thing to do is start again from the home page. Feel free to contact us if the problem persists or if you definitely can’t find what you are looking for. Thank you."

TLC Authorized Wheelchair Passenger Assistance Training Provider (Map)

Response not sent yet.

Pending

2023-05-06T00:00:00.000

2026-10-02T00:00:00.000

9767

Reported Error

New York City Police Department (NYPD)

I messaged a bit earlier, but I pasted the wrong URL link. But here is the original message for the new link: NYPD Complaint Data Current (Year To Date) has very low 2022 complaint counts. It went from 37k in Dec 2021 to 222 in Jan 2022. It remains low for most of the year. May you explain why that is?

NYPD Complaint Data Current (Year To Date)

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

The issue may be related to the recent data update. The YTD Complaint data was refreshed for for 2023. The 2022 data is now included in the Historic Complaint dataset found here:
NYPD Complaint Data Historic | NYC Open Data (cityofnewyork.us)
When exploring this Historic dataset using the RPT_DT field, the issue you describe is NOT present.


Thank you,
The Open Data team

Closed

2023-05-05T00:00:00.000

2026-10-02T00:00:00.000

9766

Reported Error

New York City Police Department (NYPD)

NYPD Complaint Data Current (Year To Date) has very low 2022 complaint counts. It went from 37k in Dec 2021 to 222 in Jan 2022. It remains low for most of the year. May you explain why that is?

NYPD Complaint Data Historic

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

Response not sent yet.

Closed

2023-05-05T00:00:00.000

2026-10-02T00:00:00.000

9751

Reported Error

New York City Police Department (NYPD)

In this dataframe, there are a number of incidents that appear to be erroneously coded as "MURDER & NON-NEGL. MANSLAUGHTER." As a result, the dataframe indicates that there were 588 "MURDER & NON-NEGL. MANSLAUGHTER." incidents in 2022. In actuality, per other NYPD data, the figure should be closer to 440. For example, on on May 4, 2022, this dataframe says that there were 12 murders committed in one location (Video Store, -73.993500, 40.754692) at same time.

NYPD Complaint Data Current (Year To Date)

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

Response not sent yet.

Pending

2023-05-03T00:00:00.000

2026-10-02T00:00:00.000

9744

Reported Error

Department of Parks and Recreation (PARKS)

It appears that the latitude and longitude values are not in the correct UTM form. I have tried converting them to latitude and longitude with no success.

Cool It! NYC 2020 - Cooling Sites

https://data.cityofnewyork.us/d/h2bn-gu9k

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

Thank you,
NYC Department of Parks and Recreation

Closed

2023-05-01T00:00:00.000

2026-10-02T00:00:00.000

9743

Data Question

Department of Buildings (DOB)

Should this data set have Borough, Block and Lot columns?

DOB NOW: Build – Limited Alteration Applications

https://data.cityofnewyork.us/d/xxbr-ypig

Response not sent yet.

Pending

2023-05-01T00:00:00.000

2026-10-02T00:00:00.000

9742

Data Question

Department of Buildings (DOB)

Can the "Job Description" be added to this data set?
Thanks.

DOB NOW: Build – Job Application Filings

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

Response not sent yet.

Pending

2023-05-01T00:00:00.000

2026-10-02T00:00:00.000

9741

Data Question

Department of Buildings (DOB)

Can the LOC issued/status date be added to the data set? E.g. Job #B00000280 LOC Issued 11/6/2020 as per DOB NOW.

DOB NOW: Build – Job Application Filings

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

Response not sent yet.

Pending

2023-05-01T00:00:00.000

2026-10-02T00:00:00.000

9740

Data Question

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

In the column 'Title Description', some titles have this next to their job titles: 'AL 1 ONLY 40 HR'. I would love to understand what this means. This is for a deadline story, so a timely response is much appreciated. Thank you.

Citywide Payroll Data (Fiscal Year)

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

Response not sent yet.

Pending

2023-05-01T00:00:00.000

2026-10-02T00:00:00.000

9736

Data Question

Agency not assigned yet.

Hello,

Is there one of the datasets that include police action by the former Cabaret unit, and if so, could you please direct me as to how to find it? Otherwise, is it possible to have get access to such dataset?

No URL Submitted.

The information you are looking for is not maintained by NYC Open Data. We encourage you to submit a FOIL request via Open Records: https://a860-openrecords.nyc.gov/

FOIL stands for the Freedom of Information Law. The New York State Freedom of Information Law requires government agencies to provide records to the public upon request. Government records affect the lives of each New Yorker, and providing easy access to the records makes government work better. The FOIL definition of records is very broad and includes information found in paper and electronic documents and audio and visual recordings. All records are available upon request, unless an exception in FOIL permits an agency to deny access to a record. Learn more about FOIL requests via this Frequently Asked Questions page.

Thank you,
The NYC Open Data Team

Closed

2023-04-28T00:00:00.000

2026-10-02T00:00:00.000

9734

Data Question

Mayor's Office of Management and Budget (OMB)

Hello,

Thank you very much for your response to my inquiry. Is there any way to determine which of the expenditures are liquidations and which are accruals?
As you note, per Checkbook, the City has spent $30.95M on FMS CT107120211408132. However, if you total the expenditures associated with the same contract on the COVID-19 Expenditures Report data, it adds up to 69,820,190.09. Is there any context you can provide for this discrepancy?

Thank you,
Jamison
-----
Hello,

I have a few questions about the COVID-19 Expenditures Report dataset. I have been cross-referencing the dataset with NYC Checkbook (the database published by the NYC Comptroller), and have noticed some considerable discrepancies. For example, if you look up FMS Contract ID CT107120211408132 on both datasets, the total expenditures vary considerably. Can you please provide some additional context on what "expenditures" means in the context of this dataset and whether it's comparable to NYC Checkbook?

In addition, would it be possible to provide an explanation of negative expenditure amounts -- I've seen a number of examples where there will be two identical expenditure amounts, but one will be negative and the other will be positive.

Thanks very much for your help. Happy to discuss over email (*****) or phone (*****).

Best,
*****

COVID-19 Expenditures Report (Historical)

https://data.cityofnewyork.us/d/thut-5mdg

Thank you for your inquiry. The COVID-19 Expenditures Report available on Open Data includes expenditures resulting from the City’s response to COVID-19. Expenditures include both liquidations and accruals.

NYC Checkbook is managed by a different office, and we can’t speak to their dataset. We looked into your contract example (FMS CT107120211408132), and the City has spent $30.95M through March 2023.

Thank you,
NYC Office of Management and Budget

Closed

2023-04-27T00:00:00.000

2026-10-02T00:00:00.000

9732

Data Question

Department of Transportation (DOT)

I exported the csv file from the dataset URL and see the x and y coordinates for each of the raised crosswalks, is there any way I can get the Latitude and Longitude for these points to map them either in google maps or google earth?

Raised Crosswalk Locations

https://data.cityofnewyork.us/d/uh2s-ftgh

Thank you for your inquiry. The Raised Crosswalk Locations data provides only X and Y coordinates. You may use a Geographic Information System (GIS) applications such as ESRI ArcGIS or the free open-source platform QGIS to process X,Y conversion to Latitude (lat), Longitude (long). Some basic GIS application knowledge is required, see information below:

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

To do:
1. Load the data into the application as a CSV, add new columns in the attribute table (long and lat).
2. 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) Using QGIS- free to download
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
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. Geometry: AS_XY

Thank you,
NYC Department of Transportation

Closed

2023-04-26T00:00:00.000

2026-10-02T00:00:00.000

9731

Data Question

Department of City Planning (DCP)

Dear,

What is the spatial reference system used for the coordinates?

Best regards,
*****

2020 Neighborhood Tabulation Areas (NTAs)

https://data.cityofnewyork.us/d/9nt8-h7nd

You can see all of the spatial reference information in the datasets metadata. We copied it below.

Coordinate system:
- Type: Projected
- Geographic coordinate reference: GCS_North_American_1983
- Projection: NAD_1983_StatePlane_New_York_Long_Island_FIPS_3104_Feet
- Coordinate System Identifier: 2263


Thank you,
-DCP Open Data Team

Closed

2023-04-26T00:00:00.000

2026-10-02T00:00:00.000