NYC Open Data Help Desk: Data Questions and Reported Errors

5110

Data Question

Department of Finance (DOF)

PLEASE help. ABAT_GRANT and ABATEMENT are always the same number. I assume one should be the amount for a single year and the other should be the sum over the life of the abatement. So (a) which number are you giving us? I think it looks like a single year. And (b) please please please supply both numbers. I think what is missing is the multi-year sum. I think I can see how to back into the total but it makes analysis of a large dataset harder.
Thanks for all your work.

J-51 Exemption and Abatement (Historical)

https://data.cityofnewyork.us/d/y7az-s7wc

The ABAT_GRANT and ABATEMENT are the same amounts. The total abatement is determined from the COST_OF_ALT and the AB_PCT.


Thank you,
- NYC Open Data Team

Closed

2019-04-28T00:00:00.000

2026-10-02T00:00:00.000

5107

Data Question

Department of Finance (DOF)

Does this dataset contain all J-51 benefits going back to the 1950s? If I find that a building has abatements only back to 1978, is that the whole history (for J51)? Thanks.

J-51 Exemption and Abatement (Historical)

https://data.cityofnewyork.us/d/y7az-s7wc

The J-51 records available only go back to 1973.

Closed

2019-04-27T00:00:00.000

2026-10-02T00:00:00.000

5104

Data Question

Agency not assigned yet.

According to the date on the original shapefile, this dataset hasn’t been updated in over a year. Could you please provide an update?
City Planning is required by City Charter to provide annual updates of our Facilities Database. Your dataset is one of the source datasets for Facilities Database. As such, we require annual updates to the dataset.
Please let us know if we should be getting this data from a different source.

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please be advised that this information is provided by the NYCity Map at http://maps.nyc.gov/doitt/nycitymap/

Thank you,
- NYC Open Data Team

Closed

2019-04-26T00:00:00.000

2026-10-02T00:00:00.000

5103

Data Question

Department of Education (DOE)

According to the “Data Last Updated” information on NY OpenData, this dataset hasn’t been updated in over a year. Could you please provide an update?
City Planning is required by City Charter to provide annual updates of our Facilities Database. Your dataset is one of the source datasets for Facilities Database. As such, we require annual updates to the dataset.
Please let us know if we should be getting this data from a different source.

Universal Pre-K (UPK) School Locations

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

The data set is updated at the new school year and all sites have been verified. The next update is scheduled for the school year 2019-2020.


Thank you,
- NYC Open Data Team

Closed

2019-04-26T00:00:00.000

2026-10-02T00:00:00.000

5102

Data Question

Agency not assigned yet.

According to the “Data Last Updated” information on NY OpenData, this dataset hasn’t been updated in over a year. Could you please provide an update?
City Planning is required by City Charter to provide annual updates of our Facilities Database. Your dataset is one of the source datasets for Facilities Database. As such, we require annual updates to the dataset.
Please let us know if we should be getting this data from a different source.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. ​These are Worksource1 Centers and they have not changed over the year so the data is up-to-date.

​Thank you,
- NYC Department of Small Business Services

Closed

2019-04-26T00:00:00.000

2026-10-02T00:00:00.000

5100

Data Question

Department of Youth and Community Development (DYCD)

According to the “Data Last Updated” information on NY OpenData, this dataset hasn’t been updated in over a year. Could you please provide an update?
City Planning is required by City Charter to provide annual updates of our Facilities Database. Your dataset is one of the source datasets for Facilities Database. As such, we require annual updates to the dataset.
Please let us know if we should be getting this data from a different source

DYCD after-school programs

​Thank you for contacting NYC Open Data Help Desk. Please refer to the recently published DYCD Program Sites datset at https://data.cityofnewyork.us/Social-Services/DYCD-Program-Sites/ebkm-iyma

Thank you,
- NYC Open Data Team

Closed

2019-04-26T00:00:00.000

2026-10-02T00:00:00.000

5096

Data Question

Agency not assigned yet.

Greetings. The data set has a lot of repetitions for the same parks and locations. I am trying to determine which NYC borough has the most amount of parks/open space, but I am unsure if the repetitions are mistakes or purposely there. Thank you.

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. For additional information, please refer to ​https://github.com/CityOfNewYork/nyc-planimetrics/blob/master/Capture_Rules.md
​
​These repetitions are part of the update process that captures all if any changes with each update.

​Thank you,
- NYC Open Data Team

Closed

2019-04-26T00:00:00.000

2026-10-02T00:00:00.000

5093

Data Question

Agency not assigned yet.

Good afternoon,

I am writing to request information about the property at 132 4th Avenue, New York, NY .

May we obtain,
- Copies of open zoning/building/fire code violations
- Copies of Certificates of Occupancy

Thank you,

No URL Submitted.

Hi,

For an in depth report on a specific building like you're looking for, your best bet is to use our Building Information System (BIS). On this building's Property Profile, you'll find a wealth of information about the building. If you click on Certificates of Occupancy near the top, you'll get a list of all of them. (104339235-23.PDF near the bottom is the most recent.) On the bottom left of the Property Profile page, you'll see 2 links for Violations - DOB and Violations - ECB that list all of the violations on this property issued by the Department of Buildings. I don't see any open violations on either list.

Thank you,
- , DOB Open Data Coordinator

Closed

2019-04-25T00:00:00.000

2026-10-02T00:00:00.000

5091

Data Question

Agency not assigned yet.

Hi, I tested to implement service which finds a hurricane evacuation zone by given position.

I called open API by this request: https://data.cityofnewyork.us/resource/rb3k-upyb.json?$select=hurricane&$where=intersects(the_geom, 'POINT (-73.9931 40.645)')

And got result:
[
{
"hurricane": "X"
}
]

From map it seems that this point should not be in an any evacuation zone. What does that X means? Usually when finding zone from point which is not in any evacuation zone, I get empty array.

No URL Submitted.

The Hurricane Evacuation Zone value of 'X' = No Evacuation Zone.

The full list of domain values are as follow:
0 = Water Blocks
1 = Zone 1
2 = Zone 2
3 = Zone 3
4 = Zone 4
5 = Zone 5
6 = Zone 6
X = No Evacuation

We will add this to the metadata so that this is clarified to data users.

Thank you,
- NYC DCP OpenData Team

Closed

2019-04-25T00:00:00.000

2026-10-02T00:00:00.000

5089

Reported Error

Agency not assigned yet.

As usual, a poorly managed Platform. I walked two miles in Old Astoria. Three Payphones DON'T EXIST. On 27th Ave and on 8th Street.

No URL Submitted.

Response not sent yet.

Closed

2019-04-24T00:00:00.000

2026-10-02T00:00:00.000

5088

Data Question

Department of Finance (DOF)

Hello, the dataset contains 3 columns labeled "Street Code1", "Street Code2" and "Street Codse3". What are these coordinates and is there a reference map/guide that can allow me to locate the street to which these coordinates describe?

Parking Violations Issued - Fiscal Year 2027

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

The three data fields (Street Code1/Code2/Code3) are GIS coordinates of the location where the violation was issued and intersecting street boundaries. The coordinate values are derived from data provided by the Department of City Planning. The BYTES of the BIG APPLE™ family of software, data and geographic base map files can be downloaded here for free. To receive alerts when new data sets or updates are available, subscribe to our BYTES of the BIG APPLE RSS Feed. (http://www1.nyc.gov/site/planning/data-maps/open-data.page).

Closed

2019-04-24T00:00:00.000

2026-10-02T00:00:00.000

5085

Reported Error

Department of Sanitation (DSNY)

Dataset doesn't provide raw numbers, only rates, greatly limiting its utility. Thx.

Recycling Diversion and Capture Rates

https://data.cityofnewyork.us/d/gaq9-z3hz

​Thank you for contacting NYC Open Data Help Desk. ​Diversion Rates are calculated based on the raw numbers of the collections reported in the DSNY Monthly Tonnage Data dataset at https://data.cityofnewyork.us/City-Government/DSNY-Monthly-Tonnage-Data/ebb7-mvp5/data
​Capture rates have been discontinued since 2013.
​
Thank you,
- NYC Department of Sanitation

Closed

2019-04-23T00:00:00.000

2026-10-02T00:00:00.000

5075

Reported Error

New York City Police Department (NYPD)

The dataset only goes through 2017, not 2018 as the metadata says it will. Because the year-to-date arrest dataset only includes 2019 data, there is no 2018 arrest data available.

NYPD Arrests Data (Historic)

https://data.cityofnewyork.us/d/8h9b-rp9u

Thank you for contacting NYC Open Data Help Desk. Please be advised that the arrest data for 2018 is still maintained in the NYPD Arrest Data (Year to Date) at this url - https://data.cityofnewyork.us/Public-Safety/NYPD-Arrest-Data-Year-to-Date-/uip8-fykc
​In the coming weeks, we will be updating the current Year-to-date dataset with 2019 data, at which time the 2018 data will be moved to Historical dataset.

Thank you,
- NYC Open Data Team

Closed

2019-04-22T00:00:00.000

2026-10-02T00:00:00.000

5063

Data Question

Agency not assigned yet.

Why the "Civil Service List Certification" hasn't been updated since April 12, 2019 ?

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please be advised that Civil Service List Certification was updated with the latest available information.

Thank you,
- NYC Open Data Team

Closed

2019-04-18T00:00:00.000

2026-10-02T00:00:00.000

5060

Data Question

Department of Citywide Administrative Services (DCAS)

Civil Service List Certification has not been updated since 4/12/19.
Could you please take care of this!

Thank You!

Civil Service List Certification

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

Thank you for bringing this to our attention! We will look into this as soon as possible.

Thank you,
- NYC Open Data Team

Closed

2019-04-17T00:00:00.000

2026-10-02T00:00:00.000

5057

Reported Error

Agency not assigned yet.

The latitude of all DCLA organizations has been incorrectly copied into the longitude column (need correct longitude data).

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk and reporting this error. ​The issue was resolved and the correct values for the Longitude column added to the data.
​
Thank you,
- NYC Open Data Team

Closed

2019-04-17T00:00:00.000

2026-10-02T00:00:00.000

5054

Data Question

Agency not assigned yet.

Trying to locate building permit for 3 East 78th Street, Apartment 2A, NYC 10075 for replacement of windows for apartment 2A. Was posted to outside of building but no longer there.

No URL Submitted.

Hi,

I'm not sure which permit exactly that you're looking for, since we don't issue a permit for window installation specifically. I think it might have fallen under this general construction permit.

We are in the process of switching from our old database to a new one, so to get all of the permits for a building in open data, you currently have to look at both DOB Permit Issuance and DOB NOW: Build – Approved Permits. If you want a holistic view of a single building, you can use our Building Information System (BIS) or DOB NOW web applications.

Thank you,
- , DOB Open Data Coordinator

Closed

2019-04-17T00:00:00.000

2026-10-02T00:00:00.000

5050

Data Question

Department of Environmental Protection (DEP)

1. What does the column name "Calc__Rain" stand for?
2. Is the year of construction (or scheduled year of construction) of these green infrastructure available?

Thank you so much for your help.

DEP Green Infrastructure

https://data.cityofnewyork.us/d/spjh-pz7h

Please see below for the responses to your questions about the Green Infrastructure dataset:

1. What does the column name "Calc__Rain" stand for?
>Calc_rain (short for calculated volume of rainfall managed) is the volume of rainwater that an asset could capture over a 24 hour, one inch rain event. The unit is cubic feet.
2. Is the year of construction (or scheduled year of construction) of these green infrastructure available?
> The Department of Environmental Protection is exploring the possibility of adding the year constructed to the features in this dataset. We will notify you when a decision has been taken.

Thank you,
- NYC Open Data Team

Closed

2019-04-17T00:00:00.000

2026-10-02T00:00:00.000

5047

Data Question

Agency not assigned yet.

What do the legends P, WD, and U stand on the quality review ratings for NYC schools? Working on a regression analysis report for grad school. Thanks.

No URL Submitted.

Please see the data dictionary attached to the file.
Range of possible values: U/UD, UPF, D, P, WD, O (U/UD = Underdeveloped; UPF = Underdeveloped with Proficient Features (only an option in 2007-8, 2008-9 and 2009-10); D = Developing, P = Proficient, WD = Well Developed, O = Outstanding (only an option in 2007-8)

Closed

2019-04-16T00:00:00.000

2026-10-02T00:00:00.000

5046

Data Question

Department of Parks and Recreation (PARKS)

Is there an indicator for when the park was opened? How is the "TYPECATEGO" and "SUBCATEGOR" determined? What do the variables "PERMIT" and "PIP_RATABL" indicate?

ARCHIVED - Parks Properties

https://data.cityofnewyork.us/d/k2ya-ucmv

Thank you for contacting NYC Parks regarding the Parks Properties dataset.

Park Opening: The ACQUISITIONDATE is the best date to use for when a park "opened". This date indicates when the agency acquired the property. The date is not the easiest to read on the Open Data Portal but if you ignore the zeros the date appears. For example, 19340803000000.00000 is 08/03/1934.

TYPECATEGORY: This field describes the type of property as defined by our Planning division at NYC Parks. There is a detailed list of type categories in the data dictionary (4th tab, titled "Typecategory").

SUBCATEGORY: This field defines the property as well, but the category is used by our Operations and Management Planning division (OMP). OMP is responsible for the Parks Inspection Program (PIP). You can learn more about the program here.

PIP_RATABLE: This field indicates if the property is rated as part of the Parks Inspection Program.

PERMIT: This field indicates if the property is available for reservation by permit, such as for a special event.

Thank you,
-NYC Parks and the NYC Open Data Team

Closed

2019-04-16T00:00:00.000

2026-10-02T00:00:00.000

5045

Reported Error

Agency not assigned yet.

I probably did something wrong but my issue is this, I orginally had an account made and I attempted to log in and monitor my account because I just wanted to see what the account data base looks like after completing an exam. I must of created a new account under the same email address. The new account with my name and the same email address as my original account is completely new and unaware that I applied,paid for, and completed an exam. Could we retrieve and restore my original account, and perhaps delete the new and unneeded account I created earlier today by mistake please?

No URL Submitted.

​Thank you for contacting NYC Open Data Help ​Desk. For help with your Socrata account management and other related issues, please reach out to Socrata support at https://support.socrata.com/hc/en-us
​​
Thank you,
- NYC Open Data Team

Closed

2019-04-16T00:00:00.000

2026-10-02T00:00:00.000

5034

Reported Error

311

The data that is returned is not only NYC zipcodes.

This is the get request I sent : https://data.cityofnewyork.us/resource/fhrw-4uyv.csv?$select=date_extract_y(created_date) as year,incident_zip as zipcode, count(*) as count&$where=created_date between '2016-01-01T00:00:00'and'2018-12-31T23:59:59'&$group=year,zipcode

311 Service Requests from 2020 to Present

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

Response not sent yet.

Pending

2019-04-13T00:00:00.000

2026-10-02T00:00:00.000

5031

Reported Error

Agency not assigned yet.

I could not convert xml and Json file to shape file. I got this error message in Arcgis.
001558: Error parsing .json file <value>.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please be advised that Open Data team does not provide technical support for the third party products. You are encouraged to contact appropriate vendor's customer support to resolve this issue.

Thank you,
- NYC Open Data Team

Closed

2019-04-12T00:00:00.000

2026-10-02T00:00:00.000

5025

Reported Error

Agency not assigned yet.

Data ends in Oct 2018, would be great to have the remaining calendar year 2018. Also the columns are off by one starting with Latitude.

No URL Submitted.

Rooftop Drinking Water Tank Inspection Results dataset has been updated with most recent available 2019 water tank inspection data and column display error described in the request was fixed.

Thank you NYC Department of Health

Closed

2019-04-12T00:00:00.000

2026-10-02T00:00:00.000

5023

Data Question

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

I am a student at Columbia University. I am doing a research project on the Clean Heat Program. I am wondering if you can provide a documentation of this dataset. Also if there's additional data on this project that you can recommend.

NYC Clean Heat Dataset (Historical)

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

Response not sent yet.

Pending

2019-04-12T00:00:00.000

2026-10-02T00:00:00.000

5022

Reported Error

Agency not assigned yet.

The data is titled "2005 - 2015 Regents Exam Results" and described as "Regents results by School for all subjects, by year.", but the file appears to be the NYC graduation data by subgroup, not the Regents test data.

No URL Submitted.

hanks for alerting us. I'll have someone take a look and resolve.

Thank you,
- NYC Open Data Team

Closed

2019-04-11T00:00:00.000

2026-10-02T00:00:00.000

5020

Data Question

Agency not assigned yet.

As far as I know, the window for retail stores to apply for new Electronic Cigarette licenses is during he month of May. This data set says the cap for licenses is hit already. Will retail stores be able to apply for licenses during the 2019 application window?

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. ​At present there are no tobacco retail dealer or electronic cigarette retail dealer licenses available in any community districts. For more information about the community district caps please refer to the Information for Tobacco Retail Dealers page on the DCA website at https://www1.nyc.gov/site/dca/businesses/info-cigarette-retail-dealers.page If you have additional questions about the NYC Tobacco and Electronic Cigarette Caps, please contact DCA’s Business Compliance Counsel at https://www1.nyc.gov/site/dca/about/business-compliance-counsel.page
​
Thank you,
- NYC Department of Consumer Affairs

Closed

2019-04-11T00:00:00.000

2026-10-02T00:00:00.000

5019

Reported Error

Agency not assigned yet.

The latitude and longitude entries of the coordinates array in the lat_lon field response are flipped.

e.g. from https://data.cityofnewyork.us/resource/7x9x-zpz6.json?$where=within_circle(lat_lon,%2040.86815,%20-73.88683,%20500)&$limit=1 :

"lat_lon": {
"type": "Point",
"coordinates": [
-73.886835085,
40.865398905
]
},
"latitude": "40.86539890500006",
"longitude": "-73.88683508499997",

The name of the field, and the description of the Location type (https://dev.socrata.com/docs/datatypes/location.html#,), imply that longitude should appear first in the coordinates array.

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. For technical questions related to Socrata API functionality and discrepancies, please reach out to their support at https://support.socrata.com/hc/en-us

Thank you,
- NYC Open Data Team

Closed

2019-04-11T00:00:00.000

2026-10-02T00:00:00.000

5014

Data Question

Agency not assigned yet.

In the FAQ section, the link to the "dataset of datasets" is broken. If someone could please fix this, it would be most appreciated. I'm the data manager at IBO and would like this information for our users. Thanks!

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please be advised that this dataset is currently under review and is not available to public. As an alternative, please refer to the https://data.cityofnewyork.us/City-Government/Local-Law-251-of-2017-Published-Data-Asset-Invento/5tqd-u88y which provides much more detailed information about every official public asset hosted on the NYC Open Data portal.

Thank you,
- NYC Open Data Team

Closed

2019-04-10T00:00:00.000

2026-10-02T00:00:00.000

5007

Reported Error

New York City Police Department (NYPD)

Majority of variables under "Dimension" have entries like 'Other' or '(No Value)' - and the % share of those in a given dimension is really high (70-80%). This means majority of dimensional data can't be used to draw any meaningful insights.

Motor Vehicle Collisions - Crashes

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

​Thank you for contacting NYC Open Data Help Desk and reporting this issue. Please be advised that this is a known data quality issue related to the way the data is being entered/captured.
​
Thank you,
- NYPD

Closed

2019-04-09T00:00:00.000

2026-10-02T00:00:00.000

5004

Data Question

Department of Buildings (DOB)

https://data.cityofnewyork.us/Housing-Development/DOB-Job-Application-Filings/ic3t-wcy2/dataFor the property 886 Dekalb in Brooklyn, there is an open job :#321620705 that has a permit issued but is not closed out. Will the job be posed as closed out at some point? Thank you!

DOB Job Application Filings

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

Hi,

That's entirely up to the building owner and the applicant who submitted the job application. The permits were just issued in February, so the work can begin if it hasn't already. When the work is completed, the applicant will have to come back to DOB to finish the process.

You can see more details for this job on our Building Information System (BIS), and you can continue to monitor the status of the application on BIS or on Open Data.

Thank you,
- , DOB Open Data Coordinator

Closed

2019-04-09T00:00:00.000

2026-10-02T00:00:00.000

5003

Reported Error

Agency not assigned yet.

There are many records with the date "1899-11-30" for the date_desig column. It seems like this is what is used instead of missing values, or something is going wrong. This is also not just for landmarks that aren't yet designated. It seems like this problem only appeared in the most recent update to the dataset - the file I downloaded just a month ago didn't have this problem. Thanks for your help!

No URL Submitted.

Thank you for bringing this issue to our attention.

"1899-11-30" resulted from a data processing error that misinterpreted "<Null>" values.
We are working to resolve this as soon as possible, and aim to have it fixed within the next two weeks.

Sincerely,
-NYC Landmarks Commission

Closed

2019-04-09T00:00:00.000

2026-10-02T00:00:00.000

5000

Data Question

New York City Police Department (NYPD)

I am wondering if each line in this data set represents an individual arrest or an individual charge. For example, if a person were arrested for one count of drug possession and one count of resisting arrest, would that be one row in the data or two?

If each row represents an arrest, which offense is listed if there are multiple charges?

Thank you!

NYPD Arrest Data (Year to Date)

https://data.cityofnewyork.us/d/uip8-fykc

​Thank you for contacting NYC Open Data Help Desk. As per the NYPD_Arrest_Incident_Level_Data_Footnotes.pdf: "Arrests which involve multiple charges are classified according to the top charge".

Thank you,
- NYPD

Closed

2019-04-09T00:00:00.000

2026-10-02T00:00:00.000

4996

Data Question

Mayor's Office of Management and Budget (OMB)

What is the difference between adopted budget, current modified budget, and financial plan? Which is the most up to date number for what the city actually spent in a given FY?

Expense Budget

https://data.cityofnewyork.us/d/mwzb-yiwb

Thank you for contacting NYC Open Data Help Desk. ​

​​What is the difference between adopted budget, current modified budget, and financial plan?

After an Executive Budget has been released by the Mayor, it is reviewed and revised by the City Council. If approved by the Council, the budget becomes “adopted.” The Adopted Budget is then sent back to and released by the Mayor in June.

The current modified budget is the Adopted Budget as revised through modification and approval in accordance with the City Charter.

The financial plan is an adjustment of current year expenditures and revenue forecasts and a projection of how these adjustments will affect future budgets.
The financial plan is released four times a year - one in the fall/winter, the Preliminary in January, the Executive in April, and the Adopted Budget in June.

Which is the most up to date number for what the city actually spent in a given FY?

The City Comptroller publishes a Comprehensive Annual Financial Report which details annual spending for the City. This document is available on the City Comptroller’s website.


Thank you,
- NYC Office of Management and Budget

Closed

2019-04-08T00:00:00.000

2026-10-02T00:00:00.000

4974

Data Question

Agency not assigned yet.

I have a question please regarding Open Data City update time (https://opendata.cityofnewyork.us/).
Our app, Citiscape, allows tenants, construction and real estate professionals to access Complaints, Violations DOB/ECB, Job descriptions, Plan Examinations and other DOB info on their building including current work & stop work orders.

https://citiscapeapp.com/

We have found a data delay (obsolete data) of at least 48 hours in Open Data City of New York API and due to the nature of our services, we require that time to be dramatically lower in order to best serve the members of New York City.

One of the main purposes of the app is to keep construction sites safe and make construction professionals react immediately to the complaints of the public.

Any further assistance would very much appreciated.

Many thanks.

Regards,

No URL Submitted.

Hi,

Our press office forwarded your messages to me as well. Our current IT architecture has a daily update from the source to our data warehouse and then another daily update from the data warehouse to open data. This is why you are seeing a 48 hour delay. We do not have the capability to provide the data any faster at this time.

If you have additional questions, you can reach me directly at cnicklin@buildings.nyc.gov.

Thank you,
- , DOB Open Data Coordinator

Closed

2019-04-03T00:00:00.000

2026-10-02T00:00:00.000

4972

Data Question

Agency not assigned yet.

I'm looking at a data set on AP tests taken per school. A number of cells have the letter "s" in them instead of a number. What does that mean? Additionally, is 2012 the latest data set available with this information? I'm also interested in the number of AP classes offered per school (on a school level) and which AP classes those are. Is that possible to request also?

No URL Submitted.

An 'S' indicates that the value in that field is below the threshold that would allow us to report the number without the potential of the student(s) being identified. Any count below 9 is not reported and shows up as an 'S'.

With regards to your data request, unfortunately, we are unable to accommodate an individual request for data sets.

You may use the link below to make a request for the data.
https://infohub.nyced.org/reports-and-policies/research/doing-research-in-new-york-city-public-schools

Thank you,
- NYC Open Data Team

Closed

2019-04-03T00:00:00.000

2026-10-02T00:00:00.000

4965

Data Question

Department of Buildings (DOB)

I received your response and noticed that the query is returning violations today. However, I see exactly 1000 violations returned. That's a suspiciously round number. Is it possible there are more than 1000, but the response is truncated?
https://data.cityofnewyork.us/resource/dvnq-fhaa.json?violation_type_code=BENCH&$where=starts_with(issue_date,%272019%27)

DOB Violations

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

​Thank you for contacting NYC Open Data Help Desk. Please be advised that 1,000 rows is a default number of records that are generated by the API script. To increase the number of rows, please use the $limit parameter. For more information, please refer to https://dev.socrata.com/docs/queries/limit.html
For additional information or if you have followup questions regarding the Socrata API, please contact Socrata support at https://support.socrata.com/hc/en-us

Thank you,
- NYC Open Data Team

Closed

2019-04-09T00:00:00.000

2026-10-02T00:00:00.000

4962

Data Question

Department of Buildings (DOB)

Hi, will this dataset be updated soon? Several key violations were issued over the weekend.

DOB Violations

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

Hi,

This dataset is only updated on weekdays, and the update occurs in the afternoon. Additionally, there is a 1-day delay as the data is transferred through the various computer systems before it gets to open data. (I'm not sure if that delay is also based on weekdays or not.)

So my short summary is that the earliest you will see violations that were issued this weekend would be this evening. And they might not show up until tomorrow evening.

If you are looking for a specific violation, you can find that information faster in our Building Information System (BIS).

Thank you,
- , DOB Open Data Coordinator

Closed

2019-04-01T00:00:00.000

2026-10-02T00:00:00.000

4957

Data Question

Department of Citywide Administrative Services (DCAS)

About 12 years ago i took a NYPD officer exam. On this page i found my name and would like to have it removed i am not city employee, never worked for city of New York, did not pursue a career in Law Enforcement and do not reside in New York State.
Thank You

Civil Service List (Active)

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

Our records indicate that a person named [Name Redacted] took Exam No. 4312, Police Officer, in 2013, and earned a score of 106.47.

DCAS is required by law to publish the names of all persons who have passed civil service exams, and we cannot remove the names of any such persons from the public record.

Closed

2019-03-29T00:00:00.000

2026-10-02T00:00:00.000

4956

Data Question

311

How can i reduce the number of columns before downloading the data. I just want 20 columns of the 41 available in the 311 SR calls data set.

311 Service Requests from 2020 to Present

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

​Thank you for contacting NYC Open Data Help Desk. There are 2 ways in which you can delimit the number of columns you would like to export.
​
​1. If you have an account with Socrata and you logged in, you can create a derived view from a dataset or filtered view, save that derived view, and then hide columns through the column editor modal in grid view. After saving those changes in the view, the remaining data can be exported using the Export option in grid view. To signup for the account, please visit this URL: https://data.cityofnewyork.us/signup
​
​2. Without needing to create a derived view, a user can write a SoQL query from the SODA API endoint using a "Select" parameter to explicitly specify the desired columns. Please note that API defaults the limit to 1000, so you will need to set the limit to accommodate 311 dataset. After viewing the .json to verify that they you are getting the expected results from their query, you can change the end of the URL from .json to .csv in order to download those results as a CSV.
​
​For questions regarding API and other technical issue, please direct inquires to Socrata support at https://support.socrata.com/hc/en-us

Thank you,
- NYC Open Data Team

Closed

2019-03-28T00:00:00.000

2026-10-02T00:00:00.000

4949

Reported Error

Department of Health and Mental Hygiene (DOHMH)

The data set was last updated in september 2018, and contains records for only IDs issues in 2016 . Can this data set please be updated so that the records include items for 2017, 2018, and 2019?

NYC Dog Licensing Dataset

https://data.cityofnewyork.us/d/nu7n-tubp

https://data.cityofnewyork.us/Health/NYC-Dog-Licen...

The data set was last updated in september 2018, and contains records for only IDs issues in 2016 .
-----------------

Thank you for contacting NYC Open Data Help Desk. Please be advised that September 10, 2018 update is only applicable to the metadata changes - no actual data was updated at that time.

Thank you,
- NYC Open Data Team

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/ZPkmkF46Yg0E

Closed

2019-03-28T00:00:00.000

2026-10-02T00:00:00.000

4945

Data Question

Agency not assigned yet.

Hi there
I would like to inquire on how to get more up to date / frequent information from the DOB's API. We have been using the open data but it seems to have a small delay of 48hrs and i would like to know how to get the data more frequently than that.
Thanks in advance

No URL Submitted.

Hi,

We only provide bulk information through the open data portal. If you need to look up an individual record to get more current data, you can get that information through our Building Information System (BIS).

Thank you,
- , DOB Open Data Coordinator

Closed

2019-03-28T00:00:00.000

2026-10-02T00:00:00.000

4941

Data Question

New York City Police Department (NYPD)

This data set claims to have all crimes reported from 2006-2017 however why is the data on the years 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, and 2016 so scarce? Is there a more complete data set? Thanks

NYPD Complaint Data Historic

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

​Thank you for contacting NYC Open Data Help Desk. Please be advised that the Complaint data is consistent across all years averaging roughly half a million complaints per year. For example, using a Filter condition for CMPLNT_FR_DT is between 01/01/2016 and 12/31/2016 generated 477,639 records. For more information on how to utilize the Filter function, please refer to https://support.socrata.com/hc/en-us/sections/360000042047-Filtered-Datasets-and-Views

Thank you,
- NYC Open Data Team

Closed

2019-03-27T00:00:00.000

2026-10-02T00:00:00.000

4940

Data Question

Agency not assigned yet.

I've noticed that there are duplicates on this data set. I was thinking maybe it's because the program have different contracts or more than one inspection summary result but it's all the same information throughout the report. Is this an error or is there a reason for the duplicates?

No URL Submitted.

In both Child Care Connect and when referred to OATH individual citations are bundled as a single violation of each health code subsection for each inspection This dataset lists every individual citation of a violation for each inspection and does not bundle them. If a program received multiple violations during the same inspection, those will appear individually. More information about this dataset can be found in the Open Data Dictionary Child Care v4 20190227.xlsx available in the Attachment section.

Thank you,
Department of Health

Closed

2019-03-27T00:00:00.000

2026-10-02T00:00:00.000

4934

Data Question

Agency not assigned yet.

i am looking for Building identification Number associated with that address. How do we get it ?

No URL Submitted.

There are several ways you can find the Building Identification Number (BIN) from an address or BBL (borough/block/lot number).

The Department of City Planning (DCP) has a single record geo-coder called GOAT where you can enter an address or BBL and receive the BIN back. Change the search function to match your input; address = '1B' and BBL = 'BL'.

If you need to look up BINs in a batch format there are other options depending on your technical skills.
GeoSupport Desktop: https://www1.nyc.gov/site/planning/data-maps/open-...
GeoClient API: https://developer.cityofnewyork.us/api/geoclient-a...


Thank you,
- NYC DCP OpenData Team

Closed

2019-03-26T00:00:00.000

2026-10-02T00:00:00.000

4931

Data Question

Department of City Planning (DCP)

Would it be possible to get the Election Districts dataset (https://data.cityofnewyork.us/City-Government/Election-Districts/h2n3-98hq) broken down into boroughs downloadable as kml files? Could the dataset include options to only download, say, Brooklyn EDs? The filtering ability only allows it to be downloaded as xml which I can't use.

Election Districts

https://data.cityofnewyork.us/d/h2n3-98hq

The Department of City Planning (DCP) only maintains a Citywide file for election districts. Unfortunately there is not a Borough attribute at this time. You could download the NYC Borough Boundary (shoreline clipped) and spatially select the election districts by a Borough.

NYC Borough Boundary (shoreline clipped): https://data.cityofnewyork.us/City-Government/Boro...


DCP will consider your feedback and review if we can add a borough code to the attribute table to allow for better filtering in the future.

Thank you,
- NYC DCP Open Data Team

Closed

2019-03-29T00:00:00.000

2026-10-02T00:00:00.000

4923

Reported Error

Mayor's Office of Media and Entertainment (MOME)

it looks like this data stopped updating at the end of 2018. I am looking for a dataset that updates the permits data for filming. Thanks!

Film Permits

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that for public safety reasons, we do not include Project Title and delay posting by 3 months, a schedule which we agreed upon with City Council.


Thank you,
-NYC Mayor’s Office of Media and Entertainment

Closed

2019-03-23T00:00:00.000

2026-10-02T00:00:00.000

4919

Data Question

Agency not assigned yet.

Hi , I have got 87 out of 100 on Computer Specialist(Software)exam and want to know what is my cert. serial number and when I may get call and after how many person?

No URL Submitted.

Your name has been included in numerous certifications to the eligible list for Exam No. 7005, Computer Specialist (Software), but it is not possible to predict whether any given agency may call you for an interview.

Please log in to your OASys account for up-to-date information concerning exams you have taken.

Closed

2019-03-22T00:00:00.000

2026-10-02T00:00:00.000

4911

Data Question

Department of Finance (DOF)

in the definition of this data set it says " Summonses that have been written-off are indicated by blank financials." What is the criteria for writing off a summons and why is that criteria not noted on the individual records?

Open Parking and Camera Violations

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

​Thank you for contacting NYC Open Data Help Desk. Summonses in judgment status are written off 8 years from issue date.

​Thank you,
- NYC Department of Finance

Closed

2019-03-21T00:00:00.000

2026-10-02T00:00:00.000

4910

Data Question

Agency not assigned yet.

Good afternoon,
I want to know if my business still has open applications for department of buildings

No URL Submitted.

Hi,

You can search for your building in our DOB Job Application Filings and DOB NOW: Build – Job Application Filings datasets. Check out the Data Dictionary in the Attachments section on each dataset homepage for information about the different statuses.

Thank you,
- , DOB Open Data Coordinator

Closed

2019-03-21T00:00:00.000

2026-10-02T00:00:00.000