NYC Open Data Help Desk: Data Questions and Reported Errors

4908

Reported Error

Agency not assigned yet.

This website is over a year out of date. Please replace with a current version.

Among other features, this version lacks the subway station footprints that are seen in the WalkNYC maps installed in subway stations. The MTA has assured me that the DOT is the sole custodian of the WalkNYC geodatabase.

No URL Submitted.

Hello,

Thank you for your request of WalkNYC MTA Neighborhood Maps, specifically the Subway Footprints. We apologize the delay and for any confusion, however DOT neither generates nor maintains the data used to create the Subway Footprints. DOT’s understanding is that consultants work directly with MTA to create that additional layer.

The currently available Department of Transportation WalkNYC map layers will be updated by 9/30/2019.

All the layers under DOT's jurisdiction was updated on the portal on 7/31/2019. The MTA station footprints that the requestor is looking for is not under DOT jurisdiction.
Best,
NYC DOT – Open Data Team

Closed

2019-03-21T00:00:00.000

2026-10-02T00:00:00.000

4907

Reported Error

Department of Citywide Administrative Services (DCAS)

The latest data-set is missing an enormous amount of information.

Additionally, the encoding is incorrect and doesn't include line breaks; but that is a more or less trivial issue compared to the missing data.

Jobs NYC Postings

https://data.cityofnewyork.us/d/kpav-sd4t

Thank you for contacting NYC Open Data Help Desk. NYC Jobs dataset was updated today with the latest available information.

Thank you,
- NYC Open Data Team

Closed

2019-03-21T00:00:00.000

2026-10-02T00:00:00.000

4902

Data Question

Department of Finance (DOF)

Thank you, thank you, thank you for all your work.
(1)What are the date limitations in the J-51 dataset? It looks like data are missing before init_year 1964? or 1959? and before tax_year 1970 even tho there are records for those time periods. [Counting would be soooo much easier if each record had any unique identifier. So I'm slipping a request in here too, I guess. You also might want to add date limitations info to the Data Dictionary, too. Sorry to be greedy. But I LOVE your work!]
J-51 goes back to 1955. I'm not sure what the effective year is, so do data exist going back to the first J-51 benefit granted? Will such data make it into this dataset? If the answer to the latter question is no, are the data available via FOIL request?
(2) ABATE_GRANTED and ABATEMENT are the same numbers. I'm very sure that one of those should be the total, multi-year amount and the other should be the amount used in the named tax year. That is how the DOF web site used to do it so the data or the routine for deriving it exists. I can back into it too, but doing it often will be a pain. Can you fix?
(3) I see the Data Dictionary's mention of TAX_YEAR = 9999, But it is INIT_YEAR that often has 9999. Same idea? (Seems a bit odd to have multiple abatements STARTING in the same year, but if you insist....)
Thanks again.

J-51 Exemption and Abatement (Historical)

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

. The J-51 data on the portal goes from 1973 - 1/2019. We do not have accessible data prior to 1973.
2. ABAT_GRANTED and ABATEMENT have the same value.
3. TAX_YEAR = 9999 represents the total exemption when there are multiple exemptions for the same year.






Thank you,
- NYC Open Data Team

Closed

2019-03-20T00:00:00.000

2026-10-02T00:00:00.000

4888

Data Question

Agency not assigned yet.

The SCA has subdistrict boundaries mapped - can these subdistrict shapefiles become part of the dataset?

see here:

https://dnnhh5cc1.blob.core.windows.net/portals/0/Capital_Plan/Management_Reports/District%2014.pdf?sr=b&si=DNNFileManagerPolicy&sig=UsHha9H77jCFyDBHgZXWk2ab6oAsSTC4uBaG4KcsTuQ%3D

and here (parent)
http://www.nycsca.org/Community/Capital-Plan-Reports-Data#Sub-District-Maps-335

No URL Submitted.

We cannot accommodate requests to create specific datasets for single data points or records available in an Open Data dataset.

Thank you,
- NYC Open Data Team

Closed

2019-03-19T00:00:00.000

2026-10-02T00:00:00.000

4887

Reported Error

Department of Finance (DOF)

The borough numbers do not align properly with the addresses. Additionally, the dataset currently loads zero Staten Island land sales, according to borough labels.

ACRIS - Real Property Master

https://data.cityofnewyork.us/d/bnx9-e6tj

The borough field in the ACRIS Real Property Master data set is the recorded borough where the document was processed, not the property borough. All electronic submissions are processed in Manhattan so this field will be 1 for most recent recordings.

You can find more information in the data dictionary which is under the About tab and in the Attachments that are available there.

Closed

2019-03-19T00:00:00.000

2026-10-02T00:00:00.000

4885

Data Question

Agency not assigned yet.

NYC Open Data Staff,
A group of policy researchers on my team are pursuing research involving housing complaints, problems, and violations in NYC. We are looking for a way to combine the "Complaint Problems" and "Housing Maintenance Code Violations" datasets. Currently, these datasets seem to lack a unique identifier variable to connect the two. Is there an efficient method for connecting "problems" to "violations"?

No URL Submitted.

Hi,

Unfortunately, there is no unique identifier to connect a complaint problem to a violation, due to the fact that not all violations flow directly from complaints received.

Thank you,
- NYC Open Data Team + NYC Department of Housing Preservation and Development

Closed

2019-03-19T00:00:00.000

2026-10-02T00:00:00.000

4884

Data Question

Department of Buildings (DOB)

Hi I notice that this dataset is typically one day behind when the violations hit. I also notice that there are some entities/companies that seem to have an advanced copy of the data set. Is there a way to get something more in real time? Thanks!

DOB Violations

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

Hi,

This is the highest frequency we can offer in bulk through the open data portal. You can look up individual violations if you know the number, or you can look up an individual property, on our Building Information System (BIS) website.

Thank you,
- , DOB Open Data Coordinator

Closed

2019-03-19T00:00:00.000

2026-10-02T00:00:00.000

4882

Data Question

Department of Transportation (DOT)

May I please know what the LinkID means in this "Real-time Traffic Speed data" dataset? Is there a matching list available to map this LinkID to the road network of NYC? Thanks a lot.

Real-Time Traffic Speed Data

Thank you for sending in your question! Descriptions of the fields for the Real-Time Traffic Speed Data can be found in the link below in attachments section:
https://data.cityofnewyork.us/Transportation/DOT-Traffic-Speeds-NBE/i4gi-tjb9


Thank you,
- NYC Open Data Team

Closed

2019-03-18T00:00:00.000

2026-10-02T00:00:00.000

4873

Data Question

Agency not assigned yet.

Hi how do I get more information about the name of a person that appears on this list? How did he died, what happen? [Name Redacted] is my uncle, we have been looking for him since 1992. Please help me.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Our records show that [Name Redacted] died and was buried in 1997. For more information regarding the cause of death or any medical conditions, please contact NYC Office of Chief Medical Examiner at https://www1.nyc.gov/site/ocme/index.page​

Thank you,
- NYC Department of Correction (DOC)

Closed

2019-03-16T00:00:00.000

2026-10-02T00:00:00.000

4871

Data Question

Department of Finance (DOF)

Hi, is there an API or documentation on how to work with Properties Master ?
I want to make a project (im in coding school).

ACRIS - Real Property Master

https://data.cityofnewyork.us/d/bnx9-e6tj

​Thank you for contacting NYC Open Data Help Desk. You are encouraged to review API documentation at
https://dev.socrata.com/
​In addition, you are also encouraged to reach out to Socrata support for any questions of technical nature at https://support.socrata.com/hc/en-us
​
Thank you,
- NYC Open Data Team

Closed

2019-03-15T00:00:00.000

2026-10-02T00:00:00.000

4862

Reported Error

Mayor's Office of Media and Entertainment (MOME)

The webpage says the dataset was updated on 3/13, but the last entry is from 12/13

Film Permits

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

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


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

Closed

2019-03-14T00:00:00.000

2026-10-02T00:00:00.000

4860

Data Question

Department of Finance (DOF)

Hello. When browsing ACRIS information on the Department of Finance website, the 'Details' section of an ACRIS record will often have a 'Parcels' section (here's an example: https://a836-acris.nyc.gov/DS/DocumentSearch/DocumentDetail?doc_id=2007123100758001). Is this parcel data available through NYC OpenData? If not, could it be made available? Thanks!

ACRIS - Real Property Master

https://data.cityofnewyork.us/d/bnx9-e6tj

The parcel details are available in the ACRIS Real Property Legals data set here:
https://data.cityofnewyork.us/City-Government/ACRIS-Real-Property-Legals/8h5j-fqxa

The link is via DOCUMENT ID & GOOD THROUGH DATE.

You can take a look at the Attachments under the About tab. These documents explain the relationship between the ACRIS data sets.

Thank you,
- NYC Open Data Team

Closed

2019-03-13T00:00:00.000

2026-10-02T00:00:00.000

4858

Data Question

Agency not assigned yet.

Based on the column "Permit_Expiration_Date", it appears that the vast majority of permits in the dataset are expired. Is there a more up-to-date version of this dataset available?

No URL Submitted.

Thank you for your comment and we are looking into this issue. In the meantime, you may submit a FOIL request to recordsaccess@health.nyc.gov if you would like a particular dataset.

Closed

2019-03-13T00:00:00.000

2026-10-02T00:00:00.000

4855

Data Question

Agency not assigned yet.

How many stalled construction sites are in NYC (Manhattan and the boroughs)? Thanks.

No URL Submitted.

Hi,

Check out our DOB Stalled Construction Sites dataset. This is a list of all of the sites that we are currently tracking as a "Stalled Site" every day. We do not go in search of stalled sites, so a location will only make the list if a) a complaint is made, and then b) our inspector finds that it is in fact an abandoned construction site.

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

Closed

2019-03-12T00:00:00.000

2026-10-02T00:00:00.000

4848

Data Question

Agency not assigned yet.

All OMO charges have been paid in full through DOF. How can I have the data removed from Opendata?
Thank you

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. If you check our Invoices for Open Market Orders (OMO) Charges dataset, you'll see that that the invoices show that the OMO charges for this building were transferred to DOF on the dates specified for each record. Note that this report does not show changes to individual charges as a result of protests or payments. The Department of Finance system should be checked for the current status of any charge listed on this report once that charge has been transferred to DOF.

Thank you,
- NYC Open Data Team + HPD

Closed

2019-03-11T00:00:00.000

2026-10-02T00:00:00.000

4846

Data Question

Office of Technology and Innovation (OTI)

I would like to know the proper way to list the cite the source for this dataset. I believe the data for the buildings layer is from a 2014 fly over, and is periodically updated, but its not "versioned" so the attribution is not clear. Some discretionary land use changes are now requiring me to list my data sources and I would like to be as accurate as possible. Thank you

Building Footprints (Deprecated)

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that this dataset is being weekly with a full replace. Some of the previous versions of this data is available as the older files that can be downloaded from this dataset's "Attachments" section.

The file is current upto the date on the Open Data portal in the sense that it has all of the edits made over the previous week. You are encouraged to fully utilize resources available for this dataset at https://github.com/CityOfNewYork/nyc-geo-metadata/blob/master/Metadata/Metadata_BuildingFootprints.md

Closed

2019-03-11T00:00:00.000

2026-10-02T00:00:00.000

4842

Data Question

Agency not assigned yet.

How can I get data on oil use in NYCHA buildings for 2017 and 2018?

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please be advised that Heating Oil Consumption And Cost (2010 - 2016) is expected to be updated with 2017-18 data in the coming weeks.
​​
Thank you,
- New York City Housing Authority (NYCHA)

Closed

2019-03-11T00:00:00.000

2026-10-02T00:00:00.000

4841

Data Question

Agency not assigned yet.

I am from Truview background Screening and investigations working on behalf of the NYS Comptroller's Office. I am reaching out in regards to information found on your site about [Named Redacted]. I am just looking to confirm that he has passed away. If you would please contact me back at your earliest convenience I would appreciate it.
Thank you.

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Our records show that Kurtis Rattan date of death was 7/10/2017 at Lincoln Medical and Mental Health Center (HHC). We can confirm date of death (as reported to us by Office of Chief Medical Examiner) and the date of actual burial (managed by Department of Correction). Anything beyond the physical custody and burial, please contact OCME at https://www1.nyc.gov/site/ocme/index.page
​
Thank you,
- NYC Department of Correction (DOC)

Closed

2019-03-11T00:00:00.000

2026-10-02T00:00:00.000

4838

Data Question

New York City Police Department (NYPD)

Why are there no comments in the discussion earlier than 2 years? That seems very unlikely.

Motor Vehicle Collisions - Crashes

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

Thank you for contacting NYC Open Data Help Desk. The earliest comment recorded for this dataset is 5 years old (in the "Discuss" option). Please be advised that from 2017, NYC Open Data disabled this feature and instead, implemented a new system using "Contact Us" page - https://opendata.cityofnewyork.us/engage/

​Thank you,
- NYC Open Data Team

Closed

2019-03-11T00:00:00.000

2026-10-02T00:00:00.000

4833

Data Question

New York City Police Department (NYPD)

I would like to know if there is any column that let me relation this dataset
"https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Historic/qgea-i56i" with this one "https://data.cityofnewyork.us/Public-Safety/NYPD-Arrests-Data-Historic-/8h9b-rp9u"

NYPD Complaint Data Historic

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

​Thank you for contacting NYC Open Data Help Desk. Please be advised that there is no column that links the two datasets because there is not a one to one relationship. There are complaints that do not have corresponding arrests and similarly there are arrests that do not have complaints.

Thank you,
- NYC Open Data Team

Closed

2019-03-09T00:00:00.000

2026-10-02T00:00:00.000

4832

Reported Error

New York City Police Department (NYPD)

Missing location data -- Borough, zipcode, latitude, longitude. The pattern shows that either Borough/zipcode is missing, or latitude/longitude is missing. Geocoding routines using cross street and zipcode could provide lat/long, and lat/long could easily provide borough and zipcode.

Motor Vehicle Collisions - Crashes

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

​Thank you for contacting NYC Open Data Help Desk. Please be advised that this is an known data quality issue related to the capturing of valid address information on the MV-104 form.

Thank you,
- NYPD

Closed

2019-03-09T00:00:00.000

2026-10-02T00:00:00.000

4831

Reported Error

Department of Finance (DOF)

The record with document id "2016050400438019" has ben corrupted somehow and has json data all in in the CRFN field.

ACRIS - Personal Property Master

https://data.cityofnewyork.us/d/sv7x-dduq

Thank you for contacting NYC Open Data Help Desk. Please be advised that the ACRIS - Personal Property Master dataset was updated and the record in question corrected.

Thank you,
- NYC Open Data Team

Closed

2019-03-09T00:00:00.000

2026-10-02T00:00:00.000

4822

Reported Error

311

Number of rows in the dataset dropped significantly overnight from March 6 to March 7th. This seems to be caused by a significant drop in the record count between 2010 and 2013.

311 Service Requests from 2020 to Present

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

​Thank you for contacting NYC Open Data Help Desk and reporting this discrepancy. Please be advised that 311 Service Requests from 2010 to Present dataset was updated with the latest available information and currently contains almost 20M records.

Thank you,
- NYC Open Data Team

Closed

2019-03-07T00:00:00.000

2026-10-02T00:00:00.000

4819

Data Question

Agency not assigned yet.

I work for the *** and at times require the use of 311 data. I am currently looking into the DOHMH pest control complaints and was wondering whether it would be possible to obtain an extract for a certain time period including the SR #. I saw that the SR # does not seem to be available on the NYC OpenData datasets. If it is possible, please let me know who we would need to contact, or direct me how to obtain it from the website if it is available to download. Thank you.

No URL Submitted.

We've been advised by the agency's general counsel that the information that you're looking for is not made available due to privacy concerns.

Thank you

Closed

2019-03-07T00:00:00.000

2026-10-02T00:00:00.000

4817

Reported Error

Agency not assigned yet.

Dataset is supposed to show 2018 information, yet it shows data from 2001 to 2084.

No URL Submitted.

The data in the Yellow Trip Record dataset were collected and provided to the NYC Taxi and Limousine Commission (TLC) by technology providers authorized under the Taxicab & Livery Passenger Enhancement Programs (TPEP/LPEP). The trip data was not created by the TLC, and TLC does not modify the data we were provided. We have uploaded records through June 30, 2018-- anything after this date was recorded in error. We are currently working on releasing trip records to Open Data and the TLC website through the end of the 2018-- please check back in a week or so for updated data.

Thanks,
NYC Open Data + Taxi and Limousine Commission

Closed

2019-03-06T00:00:00.000

2026-10-02T00:00:00.000

4815

Data Question

Department of Buildings (DOB)

the documentation says that this file contains the property owners name,address and phone #. in reviewing a number of the entries it would appear that these fields were populated by the person contracted to do the work and not the actual owner. if you look in manhattan, block 758, lot 37 which finance says is owned by Holy Spirit Assn while this data set shows multiple property owners - all of whom it would appear are actually the owners of the business doing the work. can you please clarify if these fields are the actual owner of the property or of the firm doing the work. thank you

thanks for your reply - you would think it would be easy to correct the documentation such that is reflects that these fields PROBABLY are not the actual property owner but most likely the contact/owner of the firm doing the actual work

DOB Job Application Filings

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

Hi,

Good question! These fields represent what the applicant wrote on the original job application. Department of Finance building ownership data is a more reliable source for this information.

This is a common misunderstanding in DOB data, and I've struggled to clarify it in the documentation. I will revisit it based on your comments and see if I can make it clearer.

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

Closed

2019-03-07T00:00:00.000

2026-10-02T00:00:00.000

4813

Reported Error

New York City Fire Department (FDNY)

This data along with the other "Bureau of Fire Prevention" datasets are scheduled to be updated Quarterly but have not been updated since April 19, 2018. There was a metadata update in September but not data update.

These are the four datasets in question:

Certificates of Fitness https://data.cityofnewyork.us/Public-Safety/Bureau-of-Fire-Prevention-Certificates-of-Fitness/pdiy-9ae5
Inspections https://data.cityofnewyork.us/Public-Safety/Bureau-of-Fire-Prevention-Inspections/ssq6-fkht
Building Summary https://data.cityofnewyork.us/Public-Safety/Bureau-of-Fire-Prevention-Building-Summary/nvgj-hbht
Active Violation Orders https://data.cityofnewyork.us/Public-Safety/Bureau-of-Fire-Prevention-Active-Violation-Orders/bi53-yph3

Bureau of Fire Prevention - Certificates of Fitness (Historical)

https://data.cityofnewyork.us/d/pdiy-9ae5

Thank you for contacting NYC Open Data Help Desk. All 4 datasets were updated with the latest available information.

Thank you,
- NYC Open Data Team

Closed

2019-03-06T00:00:00.000

2026-10-02T00:00:00.000

4810

Data Question

Agency not assigned yet.

I cannot see the view and none of my location searches are coming up. When I refresh the view there are more buttons just before it loads and then they disappear. I would like to be able to use this for searching property boundaries and download it for use with GIS.. Is there a class I can take to use this site better?

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please be advised that the technical issue that affected this map was resolved.
​
​For additional information on how to use NYC Open Data portal, please refer to
​https://opendata.cityofnewyork.us/how-to/
You are also encouraged to ​contact Socrata support at
https://support.socrata.com/hc/en-us/requests/new
Socrata is a platform that hosts ​NYC Open Data and can provide additional learning resources.

Thank you,
- NYC Open Data Team

Closed

2019-03-06T00:00:00.000

2026-10-02T00:00:00.000

4808

Data Question

Agency not assigned yet.

Hi all.what happened to the 2014 TLC yellow taxi trip data? Cannot find it anywhere on your database unless i missed it.
Thanks

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. The information you are looking for can be found at https://data.cityofnewyork.us/view/gn7m-em8n
We have adjusted the metadata for this asset so it will be visible in the search results. ​

Thank you,
- NYC Open Data Team

Closed

2019-03-06T00:00:00.000

2026-10-02T00:00:00.000

4807

Reported Error

New York City Police Department (NYPD)

The NYPD_Collision_DataDictionary.xlsx document appears to be outdated. The columns referenced in the document do not align with the actual columns in the dataset.

There is also some data cleaning required in the "Vehicle Type Code X" columns. For example, there are separate entries for "Bus" & "BUS" and for "Bike" & "Bicycle"

Motor Vehicle Collisions - Crashes

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

Thank you for contacting NYC Open Data Help Desk and for your input. We are currently in the process of updating the data dictionary for this dataset and your suggestions will be taken under consideration.

Thank you,
- NYPD

Closed

2019-03-05T00:00:00.000

2026-10-02T00:00:00.000

4804

Data Question

Agency not assigned yet.

coo of a 3 bldgs that were completely redone in approx. 1985. 1850 52nd street, 1860 52nd street and 1865 52nd street Brooklyn, NY 11204. The updated certificate of occupancies I need to demonstrate the change in status of the buildings

No URL Submitted.

Hi,

This is difficult to trace back in our digital records. They only go back to about 2000 on open data, and about 1985 in our digital systems. You can try looking up the buildings individually in our BIS system, but I'm getting confused and I'm familiar with some of the complications involved.

I think your best bet in tracking down what you need is to submit a FOIL request.

Thank you,
- , DOB Open Data Coordinator

Closed

2019-03-05T00:00:00.000

2026-10-02T00:00:00.000

4802

Reported Error

Department of Citywide Administrative Services (DCAS)

I am unable to review the civil service list in the site. Usually I am able to see the list for the exam, grades, and names of the passing applicants.

City Record Online

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

Thank you for contacting NYC Open Data Help Desk. This information can be found in ​the Civil Service List (Active) dataset at https://data.cityofnewyork.us/City-Government/Civil-Service-List-Active-/vx8i-nprf
​
​Thank you,
- NYC Open Data Team

Closed

2019-03-05T00:00:00.000

2026-10-02T00:00:00.000

4799

Data Question

Agency not assigned yet.

I'm looking at the data for the MOFTB. For 2018, it indicates Total 6.25M Rows and Filtered Amount 1984 Rows. What's the difference between total rows and filtered rows?
Thanks.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. 6.25M rows is the number of records in this dataset for 2018 for all the agencies.

MOFTB has a total of 20.4K rows in this dataset. But you have filtered this data based on 2018 year only, which generated 1,984 filtered MOFTB rows applicable to only 2018 year. In other words, 1,984 MOFTB rows is a subset of the 20.4K MOFTB rows and a subset of 6.25M rows for all agencies based on filtered criteria of Agency=MOFTB and Year=2018.

Thank you,
- NYC Open Data Team

Closed

2019-03-05T00:00:00.000

2026-10-02T00:00:00.000

4797

Data Question

Department of Environmental Protection (DEP)

Can you confirm if this data includes all water usage in NYC including usage by commercial businesses, parks, etc? What is the measurement source for the NYC Consumption?

Water Consumption in the City of New York

https://data.cityofnewyork.us/d/ia2d-e54m

Please find the answers to your questions about the NYC Water Consumption datasset:

Q1 - Can you confirm if this data includes all water usage in NYC including usage by commercial businesses, parks, etc?

A1 - The consumption numbers are the total drinking water consumption in the City including all uses.

Q2 - What is the measurement source for the NYC Consumption?

A2 - The measurements are made at the entry points of drinking water to the distribution system.

Thank you,
- NYC DEP OpenData Team

Closed

2019-03-05T00:00:00.000

2026-10-02T00:00:00.000

4795

Data Question

Agency not assigned yet.

Can you please tell me if this data set will be updating daily or weekly? If weekly, will it be on Monday afternoons? Thank you

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please be advised that Open Parking and Camera Violations dataset is usually updated daily in the morning.

Thank you,
- NYC Open Data Team

Closed

2019-03-05T00:00:00.000

2026-10-02T00:00:00.000

4791

Data Question

Agency not assigned yet.

(1) How do we interpret the time stamp for permit issue and expiration dates? Is it the date the permit was first issued? (2) What do duplicate entries indicate? (3) Is there a detailed codebook available?

No URL Submitted.

Hello,
Most recent NYC restaurant inspection data can be found on NYC OpenData in the DOHMH New York City Restaurant Inspection Results data set. https://data.cityofnewyork.us/Health/DOHMH-New-York-City-Restaurant-Inspection-Results/43nn-pn8j
Important information about the data set and instructions on how to use the data can be found in the “About the Dataset” section of the page.

Thank you
Department of Health

Closed

2019-03-04T00:00:00.000

2026-10-02T00:00:00.000

4790

Data Question

Department of Citywide Administrative Services (DCAS)

I would like to know if the civil service list active certification shows agency" (example NYCHA) with request dates and expiration date , does that means they send me a letter to attend for a pool? because the agency I have received hiring pool letters are on this list.

Civil Service List (Active)

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

You inquired concerning the Civil Service List Certification dataset. The dataset includes information concerning the date on which an agency requests that DCAS certify names from a civil service list ("request date") and the date on which DCAS certifies names to an agency ("certification date"). DCAS does not have information about the dates on which individual agencies call candidates to appear for an interview or attend a hiring pool.

Closed

2019-03-04T00:00:00.000

2026-10-02T00:00:00.000

4786

Data Question

Agency not assigned yet.

Can you please tell me why the parking ticket website data has not been updated since 2.25.19? Are you still planning to update this data daily? Thank you.

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk and reporting this issue. Open Parking and Camera Violations dataset was updated on 03/05/2019 with the latest available information.

Thank you,
- NYC Open Data Team

Closed

2019-03-03T00:00:00.000

2026-10-02T00:00:00.000

4785

Data Question

Agency not assigned yet.

I see you have the 311 call list data set available. I downloaded it once directly from the site as an excel document and it opened fine. However I tried to reopen it and it compressed the file and changed the order of the sections and put the dates in a weird order. I have tried to redownload the file but it does not let me download it as an excel directly, and when I convert from CVS the data is not clearly sectioned. I require just the data from January 1st 2018 to January 1st 2019. The only information I need to know is the amount of calls made each day for the time specified. I am doing an independent research study as an undergrad for Hunter. I am a statistics major and would like to use the data for analysis on R and am presenting on presenting the research at the undergraduate research fair. I am trying to see correlations between temperature and the amount of calls received. This is to see if weather is attributing to any of the immense amount of calls.

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. If you are referring to the 311 Call Center Inquiry dataset at https://data.cityofnewyork.us/City-Government/311-Call-Center-Inquiry/wewp-mm3p/data you will need to utilize a Filter feature of this platform that would allow you to select a range of records according to your specific criteria. For help on how to use Filter, please refer to https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View
​This dataset generates around 6 million records for the date range you have specified and the entire file will not open in Excel due to this application's size limitation to only around 1 million records. You are encouraged to download the filtered view in csv format and use programs that would allow you to handle files with such number of records (for example Sublime Text). Please note that NYC Open Data does not in any way promote any of these commercial applications or provide technical support for the third-party products.
​
​For additional technical assistance with the Open Data portal, please contact Socrata support at https://support.socrata.com/hc/en-us
​
​Thank you,
- NYC Open Data Team

Closed

2019-03-02T00:00:00.000

2026-10-02T00:00:00.000

4784

Data Question

Department of Parks and Recreation (PARKS)

I have a question about your data on the park zones. Some of these parks have roads where an automobile can drive through, but some of them don't. Which parks don't have roads where an automobile can drive through?

ARCHIVED - Parks Properties

https://data.cityofnewyork.us/d/k2ya-ucmv

Thank you for contacting NYC Parks regarding roads within parks. We do not maintain this information as a unique dataset. To find roadways in parks, we recommend spatially joining the City Street Centerline (CSCL) dataset, which is the authoritative source for roadbed information, to our Parks Properties dataset.

Thank you,
- NYC Parks and the NYC Open Data Team

Closed

2019-03-01T00:00:00.000

2026-10-02T00:00:00.000

4783

Reported Error

Agency not assigned yet.

Can you put the "date made public" in the published data asset inventory in a date format?

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please be advised this column is a custom Socrata metadata field, and the platform does not provide a functionality for a user to specify its data type. All of the custom metadata fields are automatically created as a text field. Open Data team requested this functionality to be added as a Feature Request for the future platform releases.
​
Thank you,
- NYC Open Data Team

Closed

2019-03-01T00:00:00.000

2026-10-02T00:00:00.000

4781

Reported Error

Department of City Planning (DCP)

For the mapPluto parcel files, ownership data is cut off at a certain number of characters (~20). We are trying to build into our app the ability to cross-reference with the NYS Active Corporations dataset (https://data.ny.gov/Economic-Development/Active-Corporations-Beginning-1800/n9v6-gdp6/data) but because the data is cut off, the matches don't return correctly. Is there any way to get the dataset with full owner name?

Primary Land Use Tax Lot Output - Map (MapPLUTO)

https://data.cityofnewyork.us/d/f888-ni5f

PLUTO uses datasets from many other city agencies, including Department of Finance (DOF). The owner name comes from a source file at DOF, which also caps the 'owner name' at 21 characters, which is why the ownername field in PLUTO is 21 characters. We do not have another source for the owner name.

DOF is creating a new data system and we are told that the owner name field will be longer. When that change occurs in the DOF file we will update the owner name field in PLUTO.

Thank you for your feedback.

Thank you,
- Department of City Planning Open Data Team

Closed

2019-03-01T00:00:00.000

2026-10-02T00:00:00.000

4780

Data Question

Agency not assigned yet.

I am trying to understand construction permit data. The NYC Construction Dashboard has data on an annual basis that does not match Open Data construction permit data. I am looking for what the "official" construction permits issued are annually by borough and job type. thanks,

No URL Submitted.

Response not sent yet.

Closed

2019-03-01T00:00:00.000

2026-10-02T00:00:00.000

4779

Data Question

Department of Parks and Recreation (PARKS)

There are only 231 "schoolyards to playgrounds" listed in this data set, but according to a 2017 press release (see below), there are 251-261 in existence. What accounts for this discrepancy?

https://www1.nyc.gov/office-of-the-mayor/news/509-17/de-blasio-administration-reveals-10-new-schoolyards-playgrounds-sites#/0

ARCHIVE - Schoolyards To Playgrounds

https://data.cityofnewyork.us/d/urxm-vzzk

Agency representative directly contacted this user

Closed

2019-03-01T00:00:00.000

2026-10-02T00:00:00.000

4777

Data Question

Department of Transportation (DOT)

I'm trying to read the location data from the shapefile, but i'm having a bit of an issue converting the WGS84 coordinates into lat/lon.. They always seem to convert to locations in Africa. Are there any examples of which coordinate system exactly i should be converting from?

Parking Regulation Locations and Signs

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

Can you please provide additional information? Which system are you using?
The Coordinate System for the shapefiles are in WGS 1984.

Thank you,
- NYC Open Data Team

Closed

2019-03-01T00:00:00.000

2026-10-02T00:00:00.000

4774

Data Question

Agency not assigned yet.

Do you know how I can obtain a PAR (Statistical Summary Attendance Report) for our school?

No URL Submitted.

Run the RPAR report in ATS
Thank you,
- NYC Open Data Team

Closed

2019-02-28T00:00:00.000

2026-10-02T00:00:00.000

4773

Data Question

Agency not assigned yet.

How can I get DOB Construction Permit info for the 1980's prior to 1989 (which is online)?

No URL Submitted.

Hi,

For anything earlier than that, we don't even have access to it as data ourselves. You'll have to submit a FOIL request and someone will help you research through our document archives.

Thank you,
- , DOB Open Data Coordinator

Closed

2019-02-28T00:00:00.000

2026-10-02T00:00:00.000

4771

Data Question

New York City Fire Department (FDNY)

I'm trying to figure out if there is a data dictionary that accompanies this dataset? For example, in the 'COMMUNITYDISTRICT' column, values range in the 100's, 200's, 300's etc.. but to my knowledge, NYC only has about 59. So essentially, I'm trying to figure out what all the codes mean.. for this column as well as other's that I should know about. Thanks for your help

EMS Incident Dispatch Data

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

The first digit identifies the borough and the remaining two digits are the community district.

1 (Manhattan), 2 (Bronx), 3 (Brooklyn), 4 (Queens), 5 (Staten Island)

I hope this information is helpful. Thank you for your inquiry.

Closed

2019-02-27T00:00:00.000

2026-10-02T00:00:00.000

4767

Data Question

Department of Housing Preservation and Development (HPD)

What is "capitalization rate"? the interest rate on the (current?) mortgage? Other?

Speculation Watch List

https://data.cityofnewyork.us/d/adax-9mit

As defined in the local law that governs the Speculation Watch List data, a property’s capitalization rate is the net operating income divided by the sales price for that property. Properties with a capitalization rate below the borough median are placed on the Speculation Watch List.

Thank you,
- NYC Open Data Team + HPD

Closed

2019-02-27T00:00:00.000

2026-10-02T00:00:00.000

4761

Reported Error

Agency not assigned yet.

Starting at Program Type, the values are inaccurate need to be shifted. Values don't correspond to the variable name.

No URL Submitted.

The correction has been made
Thank you,
- NYC Open Data Team

Closed

2019-02-26T00:00:00.000

2026-10-02T00:00:00.000