NYC Open Data Help Desk: Data Questions and Reported Errors

659

Data Question

Agency not assigned yet.

What's my ori ?

No URL Submitted.

Please provide additional information by updating your submission here- https://nyc-moda.forms.fm/nyc-open-data-team-help-desk/responses/LqlAxPN4TIjJ.

Thanks,
NYC Open Data

Closed

2017-03-22T00:00:00.000

2026-10-02T00:00:00.000

656

Data Question

Agency not assigned yet.

I am a researcher at the *** studying the effect of information regulation on***. I'm using the NYC restaurant grade data to estimate the effect of a restaurant getting a grade on the revenue, survival and pricing of restaurants. One of the confounding components of this analysis is that restaurant graders may have idiosyncratic grading policies. Would it be possible to have "inspector codes" which indicate which department of health inspector conducted the inspection. This would be immensely helpful in estimating the effect of information regulation on consumer outcomes.

Thank you for your help.

No URL Submitted.

Greetings,

Thank you for your request. This data is related to the internal agency administration and does not qualify to be published in open data.

Best,
- Department of Health and Mental Hygiene (DOHMH)
- NYC Open Data

Closed

2017-03-21T00:00:00.000

2026-10-02T00:00:00.000

654

Data Question

Department of Health and Mental Hygiene (DOHMH)

Hi,

I'm interested in using this API, but it seems like the API doesn't include everything from the downloadable dataset. Is there a way to get all the data through the API?

DOHMH New York City Restaurant Inspection Results

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

Please take a look at the 'Paging' section of this page- https://dev.socrata.com/consumers/getting-started.html. If you have any additional questions about the Socrata API, please reach out to support@socrata.com. Thanks!

Closed

2017-03-20T00:00:00.000

2026-10-02T00:00:00.000

652

Data Question

Department of Finance (DOF)

There is a columns in this dataset called "Issuing Agency". It is a on character field that obviously represents a code for the name of the agency that issued the summons. Where is a definition of the code table that maps the one character field to the descriptive name it represents.
Thanks

Parking Violations Issued - Fiscal Year 2027

https://data.cityofnewyork.us/d/pvqr-7yc4

The code translations have been added to the field definition section of the dataset landing page for that field.

Thanks!
NYC Open Data

Closed

2017-03-20T00:00:00.000

2026-10-02T00:00:00.000

645

Data Question

Department of Finance (DOF)

Is it possible to get location and time of day for each parking ticket given in New York City?

Parking Violations Issued - Fiscal Year 2016

https://data.cityofnewyork.us/d/kiv2-tbus

This information can be found in the Violation Time and Issue Date fields within this dataset. Thanks!

Closed

2017-03-19T00:00:00.000

2026-10-02T00:00:00.000

642

Data Question

Department of Environmental Protection (DEP)

The list of NYCDEP certified asbestos investigator appears to be out of date and lists people whose certifications have expired and does not list other certified investigators.

Certified Asbestos Investigators

https://data.cityofnewyork.us/d/m64p-r9hk

This dataset has been updated. Thanks!

Closed

2017-03-17T00:00:00.000

2026-10-02T00:00:00.000

637

Data Question

Agency not assigned yet.

Hello!

I recently received an email about a dataset request I made informing me that "The dataset suggestion you made, NYC DOT Street Furniture Locations is now open". However, when I click the link, I get an error message alerting me that the page has moved or does not exist. I've tried manually searching for this new dataset both by keyword and date of publication (based on when I received the email, which was March 2nd), but cannot find it. Any guidance would be much appreciated.

No URL Submitted.

Greetings,

The Department of Transportation has determined that the previously titled Street Furniture and Pavement Markings dataset actually consists of multiple datasets. City Bench Locations and Bicycle Shelters datasets are already published the NYC Open Data portal. Additional Street Furniture datasets will be individually added in 2018.

Bicycle Shelters - https://data.cityofnewyork.us/Transportation/Bicycle-Parking/qpbf-g2yx
City Bench Locations - https://data.cityofnewyork.us/Transportation/City-Bench-Locations/8d5p-rji6

Please refer to the 2017 NYC Open Data Plan for more information on the planned dataset releases:

https://data.cityofnewyork.us/City-Government/2017-NYC-Open-Data-Plan-Scheduled-Releases/k233-bk49

Hope this helps.
-NYC Open Data

Closed

2017-03-16T00:00:00.000

2026-10-02T00:00:00.000

636

Data Question

Agency not assigned yet.

The "dataset of datasets" link on your FAQ at http://opendata.cityofnewyork.us/faq/ is broken.

No URL Submitted.

Thank you for the heads up. This is fixed now

Closed

2017-03-16T00:00:00.000

2026-10-02T00:00:00.000

635

Data Question

Agency not assigned yet.

I am looking for the median income by housing project in nyc. I found the dataset "Housing New York Units by Project" which has everything but. Did I miss something?

I wanted to compliment you on your presentation with the data dictionary and the example, etc. very nice.

No URL Submitted.

Hello,

As you may have already figured out regarding you request, the data you've requested can be found here:https://data.cityofnewyork.us/Housing-Development/Housing-New-York-Units-by-Project/hq68-rnsi To answer your question we do not believe you are missing anything in regards to understanding median income levels per housing project.

The following columns: Very Low Income, Low Income, Moderate Income and Middle Income provide information on the median income levels for each housing project. The column definitions go even further to give you the percentage ranges for each median income criteria.

Hope this helps
- NYC Open Data

Closed

2017-03-16T00:00:00.000

2026-10-02T00:00:00.000

628

Data Question

Agency not assigned yet.

Two questions:
1- Addresspoint still seems to have dates rather than house numbers for certain entries when you download as a csv file (row *** for example).

2- when I try to sign up for an account, there is no box to check to show I'm not a robot. That happens on both IE and Firefox.

No URL Submitted.

I'm unable to replicate the issue with record ***. How are you opening the CSV? If you're using excel, can you try with a text editor? Sometimes excel misinterprets and formats data differently. If you still have this issue, please update your submission and let us know https://nyc-moda.forms.fm/nyc-open-data-team-help-desk/responses/CCvMBkJPyEC0.

As for the issue with signing up for an account- please reach out to support@socrata.com for help in creating an account.

Thanks!
NYC Open Data

Closed

2017-03-16T00:00:00.000

2026-10-02T00:00:00.000

625

Data Question

311

I got the replay on my question before. You said this dataset includes all 311 service request. Then, can I get information about the channel(text, call, web site, mobile app, etc) for each request? I'm a *** and studying about information system and ***.
Thank you.

311 Service Requests from 2020 to Present

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

We are looking at adding this to the dataset in the future but are unable to do so now because of inconsistencies in the data.

Closed

2017-03-16T00:00:00.000

2026-10-02T00:00:00.000

624

Data Question

Office of Technology and Innovation (OTI)

Is there a manner in which I can simply extract a polygon of interest from this dataset? It's large shape-file size and the inability to extract areas of interest makes it difficult to work with. It is a great layer and I would like to work with it on a regular basis, but the large file size makes it difficult to do so. I can extract sub-datasets from ArcMap but it would be great to be able to do it directly from the NYC Map web user interface. Also, is there a way engineers or people in a professional, technical field can reach you via telephone for more immediate feedback? The guidance on the website seems to be for more basic users as opposed to professionals who use GIS on a frequent basis. Is there a way to get more advanced help and feedback? Thank you in advance. This is a great resource that looks to be continually developing!

Building Footprints (Deprecated)

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

Unfortunately there are no ways to extract an exact polygon from a shape file using the Socrata API. The closest solution would be just to isolate the desired layer via the "More Views" tab, export and use an external GIS program to conduct further analysis. The open data team has confirmed that a successful export of said layer is possible.

Best,
Open Data NYC

Closed

2017-03-15T00:00:00.000

2026-10-02T00:00:00.000

191

Data Question

Department of Finance (DOF)

I have been tracking the Open Parking database since early 2016 with the intention of trying to determine the average duration in which a summons remains unpaid. I have recently noticed that some summons have not had any activity since I first started following the database(05/18/2016). These records no longer show up in the data feed. It was my understanding that the data feed was cumulative and there was no purge activity. One summons in question "***" issued on 2016-01-18 is no longer in the input file and shows up on the NYSERV site as "satisfied", yet my review of the transactions can not locate the day in which the summons was paid. I can provide more samples if needed. Is there another dataset with ALL the transactions available so that i can true up my workflow?
Thanks in advance,

Open Parking and Camera Violations

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

The initial data set was loaded 5/14/16. With regards to the specific summons mentioned (***), the summons was issued *** and then paid on 01/31/16. Since the summons was paid before the 5/14/16 date, the summons will not show up as part of this data set. This data set only reflects open inventory of summonses issued since 5/14/16.

Closed

2017-03-14T00:00:00.000

2026-10-02T00:00:00.000

190

Data Question

311

I have a question about the 311 service requests dataset.
Does it include all connection to 311 like phone call, text, skype, web, and mobile app?? or include only some connections.
Thank you in advance.

311 Service Requests from 2020 to Present

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

This dataset includes all 311 Service Requests. Thanks!

Closed

2017-03-14T00:00:00.000

2026-10-02T00:00:00.000

187

Data Question

Agency not assigned yet.

What coordinate system are the XY values in?

No URL Submitted.

he system uses State Plane Coordinates in the Long Island East Zone NAD 1983/92 NAVD 1988 (Long Island Zone 3104). Thanks!

Closed

2017-03-13T00:00:00.000

2026-10-02T00:00:00.000

185

Data Question

Department of Finance (DOF)

Hi,
I would like to inquire about you API and how a Developer may use it in the from JSO/XML request to obtain data. Particularly ACRIS document recordings.

ACRIS - Real Property Master

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

Please click the 'Export' and 'SODA API' links within the dataset for detailed API documentation specific to the dataset. You can also visit https://dev.socrata.com/ for additional information. Thanks! you can also check this page for more information on the Socrata API.

Closed

2017-03-12T00:00:00.000

2026-10-02T00:00:00.000

182

Reported Error

Department of Buildings (DOB)

Dataset doesn't contain the information in the description which is 'List of NYC Properties under DOB jurisdiction'. It contain other information but not the list of properties.

Property Data (Buildings Information System) - Now Retired

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

Greetings,

Portions of your data request for Building Characteristics have been found to be public data and will be prioritized for release.

Best,
- NYC Open Data

Closed

2017-03-10T00:00:00.000

2026-10-02T00:00:00.000

179

Data Question

New York City Police Department (NYPD)

I was wondering what the key codes are for "family offenses" (ky_cd) or penal codes (pd_cd)... I'd like to isolate all incident reports for family offenses (harassment 2, assault 3 etc) but I can't figure out what these codes #s signify. Many thanks

NYPD Complaint Data Historic

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

The descriptions are contained in the OFNS_DESC and PD_DESC fields. Thanks!

Closed

2017-03-09T00:00:00.000

2026-10-02T00:00:00.000

166

Data Question

Taxi and Limousine Commission (TLC)

Im ***. My app # is ***.. my email address is ***.. Ive be patiently waiting for positive results so I can start work.. I need answers.. I paid to complete everything needed to start work so I shouldn't have to wait so long especailly when I took fingerprints on *** and it is now 3/8/17.. Email me asap .. Thank you

No URL Submitted.

 If this is related to TLC New Driver Application Status, please email newdriverapp@tlc.nyc.gov.

Closed

2017-03-08T00:00:00.000

2026-10-02T00:00:00.000

163

Data Question

Department of Cultural Affairs (DCLA)

I was wondering how my company **** productions can be listed on the DCLA Cultural Organizations data set?

DCLA Cultural Organizations

https://data.cityofnewyork.us/d/u35m-9t32

Thank you for contacting NYC Open Data Help Desk. In order to be listed, your company must apply and receive funding from the NYC Department of Cultural Affairs. For more information, please visit http://home2.nyc.gov/html/dcla/html/funding/cdf.shtml
​
Thank you,
- NYC Open Data Team

Closed

2018-03-07T00:00:00.000

2026-10-02T00:00:00.000

162

Data Question

Department of Citywide Administrative Services (DCAS)

How can I dispute the listing on exam 6049. My qualifications should have me listed in the top ten of this exam, however I ended up *** on this list.

Civil Service List (Active)

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

Certified IT Administrator (LAN/WAN), Exam No. 6049 was established on March 1, 2017. However, the Notice of Results (NOR) card has not yet been mailed out. Once you receive the NOR, you may follow the instructions to appeal.

You are encouraged to contact the Department of Citywide Administrative Services’ 24-hour Interactive Voice Response database at Tel. (212) 669-1357 to receive up to date information on the status of your list(s).

Closed

2017-03-07T00:00:00.000

2026-10-02T00:00:00.000

161

Reported Error

New York City Police Department (NYPD)

Hello,
I just finished a project using NYC Open Data looking into distracted driving collisions throughout the city. I thought it would be interesting to share, especially with Distracted Driving awareness month coming up in April. http://www.omranitaub.com/nyc-distracted-driving-accidents/

I also had a question about a gap in the data and was hoping you might be able to answer it.

Thank you,

Motor Vehicle Collisions - Crashes

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

Hi,

Thanks for sharing your project! Please submit another request here under the 'Report an error in the data' drop down and we'll take a look.

Thanks!
NYC Open Data

Closed

2017-03-07T00:00:00.000

2026-10-02T00:00:00.000

160

Data Question

Department of Citywide Administrative Services (DCAS)

Why all of a sudden is the dataset of city-owned properties restricted?

Suitability of City-Owned and Leased Property for Urban Agriculture (LL 48 of 2011)

https://data.cityofnewyork.us/d/4e2n-s75z

This dataset was temporarily taken down while we work with DCAS to review and update the dataset.

Closed

2017-03-07T00:00:00.000

2026-10-02T00:00:00.000

157

Reported Error

Office of Technology and Innovation (OTI)

Unable to sign-up for a new account for open data, says internal error. Can you investigate the issue on your end?

No URL Submitted.

Please contact Socrata support by emailing support@socrata.com for help creating a new account. 

Closed

2017-03-06T00:00:00.000

2026-10-02T00:00:00.000

151

Data Question

Department of Finance (DOF)

Is it possible to get similar data for next years? Especially for:
a) 2011
b) and most current data (e.g. 2015 or 2016)
or other similar years?

Thank you in advance for your information.

It will be useful for my research connected to my my doctoral dissertation. I'm trying to check housing prices in some Manhattan's neigbordhoods and and to compare the data with varying coverage.

NYC Calendar Sales (Archive)

https://data.cityofnewyork.us/d/uzf5-f8n2

The dataset has been updated with data through 2015. Additional information and formats can be found here. Thanks!

Closed

2017-03-06T00:00:00.000

2026-10-02T00:00:00.000

145

Reported Error

Taxi and Limousine Commission (TLC)

 I have completed all the requirements listed but the open data under my application number which is *** is showing that it is incomplete. Sometimes it shows that you have recieved some documents and then it shows up as needed. PLEASE get back to me as soon as possible. I kindly await your response. Thank You.

TLC New Driver Application Status

https://data.cityofnewyork.us/d/dpec-ucu7

For questions, please email newdriverapp@tlc.nyc.gov.

Closed

2017-03-05T00:00:00.000

2026-10-02T00:00:00.000

142

Data Question

Department of Finance (DOF)

Could you add the violation code to the dataset?

Open Parking and Camera Violations

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

While there are no plans to add the violation code to the dataset, the code can be found on the image and the code translations can now be found here: https://data.cityofnewyork.us/api/views/nc67-uf89/files/6adc82e3-36b3-43ff-8c0b-c2de01ddd742?download=true&filename=STARS.VIO.CODES.TXT

Closed

2017-03-04T00:00:00.000

2026-10-02T00:00:00.000

141

Reported Error

Taxi and Limousine Commission (TLC)

I believe there is an issue with the taxi application data set. Because I checked the data in the past and things that i had completed were noted as complete and now they say they are needed. thank you

TLC New Driver Application Status

https://data.cityofnewyork.us/d/dpec-ucu7

For questions, please email newdriverapp@tlc.nyc.gov.

Closed

2017-03-04T00:00:00.000

2026-10-02T00:00:00.000

139

Data Question

Taxi and Limousine Commission (TLC)

I noticed that my application status has changed with missing info from all the requirements I already did so it changed from under review to incomplete, my app no. is ***

TLC New Driver Application Status

https://data.cityofnewyork.us/d/dpec-ucu7

Hi. For questions, please email newdriverapp@tlc.nyc.gov.

Closed

2017-03-04T00:00:00.000

2026-10-02T00:00:00.000

134

Data Question

Department of Transportation (DOT)

There is a variable in this data set called Post_VG_SG. It is not defined in the metadata. What is it?

http://www.nyc.gov/html/dot/html/about/vz_datafeeds.shtml

Are you referring to the 'postvz_sg' field in the speed limit shapefile? If so, this indicates whether or not there is a Vision Zero sign along the street segment. Please see page 3 of the metadata(http://www.nyc.gov/html/dot/downloads/pdf/vision-zero-view-metadata.pdf) for additional information

Closed

2017-03-03T00:00:00.000

2026-10-02T00:00:00.000