NYC Open Data Help Desk: Data Questions and Reported Errors

5643

Reported Error

Office of Technology and Innovation (OTI)

Hi, I'm checking certificate of occupancy status for Jackson Park, a multifamily development with 3 towers and 3 building IDs. https://data.cityofnewyork.us/Housing-Development/DOB-Certificate-Of-Occupancy/bs8b-p36w I can find the certificate of occupancy details for building ID 4596920 and 4596921. But I can't find the certificate of occupancy data for building ID 4618925. Why isn't certificate of occupancy data for 4618925 showing up when I download the certificate of occupancy data?

Building Footprints (Deprecated)

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

Hi ,

This is an unfortunate side effect of a known data problem with Department of Buildings (DOB) BINs. We are working to clean this up, but here's the explanation:

Sometimes when there is new construction, our BIN data gets out of sync with the master list of BINs set by Department of City Planning (DCP). Due to issues surrounding the business process of getting permits for a new building, the building's records might be related to a "Dummy" BIN, which has an 8 as the second digit. These Dummy BINs will not show up in any other agency's data.

In this particular case, you can see on our BIS system that BIN 4618925 (http://a810-bisweb.nyc.gov/bisweb/PropertyProfileOverviewServlet?bin=4618925&go4=+GO+&requestid=0) has 2 other Dummy BINs associated with it (Additional BINs for Building). The current Certificate of Occupancy is actually tied to BIN 4856065 (http://a810-bisweb.nyc.gov/bisweb/PropertyProfileOverviewServlet?requestid=9&bin=4856065). And if you use that BIN on our Certificates of Occupancy dataset (https://data.cityofnewyork.us/Housing-Development/DOB-Certificate-Of-Occupancy/bs8b-p36w/data), you'll see the recent history of COs there.

Another way to disentangle this issue is to look at the Borough, Block and Lot. Those may match when the BIN doesn't.

So if you're looking at the Buliding Footprints dataset (https://data.cityofnewyork.us/Housing-Development/Building-Footprints/nqwf-w8eh), and you can't find a matching record in DOB data, this is likely the reason why. We are working closely with DCP to fix this problem.

Thank you,
- DOB Open Data Coordinator

Closed

2019-08-22T00:00:00.000

2026-10-02T00:00:00.000

5642

Reported Error

New York City Fire Department (FDNY)

Dataset is has not been updated. Last update date was March 7. Update frequency is listed as quarterly which would be early June. Please advise when next update can be expected.

Bureau of Fire Prevention - Certificates of Fitness (Historical)

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

Response not sent yet.

Pending

2019-08-22T00:00:00.000

2026-10-02T00:00:00.000

5640

Data Question

Agency not assigned yet.

Hello,

I would like to share a part of this dataset as a service in a web map I am mapping. Could you send me the endpoint url? No endpoints are available when I try and export from the map.

I am also interested in endpoints for https://data.cityofnewyork.us/Transportation/Bus-Stop-Shelters/qafz-7myz and https://data.cityofnewyork.us/Transportation/Bicycle-Routes/7vsa-caz7 if possible.

No URL Submitted.

Response not sent yet.

Pending

2019-08-21T00:00:00.000

2026-10-02T00:00:00.000

5639

Data Question

Department of Finance (DOF)

I am requesting information re: the [Violation Status] field.

If there is a null value does that mean the recipient of the citation has not challenged the citation?

All the values that do appear in the [Violation Status] field seem to indicate hearings, appeals, or some other type of claim of the recipient of the citation.

Open Parking and Camera Violations

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

“Yes, a null or blank value in the ‘Violation Status’ field indicates that the respondent has not contested the ticket.”

Below is a brief explanation of each of the possible values that may populate the ‘Violation Status’ field.

ADMIN CLAIM DENIED: Ticket was contested, and the claim was denied administratively, without an ALJ/hearing (contested - guilty)
ADMIN CLAIM GRANTED: Ticket was contested, and the claim was denied administratively, without an ALJ/hearing (contested - guilty)
ADMIN REDUCTION: Ticket was contested, and the claim was denied administratively, without an ALJ/hearing (contested - guilty)
APPEAL ABANDONED: Original guilty determination was appealed, but the respondent never followed through with the appeal hearing (contested - guilty)
APPEAL AFFIRMED: Original guilty determination was affirmed at an appeal hearing (contested - guilty)
APPEAL MODIFIED: Original guilty determination was affirmed at an appeal hearing (contested - guilty)
APPEAL REMANDED: Case deferred, similar to an adjournment (contested - no new determination…just the original guilty)
APPEAL REVERSED: Original guilty determination was reversed at an appeal hearing (contested - not guilty)
HEARING ADJOURNMENT: Ticket was contested, and brought to a hearing. The ALJ determined that more evidence was needed. Hearing was rescheduled for another day (contested - no determination yet)
HEARING HELD-GUILTY: Ticket was contested, and found guilty by an ALJ at a hearing (contested - guilty)
HEARING HELD-GUILTY REDUCTION: Ticket was contested, and found guilty by an ALJ at a hearing, with some reduction of previously assessed penalties (contested - guilty)
HEARING HELD-NOT GUILTY: Ticket was contested, and found not-guilty by an ALJ at a hearing (contested - not guilty)
HEARING HELD-REINSTATEMENT: Ticket was found guilty at a fraud hearing (previously dismissed fraudulently) and has been reinstated (contested - guilty)
HEARING PENDING: Ticket was contested, and hearing is pending (contested - no determination yet)
HEARING WAIVED: A settlement was agreed to by the respondent, which included a waiver of ever having a hearing (not contested)


Thank you,
- NYC Open Data Team

Closed

2019-08-21T00:00:00.000

2026-10-02T00:00:00.000

5634

Data Question

Office of Administrative Trials and Hearings (OATH)

We're having trouble displaying this table. Check to make sure the underlying dataset hasn't been deleted or unpublished. This is the second time I am reporting this.

OATH Hearings Division Case Status

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

We have escalated you inquiry to Socrata Support. Due to the size of the data set you are searching.
https://data.cityofnewyork.us/City-Government/OATH-Hearings-Division-Case-Status/jz4z-kudi.
​
​It is advised that you use filters and search for terms in a desired column. Filtering for data is much more stable and reliable than given the size of this data set.

Thank you,
- NYC Open Data Team

Closed

2019-08-20T00:00:00.000

2026-10-02T00:00:00.000

5632

Data Question

Office of Administrative Trials and Hearings (OATH)

I'm trying to reconcile the job filings located in the DOB NOW Build public portal and the "DOB NOW: Build – Job Application Filings" dataset. It looks like the dataset is missing a very large amount of job filings available on the DOB NOW website (albeit in a much less accessible format). Can you give any guidance for when we can expect DOB NOW data to show up in the OpenData dataset?

For example, if you go to https://a810-dobnow.nyc.gov/publish/#!/ and search BIN 1036082, I can see sprinkler job "M00174525-P1". This job is not available in the OpenData dataset.

OATH Hearings Division Case Status

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

Hii,

Thank you for your report. I looked into the specific example you gave, and M00174525-P1 is a Limited Alteration Application (LAA). As you noted, LAAs are not showing up in the DOB NOW: Build – Job Application Filings dataset. Because the data is slightly different in the database, this will be an entirely new dataset, and we plan to publish it on open data in October 2020. We have several new datasets and updates to existing datasets on the calendar over the next couple of years, so we appreciate your patience as we roll out all of these updates. Watch for the Open Data Compliance Plan that will be published in ~September on the portal for more details.

Thank you,
- DOB Open Data Coordinator

Closed

2019-08-19T00:00:00.000

2026-10-02T00:00:00.000

5631

Data Question

Agency not assigned yet.

I would like to add a link to the NYC Sandy Funding Tracker to my Microsoft Word and Access form. I obtained the Infrastructure link on the Funding Tracker website and I copied the link to my document. However, although the link takes me to a page with NYC Maps.nyc.gov in the title the Sandy Tracker map does not open although it looks like it is loading.
Thanks.

No URL Submitted.

Response not sent yet.

Pending

2019-08-19T00:00:00.000

2026-10-02T00:00:00.000

5629

Data Question

Office of Administrative Trials and Hearings (OATH)

When I go to the following dataset (https://data.cityofnewyork.us/City-Government/OATH-Hearings-Division-Case-Status/jz4z-kudi/data) and run a search in the “search box” on the right hand side, I get the following error message: "We're having trouble displaying this table. Check to make sure the underlying dataset hasn't been deleted or unpublished."

OATH Hearings Division Case Status

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

We have escalated you inquiry to Socrata Support. Due to the size of the data set you are searching.
https://data.cityofnewyork.us/City-Government/OATH-Hearings-Division-Case-Status/jz4z-kudi.
​
​It is advised that you use filters and search for terms in a desired column. Filtering for data is much more stable and reliable than given the size of this data set.

Thank you,
- NYC Open Data Team

Closed

2019-08-27T00:00:00.000

2026-10-02T00:00:00.000

5627

Data Question

Department of Correction (DOC)

The dataset lists ~1000 cases as having "charge unknown." Does that mean they are not in pre-trial detention? That is, they are sentenced, in on a technical parole violation, state ready, etc. Thank you.

Daily Inmates In Custody

https://data.cityofnewyork.us/d/7479-ugqb

Response not sent yet.

Pending

2019-08-16T00:00:00.000

2026-10-02T00:00:00.000

5624

Reported Error

Office of Administrative Trials and Hearings (OATH)

I have a question about the data quality/accuracy of certain fields.

I am interested in penalties imposed, penalties paid, and additional penalties or late fees. I see the definitions in the data dictionary (Paid Amount = The total amount paid by the respondent. Additional Penalties or Late Fees = Monetary penalties which are levied in addition to the original penalty amount and which may include a fee for payments made after the payment due date.)

For penalties imposed on health code violations related to lead (or, those containing "173.13"), none of the penalties imposed are recorded as “paid” in this dataset.

How should I interpret this blank "paid amount" field? Is it accurate that no penalties have been paid for lead-related violations? Is there another explanation (i.e. poor, inaccurate, or otherwise incomplete data)?

Thank you for your attention.

OATH Hearings Division Case Status

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

Response not sent yet.

Pending

2019-08-15T00:00:00.000

2026-10-02T00:00:00.000

5615

Reported Error

Office of Administrative Trials and Hearings (OATH)

I am unable to view the Hearing database from OATH when I put something into the search box

OATH Hearings Division Case Status

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

We have escalated you inquiry to Socrata Support. Due to the size of the data set you are searching.
https://data.cityofnewyork.us/City-Government/OATH-Hearings-Division-Case-Status/jz4z-kudi.
​
​It is advised that you use filters and search for terms in a desired column. Filtering for data is much more stable and reliable than given the size of this data set.

Thank you,
- NYC Open Data Team

Closed

2019-08-14T00:00:00.000

2026-10-02T00:00:00.000

5611

Reported Error

Office of Administrative Trials and Hearings (OATH)

I am trying to search the oath hearings division case status
and when i enter information
it comes up that we are having
trouble displaying this table
check to make sure the underlying dataset hasn't deleted or unpublished.

OATH Hearings Division Case Status

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

Hi ,

The data you've requested can be found here: https://data.cityofnewyork.us/City-Government/OATH-Hearings-Division-Case-Status/jz4z-kudi/data
​
​The search functionality appears to be functioning at this time. However, it is recommended that you instead filter for text terms as this is a way of looking up values in a more stable way. You can reference the tutorial resources at the Socrata learning page here: https://opendata.cityofnewyork.us/how-to/

Thank you,
- NYC Open Data Team

Closed

2019-08-14T00:00:00.000

2026-10-02T00:00:00.000

5607

Data Question

Department of Investigation (DOI)

Why doesn't the evictions data include the totality of evictions conducted by all City Marshals. For example for year 2018, the data set only includes 26 out of the 35 Marshals.

Evictions

https://data.cityofnewyork.us/d/6z8x-wfk4

Response not sent yet.

Pending

2019-08-13T00:00:00.000

2026-10-02T00:00:00.000

5601

Data Question

New York City Police Department (NYPD)

When will the dataset be appended with the 2018 data?

NYPD Complaint Data Historic

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

Hi,

The data you've requested can be found here: https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Historic/qgea-i56i now with all of the data from 2018

Thank you,
- NYC Open Data Team

Closed

2019-08-12T00:00:00.000

2026-10-02T00:00:00.000

5598

Reported Error

Department of Buildings (DOB)

Daily dataset has not updated since 8/9/19 (3 days ago)

DOB NOW: Build – Job Application Filings

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

Hi,

I just got your error report. Looks like everything was running smoothly the next day, and has been since. Thank you for reporting!

Thank you,
- DOB Open Data Coordinator

Closed

2019-08-12T00:00:00.000

2026-10-02T00:00:00.000

5595

Reported Error

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

There seems to be no way for the end user to create measures.

How do we as end user publish "data sets" based on existing data???

This system seems to be very incomplete.

Look at total pay, it has total gross pay and total overtime pay and total other pay, but were is the sum???

If you want to show the total pay / total employees it seems that there is no way to do that.

Is that true?

This seems to be a severe limitation.

Citywide Payroll Data (Fiscal Year)

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

Hi,

The NYC Open Data team is committed to making City data available for anyone to access online. Please ensure that you have a registered account and that you are logged in in order to save filters and data visualizations.

In regards to your request to display column totals, we've sent your feedback along to our platform vendor Socrata and they acknowledge that the feature you are requesting is not supported yet. The Socrata Support staff has received similar feedback from other customers for improved column statistics and your input has been added to that request since this message.
​
Thank you,
- NYC Open Data Team

Closed

2019-08-11T00:00:00.000

2026-10-02T00:00:00.000

5585

Reported Error

Agency not assigned yet.

The number of new applicants for a TLC license in the month of July (based on App Date) is 31 according to the dataset, while in preceding months this number has been in the several hundreds. Could you please confirm if this is right?

No URL Submitted.

Hi,

Thank you for reaching out about driver applications. The historic list you referenced in your inquiry is where application records are moved once the licensed is approved or denied. There are still active applications which were started in July working through the approval process in the current TLC New Driver Application Status list, which you can find here: https://data.cityofnewyork.us/Transportation/TLC-New-Driver-Application-Status/dpec-ucu7/data . The approval process can take weeks depending on how quickly the criteria for licensing are met, so a majority of the applications that were started in July are still incomplete and on the other list.

Thanks,
NYC Open Data + Taxi & Limousine Commission

Closed

2019-08-08T00:00:00.000

2026-10-02T00:00:00.000

5584

Reported Error

Agency not assigned yet.

The field names in the E-desginations API (https://data.cityofnewyork.us/Environment/E-Designations-CSV-file/hxm3-23vy) are incorrect.

The correct fields show up when downloading the CSV file:

CSV header from downloaded file:
ENumber,E Effective Date,BOROCODE,TAXBLOCK,TAXLOT,HazMat Code,Air Code,Noise Code,HazMat Date,Air Date,Noise Date,CEQR_NUM,ULURP_NUM

However, when accessing the data through the API, the CSV headers // or JSON keys are nonsensical:

CSV header from API endpoint:
"e_1","_4_28_1983_0_00","_3","_319","_1","_0","_0_1","_1_1","column_8","column_9","column_10","_82_252k","_830178_zmk"

JSON example from API endpoint:
[{"e_1":"E-1","_4_28_1983_0_00":"1983-04-28T00:00:00.000","_3":"3","_319":"319","_1":"1","_0":"0","_0_1":"0","_1_1":"1","_82_252k":"82-252K","_830178_zmk":"830178 ZMK"}
,{"e_1":"E-1","_4_28_1983_0_00":"1983-04-28T00:00:00.000","_3":"3","_319":"319","_1":"10","_0":"0","_0_1":"0","_1_1":"1","_82_252k":"82-252K","_830178_zmk":"830178 ZMK"}
,{"e_1":"E-1","_4_28_1983_0_00":"1983-04-28T00:00:00.000","_3":"3","_319":"319","_1":"11","_0":"0","_0_1":"0","_1_1":"1","_82_252k":"82-252K","_830178_zmk":"830178 ZMK"}

No URL Submitted.

Hi Yarin Kessler #4,

Hello thank you for pointing out the discrepancy in the data sets metadata. We contacted DCP for approval and have updated API field names usable.
https://data.cityofnewyork.us/Environment/E-Designations-CSV-file/hxm3-23vy

Thank you,
- NYC Open Data Team

Closed

2019-08-08T00:00:00.000

2026-10-02T00:00:00.000

5582

Reported Error

Department of Finance (DOF)

Is it possible to obtain information on residential building construction type and exterior cladding material? It seems like these data are collected in property assessment (I found this form online - it includes those fields: https://www1.nyc.gov/assets/finance/downloads/pdf/assessments/request_update_class1.pdf) but I don't see them in the NYC open data portal. Please let me know if I'm just overlooking something, thanks.

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

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

Hi,
There is very limited information on building material in the DOF public datasets.
You can use the building class from the Property Valuation and Assessment Data Tax Classes 1,2,3,4 and the building classification code document to identify 2 family brick or frame homes.


https://data.cityofnewyork.us/browse?q=Property%20Valuation%20and%20Assessment%20Data%20Tax%20Classes%201%2C2%2C3%2C4&sortBy=relevance



Thank you,
- NYC Open Data Team

Closed

2019-08-11T00:00:00.000

2026-10-02T00:00:00.000

5579

Data Question

Department of Finance (DOF)

Is it possible to obtain information on residential building construction type and exterior cladding material? It seems like these data are collected in property assessment (I found this form online - it includes those fields: https://www1.nyc.gov/assets/finance/downloads/pdf/assessments/request_update_class1.pdf) but I don't see them in the NYC open data portal. Please let me know if I'm just overlooking something, thanks.

Property Exemption Detail

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

Hi,

There is a plan to update the property exemption detail but that update is not ready as yet. As soon as the new data becomes available, it will be loaded to the Open Data portal.

Closed

2019-08-07T00:00:00.000

2026-10-02T00:00:00.000

5574

Data Question

Department of Citywide Administrative Services (DCAS)

Question regarding "Cert seq No.", "Request Date", "No. Vacancies". is there a guide on how to read these data? i have randomly checked few records, and found confusing. for example, exam 07005, i see a request from DOITT, and my cert seq is #6, vacancies is 10 positions, but i have NEVER received any notice nor email from DOITT. please help me better understand how to read these data, and where to report. Thank you

Civil Service List Certification

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

The dataset that you're reviewing lists the candidates whose names are certified to agencies that submit a certification request to DCAS. Being included in a certification does not necessarily mean that an agency will contact you or schedule an interview. Any communication to a candidate with respect to a certification would be made by the hiring agency.

Closed

2019-08-07T00:00:00.000

2026-10-02T00:00:00.000

5573

Data Question

Department of Buildings (DOB)

How many violations have been issued against [Address Removed]within the last three years?

DOB ECB Violations

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

You can get this information from our DOB Violations and DOB ECB Violations datasets.
https://data.cityofnewyork.us/Housing-Development/DOB-Violations/3h2n-5cm9
https://data.cityofnewyork.us/Housing-Development/DOB-ECB-Violations/6bgk-3dad

When you click the View Data button, you'll see a spreadsheet of all the DOB and ECB Violations that we have published. You can filter by using the menu in the top right. I suggest you filter by Building Identification Number (BIN). If you don't know your BIN, use our Buildings Information System to look it up by address and get the BIN.
http://a810-bisweb.nyc.gov/bisweb/bsqpm01.jsp
If you want to limit the time period, I suggest using the Issue Date in either dataset.

The answer to your question is that there are 0 DOB or ECB Violations issued to either property in the past 3 years.

Thank you,
DOB Open Data Coordinator

Closed

2019-08-07T00:00:00.000

2026-10-02T00:00:00.000

5569

Reported Error

Agency not assigned yet.

WHO UPDATES GREEN BOOK? I AM SURE GREEN BOOK NEEDS A CLEANED UP.

No URL Submitted.

Thank you for your email. I will forward the information you provided to the Green Book staff.


Senior Counsel
Department of Citywide Administrative Services (DCAS)

Closed

2019-08-06T00:00:00.000

2026-10-02T00:00:00.000

5566

Data Question

Agency not assigned yet.

Before exporting the dataset it shows that the dataset has 146,087,462 rows. However, the exported CSV(no filters) only has 77,080,576 rows. Am I missing something?

No URL Submitted.

Hi ,

Thank you for reaching out about this issue. It appears as though for some reason the download link redirects to a subset of the full 2015 dataset, from January to June 2015. There should be a full 144m rows for the full year. I will work on getting this fixed, but in the meantime you can download monthly Yellow Taxi Trip files from the Taxi and Limousine Commission's website, here:

https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page

You will find the appropriate downloads under the 2015 tab, and metadata and other associated downloads are linked at the bottom of the page.

Best,

NYC Open Data + Taxi and Limousine Commission

Closed

2019-08-05T00:00:00.000

2026-10-02T00:00:00.000

5565

Data Question

Agency not assigned yet.

This DCA dataset is listed as "update frequency: Weekly" but it has not been updated since January. Can this dataset be updated regularly?

No URL Submitted.

Response not sent yet.

Pending

2019-08-05T00:00:00.000

2026-10-02T00:00:00.000

5561

Data Question

Department of Citywide Administrative Services (DCAS)

how can i find out a list of all employees in the title of Surveyor 2

NYC Civil Service Titles

https://data.cityofnewyork.us/d/nzjr-3966

Please visit the Citywide Payroll Dataset

https://data.cityofnewyork.us/City-Government/Citywide-Payroll-Data-Fiscal-Year-/k397-673e/data

You can filter the list by "Title Description" to see a list of employees in a given title.

Closed

2019-08-01T00:00:00.000

2026-10-02T00:00:00.000

5558

Data Question

Taxi and Limousine Commission (TLC)

How often is this data set updated?

FHV Base Aggregate Report

https://data.cityofnewyork.us/d/2v9c-2k7f

Hi,

Thanks for reaching out about the FHV Base Aggregate Report data set. This list has traditionally been updated monthly, but recent changes to the TLC's data reporting standards have interrupted that schedule. Because new TLC rules have split the for-hire vehicle license into two separate license types, High Volume FHV and Traditional FHV, our IT team has required additional development time to accommodate for the new data, which has delayed updates to our lists on Open Data. We are hoping to have the FHV Base Aggregate Report updated through April in the next couple of days, and to return to a monthly update schedule over the next month or so. Please check back for updates soon.

Thanks,

NYC Open Data + Taxi and Limousine Commission

Closed

2019-08-01T00:00:00.000

2026-10-02T00:00:00.000

5557

Reported Error

Agency not assigned yet.

The Speed Limit along North and South Conduit Avenues in the vicinity of JFK is shown as 40 MPH. This speed limit was lowered to 35 MPH in 2016. Thanks!

No URL Submitted.

Hi,

Thank you for your request. The speed limit error for North and South Conduit near JFK has been updated from 40 MPH to 35 MPH.

Thank you,
- NYC Open Data Team

Closed

2019-07-31T00:00:00.000

2026-10-02T00:00:00.000

5549

Data Question

Agency not assigned yet.

This dataset claims to haveParking Violations Issued during Fiscal Year 2019 (August 2018 – June 2019), but I also see hundreds of tickets issued in July and June 2018, as well as some tickets from 2017. Why are there tickets earlier than August 2018 in this dataset?

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please note that the date information entered on the ticket is a subject to a human error. These ticket were issued in the FY2019 but the dates might reflect different FY or even far into the future (Ex: 01/23/2029)

Thank you,
- NYC Open Data Team

Closed

2019-07-29T00:00:00.000

2026-10-02T00:00:00.000

5541

Data Question

Department of Buildings (DOB)

There are codes in the Permit Type field of DOB Permits Issuance dataset (https://data.cityofnewyork.us/Housing-Development/DOB-Permit-Issuance/ipu4-2q9a) that don't appear under Permit Types in the Acronym Glossary: e.g. EW, NB, AL, EQ. Could you clarify? Also, Permit Sub Types aren't defined in the Acronym Glossary, and that would be helpful. The purpose of that field and of the relationship between these three fields is unclear to me, so any clarification would be appreciated. Thanks!

DOB License Info

https://data.cityofnewyork.us/d/t8hj-ruu2

You can get this information from our DOB Violations and DOB ECB Violations datasets.
https://data.cityofnewyork.us/Housing-Development/DOB-Violations/3h2n-5cm9
https://data.cityofnewyork.us/Housing-Development/DOB-ECB-Violations/6bgk-3dad

When you click the View Data button, you'll see a spreadsheet of all the DOB and ECB Violations that we have published. You can filter by using the menu in the top right. I suggest you filter by Building Identification Number (BIN). If you don't know your BIN, use our Buildings Information System to look it up by address and get the BIN.
http://a810-bisweb.nyc.gov/bisweb/bsqpm01.jsp
If you want to limit the time period, I suggest using the Issue Date in either dataset.

The answer to your question is that there are 0 DOB or ECB Violations issued to either property in the past 3 years.

Thank you,
DOB Open Data Coordinator

Closed

2019-07-26T00:00:00.000

2026-10-02T00:00:00.000

5537

Data Question

Department of Buildings (DOB)

Approximately when will time fields be added to this dataset? Thanks!

DOB NOW: Build – Job Application Filings

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

This one just got assigned to me, and I already answered your followup question, so I'm just closing this out.

DOB Open Data Coordinator

Closed

2019-07-26T00:00:00.000

2026-10-02T00:00:00.000

5534

Data Question

Department of Finance (DOF)

Hello, can you please tell me what the PSTATUS abbreviations ( e.g. A, AR,SA, AT, D, DL, P, W) stand for? Thank you

Property Exemption Detail

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

Hi,

Please see the data dictionary for the dataset, https://data.cityofnewyork.us/City-Government/Property-Exemption-Detail/muvi-b6kx. This document was recently updated with the possible PTSTATUS codes and their descriptions.

Closed

2019-07-26T00:00:00.000

2026-10-02T00:00:00.000

5530

Data Question

Department of Transportation (DOT)

I am looking at the parking regulation and signs dataset and had a few questions about some of the sign attributes. In particular, I was confused what the sign sequence, distance from curb line, arrow points, and sign code attributes were. Any clarification on these would be helpful. Thank you

Parking Regulation Locations and Signs

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

Thank you for your dataset inquiry. The Parking Regulation and Signs dataset is scheduled for an update for December, 2019.

The answers to your question are as follows:
Sign sequence (SRP_Seq)- The unique identifier of the Sign Order. One sign order may contain multiples of the same sign.
Distance from the curb line (SR_Distx)- The distance between the curb and the sign in feet.
Arrow points (SR_Arrow)- If the sign contains an arrow (eg: One-Way Sign), the column describes the direction of the arrow, otherwise it is NULL.
Sign code (SR_Mutcd_Code)- The unique identifier of the sign based on the design.

Best,
NYC DOT – Open Data Team

Closed

2019-07-25T00:00:00.000

2026-10-02T00:00:00.000

5529

Reported Error

Agency not assigned yet.

errors I am looking for Manhattan Community Board 3, thanks.

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. To identify the records for the Manhattan Community Board 3, please filter this dataset​ for "Borough is Manhattan" and the next filter "Community District is 3". Please refer to https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View for more information on how to use Socrata filter feature.

Thank you,
- NYC Open Data Team

Closed

2019-07-25T00:00:00.000

2026-10-02T00:00:00.000

5527

Data Question

Agency not assigned yet.

Hello, I am currently working for a university project concerning a competitor analysis within the ride-hailing and ride-pooling market. For my research I found the website of NYC Taxi & ridehailing usage which includes very valuable Information about the market itself. I would like to know how you define ride-hailing for the graphs and statistics? Via, for example, is operating in the ridepooling market (on-demand transit market) which is not specifically ride-hailing (. They use an algorithm and always try to "pool" people as best as possible. Do you have any further specific information about the background indicators and numbers which are used for the graphs and statistics? I would really much appreciate it to receive some more background information and details on that.

Thank you very much in Advance!

No URL Submitted.

Thank you for reaching out about the Taxi and Limousine Commission's open data. The dashboard you are referring to was not created by the TLC, so we cannot speak to the language used by its creator, in the graphs and statistics he produced. Uber, Lyft, Via, and Juno all operate in New York City under the TLC's High-Volume For-Hire Service license. Businesses that currently dispatch or plan to dispatch more than 10,000 for-hire vehicle (FHV) trips in NYC per day under a single brand, trade, or operating name via FHV bases must apply for the High-Volume For-Hire Service license. We do not legally differentiate between services that are primarily pooled, like Via, or sometimes pooled, like Uber and Lyft, although the congestion surcharge paid by the passenger is reduced for pooled trips. You can read more about the High-Volume For-Hire Services license, and the rules that created that license class, here: https://www1.nyc.gov/site/tlc/businesses/high-volume-for-hire-services.page

While we do not legally differentiate between the High Volume For-Hire Services company who do majority pooled versus majority non-pooled trips, all HVFHS trips are subject to new Driver Income rules, which you can read about here: https://www1.nyc.gov/assets/tlc/downloads/pdf/driver_income_rules_12_04_2018.pdf
These rules dictate that a measure of a company's utilization, defined as the percentage of time drivers are on a trip per working hour, be a factor in how much that company has to pay its drivers per trip. This will impact each HVFHS company differently, based on the utilization rate they maintain.

The dashboards are based on the FHV Base Aggregate Reports, which the TLC publishes to NYC Open Data here: https://data.cityofnewyork.us/Transportation/FHV-Base-Aggregate-Report/2v9c-2k7f/data. You can find metadata available for download under the 'About' tab.

Best,
NYC Open Data + Taxi and Limousine Commission

Closed

2019-07-25T00:00:00.000

2026-10-02T00:00:00.000

5526

Data Question

New York City Police Department (NYPD)

How does the arrest data differ from the NYPD Complaint data https://data.cityofnewyork.us/browse?q=NYPD%20Complaint%20Data%20Historic&sortBy=relevance ? Is it that the crime data details where the crime happened, and the arrest data details when and where the arrest regarding the crime was made?

NYPD Arrests Data (Historic)

https://data.cityofnewyork.us/d/8h9b-rp9u

Hi,

A complaint is usually citizen generated, though officers during their routine duties may generate one. Complaints are basically allegations of a criminal event. Arrests are when a suspect is actually taken into custody for committing a crime.

Thank you,
- NYC Open Data Team

Closed

2019-07-24T00:00:00.000

2026-10-02T00:00:00.000

5522

Data Question

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

Hi! I was looking at this sea-level rise map the city provides and I notice that it says "2050s 500-year floodplain." So does this mean the map shows flood zones for 2050 or 500 years after 2050?

Sea Level Rise Maps (2050s 500-year Floodplain)

https://data.cityofnewyork.us/d/qwca-zqw3

​Thank you for contacting NYC Open Data Help Desk. This map is based on the FEMA's Preliminary Work Map. Please refer to this article that provides additional details - https://www.climate.gov/news-features/featured-images/future-flood-zones-new-york-city
​
​​You are also encouraged to reach out directly to FEMA for more information at
​https://www.fema.gov/contact-us

Thank you,
- NYC Open Data Team

Closed

2019-07-23T00:00:00.000

2026-10-02T00:00:00.000

5519

Data Question

Department of Citywide Administrative Services (DCAS)

Good Afternoon, my question is about the current active civil service list for STAFF ANALYST title. Can you please guide me through how list #'s are assigned to test takers who received the same score in a civil service exam? Are they assigned based on certain criteria such as SS#, last name/first name etc.? Because I noticed that different list #'s are assigned to test takers with the same score. For example, in the current Staff Analyst list, list number 71-173 have been assigned to test takers who scored 98.75. Thank you.

Civil Service List (Active)

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

In answer to your question, in instances where multiple candidates on an eligible list receive the same score, list numbers are assigned by using certain digits of each candidate's social security number. When agencies request that candidates be certified, the names of all candidates with the same scores are provided as a "tie group".

Closed

2019-07-23T00:00:00.000

2026-10-02T00:00:00.000

5508

Data Question

Agency not assigned yet.

Hello! I'm a grad student doing research on data sharing in transportation. I'd read that NYC required FHVs to give specific pickup and dropoff locations, as well as license plates for the performing vehicle, which would then be shared in the public dataset. I downloaded this dataset to confirm, and found that pickups and dropoff zones were shown instead. Has NYC TLC begun requesting less specific data, or is the specific location data available upon request? Thank you for any information!

No URL Submitted.

Thanks for reaching out about the TLC's trip data. The TLC still collects vehicle plate, pickup lat/long, and dropoff lat/long for all trips, but we stopped releasing that information to the public through Open Data or Freedom of Information Law (FOIL) requests over concerns about our drivers' and passengers' privacy. When we first began releasing trip records containing anonymized driver identifiers and full lat/longs, users of the dataset were able to re-identify drivers and also to isolate the trips of specific passengers, so we now classify coordinates as Personally Identifying Information, exempt under FOIL. This policy regarding coordinate data was enacted before the TLC published FHV data, only taxi, so the coordinates of FHV trips have never been released.

The TLC has no plans to begin releasing coordinates at this time, but you can use the PULocationID/DOLocationID fields to determine the neighborhood of origin and the destination of each trip. These IDs come from the Taxi Zone map, which is also available on NYC Open Data: https://data.cityofnewyork.us/Transportation/NYC-Taxi-Zones/d3c5-ddgc

Best,
NYC Open Data + Taxi & Limousine Commission

Closed

2019-07-22T00:00:00.000

2026-10-02T00:00:00.000

5506

Data Question

Department of Finance (DOF)

Hello, can you please tell me what the PSTATUS abbreviations ( e.g. A, AR,SA, AT, D, DL, P, W) stand for?

Property Exemption Detail

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

Hello, thank you for your inquiry. Please find that the data dictionary for this dataset hasd been updated to include the definitions for the values contained in the "PSTATUS" column: https://data.cityofnewyork.us/api/views/muvi-b6kx/files/b6782200-80e3-4892-9be6-a7bb4744c262?download=true&filename=Data_Dictionary_for_Property_Tax_Exemptions.xlsx

Thank you,
- NYC Open Data Team

Closed

2019-07-22T00:00:00.000

2026-10-02T00:00:00.000

5504

Data Question

Agency not assigned yet.

Over by W 30th St and 11 Ave in the area of the Vessel. Is there a new road called Hudson Blvd?

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Hudson Blvd can also be found on the Google maps:
​​https://www.google.com/maps/place/Hudson+Blvd+E,+New+York,+NY/@40.7541265,-74.0028429,17z/data=!4m5!3m4!1s0x89c259b343d56e5b:0xfab47714a861a35c!8m2!3d40.7551587!4d-74.0005147

Thank you,
- NYC Open Data Team

Closed

2019-07-22T00:00:00.000

2026-10-02T00:00:00.000

5499

Data Question

Department of Citywide Administrative Services (DCAS)

Hi, my question is about the current active civil service list for STAFF ANALYST. I don't quite understand how the list #'s are created, since people who received the same score as mine didn't get the same list #. Can you please kindly advise how does DCAS rank test takers with the same score? Thank you.

Civil Service List (Active)

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

A list number indicates a candidate's position on a list. There is a separate list number for each person. For example, if 100 people received a score of 90, each of the 100 persons would have a different list number but the same score.

Closed

2019-07-19T00:00:00.000

2026-10-02T00:00:00.000

5494

Data Question

Agency not assigned yet.

Regarding dataset "Medallion Vehicles - Authorized":

It appears there are nearly 12 million rows of data in this set. Because it is so large, I am having trouble culling the data. I'm also only able to download an incomplete set to my computer through excel (is there a better way to do this to get a complete set?).

I am assuming the nearly 12 million figure represents duplicative entries for the same vehicles. In short, I am looking for:

1) how many yellow cabs are currently authorized?

2) how many of those are WAV vehicle type?

Thank you for any assistance you can offer with this.

My phone number is 212-244-4664.

No URL Submitted.

Thank you for reaching out. You are correct in saying that there are duplicate entries-- the 'Medallion Vehicles - Authorized' list appends new records daily, rather than replacing the previous day's list. We are currently exploring new ways of archiving prior records, so this may change over the course of the next year or so.

If you were interested in only currently authorized medallions and which ones of those were hacked up as WAVs, you can use the date filter 'Last Date Updated' and set to the previous day's date (or the current date, if you are checking in the evening). This should pull <13k records, which you can further filter for WAV/non-WAV using the 'Vehicle Type' column.

Please let us know if you have any further questions!

Best,
NYC Open Data + Taxi and Limousine Commission

Closed

2019-07-18T00:00:00.000

2026-10-02T00:00:00.000

5492

Reported Error

Agency not assigned yet.

The api endpoint for this dataset was https://data.cityofnewyork.us/resource/qpyv-8eyi.json until ~5 PM EDT on July 17, 2019 (21:00 07/17/2017 UTC), but then changed without notice to https://data.cityofnewyork.us/resource/faiq-9dfq.json.

This is now the fourth time an API endpoint for a dataset I use has changed without warning. The service I run is not critical, but many people depend on it, and any such changes should be announced in advance, in lieu of not happening to begin with. I use several fiscal year datasets, and when the fiscal year ends, the closing dataset (for the ending fiscal year) receives a new endpoint instead of simply remaining as is. Could you please investigate why this is happening and how to prevent it from happening in the future?

No URL Submitted.

Hi ,

The situation you describe is not about the data itself but more about the operational maintenance of the data on the portal.

The pages that have been created on the Open Data Portal for the monthly “Parking Violations Issued” of parking tickets by Fiscal Year contain static information. At the end of each Fiscal Year, the data for that current Fiscal Year is archived onto a separate page per City guidelines and the “current” Fiscal Year page is maintained for the “new current” Fiscal Year.

Closed

2019-07-17T00:00:00.000

2026-10-02T00:00:00.000

5489

Reported Error

Agency not assigned yet.

This data was a record in 2018, but there are several rows that theirs datetimes are 2001, 2084, etc. Please check.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. The 2018 Taxi Trip Data, as well as all of our trip data, is uploaded to Open Data exactly as the TLC received it-- we do not modify any records that were submitted by technology providers authorized under the Taxicab & Livery Passenger Enhancement Programs, or TPEP/LPEP (see the disclaimer on the dataset for more info). These incorrect dates were errors that occurred with the metering of the trip or with the software, and were passed along to us. We recommend filtering by the date range of the dataset, in your case Jan 1 2018 - Dec 31 2018. Please let us know if you have any further questions.

Thanks,
NYC Open Data + Taxi and Limousine Commission

Closed

2019-07-16T00:00:00.000

2026-10-02T00:00:00.000

5488

Data Question

Department of Buildings (DOB)

The NYC Construction Dashboard provides a "Permit Time Series (2000-2019)" chart that shows total number of permits each year by type (i.e. New Build, Demolition, A1, A2, and A3). This data encompasses all permits across residential, commercial, and industrial. I was hoping to get this exact same data set but for JUST commercial (so excluding residential). If the existing backup data for the data set classifies each permit by whether it is residential/commercial/industrial, then the backup data will do just fine. Thanks!

DOB Permit Issuance

The DOB Permit Issuance dataset has a field called "Residential". Just filter that to exclude any "Yes" values, and you should have the data that you're looking for. Let me know if you have any additional questions.

Thank you,
- DOB Open Data Coordinator

Closed

2019-07-16T00:00:00.000

2026-10-02T00:00:00.000

5486

Data Question

Office of Technology and Innovation (OTI)

Is there any capture of data for embodied carbon in the Buildings Footprint?

Building Footprints (Deprecated)

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

Hi {{ respondent_name }},

At this time, we believe that your requested dataset is not maintained by a New York City agency.
Particularly, Data on carbon embodiment is not captured in this dataset.

You are welcome to submit a new dataset request with additional detail and specifically named agencies for referral.

Thank you,
- NYC Open Data Team

Closed

2019-07-16T00:00:00.000

2026-10-02T00:00:00.000

5485

Data Question

Agency not assigned yet.

Hello - I have been in touch regarding gathering vehicle data for the Bell Blvd Bayside area. Can someone please assist with gathering this info. I only see info for Queens in a particular area.
If someone could provide a number for me to speak with someone that would be best.
Thank you

No URL Submitted.

Thank you for your request. At this time, the your requested dataset is not maintained by a New York City agency.
You may request for a new Vehicle and Pedestrian Counts study by visiting the Contact DOT website and fill out the form: https://www1.nyc.gov/html/dot/html/contact/contact-form.shtml

Thank you,
- NYCDOT Open Data Team

Closed

2019-07-16T00:00:00.000

2026-10-02T00:00:00.000

5484

Data Question

Agency not assigned yet.

Is there any way for us to tie trips to an individual (anonymized) driver? We are trying to understand the utilization gap between Uber and Lyft in NYC.

No URL Submitted.

The TLC stopped releasing anonymized driver identifiers over concerns that the data could be re-identified to reveal Personally Identifying Information about our drivers. We have no plans to add anonymized driver identifiers back to our trip records.

Thanks,
NYC Open Data + Taxi & Limousine Commission

Closed

2019-07-16T00:00:00.000

2026-10-02T00:00:00.000

5482

Data Question

Taxi and Limousine Commission (TLC)

I only see data through January 2019, but noticed Bloomberg published an article with Uber and Lyft data through May. Where do I find the Lyft and Uber trip data through May?

FHV Base Aggregate Report

https://data.cityofnewyork.us/d/2v9c-2k7f

The TLC sometimes provides summary statistics on request for press—Bloomberg received those numbers directly through our Public Affairs office, not through Open Data. Because new TLC rules have split the for-hire vehicle license into two separate license types, High Volume FHV and Traditional FHV, which have different data reporting standards, our IT team has required additional development time to update our monthly aggregate reports on Open Data. We anticipate that this work will be done soon, so please check back frequently.

Thanks,
NYC Open Data + Taxi and Limousine Commission

Closed

2019-07-16T00:00:00.000

2026-10-02T00:00:00.000