NYC Open Data Help Desk: Data Questions and Reported Errors

4102

Data Question

Department of Buildings (DOB)

Hi - I'm looking for an update on the *****. The address is around *****. Do you have an update on where this project is in the permitting process?

DOB Job Application Filings

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

Hi,

Since you're looking for a single address, your best bet is to look at our Building Information System (BIS). The page for 46-15 Kissena Boulevard shows all of the job applications and their statuses.

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

Closed

2018-10-05T00:00:00.000

2026-10-02T00:00:00.000

4096

Reported Error

Agency not assigned yet.

I am trying to use the open data sight however when you got to sort by date it does not sort correctly by date.

It is sorting by the day, instead of year. For example:

01/03/2018
01/03/2018
01/04/2017
01/04/2018
01/05/2016
01/05/2017
01/05/2018

and so on. Can someone please take a look and tell me if I am sorting incorrectly, or if the Open Data sight needs to be adjusted. Thank you.

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please note that the ​Issue Date column is a text type and sorts the records based on alphanumeric values rather than chronologically. The text data type was chosen for the column specifically to allow the records that contain date errors entered by the officers (such as April 31 and other illegal values) to be added to the dataset that otherwise would be omitted due to a data type mismatch. You are encouraged to utilize a filter feature using the underlying dataset https://data.cityofnewyork.us/City-Government/Open-Parking-and-Camera-Violations/nc67-uf89 to search for the records based on specified criteria. For more information on how to use this feature, please visit https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View
​
Thank you,
- NYC Open Data Team

Closed

2018-10-04T00:00:00.000

2026-10-02T00:00:00.000

4094

Data Question

Agency not assigned yet.

I am having trouble downloading subsets of this dataset; either I have to zoom out and download a huge chunk and or I have to zoom in too much and download seemingly haphazard bits of the data. Please advise -

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. You are encouraged to utilize Filter feature that would allow you to delimit the number of records based on your specified criteria. For more information on how to use this feature, please visit https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View
​
Thank you,
- NYC Open Data Team

Closed

2018-10-04T00:00:00.000

2026-10-02T00:00:00.000

4091

Reported Error

New York City Police Department (NYPD)

There are inconsistencies in the data.

For example, there are about 15 data samples in 2018 that have Borough = STATEN ISLAND, but contain a GPS reference outside Staten Island.

For example:

05/09/2018,16:00,STATEN ISLAND,10304,40.74262,-73.75683,"(40.74262, -73.75683)",,,260 PARK HILL AVENUE ,0,0,0,0,0,0,0,0,Unspecified,,,,,3897310,SPORT UTILITY / STATION WAGON,,,,,"14,506",3,16,26,69

40.74262,-73.75683
is
218th St. near 73rd Ave in
Oakland Gardens, Queens

There is a 206 Park Hill Ave,
in Park Hill, Staten Island.

The GPS reference of the incident is different than the street address of the incident.

How is that possible?
Which is correct?

I would have thought that would be checked during data entry. What edits are performed during data entry to ensure viable data is in the database?

Thank you.

Motor Vehicle Collisions - Crashes

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

​Thank you for contacting NYC Open Data Help Desk. ​We will take the suggestions and requests for additional QA/QC into consideration.
​
Thank you,
- New York City Police Department

Closed

2018-10-04T00:00:00.000

2026-10-02T00:00:00.000

4087

Reported Error

Office of Administrative Trials and Hearings (OATH)

The following records have different balance due when compared with OATH Ticket Finder:
***

OATH Hearings Division Case Status

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

https://data.cityofnewyork.us/City-Government/OATH-Hearings-Division-Case-Status/jz4z-kudi

Thank you for contacting NYC Open Data Help Desk. Please be advised that the OATH Hearings Division Case Status dataset was updated with the latest available information.

Thank you,
- NYC Open Data Team

Closed

2018-10-03T00:00:00.000

2026-10-02T00:00:00.000

4084

Data Question

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

Hello, I am wondering what is the reasoning for the very high regular gross earnings for the stationary engineers and senior stationary engineers at NYC DEP? The numbers don't match up with the individuals rates and the amount of regular hours worked. I'm assuming there was a lump sum payment for these individuals, Im just wondering what for, and why is it listed as regular pay? Any information is much appreciated. Thank you!

Citywide Payroll Data (Fiscal Year)

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

​Thank you for contacting NYC Open Data Help Desk. ​Please note that this was due to structured lump sum payments and a significant retro payment.
​
Thank you,
- New York City Office of Payroll Administration

Closed

2018-10-02T00:00:00.000

2026-10-02T00:00:00.000

4083

Data Question

Agency not assigned yet.

Is it possible to search jobs or permits by the name or license of a contractor?

No URL Submitted.

Hi,

Yes, you can search our data for the name and license of a contractor. You should note that for larger jobs where there are multiple licensed professionals, you might only find the main contractor listed.

For jobs, check out our DOB Job Application Filings and DOB NOW: Build – Job Application Filings. For permits, check out DOB Permit Issuance and DOB NOW: Build – Approved Permits.

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

Closed

2018-10-02T00:00:00.000

2026-10-02T00:00:00.000

4081

Data Question

Mayor's Office of Contract Services (MOCS)

The Small Purchase dataset from MOCS is supposed to be quarterly, but the data has not been updated since it was posted in April 2016. Please provide updated data.

Small Purchase Report

https://data.cityofnewyork.us/d/3ups-txji

Response not sent yet.

Pending

2018-10-02T00:00:00.000

2026-10-02T00:00:00.000

4078

Reported Error

Agency not assigned yet.

Not an error in the dataset, but an error in the dictionary: field 'NYCgov_Income' does not appear in the 2016 data dictionary.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk and reporting this discrepancy. We will reach out to the Mayor's Office for Economic Opportunity with a request to update their data dictionary.

​Thank you,
- NYC Open Data Team

Closed

2018-10-02T00:00:00.000

2026-10-02T00:00:00.000

4067

Data Question

Agency not assigned yet.

Hello, officer.

Thank you for offering this valuable data.

Let me introduce myself briefly.

I am ***, a PhD student at***.

I am working on my research related to park access for people with disabilities.

May I ask a question?

In your "Directory of Parks Disability Accessibility Facilities and Programs" data, What is the standards for defining accessible facilities for people with disability (like parks having ADA parking and ADA sidewalk)?

No URL Submitted.

Thank you for contacting NYC Parks regarding accessible facilities. I apologize for the delayed response. The criteria used for the facilities in the dataset are outlined on this page: https://www.nycgovparks.org/accessibility/accessib... Please let me know if you have additional questions.

Closed

2018-09-27T00:00:00.000

2026-10-02T00:00:00.000

4065

Reported Error

Agency not assigned yet.

NYPD's sectors have completely changed due to Neighborhood Coordinator Officer program but the old sector maps are still displayed. New maps that are interactive need to be provided. For example: Currently Sector A in the 50 Precinct is now the combination of Sectors A, D and K. The 50 Precinct only has Sectors A, B, C and NYCHA (Housing) now. Thank you.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please be advised that NYPD Sectors was updated on 9/28/2018 with the latest available information - https://data.cityofnewyork.us/Public-Safety/NYPD-Sectors/eizi-ujye/data

Thank you,
- NYC Open Data Team

Closed

2018-09-27T00:00:00.000

2026-10-02T00:00:00.000

4062

Data Question

Agency not assigned yet.

Can I find out whether a development is affordable housing from the dataset? Are filers required to offer whether the development receive any subsidy when they pre-file? Thanks!

No URL Submitted.

Hi,

We do not report on Affordable Housing in our data. There is a question on the general application, but the data is not suitable for release for a few reasons including that it's self-reported and that the definition is unclear. "Affordable Housing" means different things to different people. The most likely definition that you're looking for is the one governed by HPD and Local Law 44, so your best bet is to use their Housing Development Projects Receiving City Financial Assistance (Local Law 44) collection of datasets.

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

Closed

2018-09-27T00:00:00.000

2026-10-02T00:00:00.000

4061

Data Question

Agency not assigned yet.

I am writing with a question about your Regents data. I am looking for school-level data for 8th grade science from the 2018-19 school year. McGraw-Hill is interested in potentially hiring us to compare schools that used their science curriculum with those who did not in New York City in terms of their Regents scores.

It currently seems that data are available through the 2017-18 school year. Can you give me an approximate estimate for when 2018-19 data will be made available so that I can include those in an evaluation plan for McGraw-Hill?

Thank you for your time and consideration.

No URL Submitted.

Duplicate inquiry please see response #4031

Closed

2019-09-26T00:00:00.000

2026-10-02T00:00:00.000

4059

Reported Error

Office of Administrative Trials and Hearings (OATH)

*** DEP Violation Socrata showing $500 due, OATH Ticket Finder shows $0
*** FDNY Socrata showing Docketed and $375 due, OATH Ticket Finder showing $0 & paid in full
*** FDNY NOV OATH Ticket Finder shows $0/Socrata shows $5,000

OATH Hearings Division Case Status

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

https://data.cityofnewyork.us/City-Government/OATH-Hearings-Division-Case-Status/jz4z-kudi

Thank you for contacting NYC Open Data Help Desk. Please be advised that the OATH Hearings Division Case Status dataset was updated with the latest available information.

Thank you,
- NYC Open Data Team

Closed

2018-09-26T00:00:00.000

2026-10-02T00:00:00.000

4058

Data Question

Agency not assigned yet.

Hello, I am using your crime map data for research at ***. With the crime map, some dates don't include certain data, for example some months don't have the murder or rape factor. Does that mean the data for that month was 0 for murders, or is it just not entered into the system? An example of this could be seen in the crime map, for the 102nd precinct from October 1, 2017- October 31, 2017. The data on crime is as follows:
22 Burglaries
16 Felony Assaults
25 Grand Larcenies
25 Grand Larcenies of Motor Vehicles
1 Murders
15 Robberies

Since there are no rapes mentioned, does this mean there were 0 rapes for the month of October 2017?

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. If the crime category is not listed for the selected time period/precinct combination, this means that there were no crimes reported. In the above example, there were no rape crimes reported for the 102nd Precinct during the month of October 2017.

Thank you,
- New York City Police Department

Closed

2018-09-26T00:00:00.000

2026-10-02T00:00:00.000

4054

Reported Error

311

I'm trying to download 311 data from <https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/7ahn-ypff>.

When I click Export, the filter option is disabled. It will only allow me to download the whole dataset. The filter button is disabled/gray.

In the browser console, many instances of this error are reported:
include code 20a19e4c-47dd-4c4e-907f-d239033ebed3 if you report the error

311 Service Requests from 2020 to Present

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

Thank you for contacting NYC Open Data Help Desk. As per Socrata support response, this is currently the expected behavior for filtering on data lens assets—data that is filtered using a search card cannot be exported. However, data that is filtered using non-search cards in datalens will show the option to export the filtered results.

Thank you,
- NYC Open Data Help Desk

Closed

2018-09-26T00:00:00.000

2026-10-02T00:00:00.000

4051

Data Question

Department of Citywide Administrative Services (DCAS)

It looks that "export" option "CSV Excel" format doesn't work in the City Record Online dataset for bid solicitations and RFP (i cannot download the records selected by a filter).

City Record Online

https://data.cityofnewyork.us/d/dg92-zbpx

​Thank you for contacting NYC Open Data Help Desk. Please be advised that we did not experience and errors using a filter feature for https://data.cityofnewyork.us/City-Government/City-Record-Online/dg92-zbpx/data on our end. Would you be able to provide us with more details regarding this query? Alternatively, you are encouraged to reach out to Socrata support at
​https://support.socrata.com/hc/en-us if this issue is of technical nature.
​
Thank you,
- NYC Open Data Team

Closed

2018-09-24T00:00:00.000

2026-10-02T00:00:00.000

4040

Reported Error

Agency not assigned yet.

The numbers in the horizontal bar charts for Date would seem to be almost three times higher than from other sources.

Recreate:
1. NYC Open Data motor vehicle collisions:
https://data.cityofnewyork.us/Public-Safety/NYPD-Motor-Vehicle-Collisions/h9gi-nx95/data

2. Click Visualize > Launch Visualization and No Thanks for the sign in.

3. Select Date and the recommended horizontal bar chart.

4. A little awkward, so scroll down to Time Grouping (on the left) and click Group By Year.

The bar for 2017 shows 229,421 collisions. That sounds fantastically high.

If I then switch to the State Portal:
https://www.itsmr.org/TSSR/.
Click Crash Reports > NYC Crashes. I see about 82,286 collisions for 2017. (Which also seems unfortunately high.)

I always expect some disparity in statistics - different reporting styles, subtle differences in definitions, different time frames for inclusion, etc.

But, in this case, we appear to be off by a factor of almost three times! Similarly for preceding years. That piques my curiosity.

Problem is that I have no clue which numbers might be correct. Can you offer any advice? I expect that my City and my State should agree about some basic stats, at least within the same number of digits :-)

Thanks.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please note that NYS only tracks DMV reportable accidents (injuries, fatalities, damage of more than $1,000), while NYPD tracks all of the accidents.
Generally speaking, please exercise caution when comparing datasets from different organizations as they may not be using the same criteria.

Thank you,
- NYC Police Department

Closed

2018-09-19T00:00:00.000

2026-10-02T00:00:00.000

4038

Data Question

New York City Police Department (NYPD)

Hi, many records in this data-set (NYC collision data) don't contain the borough name. Is this collision is reported on another record? Or is this still a seperate unique collision which just has some information missing for whatever reason.
Thanks for your help.

Motor Vehicle Collisions - Crashes

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

​Thank you for contacting NYC Open Data Help Desk. Please note that each row/record is a unique collision. There may be inconsistencies in data collection for individual records.

Thank you,
- NYPD

Closed

2018-09-18T00:00:00.000

2026-10-02T00:00:00.000

4035

Reported Error

Agency not assigned yet.

The error is in the pie-chart visualization of the data; I do not know if the data, itself, is invalid.

To recreate error:
1. Visit NYC Open Data Vehicle Collision Data:
https://data.cityofnewyork.us/Public-Safety/NYPD-Motor-Vehicle-Collisions/h9gi-nx95/data
2. Click Visualize, then Launch New Visualization. (I then clicked No Thanks for the sign on).
3. Add filter on Date from 09/01/2018 to 09/14/2018.
4. Select Contributing Factor Vehicle 1.
5. Select Pie Chart.

It shows 51%, 8108 "Other"; 13%, 2130, "Distracted", etc.

Now, scroll to the bottom where it lists the table data; at bottom, it says:
Showing rows 1-18 out of 8,574

So, the table data indicates there are 8,574 records in my result set.
The pie chart shows over 10,000 records in the first two slices, alone!

That would appear to be a serious data presentation error.

The horizontal bar chart shows much more reasonable results.

Side Notes:
A. All charts should summarize the description of the chart, right above the chart - a title, if you like - of the form:
NYC Collision data - <filters, esp. the date range> - Total result set size: 8574 incidents
(it should be obvious when looking at a chart "Of What", and "How Many").

B. There should be a data key available to describe each value in each column, when there is an enumerated list. For example, what, exactly, is meant by "Unsafe Speed"? By "Passing or Lane Usage Improper"?

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. We have forwarded your inquiry to Socrata, and after further investigation they have identified a bug. The error is caused by the fact that all the records with no values in the Contributing Factor Vehicle 1 column are included in the visualization regardless whether these records fall between the dates specifies in the filter. Socrata created a ticket to fix this bug. Meantime, you are encouraged to exclude those records that have no corresponding value in the Contributing Factor Vehicle 1 column from your filter.

Thank you,
- NYC Open Data Team

Closed

2018-09-18T00:00:00.000

2026-10-02T00:00:00.000

4034

Data Question

Department of Citywide Administrative Services (DCAS)

I wanted to know about exam 7005 and my score. I sent in an appeal but I didnt get any response from DCAS. Is my score the current score that is posted for me or has DCAS scored my appeal? Thanks.

Civil Service List (Active)

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

You inquired about Exam 7005, Computer Associate (Software). The dataset on Open Data reflects your score on the established civil service list.

Once a determination is made on your appeal, you will receive a written notice in the mail, and if your score has been changed, you will also receive an amended Notice of Result.

Closed

2018-09-18T00:00:00.000

2026-10-02T00:00:00.000

4031

Data Question

Agency not assigned yet.

Can you provide me with a key to the column codes (i.e. Q7_2)? If there is a blank copy of the original survey that corresponds to these responses, that will suffice.

No URL Submitted.

Hi,

File uploaded

Thank you,
- NYC Department of Education

Closed

2018-09-17T00:00:00.000

2026-10-02T00:00:00.000

4028

Data Question

Agency not assigned yet.

Regarding this dataset (and most all others), on the export option what is the difference between "Shapefile" and "Original"?

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk.​ You are strongly advised to choose "Original" option in order to retain all the files provided by the original source. Certain files, such as XML documents and other information might be omitted if you specify "Shapefile" option, as in the case of the Individual Landmarks dataset. For more information, please contact Socrata support at
​https://support.socrata.com/hc/en-us

Thank you,
- NYC Open Data Team

Closed

2018-09-16T00:00:00.000

2026-10-02T00:00:00.000

4026

Reported Error

Agency not assigned yet.

Contact phone number should be*** rather than ***.

No URL Submitted.

Please submit any Green Book updates or revisions to:

amahoney@dcas.nyc.gov

Thank you,

Closed

2018-09-14T00:00:00.000

2026-10-02T00:00:00.000

4021

Data Question

Agency not assigned yet.

Hi! Do the emission factors include Transmissions and distribution losses and/or Well-To-Tank emissions (emissions from producing the fuels combusted in generators).

I have the same question for the district steam EFs: https://data.cityofnewyork.us/Environment/Inventory-of-New-York-City-Greenhouse-Gas-Emission/ismp-xffj

Best regards and thank you in advance

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. The electricity emission factors do not account for T&D losses and do not account for lifecycle emissions of fuel production upstream of combustion. The Mayor’s Office of Sustainability reports to the GPC Basic level, which does not include these emission sources.

Thank you,
- NYC Mayor's Office | Climate Policy and Programs

Closed

2018-09-14T00:00:00.000

2026-10-02T00:00:00.000

4017

Data Question

Agency not assigned yet.

What are the definitions of the "street code" columns (there are 3)?

I'm trying to determine GPS coordinates or how to map these rows.

For example, if
Street Code1 = 10,510
Street Code2 = 34,870
Street Code3 = 34,890

how should I use those above values to determine the location of the parking violation?

Thank you!

No URL Submitted.

The three data fields (Street Code1/Code2/Code3) are GIS coordinates of the location where the violation was issued and intersecting street boundaries. There is a data key attached to the data set. The data set reflects only parking tickets issued in NYC. The data is provided by NYC’s database of record for parking tickets.


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).

Regards,
NYC DOF

Closed

2018-09-13T00:00:00.000

2026-10-02T00:00:00.000

4015

Reported Error

City Council (NYCC)

Out of date. Please compare the attached data set from NYC Open Data with this updated list of NYC council members.

https://council.nyc.gov/districts/

Example: District 2
Current Council Member: ***. The NYC Open Data says ***.

City Council Members (1999 to Present)

https://data.cityofnewyork.us/d/uvw5-9znb

​Thank you for contacting NYC Open Data Help Desk. Please be advised that we are currently in the process of automating this, to provide a fuller and more regularly updated dataset.

Thank you,
- NYC City Council

Closed

2018-09-13T00:00:00.000

2026-10-02T00:00:00.000

4014

Data Question

Department of City Planning (DCP)

We're doing a project on voter turnout, and are wondering if these election districts change shape from one election to another, as we'd like to compare turnout from the 2014-2018 elections.

Election Districts

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

There was no redistricting of the election districts between 2014 and 2018 so they will be virtually identical. Generally, the election districts would only change after a Census update (2-3 years after, i.e. 2010 Census -> redistrict in 2012 or 2013).

The election districts are aligned with the City Street Centerline dataset so if there was a slight adjustment to the street centerline, the election district boundaries would reflect that adjustment.

We also make archived versions of the all of our district boundary files available here:
https://www1.nyc.gov/site/planning/data-maps/open-...
-Search for Election district - there are quarterly updates to the centerline file so you will see four versions of all the district boundary files available for each year (i.e. Election District for 2014 will have a 14A, 14B, 14C & 14D version available).

Thank you,
- Department of City Planning

Closed

2018-09-13T00:00:00.000

2026-10-02T00:00:00.000

4011

Data Question

Agency not assigned yet.

I got a 96 on the firefighter exam I wanted to know how I would find out that I made it to the next round?

No URL Submitted.

Agency representative directly contacted this user

Closed

2018-09-12T00:00:00.000

2026-10-02T00:00:00.000

4004

Data Question

311

i received a response from you (below) but i believe there was a typo in the original request -- I'm looking for 2018 311 complaint data for a specific zip code. My issue is that I'm unable to filter/visualize so that I can easily see what complaint type was most numerous for a particular zipcode (ex: 10280) from Jan 1, 2018 - present. Please advise. thank you.

311 Service Requests from 2020 to Present

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

You can enter the recommended visualization tool here: https://nycopendata.socrata.com/d/fhrw-4uyv/visual...

To isolate 2018 311 complaint data, I would filter "created date" from 1/1/2018 to 9/12/2018 using the filter button that will appear at the top left of the page. The second filter I would add is to select "incident zip" - "is" - "10280"

There about 369 complaints to date for that zip code area btw..

Please use this link for instructions on how to navigate the visualization canvas and customize filter etc https://support.socrata.com/hc/en-us/articles/115000813847-Creating-a-Visualization-in-the-New-Visualization-Canvas

Thank you,
- NYC Open Data Team

Closed

2018-09-12T00:00:00.000

2026-10-02T00:00:00.000

4003

Data Question

New York City Fire Department (FDNY)

This data runs from 2013-2017. Where can I find a comparable dataset for years as far back as 2000?

EMS Incident Dispatch Data

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

Thank you for your interest in the EMS Incident Dispatch dataset. This dataset is derived from our Computer Aided Dispatch system, which has over the years gone through significant changes. We are reviewing this dataset to determine which historical data is available for release to Open Data.

Closed

2018-09-11T00:00:00.000

2026-10-02T00:00:00.000

3996

Data Question

New York City Police Department (NYPD)

To whom it concerns,

I hope all is going well on your end. I am reaching out to you to see if there is any hate crime data at the city level in which the motivation would be oriented to nationality or legal status (i.e. immigrant)? I ask because I am working on several projects with my colleagues concerning hate crime and anti-immigrant hate crime, yet most major LEAs do not collect data on these types of motivations.

Is there anyway to dig into the incident particulars to see if EITHER such a motivation exists, or whether the victim was in fact a non-citizen/immigrant/etc.?

I am trying to essentially figure out a way to approximate for anti-immigrant hate crime in lieu of existing data; as many scholars will make the false assumption that anti-Arab, anti-Hispanic, or anti-Muslim hate crime is synonymous with anti-immigrant hate crime.

Any thoughts you can provide as to this inquiry would be greatly appreciated.

Best,

NYPD Complaint Data Historic

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

Thank you for contacting​ NYC Open Data Help Desk. Please refer to the Hate Crimes Reports, specifically the tables based on bias motivation.
​https://www1.nyc.gov/site/nypd/stats/reports-analysis/hate-crimes.page

​Thank you,
- NYC Police Department

Closed

2018-09-10T00:00:00.000

2026-10-02T00:00:00.000

3989

Data Question

Taxi and Limousine Commission (TLC)

Hi, can I request an alert via email whenever the data is updated?
Thanks!

FHV Base Aggregate Report

https://data.cityofnewyork.us/d/2v9c-2k7f

Thank you for contacting NYC Open Data Help Desk. In order to receive notifications, you will need to setup NYC Open Data account on Socrata. If you do not have an account, you can create one at https://data.cityofnewyork.us/signup
​
Please follow this link for a step-by-step guide on how to setup notifications on Socrata:
​https://support.socrata.com/hc/en-us/articles/115013178007-Notifications

Thank you,
- NYC Open Data Team

Closed

2018-09-07T00:00:00.000

2026-10-02T00:00:00.000

3987

Data Question

Agency not assigned yet.

We are looking for a 2013 Mercedes Benz Van, vin # ***, *** in color, N.Y. reg. # ***, Marked by your department on 7/27/18 by badge # *** at ***, N.Y. and marked under Voucher # ***. Did you remove it and what is the disposition of the vehicle ?

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please be advised that we did not receive your reply to our request for additional information (9/6/2018). We consider this issue resolved and will close this request. If you still need help with this request, please kindly contact us again with more detailed information and we would be happy to further assist you.
​
​Thank you,
- NYC Open Data Team

Closed

2018-09-06T00:00:00.000

2026-10-02T00:00:00.000

3986

Data Question

Agency not assigned yet.

Hi, I am working on a thesis project studying the economic effects of recycling in NYC. I would like to know if there is any way to access diversion and capture rates prior to 2016. Additionally, March through June numbers for 2018 seem to be missing. Is there a reason for that?

Thank you in advance!

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please note that March 2018 through June 2018 data is part of the Fiscal Year 2017.
​
​if you would like to request an agency to release historical data, please visit
​https://opendata.cityofnewyork.us/engage/ and in the How can we help you? field please choose "Request a dataset" option.
​
​Thank you,
- NYC Open Data Team

Closed

2018-09-06T00:00:00.000

2026-10-02T00:00:00.000

3984

Data Question

Agency not assigned yet.

,

Hello, my name is . I work with at UNHP and have been looking into the DOB Open Data as well.

We looked into aggregating on BIN and ran into some new questions for you. We looked up all associated BINs on DOB BIS and the combined number of violations across BINs does look correct. We noticed, however, that sometimes associated BINs corresponded to different BBL’s. We figured this must be due to merged tax lots; however, when we consulted Oasis the lots are still shown as separate. For example, when you look up the BBL 2031120025 on DOB BIS there are 2 BINs associated, 2013017 and 2013018. However, the BBL on the BIS page of second BIN is 2031120030. On the Oasis map it shows the lots as separate, but they do have the same owner. Similarly for the BBL 3003550036 there are 2 associated BINs, 3004928 and 3339575. When the Open Data DOB table is filtered for these bins 3 additional BBLs are associated, 3003550018, 3003550021, and 3003550030. On Oasis these lots are all shown as distinct except for 3003550021, which appears to have been merged with another lot. Only 3003550030 and 3003550018 have the same owner. We group our data based on BBL because we are interested in violation and registration data organized by the owner of the entire lot. So it’s concerning to us that in the above examples, we’re having trouble translating a total number of violations by BIN to that of BBL.

Is this issue part of the reason that you have suggested we filter the DOB & ECB Open Data by BIN? If so, do you have a sense of the frequency of the above issue, (i.e. when one BIN is associated with multiple BBLs when we search through the various data sources)? Thanks again for your patience in working with us on this – we don’t expect the DOB data to be perfect, but it helps to have a sense of the frequency of irregularities that we’re seeing when we try to group violation data by BBL.

I know this is a bit confusing to try and flush out over email. Would you be available to meet with us in person or talk over the phone?

Thanks again,

No URL Submitted.

Hi,

No problem. Happy to help.

For question 1, you're running into BBL vs BIN issues again. I really recommend that you look at our data by BIN because that's what we use as a key in all of our datasets. I did a quick check on the 3 BBLs that you provided for the ECB data and here's what I found:

• 1021230030: Missing ECB # 34076127J has a 0 block 0 lot on open data (data error), but the BIN matches the data in BIS
• 2031120025: I didn’t see any that were missing when comparing open data to BIS
• 3022640061: Missing ECB # 35274824Z has a lot of 7517 (lots that start with 7 indicate a condo apartment), but the BIN matches the data in BIS
For question 2, it's not duplication. ECB and DOB are two different types of violations. So when you see the same BIN in both datasets on the same date, it means that there were 2 violations issued that day. The 2 violations might be for the same issue, but they might carry separate fines and they get resolved differently.

Let me know if you have any other questions.
.........................................
Hi,

This is why we use BIN as our unique ID. BINs shouldn't ever change. In our violations data, we are reporting the BBL at the time of the violation. This dataset doesn't update if there's a lot split or merger down the road.

I think that explains everything that you're seeing. If you have any more questions, it might be best to have a phone conversation. You can reach me at 212-393-2772 or cnicklin@buildings.nyc.gov. Please don't share this widely as I would rather triage questions from outside the agency through the Open Data portal.

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

Closed

2018-09-06T00:00:00.000

2026-10-02T00:00:00.000

3976

Data Question

Agency not assigned yet.

I see items like INMATE_STATUS_CODE, but I don't see descriptions or definitions of the codes anywhere. Is this something that can be provided with the dataset? If it already exists, would you kindly point me to the right location? Thanks!

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Below is a list of expected values in the "Inmate Status Code" column:

CS= City Sentenced
CSP= City Sentenced - with VP Warrant
DE= Detainee
DEP= Detainee - with Open Case & VP Warrant
DNS= Detainee- Newly Sentenced to State Time
DPV= Detainee- Technical Parole Violator
SCO= State Prisoner- Court Order
SSR= State Ready

​You can also find these values in the data dictionary, that can be downloaded from this dataset's landing page on the NYC Open Data portal - https://data.cityofnewyork.us/Public-Safety/Daily-Inmates-In-Custody/7479-ugqb

Thank you,
-NYC Open Data

Closed

2018-09-03T00:00:00.000

2026-10-02T00:00:00.000

3975

Reported Error

Agency not assigned yet.

I know this isn't strictly under your purview, but I've noticed a few errors while processing the public traffic data on the NYPD website. Do you know who I should contact to fix about this?

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. You are encouraged to submit your questions through this help desk, or direct your inquiries to the NYPD at 646-610-5000 (General Inquiries) and https://www1.nyc.gov/site/nypd/about/about-nypd/email-the-commissioner.page

Thank you,
- NYC Open Data Team

Closed

2018-09-03T00:00:00.000

2026-10-02T00:00:00.000

3973

Data Question

Department of Buildings (DOB)

Date limitations? BIS has multiple C of O files for my building but none are in this dataset. The newest is from 1964 (BIN *****). Is that the issue? I also tried searching by block/lot and address. If there are date limitations, you need to edit the description of the dataset. Otherwise, advise what I might be doing wrong? Thanks for all your work.

DOB Certificate Of Occupancy

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

Hi,

Yes, the date is the reason that you're not finding your building in this dataset. I took your suggestion and updated the description to include a note that this dataset goes back to 7/12/12. Thanks for the feedback!

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

Closed

2018-08-31T00:00:00.000

2026-10-02T00:00:00.000

3972

Reported Error

Department of Finance (DOF)

Summons number *** in this dataset references a violation for a NJ vehicle with plate ***. However, this same summons number appears in Open Parking and Camera Violations (https://data.cityofnewyork.us/City-Government/Open-Parking-and-Camera-Violations/nc67-uf89/data) belonging to a CT vehicle with plate AA37715. The original summons for the NJ vehicle appears in this database (Open Parking and Camera Violations) with summons number *** with an identical issue_date. This is the first I've found, but I have another 156 summonses that appear to be duplicated across all the databases where at least one of the duplicate records is for an expired meter, so there may be many more.

Thank you for your help.

Parking Violations Issued - Fiscal Year 2016

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

Back in 2017 there were a number of violations issued with previously used violation numbers, this is not a normal occurrence. The earlier summonses that had been satisfied were removed from the database so that the later ones could be added.

Closed

2018-08-30T00:00:00.000

2026-10-02T00:00:00.000

3968

Data Question

Mayor's Office of Media and Entertainment (MOME)

Why is the latest set of data available from May 2018 if the data was supposedly updated yesterday?

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

2018-08-30T00:00:00.000

2026-10-02T00:00:00.000

3967

Data Question

Agency not assigned yet.

I am interested in exploring inmate admission patterns by inmate status. Unfortunately, I could not find any description on what each value of the inmate_status_code means (eg. DE, CS, SSR). Could you provide the value label for the data field inmate_status_code? Thanks so much!!!!

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please see below the list of expected values for the ​Inmate_Status_Code column:
​
​CS= City Sentenced
CSP= City Sentenced - with VP Warrant
DE= Detainee
DEP= Detainee - with Open Case & VP Warrant
DNS= Detainee- Newly Sentenced to State Time
DPV= Detainee- Technical Parole Violator
SCO= State Prisoner- Court Order
SSR= State Ready

We also included these values in the revised data dictionary, which you can download from the "Attachments" section from this dataset's landing page.
​
​Thank you,
- NYC Open Data Team

Closed

2018-08-29T00:00:00.000

2026-10-02T00:00:00.000

3965

Data Question

Agency not assigned yet.

To Whom It May Concern,

I would like to know when the retail prescription drug price data (https://apps.health.ny.gov/pdpw/SearchDrugs/Home.action) was last updated and if it would be possible to get access to the raw historical and current data on an excel spreadsheet or as a csv file. If you are unable to do this, do you know who I may be able to reach out to for this information?

Thank you for your time and help.

No URL Submitted.

The information you're looking for is not maintained by the agency. Please contact the New York State Department of Health.

Closed

2018-08-29T00:00:00.000

2026-10-02T00:00:00.000

3963

Data Question

Agency not assigned yet.

please send me 2018 permit information for construction at 123 E. 37th St. Apt. 12C and 12D Manhattan which shows the plan you have approved

No URL Submitted.

Hi,

You can find most of this information in our open data. The only problem is that we don't release Apartment # to open data. If you need that level of detail, you will have to manually check our Buildings Information System (BIS).

If you want the permit/application history for the entire building, you can get that on open data. You would need to search as follows:

Approved job applications in DOB Job Application Filings:
Filter by Bin # = 1019088 (You could filter by address, but you might miss some records because of differences in the way the data was entered, such as E. 37TH STREET vs EAST 37TH STREET)
Filter by Job Status Descrp. You want to see SIGNED OFF, PERMIT ISSUED - ENTIRE JOB/WORK, PLAN EXAM - APPROVED, PERMIT ISSUED - PARTIAL JOB, PLAN EXAM - PARTIAL APPROVAL, or COMPLETED.
Permits issued in DOB Permit Issuance:
Filter by Bin # = 1019088 (You could filter by address, but you might miss some records because of differences in the way the data was entered, such as E. 37TH STREET vs EAST 37TH STREET)
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/K9KxrXqs1KRB

Closed

2018-08-29T00:00:00.000

2026-10-02T00:00:00.000

3959

Reported Error

Department of Health and Mental Hygiene (DOHMH)

I wanted to report an encoding issue in some of the "violation descriptions". It appears to be with the degree character, and looks something like this: "Hot food item not held at or above 140º F."

DOHMH New York City Restaurant Inspection Results

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

Thank you for your submission. We will look into the matter.

Closed

2018-08-27T00:00:00.000

2026-10-02T00:00:00.000

3958

Data Question

Department of Health and Mental Hygiene (DOHMH)

Hi there! Thank you very much for providing and updating this dataset. I'm curious if when data is added if it's only forward in time. For example, if I fetch the dataset today, and then tomorrow ask for all new data that has an inspection date greater than the previous day, will I have missed any data? Said differently, is new data added retroactively? If so, how retroactive can the inspected_at dates be?

DOHMH New York City Restaurant Inspection Results

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

Thank you for your inquiry. This dataset is updated daily to account for new inspection data as well as changes to historic inspection data resulting from adjudication. The adjudication process typically takes 2 months or less. However, it can take longer and there is no time limit on how far back data can be updated if changes occur.

Closed

2018-08-27T00:00:00.000

2026-10-02T00:00:00.000

3948

Reported Error

Office of Administrative Trials and Hearings (OATH)

There is a massive subset of records in this dataset that are erroneous. I know this because I've been importing this dataset everyday for the past few years and I know how the data is supposed to appear. Yesterday there appeared tens of thousands of records with ticket number that are less than 10 characters. To see this for yourself, do a search where 'Violation Details = Batch insert' or 'Violation Details = document printed'. The viol #s are only 7 digits and most of the other field are blank.

OATH Hearings Division Case Status

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

​Thank you for contacting NYC Open Data Help Desk. Please note the following:
​
​1. The 10-digits tickets numbers are applicable only to the ECB violations. Ticket numbers appearing as alphanumeric strings or shorten values are summonses from other agencies (DCA, DOHMH, TLC).

2. “NOT NYC” in Borough column appears for all TLC summonses because NYCServ doesn’t have a borough field.

3. For TLC summonses Violation Details Column:
​a) Document Printed - the decision was not picked up by the respondent, it was printed and mailed to the address on file.
​b) Decision Printed - respondent signed out for the decision following the hearing.
​c) Batch Insert - summons was entered into NYCServ.

Please note that this dataset has recently undergone a major revision with additional summonses from DCA, DOHMH and TLC added. Agency is currently in the process of reviewing and correcting discrepancies.

Thank you,
- NYC Office of Administrative Trials and Hearings (OATH)
​-NYC Open Data team

Closed

2018-08-24T00:00:00.000

2026-10-02T00:00:00.000

3947

Data Question

Agency not assigned yet.

To whom it may concern:
In the high school directory dataset, is it possible to add other known high school identifier number; specifically the ceeb code and the NCES id? Please let me know if this request is feasible.
Thank you for providing all the wonderful data sets.

No URL Submitted.

Unfortunately, we do not maintain those codes in our Location Management Systems, so we would not be able to provide them

Thank you,
- NYC Open Data Team

Closed

2018-08-24T00:00:00.000

2026-10-02T00:00:00.000

3942

Data Question

Agency not assigned yet.

In addition and in context to below question, I have this question.
If I want to find all addresses and applications with PA certificate granted
, then which job status codes should be filtered and selected ? I am confused with similar codes like completed, signed off, appoved, permit.?
I am referring to job application filing table data.
Previous question asked as below. Just for your information.
How do I know based on data if the building or a structure is building of public assembly (Occupying more than 75 people) ? Which data set field has this information of maximum allowed occupancy for a customer / or entity.

No URL Submitted.

Hi,

I understand. You're looking for buildings that have been issued a Place of Assembly Certificate of Operation. This information is not currently available in open data. We will review your request to add this dataset. Place of Assembly certificates are applied for with a PA1 form, which is not currently in our open data. We do plan to add this to DOB NOW, our new online application system, and the data will be published at that time. Until then, if you need the data, please request it through our FOIL process.

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

Closed

2018-08-24T00:00:00.000

2026-10-02T00:00:00.000

3937

Data Question

Agency not assigned yet.

DOF – thank you for the response for dataset and the header information – however can you help with the questions? =

1) There is year in the dataset for 2009. Does the data contain information contain values for the most recent tax year?
2) I do not see the Owner Address – do you have that information?

Thank you.

No URL Submitted.

This file does not have the owner's address when it is different from the property address.
Property valuation and assessment data after 2009 can be found on the NYC Department of Finance website,
https://www1.nyc.gov/site/finance/taxes/property-assessments.page
Please look there for more current data while we update the files on the Open Data Portal.

Regards,
NYC DOF

Closed

2018-08-23T00:00:00.000

2026-10-02T00:00:00.000