NYC Open Data Help Desk: Data Questions and Reported Errors

This is a list of responses to public inquiries to the NYC Open Data Team via the Contact Us page on www.nyc.gov/opendata that get triaged as being “Data Questions” and “Reported Errors.”

City Government NYC Open Data Team Dataset r67x-e97r 10 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
3407
Inquiry Id: 3407 • Inquiry Type: Reported Error • Assigned Agency: 311
Inquiry Id
3407
Inquiry Type
Reported Error
Assigned Agency
311
Inquiry
I can no longer create a visualization. When I click "Visualize" -> "Create Visualization", I see "We're having trouble displaying this table. Check to make sure the underlying dataset hasn't been deleted or unpublished."

Is the site down? Is the feature disabled? Will this come back up?
Dataset Name
311 Service Requests from 2020 to Present
Dataset Url
https://data.cityofnewyork.us/d/erm2-nwe9
Assigned Agencys Response
​Thank you for contacting NYC Open Data Help Desk. The visualization feature seems to be working properly for 311 and other datasets. Please let us know if this issue persists.
​
​You are also encouraged to contact Socrata support for platform's technical issues/questions at https://support.socrata.com/hc/en-us/requests/new
​
Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-24T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3402
Inquiry Id: 3402 • Inquiry Type: Reported Error • Assigned Agency: Department of Housing Preservation and Development (HPD)
Inquiry Id
3402
Inquiry Type
Reported Error
Assigned Agency
Department of Housing Preservation and Development (HPD)
Inquiry
Hello, it appears that certain "inspection fees" are not being displayed in this file. *** have fees on the building charge report from HPD that are not in the data file
Dataset Name
Fee Charges
Dataset Url
https://data.cityofnewyork.us/d/cp6j-7bjj
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. Can you kindly provide us with more details on the missing records. We found one record listing the address above (FeeID ***; dated 01/02/2018). Also please keep in mind that this dataset is updated once a month (last update date - 04/02/2018), and might not include the latest information.

Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-24T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3400
Inquiry Id: 3400 • Inquiry Type: Data Question • Assigned Agency: Agency not assigned yet.
Inquiry Id
3400
Inquiry Type
Data Question
Assigned Agency
Agency not assigned yet.
Inquiry
Can I get they quantity of bags on this previously awarded contract
Contract #:***
Date: ***
Amount: $***
Vendor awarded: ***C
Description: Rock Salt 50 lb. bags - MTA NYCTA Contract
Dataset Url
No URL Submitted.
Assigned Agencys Response
In response to your inquiry concerning the previous contract awarded by MTA NYCTA to Dart Seasonal Products for Rock Salt, 50 lb. Bags, I would recommend that you contact NYCTA directly. DCAS does not maintain records or data on NYCTA contracts.
Status
Closed
Date Submitted
2018-04-24T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3397
Inquiry Id: 3397 • Inquiry Type: Data Question • Assigned Agency: 311
Inquiry Id
3397
Inquiry Type
Data Question
Assigned Agency
311
Inquiry
Around April 20, 2018 this 311 dataset went from having 53 columns down to the current 41 columns. Is that a permanent change going forward? Or is that a problem with the data?
Dataset Name
311 Service Requests from 2020 to Present
Dataset Url
https://data.cityofnewyork.us/d/erm2-nwe9
Assigned Agencys Response
Thank you for contacting NYC Open Data. The 311 new column schema will contain 41 columns going forward. Please refer to http://www1.nyc.gov/311/nyc311-enhances-service-request-open-dataset.page for more information regarding the changes.

Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-24T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3394
Inquiry Id: 3394 • Inquiry Type: Data Question • Dataset Name: Citywide Payroll Data (Fiscal Year)
Inquiry Id
3394
Inquiry Type
Data Question
Assigned Agency
Financial Information Services Agency / Office of Payroll Administration (FISA-OPA)
Inquiry
What Boroughs are considered as 'Other'? Crucial information for the solution of a professional problem. Much appreciated!
Dataset Name
Citywide Payroll Data (Fiscal Year)
Dataset Url
https://data.cityofnewyork.us/d/k397-673e
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. The “other’ designation is a placeholder when no borough was assigned in PMS (Payroll Management System) by the agency.

Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-23T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3393
Inquiry Id: 3393 • Inquiry Type: Data Question • Assigned Agency: Agency not assigned yet.
Inquiry Id
3393
Inquiry Type
Data Question
Assigned Agency
Agency not assigned yet.
Inquiry
How can I find a list of all licensed scaffolding companies, including their license verification and contact information? Thanks.
Dataset Url
No URL Submitted.
Assigned Agencys Response
The dataset you requested does not exist. We do not license companies to install scaffolds. We allow Professional Engineers (PEs), Registered Architects (RAs) or General Contractors to apply for a permit to install sheds and scaffolds. You can get a list of licensed General Contractors in our DOB License Info dataset. PEs and RAs are licensed by New York state, so you would have to get the list of licensees from their data.
Status
Closed
Date Submitted
2018-04-23T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3392
Inquiry Id: 3392 • Inquiry Type: Reported Error • Assigned Agency: Agency not assigned yet.
Inquiry Id
3392
Inquiry Type
Reported Error
Assigned Agency
Agency not assigned yet.
Inquiry
This concerns the Multi Agency Permits dataset (https://data.cityofnewyork.us/City-Government/Multi-Agency-Permits/xfyi-uyt5/data) source Mayor's Office of Data Analytics (MODA).
The dataset contains at least one wrong address. For my building, BIN ***, the address listed is***. If you look at the DOB's building profile (http://a810-bisweb.nyc.gov/bisweb/PropertyProfileOverviewServlet?boro=1&houseno=701%20&street=west%20end%20av&requestid=0&s=A03C41B885B461E4F46BD08866A7430E), there are many addresses, including*** and *** but NOT ***.
This wrong address is different from the address listed in the DOB Permit Issuance dataset (https://data.cityofnewyork.us/Housing-Development/DOB-Permit-Issuance/ipu4-2q9a/data#revert), and it ought to be the same. When you sort without filtering, the dataset falls apart with a date in the "source" field and much worse. The dataset also includes permits outside its stated universe (more than the two agencies named). So something is going wrong somewhere upstream.
Thanks for listening.
Dataset Url
No URL Submitted.
Assigned Agencys Response
​Thank you or contacting NYC Open Data Help Desk. After further review, we came to a conclusion that this dataset will require a major data and structural overhaul. You are strongly encouraged to utilize DOB Permit Issuance instead.
Status
Closed
Date Submitted
2018-04-23T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3389
Inquiry Id: 3389 • Inquiry Type: Data Question • Assigned Agency: Agency not assigned yet.
Inquiry Id
3389
Inquiry Type
Data Question
Assigned Agency
Agency not assigned yet.
Inquiry
Hi, can you provide some additional information on the specified data set to show more information about the centers. I am looking for information equivalent to what is found on the below link:

https://data.ny.gov/Human-Services/Child-Care-Regulated-Programs-API/fymg-3wv3

Example: Facility ID, Address, Tel, etc.
Dataset Url
No URL Submitted.
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. For up-to-date information on the NYC child care​ facilities, you are encouraged to utilize the following resource: https://a816-healthpsi.nyc.gov/ChildCare/SearchAction2.do
Status
Closed
Date Submitted
2018-04-21T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3386
Inquiry Id: 3386 • Inquiry Type: Data Question • Assigned Agency: Agency not assigned yet.
Inquiry Id
3386
Inquiry Type
Data Question
Assigned Agency
Agency not assigned yet.
Inquiry
I’m trying to get the entire FDNY Fire list #7029.
Any way I can find an archive ?
Dataset Url
No URL Submitted.
Assigned Agencys Response
The list for Exam #7029, Firefighter (1999), was invalidated by court order.
Status
Closed
Date Submitted
2018-04-20T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3378
Inquiry Id: 3378 • Inquiry Type: Reported Error • Assigned Agency: Department of Buildings (DOB)
Inquiry Id
3378
Inquiry Type
Reported Error
Assigned Agency
Department of Buildings (DOB)
Inquiry
HI, I'm trying to set up an ODATA connection to a data visualization application but I receive an error message stating the server closed the connection to the data.
Dataset Url
DOB Permit Issuance
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. For technical issues related to the platform, please contact Socrata support at https://support.socrata.com/hc/en-us/requests/new
​It would be helpful to provide their support with additional information and a screenshot of the error.
​​
Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-18T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3377
Inquiry Id: 3377 • Inquiry Type: Data Question • Assigned Agency: Department of Finance (DOF)
Inquiry Id
3377
Inquiry Type
Data Question
Assigned Agency
Department of Finance (DOF)
Inquiry
Hello!
I dont understand what the column 'Violation Post Code' means. Hope you can help me understand it! Thank you!
Dataset Name
Parking Violations Issued - Fiscal Year 2016
Dataset Url
https://data.cityofnewyork.us/d/kiv2-tbus
Assigned Agencys Response
The data field “Violation Post Code” reflects the location post code of violation. Each traffic agent is assigned a post or route each day before heading out in the field to issue summonses.
Status
Closed
Date Submitted
2018-04-18T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3376
Inquiry Id: 3376 • Inquiry Type: Data Question • Assigned Agency: Department of Finance (DOF)
Inquiry Id
3376
Inquiry Type
Data Question
Assigned Agency
Department of Finance (DOF)
Inquiry
Hi,
I do not really understand the values of the 'Days Parking In Effect' column. Hope you could explain!
Thank you!
Dataset Name
Parking Violations Issued - Fiscal Year 2016
Dataset Url
https://data.cityofnewyork.us/d/kiv2-tbus
Assigned Agencys Response
The information reflected in the “Days Parking in Effect” data field for each listed summons is comprised of a data string made up of values of “B” (B representing “By-pass”) or “blank” (also meaning “By-pass”) or “Y” (representing “Yes”) to indicate the days of the week in which the parking rules are in effect. The point of this field is to indicate which days of the week the particular parking rule is in effect depending on the violation. The data string represents the 7 days of the week following day order of Sun/Mon/Tue/Weds/Thurs/Fri/Sat.
Status
Closed
Date Submitted
2018-04-18T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3375
Inquiry Id: 3375 • Inquiry Type: Reported Error • Assigned Agency: Department of Housing Preservation and Development (HPD)
Inquiry Id
3375
Inquiry Type
Reported Error
Assigned Agency
Department of Housing Preservation and Development (HPD)
Inquiry
In looking at your Housing Code Violations, I noticed that some of the data is incomplete. The NovIssueDate is blank for 100,000+ open violations. Would you be able to fill in these missing data points?
Dataset Name
Housing Maintenance Code Violations
Dataset Url
https://data.cityofnewyork.us/d/wvxf-dwi5
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. Please note that 96% of the violations missing an NOV Issue Date at the time this dataset was pulled are “Class I” violations. Class I violations are not truly violations, they are informational notices that according to this dataset's data dictionary, “...do not have certification periods associated; they indicate something about the status of the property: that an order is open against the property or that a property is vacant or that a properly is not validly registered.” Which explains why certification-related information is missing.

For the majority of the remaining violations, the certification date should be there at this time (the certification date is only provided after the Notice of Violation is generated for mailing). A very small percentage of violations may be associated with bad data and no certification date is available.

Please let us know if you have any other questions.

Thank you,
-NYC Department of Housing Preservation and Development
Status
Closed
Date Submitted
2018-04-18T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3371
Inquiry Id: 3371 • Inquiry Type: Reported Error • Assigned Agency: Department of Consumer and Worker Protection (DCWP)
Inquiry Id
3371
Inquiry Type
Reported Error
Assigned Agency
Department of Consumer and Worker Protection (DCWP)
Inquiry
This issue was pushed to socrata and they pushed it back.

Please address this issue!
Dataset Name
Issued Licenses
Dataset Url
https://data.cityofnewyork.us/d/w7w3-xahh
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. Please note that there are no technical issues with the Legally Operating Businesses dataset itself. The "Address ZIP" column does contain over 500 records with no value assigned or zero values, but it is data related, not a technical error. It might be helpful to note that "Address ZIP" is a text-type column, not a numeric type. In addition, some of the zipcode values have a leading zero and might require special handling. Since you are using a third-party tool, you are encouraged to refer to your program's documentation to resolve this issue.

Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-17T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3370
Inquiry Id: 3370 • Inquiry Type: Data Question • Assigned Agency: New York City Fire Department (FDNY)
Inquiry Id
3370
Inquiry Type
Data Question
Assigned Agency
New York City Fire Department (FDNY)
Inquiry
Within the NYC EMS Data, the ATOM column does not match with the atomic ID polygons that are publically available here: (https://www1.nyc.gov/site/planning/data-maps/open-data.page). Is there a publically available shapefile that does match the ATOM number in the EMS dispatch data and if so, which file is it?
Dataset Name
EMS Incident Dispatch Data
Dataset Url
https://data.cityofnewyork.us/d/76xm-jjuj
Assigned Agencys Response
Thank you for your interest in the EMS Dispatch dataset. The Atom refers to geographic areas used for EMS unit dispatching. We are currently reviewing HIPPA and other privacy laws to determine whether these geographic locations may be lawfully released. If we determine that it may be released, we will publish it to the Open Data site, otherwise the atom data point will be removed.
Status
Closed
Date Submitted
2018-04-17T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3367
Inquiry Id: 3367 • Inquiry Type: Data Question • Assigned Agency: Office of Administrative Trials and Hearings (OATH)
Inquiry Id
3367
Inquiry Type
Data Question
Assigned Agency
Office of Administrative Trials and Hearings (OATH)
Inquiry
To Whom It May Concern:

I am examining the OATH data uploaded to the NYC Open Data Portal and I have a few queries about the data.

For the hearingstatus variable, I am unable to find any information as to what some of the terms mean:
While I am aware that “ASSIGNED” means “summons had a hearing, the case is assigned, and a decision is pending but do the following mean, exactly: “ASSIGNED TO APPEALS”; “HRG BEFORE ASSIGN”; “PERFECTION REQUIRED”; “STAY REQUESTED”; “STAYED”; and STIPULATION OFFERED. For the last one, specifically, what is the difference between “STIP NEEDS REVIEW” (which means “Stipulation offered by enforcement agency (petitioner) and stipulation was accepted by respondent”) and “STIPULATION OFFERED”?

For the hearingresult variable, what does “COSRV INVIO” mean? Likewise for “POP IN-VIOL” and “SETTL IN-VIO”. I am unable to find any information on your website as to what they refer to. Also, how different are these 3 above-listed values from “IN VIOLATION” and what specifically does this mean? Are there overlaps in meaning?

Also, could you please enlighten me as to what the prefix “SAU” stands for in the scheduledhearinglocation and the decisionlocationborough variables. This prefix “SAU:” is placed before every borough. For example, “SAU: BKLN” or “SAU”MANH”.

Finally, I am not sure if this is a typo but in the violationdescription variable, besides “ASBESTOS”, “BAR”, “COMMERCIAL”, “FIRE”, “MULTIPLE DWELLING”, and “NOISE” there is the “1 -D142 2 FAMILY” value whose meaning I cannot fathom.

Thank you in advance for your time.
Dataset Name
OATH Hearings Division Case Status
Dataset Url
https://data.cityofnewyork.us/d/jz4z-kudi
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. Please see below the responses to your questions:
​
​For the hearingstatus variable, I am unable to find any information as to what some of the terms mean:
While I am aware that “ASSIGNED” means “summons had a hearing, the case is assigned, and a decision is pending but do the following mean, exactly: “ASSIGNED TO APPEALS”; “HRG BEFORE ASSIGN”; “PERFECTION REQUIRED”; “STAY REQUESTED”; “STAYED”; and STIPULATION OFFERED. For the last one, specifically, what is the difference between “STIP NEEDS REVIEW” (which means “Stipulation offered by enforcement agency (petitioner) and stipulation was accepted by respondent”) and “STIPULATION OFFERED”?

Assigned – Assigned to a hearing officer.
Assigned to Appeals – the summons has had an appeal filed and is with our appeals department
Hrg before assign – the summons was heard before OATH got a copy of it
Perfection Required -- An appeal has been entered but there is still paperwork that needs to be filed for the appeal to progress
Stay Requested – the respondent has filed a request to stay a case and prevent it from progressing (to default/docketing/collections etc.)
Stayed – For a variety of legal reasons (e.g., a respondent request, a hold pending some kind of negotiation or legal case), the case has a stay placed on it
Stipulation offered – this is a program that allows certain Buildings cases to be settled before a hearing subject to certain conditions. This indicator means that the offer of stipulation was sent out by OATH on behalf of the issuing agency.
Stip needs review – A respondent has accepted the offer of stipulation but for a variety of reasons, the stipulation may require intervention by OATH staff in order to be processed

For the hearingresult variable, what does “COSRV INVIO” mean? Likewise for “POP IN-VIOL” and “SETTL IN-VIO”. I am unable to find any information on your website as to what they refer to. Also, how different are these 3 above-listed values from “IN VIOLATION” and what specifically does this mean? Are there overlaps in meaning?

​​COSRV INVIO means "In Violation, Community Service Eligible" and applies only to summonses related to the Criminal Justice Reform Act (CJRA), for which community service is an available alternative to payment of a fine for an In Violation summons.
POP In Vio means "In Violation – Publicly Owned Property" – the respondent is the city itself. In these cases, the agency that owns the property isn't required to pay.
Settl In Vio means that there was a settlement prior to hearing and the respondent is recorded as having been in violation as a condition of to that settlement
​They all mean that the finding is that the respondent is in violation.
​
​Also, could you please enlighten me as to what the prefix “SAU” stands for in the scheduledhearinglocation and the decisionlocationborough variables. This prefix “SAU:” is placed before every borough. For example, “SAU: BKLN” or “SAU”MANH”.

SAU signifies that a case was assigned to the Hearings by Mail unit
​
​Finally, I am not sure if this is a typo but in the violationdescription variable, besides “ASBESTOS”, “BAR”, “COMMERCIAL”, “FIRE”, “MULTIPLE DWELLING”, and “NOISE” there is the “1 -D142 2 FAMILY” value whose meaning I cannot fathom.

​This field is used by various agencies to store various information, generally indicating something additional (a building type, a violation type) – it’s not consistent across OATH’s data. I will contact Open Data to see how they're assembling it
​
Thank you,
-Office of Administrative Trials and Hearings
Status
Closed
Date Submitted
2018-04-17T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3366
Inquiry Id: 3366 • Inquiry Type: Data Question • Assigned Agency: 311
Inquiry Id
3366
Inquiry Type
Data Question
Assigned Agency
311
Inquiry
Hello, I am writing to seek clarification about the 311 service request data set. I am a graduate researcher at *** and part of my work has been utilizing 311 data to quantify citizen needs and government response. Not too long ago, the total number of rows in the '311 Service Requests 2010 to present' data set dropped dramatically from about 17 million to 9 million. Why did this happen and is there any way to access the calls that are now missing? For example, on 8/14/11 this data set used to have record of 691 calls with one of these descriptors: sewer backup, catch basin clogged, street flooding, manhole overflow, highway flooding. Today that same data set with the same filters is showing 44 total calls. I had downloaded this data a few months ago so I have all the records for this day that are missing but as I continue my work I will need to download more of this data and thus need to make sure the calls I am downloading are an accurate depiction of the needs of citizens on a given day. Please let me know why this change was made and if there is any way to recover the records as they appeared before the change.
Dataset Name
311 Service Requests from 2020 to Present
Dataset Url
https://data.cityofnewyork.us/d/erm2-nwe9
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. Please be advised that 311 Service Requests from 2010 to Present dataset has recently undergone structural changes. For a general review of changes to this dataset, please refer to http://www1.nyc.gov/311/nyc311-enhances-service-request-open-dataset.page
​311 dataset is now fully refreshed and contains as of 05/02/2018 17.5 million records.

Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-17T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3365
Inquiry Id: 3365 • Inquiry Type: Data Question • Assigned Agency: Agency not assigned yet.
Inquiry Id
3365
Inquiry Type
Data Question
Assigned Agency
Agency not assigned yet.
Inquiry
Hi! I am using the OACE Directory with their classes schedule for 2017-2018 (see link below) and I would like to know if that data is available through Open Data. So far I have found the list/map with OACE sites and not sure if that is up to date and to what extent it corresponds with the PDF document?

(Link: http://schools.nyc.gov/NR/rdonlyres/13676954-4A29-4648-A18F-8F8FBFD9DDC4/0/OACEDirectoryofClassesFall2018.pdf)
Dataset Url
No URL Submitted.
Assigned Agencys Response
The Map is actually a listing of the sites. The difference is the PDF has class information not available on the map. With regards to the PDF being made available in an appropriate format for the I would need to ask the responsible department to recreate. As to when that would be available, I could not say at this point. If, and when it is I'll upload to the site .

Thank you,
- NYCDOE Open Data
Status
Closed
Date Submitted
2018-04-17T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3363
Inquiry Id: 3363 • Inquiry Type: Data Question • Assigned Agency: Agency not assigned yet.
Inquiry Id
3363
Inquiry Type
Data Question
Assigned Agency
Agency not assigned yet.
Inquiry
How can I find work permits or paperwork filings related to [Adressed Removed]. Dating back from 2006 through current date. Also, can you confirm how much a work permit costs to file? thank you
Dataset Url
No URL Submitted.
Assigned Agencys Response
Hi,

To find all of the filings for a specific building, your best bet is to use our Buildings Information System website. At the bottom of the profile page for [Address removed], you'll see links for Jobs/Filings, Permits In-Process/Issued, Elevator Records, Complaints, etc.

For the cost of a specific permit, you should check out our website or call our customer service line at (212) 566-5000.

Best,
DOB NYC Open Data Coordinator
Status
Closed
Date Submitted
2019-04-17T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3361
Inquiry Id: 3361 • Inquiry Type: Data Question • Assigned Agency: Department of Finance (DOF)
Inquiry Id
3361
Inquiry Type
Data Question
Assigned Agency
Department of Finance (DOF)
Inquiry
Hi there! I have a question about the value of column 'Street Code X'. I notice that there are some values not 5-digit long. I thought the street code used here is the five-digit code. Could you explain, for example, what "street code == 0" means?
Dataset Name
Parking Violations Issued - Fiscal Year 2016
Dataset Url
https://data.cityofnewyork.us/d/kiv2-tbus
Assigned Agencys Response
A value of zero could be representative of an invalid location, such as a street name being misspelled or an invalid house address for the specified street.
Status
Closed
Date Submitted
2018-04-16T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3359
Inquiry Id: 3359 • Inquiry Type: Reported Error • Assigned Agency: Department of Consumer and Worker Protection (DCWP)
Inquiry Id
3359
Inquiry Type
Reported Error
Assigned Agency
Department of Consumer and Worker Protection (DCWP)
Inquiry
Trying to import dataset into SQL server for a class.
- Executing (Error)
Messages
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Address ZIP" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
(SQL Server Import and Export Wizard)

Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Source - Legally_Operating_Businesses_csv.Outputs[Flat File Source Output].Columns[Address ZIP]" failed because error code 0xC0209084 occurred, and the error row disposition on "Source - Legally_Operating_Businesses_csv.Outputs[Flat File Source Output].Columns[Address ZIP]" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)

Error 0xc0202092: Data Flow Task 1: An error occurred while processing file "P:\thehitman\Downloads\Legally_Operating_Businesses.csv" on data row 2.
(SQL Server Import and Export Wizard)

Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Source - Legally_Operating_Businesses_csv returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)
Dataset Name
Issued Licenses
Dataset Url
https://data.cityofnewyork.us/d/w7w3-xahh
Assigned Agencys Response
​Thank you for contacting NYC Open Data Help Desk. For technical/programming questions, you are encouraged to directly contact Socrata support at support@socrata.com. For their online Customer Center, please refer to https://support.socrata.com/hc/en-us
Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-15T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3358
Inquiry Id: 3358 • Inquiry Type: Data Question • Assigned Agency: Department of Citywide Administrative Services (DCAS)
Inquiry Id
3358
Inquiry Type
Data Question
Assigned Agency
Department of Citywide Administrative Services (DCAS)
Inquiry
good morning I have question about my test score
I took exam#7326 POLICE OFFICER
and I'm still serve in US Military but I don't see a military credit that was apply for my score, do you know who I can contact about this question?
Thank you.
Dataset Name
Civil Service List (Active)
Dataset Url
https://data.cityofnewyork.us/d/vx8i-nprf
Assigned Agencys Response
Agency representative directly referred user to DCAS Exam Support
Status
Closed
Date Submitted
2018-04-15T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3356
Inquiry Id: 3356 • Inquiry Type: Data Question • Assigned Agency: Department of Citywide Administrative Services (DCAS)
Inquiry Id
3356
Inquiry Type
Data Question
Assigned Agency
Department of Citywide Administrative Services (DCAS)
Inquiry
I CAN NOT SEE MY NAME IN THE LISTS WHEN I HAD ALREADY PASSED HOUSING INSPECTOR Exam No. 8011
Dataset Name
Civil Service List (Active)
Dataset Url
https://data.cityofnewyork.us/d/vx8i-nprf
Assigned Agencys Response
I'm writing in response to your inquiry concerning Exam No. 8011, Housing Inspector.

The list for Exam No. 8011 has not yet been released. When it is released, you will receive a notice with your results and the list will appear on the NYC OpenData website.
Status
Closed
Date Submitted
2018-04-15T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3355
Inquiry Id: 3355 • Inquiry Type: Data Question • Assigned Agency: Agency not assigned yet.
Inquiry Id
3355
Inquiry Type
Data Question
Assigned Agency
Agency not assigned yet.
Inquiry
Hi, I am trying to compile data on all Public Libraries (NYPL, BPL, QPL) for all 5 boroughs.

The NYPL dataset does not contain the same information the BPL and QPL do, such as address, phone, hours of operation, etc.

Would you guys mind making the data available in the same way you have for:
https://data.cityofnewyork.us/Recreation/Queens-Library-Branches/kh3d-xhq7

Additionally, for the BPL, do you guys have a csv export such as the Queens one?

There seems to be a different format for each NYPL, QPL and BPL, making if difficult to process the information.
Dataset Url
No URL Submitted.
Assigned Agencys Response
​Thank you for contacting NYC Open Data Help Desk. Please be advised that the spreadsheet file is now available for download (please refer to the Attachments section of BPL Branches dataset's metadata).
https://data.cityofnewyork.us/Recreation/BPL-Branches/xmzf-uf2w
​
We apologize for a long delay in responding to your request.

Thank you,
- NYC Open Data Team
Status
Closed
Date Submitted
2018-04-14T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3351
Inquiry Id: 3351 • Inquiry Type: Data Question • Assigned Agency: Department of Finance (DOF)
Inquiry Id
3351
Inquiry Type
Data Question
Assigned Agency
Department of Finance (DOF)
Inquiry
I do not have Microsoft Access therefore I can not open the MDB file provided here. I only need the data for one NYC postal code (11222) or Brooklyn in general could potentially work. preferably in CSV format.
Dataset Name
Property Valuation and Assessment Data
Dataset Url
https://data.cityofnewyork.us/d/yjxr-fw8i
Assigned Agencys Response
To get the data in a CSV format you would have to put in a FOIL request to NYC Department of Finance.
Status
Closed
Date Submitted
2018-04-12T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3347
Inquiry Id: 3347 • Inquiry Type: Reported Error • Assigned Agency: New York City Police Department (NYPD)
Inquiry Id
3347
Inquiry Type
Reported Error
Assigned Agency
New York City Police Department (NYPD)
Inquiry
The dataset claims to have data from 2006 to the end of last year (2016) but there is no data from 2016 at all in this dataset. However the dataset "NYPD Complaint Data Current YTD" has data from December 2016 but no other complete months from 2016. The descriptions of these datasets should be updated to the proper timeframes and the January-November 2016 data should be posted in one csv or the other.
Dataset Name
NYPD Complaint Data Historic
Dataset Url
https://data.cityofnewyork.us/d/qgea-i56i
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. You are encouraged to utilize the Filter feature of the Socrata platform. Filtering this dataset for CMPLNT_FR_DT is after 12/31/2015 returns over 468,000 records dated from 01/01/2016 to 12/31/2016.
For more information on this feature, please refer to https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View

Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-10T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3345
Inquiry Id: 3345 • Inquiry Type: Data Question • Assigned Agency: Agency not assigned yet.
Inquiry Id
3345
Inquiry Type
Data Question
Assigned Agency
Agency not assigned yet.
Inquiry
I purchased my apartment 2 years ago which included an enclosed balcony. I was told by management that all enclosures on the balconies will be removed. I have no idea when and who installed it. But the building is 64 years. Where can I research if the individuals who lived here prior to me erected this properly with a permit. If a permit exists, the enclosure will remain. Please direct me where I can begin looking before they start tearing it down. Thank-you.
Dataset Url
No URL Submitted.
Assigned Agencys Response
Hi,

Thank you for contacting us. We do have permit data available at the link below. I do not know, however, that it will go back as far as you may need to find the record in question.

https://data.cityofnewyork.us/Housing-Development/DOB-Permit-Issuance/ipu4-2q9a
Status
Closed
Date Submitted
2018-04-10T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3344
Inquiry Id: 3344 • Inquiry Type: Data Question • Assigned Agency: New York City Fire Department (FDNY)
Inquiry Id
3344
Inquiry Type
Data Question
Assigned Agency
New York City Fire Department (FDNY)
Inquiry
Hello, in the EMS data, which geographic identifier does the ATOM column represent? I tried looking at the ATOMIC IDs for NYC and the ATOM column did not match any of the IDs or the numbers
Dataset Name
EMS Incident Dispatch Data
Dataset Url
https://data.cityofnewyork.us/d/76xm-jjuj
Assigned Agencys Response
Thank you for your interest in the EMS Dispatch dataset. The Atom refers to geographic areas used for EMS unit dispatching. We are currently reviewing HIPPA and other privacy laws to determine whether these geographic locations may be lawfully released. If we determine that it may be released, we will publish it to the Open Data site, otherwise the atom data point will be removed.
Status
Closed
Date Submitted
2018-04-10T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3342
Inquiry Id: 3342 • Inquiry Type: Reported Error • Assigned Agency: Department of Finance (DOF)
Inquiry Id
3342
Inquiry Type
Reported Error
Assigned Agency
Department of Finance (DOF)
Inquiry
this issue was closed and let you know if the problem persists! It was never fixed nor was I advised if there is nothing wrong and we are looking in the wrong spot. How many people were given this website and don't realize there is an issue and NYC is making money off of their penalties. Please fix the site
Dataset Name
Open Parking and Camera Violations
Dataset Url
https://data.cityofnewyork.us/d/nc67-uf89
Assigned Agencys Response
The Open Data Portal is not where you should be looking to print and settle parking tickets. This should be done on the NYC Finance web site, https://www1.nyc.gov/site/finance/index.page. Please access the site and navigate the links for Parking tickets.
Status
Closed
Date Submitted
2018-04-10T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3339
Inquiry Id: 3339 • Inquiry Type: Data Question • Assigned Agency: Department of Finance (DOF)
Inquiry Id
3339
Inquiry Type
Data Question
Assigned Agency
Department of Finance (DOF)
Inquiry
Hi there! I have a question about the value of column 'Street Code X'. I notice that there are some values not 5-digit long. I thought the street code used here is the five-digit code. Could you explain, for example, what "street code == 0" means? Thank you in advance!
Dataset Name
Parking Violations Issued - Fiscal Year 2016
Dataset Url
https://data.cityofnewyork.us/d/kiv2-tbus
Assigned Agencys Response
Hi Mia,
The Street Code fields are populated with values returned by a routine provided the City Planning Commission. A value of zero could be representative of an invalid location, such as a street name being misspelled or an invalid house address for the specified street.





Regards,
NYC Department of Finance
Status
Closed
Date Submitted
2018-04-09T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3338
Inquiry Id: 3338 • Inquiry Type: Reported Error • Assigned Agency: Agency not assigned yet.
Inquiry Id
3338
Inquiry Type
Reported Error
Assigned Agency
Agency not assigned yet.
Inquiry
Violation with summons_number=***, which has been issued on 02/28/2018, is still not available within qpyv-8eyi dataset. However, this summons is present within nc67-uf89 dataset. Please advise.
Dataset Url
No URL Submitted.
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. Please be advised that Open Parking and Camera Violations dataset https://data.cityofnewyork.us/City-Government/Open-Parking-and-Camera-Violations/nc67-uf89 is updated daily while the
​Parking Violations Issued - Fiscal Year 2018 dataset https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2018/pvqr-7yc4 is updated monthly. The last update in mid-March included violations up to 02/15/2018, while the violation you are looking for is dated 02/28/2018. This violation should be included in the mid-April update.
Status
Closed
Date Submitted
2018-04-09T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3337
Inquiry Id: 3337 • Inquiry Type: Data Question • Assigned Agency: Department of Investigation (DOI)
Inquiry Id
3337
Inquiry Type
Data Question
Assigned Agency
Department of Investigation (DOI)
Inquiry
Hello,
I was hoping you could let me know the status of the eviction dataset that used to be at this url. The NYCOpenData website says the following about the dataset,
"This dataset has been taken down while reported data issues are being investigated."

Thank you in advance for your help.
Dataset Name
Evictions
Dataset Url
https://data.cityofnewyork.us/d/6z8x-wfk4
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. This dataset is still in the development phase with the target release date of 06/01/2018.

Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-09T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3336
Inquiry Id: 3336 • Inquiry Type: Reported Error • Assigned Agency: Department of Finance (DOF)
Inquiry Id
3336
Inquiry Type
Reported Error
Assigned Agency
Department of Finance (DOF)
Inquiry
Hi NYC Open Data,

I have spent quite a bit of time searching through the 'Open Parking and Camera Violations' dataset (https://data.cityofnewyork.us/City-Government/Open-Parking-and-Camera-Violations/nc67-uf89/data). It appears to be missing many violations that appear in the datasets for parking and camera violations by each fiscal year.

FY' 14: https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2014-August-/jt7v-77mi/data
FY '15: https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2015/c284-tqph/data
FY '16: https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2016/kiv2-tbus/data
FY '17: https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2017/2bnn-yakx/data
FY '18: https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2018/pvqr-7yc4/data

Given that the datasets contain information about the same records (non-moving violations tickets), is there any reason why many records in the fiscal year datasets do not show up in the overall 'Open Parking and Camera Violations' dataset?
Dataset Name
Open Parking and Camera Violations
Dataset Url
https://data.cityofnewyork.us/d/nc67-uf89
Assigned Agencys Response
Open Parking and Camera Violations” lists only those violations that are still open at the time (i.e., unsatisfied), so yes, it will only be a subset of the fiscal year datasets.
Status
Closed
Date Submitted
2018-04-09T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3335
Inquiry Id: 3335 • Inquiry Type: Data Question • Assigned Agency: Agency not assigned yet.
Inquiry Id
3335
Inquiry Type
Data Question
Assigned Agency
Agency not assigned yet.
Inquiry
I'm attempting to import this data set into Python using panda.read_json(). All is well, however it is only returning 1,000 rows. I was hoping you could advise as to why this is happening (is there a set limit from your end?).

Many thanks in advance!
Dataset Url
No URL Submitted.
Assigned Agencys Response
​Thank you for contacting NYC Open Data Help Desk. Please be advised that the limit of 1,000 rows is a default set by the Socrata platform. Please refer to Socrata documentation for instructions on how to modify this parameter at https://dev.socrata.com/docs/queries/limit.html If you have further questions, you are encouraged to contact Socrata at support@socrata​.com

Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-09T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3332
Inquiry Id: 3332 • Inquiry Type: Data Question • Assigned Agency: Department of Buildings (DOB)
Inquiry Id
3332
Inquiry Type
Data Question
Assigned Agency
Department of Buildings (DOB)
Inquiry
Hello,
Just wanted to check with you on the following with regards to the DOB Job application filing data set:

1. Could you please let me know if this data set will be updated in the future? if so, could you please let me know when?

2. The data for March is no longer available, is there some other place I can access it?

3. Is there another website I can get the updated data?

Thank you for your help with this.
Dataset Name
DOB Job Application Filings
Dataset Url
https://data.cityofnewyork.us/d/ic3t-wcy2
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. Please be advised that this issue was resolved. The dataset was updated with the latest information on 06/11/2018, and contains records for March.

Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-06T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3331
Inquiry Id: 3331 • Inquiry Type: Data Question • Assigned Agency: New York City Police Department (NYPD)
Inquiry Id
3331
Inquiry Type
Data Question
Assigned Agency
New York City Police Department (NYPD)
Inquiry
Just need a clarification on Vehicle Type Code since the labels are not defined in the data dictionary. Do any of the variables include vehicles operated for ride-sharing services, such as Uber or Lyft?
Dataset Name
Motor Vehicle Collisions - Crashes
Dataset Url
https://data.cityofnewyork.us/d/h9gi-nx95
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. ​On a Police Accident Report (which is the official New York State DMV name of the form) there is no way to distinguish if a vehicle is Uber of Lyft etc. On this form the code is Taxi/Livery which includes all yellow taxi, limos, car services as well as uber and Lyft.

​​
Thank you,
-NYPD
Status
Closed
Date Submitted
2018-04-06T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3329
Inquiry Id: 3329 • Inquiry Type: Data Question • Assigned Agency: Department of Consumer and Worker Protection (DCWP)
Inquiry Id
3329
Inquiry Type
Data Question
Assigned Agency
Department of Consumer and Worker Protection (DCWP)
Inquiry
I have a question about the Legally Operating Businesses dataset. Why is it so incomplete? For example, my database has over 160 companies in the Empire State Building at 350 5th Ave. However, I'm only seeing 8 licenses with that address when I filter. Can you help me understand the discrepancy? Thank you so much.
Dataset Name
Issued Licenses
Dataset Url
https://data.cityofnewyork.us/d/w7w3-xahh
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk.

The Legally Operating Businesses dataset is described as a dataset which, “… features businesses/individuals holding a DCA license so that they may legally operate in New York City.”
The Department of Consumer Affairs [DCA] does not count the number or types of businesses operating in non-licensed business categories.

A list of business categories licensed by the Department of Consumer Affairs can be found here: http://www1.nyc.gov/site/dca/businesses/licenses-apply.page
or downloaded as a PDF* here: http://www1.nyc.gov/assets/dca/downloads/pdf/businesses/licensing_industries_list.pdf

* Note: License categories appearing on pages one and two ONLY, of the PDF, are issued by Consumer Affairs. The license categories on pages three and four are issued by the NYC Department of Health & Mental Hygiene and do not fall under Consumer Affairs’ jurisdiction.

Thank you,
-NYC Department of Consumer Affairs
Status
Closed
Date Submitted
2018-04-06T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3328
Inquiry Id: 3328 • Inquiry Type: Data Question • Assigned Agency: Agency not assigned yet.
Inquiry Id
3328
Inquiry Type
Data Question
Assigned Agency
Agency not assigned yet.
Inquiry
Hello,
I'm looking for a parcel or building GIS data set to download that contains the building exterior as an attribute for Brooklyn, NY. I see that it's included in the Dataset URL provided, but I have not been able to find a source that has it for download.
Dataset Url
No URL Submitted.
Assigned Agencys Response
Such a dataset is not available on the Open Data portal. The data may be obtained by making a FOIL request from NYC Department of Finance.
Status
Closed
Date Submitted
2018-04-05T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3325
Inquiry Id: 3325 • Inquiry Type: Data Question • Assigned Agency: Office of Technology and Innovation (OTI)
Inquiry Id
3325
Inquiry Type
Data Question
Assigned Agency
Office of Technology and Innovation (OTI)
Inquiry
What are the units of the values for HEIGHTROOF and GROUNDELEV? Thank you for your help!
Dataset Name
Building Footprints (Deprecated)
Dataset Url
https://data.cityofnewyork.us/d/nqwf-w8eh
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. The unit of measure for these values is feet. 
Status
Closed
Date Submitted
2018-04-05T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3323
Inquiry Id: 3323 • Inquiry Type: Data Question • Assigned Agency: Department of Finance (DOF)
Inquiry Id
3323
Inquiry Type
Data Question
Assigned Agency
Department of Finance (DOF)
Inquiry
The “Days Parking in Effect” column contains data values “Y” and “B” that refer to when Parking Rules are in effect for each day of the week following the order of Sun/Mon/Tues/Weds/Thurs/Fri/Sat. The “Y” represents “Yes” and the “B” represents “Bypass”.
My questions, what are all possible values for days_parking_in_effect and meaning; we see for instance the below values:
1-Sometimes it has only one letter Y? does that means YYYYYYY for the whole week?
2-sometimes days_parking_in_effect = "Y Y" for violation_code=21
3-Other instance it has number:days_parking_in_effect =57
4- days_parking_in_effect =0BBBBBB
Thanks
Dataset Name
Parking Violations Issued - Fiscal Year 2016
Dataset Url
https://data.cityofnewyork.us/d/kiv2-tbus
Assigned Agencys Response
The information reflected in the “Days Parking in Effect” data field for each listed summons is comprised of a data sting made up of values of “B” (B representing “By-pass”) or “blank” (also meaning “By-pass”) or “Y” (representing “Yes”) to indicate the days of the week in which the parking rules are in effect. The point of this field is to indicate which days of the week the particular parking rule is in effect depending on the violation. The data string represents the 7 days of the week following day order of Sun/Mon/Tue/Weds/Thurs/Fri/Sat.
Status
Closed
Date Submitted
2018-04-05T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3322
Inquiry Id: 3322 • Inquiry Type: Data Question • Assigned Agency: Department of Health and Mental Hygiene (DOHMH)
Inquiry Id
3322
Inquiry Type
Data Question
Assigned Agency
Department of Health and Mental Hygiene (DOHMH)
Inquiry
Is there a codebook or data dictionary that labels what are the violation codes identified during each recorded restaurant inspection associated with the NYC DOHMH dataset? If so, I would like to request access to the labels associated with these violation codes. The health violation codes available online are not consistent with the violation codes identified (i.e., number followed by letter). Thank you in advance for your time in this matter, and I look forward to your response.
Dataset Name
DOHMH New York City Restaurant Inspection Results
Dataset Url
https://data.cityofnewyork.us/d/43nn-pn8j
Assigned Agencys Response
The information that you're requesting can be found here http://www1.nyc.gov/assets/doh/downloads/pdf/rii/blue-book.pdf

Thank you for your submission
Status
Closed
Date Submitted
2018-04-05T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3319
Inquiry Id: 3319 • Inquiry Type: Data Question • Assigned Agency: Department of Buildings (DOB)
Inquiry Id
3319
Inquiry Type
Data Question
Assigned Agency
Department of Buildings (DOB)
Inquiry
How do I narrow the list of DOB permits granted? I'd like to view a specific area (Manhattan), address and apartment unit.
Dataset Url
DOB Permit Issuance
Assigned Agencys Response
​Thank you for contacting NYC Open Data Help Desk. Please refer to the DOB Permit Issuance
dataset at this URL: ​https://data.cityofnewyork.us/Housing-Development/DOB-Permit-Issuance/ipu4-2q9a/data#revert
​
​To narrow your search you are encouraged to utilize a Filter feature of the Socrata platform. For Manhattan, you can utilize the following Filter condition: BOROUGH is MANHATTAN.
​
​For more information on how to use this feature, please refer to the Socrata guide on creating a filtered view at https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View
​
Status
Closed
Date Submitted
2018-04-05T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3317
Inquiry Id: 3317 • Inquiry Type: Data Question • Assigned Agency: 311
Inquiry Id
3317
Inquiry Type
Data Question
Assigned Agency
311
Inquiry
complaint type: rodent; Descriptor: conditions attracting rodents.
what does that mean / what complaint types & descriptors where aggregated to this? and how was this calculated, based on what? thank you
Dataset Name
311 Service Requests from 2020 to Present
Dataset Url
https://data.cityofnewyork.us/d/erm2-nwe9
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. Complaint type Rodent ---> Descriptor Condition Attracting Rodents are values from the Department of Health and Mental Hygiene and are not aggregations of other complaint types and descriptors.

Thank you,
-NYC 311
Status
Closed
Date Submitted
2018-04-04T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3316
Inquiry Id: 3316 • Inquiry Type: Data Question • Assigned Agency: 311
Inquiry Id
3316
Inquiry Type
Data Question
Assigned Agency
311
Inquiry
Can I access 311 calls for a certain date or for a certain location
Dataset Name
311 Service Requests from 2020 to Present
Dataset Url
https://data.cityofnewyork.us/d/erm2-nwe9
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. For the list of the 311 calls please refer to the 311 Call Center Inquiry at https://data.cityofnewyork.us/City-Government/311-Call-Center-Inquiry/tdd6-3ysr
​This is a Data Lens dataset and you can utilize Date Card to select a date or a range of dates of your choice. For more information on how to use Data Lens, please refer to Socrata guide at https://support.socrata.com/hc/en-us/sections/200646116-Data-Lens

​​For more detailed descriptions of 311 inquiries, you are encouraged to use 311 Service Requests from 2010 to Present dataset at https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9. The data provides a detailed address information, and you are encouraged to utilize a Filter feature of the Socrata platform to narrow your search.
​For more information on how to use this feature, please refer to the Socrata guide on creating a filtered view at https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View
​
​Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-04T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3313
Inquiry Id: 3313 • Inquiry Type: Data Question • Assigned Agency: Agency not assigned yet.
Inquiry Id
3313
Inquiry Type
Data Question
Assigned Agency
Agency not assigned yet.
Inquiry
The DOB Applications stopped pulling into OpenData at the end of March. Do you know if this will be fixed soon? There is no other way to compile applications now that the DOB website no longer updates.
Dataset Url
No URL Submitted.
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. Please be advised that this issue was resolved.

Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-04T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3311
Inquiry Id: 3311 • Inquiry Type: Data Question • Assigned Agency: Department of Citywide Administrative Services (DCAS)
Inquiry Id
3311
Inquiry Type
Data Question
Assigned Agency
Department of Citywide Administrative Services (DCAS)
Inquiry
I could not find my name on the dataset for the firefighter exam, Can you send me my list number if possible?
Dataset Name
Civil Service List (Active)
Dataset Url
https://data.cityofnewyork.us/d/vx8i-nprf
Assigned Agencys Response
List is not released
Status
Closed
Date Submitted
2018-04-04T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3307
Inquiry Id: 3307 • Inquiry Type: Data Question • Assigned Agency: Agency not assigned yet.
Inquiry Id
3307
Inquiry Type
Data Question
Assigned Agency
Agency not assigned yet.
Inquiry
1-What does B and Y stand for in days_parking_in_effect? (for example BYBBYBB?)
2-In case B stands for business days (non holiday days) what is considered a holiday. Where may I find the list of holidays?
Thank you!
Dataset Url
No URL Submitted.
Assigned Agencys Response
1-What does B and Y stand for in days_parking_in_effect? (for example BYBBYBB?)
2-In case B stands for business days (non holiday days) what is considered a holiday. Where may I find the list of holidays?
Thank you!
​-----
​Thank you for contacting NYC Open Data Help Desk.
​
​1. The “Days Parking in Effect” column contains data values “Y” and “B” that refer to when Parking Rules are in effect for each day of the week following the order of Sun/Mon/Tues/Weds/Thurs/Fri/Sat. The “Y” represents “Yes” and the “B” represents “Bypass”.
​
​2. Parking meter regulations are suspended on major legal holidays. The major legal holidays are New Years Day, Memorial Day, Independence Day, Labor Day, Thanksgiving and Christmas. On all other holidays, only street cleaning rules are suspended, and other regulations remain in effect.

Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-03T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3306
Inquiry Id: 3306 • Inquiry Type: Reported Error • Assigned Agency: Office of Administrative Trials and Hearings (OATH)
Inquiry Id
3306
Inquiry Type
Reported Error
Assigned Agency
Office of Administrative Trials and Hearings (OATH)
Inquiry
Has not been updated since Sunday. It is a daily data set.
Dataset Name
OATH Hearings Division Case Status
Dataset Url
https://data.cityofnewyork.us/d/jz4z-kudi
Assigned Agencys Response
Thank you for contacting NYC Open Data. Please be advised that the agency adds new records to the dataset with 2-3 day delay as part of the internal business logic. We have reached out to the agency with your request to increase the update frequency for the new records.

Thank you,
-NYC Open Data
Status
Closed
Date Submitted
2018-04-03T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3305
Inquiry Id: 3305 • Inquiry Type: Reported Error • Assigned Agency: Department of Buildings (DOB)
Inquiry Id
3305
Inquiry Type
Reported Error
Assigned Agency
Department of Buildings (DOB)
Inquiry
In some of the rows, the data to the right of the free-text column "VIOLATION_DESCRIPTION" is misaligned. The next column, "PENALTY_IMPOSED", is blank and the penalty amount is in the "AMOUNT PAID" field. You can see a clear example of this if you filter on ISN_DOB_BIS_EXTRACT in (739166, 1191771).



4/9/2018:
The way things are rendering on the website (https://data.cityofnewyork.us/Housing-Development/DOB-ECB-Violations/6bgk-3dad/data), there are sometimes columns that are shifted to the right after a long description field. My guess is that whatever separator the program is searching for in the data when it is loaded is contained somewhere in the string VIOLATION_DESCRIPTION for these rows (ISN_DOB_BIS_EXTRACT = 739166 or 1191771).

On the website I see
ISN_DOB_DIB_EXTRACT = 739166, PENALTY_IMPOSED = NULL, AMOUNT_PAID = 350.00, BALANCE_DUE = 1350.00, INFRACTION_CODE1 = -100000
ISN_DOB_DIB_EXTRACT = 1191771, PENALTY_IMPOSED = NULL, AMOUNT_PAID = 350.00, BALANCE_DUE = 350.00, INFRACTION_CODE1 = 0

I don't think -100000 or 0 are valid INFRACTION_CODE1 values.
Dataset Name
DOB ECB Violations
Dataset Url
https://data.cityofnewyork.us/d/6bgk-3dad
Assigned Agencys Response
Hi,

The issue you reported with invalid values for INFRACTION_CODE1 in our DOB ECB Violations dataset has been fixed. Thank you for reporting!

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

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/IFhb3dVJttOJ
Status
Closed
Date Submitted
2018-04-03T00:00:00.000
Data As Of
2026-10-02T00:00:00.000
3302
Inquiry Id: 3302 • Inquiry Type: Data Question • Assigned Agency: Department of Housing Preservation and Development (HPD)
Inquiry Id
3302
Inquiry Type
Data Question
Assigned Agency
Department of Housing Preservation and Development (HPD)
Inquiry
A data pull from 5/2/17 has large discrepancies with one from 3/7/18. E.g. total number of 2016 litigations in 5/2/17 pull is 5,936 and in 3/7/18 pull is 11,900. Similar discrepancies for other past years. Can you explain the difference? Thanks.
Dataset Name
Housing Litigations
Dataset Url
https://data.cityofnewyork.us/d/59kj-x8nc
Assigned Agencys Response
Thank you for contacting NYC Open Data Help Desk. This past December we realized that the data transfer process with DOITT was inadvertently leading to many dropped records. We fixed the process and reloaded the entire dataset in early January 2018. We apologize for any inconvenience or issues these errors may have caused. We are currently working with our tech team to systematically improve these types of issues in our open data.

The HPD website Litigation dataset did not have this issue and was always correct. And again, the NYC Open Data Portal Litigations dataset is now comprehensive and correct also.

Thank you,
-NYC Department of Housing Preservation and Development
Status
Closed
Date Submitted
2018-04-03T00:00:00.000
Data As Of
2026-10-02T00:00:00.000