NYC Open Data Help Desk: Data Questions and Reported Errors

3298

Data Question

Agency not assigned yet.

We would like to request you that can you guys help us in nycdot.info website. We are going through the files which you have used in the website “locations” and “signs”. We are developing a mobile application where we would like to use the details which are shown on the nycdot website.

Can you please let us know how the two files are related and how can we retrieve the parking details from both the files. We would like to know the relationship between both the files and how the files are used to show the parking restrictions. Because both files are connected by the Status-Order Number and Boro code. But how it’s used in the depicting the parking restrictions we can’t find it.

I would like to request you that can you please help us in the API. We are developing an application for one of our client. The application will showcase the users to view the parking restrictions in New York. The users will be able to view the parking status on the app like your nycdot.info website.

No URL Submitted.

dublicate inquiry. DOT responded to the original inquiry

Closed

2018-05-03T00:00:00.000

2026-10-02T00:00:00.000

3296

Data Question

Agency not assigned yet.

Dear Madam or Sir, I am a master student at***. I am writing to ask how is the search queries for data set in the portal evaluated. e.g. are they purely based on similarity between search keyword and name of the dataset? Are they evaluated through similarity between keyword and specific columns in the dataset? I am asking so potentially some colleagues and I can build some improvements into the current search interface. Thanks!

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please refer to the following FAQ article: https://support.socrata.com/hc/en-us/articles/225465147-Catalog-Search-FAQ
If you have further questions regarding the Socrata platform, you are encouraged to directly contact their support at support@socrata.com.

Thank you,
-NYC Open Data

Closed

2018-04-02T00:00:00.000

2026-10-02T00:00:00.000

3294

Reported Error

Department of Citywide Administrative Services (DCAS)

My name does not appear in full on the list published 06/14/2018, under List Title description, for Exam No. 7037. My full name is *****. Please correct my full name.
Thank you.

Civil Service List (Active)

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

I'm writing in response to your inquiry submitted through the OpenData portal.

Please be assured that your full name is reflected in the eligible list for Exam No. 7037, Civil Engineer. Due to space limitations, the Civil Service List dataset on NYC OpenData includes only the first 15 characters of a candidate's last name.

Sincerely,

Closed

2018-04-02T00:00:00.000

2026-10-02T00:00:00.000

3291

Data Question

Agency not assigned yet.

Hi! I was wondering how you defined "after school programs" in the data set. Are the after school programs programs in schools? Are they offered by the city? Are they all for children under the age of 18? Thank you!

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. For the detailed description of the Department of Youth and Community Development After-school programs, please refer to this resource at https://www1.nyc.gov/site/dycd/services/after-school.page
You are also encouraged to directly contact the department at 1-800-246-4646.

Thank you,
-NYC Open Data

Closed

2018-04-02T00:00:00.000

2026-10-02T00:00:00.000

3290

Reported Error

Department of Buildings (DOB)

The most recent DOBRUNDATE of the data from today is March/05/2018. Please validate what is happening

DOB Job Application Filings

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that this issue was resolved and the dataset was updated with the latest information.

Closed

2018-04-02T00:00:00.000

2026-10-02T00:00:00.000

3289

Reported Error

Department of Buildings (DOB)

Hello, it appears DOB is trying to export a full history of their job filings (and I hope they do). However, the latest "dob run date" is currently showing 3/1/2018, and all later jobs are not shown.

DOB Job Application Filings

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that this issue was resolved and the dataset was updated with the latest information.​
​
Thank you,
-NYC Open Data

Closed

2018-04-02T00:00:00.000

2026-10-02T00:00:00.000

3288

Data Question

Mayor's Office of Media and Entertainment (MOME)

May I have a link to a calendar of current shootings? I don't want my car to be towed. Thanks!

Film Permits

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

Thank you for contacting NYC Open Data Help Desk. The information you are looking for can be found here: https://data.cityofnewyork.us/City-Government/Film-Permits/tg4x-b46p

Thank you,
-NYC Open Data

Closed

2018-04-01T00:00:00.000

2026-10-02T00:00:00.000

3283

Reported Error

Department of Citywide Administrative Services (DCAS)

LIST TITLE: PRONCIPLE ADMINISTRATIVE ASSOCIATE FOR EXAM 5537 (HRA PROMOTIONAL) AND 5033 (OC) NOT LISTED IN THE NYC OPEN DATA 

Civil Service List Certification

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that Exam No column contains values with leading zeroes. To find the exam numbered 5537, please search for 05537 value or use a Filter with the following condition: "Exam No contains 5537".
Thank you,
-NYC Open Data

Closed

2018-03-29T00:00:00.000

2026-10-02T00:00:00.000

3282

Data Question

Agency not assigned yet.

How does one obtain a description of the numeric values in the union cd field?

No URL Submitted.

answer was provided through FOIL

Closed

2018-03-29T00:00:00.000

2026-10-02T00:00:00.000

3281

Reported Error

Office of Administrative Trials and Hearings (OATH)

Dataset has not updated since 3/26. This is a daily update frequency set.

OATH Hearings Division Case Status

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that the OATH Hearings Division Case Status dataset was updated with the latest information. the agency is planning to undertake a project which will update this dataset on the Open Data Portal.

Thank you,
-NYC Open Data

Closed

2018-03-29T00:00:00.000

2026-10-02T00:00:00.000

3280

Data Question

Department of Citywide Administrative Services (DCAS)

Exam 7023. My test score was ***, List showing ***. Why ? Also, What does a List # signifies ?

Civil Service List (Active)

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

Agency representative responded directly to the user

Closed

2018-04-02T00:00:00.000

2026-10-02T00:00:00.000

3278

Reported Error

Agency not assigned yet.

The VTM data is broken. See colume "year_description" and "data_valuemessage".

No URL Submitted.

The data has been updated. Please review to see if your concerns have been addressed. If not please feel free to follow up with me directly at cjones1@helath.nyc.gov.

Thank you

Closed

2018-03-29T00:00:00.000

2026-10-02T00:00:00.000

3276

Data Question

Department of Finance (DOF)

Hi, I am wondering how I can tell which violations happened in which boroughs. Should I use the 'Violation Precinct' column? If I should, how can I find the corresponding boroughs. Thank you for your help in advance.

Parking Violations Issued - Fiscal Year 2016

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

Thank you for contacting NYC Open Data Help Desk. You are encouraged to utilize the "Violation County" column for those records that provide this value. Below are the values range used for each borough:

Manhattan - "MN", "NY"
Bronx - "BRONX", "BX"
Brooklyn - "BK", "K", "KING", "KINGS"
Queens - "Q", "QN", "QUEEN", "QNS", QU"
Staten Island - "R", "ST"

Thank you,
-NYC Open Data

Closed

2018-03-28T00:00:00.000

2026-10-02T00:00:00.000

3275

Data Question

Department of Citywide Administrative Services (DCAS)

Hello, my friend needs to figure out how her job was classified under civil service laws. Do you know what the term "TEMPORARY OJ", as found in the NYC Civil Service Titles, means? If a legend explains that, I haven't found it. My best guess is "Temporary Office Job". I would also like to know if that designation is within the labor, exempt, competitive, or noncompetitive class, or if it has not yet been assigned within those classified classes. Thank you for your time!

NYC Civil Service Titles

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

Thank you for contacting NYC Open Data Help Desk. A title marked “OJ” refers to “Original Jurisdiction”, which indicates that the title is not represented by a union and has salary ranges set by the Mayor pursuant to the Mayor’s authority under the City Charter.
A temporary title is one that has been proposed and is pending the completion of the formal classification process.
A temporary OJ title could be proposed for either the Non-Competitive or Exempt Class.
​
Thank you,
-NYC Open Data

Closed

2018-03-28T00:00:00.000

2026-10-02T00:00:00.000

3274

Data Question

Agency not assigned yet.

m looking for someone at DOF that I can ask about fines on the OpenData portal. I am looking to specifically identify TLC-licensed vehicles. Is there any data field that allows me to do this?

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. You are encouraged to cross reference the license plates recorded in the Parking violation dataset(s) with the following TLC datasets:
​
​​For Hire Vehicles (FHV) - Active - https://data.cityofnewyork.us/Transportation/For-Hire-Vehicles-FHV-Active/8wbx-tsch
​Medallion Vehicles - Authorized - https://data.cityofnewyork.us/Transportation/Medallion-Vehicles-Authorized/rhe8-mgbb
​
​Column name for both dataset is "DMV License Plate Number".
​
Thank you for contacting NYC Open Data Help Desk. The data set can be filtered on license type OMT for summonses issued to vehicles classified as “Taxi (Omnibus)”. There are other “OM-X” types that may be filtered upon for additional values such as OMF; OML; OMO; OMR; and OMV depending on the nature of the data research.

Thank you,
-NYC Department of Finance

Closed

2018-03-27T00:00:00.000

2026-10-02T00:00:00.000

3272

Data Question

Department of Citywide Administrative Services (DCAS)

I would like to know whether clerical associate exam 2016 list has been terminated or extended for anther year.

Civil Service List (Active)

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

Thank you for contacting NYC Open Data Help Desk. Please refer to the Civil Service List (Active) dataset on the Open Data portal for the eligible list for Exam No. 3016, Clerical Associate. - https://data.cityofnewyork.us/City-Government/Civil-Service-List-Active-/vx8i-nprf

The Anniversary Date is 12/24/17 and the Extension Date is 12/24/18. The eligible list is therefore available to agencies hiring persons in this title until the list expires on 12/24/18.


Thank you,
- NYC Department of Citywide Administrative Services

Closed

2018-03-27T00:00:00.000

2026-10-02T00:00:00.000

3268

Reported Error

Department of Finance (DOF)

Your files are not updating and tickets are getting penalties. I highly doubt NYC Dept of Finance will be waving penalties due to their system malfunction. A reply would be appreciated to verify you are aware of the issue.

Open Parking and Camera Violations

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

Thank you for contacting NYC Open Data Help Desk. Please let us know if this discrepancy persists.

Thank you,
-NYC Open Data

Closed

2018-03-27T00:00:00.000

2026-10-02T00:00:00.000

3267

Data Question

Department of Youth and Community Development (DYCD)

Hi! I recently submitted a question about this DYCD dataset and received your response. In case I have a follow up question related to your answer what is the best way to keep all emails in the same thread?
More specific question. Your response was that most likely we should refer to DYCD website rather than their open data set. Do you know if the data underneath the DYCD portal is available somewhere in some user friendly format? Also, how are the requirements for agencies structured in regards to updating their information on open data?
Thanks a lot for your prompt responses!

DYCD after-school programs

Thank you for contacting NYC Open Data Help Desk.
​
​Question: Do you know if the data underneath the DYCD portal is available somewhere in some user friendly format?
​Currently, the data is all in raw format. The only way to view data is to access a particular dataset, export it to an Excel spreadsheet, and filter/group the data as desired. DYCD did develop a public website a few years ago, known as Discover DYCD http://www.dycdportal.nyc/discoverdycd/home. This application allows the public to actively search for DYCD activities and services that are relevant and nearby. These services include After-School Programs, Summer Jobs Programs, and many other programs that are funded by DYCD. While the data that is displayed is not an actual report, the results are still in a readable format.

​Also, how are the requirements for agencies structured in regards to updating their information on open data?

As of now, there is no structured plan to regularly update the data that exists on the Open Data site. However, I do see a major need for this, and will be bringing this up with our Upper Management team. In the meantime, if there is specific data that the user who sent you these questions is looking for, can they please send another request with all the details? If I know what exactly they are looking for, I will be in a better position to respond to their questions.

​Thank you,
-NYC Department of Youth and Community Development

Closed

2018-03-27T00:00:00.000

2026-10-02T00:00:00.000

3265

Data Question

Office of Administrative Trials and Hearings (OATH)

Dear Sir/ M’am,
Out of the 15 million plus observations in this OATH Hearings data set, roughly 4 million are missing the issuing agency that issued the violation ticket. For this subset, around 80% of the data on “violation house number” and about 70% of the information on “violation street” is missing. With such a substantial portion of geographic information missing, it is not possible to conduct further analysis that examines specifically where the violations occur. Is it possible to obtain complete information for this subset of data? Please advise. Thank you for your time; I look forward to hearing from you.

OATH Hearings Division Case Status

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that the agency is planning to undertake a project which will update this dataset on the Open Data Portal over the next few weeks. ​Thank you for contacting NYC Open Data Help Desk. Please be advised that OATH Hearings Division Case Status dataset was completely refreshed and contains up-to-date available information.

​Thank you,
-NYC Open Data

Closed

2018-03-26T00:00:00.000

2026-10-02T00:00:00.000

3262

Data Question

Department of Buildings (DOB)

Similar to my question about DOB Job Application Filings, how do I determine the most recent row for a DOB Permit Issuance? There appeals to be duplicates when I sort on Job #, Doc #, BBL and BIN.

Also, can more than one permit be issued under a job?

DOB Permit Issuance

You could look at Permit Sequence #, in increments of 1 (01, 02, 03, etc.). Yes, more than one permit could be issued for a job.

Closed

2018-03-26T00:00:00.000

2026-10-02T00:00:00.000

3261

Data Question

Department of Buildings (DOB)

May I have guidance on how to index DOB Job Application Filings?

When I sort on Job Number, Doc Number, Borough, Block and Lot, there are several duplicates. Is there a date variable I can use to keep the most recent entry for a job application?

DOB Job Application Filings

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

You could try the Last Action Date, Paid, or Fully Paid columns, which contain corresponding dates.

Closed

2018-03-26T00:00:00.000

2026-10-02T00:00:00.000

3258

Data Question

Department of Buildings (DOB)

What is PERMIT_SI_NO? This is the only column name that does not have Column Description? Is it a permit number?

DOB Permit Issuance

PERMIT_SI_NO is a unique identifier for the records listed. In this instance the SI refers to Subdivision Improvement.

Closed

2018-03-25T00:00:00.000

2026-10-02T00:00:00.000

3253

Reported Error

Department of Finance (DOF)

Tickets are not being updated since the beginning of february

Open Parking and Camera Violations

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that this dataset was updated with the latest information. Please let us know if this reported issue persists and kindly provide us with more details and examples.

Thank you,
-NYC Open Data

Closed

2018-03-23T00:00:00.000

2026-10-02T00:00:00.000

3251

Data Question

Department of Youth and Community Development (DYCD)

Hi! I would like to know if this data set is up to date. I see that the data was last updated on September 2017, but I also noticed that it is exactly the same as some of the older DYCD files we received in 2016. Also, I compared the Open Data file with the DYCD portal (http://www.dycdportal.nyc/discoverdycd/home) and the information doesn't match. What is more current, portal or DYCD files on open data? Thanks!

DYCD after-school programs

Thank you for contacting NYC Open Data Help Desk. Please be advised that the September 2017 update for the DYCD after-school programs dataset on the Open Data portal involved only an addition of several geospatial columns (Latitude, Longitude, Community Board, etc..) in compliance with the Local Law 108 of 2015. This update did not change the underlying older data, and you are encouraged to utilize the resources available on the agency's website.

Thank you,
-NYC Open Data

Closed

2018-03-23T00:00:00.000

2026-10-02T00:00:00.000

3248

Data Question

Department of Buildings (DOB)

I am cross referencing the DEP CATS permit data and the DOB Safety boiler information. I've found sever differences. There are several large boilers in the DEP dataset but not in the DOB file. Also, the makes and model differ. E.g., BIN ***.

May I have more information regarding the DOB boiler file?

DOB NOW: Safety Boiler

https://data.cityofnewyork.us/d/52dp-yji6

I'm happy to answer questions about DOB's Boiler dataset. As a general overview, this dataset comes from our new DOB NOW: Safety Boiler compliance filing system. It will only include filings for boilers that were submitted through this system. There may be older boilers with filings that are not yet included because a current filing has not yet been submitted.

If you have any additional questions, please let us know.

Closed

2018-03-22T00:00:00.000

2026-10-02T00:00:00.000

3247

Reported Error

Agency not assigned yet.

Telephone number listed is incorrect. The correct number is ***. Please delete the numbers listed. Thank you.
Activity

No URL Submitted.

Good Afternoon,

Thank you for your inquiry. The data is in the process of being updated and should be completed within 5-7 business days.

Closed

2018-03-22T00:00:00.000

2026-10-02T00:00:00.000

3246

Data Question

New York City Fire Department (FDNY)

Hi there! Is it possible to obtain the information in this dataset limited to our hospital and from 2015 - 2017?
Thank you -

EMS Incident Dispatch Data

https://data.cityofnewyork.us/d/76xm-jjuj

The information you are looking for is not maintained by NYC Open Data as it is not a data request. It would require the publication of a new dataset which would be unit specific in order to include hospital destinations. For information requests (documents, correspondence, etc.) we encourage you to submit a FOIL request via Open Records: https://a860-openrecords.nyc.gov/

FOIL stands for the Freedom of Information Law. The New York State Freedom of Information Law requires government agencies to provide records to the public upon request. Government records affect the lives of each New Yorker, and providing easy access to the records makes government work better. The FOIL definition of records is very broad and includes information found in paper and electronic documents and audio and visual recordings. All records are available upon request, unless an exception in FOIL permits an agency to deny access to a record. Learn more about FOIL requests via this Frequently Asked Questions page.

Thank you,
- NYC Open Data Team

Closed

2018-03-22T00:00:00.000

2026-10-02T00:00:00.000

3244

Reported Error

Office of Technology and Innovation (OTI)

Height of building with BIN *** in buildings dataset seems to be incorrect. Kind Regards,

Building Footprints (Deprecated)

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

Thank you for contacting NYC Open Data Help Desk. Can you kindly provide us with with more details regarding this discrepancy? Please note that the reported building height is an estimate with 1-2 feet error tolerance.

Thank you,
-NYC Open Data

Closed

2018-03-22T00:00:00.000

2026-10-02T00:00:00.000

3241

Data Question

Agency not assigned yet.

I am currently on an open-competitive list - List #***- Computer Programmer Analyst. Could you please refer me to someone who can give me a list of all people (by rank #'s) who have been removed in any way, shape or form for any reason whatsoever!

Thank You very much!

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please refer to ​Civil Service List (Terminated) dataset found at this URL: https://data.cityofnewyork.us/City-Government/Civil-Service-List-Terminated-/qu8g-sxqf/data

​If you need more information regarding the NYC civil service​, you are encouraged to contact Department of Citywide Administrative Services at
http://www.nyc.gov/html/dcas/html/contact/contact.shtml
​
Thank you,
-NYC Open Data

Closed

2018-03-21T00:00:00.000

2026-10-02T00:00:00.000

3236

Reported Error

Department of Citywide Administrative Services (DCAS)

Exam number 7023, when I took the exam I received a print out that showed that I received a *** on the exam. However, according to the list online I received an Adj FA of ***. I also took test number 7301. I received a similar score on both exams and for that exam my Adj. FA is ***. I believe that the information for exam number 7023 was entered into the system incorrectly. Based on this error I also have a list number that is much further down the list than should be.

Civil Service List (Active)

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

Greetings,

Thank you for contacting NYC Open Data Help Desk. To resolve this discrepancy, you are encouraged to directly contact Department of Citywide Administrative Services (DCAS) at
http://www.nyc.gov/html/dcas/html/contact/contact.shtml

Thank you,
-NYC Open Data

Closed

2018-03-21T00:00:00.000

2026-10-02T00:00:00.000

3234

Data Question

Department of Finance (DOF)

Is there a way to find a list of all retired lots and it's shapes? We want to use this to connect various datasets that sometime references retired lot.

Department of Finance Digital Tax Map

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

There is no repository of the shape changes nor a listing of all the “retired” lots.

Regards,
NYC Department of Finance

Closed

2018-03-20T00:00:00.000

2026-10-02T00:00:00.000

3233

Data Question

New York City Police Department (NYPD)

Good Day, I am a student trying to access the data on road accidents for a GIS project that I am doing. I there anyway that I can transfer the data (like make a copy of it) so it can be used for the ArcGIS software?

Motor Vehicle Collisions - Crashes

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

Greetings,

Thank you for contacting NYC Open Data Help Desk. You are encouraged to use "Export" feature of the portal, that would enable you to save the data in a number of different formats. Please refer to the ArcGIS guides to select the appropriate file format.

Thank you,
-NYC Open Data

Closed

2018-03-20T00:00:00.000

2026-10-02T00:00:00.000

3228

Data Question

Department of Finance (DOF)

Is the street code in the parking violation data set corresponding to the "sc5" variable in the Street name Dictionary data set? Thank you!

Parking Violations Issued - Fiscal Year 2016

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

You have not provided enough information to answer your question. Please provide the specific dataset name for, 'the "sc5" variable in the Street name Dictionary data set' that you are referring to.

Closed

2018-03-19T00:00:00.000

2026-10-02T00:00:00.000

3224

Data Question

Agency not assigned yet.

Hello! How can I get a list of NYC taxi medallions and respective owners? Thank you

No URL Submitted.

The medallion vehicle owners are also the medallion owners, and thus the same link can be used to identify the medallions owners. Medallions can be owned by an individual or by a corporation.

Thank you,
- NYC TLC Open Data

Closed

2018-03-19T00:00:00.000

2026-10-02T00:00:00.000

3220

Data Question

Agency not assigned yet.

I find the columns of street_code1, street_code2, and stree_code3 very confusing and cannot find any documents that help me understand what they mean. Hope you could help me with this!

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. Street Code1 column corresponds to the Street Name on which a specific violation took place, Street Code2 corresponds to the Low End Cross Street, and Street Code3 corresponds to the High End Cross Street. The Department of City Planning maintains a set of names of geographic features that Geosupport software recognizes and considers valid. All of these names are assigned Street Codes. Street codes enable street name aliases to be grouped together in a meaningful way. For more information, please refer to Geosupport System User Programming Guide (CHAPTER IV: STREET CODES) at http://a030-goat.nyc.gov/goat/documents/upg.pdf

Thank you,
-NYC Open Data

Closed

2018-03-18T00:00:00.000

2026-10-02T00:00:00.000

3214

Data Question

Agency not assigned yet.

Are these Jobs updated on a weekly or monthly basis?

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. If you referring to the NYC Jobs, please note that this dataset is being updated every 1-2 weeks.
https://data.cityofnewyork.us/City-Government/NYC-Jobs/kpav-sd4t

Thank you,
-NYC Open Data

Closed

2018-03-15T00:00:00.000

2026-10-02T00:00:00.000

3212

Data Question

Department of Finance (DOF)

I am trying to print out a list of allt ax lines that are filed each day. Is there a way to do that and then import to excel?

Here is a link https://data.cityofnewyork.us/City-Government/ACRIS-Real-Property-Master/bnx9-e6tj/data

how can just pull up federal tax lines sorted by date?

ACRIS - Real Property Master

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

Thank you for contacting NYC Open Data Help Desk. You may refer to Personal Property Master dataset here: https://data.cityofnewyork.us/City-Government/ACRIS-Personal-Property-Master/sv7x-dduq
Within this dataset you may filter by Doc. Type for "FL". Yo may also refer to the Document Control Codes dataset to determine the Doc. Types of interest. This dataset can be found here: https://data.cityofnewyork.us/City-Government/ACRIS-Document-Control-Codes/7isb-wh4c/data

Thank you,
-NYC Department of Finance

Closed

2018-04-02T00:00:00.000

2026-10-02T00:00:00.000

3210

Data Question

Department of Education (DOE)

Hi! Could you tell me when was the Pre-K sites data last updated? I saw that metadata was last updated on December 18, but it doesn't state anything about the data itself?
Thanks!

Universal Pre-K (UPK) School Locations

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

Greetings,

Thank you for contacting NYC Open Data Help Desk. This dataset contains historical data, and the update of 12/18/2017 only refers to the metadata changes, not the actual data. For the 2018 Pre-K School Directory, please refer to this dataset: https://data.cityofnewyork.us/Education/2018-Pre-K-School-Directory/xck4-5xd5

Thank you,
-NYC Open Data

Closed

2018-03-14T00:00:00.000

2026-10-02T00:00:00.000

3207

Reported Error

Department of Finance (DOF)

Why are tickets over a month old not showing up in the open data but are in NYCSERV?

Open Parking and Camera Violations

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

Thank you for contacting NYC Open Data Help Desk. Please let us know if this discrepancy persists.

Thank you,
-NYC Open Data

Closed

2018-03-14T00:00:00.000

2026-10-02T00:00:00.000

3200

Data Question

Department of Housing Preservation and Development (HPD)

How do I link LL 44 Registration Contacts data to a BIN, HPD number or BBL? The file does not have a property address or any other information I can use to link this data to my files.

Registration Contacts

https://data.cityofnewyork.us/d/feu5-w2e2

Greetings,

Thank you for contacting NYC Open Data Help Desk. HPD’s Registration Data is relational – that is, the data is contained in 2 inter-related files. The documentation actually is intended to cover both of those files. Apologies for any confusion – this type of complex data can be difficult to display on the Open Data portal. Here are the two files:

Multiple Dwelling Registrations: https://data.cityofnewyork.us/Housing-Development/Multiple-Dwelling-Registrations/tesw-yqqr/data
Registration Contacts: https://data.cityofnewyork.us/Housing-Development/Registration-Contacts/feu5-w2e2/data

The first datset, “Registrations” contains location information like address, BIN, BBL. You can connect this data to the “Registration Contacts” dataset through the Registration ID, which exists in both datasets.

Thank you,
-NYC Open Data

Closed

2018-03-13T00:00:00.000

2026-10-02T00:00:00.000

3199

Reported Error

New York City Police Department (NYPD)

When exporting to csv file, the latitude and longitude values are excluded from download

NYPD Complaint Data Current (Year To Date)

https://data.cityofnewyork.us/d/5uac-w243

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that there are about 10,000+ records in this dataset that do not have Latitude/Longitude data. The rest of the records contain this information either on the portal or within the downloadable csv file.

Thank you,
-NYC Open Data

Closed

2018-03-13T00:00:00.000

2026-10-02T00:00:00.000

3197

Data Question

Department of Finance (DOF)

ubject: “Violation Status” Field and its relation to “Judgement Entry Date” field.
1- To which Violation status value “Judgement Entry Date” field is pertinent to?
(List of 15 “Violation status” we found in the data are: ADMIN CLAIM DENIED, ADMIN CLAIM GRANTED, ADMIN REDUCTION, APPEAL ABANDONED, APPEAL AFFIRMED, APPEAL MODIFIED, APPEAL REMANDED, APPEAL REVERSED, HEARING ADJOURNMENT, HEARING HELD-GUILTY, HEARING HELD-GUILTY REDUCTION, HEARING HELD-NOT GUILTY, HEARING HELD-REINSTATEMENT, HEARING PENDING, HEARING WAIVED)
2- Most of the data (about 75%) does NOT have a violation status, does this mean Violation Status field has a value only when a ticket is disputed?

3-Do you have “Violation status” workflow or Lifecycle?

Open Parking and Camera Violations

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

1. There is no direct relationship between the JUDGMENT ENTRY DATE field and the VIOLATION STATUS field. The JUDGMENT ENTRY DATE field provides the date the violation entered into judgment status, which is based on a pre-determined penalty schedule. The VIOLATION STATUS field provides the status of a contested ticket, such as whether there is a hearing pending, or what the outcome of the hearing was. Hearings can take place both before or after the entry of judgment.

2. That is correct. Any uncontested ticket, whether it is ignored or paid, will have a blank VIOLATION STATUS.

3. There isn’t a set workflow associated with the VIOLATION STATUS values. All of the statuses, with the exception of ‘Hearing Pending’ reflect the outcome (or determination) from a hearing, whether it be an initial hearing or an appeal hearing. While there are common scenarios, the sequence of values for VIOLATION STATUS will depend on the specific case related to a disputed ticket. As an example, one common sequence might be…
‘Hearing Pending’ ---> ‘Hearing Held–Guilty’ ---> ‘Appeal Reversed’, which translates to a scenario in which a ticket was contested, found guilty at the initial hearing, and then dismissed at an appeal hearing. There are many other possibilities.

Thank you,
-NYC Department of Finance

Closed

2018-03-12T00:00:00.000

2026-10-02T00:00:00.000

3196

Data Question

Agency not assigned yet.

Can we view all permits issued to our property/building? Thank you.

No URL Submitted.

Hi,

You can find the list of permits issued here: https://data.cityofnewyork.us/Housing-Development/DOB-Permit-Issuance/ipu4-2q9a/data

I would recommend looking at the "BOROUGH", "Street Name", and "House #" columns to find the location you need.

Closed

2018-03-12T00:00:00.000

2026-10-02T00:00:00.000

3193

Reported Error

Department of Finance (DOF)

There are multiple missing ACRIS data sets associated with real property and all of personal property files are missing too. Please help investigate, thank you!

ACRIS - Real Property Master

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

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that the ACRIS filtered views datasets were restored to the official public catalog - https://data.cityofnewyork.us/City-Government/ACRIS-Real-Property-Master/bnx9-e6tj

Thank you,
-NYC Open Data

Closed

2018-03-12T00:00:00.000

2026-10-02T00:00:00.000

3190

Data Question

Agency not assigned yet.

Once I have created a filter and saved it, is it possible to edit the filter? How is that done?

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. To edit the existing filter that you have created, please use Filter--->Edit Default Filter option.

Thank you,
-NYC Open Data

Closed

2018-03-10T00:00:00.000

2026-10-02T00:00:00.000

3188

Data Question

Department of Buildings (DOB)

I'm trying to use your building permits data, and realize that I don't understand the categorization of locations. There are two variables in the data, Owner's Business Type and Residential. I would assume that these two things are mutually exclusive - i.e. that residential addresses/permits are not businesses, but I find that of the 1.3 million residential permits, 360k of them are listed as being "corporation" under business type, and only about 600k are Condo/Co-op or Individual, which I would have guessed would have been the only relevant distinction left to make. Is the owner information about the owner of the permit, rather than the owner of the property where the permit is taking place? Any explanation of what these variables are/how they are related would be great. Thanks!

DOB Permit Issuance

Please check out the Data Dictionary associated with each of our datasets for more detailed information about the fields. You'll find this on the https://data.cityofnewyork.us/Housing-Development/DOB-Permit-Issuance/ipu4-2q9a home page under the heading "Attachments".

For your specific question, Owner's Business Type refers to the owner of the building. Not the tenant of the building. To find out who occupies the building, you could try our Certificate of Occupancy dataset https://data.cityofnewyork.us/Housing-Development/DOB-Certificate-Of-Occupancy/bs8b-p36w. Or you might check out Department of City Planning's PLUTO dataset https://www1.nyc.gov/site/planning/data-maps/open-data/dwn-pluto-mappluto.page, which might be more comprehensive.

Thank you,

Closed

2018-03-09T00:00:00.000

2026-10-02T00:00:00.000

3186

Data Question

Department of Citywide Administrative Services (DCAS)

i am looking for senior stationary engineer lists exam no's 6037 and 6520 thanks

Civil Service List (Active)

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

You submitted an inquiry regarding the eligible lists for Exam No. 6037, Senior Stationary Engineer (Open Competitive) and Exam No. 6520, Senior Stationary Engineer (Promotional).

Civil Service eligible lists are found at the OpenData Civil Service List website:https://data.cityofnewyork.us/City-Government/Civil-Service-List-Active-/vx8i-nprf/data

To find the list for a specific exam, select the "Filter" control, Add a New Filter Condition, enter the Exam No. in the box, and press enter. You can also sort the list ("Sort & Roll-Up"). To see a different list, press the "Revert" button and enter the new information.

Closed

2018-03-09T00:00:00.000

2026-10-02T00:00:00.000

3185

Data Question

Department of Buildings (DOB)

Hi, I'm concerned one of the data sets (DOB Job Application Filings, https://data.cityofnewyork.us/Housing-Development/DOB-Job-Application-Filings/ic3t-wcy2 ) is not being updated with complete information.

For example, this NYC DOB BIS application for 159 Broadway, Brooklyn shows a NB application w/ a pre-filing date of Feb 2018 ( http://a810-bisweb.nyc.gov/bisweb/JobsQueryByNumberServlet?requestid=2&passjobnumber=320911233&passdocnumber=01 ). No matter how many arguments I pass to the API endpoint ( https://data.cityofnewyork.us/resource/rvhx-8trz.csv ) I cannot come up w/ any job_type="NB" records ( latest_action_date) more recent than 2015.

This job should not be part of the DOB NOW data set, and I've checked, there's nothing in there.

If you could provide some insight on why some of this data is not available via open data I'd really appreciate it. I have additional examples if you'd like.

DOB Job Application Filings

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

hank you for your report! You are correct that Job *** should be showing up in the DOB Job Application Filings dataset. We are actually updating this dataset to correct some quality issues which should resolve this situation. Please check again in 2 weeks and if you still are not seeing records that you expect to see, then please reach out to us again.

Closed

2018-03-09T00:00:00.000

2026-10-02T00:00:00.000

3184

Reported Error

Agency not assigned yet.

Hello, I noticed that a majority of the ACRIS data sets are missing. Could it be an error with this months update?

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that the ACRIS filtered views datasets were restored to the official public catalog - https://data.cityofnewyork.us/browse?q=acris&sortBy=relevance

Thank you,
-NYC Open Data

Closed

2018-03-09T00:00:00.000

2026-10-02T00:00:00.000

3181

Data Question

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

Is there more information available regarding the Clean Heat dataset? The title and variables are interesting, but there is no data dictionary or explanation on the source of the data.

NYC Clean Heat Dataset (Historical)

https://data.cityofnewyork.us/d/8isn-pgv3

Greetings,

Thank you for contacting NYC Open Data Help Desk. This database was maintained as part of the NYC Clean Heat program, which ended in 2015. The program was rolled into the NYC Retrofit Accelerator, but is just a portion of that program, so it is no longer maintained in the way that it did previously. This dataset is really comprised of other datasets, including DEP’s CATs permits, which provide information on boiler operation permits, and the city’s benchmarking data, which provides information on the energy and water consumption for buildings over 50,000 square feet.

https://data.cityofnewyork.us/Environment/CATS-Permits/f4rp-2kvy
https://data.cityofnewyork.us/City-Government/NYC-Municipal-Building-Energy-Benchmarking-Results/vvj6-d5qx

Thank you,
-NYC Open Data

Closed

2018-03-08T00:00:00.000

2026-10-02T00:00:00.000