NYC Open Data Help Desk: Data Questions and Reported Errors

8853

Data Question

Agency not assigned yet.

Your excellent NYC tree data - is the dbh field in INCHES or in CM? Thank you.

No URL Submitted.

Thanks for your interest in NYC Open Data! In the "2015 Street Tree Census - Tree Data" dataset (https://data.cityofnewyork.us/Environment/2015-Str...), the dbh field is measured in inches. For future reference, you can check the dataset's data dictionary for information like this.
For example, on this dataset, you can click the "About" button and scroll down to where it says "Attachments." There should be a file named "StreetTreeCensus2015TreesDataDictionary20161102.pdf." That document contains all there is to know about this dataset.
Hope this helps!

Thank you,
- NYC Open Data Team

Pending

2022-06-22T00:00:00.000

2026-10-02T00:00:00.000

8852

Data Question

Department of Health and Mental Hygiene (DOHMH)

When will this dataset be next updated? Thank you!

SARS-CoV-2 concentrations measured in NYC Wastewater

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

Response not sent yet.

Pending

2022-06-22T00:00:00.000

2026-10-02T00:00:00.000

8845

Reported Error

Department of Transportation (DOT)

On multiple days, including 9/22/19, there are two entries for Columbia St in Brooklyn for SB count at the 0 hour. That is not possible. If you are counting the vehicles at a location in a direction at a specific time, that is one specific value, not two.

No URL Submitted.

Apologies for the delay, thank you for bringing the Automated Traffic Counts errors, including duplicate rows to our attention. The dataset has now been updated with the latest available information.
https://data.cityofnewyork.us/Transportation/Autom...

Thank you,
NYC Department of Transportation, NYC Open Data Team

Closed

2022-06-20T00:00:00.000

2026-10-02T00:00:00.000

8840

Reported Error

New York City Police Department (NYPD)

The data now contains cells with a value of "(null)", rather than actual null values in various columns such as CMPLNT_TO_TM and HADEVELOPT.

So https://data.cityofnewyork.us/resource/5uac-w243.json?$where=cmplnt_to_tm%20is%20not%20null has matches, https://data.cityofnewyork.us/resource/5uac-w243.json?$where=cmplnt_to_tm%20is%20null has no matches, and https://data.cityofnewyork.us/resource/5uac-w243.json?$where=cmplnt_to_tm=%22(null)%22 has matches.

NYPD Complaint Data Current (Year To Date)

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

Thank you for contacting the NYC Open Data help desk. The solution would be to use the value "(null)" in your filters.


Here’s the last message that was sent on <DD/MM/YYYY>:

Thank you,
The NYC Open Data Team

Closed

2022-06-17T00:00:00.000

2026-10-02T00:00:00.000

8837

Reported Error

Department of Buildings (DOB)

Hello,
Can this dataset please be updated?
Thanks!

DOB NOW: Build – Approved Permits

https://data.cityofnewyork.us/d/rbx6-tga4

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

Thank you,
- NYC Open Data Team

Closed

2022-06-15T00:00:00.000

2026-10-02T00:00:00.000

8836

Reported Error

Agency not assigned yet.

Hello,

Hope this finds you well. I just wanted to log a ticket that the Motor Vehicle Collisions - Vehicles data set has not been updated in a few months, where as the Person and Crashes data is up to date.

Thank you.

No URL Submitted.

Response not sent yet.

Pending

2022-06-15T00:00:00.000

2026-10-02T00:00:00.000

8832

Reported Error

Agency not assigned yet.

Hi,
My name is *****.
Can you please delete my records? It's already an inactive business, some information is wrong already.
I had just applied for this pedicab license. I didn't even use it. Can you delete this records?

Thank you,
*****

No URL Submitted.

Your report was forwarded to the Department of Consumer and Worker Protection (DCWP) for review.

Applying for a DCWP-issued license is a matter of public record and that record is covered by NYC’s Open Data law. Consistent with DCWP’s Personally Identifying Information (PII) policy, other than name, and the City, State, and ZIP Code of the mailing address we do not publish any information regarding an individual’s contact information or address.

Thank you,
- NYC DCWP Open Data

Closed

2022-06-14T00:00:00.000

2026-10-02T00:00:00.000

8824

Data Question

Department of Citywide Administrative Services (DCAS)

Trying to get a update on DCAS Civil Service List Certification. Last update was June 3, 2022
Looking for an update on exam I have taken last year.

Civil Service List Certification

https://data.cityofnewyork.us/d/a9md-ynri

I’m responding to your inquiry submitted through the Open Data website.

The Civil Service Certification dataset is up-to-date and is updated whenever new list certifications are issued.

Please also log in to OASys to see the status of any exams you have taken.

Closed

2022-06-13T00:00:00.000

2026-10-02T00:00:00.000

8818

Reported Error

Department of Buildings (DOB)

I think the DOB Now job application dataset is missing owner information. The only columns labelled owner (Owner's Business Name and Owner's Street Name) actually relate to the Applicant, not to Owner.

The old system DOB job application filing dataset includes owner information.

Could this be corrected?

DOB NOW: Build – Job Application Filings

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

Response not sent yet.

Pending

2022-06-09T00:00:00.000

2026-10-02T00:00:00.000

8813

Reported Error

Department of Buildings (DOB)

Hello again,

Thanks for getting back to me on my previous questions about the DOB NOW: Build Job Application Filings data set. I still have one outstanding question that I hope you help clarify:

1. From approximately 150 DOB NOW job filings that I was researching, almost 50% were missing (including General Construction, Plumbing, Mechanical Systems and Boiler jobs). How can I get the pertinent information for any job filings missing from that data set?

Your continued help is much appreciated!

DOB NOW: Build – Job Application Filings

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

Response not sent yet.

Pending

2022-06-08T00:00:00.000

2026-10-02T00:00:00.000

8812

Data Question

New York City Police Department (NYPD)

Wat would be the most efficient way to add this tabular data to ArcGIS Pro as a spatial dataset? Is there a way for NYC Open Data to create/add links to data in a ArcGIS feature layer?

Motor Vehicle Collisions - Crashes

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

The collision dataset includes columns for Latitude and Longitude. You can download the dataset as a CSV and load it into your ArcGIS Pro project. Once loaded, you can use the Display XY data tool create and ESRI feature class and display them in a map.

Thank you,
- NYC Open Data Team

Closed

2022-06-08T00:00:00.000

2026-10-02T00:00:00.000

8811

Reported Error

Department of Parks and Recreation (PARKS)

The coordinates in the geometry/shape column doesn't match the WGS84 system. I noticed this dataset is just updated today. Is there an older version to access the parks trails layer?

Parks Trails

https://data.cityofnewyork.us/d/vjbm-hsyr

Thank you for your patience. We are working on this and hope to have the updated dataset up by this Friday 2/17.

Thank you,
- NYC PARKS Open Data

Closed

2022-06-07T00:00:00.000

2026-10-02T00:00:00.000

8809

Reported Error

Department of Buildings (DOB)

Hi there,

Thanks for getting back to me on the DOB NOW: Build Job Application Filings data dictionary. I look forward to your updates. However, I still have two outstanding questions that I hope you help clarify:

1. Why is the "Current Status Date" in this data set is often not in line with the "Modified Date" in DOB NOW's interface, sometimes by weeks or months?

2. From approximately 150 DOB NOW job filings that I was researching, almost 50% were missing. Do you know why so many jobs are missing from this data set? FYI these were not electrical, LAAs or elevator jobs. These included General Construction, Plumbing, Mechanical Systems and Boilers.

Your continued help is much appreciated!

DOB NOW: Build – Job Application Filings

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

I can tell you that a modification and modified date do not necessarily mean a change in status or status date. These data points are sent over by IT transfer, so any record discrepancy is not going to be apparent without further investigation.

Thank you,
- NYC Open Data Team

Pending

2022-06-06T00:00:00.000

2026-10-02T00:00:00.000

8808

Reported Error

Department of Buildings (DOB)

It looks like this dataset hasn't been updated in over a month and there should be a daily update.

Is there a different url for this dataset or is something technically wrong?

Thank you

DOB NOW: Build – Approved Permits

https://data.cityofnewyork.us/d/rbx6-tga4

IT is aware and investigating this.

Thank you,
- NYC Open Data Team

Pending

2022-06-06T00:00:00.000

2026-10-02T00:00:00.000

8807

Data Question

New York City Police Department (NYPD)

Do you know when we can expect the Q1 2022 update of the NYPD Complain Data (Year To Date) dataset? Based on the previous update date I was expecting this data to be shared last month. Thanks!

NYPD Complaint Data Current (Year To Date)

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

Our apologies for the delay. The complaint dataset has been updated. The latest updates includes data through May 31, 2022.

Thank you,
- NYC Open Data Team

Closed

2022-06-06T00:00:00.000

2026-10-02T00:00:00.000

8803

Reported Error

Agency not assigned yet.

It states that the count is for Columbia St in Brooklyn from Kane St. to Irving St. There is no Irving St. in Brooklyn and there is no intersection Columbia St & Irving St. Columbia St. does not intersect Bush St. or Center Mall. This data is completely inaccurate. It lists places that don't exist.

No URL Submitted.

Thank you for bringing this issue to our attention for Automated Traffic Volume Counts. The street names are based off of LION data, and Irving Street was in LION prior to 2018. The location of the counter is in front 144 Columbia Street, Brooklyn 11231.

Thank you,
- NYC DOT Open Data Team

Closed

2022-06-04T00:00:00.000

2026-10-02T00:00:00.000

8801

Reported Error

Office of Technology and Innovation (OTI)

When the building footprint polygons are downloaded as a shapefile, the polygons are incorrect. Rather than being a footprint, the polygons appear to be rectangles oriented to the x/y axis (I can provide a screenshot of this if necessary).

Just a guess, but this could be related to a spatial index, as spatial indexes use simple rectangles similar to the ones I'm seeing.

Thanks for the help!

*****
Spatial Database Engineer
*****
*****

Building Footprints (Deprecated)

https://data.cityofnewyork.us/d/nqwf-w8eh

 To answer your question, the best way to download Building Footprints is to choose “Original” from the Export options. This will generate a shapefile that is exported weekly for OpenData. The “Shapefile” option will create a shapefile for export on demand. We have experienced issues with this output shapefile in the past so we recommend using Original.

Thank you,
-NYC Open Data Team

Closed

2022-06-03T00:00:00.000

2026-10-02T00:00:00.000

8800

Reported Error

Department of Buildings (DOB)

This site has not been updated since May 3,2022 and needs to be updated daily. Please advise

DOB NOW: Build – Approved Permits

https://data.cityofnewyork.us/d/rbx6-tga4

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

Thank you,
- NYC Open Data Team

Pending

2022-06-03T00:00:00.000

2026-10-02T00:00:00.000

8799

Data Question

Agency not assigned yet.

HI. I have filtered this dataset how i want it and are trying to plot the data in google maps, but the coordinate system EPSG:2263 does not work in google maps. I then tried to use your own visualizations, but this too needs lat long. I used a Javascript to convert them but then it needs to be imbedded in a site for the java to run and I don't want that just a simple kml

No URL Submitted.

Thank you for your inquiry. Unfortunately, the Street Sign Work Orders system does not provide latitude (lat) and longitude (long) information, only X,Y. A possible solution is to use Geographic Information System (GIS) applications such as ESRI ArcGIS or the free open-source platform QGIS to process the conversions, some basic application knowledge is required, see information below:
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-data/tables/calculating-area-length-and-other-geometric-properties.htm
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

Using QGIS- free to download

More information from this blog: https://www.gisoutlook.com/2020/05/coordinate-conversion-process-in-qgis.html

To do:
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. Geometry: AS_XY
Thank you,
- NYC DOT Open Data Team

Closed

2022-06-03T00:00:00.000

2026-10-02T00:00:00.000

8797

Data Question

Mayor's Office of Media and Entertainment (MOME)

NYC Media list.

We want to add our NYC television networks to the data set For ethnic media list. Please get back to me on how to submit.

Thank you,

Citywide Marketing Directory

https://data.cityofnewyork.us/d/gc4z-q69i

Thanks for your interest in NYC Open Data! Any requests to be added to the directory can be submitted through the Mayor's Office of Ethnic & Community Media (MOECM)'s contact form (https://nyc-csg-web.csc.nycnet/site/ethnicmedia/contact/contact.page). Hope this helps!

Thank you,
- NYC Open Data Team

Closed

2022-06-01T00:00:00.000

2026-10-02T00:00:00.000

8796

Reported Error

Agency not assigned yet.

On site, my property is listed as a business under *****. It's a residential 2 family house under ***** as written under ACRIS. Ive been denied city services because of this. Please correct or advise how to ensure all agencies report the same information.

No URL Submitted.

Response not sent yet.

Pending

2022-06-01T00:00:00.000

2026-10-02T00:00:00.000

8792

Data Question

New York City Police Department (NYPD)

One of the columns you have in this dataset is called KY_CD, which appears to be a less granular category of PD_CD. You do have a dictionary of the PD_CD codes, but I don't see one for the KY_CD codes. Where can I find out what each KY_CD code represents?

Thanks,
*****

NYPD Complaint Data Current (Year To Date)

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

The OFNS_DESC field is the explanation for the KY_CD column. Similarly, the PD_DESC explains the PD_CD field.


Thank you,
- NYC Open Data Team

Closed

2022-05-31T00:00:00.000

2026-10-02T00:00:00.000

8785

Data Question

Department of Buildings (DOB)

Is there a simple way to filter this dataset to show only the job applications that are currently active/pending and have not yet been permitted?

DOB Job Application Filings

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

Filters are available as a tab above the data once you click to view the data.

Thank you,
- NYC Open Data Team

Pending

2022-05-28T00:00:00.000

2026-10-02T00:00:00.000

8782

Reported Error

Agency not assigned yet.

We are noticing a huge anomaly in crime data for October 2020

No URL Submitted.

Can you please provide additional information?

Thank you,
- NYC Open Data Team

Pending

2022-05-27T00:00:00.000

2026-10-02T00:00:00.000

8781

Reported Error

Department of Buildings (DOB)

Hi there,

The data dictionary for the DOB NOW: Build Job Application Filings data set does not include descriptions for all of the columns in that data set. I am particularly interested in the description for "Current Status Date", which occasionally aligns with the "Modified Date" in DOB NOW, but is often off by weeks or months (at least for the subset of projects we're looking into). In addition, I wasn't able to find about half of the DOB NOW job filings that I needed in this data set.

Your help would be much appreciated in helping us understand these issues better, as we would like to be able to rely on this data set to better track DOB jobs for our agency's housing production pipeline.

Thank you in advance.

*****

DOB NOW: Build – Job Application Filings

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

Response not sent yet.

Pending

2022-05-27T00:00:00.000

2026-10-02T00:00:00.000

8779

Data Question

Department of Finance (DOF)

This dataset no longer has recently rolling month sold properties, it seems that the most recent reported sold month is February 2022. Is there a new dataset for this current rolling month and year?

NYC Citywide Rolling Calendar Sales

https://data.cityofnewyork.us/d/usep-8jbt

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

Thank you,
NYC Department of Finance

Closed

2022-05-26T00:00:00.000

2026-10-02T00:00:00.000

8775

Data Question

Agency not assigned yet.

Hello, I have an Open Data account, but am forbidden from viewing Real Estate datasets. May I view them?
Thank you
*****

No URL Submitted.

Response not sent yet.

Closed

2022-05-25T00:00:00.000

2026-10-02T00:00:00.000

8774

Data Question

Department of Finance (DOF)

When should the FY2023 Final Property Assessment Data be added to open data?
Thanks!

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

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

Thank you for bringing this to our attention and for your patience as we gathered your answer. Technical difficulties have prevented the city from loading updates to this dataset. Please visit www.nyc.gov/assessments for the property tax assessment data files.

Thank you,
NYC Department of Finance

Closed

2022-05-25T00:00:00.000

2026-10-02T00:00:00.000

8772

Reported Error

Department of Consumer and Worker Protection (DCWP)

Hi,
I have searched my name on google and it came up with associating with Pedicab driver. First of all, i would like to remove my identity from this service. I am not authorizing to share any my personal info online. I am not a pedicab driver. Please remove my name from your database, I am not allowing to share any my personal info publicly.

Issued Licenses

https://data.cityofnewyork.us/d/w7w3-xahh

The New York City Open Data Law requires City Agencies to make their public datasets, such as NYC Business Licenses, available on NYC Open Data. Note that any public datasets, like this one, include archived data - such as a now-expired license.

We hope this information is useful. Thank you for your question.

Thank you,
- NYC Open Data Team

Closed

2022-05-24T00:00:00.000

2026-10-02T00:00:00.000

8771

Reported Error

Agency not assigned yet.

Seven day and twenty-eight day averages are being calculated incorrectly. You can’t have day over day the number of hospitalizations go up and have the seven day average remain lower then the twenty-eight day average. Also, on some of the graphs the y-axis needs to be updated because you are going off the chart

No URL Submitted.

Response not sent yet.

Pending

2022-05-24T00:00:00.000

2026-10-02T00:00:00.000

8769

Data Question

New York City Police Department (NYPD)

I wanted to ask when this dataset would be updated? Looks like it only has data up to the end of 2021.

NYPD Calls for Service (Year to Date)

https://data.cityofnewyork.us/d/n2zq-pubd

Our apologies for the delay. The calls for service data has been updated. This latest update includes data through May 31st, 2022.


Thank you,
- NYC Open Data Team

Closed

2022-05-24T00:00:00.000

2026-10-02T00:00:00.000

8768

Data Question

Agency not assigned yet.

Dear colleagues,
In April, I downloaded a dataset with traffic volume counts for the period 2014 to 2020. I wanted to use this dataset to validate the clustering algorithm in our project. However, now the link I used is not valid and I can no longer find this dataset. The problem is that I have to add the dataset reference and license to the citation. It was a dataset called Traffic_Volume_Counts__2014-2020_.csv from the link https://data.cityofnewyork.us/Transportation/Traffic-Volume-Counts-2014-2020-/ertz-hr4r. Could you please tell me if I can use this dataset and how to cite it correctly in this case (and with what license). Thank you very much.

Regards,
*****

No URL Submitted.

Traffic Volume Counts dataset on the Open Data Portal was removed due to the redundancy of the data, it was added back to the Open Data Portal due to high demand, linked below. The alternative Automated Traffic Volume Counts data was the preferred dataset due to the more detailed 15 min count intervals compare to the 1 hour count intervals.
Both datasets are now available:
Traffic Volume Counts (up to 2021)- https://data.cityofnewyork.us/Transportation/Traffic-Volume-Counts/btm5-ppia
Automated Traffic Volume Counts (up to 2020)- https://data.cityofnewyork.us/Transportation/Automated-Traffic-Volume-Counts/7ym2-wayt/data
Standard citation are used, the order and punctuation of the citation components is dictated by the style you use. The following information should be include:
Author Name (Agency Name). “Title of Page/Work.” Title of Website, Date of Publication, Website Link

Thank you,
- NYC DOT Open Data Team

Closed

2022-05-24T00:00:00.000

2026-10-02T00:00:00.000

8767

Reported Error

Department of Buildings (DOB)

I noticed duplicate Job# and Doc# rows when filtering for Bin# 5166781.

Job#500746099 Doc#1 appears three times for example.
Job#520225426 Doc#3 twice.
520225480-1, 520227111-1, 520451813-1 and 540175264-1 are also there twice.

520295289-1 and 540202289-1 three times.

DOB Job Application Filings

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

Response not sent yet.

Pending

2022-05-24T00:00:00.000

2026-10-02T00:00:00.000

8766

Data Question

Agency not assigned yet.

Hello,

My name is *****, and I'm an ***** at ***** in New York. Every month at *****, we publish an Index of thought-provoking statistics in print and online. For our upcoming issue, we’re interested in publishing DOE statistics on chronic absenteeism in NYC public schools. The Daily News had just done a study on this subject.

Could someone at the DOE please verify these numbers that we have from the Daily News article?
Before the pandemic, those who missed at least 10% of school days were at 25%. But by Fall 2021, that percentage was at 30%.

So far in 2022 [as of April when the article was published], that percentage is at 37%

The racial breakdown in that same time frame, Fall 2021, was as follows:

Black students: 33% 4 years before pandemic, to 40%

Hispanic students: 31% to 36%

Asian students: 13% to 14%

White students: 17% to 19%

English language learners: 27% to 36%.

Would these above stats be correct? Do you also have the latest 2022 numbers for the other categories as you have for the 2022 numbers for ELL students, which the Daily News reported as 40%?

Additionally, just to make sure, these statistics are for Fall 2020-Spring 2021, correct?

I’m also happy to communicate by phone ***** if that’s easier.

Thank you,
*****

No URL Submitted.

You can find the list of datasets maintained by the Department of Education here:
https://data.cityofnewyork.us/browse?Dataset-Infor...

The NYC Open Data team is committed to making City data available for anyone to access online. We cannot accommodate requests to perform individual lookups or queries for single data points or records available in a Open Data dataset. For more help with filtering or searching within a single dataset for an individual record, consult these
video guides.

Thank you,
- NYC Open Data Team

Closed

2022-05-23T00:00:00.000

2026-10-02T00:00:00.000

8765

Reported Error

Department of Buildings (DOB)

Hi there, previously you were including "job_description" on this data set for approved filings. That value seems to have disappeared. Could you please advise if that will be added back? Thank you, Andrew.

DOB NOW: Build – Job Application Filings

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

No, can you just tell us which data set?

Thank you,
- NYC Open Data Team

Pending

2022-05-23T00:00:00.000

2026-10-02T00:00:00.000

8764

Data Question

New York City Police Department (NYPD)

What is the most current and canonical dataset of reported crimes in NYC by year?

The various "crime" tagged datasets in the dataset are confusing to new users, and it's not immediately clear the date of the most-recent-row in the dataset. (Clicking "look" to view the dataset in the browser doesn't always show its most recent row, some dates are blank, which is frustrating.)

There's a lot of public debate now over what kind of violent crimes are happening in the city and whether they're increasing or decreasing, year over year and on a longer trend, but it's hard to figure out where to start making a data-viz from the open data portal's offerings. Seems like a missed opportunity.

NYPD Complaint Data Current (Year To Date)

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

The YTD and historic complaint datasets provide every crime reported to the NYPD. The RPT_DT column captures the date the crime was reported, not the date of occurrence, which in many cases is different.
For a more digested view of major crimes and their trends, please use Compstat 2,0 available here.
NYPD CompStat 2.0 (nypdonline.org)

Thank you,
- NYC Open Data Team

Pending

2022-05-23T00:00:00.000

2026-10-02T00:00:00.000

8763

Reported Error

Agency not assigned yet.

The link https://data.cityofnewyork.us/Transportation/Traffic-Volume-Counts-2014-2019-/ertz-hr4r takes me to a page that says forbidden. The link https://data.cityofnewyork.us/Transportation/Automated-Traffic-Volume-Counts/7ym2-wayt takes me to the data set, but the most recent data is from 2019.

No URL Submitted.

Traffic Volume Counts dataset on the Open Data Portal was removed due to the redundancy of the data, it was added back due to high demand, linked below. The Automated Traffic Volume Counts data was the preferred dataset with the more detailed 15 min count intervals compare to the 1 hour count intervals. The data are collected 3-6 month per year at various locations by placing automated traffic recorder on streets and the update schedule is once per year during the fall.
Both datasets are now available:
Traffic Volume Counts (up to 2021)- https://data.cityofnewyork.us/Transportation/Traffic-Volume-Counts/btm5-ppia
Automated Traffic Volume Counts (up to 2020)- https://data.cityofnewyork.us/Transportation/Automated-Traffic-Volume-Counts/7ym2-wayt/data

Thank you,
- NYC DOT Open Data Team

Closed

2022-05-23T00:00:00.000

2026-10-02T00:00:00.000

8759

Data Question

Department of Buildings (DOB)

I am wondering if the DOB Sustainability Compliance dataset reflects the energy efficiency scores for the most recent year, 2021 in this case. If so, is the data for the previous year available?

DOB Sustainability Compliance Map: Local Law 33

https://data.cityofnewyork.us/d/355w-xvp2

These data points are current as of October 2020, and they will be updated this week with October 2021 records.

Thank you,
- NYC Open Data Team

Pending

2022-05-21T00:00:00.000

2026-10-02T00:00:00.000

8754

Data Question

Agency not assigned yet.

In the Health field there are two classifications (Yes & No) that are not explained in the Data Dictionary. Would Yes indicate a healthy tree and No indicate an unhealthy tree? Thank you. *****

No URL Submitted.

The data dictionary for this dataset shows that the "health" field will contain the values "good," "fair," and "poor." Please let us know if you have further questions. Hope this helps!

Thank you,
- NYC Parks Open Data

Closed

2022-05-19T00:00:00.000

2026-10-02T00:00:00.000

8753

Reported Error

Agency not assigned yet.

The launch project URL is not valid. Change it to scout.tsdataclinic.com

No URL Submitted.

Hi Zhi,
Thanks for pointing this out! Now fixed.

All the best,
*****

Closed

2022-05-19T00:00:00.000

2026-10-02T00:00:00.000

8752

Data Question

Agency not assigned yet.

Hello,

1st of every month Open Data pulls the data from the Accelerator CPR database. DoITT is upgrading the the CPR and we wanted to confirm that it will not impact this mechanism.

The mechanism was created by "***** (Consultant)" in 2014.

CPR UPGRADE TO OAS (Oracle Analytics Server) 5.9 - *****.

No URL Submitted.

Response not sent yet.

Pending

2022-05-19T00:00:00.000

2026-10-02T00:00:00.000

8747

Data Question

Department of Education (DOE)

Is the 4:00pm daily reporting available historically? Not the historical daily attendance (https://data.cityofnewyork.us/Education/2015-2017-Historical-Daily-Attendance-By-School/46g3-savk) but rather the reported daily attendance as of 4:00pm without later correction.

School Attendance Statistics

https://data.cityofnewyork.us/d/u6fv-5dqe

No its not.

Thank you,
- NYC Open Data Team

Closed

2022-05-16T00:00:00.000

2026-10-02T00:00:00.000

8746

Data Question

Agency not assigned yet.

I could obtain this dataset with more information of years, I need to do my final data science master's thesis and I would need this information but with more years

No URL Submitted.

Due to changes in data systems and reporting requirements, we are currently releasing all the available, consistent data we have.

Thank you,
- NYC Open Data Team

Closed

2022-05-16T00:00:00.000

2026-10-02T00:00:00.000

8745

Data Question

Agency not assigned yet.

Dear NYC open data,
I am having trouble with running the "Automated Traffic Volume Counts" Table on ArcGIS pro. I am conducting research on the Implementation of Vision Zero in NYC. All other files that I have used so far from your data base contain geo locations on some form of a WGS 84 Projection. This data set contains a unique WKtGeom that I have never seen before and The ArcGIS program dose not recognize. I would very much appreciate if you could share with me the spatial reference identifier (SRID) for this data set.
I look forward to your replay.

Thank you,
*****
Department of Geography
***** University *****

A Research member of *****'s
Transport behavior and Smart Transport Systems team.

No URL Submitted.

Thank you for contacting NYC Open Data regarding Automated Traffic Recorder dataset. Well-known text (WKT) represents coordinate reference systems in machine and human readable language. 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

Alternate option is to use the open source QGIS application and use the QuickWKT plugin to convert "WktGeom' into point geometry, which is then exportable to ESRI shapefile.
Stack Exchange forum: https://gis.stackexchange.com/questions/211822/converting-wkt-to-shp


Thank you,
- NYC DOT Open Data Team

Closed

2022-05-15T00:00:00.000

2026-10-02T00:00:00.000

8744

Data Question

Agency not assigned yet.

Why is this dataset out of date? The metadata indicates that it should be updated daily and is updated via an automated process but yet it has not seen an update since December of 2021.

No URL Submitted.

Response not sent yet.

Pending

2022-05-14T00:00:00.000

2026-10-02T00:00:00.000

8743

Data Question

City Council (NYCC)

When will this dataset be updated? It hasn't been updated since 2021 and many city council members are out of date now.

City Council Members (1999 to Present)

https://data.cityofnewyork.us/d/uvw5-9znb

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

Thank you,
- NYC Open Data Team

Closed

2022-05-14T00:00:00.000

2026-10-02T00:00:00.000

8740

Data Question

Agency not assigned yet.

To whom it may concern,
I hope that you are doing well. My name is ***** and I am a research economist working with *****. At the moment I am trying to better understand the ownership of and market for NYC taxi medallions.

I am struggling to understand the data set in the link given above. For any given vehicle, it seems to have many columns, it says that it "contains historical information on the status of current medallion vehicles authorised to operate in NYC". What exactly is this information? Is it the case that any given vehicle must be re-registered every day? In addition, I was wondering if NYC Open Data has information on the auctioning of medallions by the city over time/ of the trade of medallions on the secondary market. I was unable to find it on your website, but if you have any information on it that would be greatly appreciated. Thank you in advance for your help.
Best wishes,
*****

No URL Submitted.

Response not sent yet.

Pending

2022-05-13T00:00:00.000

2026-10-02T00:00:00.000

8735

Reported Error

Department of Housing Preservation and Development (HPD)

The column vacateordernumber is supposed to be unique, but there are two distinct records that both have the value 172191, so this is breaking our existing database updating process that provides access to this data for many different tools and analysis projects. It would be a huge help if you are able to correct this issue, thanks

Order to Repair/Vacate Orders

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

Thank you for contacting us about this issue. We have investigated and found the source of the error. It has been resolved internally and the open data should be corrected by early next week.

Best,
HPD Open Data Team

Closed

2022-05-12T00:00:00.000

2026-10-02T00:00:00.000

8731

Reported Error

Department of Housing Preservation and Development (HPD)

There are two rows for distinct records with the same value for vacate_order_number (172191), which is supposed to be unique.

Order to Repair/Vacate Orders

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

Thank you for contacting us about this issue. We have investigated and found the source of the error. It has been resolved internally and the open data should be corrected by early next week.

Best,
HPD Open Data Team

Closed

2022-05-11T00:00:00.000

2026-10-02T00:00:00.000

8730

Reported Error

Department of Buildings (DOB)

It looks like the ":created_at" underlying field for querying was changed in the past month and stopped accepting queries of form "2022-5-1" for example. May have been an inadvertent error or change in convention over the past month. Can you please take a look? Would really appreciate it!

DOB Violations

https://data.cityofnewyork.us/d/3h2n-5cm9

Response not sent yet.

Pending

2022-05-11T00:00:00.000

2026-10-02T00:00:00.000