NYC Open Data Help Desk: Data Questions and Reported Errors

3026

Data Question

Agency not assigned yet.

Hello. I would like to see the report stating that a building, 213-02 42nd Avenue, Bayside, NY (Queens), is in need of repair per Local Law 11. I am having a difficult time getting through to the management agency. Is there a database online or a report that I can read? Thank you!

No URL Submitted.

Hi,

The address is required by Local Law 11 to have an inspection report filed every five years with the Department of Buildings. You can see the historical reports in BIS here.

As of December 2016, these reports are now required to be filed in our new DOB NOW system. You can see the newer reports in the DOB NOW Public Portal. On the left, search for the building by address, BIN, or Borough, Block, Lot. This will give you the building profile page. Scroll to the bottom and click on SAFETY: Compliance Filings. You'll see 3 filings for this building. You want to view the top one, TR6-811455-8A-I1, which is the most current filing. Click on the icon in the View column. You can then click through the different areas of the report to see what the inspector found.

You can also see this in open data in our DOB NOW: Safety – Facades Compliance Filings dataset. But if you are only interested in a single address, you will get more detail by going directly to DOB NOW as explained above.

Thank you,
- , DOB Open Data Coordinator

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

Closed

2018-02-05T00:00:00.000

2026-10-02T00:00:00.000

3025

Data Question

Agency not assigned yet.

The "Incidents Responded to by Fire Companies" data says that it is updated annually but appears not to have anything past 2015. I would like this data for 2017.

No URL Submitted.

The data you've requested can be found here:
https://data.cityofnewyork.us/Public-Safety/Incidents-Responded-to-by-Fire-Companies/tm6d-hbzd/data

It has been updated through December 2017 and will continue to be updated on a bi-annual basis.

Thank you.

- NYC Open Data

Closed

2018-02-05T00:00:00.000

2026-10-02T00:00:00.000

3021

Data Question

311

Does a list of descriptions for the 'complaint_type' column items in the 311 dataset exist anywhere? Trying to make a tool for New Yorkers and community boards to understand the most pressing issues in their areas, but - for example - it's not immediately clear what the "DOOR/WINDOW", "General", or "Consumer Complaint" columns are referring to or what some examples of those complaints might be.

If a formal collection of definitions or descriptions for the complaint type names doesn't exist currently, could you point me in the direction of someone who might understand those mappings a little better and be able to provide a bit more context. Happy to open source the descriptions from there :)

311 Service Requests from 2020 to Present

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

Thank you for contacting NYC Open Data Help Desk. There is no formal collection of the complain type descriptions currently available. You are encouraged to visit BetaNYC and other public forums that examines in greater detail the 311 data.

​Thank You,
​- NYC 311

Closed

2018-02-03T00:00:00.000

2026-10-02T00:00:00.000

3017

Reported Error

Office of Administrative Trials and Hearings (OATH)

There are a lot of mismatches between the status and balance due as reflected on Socrata when compared to OATH Ticket Finder.

Here are some examples:
***

I believe this is a widespread issues beyond just these examples but there is no way to systematically analyze from an outside perspective.

OATH Hearings Division Case Status

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

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that the agency is planning to undertake a project which will update about 4 million records on the Open Data Portal over the next couple of weeks. It is expected that it would resolve any potential issues such as these. The agency will also continue to monitor the dataset and data-feed to Open Data going forward.

Thank you,
-NYC Open Data

Closed

2018-02-02T00:00:00.000

2026-10-02T00:00:00.000

3016

Data Question

Department of Housing Preservation and Development (HPD)

Housing Maintenance Code Complaints https://data.cityofnewyork.us/Housing-Development/Housing-Maintenance-Code-Complaints/uwyv-629c/data I need an update with the January 2018 data

Housing Maintenance Code Complaints

Greetings,

Thank you for contacting NYC Open Data Help Desk. Housing Maintenance Code Complaints is updated on the second day of each month. This dataset was updated last on 02/02/2018 and includes data for January 2018. Filtering this dataset for StatusDate is between 01/01/2018 and 01/31/2018 returns 88,818 records.

Thank You,
- NYC Open Data

Closed

2018-02-02T00:00:00.000

2026-10-02T00:00:00.000

3009

Data Question

Agency not assigned yet.

Hi there,
It looks like the most recent permits are from 2013. Is that right, or am I misunderstanding the data? Thanks so much for your help!

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. Current permit information will be made available later this year. The agency is anticipating a late October/early November release.

Thank you,
- NYC Open Data

Closed

2018-01-31T00:00:00.000

2026-10-02T00:00:00.000

3008

Data Question

Agency not assigned yet.

Is there any way to find out the number of people appointed to a title from a current active list?

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. NYC Department of Citywide Administrative Services does not routinely maintain this type of report. If you are looking for information regarding a specific civil service list, you may submit a FOIL request to the agency via this email: foilrequest@dcas.nyc.gov or using this URL: http://www1.nyc.gov/nyc-resources/mail/dcas-email-the-commissioner.page

Thank you,
-NYC Department of Citywide Administrative Services

Closed

2018-02-02T00:00:00.000

2026-10-02T00:00:00.000

3007

Data Question

Agency not assigned yet.

I am researching on the relationship between bike sharing system and Point of Interest .Now I have installed the csv file of Point of Interest,but I don't know the meaning of the columns in the csv,such as "FACI_DOM ","BOROUGH",and " FACILITY_T",etc. Please send me an email to tell me the meaning of the columns.I am not a native speaker,sorry for my English.Thanks!

No URL Submitted.

Greetings,

Thank you for contacting NYC OpenData Help Desk. Please be advised that this dataset was created temporary for testing purposes. Please refer to the official Points Of Interest dataset at this URL:
https://data.cityofnewyork.us/City-Government/Points-Of-Interest/rxuy-2muj
For column descriptions and additional information about this dataset, please download a data dictionary that can be found in About--->Attachments--->PointOfInterest.pdf

Thank you,
-NYC Open Data

Closed

2018-01-31T00:00:00.000

2026-10-02T00:00:00.000

2994

Data Question

Agency not assigned yet.

I am the owner of the ***.

We had an inspection 11/1/2017 resulting in Grade B (violation codes 02G 04N 08A 10B). The current Grade is now A (outstanding violations 04N 08A). Do you know when the hearing took place to change from B to A? and when the "Grade A" card was mailed? Your public database only shows 11/1/2017 (which was the date of the inspection = B. not the date it was upgraded to A). Thanks for your help and best regards,

No URL Submitted.

Thank you for your enquiry. *** currently has an A grade in Open data and on the DOHMH website. The hearing was conducted on 12/15/17 and the Tribunal “A” grade card was issued that day. The Notice of appearance shows that an authorized representative represented the respondent and signed for the hearing decision.

If you would like a replacement grade card:

Food Service Operators should print the Replace a Grade Card form (PDF), complete it and have it notarized.

The form must be submitted in person at the:
Bureau of Food Safety and Community Sanitation
125 Worth Street, Room 1020
New York, New York 10013
Hours : 9am-4pm Monday-Thursday; 9am-12pm Friday

Operators must have current government issued-photo identification to receive the replacement card.
Mail-in requests are not accepted.

Thank you

Closed

2018-01-26T00:00:00.000

2026-10-02T00:00:00.000

2982

Data Question

Agency not assigned yet.

Hello, this data set has not been updated since December 8, 2017. Can HPD start updating daily as this data is time sensitive? Please advise and thank you.

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that Open Market Order (OMO) Charges dataset was updated with the latest information. Your request for daily updates for this dataset will be taken under consideration by the agency.
https://data.cityofnewyork.us/Housing-Development/Open-Market-Order-OMO-Charges/mdbu-nrqn


Thank you,
-NYC Open Data

Closed

2018-01-24T00:00:00.000

2026-10-02T00:00:00.000

2972

Data Question

Agency not assigned yet.

Why hasn't HPD updated this data since November? And can they start updating daily, like violations?

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that Invoices for Open Market Order (OMO) Charges dataset was updated with the latest information. Your request for daily updates for this dataset will be taken under consideration by the agency.
https://data.cityofnewyork.us/Housing-Development/Invoices-for-Open-Market-Order-OMO-Charges/emrz-5p35
Thank you,
-NYC Open Data

Closed

2018-01-22T00:00:00.000

2026-10-02T00:00:00.000

2971

Reported Error

Department of Buildings (DOB)

violation *** appears "Active" in the data set however the violation is "resolved" on DOB

http://a810-bisweb.nyc.gov/bisweb/ECBQueryByNumberServlet?ecbin=34308101L&go7=+GO+&requestid=0

DOB ECB Violations

https://data.cityofnewyork.us/d/6bgk-3dad

We sometimes experience a delay in file updates. We believe the entries to be reconciled now and invite you to revisit the data set.

Thank you,
DOB Open Data Coordinator

Closed

2018-01-22T00:00:00.000

2026-10-02T00:00:00.000

2969

Data Question

Department of Consumer and Worker Protection (DCWP)

This is an answer to your follow up question: It is the first! So dry cleaner with actual dry cleaning machines vs dry cleaners that outsource (aka drop shops).

Also, is there a way to determine how many are Korean-owned?

Also, is there a way to have a continuous feed so I can reply in real time?

Issued Licenses

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

Greetings,

Thank you for contacting NYC Open Data Help Desk.

Dry Cleaners are not required to maintain a DCA-issued license. DCA does not have any mechanism for generating nor maintaining the datasets as requested, and therefore is not able to fulfill this request.
From the Industrial Laundry License page (http://www1.nyc.gov/site/dca/businesses/license-checklist-industrial-laundry.page):

“Laundry services” means washing, drying, starching, or ironing laundry for a fee. “Laundry services” does not include dry cleaning. [emphasis added]

For a list of DCA-Licensed business categories, please visit http://www1.nyc.gov/site/dca/businesses/licenses-apply.page

General inquiries can be made through DCA’s “Contact Us” page (http://www1.nyc.gov/site/dca/about/contact-us.page)


Thank you,
-NYC Consumer Affairs Department

Closed

2018-01-22T00:00:00.000

2026-10-02T00:00:00.000

2965

Reported Error

Department of Buildings (DOB)

Data does not match description of the dataset

Property Data (Buildings Information System) - Now Retired

https://data.cityofnewyork.us/d/e98g-f8hy

Greetings,

Thank you for contacting NYC Open Data Help Desk. As per agency's response, Department of Buildings (DOB) is currently working on improvements to this dataset to more accurately reflect its title and original intent.

Thank you,
- NYC Open Data

Closed

2018-01-22T00:00:00.000

2026-10-02T00:00:00.000

2958

Reported Error

Department of Health and Mental Hygiene (DOHMH)

Much of the geographic information in this data set is contradictory or incorrectly formatted. There are a number of examples where the Borough/NTA/Community District/Zip Code will contradict one another. Additionally, the census tract numbers are incorrectly formatted. In cases where the the tract number has a decimal point, the decimal point has been removed. This makes it very difficult to reformat in order to join the data set with census tracts.

NYC Dog Licensing Dataset

https://data.cityofnewyork.us/d/nu7n-tubp

Greetings,

Thank you for contacting NYC Open Data Help Desk.

For the Census Tract information, please be advised that "...in computer-readable files prepared by the Census Bureau and for files uploaded for FCC Form 477, the decimal point is implied and does not appear." For more information, please refer to
https://transition.fcc.gov/form477/Geo/more_about_census_tracts.pdf


Thank you,
-NYC Open Data

Closed

2018-01-18T00:00:00.000

2026-10-02T00:00:00.000

2956

Data Question

New York City Fire Department (FDNY)

In this dataset, there is no specific locations of incidents. Can I by any chance get approach to the location information? Thanks!

Fire Incident Dispatch Data

https://data.cityofnewyork.us/d/8m42-w767

HIPAA and other privacy laws do not allow us to release location information for public use.

Closed

2018-01-17T00:00:00.000

2026-10-02T00:00:00.000

2955

Data Question

Agency not assigned yet.

I was wondering whether pooled data from all the public hospital systems in NYC are available for use by researchers. I am trying to find out how many people were tested for infection with the bacteria helicobacter pylori in NYC public hospitals, and what % of them had a positive test result. Can anybody put me in touch with someone who can help me? Any guidance is greatly appreciated!
Warm regards,

No URL Submitted.

Hello

The data is not collected by agency. Please contact Health & Hospitals

Closed

2018-01-17T00:00:00.000

2026-10-02T00:00:00.000

2954

Reported Error

311

Hi, In this above URL we have grid if i filter Agency as "DOT" and Created Date between 01/15/2018 12:00:00 AM to 01/16/2018 12:00:00 AM i got 520 records, on daily basis we are using api URL "https://data.cityofnewyork.us/resource/fhrw-4uyv.csv" this csv contains only 72 records. how can i get daily basis all records which is available in the above Data set URL

311 Service Requests from 2020 to Present

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

Thank you for contacting NYC Open Data Help Desk. Please don't hesitate to reach out to us again if this error persists.

Thank you,
-NYC Open Data

Closed

2018-01-17T00:00:00.000

2026-10-02T00:00:00.000

2952

Data Question

Department of Finance (DOF)

Is the Revised Notice of Property Value (RNOPV) only the revisions to assessed or market values that were corrected? If so, do you ever release the NOPV and when?

Revised Notice of Property Value (RNOPV)

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

Greetings,

Thank you for contacting NYC Open Data Help Desk.

RNOPV can be generated based on the several reasons: Change in Market Value, change in Assessed Value, change of Exemptions value. It is posted on the web (same way as NOPV). There are mandatory and optional dates for RNOPV processing.

Tax Class

Computer Entry Deadline Date

Mailing/Web posting Date

1, 1A, 1B, 1C & 1D

2/9/2018

2/14/2018



2, 2A, 2B & 2C

2/9/2018

2/14/2018



All Optional

3/13/2018

3/16/2018



All Optional

4/3/2018

4/9/2018



4

4/23/2018

4/26/2018



Final run on the night of rollover to the Final Period (actual date may change)

5/18/2017

5/22/2017

Thank you,
- NYC Department of Finance

Closed

2018-01-16T00:00:00.000

2026-10-02T00:00:00.000

2947

Reported Error

Agency not assigned yet.

Hi,

I am very curious about the NYC Street Tree Census Data. Who maintains the data set? I would like to email with this person to discuss analysis of its data.

Thank you,
David

No URL Submitted.

Good morning,

Thank you for contacting NYC Parks regarding the Street Tree Census datasets on the Open Data Portal. I am happy to connect you with the best person to answer your questions. Can you elaborate generally on the questions you have about the datasets?

Best,

Closed

2018-01-15T00:00:00.000

2026-10-02T00:00:00.000

2946

Data Question

Agency not assigned yet.

The Rodent Inspectation dataset has X/Y coordinate fields that are listed in "New York State Plane." Because New York is broken up into several state plane systems, I have been assuming this is Long Island State Plane which covers the NYC area.

I have been using ArcGIS 10.4.1 and none of the listed Long Island State Plane systems have managed to project the points correctly so that they overlap with shapefiles in the attempted projection. I have tried:
- NAD 1983 (2011) (meters)
- NAD 1983 (COR96) (meters)
- NAD 1983 HARN (meters)
- NAD 1983 NSRS2007 (meters)
- NAD 1983 StatePlane Long Isl FIPS 3104 (meters)

Can you please provide the correct State Plane system for me to project the data? Either that or a shapefile/feature class of the data correctly projected in a known projection?

I have also tried downloading a shapefile from NYC Open Data but none of them come as "New York State Plane" instead they come in WGS1984.

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. As per the data owner's recommendation, you are encouraged to utilize NAD_1983_StatePlane_New_York_Long_Island_FIPS_3104_Feet.

Thank you,
-NYC Open Data

Closed

2018-01-15T00:00:00.000

2026-10-02T00:00:00.000

2943

Reported Error

Department of Housing Preservation and Development (HPD)

Hello -- I recently read an article about a "slumlord" landlord and was motivated to conduct research into slumlord behavior. However, I'm unable to find data related to that landlord and am worried there might be an error.

The building I was trying to find is at: "***". Here's the article as well: https://patch.com/new-york/prospectheights/flippers-playbook-how-nyc-slumlords-terrorize-tenants-get-away-it

I could not find either any complaints in the Complaints dataset (https://data.cityofnewyork.us/Housing-Development/Housing-Maintenance-Code-Complaints/uwyv-629c)

or even a listing of the building in the Buildings/Registrations datasets (https://data.cityofnewyork.us/Housing-Development/Buildings-Subject-to-HPD-Jurisdiction/kj4p-ruqc).

Please let me know if I am not looking up the data correctly or if there is an error with the data.

Thanks in advance for your help.

Housing Maintenance Code Complaints

Greetings,

Thank you for contacting the NYC Open Data Desk Help.
Although we did not find any related entries in the Buildings Subject to HPD Jurisdiction dataset, we were able to find 31 complaint records in the Department of Building's dataset DOB Complaints Received - https://data.cityofnewyork.us/Housing-Development/DOB-Complaints-Received/eabe-havv/data
Entering "80 New York Avenue" value in the search box and filtering the BIN column for "***" value should return a list of complaints for this address dating from 2015 through November 2017.

Thank you
-NYC Open Data

Closed

2018-01-11T00:00:00.000

2026-10-02T00:00:00.000

2941

Data Question

Department of Buildings (DOB)

I am trying to download the DOB Permit Issuance dataset. it has 3.3 million rows, hence Excel does not have enough rows. I could filter the data (I only need data for Residential Permits in Manhattan, which has only about 350k rows), but the system does not give an option to download the filtered data. Is there a way for me to download this information. Thank you very much!!

DOB Permit Issuance

Greetings,

Thank you so much for contacting NYC Open Data Help Desk.

Filtering this dataset for these conditions (Borough is MANHATTAN and Residential is YES) should produced a view with 343,109 rows. You can double check the row count in About--->Row Count tab.
Once the number of rows is confirm, please use Export function to download the data in a format of your choice. Only 343K rows will be downloaded.

Thank you,
-NYC Open Data

Closed

2018-01-11T00:00:00.000

2026-10-02T00:00:00.000

2936

Data Question

Agency not assigned yet.

In the portal how do I search for a FDNY violation number? I put the # in the search field and doesn't show up with any result.

No URL Submitted.

Greetings,

You are encouraged to utilized Socrata's Filter feature. You can find more information on how to use this feature at https://support.socrata.com/hc/en-us/sections/200469748-Filtering-Datasets

Thank you,
-NYC Open Data

Closed

2018-01-10T00:00:00.000

2026-10-02T00:00:00.000

2933

Data Question

Agency not assigned yet.

The file name of the data set states, 2014,created March 2015 and last updated September 28, 2017 and is updated quarterly. Therefore is the data accurate as of September 28, 2017 and I should be seeing a quarterly update soon? Thanks

No URL Submitted.

Greetings,

Thank you for contacting the NYC Open Data Help Desk. Please note that that the update in September 2017 only involved changes to this dataset's metadata, and not the actual data. We have reached out to the agency and awaiting their reply to your request.
At this time, the agency is still working on updating this dataset. You are encouraged to subscribe to ​this dataset to receive update notifications - https://support.socrata.com/hc/en-us/articles/202949718-Subscribe-to-a-dataset-to-follow-updates
Thank you,
-NYC Open Data

Closed

2018-01-09T00:00:00.000

2026-10-02T00:00:00.000

2932

Reported Error

Department of Consumer and Worker Protection (DCWP)

Hi,

I tried to click on the "View your submission" icon and it says the page cannot be found.

Also, is there a way to distinguish between drop shops vs. dry cleaners with actual machines/plants?

Thank you!

Best,

Issued Licenses

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

Greetings.

Thank you for contacting NYC Open Data Help Desk. In order to accurately respond to your question, a data owner requested the following clarification:

"Are we looking for dry cleaners with actual dry cleaning machines ‎vs dry cleaners that outsource OR dry cleaners (with or without dry cleaning machines) vs laundromats with laundry machines where you can drop off and pick your dry cleaning?"

Thank you,
-NYC Open Data

Closed

2018-01-09T00:00:00.000

2026-10-02T00:00:00.000

2930

Data Question

Agency not assigned yet.

Hello, I've built an integration for one of our clients to pull DOB violation data into their system periodically which is working fine but they requested the ability to view the violation in the DOB system by clicking a link. Is there an easy way to do this?

It seems that a violation may exist in one of two places currently (BIS or DOBnow) and there is no way to tell where it can be seen based on the data returned by the API. I'm also not aware of a way to construct a URL to go directly to a violation in either system. Even performing searches by BIN in either system sometimes doesn't lead to the violation retrieved via the API. Can you recommend a solution for this?

No URL Submitted.

First, I want to make sure that you're aware that we have two datasets for different types of violations: DOB ECB Violations and DOB Violations. You should use both types in your analysis. The only difference is in how they get resolved: ECBs are adjudicated by OATH, and DOBs are resolved directly with DOB.

To link to our Buildings Information System (BIS), you can construct a URL using the unique identifiers.

For ECB, you would use the ECB_VIOLATION_NUMBER column. As an example, 34830294Z would go tohttp://a810-bisweb.nyc.gov/bisweb/ECBQueryByNumberServlet?ecbin=34830294Z&go7=+GO+&requestid=0

For DOB, you would use the NUMBER column. As an example, V*081511E9027/395554 would go to http://a810-bisweb.nyc.gov/bisweb/ActionViolationDisplayServlet?requestid=4&allbin=1046919&allinquirytype=BXS3OCV4&allboroughname=&allstrt=&allnumbhous=&allisn=0001603651&ppremise60=081511E9027/395554

Barring any data quality issues, this should work for all DOB and ECB violations. And if you run into quality issues, please feel free to report them .

Thank you,

Closed

2018-01-09T00:00:00.000

2026-10-02T00:00:00.000

2928

Reported Error

Agency not assigned yet.

Hello,

ACRMD a nonprofit organization is interested in leasing properties from the City of New York.
. Warehouse distribution space
. Office space with 10,000 to 15,000 square feet.

Please provide a list of locations in the borough of the Bronx.

Thank you

No URL Submitted.

That's not actually in the Department of Buildings jurisdiction. You will have to reach out to Citywide Administrative Services (DCAS) for that. Here's more information on how to do so: http://www.nyc.gov/html/dcas/html/business/real_estate_leasing.shtml

Thank you,
- DOB Open Data Coordinator

Closed

2017-12-11T00:00:00.000

2026-10-02T00:00:00.000

2921

Reported Error

Agency not assigned yet.

The latitude and longitude columns are integers (whole numbers) so they cannot be mapped.

No URL Submitted.

Please check out the current dataset for Farmer Market locations . We've also added Food Box locations as well.

Thank you

Closed

2018-01-08T00:00:00.000

2026-10-02T00:00:00.000

2911

Reported Error

Agency not assigned yet.

I think there is either errors in data or a bug in the search process. I communicated this earlier and at your suggestion changed an '=' search to a 'like' search but the problem persists either way. I have many cases where a plate search returns no records but I can successfully search for a ticket, for that plate, by its summons number. The following URL's illustrate an example: https://data.cityofnewyork.us/resource/uvbq-3m68.json?$where=(plate%20LIKE%20'202568840'%20AND%20state='IN')&$$app_token=QYpRdKb6MrDbczi7vVFcL0m05

https://data.cityofnewyork.us/resource/uvbq-3m68.json?$where=(summons_number=8520029371)&$$app_token=QYpRdKb6MrDbczi7vVFcL0m05

This is greatly impairing our usage of an otherwise great facility.

No URL Submitted.

Greetings,

We believe that this query should read:
https://data.cityofnewyork.us/resource/uvbq-3m68.json?%24where=(plate%20LIKE%20%272568840%27%20AND%20state=%27IN%27)

Looking at the first query that returned no results, it appears that there are extra digits present.The original query is looking for a plate number "202568840".

Thank you,
-NYC Open Data

Closed

2018-01-04T00:00:00.000

2026-10-02T00:00:00.000

2909

Data Question

Mayor's Office of Media and Entertainment (MOME)

Hello there! We are looking at the Film Permit data here: https://data.cityofnewyork.us/City-Government/Film-Permits/tg4x-b46p/data for a data competition. Are you able to add in the Project title to this data for us so we can see what movie or TV show it was requested by? Thanks!

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.

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

Closed

2018-01-03T00:00:00.000

2026-10-02T00:00:00.000

2906

Data Question

Agency not assigned yet.

Looking for data on new building permits (Number per years per boro) for new construction.

No URL Submitted.

Hi,

You can find the number of new building permits per year in our DOB Permit Issuance dataset. You will want to filter Job Type for NB (New Building) and also filter Work Type for NB to make sure you get the right data.

Thank you,
- , DOB Open Data Coordinator

Closed

2017-12-29T00:00:00.000

2026-10-02T00:00:00.000

2905

Reported Error

Department of Finance (DOF)

We are finding an inconsistency in the Traffic ticket data. When we search on a particular plate there is no data found. But if we search for a known ticket number for that plate the ticket is found on the site and shows the plate number that we were unable to search on. We noticed this using the API but it also seems to occur on the web page as well. Example - Plate: ***, Summons ***

Open Parking and Camera Violations

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

Greetings,

Please note that the "Plate" column is of a plain text type, and not a numeric value. You are encouraged to filter this dataset using Plate contains search criteria instead of Plate is. Using Plate is *** criteria returned 143 records with the Summons *** omitted. Using Plate contains *** returned 144 records, and included the record for the Summons ***.

Thank you,
-NYC Open Data

Closed

2017-12-28T00:00:00.000

2026-10-02T00:00:00.000

2900

Reported Error

Department of Education (DOE)

when I download the csv file then 1885 obs. of 26 variables but when I copied the API endpoint and use jsonlite package in R then1000 obs. of 26 variables. Why is not the csv file and API having the same number of observation and variables and also in the same order?

Universal Pre-K (UPK) School Locations

https://data.cityofnewyork.us/d/kiyv-ks3f

Greetings,

1,000 is a default amount of rows that are returned by a json query in Socrata. You have an option to increase a number of rows using a limit paramater. For more information, please refer to https://dev.socrata.com/docs/queries/

Thank you,
-NYC Open Data

Closed

2017-12-27T00:00:00.000

2026-10-02T00:00:00.000

2893

Data Question

Agency not assigned yet.

Can you add a metadata file for all the poverty measure datasets?

Below is one of the datasets from 2005-2010
https://data.cityofnewyork.us/City-Government/NYCgov-Poverty-Measure-Dataset-2005-2010-/9udg-56qp

No URL Submitted.

Greetings,

The data dictionaries containing metadata for the datasets of these series should be made available within 30 days of these datasets' release to public as mandated by the Local Law of 2015.

Thank you,
-NYC Open Data

Closed

2017-12-22T00:00:00.000

2026-10-02T00:00:00.000

2891

Data Question

Department of Buildings (DOB)

Hi,
This data sets doesn't seem to be updating daily the last few days. The last update was on Dec 18th. Could you please update it to include Dec 19-21st.
Thanks so much

DOB Permit Issuance

Greetings,

DOB Permit Issuance dataset is now updated with the latest information. We apologize for this interruption in daily updates.
https://data.cityofnewyork.us/Housing-Development/DOB-Permit-Issuance/ipu4-2q9a/data

Thank you,
-NYC Open Data

Closed

2017-12-21T00:00:00.000

2026-10-02T00:00:00.000

2890

Data Question

Agency not assigned yet.

I need some help with definitions of acronyms:
What do the acronyms for the various license types stand for?What do the codes EQ and EW under "Permit Type" represent?
What when I use the provided URL for a complete list: http://www.nyc.gov/html/dob/downloads/pdf/bisjobstatus.pdf
I get the following error message:


You have reached an outdated page on NYC.gov, the Official New York City website.
Thanks

No URL Submitted.

Hi,

The link you should use for those codes is http://www1.nyc.gov/assets/buildings/pdf/bisjobsta...
EQ and EW both refer to different types of equipment installation or work as indicated on that PDF.

Where did you get the other link? I'd like to make sure we update it.

Thank you,
- , DOB Open Data Coordinator

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

Closed

2017-12-21T00:00:00.000

2026-10-02T00:00:00.000

2886

Reported Error

311

This is a significant issue with service requests being tagged with "01 Manhattan" that are NOT in Manhattan community board 1. We're talking 1,000s of miss tagged service requests. This is a new issue.

311 Service Requests from 2020 to Present

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

Thank you for contacting NYC Open Data Help Desk. ​311 Service Requests from 2010 to Present dataset was updated and this discrepancy resolved. Please let us know if this error persists.
​
​https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9/data
​
Thank you,
-NYC Open Data

Closed

2017-12-18T00:00:00.000

2026-10-02T00:00:00.000

2874

Data Question

Department of Buildings (DOB)

I've been attempting to link the Job Applications dataset with the DOB Permits Issuance dataset (https://nycopendata.socrata.com/Housing-Development/DOB-Permit-Issuance/ipu4-2q9a/data). Ultimately we want to create a dataframe that connects planned building characteristics to permits. I've been attempting to use Job # as a key but I wind up with observations in each dataset which are not in the other. The distribution of various date columns does not provide a great deal of insight. My presumption was that any permit would need to be attached to a job. I have noticed that BBL links the two but this doesn't seem like the most appropriate foreign key. Could you provide some insight into how these two datasets relate to each other?

DOB Job Application Filings

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

You are right: Job # is the key that should match these two datasets (DOB Job Application Filings and DOB Permit Issuance). Here are some parameters that will help troubleshoot this:

All permits should be connected to a job.
The jobs dataset only goes back to about 2014, and permits may be issued for jobs that are older.
Only jobs that have a status of Q, R, U, or X will have permits.
We are in the midst of applying a refresh to these datasets to correct an issue where Status was not updating. Permits should now provide updates whenever the permit status changes. Jobs should be fixed by the end of the year.
If you apply those parameters, you shouldn't see any permits without jobs. You can also check specific use cases by looking up the job or permit # in our Buildings Information System (BIS).

If you still have questions or still find anomalies, please let me know.

Thank you,

Closed

2017-12-12T00:00:00.000

2026-10-02T00:00:00.000

2870

Reported Error

Agency not assigned yet.

The telephone number listed for the Mayor's Office of Sustainability is incorrect (it should be 212-676-0754) and the URL should link to our website, which is: nyc.gov/sustainability.

No URL Submitted.

Greetings,

Thank you for contacting the NYC Open Data team. Since this incorrect information is listed on the nyc.gov, you are encouraged to provide an updated contact information through the City Agency Feedback page:
http://www1.nyc.gov/nyc-resources/service/4381/cit...

Please let us know if you will need further assistance.

Thank you,
-NYC Open Data

Closed

2017-12-11T00:00:00.000

2026-10-02T00:00:00.000

2867

Reported Error

Department of Citywide Administrative Services (DCAS)

Some data are missing. For example, the Job ID *** does not exist on the dataset, but it exists on NYC Jobs. Check this link https://a127-jobs.nyc.gov/index_new.html?keyword=313791. Thank you.
Today's updated the *** showed up. However, some data are still missing. Check the Job ID ***. Also, some Job IDs are invalid. For example, ID *** cannot find in NYC Jobs, but it is in Open Data dataset. Thank you.

Jobs NYC Postings

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that NYC Jobs dataset was updated on 1/24/2018. As per agency's statement, a slight discrepancy in data is caused by the fact that the dataset on the NYC Open Data portal is updated weekly, while the agency's database hosted on the nyc.gov is refreshed everyday.
https://data.cityofnewyork.us/City-Government/NYC-Jobs/kpav-sd4t/data

Thank you,
-NYC Open Data

Closed

2017-12-12T00:00:00.000

2026-10-02T00:00:00.000

2859

Data Question

Department of Citywide Administrative Services (DCAS)

Are there instructions on how to use NYC Open Data Current Solicitations?

Current Solicitations

https://data.cityofnewyork.us/d/3khw-qi8f

Greetings,

Please refer to the data dictionary that can be found in the About--->Attachments section. If you have a specific question regarding this dataset that is not covered by the data dictionary, please kindly let us know and we will forward your request to the agency.

Thank you,
-NYC Open Data

Closed

2017-12-07T00:00:00.000

2026-10-02T00:00:00.000

2854

Data Question

New York City Police Department (NYPD)

For the Data Table "NYPD Motor Vehicle Collisions", I am trying to visualize my data with "Time" on the x-axis and accident count on the y-axis, it lists the bars not chronologically, but from greatest to least. I want them to be arranged chronologically. How do I do this?

Motor Vehicle Collisions - Crashes

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

Greetings,

On the left hand-side, please select "Axis" tab and then "Chart Sorting" option. You will have a choice of sorting a label (in this case it is "Time" column on the x-axis) either in ascending or descending order. For more information how to use Socrata's visualization tool, please refer to https://support.socrata.com/hc/en-us/sections/200469728-Data-Visualizations

Thank you,
-NYC Open Data

Closed

2017-12-06T00:00:00.000

2026-10-02T00:00:00.000

2841

Data Question

Department of Social Services (DSS)

Can you please help me? What should be the license for this dataset??

DHS Daily Report

https://data.cityofnewyork.us/d/k46n-sa2m

Greetings,

This data is not subject to any copyright or license restrictions at all. You are free to use all the data on the NYC Open Data Portal in whatever way you wish.

Best,
-NYC Open Data

Closed

2017-11-30T00:00:00.000

2026-10-02T00:00:00.000

2839

Data Question

Agency not assigned yet.

When is the next version of Pluto being released? thanks

No URL Submitted.

Hello,

The Department of City Planning expects to have new version of PLUTO and MapPLUTO available in January 2018.

Closed

2017-11-29T00:00:00.000

2026-10-02T00:00:00.000

2836

Data Question

New York City Housing Authority (NYCHA)

I am trying to compare the month of October in 2012 to 2016. When I broke the data down to Manhattan for those two months, I wanted to compare the KWH charges and consumption rates between the two years. I am calculated the averages and it looks like the average 2016 KWH Consumption is higher than 2012 but the average charges are a lot lower than the 2012 charges. Could you explain why that might be?

Electric Consumption And Cost (2010 - Sep 2025)

https://data.cityofnewyork.us/d/jr24-e7cr

Greetings,

NYCHA is a NYPA customer for electric utility. NYCHA buildings fall under four rate class. All rates have been decreasing since 2012. The authority wide average electric rate in 2012 was $0.145 and in 2016 it was $0.116. The electric and natural gas market was lower across the country in 2016.


Thank you,
-NYC Open Data

Closed

2017-11-29T00:00:00.000

2026-10-02T00:00:00.000

2828

Data Question

Agency not assigned yet.

I am looking to download specific 311 Call Center Inquiry Data, but the interface does not allow me to download 311 data with applied filters, only the full file with +65 million entries (prohibitively large files to download). The specific inquiry I am looking for is: Syringes on Sidewalk or Street --> Report of loose syringes on a City street or sidewalk --> Call Resolution. Please forward this filtered data. If you can provide data on location of call, whether it is by borough, community district, and/or zip code, that would be ideal given the question that we are trying to answer.

No URL Submitted.

the requested filtered view is available for download in .csv format at this URL:
https://data.cityofnewyork.us/resource/wewp-mm3p.csv?$where=inquiry_name like '%25Syringes%25'&$limit=10000

Closed

2017-11-27T00:00:00.000

2026-10-02T00:00:00.000

2827

Data Question

Department of Education (DOE)

In Universal Pre-K (UPK) School, there are values that were not populated in the CSV file. For example, the Council Member district number variable values were not populated in some cases. Can you please post the csv file that has ZERO missing value on this variable? thanks

Universal Pre-K (UPK) School Locations

https://data.cityofnewyork.us/d/kiyv-ks3f

Greetings,

The Universal Pre-K (UPK) School Locations dataset is now updated on the NYC Open Data portal, and all the missing values for the "Community Board" and "Council District" columns are now provided - https://data.cityofnewyork.us/Education/Universal-Pre-K-UPK-School-Locations/kiyv-ks3f

Best,
-NYC Open Data

Closed

2017-11-27T00:00:00.000

2026-10-02T00:00:00.000

2825

Data Question

Department of Finance (DOF)

What is an admin claim and an appeal? I have been searching for for traffic violation admin claims, but have not been able to find anything. The info sheet for the data has no additional information either.

Open Parking and Camera Violations

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

Greetings,

The term “admin claim” is short for “administrative claim” which is a claim that is made by a respondent that is researched and decided upon administratively by the Department of Finance (DOF). The term “appeal” refers to the scenario of a second hearing that may be conducted when a respondent appeals the decision made by an Administrative Law Judge “ALJ” during a previous hearing.

Thank you,
-NYC Open Data

Closed

2017-11-25T00:00:00.000

2026-10-02T00:00:00.000

2824

Data Question

Agency not assigned yet.

the error message i get is :The current user doesn't have access to this view
https://maps.nyc.gov/crime/
shape file : NYC crime data - location I am doing a project for my finals on ****.
I am looking for hotspots around *** to see if most of the crimes are committed close to the bars in this area, or if the crimes are sex and drugs related

- The open data, says i do not have access ot his inofmration, can you hep me ?

No URL Submitted.

----------

​Thank you for contacting NYC Open Data Help Desk. Please refer to the NYPD shapefile at this URL
​ https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Historic/qgea-i56i
​
Thank you,
-NYC Open Data

Closed

2017-11-25T00:00:00.000

2026-10-02T00:00:00.000