NYC Open Data Help Desk: Data Questions and Reported Errors

2662

Data Question

Agency not assigned yet.

99% fail, only 1% pass inspection (by my estimate). Why? It seems too high of an inspection violation rate to be realistic. Could it be there is bias as to what inspection results actually make it into this dataset? Sadly I can't use your otherwise great dataset unless this is clarified.

How I estimated which inspection records are PASS (not fail) in R language:

library("readr")
library("dplyr")
df = readr::read_csv(file = "DOHMH_New_York_City_Restaurant_Inspection_Results.csv")

df <- mutate(.data = df, PASS='No violations were recorded at the time of this inspection.' == ACTION & is.na(`VIOLATION CODE`))

df <- df[!is.na(df$PASS),] # remove the garbage examples

summary(df$PASS)
Mode FALSE TRUE
logical 389941 4954

print(mean(df$PASS))

Why I did it this way: There is no simple indicator column of pass or fail in the raw dataset.

No URL Submitted.

Thank you for your inquiry. Our inspections are based on a point system with grades (A grade = 0-13 pts, B grade =14-27 pts, C grade =28+ pts) and are not designated as pass or fail. Please refer to our guidance document located in the “about this dataset” section of the open data portal Please review the following links that provide additional details regarding the grading system.



Thank you

Closed

2017-11-12T00:00:00.000

2026-10-02T00:00:00.000

2661

Data Question

Department of Citywide Administrative Services (DCAS)

UPDATED 2/5/18: Hi, I am following up on my question from October 2017. When will the 2016 data be added to this dataset? Currently it only goes through 2015. Thanks. // Previous message: Hi, the Civil List has not been updated since 2015, but the dataset says it was updated in 2017. When is the 2016 data going to be added to this dataset? Thanks.

Civil List

https://data.cityofnewyork.us/d/ye3c-m4ga

Thank you for contacting NYC Open Data Help Desk. Please be advised that Civil List dataset was updated with data for 2016 and 2017 - https://data.cityofnewyork.us/City-Government/Civil-List/ye3c-m4ga

Thank you,
-NYC Open Data

Closed

2018-02-05T00:00:00.000

2026-10-02T00:00:00.000

2659

Data Question

Metropolitan Transportation Authority (MTA)

What is the exact projection of the coordinates given? Is it NAD27 or 83 and what zone?

Subway Entrances

Greeting,

This dataset uses North American Datum 1983 (NAD83).

Best,
- NYC Open Data

Closed

2017-10-11T00:00:00.000

2026-10-02T00:00:00.000

2656

Data Question

Department of Citywide Administrative Services (DCAS)

test numbers 7323 and 7326; trying to find my list numbers for both NYPD tests

Civil Service List (Active)

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

Greetings,

The information for test 7323 is now available in the Civil Service List (Active) dataset at this URL: https://data.cityofnewyork.us/City-Government/Civil-Service-List-Active-/vx8i-nprf
Please use a "Filter" feature for the following column names: "Exam No", "First Name", "Last Name". For the instruction on how to use this feature, please refer to this URL: https://support.socrata.com/hc/en-us/sections/200469748-Filtering-Datasets

Thank you,
-NYC Open Data

Closed

2017-10-10T00:00:00.000

2026-10-02T00:00:00.000

2652

Reported Error

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

Can i have some more details on what each column name signifies.
Your prompt response will be highly appreciated

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

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

Column FLD_ZONE represents a flood zone designation
Column STATIC_BFE and ABFE_0_2Pc are related to the base flood elevations data.
The rest of the columns are related to an internal geospatial information. For a detailed information on the Sea Level Rise Maps (2050s 500-year Floodplain) map data, please refer to https://data.cityofnewyork.us/api/assets/581A4132-...
For your convenience, this document is also available for download within the dataset in the About--->Attachments section.

Best,
- NYC Open Data

Closed

2017-10-09T00:00:00.000

2026-10-02T00:00:00.000

2650

Data Question

Agency not assigned yet.

For the programs in the high school directory dataset, why is the data laid out inefficiently? Currently, the only way to find out how many programs a school has is to check if each field is there. What I am proposing is to have a field just called programs which would be an array of programs. Each element of the array would be a JSON object containing the program description, program interests, and requirements as fields. This way, when people like me try to use the data, we can check much more efficiently how many programs there are and what their attributes are.

No URL Submitted.

Thank you for your comments. However, give the large number of schools and the nuances of the data, it is not possible to always create formats that meets the precise needs of every user. We will, however, pass on your comments to the appropriate office.

Closed

2017-10-08T00:00:00.000

2026-10-02T00:00:00.000

2647

Data Question

Agency not assigned yet.

I was told by a street event producer that their 10/4/17 event was permitted under ID #347518 (Slice Out Hunger), at ****. I found their permit #**** for 2016's event in your data set, but not this year's. Is it possible that they did not receive a permit, but have an ID# because they applied?

No URL Submitted.

Greetings,

The NYC Permitted Event Information - Historical dataset was updated with the latest information and should contain the relevant information for the event ID 347518.
https://data.cityofnewyork.us/City-Government/NYC-Permitted-Event-Information-Historical/bkfu-528j

Closed

2017-10-07T00:00:00.000

2026-10-02T00:00:00.000

2646

Data Question

Taxi and Limousine Commission (TLC)

Hello Sir/Ma'am, Is the data order set number descending or ascending, sometimes I find my number all the way up, now I am back to the rock bottom. e.g It went from number *** now precisely currently at no- ***. Any infor will be greatly appreciated. 

TLC New Driver Application Status

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

Dear ***
You can use the filter view instructions provided at https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View to create your own filtered data view. In this case you can always see only your record of interest.

Closed

2017-10-07T00:00:00.000

2026-10-02T00:00:00.000

2644

Data Question

Agency not assigned yet.

This dataset uses a series of not particularly useful "street codes" for location data. I know that the City is in the process of standardizing formats for geospatial data—consider this a vote for the prioritization of all "Parking Violations Issued" datasets. Thank you!

No URL Submitted.

Greetings,

We appreciate your input. The NYC Open Data and the city agencies are still in the process of updating relevant datasets with geospatial information as per Local Law 108 of 2015.

Best,
- NYC Open Data

Closed

2017-10-06T00:00:00.000

2026-10-02T00:00:00.000

2643

Data Question

Agency not assigned yet.

When I download the data as CSV, what time zone are the date fields displayed in? Can I assume it is Eastern time (local)? Or is it UTC? The metadata doesn't offer any specifics here.

No URL Submitted.

Greetings,

The NYC 311 service utilizes the Eastern time zone.

Best,
- NYC Open Data

Closed

2017-10-06T00:00:00.000

2026-10-02T00:00:00.000

2642

Data Question

Department of Finance (DOF)

the attached dataset for 2016 includes locations where tickets were issued. Is the same format available for 2017 parking ticket data?

Parking Violations Issued - Fiscal Year 2016

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

Greetings,

The 2017 data can be found here:
https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2017/2bnn-yakx

Best,
- NYC Open Data

Closed

2017-10-06T00:00:00.000

2026-10-02T00:00:00.000

2641

Reported Error

Department of Citywide Administrative Services (DCAS)

I took the NYPD test and can not find my name on "opendata".

Civil Service List (Active)

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

Greetings,

This dataset was recently updated and should contain your information. You are strongly encouraged to use a "Filter" feature to ensure more accurate query results. For more information on how to use this feature, please refer to
https://support.socrata.com/hc/en-us/sections/200469748-Filtering-Datasets

Closed

2017-10-06T00:00:00.000

2026-10-02T00:00:00.000

2640

Data Question

Agency not assigned yet.

I'm trying to find historic work permit and inspection data for my specific apartment unit which underwent a renovation around 2006-2007. The Historical DOB Permit Issuance data only contains a few permits for my building and none specify the unit. I know there were many units that were renovated around this time. There must be data missing... They put a new wall in among other things, so they would have needed a permit.

No URL Submitted.

When you're looking for a single location like this, you might find it easier to search our Building Information System (BIS) at http://a810-bisweb.nyc.gov/bisweb/bsqpm01.jsp.

Every permit application that we have on file is listed there - at the bottom right of that page, click on permits issued. (Or go to this page: http://a810-bisweb.nyc.gov/bisweb/PermitsInProcessIssuedByBinServlet?requestid=1&allbin=****) You'll want to look at all of the permits that end in AL, which means Alteration.

At a glance, I don't see any permits for renovation work inside a specific apartment. It's possible that the buildings owners performed the work illegally without a permit.

If you do find a permit on BIS that is not listed in our Open Data dataset, please let me know because I would like to make sure that we don't have a data quality issue.

Thank you,

Closed

2017-10-05T00:00:00.000

2026-10-02T00:00:00.000

2639

Reported Error

Department of Citywide Administrative Services (DCAS)

I was on the NYC Open Data website searching my list number for the police officer exam no. 7323. When I found my list number and final score, It was brought to my attention that I received residency credits although I am not a resident of NYC. I am reaching out here for further instruction as to what I should do to fix this and correct it. I dont want this to mess things up later on with the process and would appreciate some feedback for my situation. Thank you

Civil Service List (Active)

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

Thank you for pointing out this error. Due to the time constrains, you are encouraged to directly contact Department of Citywide Administrative Services (DCAS) at
http://www.nyc.gov/html/dcas/html/contact/contact.shtml

Best,
- NYC Open Data

Closed

2017-10-05T00:00:00.000

2026-10-02T00:00:00.000

2633

Data Question

Department of Citywide Administrative Services (DCAS)

There are 2,089 unmatched unique title codes when comparing this to the civil service payroll list. Where can I find the additional code listed in the payroll dataset? // ORIGINAL REQUEST: Hello, the Civil List dataset contains a column for civil service title. However, this title is in code, and there is no code dictionary in the data dictionary. Where can I find a list of civil service title codes and the titles they represent? Thank you.

Civil List

https://data.cityofnewyork.us/d/ye3c-m4ga

Greetings,

According to the Department of Citywide Administrative Services (DCAS) - the NYC Civil Service Titles dataset only includes information for the titles that are under DCAS jurisdiction, while the Civil List dataset includes titles used in non-Mayoral agencies, such as MTA or CUNY. Adding the information for these non-Mayoral agencies to the NYC Civil Service Titles dataset is currently under consideration.

Closed

2017-10-04T00:00:00.000

2026-10-02T00:00:00.000

2631

Data Question

Agency not assigned yet.

an inventory of DSNY street waste basket location is potentially very useful to City Council offices managing street trash services. However, this data set is limited to just 3 fields and they are not useful. Lat/Long listed but very hard to correlate those with practical street address or cross-street locations. Can this data set be improved by adding exact street address?

No URL Submitted.

Thank you for your suggestion. The Open Data Team has utilized the 'Litter Basket' long/Lat coordinates to create a map visualization.

Please follow this link and scroll to the bottom of the page to view the map: https://data.cityofnewyork.us/Environment/Litter-Basket-Inventory/es7t-6u8y

While we were able to create a plot map to better understand the 'Litter Basket Inventory' data set, we are unable to provide exact building addresses for this data. Unfortunately the actual position of each litter basket does not directly correlate with building addresses.

Thank you,
- NYC Open Data

Closed

2017-10-04T00:00:00.000

2026-10-02T00:00:00.000

2630

Reported Error

Department of Citywide Administrative Services (DCAS)

On my account it shows that I took and completed the POLICE OFFICER, Exam No. 7323 and i have proof of my payment but I am not in the list. I received a score when the test was finished. I received an email that there was no proof of my payment. I have proof of payment for my test. My scores have not been released.

Civil Service List (Active)

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

This data refreshes everyday, however you may not be included in list until you have officially received a score. 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

Closed

2017-10-03T00:00:00.000

2026-10-02T00:00:00.000

2628

Reported Error

Agency not assigned yet.

When consuming the REST endpoint through an ArcGIS Online WebMap, at no extent will the parcels draw. renders the service unusable.

No URL Submitted.

This is not an issue with the MapPLUTO dataset, but with ArcGIS online. The MapPLUTO dataset is very large and the ArcGIS online platform has a limit on features it will render at certain scales.

A possible workaround could be to:
1) Download MapPLUTO from NYC Open Data or City Planning's Bytes of Big Apple
2) Filter and select the dataset for a smaller area (i.e. borough, CD)
3) Export that to a new shapefile
4) Upload that shapefile to your ArcGIS online account

Thank you

Closed

2017-10-03T00:00:00.000

2026-10-02T00:00:00.000

2625

Data Question

Agency not assigned yet.

Does the DOT share personal information about vehicle accidents with 3rd parties? I received a phone call from a solicitor who said they have a direct hotline with the DOT when accidents occur.

No URL Submitted.

Greetings,

The New York City Department of Transportation does not share personal information about vehicle crashes with third parties.

Best,
- NYC Open Data

Closed

2017-10-03T00:00:00.000

2026-10-02T00:00:00.000

2622

Data Question

Agency not assigned yet.

I want to fetch HIC#, HIC# expiry date, Tax ID#, IBM#, Work Compensation insurance expiration date, Disability expiration date, General Liability expiration date, Street Obstruction Bond expiration date and endorsements, if any, however I am not able to find any API which will returns these details. Could you please help me with the dataset name / link if such exists? If not, could you create one for me?

No URL Submitted.

The Department of Buildings releases some of the data that you are looking for in our DOB License Info dataset. We do not have the other information that you requested.

Thank you,

Closed

2017-10-02T00:00:00.000

2026-10-02T00:00:00.000

2621

Data Question

Agency not assigned yet.

Hello I am trying to access MTA data with no luck. I signed up for a token and have one and tried the example code but still can not access anything. Can you lend some guidance?

No URL Submitted.

Greetings,

The underlying dataset for this json is https://data.cityofnewyork.us/Transportation/MTA-Data/mmu8-8w8b
Since it is not a tabular dataset, but a link to the MTA webpage, you can only access the data through the MTA website. If you are experiencing difficulties with accessing the data through the MTA web services, you are encouraged to contact this agency's customer support at
http://web.mta.info/faqs.htm

Best,
- NYC Open Data

Closed

2017-10-01T00:00:00.000

2026-10-02T00:00:00.000

2618

Data Question

Agency not assigned yet.

Dear officer,
I'm searching for historical data of a relativ of mine i. e. ***, born*** in NYC. Could you kindly suggest how or who ( which department) I should contact?

No URL Submitted.

Greetings,

You are encouraged to contact NYC Department of Records at http://www1.nyc.gov/site/records/index.page

Closed

2017-09-29T00:00:00.000

2026-10-02T00:00:00.000

2611

Data Question

Office of Administrative Trials and Hearings (OATH)

For Ticket Number *** the hearing status is "Defaulted" but the balance is $0. My understanding is that the only thing you need to do to close this hearing is pay the fine so this seems off. Please advise.

OATH Hearings Division Case Status

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

Greetings,

The most current and updated information on this cases shows a default disposition and a paid-in-full status.

- NYC Open Data

Closed

2017-09-27T00:00:00.000

2026-10-02T00:00:00.000

2610

Data Question

Department of Finance (DOF)

The dataset referenced by the link above is the Fiscal Year 2018 Parking Violations Issued. However, when I sort the dataset by Incident Date, there are more than 500 records where the date is 2016 and older. What is the criteria that determines the record inclusion into this dataset if the date is not correct? Is there a "Date Received" that can be added to the file that would make it easier to sort the data?

Parking Violations Issued - Fiscal Year 2027

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

Greetings,

The data displayed on this page reflects data that has been received by the Department of Finance for parking violations issued during FY18. Your request to add a new column "Date Received" will be taken under consideration.

- NYC Open Data

Closed

2017-09-27T00:00:00.000

2026-10-02T00:00:00.000

2608

Data Question

Agency not assigned yet.

Is it possible to get a more detailed description of the column values PD_CD and PD_DESC? Perhaps a list of what the individual codes mean so that I can better describe the data in the set?

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please refer to PDCode_PenalLaw.xlsx found in this dataset's Attachments section.

Closed

2017-09-27T00:00:00.000

2026-10-02T00:00:00.000

2605

Reported Error

New York City Police Department (NYPD)

Since 2014, the percentage of incomplete entries in this dataset has increased from 8.13% to 30.85%. Most of the incomplete fields are Borough, Zip Code, Latitude, and Longitude. These fields are critical to Vision Zero. There was a large spike in incomplete entries starting around April 2016

Motor Vehicle Collisions - Crashes

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

The increase in incomplete fields coincides with the NYPD’s collision data being captured by the FORMS.  This started on March 14, 2016.   The electronic recording of data directly from NYPD officers is still in in its infancy and the incomplete entries may be a training issue. 

Closed

2017-09-26T00:00:00.000

2026-10-02T00:00:00.000

2604

Reported Error

Agency not assigned yet.

In a blog entry, you link to the new (beta) capitalplanning.nyc.gov site but the URL points to www but it dosn't resolve (ERR_NAME_NOT_RESOLVED). Apparently the there is no CNAME for www. Please, either create the DNS record forwarding to the main site or change the URL to remove wwww.

No URL Submitted.

Thank you for bringing this to our attention! We will have this error fixed in the coming days.

Thanks again,
NYC Open Data Team

Closed

2017-09-26T00:00:00.000

2026-10-02T00:00:00.000

2602

Data Question

Agency not assigned yet.

This is the data set URL that returns a 404 error. Is this temporary or is there an alternative real-time feed?

No URL Submitted.

Greetings,

Please refer to Real-Time Traffic Speed Data dataset at
https://data.cityofnewyork.us/Transportation/Real-Time-Traffic-Speed-Data/qkm5-nuaq

Best,
- NYC Open Data

Closed

2017-09-26T00:00:00.000

2026-10-02T00:00:00.000

2601

Data Question

Agency not assigned yet.

We are curious how to access the raw data in a feed behind the flow map at the URL above. When we go to the open data site for traffic speeds and click on "XML," it takes us to a 404 error. Please let us know the appropriate URL or endpoint to access a feed of live traffic data for purposes of evaluating traffic prediction research.

No URL Submitted.

Greetings,
Please refer to Real-Time Traffic Speed Data dataset at
https://data.cityofnewyork.us/Transportation/Real-Time-Traffic-Speed-Data/qkm5-nuaq

Best,
- NYC Open Data

Closed

2017-09-26T00:00:00.000

2026-10-02T00:00:00.000

2596

Data Question

New York City Fire Department (FDNY)

I'd like more information about one of the variables. The codebook is a little thin on the matter. The variable is INITIAL_SEVERITY_LEVEL_CODE. how exactly are these assigned? They appear to be lower numbers are higher priorities, but this is not explicit. Is the same method used in all years, months, cases? etc. Ideally, I'd like to be put in touch with someone with intimate knowledge of this particular data set. Thank you!

EMS Incident Dispatch Data

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

When someone calls 9-1-1 and reaches an EMS Alarm Receipt Dispatcher (ARD), the ARD asks a number of questions to triage the call and determine its type and severity. This is determined through a computer algorithm that acts as a decision tree to find a call type through previous responses. Our EMS ARDs are also trained EMTs and they have the ability to override the computerized triage algorithm.

The call type determines which what type of resource the incident will receive. In our case, it will receive an Advanced Life Support (ALS) ambulance, a Basic Life Support (BLS) ambulance, a DUAL response (ALS+BLS) and in some cases a Certified First Responder (CFR) response. CFRs include all of our Fire Engine companies.

Each call type is mapped to a severity level. The severity level determines which incidents will get an unit assigned to the incident first. Severity levels 1-3 (also called segments) are categorized as life-threatening emergencies. 4-8 are non-life threatening emergencies. Note that not all of the highest priorities have the same type of response.

Each incident will have an initial and final severity level and call type because it can be important to know how the incident was originally triaged (based on the information the first caller gave) and how that categorization may have changed base on new information from additional callers or other trained personnel on scene or changes in patient condition, for example.

I hope this is helpful.

Closed

2017-09-25T00:00:00.000

2026-10-02T00:00:00.000

2593

Data Question

Agency not assigned yet.

Thanks for the quick response! To confirm, is the web service itself able to be called from external websites when serving maps, or is the expectation that organizations would serve their own tiles based on those provided here? Is there a usage policy for the Slippy Map Service described at https://maps.nyc.gov/tiles/#xyz? I'm wondering whether this is freely available for use in websites, and whether any restrictions apply.

No URL Submitted.

Greetings,

For a quick review, please refer to Creative Commons Attribution 4.0 International (CC BY 4.0) summary at https://creativecommons.org/licenses/by/4.0/

For a more detailed description of this license please refer to:
https://creativecommons.org/licenses/by/4.0/legalcode

Hope this helps,
- NYC Open Data

Closed

2017-09-25T00:00:00.000

2026-10-02T00:00:00.000

2581

Data Question

Agency not assigned yet.

We are going through your data in the Job Applications Open Source Data for the DOB but am finding that over time, some of the data is either changed or updated. This is causing problems with our research and would like the opportunity to speak with someone for clarification.

EDIT

Thank you for the quick response, for my research we are pulling Job Application filings over time. When we looked at the data submitted on 9/12/2017 on Friday 9/15/2017 we sorted and analyzed. But then on Monday 9/18/2017 we looked at the same days information (pulled again from the website on monday) the data appeared to have changed.

My question to you is, does the DOB ever change the open source data once it is posted? If yes what is the criteria for changing? If not is there a possible explanation for this?

Another question is, we have seen that there is a 2 day delay from the date of application to date available on Open Source Website. Could you provide more information on the timeline for this process?

No URL Submitted.

Regarding the 2-day delay, this is data coming from our old system. The application process can include delays due to issues like paper form submissions, data entry, or data quality checks between the Legacy system and the system that connects to open data.

For the changes you are seeing, can you give me a specific example of the data that is changing? I don't see anything that's randomly changing, but if you're looking at a specific job number, for example, the Job Status and Job Status Descrp may change over time. New data or changes to job application data should be reflected by new rows in the spreadsheet with a new DOBRunDate at the end. Existing rows in the dataset should not be changed.

If this is not the type of change that you mean, can you give me a specific job number with a specific column name that changed? Or other details that can help me find the change myself so I can troubleshoot?

Closed

2017-09-20T00:00:00.000

2026-10-02T00:00:00.000

2579

Reported Error

Agency not assigned yet.

Can't download 2014_Bronx_Orthoimagery.zip.

No URL Submitted.

Greetings,

The error for the 2014 Orthoimagery Bronx dataset is now fixed.
https://data.cityofnewyork.us/City-Government/2014-Orthoimagery-Bronx/snt7-jkiu

Best,
NYC Open Data

Closed

2017-09-20T00:00:00.000

2026-10-02T00:00:00.000

2575

Reported Error

New York City Police Department (NYPD)

I beleive there is an error in swapping first name and last name.
Explanation:
in the 7002-Computer Associate (Software) List; In last Name column the data displays First Name of the candidate and the First Name Column displays Last name.
this is at least for record 1509 but I believe it's an error made cross the list and even cross many civil service lists.
Thank you

Motor Vehicle Collisions - Crashes

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

Greetings,

Thank you for your request. We will forward it along to the appropriate agency.

- NYC Open Data

Closed

2017-09-19T00:00:00.000

2026-10-02T00:00:00.000

2574

Reported Error

Department of Transportation (DOT)

Wanted to report that api endpoint : https://data.cityofnewyork.us/resource/xswq-wnv9.json is returning error nr. 500.

From here : https://dev.socrata.com/foundry/data.cityofnewyork.us/xswq-wnv9

What could be the issue? Thank you very much!!

Parking Regulation Locations and Signs

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

Greetings,
This dataset is an External Link with no data actually directly hosted on the Socrata platform. This is why the API endpoint returns a 500 error.

Best,
- NYC Open Data

Closed

2017-09-19T00:00:00.000

2026-10-02T00:00:00.000

2572

Data Question

Agency not assigned yet.

Hi, I am looking for data about building heights. I've found the number of floors in the PLUTO dataset, but not the height. Yet some articles I've read suggest it's available somewhere…

No URL Submitted.

Greetings,

Please refer to the Building Footprints map at
https://data.cityofnewyork.us/Housing-Development/Building-Footprints/nqwf-w8eh/data

Best,
- NYC Open Data

Closed

2017-09-18T00:00:00.000

2026-10-02T00:00:00.000

2567

Reported Error

Agency not assigned yet.

When I try to search the database, I get the error message "warning icon This Socrata-powered site is currently unavailable." When will the site be available?

No URL Submitted.

Greetings,

The Socrata website is now fully operation. For the Socrata status updates, please refer to http://status.socrata.com/

Best,
- NYC Open Data

Closed

2017-09-16T00:00:00.000

2026-10-02T00:00:00.000

2566

Data Question

Department of Finance (DOF)

Hello there,

I am using the following APIs
1- https://data.cityofnewyork.us/City-Government/ACRIS-Real-Property-Master/bnx9-e6tj
2- https://data.cityofnewyork.us/City-Government/ACRIS-Real-Property-Parties/636b-3b5g
3- https://data.cityofnewyork.us/City-Government/ACRIS-Real-Property-Legals/8h5j-fqxa
4- https://data.cityofnewyork.us/Housing-Development/Buildings-Subject-to-HPD-Jurisdiction/kj4p-ruqc
5- https://data.cityofnewyork.us/Housing-Development/Housing-Maintenance-Code-Violations/wvxf-dwi5
6- https://data.cityofnewyork.us/Housing-Development/Housing-Litigations/59kj-x8nc
7- https://data.cityofnewyork.us/Housing-Development/Housing-Maintenance-Code-Complaints/uwyv-629c
8- https://data.cityofnewyork.us/Housing-Development/Complaint-Problems/a2nx-4u46
9- https://data.cityofnewyork.us/Housing-Development/DOB-Violations/3h2n-5cm9
10- https://data.cityofnewyork.us/Housing-Development/DOB-Complaints-Received/eabe-havv
11- https://data.cityofnewyork.us/Housing-Development/DOB-ECB-Violations/6bgk-3dad

I need to show the API last update Date in my programs, I am unable to find it. How can I programmatically know when the APIs (Datasets) were last updated.

ACRIS - Personal Property Legals

https://data.cityofnewyork.us/d/uqqa-hym2

Greetings,

The "Data Last Updated" information is stored in the dataset's metadata, and currently, Socrata does not have a functionality that would enable you to use API to access the metadata. However, in the coming months, Socrata is planning to release a customer facing metadata API that will allow you to access metadata programmatically. Hope this helps.

- NYC Open Data

Closed

2017-09-16T00:00:00.000

2026-10-02T00:00:00.000

2565

Reported Error

Agency not assigned yet.

Instead of being blank, the designation date field (DESIG_DATE) has a value of 11/30/1899 12:00:00 AM +0000. This is incorrect, since it should be blank. Also, many recently-designed landmarks have actual designation dates but instead have that one.

No URL Submitted.

Greetings,

According to the Landmark Preservation Commission, there is a discrepancy between the data presented in this map and the original source. The agency is currently working on updating this dataset with corrected information.

Best,
- NYC Open Data

Closed

2017-09-15T00:00:00.000

2026-10-02T00:00:00.000

2558

Reported Error

Office of Technology and Innovation (OTI)

We download the building footprints dataset monthly, and in this month's download several attributes that are documented in the Capture Rules (https://github.com/CityOfNewYork/nyc-planimetrics/blob/master/Capture_Rules.md#building-footprint-attributes) are missing from the dataset. The main attribute of interest to our organization that is missing is `NUM_FLOORS`, but there are several other fields that documented in the capture rules but are missing in the dataset.

One other note - this must be a recent issue. As I mentioned, we download the building footprint dataset monthly and I can verify that the fields were present in our last download on 8/8/2017.

Please let us know when the issue is resolved so that we can update our datasets accordingly.

Thanks for the help!

Building Footprints (Deprecated)

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

Greetings,

Please be advised that the agency has removed NUM_FLOORS and the other columns from the Building Footprints dataset as this data is available from primary sources elsewhere. Specifically to this question, the Dept. of City Planning’s Bytes of the Big Apple MapPLUTO dataset contains the same NUM_FLOORS information as was present in the Building Footprints and can be joined by the data consumer using BBL (borough block lot field) as a key.

The referenced metadata will be updated in a near future to reflect these recent changes to the Building Footprints dataset’s schema.

- NYC Open Data

Closed

2017-09-14T00:00:00.000

2026-10-02T00:00:00.000

2557

Data Question

New York City Police Department (NYPD)

I am trying to determine whether hate crimes are included in the NYPD Complaint Data Historic dataset from 2006-2016. There are several "internal codes." Do any of these codes flag a report as a suspected hate crime? If not, is there a dataset that has incident-level hate crime data with geographic locations attached? 

NYPD Complaint Data Historic

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

There is no code for a hate crime in the complaint data as a number of different crime types could be classified as a hate crime. For privacy reasons, incident level information identifying hate crimes is not released publicly.

Closed

2017-09-14T00:00:00.000

2026-10-02T00:00:00.000

2552

Reported Error

New York City Police Department (NYPD)

I am accessing this dataset through the api using the following : https://data.cityofnewyork.us/Public-Safety/NYPD-Motor-Vehicle-Collisions/h9gi-nx95

and when I access the same time period from a csv download and apply the same filters myself the number of records between the two don't match up. Is there an explanation for this?

Motor Vehicle Collisions - Crashes

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

Greetings,

Can you please provide additional information regarding your query and result discrepancy? If we can see your query perhaps we can help with any errors.
***Closed due to lack of response***

Thank you,
- NYC Open Data

Closed

2017-09-13T00:00:00.000

2026-10-02T00:00:00.000

2549

Data Question

Agency not assigned yet.

How did you create the shapefiles for census blocks?

No URL Submitted.

Greetings,

To examine a content of the files used to create this shapefile, you can download a zipfile using Socrata's Export function (please use "Download as Original" option).

Best,
- NYC Open Data

Closed

2017-09-13T00:00:00.000

2026-10-02T00:00:00.000

2547

Reported Error

Department of Citywide Administrative Services (DCAS)

The query is returning 0 rows, despite there being thousands of records at the source.

Jobs NYC Postings

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

Greetings,

NYC Jobs dataset is now updated with the latest information. Please keep in mind that the dataset is still undergoing a slight restructuring, which caused this error.

- NYC Open Data

Closed

2017-09-12T00:00:00.000

2026-10-02T00:00:00.000

2542

Data Question

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

Is the total OT Paid column represent the total pay or is that just for over time? In that case would I need to add base pay and other pay to get total pay?

Citywide Payroll Data (Fiscal Year)

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

Greetings,

The Total OT Paid column represents total overtime paid to the employee in the fiscal year. To get total paid, you must add together the sum of the following columns: Regular Gross Paid + Total OT Paid + Total Other Pay

Best,
- NYC Open Data

Closed

2017-09-11T00:00:00.000

2026-10-02T00:00:00.000

2537

Data Question

Agency not assigned yet.

Thank you for your reply! I am trying to find a list of units at each building, the BIN part might have not been a correct term.

No URL Submitted.

Many of the Department of City Planning datasets do not contain BIN information due to the data structure, while others, such as Facilities Database, do provide this information. The department provides Metadata/File Layout PDFs for each of its BYTES of the BIG APPLE datasets, and you are encouraged to utilize this resource to identify the datasets with the BIN data.

Thank you,
- NYC Open Data

Closed

2017-09-08T00:00:00.000

2026-10-02T00:00:00.000

2535

Reported Error

Office of Administrative Trials and Hearings (OATH)

Violation 012066308L from July 14 is appearing on ECB Ticket Finder (http://a820-ecbticketfinder.nyc.gov/searchHome.action) but not on Open Data. Please advise.

OATH Hearings Division Case Status

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

Hello,

Please review my reply to this specific ticket to view the attached screenshots. In summary, the record is now showing in both the OATH data set and the OATH website.

Thank you,
- NYC Open Data

Closed

2017-09-07T00:00:00.000

2026-10-02T00:00:00.000

2533

Data Question

Department of Finance (DOF)

Could a field for hearing date be added?

Open Parking and Camera Violations

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

Greetings,

Requests for additional data fields will be reviewed by the Agency and may be added at a future date pending the appropriate approvals and availability of programming resources.

Thank you,
-NYC Department of Finance

Closed

2017-09-06T00:00:00.000

2026-10-02T00:00:00.000

2532

Data Question

Agency not assigned yet.

My requirement is to extract the data and update the previous data downloaded weekly or daily. I was looking for vendor id ( some primary key ) which will map to the vendor names in the list.Because when I compared the data with the previous list,I see that the vendor name got updated.If there was an primary key related to that name, then I can know if it is an update or a new record.My request is if you can also add primary key to the data-set,it will help us big time.
Please let me know if you have any questions.I will promptly reply.

No URL Submitted.

Greetings,

The reason why this particular dataset does not have a unique/primary key is because it is updated with a full replace. If you have a question regarding a specific entry within a dataset, such as a possible discrepancy in vendor's name, you are encouraged to contact Small Business Services customer service at http://www1.nyc.gov/site/sbs/about/contact-us.page.

Hope this helps,
- NYC Open Data

Closed

2017-09-06T00:00:00.000

2026-10-02T00:00:00.000

2529

Reported Error

Agency not assigned yet.

There are public wifi hotspots situated on **** yet it's not listed in the dataset. There's also one at *** that's not listed too

No URL Submitted.

Greetings,

Please refer to the official NYC Wi-Fi Hotspot Locations dataset - https://data.cityofnewyork.us/City-Government/NYC-Wi-Fi-Hotspot-Locations/yjub-udmw/data
This dataset lists the information on wifi hotspots located at ***. Hope this helps.

Best,
NYC Open Data Team

Closed

2017-09-05T00:00:00.000

2026-10-02T00:00:00.000