NYC Open Data Help Desk: Data Questions and Reported Errors

3493

Data Question

Department of Buildings (DOB)

I am trying to see if this building has a Certificate of Occupancy: ***** I was unable to find it via the links to the 2 databases below. Does this mean the building does not have a Certificate of Occupancy?
Thank you, https://data.cityofnewyork.us/Housing-Development/DOB-Certificate-Of-Occupancy/bs8b-p36w/data
http://a810-bisweb.nyc.gov/bisweb/bispi00.jsp

DOB Certificate Of Occupancy

https://data.cityofnewyork.us/d/bs8b-p36w

This just means that we don't have any data for that C of O. We may have an older version of the certificate in paper format. You can contact our Customer Service unit at (212) 566-5000 to find out how to access the C of O for this building. You may need to come to a DOB office in person.

Closed

2018-05-11T00:00:00.000

2026-10-02T00:00:00.000

3491

Data Question

Department of Buildings (DOB)

Having an issue with DOB Complaints Filter system. It does not allow for me to bring up a certain date of data that I need. Error Message: "we are having trouble displaying this table.check to make sure that the underlying dataset has not been deleted or unpublished."

DOB Complaints Received

https://data.cityofnewyork.us/d/eabe-havv

​Thank you for reporting this issue. It looks like it was resolved by the Socrata platform. Please contact their technical support at https://support.socrata.com/hc/en-us if this issue persists.

Thank you,
-NYC Open Data

Closed

2018-05-10T00:00:00.000

2026-10-02T00:00:00.000

3490

Reported Error

Department of Citywide Administrative Services (DCAS)

your response to my previous request ID 1499143. My inquiry was why MY NAME is NOT on the list for the Exams 05537 (List #***) and 05033 (list#***)

Civil Service List Certification

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

You inquired concerning your status on the lists for Principal Administrative Associate, Exam No. 5039 (Open Competitive), and Exam No. 5537 (Promotional).

With respect to Exam No. 5039, your name has not yet been reached on the list for certification or appointment.

With respect to Exam No. 5537, your name is now available for certification (as of 6/1/18) and you will be certified the next time a certification request is received from an agency.

Closed

2018-05-10T00:00:00.000

2026-10-02T00:00:00.000

3488

Data Question

Agency not assigned yet.

Hi,
I have seen some changes in your poverty data files for 2015 and 2016. When using the files of variable-descriptions, value-labels-for-ceo-variables, and systematize_display_of_CEO_variables_sps, I have found some var names are not matched. For example, off_Threshold listed in data file but is not found in above three files. It is confusing to me. For a proper use of CEO data file, 1) can I have an updated data dictionary including variable labels and value labels? 2) can you tell how to use the variables in your data files to calculate the official poverty and the CEO poverty ratios (100%, 125%, 150%, and 200%...)? 3) How to get the poverty ratios by NYC community district as this information is not available in 2015 and 2016 data files? Should it be done after merging the CEO data with ACS PUMS data? 4) when merging CEO data file with ACS PUMS data, the common keys are SerialNo and Sporder? Thank you for help.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please be advised that 2015 and 2016 datasets were recently updated with additional field (NYCgov_Income). As mentioned earlier, Off_Threshold column is already included within the data:
https://data.cityofnewyork.us/City-Government/NYCgov-Poverty-Measure-Data-2015-/9ny4-8k6g
https://data.cityofnewyork.us/City-Government/NYCgov-Poverty-Measure-Data-2016-/y9gu-cxxw
​
If you have further questions, please do not hesitate to reach out to us again.
​
Thank you,
-NYC Open Data

Closed

2018-05-10T00:00:00.000

2026-10-02T00:00:00.000

3487

Data Question

Department of Buildings (DOB)

The issue persists 

DOB Permit Issuance

Thank you for contacting NYC Open Data Help Desk. We checked the underlying DOB Permit Issuance
dataset and did not report any technical issues. You are encouraged to contact Socrata Customer Center at https://support.socrata.com/hc/en-us/requests/new to report and resolve this issue with your filtering views. Please let us know if you need further assistance.

Thank you,
-NYC Open Data

Closed

2018-05-10T00:00:00.000

2026-10-02T00:00:00.000

3485

Data Question

Department of Buildings (DOB)

Error message when trying to access the DOB permit database: We're having trouble displaying this table. Check to make sure the underlying dataset hasn't been deleted or unpublished.

DOB Permit Issuance

Thank you for contacting NYC Open Data Help Desk. This dataset is available on the portal without any technical issues from our end. Please note that the Socrata implemented significant changes to the platform functionality two days ago, which might have been the cause for this temporary glitch. Please let us know if this issue persists.

Thank you,
-NYC Open Data

Closed

2018-05-10T00:00:00.000

2026-10-02T00:00:00.000

3483

Reported Error

Office of Technology and Innovation (OTI)

A very curious problem occurs with this dataset. There is (as far as I can tell) one malformed polygon at shape index 178. As is, the polygon has 303 coordinates. Coordinates from 179 up to 303 are malformed and created a non closed complex domain, when each and every polygon should consists of a closed self avoiding perimeter line, defining a simply connected closed domain. The workaround for user is simple: simply suppress the malformed coordinates. This is as long as they are aware of the error. As I was not it took several hours to understand that my code was not buggy, but that I should look instead at the data. Cheers.

Zip Code Boundaries

Agency representative directly contacted this user

Closed

2018-05-09T00:00:00.000

2026-10-02T00:00:00.000

3480

Reported Error

Department of Buildings (DOB)

The way things are rendering on the website (https://data.cityofnewyork.us/Housing-Development/DOB-Violations/3h2n-5cm9/data), there are sometimes columns that are shifted to the right after a free text field. My guess is that whatever separator the program is searching for in the raw data when it is loaded is contained somewhere in the strings STREET, DISPOSITION_COMMENTS, or DESCRIPTION for these rows.

Examples: Either navigate to the webapp or download the CSV from the link provided above. Filter on ISN_DOB_BIS_VIOL in (98699, 228391, 688184). When ISN_DOB_BIS_VIOL = 98699, you will see STREET = 139, DISPOSITION_DATE = "NASSAU STREET", and DISPOSITION_COMMENTS = 19950307. When ISN_DOB_BIS_VIOL = 228391, you will see STREET = 102 and DISPOSITION_DATE = "WASHINGTON PLACE". When ISN_DOB_BIS_VIOL = 688184, you will see STREET = 174, DISPOSITION_DATE = "WEST 58 STREET", and DISPOSITION_COMMENTS = 20000324. None of these rows are displaying valid values for DISPOSITION_DATE as the values have been shifted to the right.

DOB Violations

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

Hi,

Thank you for the examples. You are correct, there is a problem with this dataset too. I will work with our IT team to get it corrected.
............................

The issue you reported with data being shifted to the wrong columns in a small number of records in our DOB Violations dataset has been fixed. Thank you for reporting it and let us know if we can help with anything else.

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

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

Closed

2018-05-09T00:00:00.000

2026-10-02T00:00:00.000

3478

Data Question

Agency not assigned yet.

you say previous periods are with dob archives so if I want jan feb mar and april 2018 job filing i go to another website and find those job filings? please tell which website that is because i could not find such a website

No URL Submitted.

This question was already answered as part of inquiry #3476.

Closed

2018-05-08T00:00:00.000

2026-10-02T00:00:00.000

3477

Data Question

Agency not assigned yet.

A list of job applications filed for a particular day and associated data. Prior weekly and monthly reports are archived
so if i wanted January 2018 dob job filings i will find this on another website ? if that is true please indicate the website because i couldn't find it thanks

No URL Submitted.

You can find DOB Job Application Filings at this link: https://data.cityofnewyork.us/Housing-Development/DOB-Job-Application-Filings/ic3t-wcy2/data. There are date fields available to sort by, such as pre-filing, latest action, fully paid. You would be able to locate filings for a specific year and month.

Thank you,
- NYC Buildings Open Data Coordinator

Closed

2018-05-08T00:00:00.000

2026-10-02T00:00:00.000

3475

Reported Error

Agency not assigned yet.

Inconsistent search results when entering "Location" or "Street Name". I can provide specific examples. To see one for yourself, search for Agency = "DSNY" (no quotes) and Incident Address begins with "WEST 29" (no quotes). Note the 2nd result has a Unique Key of "***" and an Incident Address of "***".

Now, change the Incident Address to begins with ***" (i.e., add the "29") and five incidents are displayed but not #***.

This is the same 5-hit result as changing Incident Address = "***"

It seems to me that the incident address for #*** is not coded properly. THERE ARE SEVERAL OTHER EXAMPLES. See Incident #s ***

No URL Submitted.

Thank you for bringing this matter to our attention. We passed your observation along to Socrata, the software provider for our open data portal, and they confirm this is an issue that needs to be addressed. We look forward to resolving this as swiftly as possible.

Thank you,
-NYC Open Data

Closed

2018-05-08T00:00:00.000

2026-10-02T00:00:00.000

3474

Reported Error

Agency not assigned yet.

The year built is incorrect. My home was completed in March 13,1952. I have my Certificate of Occupancy from the DOB.

No URL Submitted.

Thank you for your feedback. When you search for a property in Zola, the lot level information returned comes from City Planning's PLUTO dataset. Most of the source data for PLUTO, including the 'Year Built' field, is supplied from a Dept. of Finance (DOF) dataset called Real Property Address Database (RPAD). The 'Year Built' field in RPAD is based on Dept. of Buildings (DOB) permit info. That source information has to be corrected in order for it to show up in our Zola application correctly.

We reached out to DOF and they instructed to use the following "Contact Us" website to request the data update. Please check "Other" for the topic and in the message include your original message you sent Open Data and tell them to update the Year Built field for your property in the Real Property Address Database (RPAD).

Thank you,
- Department of City Planning

Closed

2018-05-08T00:00:00.000

2026-10-02T00:00:00.000

3470

Data Question

Agency not assigned yet.

I'm wondering if it's possible to overlay your School Districts map with our own data about which districts have visited the museum the most. It would be great to have a way to see which districts we should reach out to more. If so, I will need some guidance. Thank you so much!

No URL Submitted.

If you have access to a mapping software (i.e. ESRI, QGIS, CARTO, MapBox, etc.) you could overlay any data you would like with all spatial datasets on open data. If you are requesting something else we would need you to please provide additional information.

Thank you,
- Department of City Planning

Closed

2018-05-07T00:00:00.000

2026-10-02T00:00:00.000

3468

Data Question

Agency not assigned yet.

When was this file last updated? It cannot be 12/22/17 as indicated because we no longer own some of the units that are still indicated as being ours in the file.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please be advised that 12/27/17 date only refers to metadata update for the dataset, not the underlying data. The file itself was uploaded in 2011.

Thank you,
-NYC Open Data

Closed

2018-05-07T00:00:00.000

2026-10-02T00:00:00.000

3467

Data Question

Agency not assigned yet.

Hi,
I'm a developer looking to put together a map for people looking to be more environmental. A huge part of that is helping people find drinking fountains in the city. I found your dataset on drinking fountains, but it unfortunately does not have a longitude and latitude for the fountains so I cannot map them. Could you direct me to a resource that could help?

No URL Submitted.

Hello,

Thank you for contacting NYC Parks regarding drinking fountains in Parks. We are currently in the process of collecting accurate point information for our drinking fountain inventory. We anticipate the data collection to be completed and the dataset released by the end of 2018. Please check the Open Data Portal periodically.

Best,
Tessa at NYC Parks and the Open Data team

Closed

2018-05-07T00:00:00.000

2026-10-02T00:00:00.000

3465

Data Question

Department of Finance (DOF)

Is it possible to start releasing ACRIS data earlier than the 8th of every month? And is it possible to release the latest update today? 

ACRIS - Real Property Master

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

The ACRIS data cannot be released any earlier because the process is tied to a set schedule.

Closed

2018-05-07T00:00:00.000

2026-10-02T00:00:00.000

3464

Data Question

Department of Finance (DOF)

Hi! I am wondering what the start date and end date are for the NYC fiscal year 2016

Parking Violations Issued - Fiscal Year 2016

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

Dates for Fiscal Year 2016
Start Date : 7/1/2015
End Date: 6/30/2016



Department Of Finance (DOF)

Closed

2018-05-05T00:00:00.000

2026-10-02T00:00:00.000

3463

Data Question

Department of Finance (DOF)

Hi there! I am wondering if I can get the list of agencies that could issue the parking tickets. There are only abbreviations in the 'Issuing Agency' column. I think 'P' stands for police department but am not sure about the rests. Thank you.

Parking Violations Issued - Fiscal Year 2016

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

Here are the issuing agencies.

Regards,
NYC Department of Finance
ISSUING-AGENCY-ID ISSUING-AGENCY-DESC
A PORT AUTHORITY
D DEPARTMENT OF BUSINESS SERVICES
E BOARD OF ESTIMATE
F FIRE DEPARTMENT
G TAXI AND LIMOUSINE COMMISSION
H HOUSING AUTHORITY
K PARKS DEPARTMENT
L LONG ISLAND RAILROAD
M TRANSIT AUTHORITY
N NYS PARKS POLICE
P POLICE DEPARTMENT
T TRAFFIC
Z METRO NORTH RAILROAD POLICE
C CON RAIL
S DEPARTMENT OF SANITATION
7 SUNY MARITIME COLLEGE
U PARKING CONTROL UNIT
B TRIBOROUGH BRIDGE AND TUNNEL POLICE
I STATEN ISLAND RAPID TRANSIT POLICE
J AMTRAK RAILROAD POLICE
O NYS COURT OFFICERS
Q DEPARTMENT OF CORRECTION
R NYC TRANSIT AUTHORITY MANAGERS
V DEPARTMENT OF TRANSPORTATION
W HEALTH DEPARTMENT POLICE
X OTHER/UNKNOWN AGENCIES
Y HEALTH AND HOSPITAL CORP. POLICE
1 NYS OFFICE OF MENTAL HEALTH POLICE
2 O M R D D
3 ROOSEVELT ISLAND SECURITY
4 SEA GATE ASSOCIATION POLICE
5 SNUG HARBOR CULTURAL CENTER RANGERS
6 WATERFRONT COMMISSION OF NY HARBOR
9 NYC OFFICE OF THE SHERIFF

Closed

2018-05-04T00:00:00.000

2026-10-02T00:00:00.000

3461

Data Question

New York City Fire Department (FDNY)

To Whom It May Concern,

I am examining the EMS Incident Dispatch data, and notice there is ATOM column for which I am unable to find a corresponding shape file. ATOM bears no resembles to either the Atomic Number or Atomic ID column in the Atomic Polygon shape file (available here - https://www1.nyc.gov/site/planning/data-maps/open-data.page). The Atomic ID consists of 10 numeric characters where the ATOM is alphanumeric and 5 characters long. Could you provide guidance as to how we can geographically map the EMS Incident Dispatch data? We require this for analysis that examines the geographic distribution of the EMS incidents.

EMS Incident Dispatch Data

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

Thank you for your interest in the EMS Dispatch dataset. The Atom refers to geographic areas used for EMS unit dispatching. We are currently reviewing HIPPA and other privacy laws to determine whether these geographic locations may be lawfully released. If we determine that it may be released, we will publish it to the Open Data site. otherwise the atom data point will be removed.

Closed

2018-05-04T00:00:00.000

2026-10-02T00:00:00.000

3458

Reported Error

Agency not assigned yet.

Hello I am currently working on an app that uses the IDNYC location data and it seems that there are some errors in the longitude and latitude of some locations:

QUEENS
Queens Flushing Library - 41-17 Main St, Flushing, 11355
East West Bank - 38 -05 Union Street, Flushing, New York
Amalgamated Bank - 36-16 21st Street, Long Island City, 11106

BROOKLYN
Center For Performance Research - 361 Manhattan Ave, Brooklyn, 11211

STATEN ISLAND
Staten Island - St. George Library Center - 5 Central Avenue, Staten Island, 10301

Those locations do not appear in their correct boroughs. Thanks.

No URL Submitted.

Thank you for flagging these discrepancies. Currently, NYC Open Data is in the process of geocoding those datasets that contain address information in compliance with the Local Law 108 of 2015. IDNYC Locations dataset was identified as an asset that falls under this legislation, and these errors will be addressed and corrected as part of this ongoing process.

Thank you,
-NYC Open Data

Closed

2018-05-04T00:00:00.000

2026-10-02T00:00:00.000

3457

Data Question

Department of Finance (DOF)

Dear NYC department of Finance,
I'm Application developer and would like to tap in https://secure24.ipayment.com/NYCPayments/nycbookmark_1.htm API to retrieve and validate Parking Tickets. Do NYC department of Finance has a public API that I may use.
Open Data API is only updated once a week and would like to access a more real time similar to what https://secure24.ipayment.com/NYCPayments/nycbookmark_1.htm and Winit Mobile app is calling.
Thank you!

Open Parking and Camera Violations

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

NYC does not have an API available.

Closed

2018-05-04T00:00:00.000

2026-10-02T00:00:00.000

3456

Reported Error

Agency not assigned yet.

Prior to downloading 311 service requests from 2010 to present, I added one filter condition, such as eliminate noise complaints in the 311 service requests from 2010 to present, which worked fine. Then I added a second filter condition, to eliminate certain agencies, such as the NYPD, and the system could not complete this task. Instead, a blue wheel endlessly spun and I had to close the window. I tried other combinations of filter conditions to reduce the number of records before exporting the data, but in each instance, only the first filter condition was actually completed by your system. It's not "open data," if it's actually inaccessible.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. We did not find any issues with the 311 dataset itself as we were able to create a sample filter that excluded the noise complaints, and NYPD and DSNY agencies within this subset.
Please note, please note that 311 dataset contains 17.6 million records, and generating a filter with multiple conditions might result in a time-consuming operation depending on your available resources.

For technical questions related to the Socrata platform's functionality, you are encouraged to reach out to their support at https://support.socrata.com/hc/en-us/requests/new to resolve this issue.

Closed

2018-05-03T00:00:00.000

2026-10-02T00:00:00.000

3455

Data Question

Agency not assigned yet.

The filter function doesn't seem to work properly after one condition is filtered and another condition is added.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Can you kindly provide us with detailed information related to this issue?
You are also encouraged to directly contact Socrata support at
https://support.socrata.com/hc/en-us/requests/new

Thank you,
-NYC Open Data

Closed

2018-05-03T00:00:00.000

2026-10-02T00:00:00.000

3454

Data Question

Agency not assigned yet.

I'm trying to map the water use of buildings within NYC. For most of the buildings I could use estimations, but apparently, for all NYCHA buildings, I do not have to, because you have the data available. I found this datafile, but the problem is, it doesn't have the BBL (Borough, Block, Lot number) of the different buildings. Is there maybe a way to obtain these? Because then I can link it to the PLUTO databank. 

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please be advised that Water Consumption And Cost dataset was updated with the latest available information, and with BBL column added.
​https://data.cityofnewyork.us/Housing-Development/Water-Consumption-And-Cost-2013-June-2018-/66be-66yr

Thank you,
- NYC Open Data Team

Closed

2018-05-03T00:00:00.000

2026-10-02T00:00:00.000

3453

Data Question

Agency not assigned yet.

I am interested in using NYC 311 data for a research project, but I would like to find a way to identify 311 service requests that are submitted by The Street Conditions Observation Unit (SCOUT) rather than residents themselves. I understand that SCOUT inspectors regularly inspect local streets and report their findings via 311. Would you be able to let me know whether the 311 data shared on the NYC Open Data portal include 311 service requests submitted by SCOUT inspectors? And If so, is there a way I can identify 311 requests that were submitted by SCOUT (e.g., a particular code or variable in the dataset)? I’ve previously emailed the NYC Mayor’s Office of Data Analytics and the NYC Mayor’s Office of Operations but did not hear back from them.

I hope that my questions make sense, and any insights you could provide would be greatly appreciated. The NYC Open Data portal has been a wonderful resource. Thanks in advance for your help with this.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Yes, the 311 Service Requests data set does include SRs from SCOUT inspectors, but unfortunately there's no indicator of the source (SCOUT vs residents) in the public data set.

Thank you,
-NYC Open Data

Closed

2018-05-02T00:00:00.000

2026-10-02T00:00:00.000

3452

Reported Error

Agency not assigned yet.

Parking lot located at *** is not shown on Parking Lot file

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please be advised that the orthographic images are taken every 4 years and do not always reflect the current data. Please note that the last planimetric mapping aerial survey took place in 2016.

Thank you,
-NYC Open Data

Closed

2018-05-02T00:00:00.000

2026-10-02T00:00:00.000

3451

Data Question

311

Hi there,

I'm a researcher at NYU CUSP, working to make 311 data more accessible for a few primary use cases. We're working on a capstone research project, and part of it is consolidating open data considerations that can help with interpretation.

We've noticed that the dataset has been going through changes in the past few weeks (the amount of rows has changed, and the columns provided). We want to understand why and when theses changes are made on open data. Are there any resources that can help answer this question, or is there someone we can be connected with to discuss?

311 Service Requests from 2020 to Present

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that 311 Service Requests from 2010 to Present dataset has recently undergone structural changes. For a general review of changes to this dataset, please refer to http://www1.nyc.gov/311/nyc311-enhances-service-request-open-dataset.page
​311 dataset is now fully refreshed and contains (as of 05/02/2018) - 17.5 million records.

Thank you,
-NYC Open Data

Closed

2018-05-02T00:00:00.000

2026-10-02T00:00:00.000

3450

Data Question

Agency not assigned yet.

What happened to the export CSV Europe format? I used to be able to do this and now I do not see the option

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. It looks like Socrata has removed/disabled this feature. For more information about this issue, you are encouraged to ​contact their customer center at https://support.socrata.com/hc/en-us/requests/new
​
Thank you,
-NYC Open Data

Closed

2018-05-02T00:00:00.000

2026-10-02T00:00:00.000

3449

Data Question

Department of Buildings (DOB)

Would you be able to add the field "Work on Floor(s)" to this dataset?

DOB Job Application Filings

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

Thank you for your dataset inquiry. Your request for additional data has been noted.

Closed

2018-05-02T00:00:00.000

2026-10-02T00:00:00.000

3447

Data Question

311

Hi,
The 311 complaints since 2010 dataset currently contains 9.36M records, but about 2-3 months ago it held about 17M records. short check i did showed most of the missing records are in the years 2010-2015.
I just wanted to know about the nature of this change, and what is the pattern of the removed records, and why while keeping some 2010-2015 records, others were removed.
Also, did the 17M dataset from 2-3 months ago DID contained ALL 2010-2015 complaints, or this version was also missing some.
Also, i wish changes like these could be noted in the notes of the dataset.
All in all, this data is very useful and thank you for making it accessible.

311 Service Requests from 2020 to Present

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that 311 Service Requests from 2010 to Present dataset has recently undergone structural changes. For a general review of changes to this dataset, please refer to http://www1.nyc.gov/311/nyc311-enhances-service-request-open-dataset.page
​311 dataset is now fully refreshed and contains (as of 05/02/2018) - 17.5 million records.

Thank you,
-NYC Open Data

Closed

2018-05-02T00:00:00.000

2026-10-02T00:00:00.000

3444

Data Question

New York City Police Department (NYPD)

Is it possible to get motor vehicle collisions from 2010 through 2012. It looks like the NYPD Motor Vehicle Collisions dataset only goes pack to July 2012.

Motor Vehicle Collisions - Crashes

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

Thank​ you for contacting NYC Open Data Help Desk. Please be advised that NYPD does not have a data for this dataset prior to July 2012.
​
Thank you,
-NYC Open Data

Closed

2018-05-01T00:00:00.000

2026-10-02T00:00:00.000

3443

Reported Error

Agency not assigned yet.

HI! I am writing regarding New York City Farmers Markets data set. Latitude and Longitude columns are formatted as a whole numbers without any decimal points, which make them useless. Do you know if the NYC DOHMH will be releasing new/corrected farmers market data any time soon?
Thanks!

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please refer to the current dataset for Farmer Market locations. We've also added Food Box locations as well.
​https://data.cityofnewyork.us/dataset/DOHMH-Farmers-Market-and-Food-Box/8vwk-6iz2

Thank you,
-NYC Open Data

Closed

2018-05-01T00:00:00.000

2026-10-02T00:00:00.000

3439

Reported Error

Office of Technology and Innovation (OTI)

The Building Footprint/Height database in Long Island City is not up to date. I personally walked along Jackson Ave and saw newly constructed buildings that are NOT represented. However these building DO show up in Google Earth. When will this database be updated to show current reality???

Building Footprints (Deprecated)

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that the orthographic images that serve as a base for the building footprints are taken every 4 years. The last planimetric mapping aerial survey took place in 2016, and we do not expect the next survey to take place for another 2 years.

Thank you,
-NYC Open Data

Closed

2018-04-30T00:00:00.000

2026-10-02T00:00:00.000

3438

Data Question

School Construction Authority (SCA)

Hi! My question refers to the asterisks (*) in this dataset, that are next to some building names - I haven't found this outlined in the codebook. Particularly, some organizations have extra rows of data for that are labeled "transportable" (i.e. R019 - P.S. 19- S.I.) has 3 extra rows called P.S. 19 TRANSPORTABLE - S.I., with 100 enrolled in each. Is this 100 to be added to the enrollment counts for each year (or subtracted, ignored)? The row above then has the two asterisks "P.S. 19 - S.I.**".

Enrollment Capacity And Utilization Reports - Target by Organization

Thank you for contacting NYC Open Data Help Desk. The asterisks next to the building name indicate that the TCU (Transportable Classroom Unit) enrollment is added to the main building enrollment when calculating capacity. Without it, the utilization for R019 @ R019 would be 114% instead of 136% (529 divided by 464 instead of 629 divided by 424).
​
​Please note that this dataset is not one report, but three years’ worth of accumulated data. In order to see the latest data, filter the field called “Data As Of” for the most recent year. There are only two rows associated with R019.

Thank you,
-NYC Open Data

Closed

2018-04-30T00:00:00.000

2026-10-02T00:00:00.000

3435

Data Question

Agency not assigned yet.

I am trying to confirm ownership of coop . The ss# attached by Chase bank is ,

No URL Submitted.

Thank you for your dataset inquiry. We do not provide or accept ownership information, or personally-identifiable information (SSN or tax ID), through Open Data.

Mark - NYC Buildings Open Data Coordinator.

Closed

2018-04-30T00:00:00.000

2026-10-02T00:00:00.000

3434

Data Question

Agency not assigned yet.

Cannot find anything on MTAC (Multiple Task Award Contracts) awarded or pending with the Board of Education. I need this information, specifically for school wellness programs.

No URL Submitted.

I am unfamiliar with this particular data set. It will mean extensive research to locate. If, and when I can obtain, I'll be sure to post a copy to the portal

Thank you,
- NYC DOE Open Data

Closed

2018-04-30T00:00:00.000

2026-10-02T00:00:00.000

3433

Data Question

Department of Finance (DOF)

Hi! I do not understand why there are some values in the Violation Precinct column that way larger than 123. I thought there are total only 123 precincts in the whole city.

Parking Violations Issued - Fiscal Year 2016

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

The values that exceed the current highest precinct number of 123 are most likely the result of being miss-keyed from a hand written violation.

Regards,
NYC Department of Finance

Closed

2018-04-29T00:00:00.000

2026-10-02T00:00:00.000

3432

Data Question

Department of Finance (DOF)

Hi there! Could you provide more explanations on the column, Issuer Command? Also, why are there numeric values and alphabetic values in the Issuer Squad Command? Thank you!

Parking Violations Issued - Fiscal Year 2016

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

Issuer Command is a field provided by the NYPD Traffic division and represents the unit to which the issuing agent is assigned.

Regards,
NYC Department of Finance

Closed

2018-04-29T00:00:00.000

2026-10-02T00:00:00.000

3428

Data Question

Agency not assigned yet.

How do I access your the open Data feed to the dept of Bldg data?

No URL Submitted.

Hi,

You can access all datasets from the Department of Buildings at https://data.cityofnewyork.us/browse?Dataset-Information_Agency=Department+of+Buildings+%28DOB%29&provenance=official&q=. Let us know if you have any additional questions.

Thank you,
- , DOB Open Data Coordinator

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

Closed

2018-04-27T00:00:00.000

2026-10-02T00:00:00.000

3427

Data Question

Agency not assigned yet.

I would like to know what type of work was done on Job # *** filing date was 6/25/1997 and Job # *** filing date was 9/21/1999. Both of these jobs were conducted at *** which is an apartment complex. There was no apartment numbers listed just job types which I have narrowed down. I tried calling both contractors, with negative results. Thank you.

No URL Submitted.

You can see the entire Job Application form in our Buildings Information System (BIS) - http://a810-bisweb.nyc.gov/bisweb/bsqpm01.jsp.

Job # *** has a Job Description of "SIDEWALK AND DRIVEWAY REPAIR/REPLACEMENT" and Job # *** has a Job Description of "CONSTRUCT HANDICAPPED RAMP IN BUILDING M AIN ENTRANCE LOBBY".

Closed

2018-04-27T00:00:00.000

2026-10-02T00:00:00.000

3425

Data Question

Office of Technology and Innovation (OTI)

What datum are these elevations based on? I can't seem to find that specified anywhere. Thanks

NYC Planimetric Database: Elevation Points

https://data.cityofnewyork.us/d/szwg-xci6

Thank you for contacting NYC Open Data Help Desk. For detailed information on this dataset, please refer to ​https://github.com/CityOfNewYork/nyc-planimetrics/blob/master/Capture_Rules.md
​
Thank you,
-NYC Open Data

Closed

2018-04-27T00:00:00.000

2026-10-02T00:00:00.000

3422

Data Question

Agency not assigned yet.

Hi! I'm have a few questions about this data...not necessarily this exact dataset, but rather what is the best way to get to the data that this dataset provides? I'm particularly interested in knowing if a school is over or under their total capacity. I notice that the above data set says that it is no longer updated, but the last time it was updated was December 2017, so I'm also wondering about what year the data in this dataset represent. I have also visited the linked datasets in the description (https://data.cityofnewyork.us/Education/Enrollment-Capacity-And-Utilization-Reports-Target/8b9a-pywy) and with that I'm wondering about the code book. Particularly, for the "target utilization" variable, it is listed as a Number, but I'm wondering how it should actually be interpreted (i.e. as a percentage).

I know I have listed many questions but I do believe that they have an easy answer, I just wanted to make sure I am using the correct data before I go ahead with my analysis. Thank you in advance!!

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. As per NYC School Construction Authority's statements, this and other datasets of the series that are no longer maintained represent 2012-13 Enrollment Capacity and Utilization Report data. These datasets is superseded by other reports already on the portal, including:
​
​https://data.cityofnewyork.us/Education/Enrollment-Capacity-And-Utilization-Reports-Target/gkd7-3vk7/data
​https://data.cityofnewyork.us/Education/Enrollment-Capacity-And-Utilization-Reports-Target/8b9a-pywy
​
The measure of whether a school is over or under capacity is called utilization. Utilization is calculated by dividing the enrollment by the capacity. Enrollment / Capacity = Utilization
It is expressed as a percentage rounded to the nearest integer, however it is listed as an integer on the report. To display this value as a percentage, divide by 100.

Thank you,
​-NYC Open Data

Closed

2018-04-26T00:00:00.000

2026-10-02T00:00:00.000

3421

Data Question

Agency not assigned yet.

I wanted to create a point map visualization using your tool. However, the map visualization only allows me to select a single dimension. What can i do in the case of when i have two separate columns for longitude and latitude.

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please be advised that the DOHMH Cooling Tower Data dataset was updated with "Location 1" column added for the purpose of map visualization.
Thank you,
-NYC Open Data

Closed

2018-04-26T00:00:00.000

2026-10-02T00:00:00.000

3417

Reported Error

Office of Technology and Innovation (OTI)

How is that Google Earth is more current that NYC Open Data?

Building Footprints (Deprecated)

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that the building footprint photos are taken once every four years; the satellites that provide photos to Google Earth orbit somewhat more often than that. Other discrepancies can be explained by the fact that these are two different data sets, maintained by different organizations, using different information sources, and updated at different intervals. Thus, there are likely to be inconsistencies between them. Please do send us the discrepancies you found, and we’ll investigate them.
​
Thank you,
-NYC Open Data

Closed

2018-04-25T00:00:00.000

2026-10-02T00:00:00.000

3415

Data Question

Agency not assigned yet.

Hi! I am quite sure that Pre-K School Directory doesn't include information about 3-K that was rolled out in several districts. Is there an open data dataset that corresponds with these district specific pdf files? http://schools.nyc.gov/NR/rdonlyres/3E0239C5-258C-46D6-B961-F4AA25AF1FD9/0/D43KProgramListENGLISH.pdf

No URL Submitted.

The 3-K sites are included in following data https://data.cityofnewyork.us/Education/2018-Pre-K-School-Directory/xck4-5xd5/data
E.G. 27QAUW - Alpha Kappa Alpha Epsilon Pi Omega DCC

Thank you,
- NYC DOE Open Data

Closed

2018-04-25T00:00:00.000

2026-10-02T00:00:00.000

3414

Data Question

Agency not assigned yet.

I'm an independent developers designing and implementing NYC parking and camera violation mobile app to help people efficiently manage their tickets. I'm in process of analyzing several data sets made available on NYC OpenData, i.e. nc67-uf89.json, uvbq-3m68.json. As of this writing latest available records are for issue_date <= 04/17/2018. However, I came across several mobile apps/websites, i.e. WinIt, finenyc.com that show records with issue_date of at least 04/19/2018. None of them are official NYC apps/websites, and I'm wondering whether DOF offers an API available to outside developers with more recent data. Does DOF offer a partnership which would facilitate such access?

No URL Submitted.

There is no API available, the only data available is on the Open Data portal.

Closed

2018-04-25T00:00:00.000

2026-10-02T00:00:00.000

3412

Data Question

Agency not assigned yet.

I've successfully linked an OData dataset to Excel. But it is small (36 records), and given the narrow filter, won't update frequently. Since I'm new at this, I wanted to go for something with more activity so I could see/test/learn. This is all to say that I have successfully made this linkage.
So I found the URL above, a dataset that updates daily; and I reduced it to only 3,000 records and 9 fields. But the download starts (and I don't touch the keyboard) and then after 100 records I get a "download did not complete" or "download failed" message with:
***[DataSource.Error] We couldn't parse OData response result. Error: A type named 'data.cityofnewyork.us.75uw-utdb' could not be resolved by the model. When a model is available, each type name must resolve to a valid type.***
This is with the V2 endpoint. I can't connect to anything with this or other datasets with the V4 endpoint, by the way--even tho the EXPORT interface reads like V4 is what I should be using with Excel. V4 doesn't even start downloading ever and just yields ***Details: "We were unable to resolve the type name '75uw-utdb' to an EdmType"***
So I'm really wondering whether the problem is on my end. These are not "type names" in the data. Sounds like a bigger picture problem.

Windows 8.1 machine (64 bit), Excel 2013. I have no problem downloading the whole 3,000 records as a "CSV for Excel" file, by the way. That happens in a heartbeat.
Thanks for any direction.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. For technical issues regarding platform's functionality and error reporting, you are encouraged to contact Socrata support at
​https://support.socrata.com/hc/en-us/requests/new
​
Thank you,
-NYC Open Data

Closed

2018-04-25T00:00:00.000

2026-10-02T00:00:00.000

3410

Data Question

Agency not assigned yet.

Ecb # 3536251X has no image on BIS system
Please advise
Ty

No URL Submitted.

Hi,

I don't see that ECB Violation Number in any of our systems. Please check that the number is correct and try again.

Thank you,
- , DOB Open Data Coordinator

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

Closed

2018-04-25T00:00:00.000

2026-10-02T00:00:00.000

3409

Data Question

Agency not assigned yet.

I would like to export this LIDAR data to a 3d modeling program. I am using QGIS and have been unable to access the 3d data, only the raster image.
Can you please point me in the right direction?

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please be advised that this functionality is not currently available for this data.

Thank you,
-NYC Open Data
Expand

Closed

2018-04-25T00:00:00.000

2026-10-02T00:00:00.000

3408

Reported Error

311

It reports Invalid SoQL query all the time

311 Service Requests from 2020 to Present

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

​Thank you for contacting NYC Open Data Help Desk. Please be advised that 311 dataset was recently restructured and updated, which might be the cause of this issue. For a general summary of these newly implemented changes, please refer to http://www1.nyc.gov/311/nyc311-enhances-service-request-open-dataset.page

In addition, you are encouraged to contact Socrata support for technical issues or questions related to the platform's functionality at https://support.socrata.com/hc/en-us/requests/new

Thank you,
-NYC Open Data

Closed

2018-04-24T00:00:00.000

2026-10-02T00:00:00.000