NYC Open Data Help Desk: Data Questions and Reported Errors

5809

Data Question

Agency not assigned yet.

Under the columns "tpep_pickup_datetime" and "tpep_dropoff_datetime," some values are entered as times that have not yet occurred. For example, "2084 Nov 04 12:32:24 PM" is a date and time that is a bit far in the future.

No URL Submitted.

Hi,

Thank you for reaching out about the 2018 Yellow Taxi Trip Record dataset on NYC Open Data. The TLC publishes trip records from our technology service providers, who record taxi meter information, exactly as they were provided to us. In a small number of cases, malfunctions in metering equipment cause incorrect dates to be recorded. The TLC does not modify or eliminate those records, but they are a small part of the millions of records that are collected. You can see more information about trip records at https://www1.nyc.gov/assets/tlc/downloads/pdf/trip_record_user_guide.pdf

Best,
NYC Open Data + Taxi and Limousine Commission

Closed

2019-09-26T00:00:00.000

2026-10-02T00:00:00.000

5805

Data Question

Department of Finance (DOF)

Does this parcel data include the zoning of each parcel?

Department of Finance Digital Tax Map

https://data.cityofnewyork.us/d/smk3-tmxj

Hi,

No, it does not include zoning. You may be able to get this data from the Department of City Planning Mappluto dataset.


Thank you,
- NYC Open Data Team

Closed

2019-08-27T00:00:00.000

2026-10-02T00:00:00.000

5800

Data Question

Department of Buildings (DOB)

How do I find out if violations on a property have been cleared

DOB Violations

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

Hi,

You can check our DOB Violations and DOB ECB Violations datasets here on Open Data. The VIOLATION_CATEGORY column in the DOB Violations dataset will tell you if it's Active, Resolved, or Dismissed. The ECB_VIOLATION_STATUS in the DOB ECB Violations dataset will tell you if it's Active or Resolved.

You could also look up an individual property in our Buildings Information System to see if it has open violations.

Thank you,

Closed

2019-09-24T00:00:00.000

2026-10-02T00:00:00.000

5796

Data Question

Department of Buildings (DOB)

Hello,

Thank you for the work you do to make information accessible to the public! I am writing because I am trying to access information about building permits for [Address Removed]. The BIN is 304XXX. If I don't see that building in your dataset, is that just because the data set is incomplete? Or because there has never been a permit request?

Best,

DOB Permit Issuance

Hi,

It's always good to hear from people who appreciate the work we do!

You have the right idea using BIN to search in our datasets as everything we do is based on BIN. But I'm showing a different BIN for this property. Best way to get a BIN is to first search in our Buildings Information System (BIS) by address. You can look up all the information for 102 Albemarle Road on our Property Profile page, which shows the BIN as 312XXXX. If you use that BIN on our Permit Issuance dataset, you'll find a number of permits going back to 1991. Open Data doesn't show the Apartment Number, but you can find more details on the individual permits on the BIS Property Profile page if you dig into the job applications and permits.

Thank you,
- DOB Open Data Coordinator

Closed

2019-09-24T00:00:00.000

2026-10-02T00:00:00.000

5793

Data Question

Office of Administrative Trials and Hearings (OATH)

Many violations are displaying empty fields in the "Balance Due" column, however there is a balance. E.G. Ticket Number 050053168Y should have a $10,000.00 balance.

OATH Hearings Division Case Status

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

Hi,

​Thanks You for your inquiry. The details you have provided are very helpful and have been noted. We are investigating the cause of this discrepancy and are working to fix this error.

Thank you,
- NYC Open Data Team

Closed

2019-09-23T00:00:00.000

2026-10-02T00:00:00.000

5792

Data Question

Department of Investigation (DOI)

Why does the dataset description say "pending, scheduled and executed" evictions, but the SCHEDULE_STATUS field only says 'Scheduled' for every record?

Evictions

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

Hi, we thank you for you patience. Your inquiry was routed to the Department of Investigation (DOI) who acknowledged your inquiry and recognized the confusion that could occur from the "SCHEDULED_STATUS"

To clarify per the agency, "The true indicator of whether an eviction was executed is found in the EXECUTED_DATE column. "

Thank you,
- NYC Open Data Team

Closed

2019-09-23T00:00:00.000

2026-10-02T00:00:00.000

5791

Data Question

Department of Housing Preservation and Development (HPD)

The complaints and problems (https://data.cityofnewyork.us/Housing-Development/Complaint-Problems/a2nx-4u46) datasets appear to be updated daily on the HPD portal, but are only updated once per month on the Open Data Portal. Could you update the data with the same frequency on Open Data, as you do with Violations data?
For example, one exact query used to the Socrata API (in Python) was:
where='created_date > "2019-01-01T00:00:00" AND lower(descriptor) like "%rental%"',

The only results were unrelated to short term rentals.

Thanks in advance for your help!

Housing Maintenance Code Complaints

Hi,

We're actively working on this request and hope to have our complaints dataset update daily instead of monthly in the coming weeks.

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

Closed

2019-09-23T00:00:00.000

2026-10-02T00:00:00.000

5787

Data Question

311

I sent a request for the helicopter noise dataset this morning because the filters on the 311 website didn't work. I am following the correct steps and also contacted Support.
However, since time is of the essence, if you can email me this specific dataset, I would very much appreciate it.

My initial request:
I need the dataset for Helicopter Noise Complaints from September 21, 2017 to September 21, 2019.
This will be used for my Graduate School research project.
I am on a tight deadline so I would needed by end of today if possible. I would very much appreciate it if you can send it to my emai

311 Service Requests from 2020 to Present

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

Thank you for contacting NYC Ope Data Help Desk. Please work with the Socrata support to resolve this issue. Meantime, we have created a temporary filter listing Noise - Helicopter complaints, which you can find at https://data.cityofnewyork.us/Social-Services/Nois...You can save this data in a CSV text file or other format using Export feature.

Thank you,
- NYC Open Data Team

Closed

2019-09-23T00:00:00.000

2026-10-02T00:00:00.000

5786

Data Question

Department of Citywide Administrative Services (DCAS)

When I export this data for Excel, the "# of Positions" column does not get exported. This column used to get exported in the past. I have several assignments for my students based on this data and many calculations using the # of Positions data. I noticed the problem in Feb of 2019 and used a work around for the spring semester. Can this column be included in the exported data again?

Jobs NYC Postings

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

Hi,

The data you've requested can be found here: https://data.cityofnewyork.us/City-Government/NYC-Jobs/kpav-sd4t The ability to download your desired column has been restored.

Thank you,
- NYC Open Data Team

Closed

2019-09-16T00:00:00.000

2026-10-02T00:00:00.000

5780

Data Question

Agency not assigned yet.

What do I need to get an access to this data? What areas of open data are restricted?
Thank you.

No URL Submitted.

Hi,

Thanks for reaching out about the former TLC Vehicle Insurance list. The TLC has archived that list on Open Data but you can get up-to-date insurance information here:

https://www1.nyc.gov/site/tlc/vehicles/vehicle-insurance-information.page

Please let us know if you have any further questions.

Best,

NYC Open Data + Taxi and Limousine Commission

Closed

2019-09-20T00:00:00.000

2026-10-02T00:00:00.000

5779

Data Question

Department of Buildings (DOB)

you mentioned that the industry will be filing different applications for each type of work, but how many different types are there? I'm looking at the permits acronym glossary and it doesn't even cover electrical or elevator work, so where can I find a list of work type that will be filed separately from general construction? Also, is there a repository of past press releases/announcements from the DOB regarding open data? I recently stumbled onto this https://www1.nyc.gov/assets/buildings/pdf/dob_now_build_sidewalk_scaffolding_fence_sign_info_session.pdf which has been helpful but hasn't been updated in 18 months. I also read the open data for all report, but that's painting a much broader picture. Also, if it's not too much to ask, please respond directly to my email so we can just keep a thread going.

DOB Permit Issuance

Here are the answers to your questions:

1. you mentioned that the industry will be filing different applications for each type of work, but how many different types are there?
Check out our website for this information. The DOB NOW: Build page keeps an updated list of the work types for new construction. And the DOB NOW: Safety page keeps an updated list for safety compliance filings. Subscribe to our newsletter for updates.

2. is there a repository of past press releases/announcements from the DOB regarding open data?
We don't have a repository specific to Open Data, but on our website you can find past press releases. And you can subscribe to our Open Data mailing list for new announcements related to DOB Open Data.

3. I recently stumbled onto this
On the Build and Safety pages (linked above), you can find FAQ and Resources for each Work Type. The PDF you found was a training document from the release for Sidewalk Shed, Supported Scaffold, Construction Fence, and Sign Filings, and will not be updated. You can find the other documents for that work type, and possibly newer ones on the Shed/Scaffold/Fence/Sign Resources page.

4. please respond directly to my email
I prefer questions about our data to come in through this form so that I can track volume of requests. It helps me when I talk to my boss about staffing and budgets to let them know how much of my time is taken by answering questions. (Emails with data requests from the public get lost in the mix of my internal DOB emails and are harder to count.) That said, I'm happy to schedule a phone call with you if you have many more questions. If you would like to chat on the phone, I'm available for a 30 minute conversation 9am-noon on Thursday 9/26 or 9am - 4pm on Friday 9/27. Let me know what time works best for you.

Closed

2019-09-20T00:00:00.000

2026-10-02T00:00:00.000

5772

Data Question

Department of Finance (DOF)

Hi - where can i find a glossary of terms for the column headers that appear in the property tax exemption detail data? thank you!

Property Exemption Detail

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

Hello, You can find the data dictionary for this data on the primer page. https://data.cityofnewyork.us/City-Government/Property-Exemption-Detail/muvi-b6kx
The donwload ticket for the file can be found here: https://data.cityofnewyork.us/api/views/muvi-b6kx/files/b6782200-80e3-4892-9be6-a7bb4744c262?download=true&filename=Data_Dictionary_for_Property_Tax_Exemptions.xlsx

If you have any questions feel free to update you ticket

Closed

2019-09-23T00:00:00.000

2026-10-02T00:00:00.000

5769

Data Question

Agency not assigned yet.

Some of the Yellow Taxi dataset links don't work, tested in a variety of browsers on different OSes. I'd really like to download each dataset

Specifically, I am trying to access the 2009, 2010, and 2015 datasets. I am unable to access them due to "ERR_TOO_MANY_REDIRECTS" (being stuck in a redirect loop).

(Related error: The 2018 dataset link works, but the CSV export link takes several minutes to load, and so seemed broken.)

No URL Submitted.

Hi,

The data you've requested can be found here:
2015 Yellow Trip Data https://data.cityofnewyork.us/dataset/Yellow-Tripdata-2015-January-June/2yzn-sicd
​2009 Yellow Trip Data https://data.cityofnewyork.us/Transportation/2009-Yellow-Taxi-Trip-Data/f9tw-8p66

Thank you,
- NYC Open Data Team

Closed

2019-09-19T00:00:00.000

2026-10-02T00:00:00.000

5766

Data Question

Department of Small Business Services (SBS)

I saw there are two dataset for the ECSP program:
- https://data.cityofnewyork.us/City-Government/Value-of-Energy-Cost-Savings-Program-Savings-for-B/va74-3m6c
- https://data.cityofnewyork.us/City-Government/Jobs-Created-by-Energy-Cost-Savings-Program-Saving/xsd9-52hv

I would like to know whether there is anyone I could speak to who can help to clarify differences between these two dataset. I looked up the same company on both files but the benefits stated for those companies are different.

Thank you.

Value of Energy Cost Savings Program Savings for Businesses - FY2019

Response not sent yet.

Pending

2019-09-18T00:00:00.000

2026-10-02T00:00:00.000

5763

Reported Error

Agency not assigned yet.

Are any fields constrained by a character limit? I'd like to know for the job applications data set, as well as issued permits and license info. Additionally, many firm names in permits and licenses are truncated to things like john doe const. grp. is any effort being undertaken to standardize these things? The same issue arises for street names, we see 8th, 8, eighth, and eight for street name followed by ave, ave., or avenue. This yields 12 ways a single street name can be presented in these data sets. Additionally, the combination of DOB NOW job applications and associated DOB NOW permits yields much less information regarding the timeline of a project than the combination of standards jobs and permits. Not only this, but there is no job description, so one is left to infer the scope of the project by the descriptions included in its associated permits. Why is that? There is information visible on the DOB NOW portal regarding architects firm names, is there any plan to publish this information?

No URL Submitted.

Hi,

You've asked a lot of questions! Here are some answers:

Are any fields constrained by a character limit?
Yes, some are. When I am aware of them I try to indicate this in the data dictionary. The documentation takes a lot of research, whether it's getting some time on IT's calendar or interviewing a business unit for information about how their unit works. I try to provide as much information as possible when I get it.
I'd like to know for the job applications data set, as well as issued permits and license info.
All 3 of the datasets you mention here are based on our old BIS system. We are migrating all transactions into DOB NOW. We will not be focusing our resources on those older datasets. Next year, we will implement a major new release in DOB NOW that will mean that almost all new construction will be moved out of BIS. We will then be focusing on improvements to DOB NOW data. Check out our most recent dataset release, DOB NOW Electrical Permit Data, for an idea of this new work.
Additionally, many firm names in permits and licenses are truncated to things like john doe const. grp. is any effort being undertaken to standardize these things?
No. The applicant/licensee is free to type in their business name as they see fit.
The same issue arises for street names...
This, too, is free text. I hope that in the future we will be able to standardize addresses, but as it stands right now, what you see is what you get. We typically use BIN for location information, as that is standardized by its nature.
Additionally, the combination of DOB NOW job applications and associated DOB NOW permits yields much less information regarding the timeline of a project than the combination of standards jobs and permits...no job description...architects firm names
Yes, our initial DOB NOW datasets were not designed optimally. We will be revisiting them after the major General Construction release in DOB NOW scheduled for next year.

Closed

2019-09-18T00:00:00.000

2026-10-02T00:00:00.000

5755

Data Question

Office of Administrative Trials and Hearings (OATH)

Any violations or Notice of Violations or Hearings on file for Wildlife Conservation Society (aka WCS). Can be in Bronx, Manhattan, Queens or Brooklyn Counties.
What question are you trying to answer with this data?
I STILL keep getting errors when I try to obtain the data. I tried opening up the dataset using Microsoft, Google and Firefox and the terms "Wildlife", Wildlife, WILDLIFE. I get the message that there are either no rows (when I use filter as suggested) or no results.

OATH Hearings Division Case Status

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

Thank you for contacting NYC Open Data Help Desk. For technical issues, you are encouraged to directly contact Socrata support at https://support.socrata.com/hc/en-us

Thank you,
- NYC Open Data Team

Closed

2019-09-18T00:00:00.000

2026-10-02T00:00:00.000

5753

Data Question

Agency not assigned yet.

Can you please provide information about final Certificate of Occupancy for [Address Removed]?
Thank you

No URL Submitted.

You can find information about the final C of O in DOB Certificate Of Occupancy. You can filter the data by the address. Just make sure when you type the street name that you type it as "SUMMIT ST" or you won't find what you're looking for.

You can also view the actual certificate on our Buildings Information System website. On the Property Profile for this building, you would click on "View Certificates of Occupancy" near the top right. The final C of O is called "321362379F.PDF".

Thank you,
DOB Open Data Coordinator

Closed

2019-09-17T00:00:00.000

2026-10-02T00:00:00.000

5749

Data Question

Agency not assigned yet.

In the pdf dictionary item for the bike_lane column, there are 11 valid bike lane types listed. When viewing the data directly, there are only 9 valid bike lane types, as well as NA values. Should this be interpreted as:

1) There are no instances of type 10 or 11 bike lanes, and all existing lanes should correspond to their matching value in the pdf

2) The numbers in the dataset do not correspond to their matching value in the pdf

3) Some other way of handling

I would appreciate any input on the subject.

No URL Submitted.

Hi ,

Thanks for your patience as we worked to route your inquiry to the proper agency and team. Going back to your inquiry that it's option 1: There are no instances of type 10 or 11 bike lanes, and all existing lanes should correspond to their matching value in the PDF.

Thank you,
- NYC Open Data Team

Closed

2019-09-16T00:00:00.000

2026-10-02T00:00:00.000

5748

Data Question

Agency not assigned yet.

Data needed going back five (5) years from today's date:
Ticket number, violation date, issuing agency, respondent last name, penalty imposed, paid amount, charge #1 code description, compliance date, and decision date.
What question are you trying to answer with this data?
I am with the New York City Department of Investigation conducting Vendor Name Checks (VNCs) for the New York City Housing Authority. As part of the VNC process we need to check for any outstanding ECB violations the vendors may have.

No URL Submitted.

Hi *****,

There is no field in the dataset which specifically designates ECB and non-ECB cases. Therefore, a combination of filtering conditions can probably produce results of ECB specific summonses. One option is to create multiple filters using the Issuing Agency field to note "Not Containing" and "DCA", "TAXI" and "PCS - DOHMH", "DOHMH - Pest Control", "Cooling Towers - DOHMH", "Bed Bugs - DOHMH", and "Vector - DOHMH" which would be non-ECB summonses.

Thank you,
- NYC Office of Administrative Trials and Hearings

Closed

2019-09-16T00:00:00.000

2026-10-02T00:00:00.000

5747

Data Question

Agency not assigned yet.

In the pdf dictionary item for the bike_lane column, there are 11 valid bike lane types listed. When viewing the data directly, there are only 9 valid bike lane types, as well as NA values. Should this be interpreted as:

1) There are no instances of type 10 or 11 bike lanes, and all existing lanes should correspond to their matching value in the pdf

2) The numbers in the dataset do not correspond to their matching value in the pdf

3) Some other way of handling

I would appreciate any input on the subject.

No URL Submitted.

Hi,

The NTA's were created by the Department of City Planning (DCP) based off of 2010 Census Tracts. This is mentioned in the description of the data on the open data page "Boundaries of Neighborhood Tabulation Areas as created by the NYC Department of City Planning using whole census tracts from the 2010 Census as building blocks." There has been no re-districting since 2010. The NTAs are maintained in LION (our street centerline file), so slight adjustments are applied to the NTAs based on updates to LION and released quarterly.

Thank you,
- NYC DCP Open Data Team

Closed

2019-09-16T00:00:00.000

2026-10-02T00:00:00.000

5746

Data Question

Department of Buildings (DOB)

s there a reason why many business names have shortened group or construction to grp. and const.?

DOB License Info

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

Hi,

That field is free text, and the licensee is able to write in the Business Name however they like.

Thank you,
- DOB Open Data Coordinator

Closed

2019-09-16T00:00:00.000

2026-10-02T00:00:00.000

5745

Data Question

Department of Buildings (DOB)

Are any fields constrained by a character limit? I'd like to know for this data set, as well as issued permits and license info. Thank you!

DOB Job Application Filings

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

***This request is a duplicate of #5763***

Closed

2019-09-16T00:00:00.000

2026-10-02T00:00:00.000

5736

Data Question

311

Hello! I'm wondering if the 311 Service Requests dataset includes _all_ 311 requests - specifically, should it include complaints about short-term rentals (Airbnb etc)? This page suggests submitting a complaint via 311: https://www1.nyc.gov/site/specialenforcement/stay-in-the-know/about-illegal-short-term-rentals.page

and this article suggests that: "In 2017, the Office of Special Enforcement received 1,800 complaints through 311" (https://www.nytimes.com/2018/06/26/nyregion/illegal-airbnb-new-york-city-bill.html)

However when searching the 311 dataset, I can't seem to find any.

I checked for the string "rental" and "airbnb" in the following fields, for complaints created in 2019:
- descriptor
- complaint_type

For example, one exact query used to the Socrata API (in Python) was:
where='created_date > "2019-01-01T00:00:00" AND lower(descriptor) like "%rental%"',

The only results were unrelated to short term rentals.

Thanks in advance for your help!

311 Service Requests from 2020 to Present

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

Response not sent yet.

Pending

2019-09-14T00:00:00.000

2026-10-02T00:00:00.000

5733

Data Question

Department of Health and Mental Hygiene (DOHMH)

Can you please clearly define Death rate and Adjusted Age?

New York City Leading Causes of Death

https://data.cityofnewyork.us/d/jb7j-dtam

Hi,

The please find the definitions for all fileds within this dataset here.
https://data.cityofnewyork.us/api/views/jb7j-dtam/files/7721c780-d09c-421e-bfa6-052c6c6a7bd0?download=true&filename=Cause%20of%20Death_121412.xlsx

Thank you,
- NYC Open Data Team

Closed

2019-09-12T00:00:00.000

2026-10-02T00:00:00.000

5731

Reported Error

Agency not assigned yet.

Good morning,

Apologies if this is the wrong category. My dataset view that uses the DOB Violations dataset has been down since the 10th.

The error that I get is "We're having trouble displaying this table. Check to make sure the underlying dataset hasn't been deleted or unpublished."

The DOB Violations dataset is published and appears to be working fine, so I'm unsure why I'm getting this message.

No URL Submitted.

Hi,

Thanks you fro bringing this to our attention. For assistance with you saved filter, please contact Socrata support via this link:

https://support.socrata.com/hc/en-us

Thank you,
- NYC Open Data Team

Sign up for our Open Data mailing list here.

Closed

2019-09-12T00:00:00.000

2026-10-02T00:00:00.000

5726

Data Question

Agency not assigned yet.

I had a question regarding the "SOURCE_ID" attribute for the Curb dataset. Does the attribute correspond to anything, or is it just a unique identifier?
I am hoping it corresponds to a street segment ID that the curb is located on (similar to the Parking Sign dataset). If you could let me know it would be appreciated.

No URL Submitted.

Hi {{respondent_name}},

Thank your for your patience on this inquiry while we contacted the appropriate team. The "SOURCE_ID" attribute for the Curb data is just a unique identifier, and it does not correspond to any street segment IDs.

Thank you,
- NYC Open Data Team

Closed

2019-09-10T00:00:00.000

2026-10-02T00:00:00.000

5725

Data Question

Department of Citywide Administrative Services (DCAS)

Hi,
My Question is, how is the description below the title updated? The reason I ask i because I work in the dpt. in DCAS that is responsible for updating the dataset concerning deed restrictions and the data set has been update successfully however is unclear what is the process for changing the description information.
Thanks,

Deed Restriction Database

https://data.cityofnewyork.us/d/rfu7-paqe

Hi,

Metadata changes to DCAS datasets (i.e. Titles , descriptions, etc) on the Open Data Portal must be requested and coordinated by the Agency's Open Data Coordinator (ODC).

Currently, the DCAS designated ODC will need to be contacted in order to coordinate any metadata updates.

Best,
- NYC Open Data Team

Closed

2019-09-10T00:00:00.000

2026-10-02T00:00:00.000

5724

Reported Error

Department of Buildings (DOB)

Is there any way to add approval dates and Mechanical worktypes

DOB NOW: Build – Job Application Filings

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

Hi ,

We do plan to update the DOB NOW: Build – Job Application Filings dataset (https://data.cityofnewyork.us/Housing-Development/DOB-NOW-Build-Job-Application-Filings/w9ak-ipjd) with dates including the date of approval and with other work types. We have another major release in DOB NOW that will affect this dataset scheduled for next summer, so the update won't happen until after that. We appreciate your patience.

Thank you,
DOB Open Data Coordinator

Closed

2019-09-10T00:00:00.000

2026-10-02T00:00:00.000

5706

Data Question

Taxi and Limousine Commission (TLC)

Hello! I was just wondering how often and exactly what time does the TLC update their FHV active vehicles and FHV active drivers lists? https://data.cityofnewyork.us/Transportation/For-Hire-Vehicles-FHV-Active/8wbx-tsch/data

For Hire Vehicles (FHV) - Active

https://data.cityofnewyork.us/d/8wbx-tsch

Hi ,

Thank you for reaching out about our active vehicle and driver lists. These lists are updated daily in the afternoon. You can find a timestamp for the last updated date in the final two columns of each list, 'Last Date Updated' and 'Last Time Updated'.

Best,
NYC Open Data + Taxi and Limousine Commission

Closed

2019-09-06T00:00:00.000

2026-10-02T00:00:00.000

5705

Data Question

Agency not assigned yet.

I would like detailed information about the specific licensing permissions associated with this dataset. Thanks.

No URL Submitted.

Response not sent yet.

Pending

2019-09-05T00:00:00.000

2026-10-02T00:00:00.000

5703

Data Question

Office of Administrative Trials and Hearings (OATH)

HELP. I need my data information. No matter what I try and search i get the message below. I used to search my company and that would filter all our violations.
Even if i search a violation number that I know is in the data, it will not find. Help please! I use this data a lot and it is too much information if I cannot search.
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-09-05T00:00:00.000

2026-10-02T00:00:00.000

5701

Reported Error

Department of Buildings (DOB)

Job Filing Numbers 'M00207218-I1' and 'M00207219-I1' show 'False' in the Sprinkler (Work Type) and Plumbing (Work Type) columns, respectively. The DOB Now Public Portal however shows 'Sprinklers' and 'Plumbing' in the Selected Work Types for the PW1.

DOB NOW: Build – Job Application Filings

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

Hi ,

We do plan to update the DOB NOW: Build – Job Application Filings https://data.cityofnewyork.us/Housing-Development/DOB-NOW-Build-Job-Application-Filings/w9ak-ipjd dataset with dates including the date of approval and with other work types. We have another major release in DOB NOW that will affect this dataset scheduled for next summer, so the update won't happen until after that. We appreciate your patience.

Thank you,
- DOB Open Data Coordinator

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

Closed

2019-09-05T00:00:00.000

2026-10-02T00:00:00.000

5698

Data Question

Office of Administrative Trials and Hearings (OATH)

No matter what I try and search i get the message below. I used to search my company and that would filter all our violations.
Even if i search a violation number that I know is in the data, it will not find. Help please! I use this data a lot and it is too much information if I cannot search.
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-09-04T00:00:00.000

2026-10-02T00:00:00.000

5697

Data Question

Department of Finance (DOF)

It appears that on/about August 30th, 2019 the column order was changed on this file. it used to be sumons_number, plate, state, license type, etc.
now it is Plate,State,License type, summons number, etc...
Changing the order of columns without saying so can cause data processing applications to fail since they are expecting certain data in certain places. Will this column order continue into the future?

Open Parking and Camera Violations

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

Hi,

We have confirmed that there was no schema changes to the to the dataset in question since 2016. is is more likely that you are speaking of DOF Parking Violations Issued which has the column ordering you are speaking of e.g. ( sumons_number, plate, state, license type, etc. ) https://data.cityofnewyork.us/d/pvqr-7yc4 the schema of this dataset has also remained unchanged since 2016.

Thank you,
- NYC Open Data Team

Closed

2019-09-04T00:00:00.000

2026-10-02T00:00:00.000

5692

Reported Error

Agency not assigned yet.

In the PAVEMENT_EDGE layer, OBJECTID 75870 is misaligned to and not coincident to the adjacent SIDEWALK layer, OBJECTID 23517. The gap is small, less than 0.01 feet, but it's enough to interfere with snap operations and spatial joins.

No URL Submitted.

Hi {{respondent_name}},

​Thank your for your inquiry. Your request was forwarded to the GIS department of the department of information technology and telecommunication who acknowledges your concerns. However, an error of less than 0.01 feet is within the Class 1 American Society for Photogrammetry and Remote Sensing (ASPRS )standard's error tolerance, which is 0.1 feet at 1:120 scale (1" = 100')."

​Please let us know if you encounter a larger discrepancy.
​
Thank you,
- NYC Open Data Team

Closed

2019-09-03T00:00:00.000

2026-10-02T00:00:00.000

5686

Reported Error

New York City Police Department (NYPD)

when I try to export 2019 ,in csv, I get text message :
"code" : "invalid_request",
"error" : true,
"message" : "Error in posted view: Cannot find column with id 425261807"
}

Motor Vehicle Collisions - Crashes

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

Hi ,

The ability to download a CSV for a particular year appears to be working as expected.
We recommend that you first use a filter on the "Date" column and isolate data for all dates with the [BETWEEN] condition from 1/1/2019 to 12/31/2019.

Once this is complete you can choose to save your filter by having a registered account or simply download your queried results. We count a total of 178,010 rows from 2019.

Thank you,
- NYC Open Data Team

Closed

2019-09-01T00:00:00.000

2026-10-02T00:00:00.000

5685

Data Question

Department of Buildings (DOB)

When I query for the sprinkler permit "M00192105-I1", the returned row lists the "Sprinkler (Work Type)" as "False", even though the work type is indeed sprinkler. Is there another field I should be checking to determine whether a filing is a sprinkler filing?

Thank you.

DOB NOW: Build – Job Application Filings

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

Hi,

We have changed the way that work types are recorded in DOB NOW and I suspect that's why this is happening. We plan to overhaul this dataset to reflect the changes to DOB NOW data at the end of 2020. Until then, please use our DOB NOW public portal to look up information for a single filing.

Thank you,
- DOB Open Data Coordinator

Closed

2019-08-30T00:00:00.000

2026-10-02T00:00:00.000

5679

Reported Error

Agency not assigned yet.

I can't access the vision zero data asset

No URL Submitted.

Hi ,

The Vision Zero View Data consists of multiple assets on an interactive map found here: http://www.vzv.nyc/
The assets are divided into 22 different datasets. The data you've requested can be found here: https://data.cityofnewyork.us/browse?q=VZV&sortBy=relevance

Thank you,
- NYC Open Data Team

Closed

2019-08-30T00:00:00.000

2026-10-02T00:00:00.000

5676

Reported Error

Mayor's Office of Media and Entertainment (MOME)

Is the person or company applying for the permit public information as well? Would love to see what companies are looking to film in NYC.

Film Permits

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

Response not sent yet.

Pending

2019-08-29T00:00:00.000

2026-10-02T00:00:00.000

5670

Data Question

Agency not assigned yet.

I was appointed under the community coordinator civil service title at 52K, however I noticed that the minimum salary posted is for 60, 403.00. Can you please look into why I did not receive that amount

No URL Submitted.

Hello,

The title Community Coordinator, title code 56058, as utilized by the Department of Education, has a lower hiring rate and incumbent rate that the rates in effect at Mayoral agencies. Please check with your union local for further information.

Senior Counsel

Closed

2019-08-28T00:00:00.000

2026-10-02T00:00:00.000

5668

Data Question

Department of Health and Mental Hygiene (DOHMH)

In this dataset, there are multiple entries for each restaurant, some of them old and out of date. Is there any way to get only the latest results?

DOHMH New York City Restaurant Inspection Results

https://data.cityofnewyork.us/d/43nn-pn8j

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

Thank you
Department of Health and Mental Hygiene (DOHMH)

Closed

2019-08-28T00:00:00.000

2026-10-02T00:00:00.000

5667

Data Question

Agency not assigned yet.

Is it possible to get the zip code of residence for the offender in each incident? Or any other data about what neighborhood, block, or borough they live in? Can I get this in a machine-readable format that I can match with this data if it's in a separate set?

No URL Submitted.

Hi,

The underlying dataset does not include zipcodes. The data provided through Open Data contains X/Y and Lat/Lon information for mapping purposes. Once mapped, zipcodes can be determined through a spatial overlay.

Thank you,
- NYC Open Data Team

Closed

2019-08-27T00:00:00.000

2026-10-02T00:00:00.000

5666

Data Question

Agency not assigned yet.

I would like to access the records of the replacement of our elevator in March of 2019. Also, management claims the city mandated the elevator replacement; can you send anything regardin this too? Thanks

No URL Submitted.

Hi,

You can see the application and permit for the elevator replacement on DOB NOW. Search for your building, click on the blue Build banner, and click on one of the applications for details. If you click on the orange Safety banner, you can see the last compliance filing which stated that there were defects with the elevator.

The Build data, the replacement applications, will be in open data in October. Until then, please use the DOB NOW portal to look up each building individually.

Thank you,
- DOB Open Data Coordinator

Closed

2019-08-27T00:00:00.000

2026-10-02T00:00:00.000

5665

Data Question

Agency not assigned yet.

I see "Updated April 24, 2019" on the "School Point Locations" dataset. But when I download the zip file the shapefile contains a file name indicating that it was created in the 2011-2012 school year. Also it looks out of date when I compare this Open Data file to other schools data.

Is it possible to know definitively when this dataset was last updated on Open Data? And if it wasn't updated recently, is it possible to request a refresh from the provider (DOE)?

Thanks!

No URL Submitted.

Hi

https://data.cityofnewyork.us/Education/2019-2020-School-Point-Locations/a3nt-yts4

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

Thank you,
- NYC Department of Education Open Data Team

Closed

2018-08-27T00:00:00.000

2026-10-02T00:00:00.000

5662

Data Question

Department of Sanitation (DSNY)

Hello,
I was looking into the DSNY Graffiti removal data and had a question. Is there a version of this spreadsheet that has the "Created Date" column filled out? Alternately, are there historical versions of this spreadsheet that I could use to compare?

Thanks for your time and help!

DSNY Graffiti Tracking

Hi ,

The data you've requested can be found here:
https://data.cityofnewyork.us/City-Government/DSNY-Graffiti-Tracking/gpwd-npar
All fields should have the appropriate data.
​
Thank you,
- NYC Open Data Team

Closed

2019-08-27T00:00:00.000

2026-10-02T00:00:00.000

5661

Data Question

Department of Finance (DOF)

Can you update this dataset with the most recent NOPV values available?

Revised Notice of Property Value (RNOPV)

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

The Notice of Property Value (NOPV) dataset has been determined to have data that is sensitive and has been categorized as private, therefore there will be no new updates to what is currently posted to the portal.

Thank you,
- NYC Open Data Team

Closed

2019-08-27T00:00:00.000

2026-10-02T00:00:00.000

5658

Data Question

Department of Finance (DOF)

Hi,

I want to compile the above data and come to the conclusion on how many Summons were Paid before judgment and some other statistics. Please point me to somewhere where I can get the details about headers and about the data in it.

Revised Notice of Property Value (RNOPV)

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

Hi , happy to help here. You can find information on filed definitions and more details in the dataset on the dataset primer page. The link is available in the section titled 'Attachments'
https://data.cityofnewyork.us/City-Government/OATH-Hearings-Division-Case-Status/jz4z-kudi

Should locating the document prove difficult here is the here is the download link to accompanying data dictionary. https://data.cityofnewyork.us/api/views/jz4z-kudi/files/ed3dd790-fe03-4957-90fc-411a2193a506?download=true&filename=OATH_Hearings_Division_Case_Status_Data_Dictionary_Final.xlsx

Best, NYC Open Data

Closed

2019-08-26T00:00:00.000

2026-10-02T00:00:00.000

5652

Reported Error

Mayor's Office of Media and Entertainment (MOME)

data from years 2016 and 2017 are missing

Film Permits

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

Response not sent yet.

Pending

2019-08-23T00:00:00.000

2026-10-02T00:00:00.000

5650

Reported Error

Department of Buildings (DOB)

DOB NOW job filings appears to be missing data. EG Job# M00179902 is missing, and many more.

DOB NOW: Build – Job Application Filings

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

Hi,
M00179902 is a Limited Alteration Applications (LAA), which is not included in the DOB NOW: Build – Job Application Filings dataset. I will update the metadata for this dataset to clarify this. Thank you for your question. It will be another dataset. We have a long queue of publications and enhancements coming, so this one is scheduled for October 2020. Until then, you can get the data for individual jobs from our DOB NOW portal. https://a810-dobnow.nyc.gov/publish/#!/ And if you absolutely need aggregate data before we publish on open data, you can request it through our FOIL office. https://www1.nyc.gov/site/buildings/about/foil-requests.page

Closed

2019-08-23T00:00:00.000

2026-10-02T00:00:00.000

5648

Data Question

Agency not assigned yet.

Dear NYC OpenData:

I hope you are having a great day.
We are working on a research project using the TLC Trip Record Data.
We think this is a fascinating data set, and we truly appreciate for opening up the data for the public.

While analyzing the data, we had a hard time understand what Bases are.
In the file 'TLC Trip Records User Guide', it states that we need to match license numbers to the base names, and multiple base names seem to have the same app company (e.g., Uber).

We try to search some of the bases (e.g., Elf-ny, LLC), and it states that those are foreign limited liability companies, with multiple seemingly rental service companies listed below (e.g., Broadway Suv Rental LLC).

To summarize,
1. What are bases? Do app companies such as Uber or Lyft own these bases in the form of LLCs, or are they having partnerships with other firms?

2. Are bases decided by locations of NYC? Can there be any overlap in their coverage?

3. What are the relationships between bases and rental service companies?

We apologize if we have caused any inconvenience.
But we believe this data provides us such an excellent opportunity to understand and study the taxi industry, and we sincerely hope that our questions can be solved.

Thank you so much for the reading.

With Best Wishes

No URL Submitted.

Thank you for reaching out about for-hire vehicle trip records. I have answered your questions below.

1. What are bases? Do app companies such as Uber or Lyft own these bases in the form of LLCs, or are they having partnerships with other firms?
- Bases are businesses licensed by the Taxi and Limousine Commission to dispatch TLC-licensed drivers to passengers throughout NYC. Whereas yellow taxis can pick up passengers on the basis of a street-hail, a black car, luxury limo, or community car service must be dispatched by a base. Before apps like Uber and Lyft became available, this arrangement was traditionally done over the phone. Because New York had existing laws about for-hire vehicles when Uber and Lyft became available, those companies were required to get base licenses in order to operate in New York. The bases listed in the trip record guide are owned by the app companies, not operated by partners. On August 14, 2018, the TLC created a new license type for bases doing more than 10,000 trips per day, the High Volume For-Hire Vehicle license, so Uber, Lyft, Via, and Juno's bases are now legally distinct from traditional for-hire vehicle bases and have different reporting requirements. You can read more about bases here: https://www1.nyc.gov/site/tlc/businesses/for-hire-vehicle-bases.page and the new High Volume FHV license here: https://www1.nyc.gov/site/tlc/businesses/high-volume-for-hire-services.page

2. Are bases decided by locations of NYC? Can there be any overlap in their coverage?
- The TLC does not dictate how the app companies divide trips between their bases, so I cannot answer your question. Any pattern, geographic or otherwise, in how ride requests are assigned to specific bases is at the discretion of the company.

3. What are the relationships between bases and rental service companies?
- We are aware that some of the app companies have partnering leasing companies that offer adjusted rates if the driver who leases the car completes a certain number of trips for that app company, etc, but that is at the discretion of the company. Bases and leasing companies are not the same, and the TLC does not license leasing companies.

Hope this helps answer some of your questions.

Closed

2019-08-22T00:00:00.000

2026-10-02T00:00:00.000