NYC Open Data Help Desk: Data Questions and Reported Errors

2339

Data Question

Agency not assigned yet.

I am trying to figure out if this Noise Complaint is related to another noise complaint?

No URL Submitted.

Greetings,

Please kindly specify which particular dataset you are using for your query. For the 311 Service Requests from 2010 to Present dataset - https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9/data the unique key you have provided us has returned a taxi complaint dated 12/09/2010. If this is the right record, you can use Socrata filter feature to search the dataset for similar complaints using columns "Created Date", "Agency", "Complaint Type" and other criteria as your filter conditions.

For more information on how to fully utilize Socrata Filter feature, please refer to https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View

Hope this helps.
-NYC Open Data

Closed

2017-07-12T00:00:00.000

2026-10-02T00:00:00.000

2338

Data Question

Agency not assigned yet.

I'm doing some research on 311 data from Open Data. In the parking complaints dataset, I am really curious why there are so many "blocked fire hydrant" complaints - more than many other parking complaints. I would expect residents to complain more about things that affect their day-to-day life, like double parking, blocked driveways, etc. Any idea why the "blocked hydrant" complaints are so high...or who is complaining?? Thanks!!

No URL Submitted.

Greetings,

Unfortunately, NYC Open Data does not possess this specific information.

Best,
-NYC Open Data

Closed

2017-07-12T00:00:00.000

2026-10-02T00:00:00.000

2336

Data Question

Agency not assigned yet.

How can I get a breakdown of noise complaints filed against houses of worship specifically by neighborhood and by year in different parts of Manhattan and Brooklyn?

No URL Submitted.

Greetings,

We recommend to use Socrata Filter feature, which allows you to select a specific criteria for each of the columns in the 311 Service Requests from 2010 to Present dataset. For the Complaint Type, please select "Noise - House of Worship"; for the neighborhood, you can filter your results based on the Borough and Community Board. Each community board is associated with specific neighborhood(s). For the date, please use the Created Date is between filter to select the date range of your choice. For more information, please refer to Socrata help on filtering datasets:

https://support.socrata.com/hc/en-us/sections/200469748-Filtering-Datasets

Hope this helps.
-NYC Open Data

Closed

2017-07-12T00:00:00.000

2026-10-02T00:00:00.000

2334

Data Question

City Council (NYCC)

Hi there! Is there any other data that you could provide related to PB projects, specifically the name of the city agency who is implementing it, the project stage of completion, the time of project start to project finish (if project has been completed), or the actual cost (if the project has been completed)? If not, do you know if there is anywhere else I could access that data?

Participatory Budgeting Projects

https://data.cityofnewyork.us/d/wwhr-5ven

Thank you for contacting NYC Open Data Help Desk. The information you are looking for may be found here: https://data.cityofnewyork.us/City-Government/Participatory-Budgeting-Project-Tracker/qm5f-frjb
​
Thank you,
-NYC Open Data

Closed

2017-07-11T00:00:00.000

2026-10-02T00:00:00.000

2333

Data Question

New York City Police Department (NYPD)

Where is the 2016 data? I can find 2015 data and ytd 2017 but cant find 2016. I am looking for crimes w/lat long.

NYPD Complaint Data Historic

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

Greetings,

We recommend filtering NYPD Complaint Data Historic dataset https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Historic/qgea-i56i by selecting CMPLNT_FR_DT is after 12/31/2015 condition. This query should produce a list of 468K records for 2016 with corresponding latitude/longitude data.

For more information on how to fully utilize the Socrata filter feature, please refer to
https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View

Closed

2017-07-11T00:00:00.000

2026-10-02T00:00:00.000

1898

Data Question

Agency not assigned yet.

How was this page built? Is there source code available somewhere? What tools does it use? It's very cool!

No URL Submitted.

Greetings,

This dataset is utilizing Socrata's Data Lens feature. Please refer to Socrata documentation at https://support.socrata.com/hc/en-us/sections/200646116-Data-Lens
If you need more information, you are encouraged to contact Socrata customer service.

Hope this helps.
-NYC Open Data

Closed

2017-07-10T00:00:00.000

2026-10-02T00:00:00.000

1896

Data Question

Taxi and Limousine Commission (TLC)

For Hire Vehicles
I would like to look at data over time. 1. How do I look at data for inactive licenses?
2. How do I identify when a license number was first issued?

For Hire Vehicles (FHV) - Active

https://data.cityofnewyork.us/d/8wbx-tsch

Greetings,

1. Archived snapshots of active list over time could be compared to find drivers who are no longer active.
2. NYC Taxi and Limousine Commission does not have the information available for all licensees.

Best,
- NYC Open Data

Closed

2017-07-10T00:00:00.000

2026-10-02T00:00:00.000

1891

Reported Error

Agency not assigned yet.

This was a problem what was fixed and appear to be back. For Service Requests in Manhattan Community Boards greater than 9, they get geocoded to Manhattan Community Board 01. Previously, this issue was related to NYC 311 mobile app service requests. The NYC Open Data team said this issue was fixed.

No URL Submitted.

Hi,

Thank you for bringing this error to our attention. This issue is now resolved.

Best,
- NYC Open Data

Closed

2017-07-07T00:00:00.000

2026-10-02T00:00:00.000

1890

Data Question

Agency not assigned yet.

Hi there,
Does the map of phone booth locations include all phone booths in NYC?
Are these phone booths out of order, or are there still some that are functional?

No URL Submitted.

Hello, and thank you for reaching out. Yes, the map of phone booth locations includes all phone booths in NYC at the time the dataset was last updated.

Best,
- NYC Open Data

Closed

2017-07-07T00:00:00.000

2026-10-02T00:00:00.000

1888

Data Question

Agency not assigned yet.

According to the about section "Previously posted versions of the data are retained to comply with Local Law 106 of 2015 and can be provided upon request made to Open Data." Would it be possible to get the June 2014, June 2015, and June 2016 versions. Thanks!

No URL Submitted.

Two older versions of the https://data.cityofnewyork.us/City-Government/NYC-Street-Centerline-CSCL-/exjm-f27b are now available for download in the Attachments section (dated 06/26/2016 and 05/04/2016).

Hope this helps.
-NYC Open Data

Closed

2017-07-06T00:00:00.000

2026-10-02T00:00:00.000

1886

Data Question

Department of Buildings (DOB)

Does the building permit application dataset include permits for hoists? If so, how are they coded? If not, where can I find permits for hoists?

DOB Job Application Filings

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

We have just updated the way we handle open data customer service, and your question from June was forwarded to me.

You are trying to find permits for hoists. This isn't something that we regularly report on, so it's not a simple thing. Here's how you can do it:

First, look for the job applications that include hoist equipment in our DOB Job Application Filings dataset by filtering the Job Description field for "hoist". This field is typed in by the applicant and there is no standardization, so you may want to make your filter narrower by specifying a type of hoist, but you might be excluding jobs where they didn't specify the type, so you'll have to play with this filter until you are satisfied with the results.
Use the Job # field from your filtered dataset in step 1 and cross reference with the DOB Permit Issuance dataset. Note: In the permit dataset, you may get several permits for a single Job #. You should look at the Work Type and Permit Type fields to narrow down to the exact permit that you want. For example, the entire alteration job might include both hoist equipment and scaffolds, and you don't want the SF (Scaffold) Permit Subtype.
That should get you to the report that you are looking for. If you have any additional questions, please let me know.

Closed

2017-07-06T00:00:00.000

2026-10-02T00:00:00.000

1885

Reported Error

Department of Health and Mental Hygiene (DOHMH)

There's a bug in your OData services: there's always an __id field in the data structure, but if I use this field as part of a $select clause, I get an error saying that field doesn't exist.

The OData service is exposing a schema that you cannot query on, as the requests will fail when you use all the fields of the service (including __id), which is the recommended way to work from the OData client perspective.

DOHMH New York City Restaurant Inspection Results

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

Greetings,

The Odata issue has been resolved. Using the new Odata v4 endpoint (Access Socrata Data using Odata) you should now be able to query on the __id field within Odata.

Best,
- NYC Open Data

Closed

2017-07-06T00:00:00.000

2026-10-02T00:00:00.000

1884

Reported Error

Agency not assigned yet.

The column labeled "Income Group" contains date values.

No URL Submitted.

Greetings,

The information you are looking for can be found here: https://data.cityofnewyork.us/City-Government/Personal-Income-By-AGI-Range/ipc3-2nbm
"Income Group" column contains values for each of the 10 groups that are equal in size.

Hope this helps.
-NYC Open Data

Closed

2017-07-06T00:00:00.000

2026-10-02T00:00:00.000

1883

Data Question

Department of Transportation (DOT)

What is the logic for the sign codes in the signs.csv file (eg PS-65C, SP-477B, etc)? Do you have a guide/legend to help decipher what Sign Description the codes represent?

Parking Regulation Locations and Signs

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

Greetings,

The sign code is a unique identifier for a sign design, and it generally has one sign description. As an example, SP-477B sign description is “BUS STOP SIGN (BUS & HANDICAP SYMBOLS) NO STANDING W/ SINGLE ARROW”. DOT does not maintain a separate guide/legend of sign codes. Excel pivot tables or other software can summarize the list of codes and their descriptions, if desired.

For most signs, all sign instances with the same sign code are physically the same. However, there are several exceptions where sign text can vary. “SPECIAL,” “INSERT” AND “RIDER” are examples of such codes. “SPECIAL” signs are often used for events, or for ceremonial street renaming, and “INSERT” AND “RIDER” are used for signs that appear on or below other signs. These generic codes have fallen out of use at DOT, but the data still contains examples.

DOT also uses generic sign codes for Bus Stop route, destination and locator panels, for some speed limit signs, and in several other cases. These sign codes have descriptions that indicate there is a variable element to the sign. An example would be the bus stop route sign, with the description “LOCAL MTA BUS ROUTE PANEL (TEXT TO BE MODIFIED AS REQUESTED)” or a speed limit sign, with the description “SPEED LIMIT XX SPEED CHECKED BY RADAR (XX = SPEED TO BE DETERMINED).”


Thank you,
-NYC Department of Transportation

Closed

2017-07-05T00:00:00.000

2026-10-02T00:00:00.000

1881

Data Question

Agency not assigned yet.

Greetings...I have a few questions I was hoping you could help me with:

(1) If CASE_DECISION_DATE == "NULL", can I assume that the restaurant chose to settle the fine rather than adjudicate? (And, if it has a date, can I assume that the restaurant chose to challenge the score assigned?)

(2) Can you help me understand the following ACTIONCODEs:

(a) ACTIONCODE == "C" --- The description is that "Previously cited violations corrected and no new violations cited". However, this code is sometimes associated with scores > 0. Can you help me understand why? (Also, this is the action code for which A-grade restaurants appear to adjudicate, i.e., CASE_DECISION_DATE != "NULL".)

(b) ACTIONCODE == "D" --- The description is "Padlocked". I assume this is different than closed (ACTIONCODE == "G"). This is a fairly frequent code. Can you help me understand what it means?

(3) If a restaurant receives 14+ points and must undergo a re-inspection for the inspection cycle, will the restaurant be fined for violations in both the initial and re-inspection? And, if so, can both be adjudicated?

(4) Is the health inspector required to appear at the OATH hearing?

Many thanks in advance for your help!

Of course, if it is easier to discuss on the phone, please let me know.

No URL Submitted.

Greetings,

Unfortunately, http://www1.nyc.gov/site/doh/services/restaurant-grades.page is not a part of the NYC Open Data. It is maintained by the Health Department. We encourage you to contact the Health Department at http://www.nyc.gov/html/mail/html/maildoh.html

Hope this helps.
-NYC Open Data

Closed

2017-07-05T00:00:00.000

2026-10-02T00:00:00.000

1877

Data Question

Agency not assigned yet.

What does tree_dbh measure? I do not understand the units. Also, the data does not seem to match published facts about NYC street trees. This page on the tree count (https://www.nycgovparks.org/trees/treescount), for example, says that the largest tree in the city is in Queens, but according to the data, the largest tree is in the Bronx:

trees = pd.read_csv("2015_Street_Tree_Census_-_Tree_Data.csv", index_col="tree_id”)
for n, g in trees.groupby("boroname"):
print(n, g.tree_dbh.max())

yields:

Bronx 450
Brooklyn 425
Manhattan 318
Queens 389
Staten Island 298

Thanks for your help.

No URL Submitted.

According to this dataset's Data Dictionary, "tree_dbh" represents the diameter of the tree, measured at approximately 54" / 137cm above the ground. Because standard measuring tapes are more accessible than forestry-specific measuring tapes designed to measure diameter, users originally measured tree circumference in the field. To better match other forestry datasets, this circumference value was subsequently divided by 3.14159 to transform it to diameter. Both the field measurement and processed value were rounded to the nearest whole inch.
Regarding the discrepancy between the dataset on the Open Data and the data provided on the Department of Parks and Recreation website, please contact the agency for further clarification at http://www.nyc.gov/html/mail/html/maildpr.html.


Hope this helps.
-NYC Open Data

Closed

2017-07-05T00:00:00.000

2026-10-02T00:00:00.000

1875

Data Question

Taxi and Limousine Commission (TLC)

***
I passed my exam yesterday with a score of 85%. your Dataset does not reflect this. when will i be able to see the update?

TLC New Driver Application Status

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

The dataset was updated on 6/30/2017 with the latest information.

Hope this helps.
-NYC Open Data

Closed

2017-06-30T00:00:00.000

2026-10-02T00:00:00.000

1867

Data Question

Agency not assigned yet.

I was wondering what program is in use to display the current dashboard. I currently work for Texas Highway Patrol's Highway Safety Operation Center and we are actively looking for better ways to display crash data. Thank you for your time.

No URL Submitted.

Greetings,

Unfortunately, NYPD TrafficStat dashboard is not a part of NYC Open Data. The website https://trafficstat.nypdonline.org/2e5c3f4b-85c1-4635-83c6-22b27fe7c75c/view/89 is maintained by the NYPD, and we encourage you to directly contact the Police Department for more information.

Hope this helps.
-NYC Open Data

Closed

2017-06-27T00:00:00.000

2026-10-02T00:00:00.000

1865

Reported Error

Agency not assigned yet.

The latitude and longitude for many of the schools are incorrect. An example, a school has correct lat/longs for school year 2015-16, but for 2016-17 has a different lat/long but the address is the same for both years. In addition, the BEDS Number column, values are incorrect. It should be unique for each school. For example, PS 167 The Parkway and PS 174 Dumont both have BEDS # 33200000000.

No URL Submitted.

Greetings,

Thank you for your request. This file seems to have been corrupted. File will be deleted and replaced by 09/30/2017.

Best,
- Department of Education (DOE)
- NYC Open Data

Closed

2017-06-27T00:00:00.000

2026-10-02T00:00:00.000

1846

Data Question

Taxi and Limousine Commission (TLC)

I'd like to create an automated feed of this data set that gets imported into a Google sheet for me to track new applications. In my current system I have to manually export the data set and then manually import it into my google sheet. is there an existing feature where I can created a timed import (e.g. 3 times/week)?

TLC New Driver Application Status

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

Greetings,

For programming/technical related questions please contact Socrata support:
https://support.socrata.com/hc/en-us


Hope this helps.
-NYC Open Data Team

Closed

2017-06-21T00:00:00.000

2026-10-02T00:00:00.000

1844

Data Question

Department of Citywide Administrative Services (DCAS)

What does the ROW # tell you about the List? Why are the list #s not in ascending order? What determines one's placement at the top of the list Row 1, versus the last Row?

Civil Service List (Active)

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

Greetings,

The positions of the records within the list are determined strictly by various technical-related criteria. You are encouraged to use "Sort" and "Filter" features of the Socrata to query your results.

Best,
- NYC Open Data

Closed

2017-06-21T00:00:00.000

2026-10-02T00:00:00.000

1843

Data Question

Department of Citywide Administrative Services (DCAS)

Why is list # 38 on the top and #58 on the bottom? What determines the order of the list #'s from top to bottom?

Civil Service List (Active)

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

Greetings,

The positions of the records within the list are determined strictly by various technical-related criteria. You are encouraged to use "Sort" and "Filter" features of the Socrata to query your results.

Best,
- NYC Open Data

Closed

2017-06-21T00:00:00.000

2026-10-02T00:00:00.000

1838

Reported Error

Department of Buildings (DOB)

The Job Status and Job Status Descrp columns are all wrong. These are dynamic fields that conclude at X (sign-off). If this field is inaccurate, dataset cannot be relied upon. I find that it is about 75% inaccurate.

DOB Job Application Filings

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

Greetings,

We appreciate your input. The Department of Buildings is working on improvements for this dataset.
- NYC Open Data

Closed

2017-06-20T00:00:00.000

2026-10-02T00:00:00.000

1837

Reported Error

Department of Buildings (DOB)

I have been exploring the newly posted DOB data-set labels "DOB License Info". Specifically for Electrical Contractor and Electrical firms: I thought that the dataset was just missing some address data but as i delve into the data I see that there are so many errors as to make the dataset useless.. I have been checking individual lines of companies that I am already familiar with and using the existing DOB online lookup serve to confirm the information. Almost every line I checked was incorrect. The DOB lookup service is correct but the Dataset does not match the known information coming from their own website.. Please get the DOB to provide an accurate and complete data-set. If you check, I have been requesting this since the NYC opendata website went live.

DOB License Info

https://data.cityofnewyork.us/d/t8hj-ruu2

Thank you for contacting us with regard to incomplete/incorrect information. The dataset in question is still in its initial phase of development and a new dataset with automated updates will be released in a near future. We will forward your request to DOB to update the existing dataset.

Best,

NYC OpenData Team

Closed

2017-06-20T00:00:00.000

2026-10-02T00:00:00.000

1834

Data Question

New York City Police Department (NYPD)

I'm studying the ***, and I have question in the vehicle collision dataset.
There is "driver inexperience" as one of the contributing factors.
Does it include "unlicensed driving"?
If not, where does the unlicensed driving belong?

Motor Vehicle Collisions - Crashes

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

Driver Inexperience is number 5 on the list of Apparent Contributing Factors of the PAR there are a list of 58 different factors. The three general categories are Human, Vehicular and Environmental. Unlicensed driving is not on the list. An unlicensed driver is issued a summons and it is captured in the Ticket/Arrest Number(s) field.

Closed

2017-06-20T00:00:00.000

2026-10-02T00:00:00.000

1833

Data Question

Agency not assigned yet.

how can i search for FDNY violations on a specific BBL or address?
Thank you very much for your help.

No URL Submitted.

hello,
how can i search for FDNY violations on a specific BBL or address?
Thank you very much for your help.
-----

Greetings,

Please refer to OATH Hearings Division Case Status dataset - https://data.cityofnewyork.us/City-Government/OATH-Hearings-Division-Case-Status/jz4z-kudi
Within the dataset, please lick on the "Filter" button and select the following condition:
Issuing Agency is "Fire Department of NYC"
You can add additional conditions to this filter to select a specific address of your choice. Unfortunately, this dataset does not have a BBL field at this time.

Hope this helps.
-NYC Open Data

Closed

2017-06-19T00:00:00.000

2026-10-02T00:00:00.000

1832

Data Question

Agency not assigned yet.

I was wondering, of all of the inspection types, what is the first type of inspection that a restaurant would receive upon opening? I hope to use one of the "inspectiontype" values as a proxy for restaurant entry and you help would be greatly appreciated! Thus, is this pre-permit or cycle inspection, and if so which sub-case specifically?

No URL Submitted.

Greetings,

Thank you for your request. Inspection type values are outlined in the data dictionary. Please refer to the data dictionary for a detailed description.

- Department of Health and Mental Hygiene (DOHMH)

Closed

2017-06-19T00:00:00.000

2026-10-02T00:00:00.000

1827

Reported Error

Department of Sanitation (DSNY)

Dataset shows X any Y coordinates but does not have link to corresponding shapefile. Where to get shapefile?

DSNY Graffiti Tracking

At the moment, the DSNY Graffiti Information is available only in a tabular form.

Best,

NYC OpenData Team

Closed

2017-06-18T00:00:00.000

2026-10-02T00:00:00.000

1823

Reported Error

Agency not assigned yet.

I need you to take me out as the Provider. This is a corporation. There is not one single provider.

No URL Submitted.

Please contact the New York State Office of Children and Family Services for further assistance.

Best,

NYC OpenData Team

Closed

2017-06-16T00:00:00.000

2026-10-02T00:00:00.000

1822

Data Question

Department of Health and Mental Hygiene (DOHMH)

Hi, I am not sure if this is the right place to be asking this. NYC birth index is public information. It used to be on loan to the *** Library. Its been removed. Can someone tell me if its viewable somewhere else since its supposed to be public information available. Thank you for your hard work and all you do.

DOHMH New York City Restaurant Inspection Results

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

Greetings,

Thank you for contacting NYC Open Data Team. For the NYC Birth Index information, you are encouraged to contact New York City Department of Records; and the New York Public Library at https://www.nypl.org/help/about-nypl/administration/contact-list

Best,
- NYC Open Data

Closed

2017-06-15T00:00:00.000

2026-10-02T00:00:00.000

1821

Data Question

Agency not assigned yet.

TLC Vehicle insurance.
Is data updated?
Can we get updated data via API

No URL Submitted.

This dataset was not updated since last year. There is a new dataset is in the process of development and should be released to public in a near future. For a specific information regarding TLC vehicle insurance, please direct your inquiry to http://www.nyc.gov/html/tlc/html/industry/vehicle_insurance_info.shtml

Best,

NYC OpenData Team

Closed

2017-06-15T00:00:00.000

2026-10-02T00:00:00.000

1392

Data Question

Agency not assigned yet.

Please advise on why the DOB website section: Data and Reporting the Complaint Disposition Reports have not been update since April. Still no update.....kindly advise…

No URL Submitted.

Please refer to the https://data.cityofnewyork.us/Housing-Development/DOB-Complaints-Received/eabe-havv/data for the updated Data and Reporting the Complaint Disposition Reports.

Best,

NYC OpenData Team.

Closed

2017-06-15T00:00:00.000

2026-10-02T00:00:00.000

1391

Reported Error

Department of Buildings (DOB)

This is a new data-set and it is missing some information. Specifically, the address information for the "Electrical Firms" is incomplete. you have the street number but the column for "street" contains no data

DOB License Info

https://data.cityofnewyork.us/d/t8hj-ruu2

This is a new data set that is still in the initial phase of development. Your request for an omitted address information will be taken under consideration.
You are also encouraged to contact the Department of Buildings at http://www1.nyc.gov/site/buildings/about/contact-us.page for more information.

Best,

NYC OpenData Team

Closed

2017-06-15T00:00:00.000

2026-10-02T00:00:00.000

1390

Data Question

New York City Police Department (NYPD)

I have been tracking crashes in CB7 for the past few years. I noticed that both crashes and injuries are dramatically lower in 2017 than in previous years. Is this due to a change in reporting procedure or have crashes and injuries dropped this significantly year over year?

Motor Vehicle Collisions - Crashes

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

Hi ,

Since it is the NYPD that determines exactly how its data is being collected and reported, we encourage you to contact this agency directly at http://www.nyc.gov/html/mail/html/mailnypd.html for more information and clarification.

Best,

NYC OpenData Team

Closed

2017-06-14T00:00:00.000

2026-10-02T00:00:00.000

1387

Data Question

Department of Buildings (DOB)

how frequently is this file actually updated since today is june 13th and the most recent reported violation is from may 17th! nearly a month old

DOB ECB Violations

https://data.cityofnewyork.us/d/6bgk-3dad

The NYC OpenData updates the DOB ECB Violations dataset on a weekdays basis. The actual data is provided by the Department of Buildings, which determines the frequency of records' release. For more information, please contact the Department of Buildings: http://www1.nyc.gov/site/buildings/about/contact-us.page

Best,

NYC OpenData Team

Closed

2017-06-14T00:00:00.000

2026-10-02T00:00:00.000

1383

Data Question

Taxi and Limousine Commission (TLC)

When will the database be updated for Taxi Improvement Fund (TIF) Medallion Payments

Taxi Improvement Fund (TIF) Medallion Payments

https://data.cityofnewyork.us/d/ht4t-wzcm

Taxi Improvement Fund (TIF) Medallion Payments dataset is now updated to reflect the latest information:
https://data.cityofnewyork.us/Transportation/Taxi-Improvement-Fund-TIF-Medallion-Payments/ht4t-wzcm/data


Best,

-NYC Open Data

Closed

2017-06-13T00:00:00.000

2026-10-02T00:00:00.000

1381

Data Question

Department of Buildings (DOB)

Can you advise as to when this dataset will be updated. Typically, it's updated every day but it hasn't been updated since June 8thl .

DOB Violations

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

Thank you for bringing it to our attention. This dataset is updated to reflect the latest information.
https://data.cityofnewyork.us/Housing-Development/DOB-Violations/3h2n-5cm9/data


Best,


NYC OpenData Team

Closed

2017-06-13T00:00:00.000

2026-10-02T00:00:00.000

1377

Data Question

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

I would like to find out why the citywide payroll data (fiscal year) for all the District Attorney's Office's with the exception of *** have no published payroll data for the *** or any supervisory individuals within that division? I work for the *** but the only published information is my last salary for another city agency.

Citywide Payroll Data (Fiscal Year)

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

Greetings,

Thank you for reaching out. Please consult with the respective DA offices regarding those titles that deemed privileged and subject to redaction for a response to this inquiry.

Best,
- Office of Payroll Administration (OPA)

Closed

2017-06-10T00:00:00.000

2026-10-02T00:00:00.000

1369

Reported Error

Agency not assigned yet.

I'm looking for a current list of public litter and recycling receptacle locations throughout NYC's five boroughs. Currently, the data set available at https://data.cityofnewyork.us/Environment/Litter-Basket-Inventory/es7t-6u8y has latitude and longitude coordinates that do not exist on a map.

No URL Submitted.

Greetings,

Thank you so much for this information. We have corrected this error and updated the Litter Basket Inventory dataset.

https://data.cityofnewyork.us/Environment/Litter-Basket-Inventory/es7t-6u8y

Best,

NYC OpenData Team

Closed

2017-06-08T00:00:00.000

2026-10-02T00:00:00.000

1368

Data Question

Agency not assigned yet.

In reference to ***
I requested to contest this citation and am not sure of the status? Do I wait until the judgement hearing? I'm not local so am not able to appear in person

No URL Submitted.

Greetings,

Please refer to OATH Hearings Division Case Status dataset for an updated status of your case. If you need more information regarding your case, please contact the OATH Hearings Division at http://www1.nyc.gov/site/oath/about/contact-the-help-center.page


Thank you,
-NYC Open Data

Closed

2017-06-07T00:00:00.000

2026-10-02T00:00:00.000

1365

Data Question

New York City Police Department (NYPD)

Hi there, I'm trying to filter this dataset properly so that I only get data related to a certain type of crime, criminal weapon possession. Is there a master list somewhere of all of the possible three-digit offense codes? I figured out one (118, for "dangerous weapons") but I am not sure if this quite covers what I'm looking for. Any tips? Thank you!

NYPD Complaint Data Historic

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

Please refer to PDCode_PenalLaw.xlsx found in the Attachments section

Closed

2017-06-07T00:00:00.000

2026-10-02T00:00:00.000

1364

Data Question

Agency not assigned yet.

How would I query the street censuses to see species composition by size classes by neighborhood & at overall city scale?
Thank you.

No URL Submitted.

Greetings,

We recommend to utilize Socrata Filter feature to produce more specific search results based on your desired criteria. For example, for the 2015 Street Tree Census - Tree Data dataset
https://data.cityofnewyork.us/Environment/2015-Street-Tree-Census-Tree-Data/uvpi-gqnh
you can use the column "nta_name" as one of your filter conditions to delimit your query result to a single New York neighborhood.

For more detailed information on how to fully utilize Socrata Filter feature, please refer to
https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View

Hope this helps.
-NYC Open Data

Closed

2017-06-07T00:00:00.000

2026-10-02T00:00:00.000

1363

Data Question

Agency not assigned yet.

I am trying to find where you receive the data that is used to populate the Taxable Sales Revenue Map that appears on the NYC Business Atlas page, here: https://maps.nyc.gov/businessatlas/?
I am trying to find the source for these figures. Kindly let me know when you have a moment. I appreciate your time and attention in this matter. Have a great day.

No URL Submitted.

Greetings,
Though SBS provides support to the Business Atlas, it is operated by the Mayor's Office of Data Analytics (MODA).

- NYC Open Data

Closed

2017-06-07T00:00:00.000

2026-10-02T00:00:00.000

1362

Data Question

Agency not assigned yet.

Hello! I'm trying to find out which houses issues permits for a roof replacement. I've determined that that would likely be Permit Type A1, and have filtered by residential buildings only, but is there a way beyond this to narrow to specifically a roof replacement?

No URL Submitted.

We have just updated the way we handle open data customer service, and your question from June was forwarded to me.

You are trying to find permits for roof replacement. This isn't something that we regularly report on, so it's not a simple thing. Here's how you can do it:

First, look for the job applications that include roof replacement work in our DOB Job Application Filings dataset by filtering the Job Description field for "roof". From what I can see, these are usually Alt 2 jobs, but that might not always be the case. This field is typed in by the applicant and there is no standardization, so you may want to make your filter narrower by using "roof replacement" or "roof replace", but you might be excluding "replace the roof", so you'll have to play with this filter until you are satisfied with the results.
Use the Job # field and cross reference with the DOB Permit Issuance dataset. Note: In the permit dataset, you may get several permits for a single Job #. You should look at the Work Type and Permit Type fields to narrow down to the exact permit that you want. For example, the entire alteration job might include both roof replacement and plumbing work, and you don't want the PL (Plumbing) Work Type permit.
That should get you to the report that you are looking for. If you have any additional questions, please let me know.

Thank you,

Closed

2017-06-07T00:00:00.000

2026-10-02T00:00:00.000

1354

Data Question

Department of Health and Mental Hygiene (DOHMH)

In the dataset, one of the columns describes 'scores'. They vary from 1 to 130. I wondered what this score means, what does is say about a restaurant if it scores a 2 in comparison to a 57? And what does the grade say about a restaurant: A, B or C?

Thank you in advance,

DOHMH New York City Restaurant Inspection Results

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

Greetings,

The NYC restaurant scoring and grading information can be found at:
http://www1.nyc.gov/assets/doh/downloads/pdf/rii/how-we-score-grade.pdf

Hope this helps.
-NYC Open Data Team

Closed

2017-06-05T00:00:00.000

2026-10-02T00:00:00.000

1350

Data Question

Department of Citywide Administrative Services (DCAS)

Hello,

I have a question about the Current Solicitations data set. I noticed there are a number of solicitations in this data set that have an end date that has already past; in fact, only a small number are listed that have not already ended. Can I infer from their presence in this data set that these solicitations are, in fact, still open? Is there a better set to use if we are seeking bidding opportunities for small businesses? We are seeking these on behalf of our partner organizations through the Small Business Development Center and Start Up New York.

Current Solicitations

https://data.cityofnewyork.us/d/3khw-qi8f

Greetings,

The information you are looking for can be found here: http://www1.nyc.gov/site/finance/about/doing-business-with-nyc.page

Best,
- NYC Open Data

Closed

2017-06-02T00:00:00.000

2026-10-02T00:00:00.000

1348

Reported Error

Office of Administrative Trials and Hearings (OATH)

No new violations since 5/28/2017. Metadata is indicating that the data has been updated but no new records are being added.

OATH Hearings Division Case Status

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

Greetings,

The OATH Hearings Division Case Status dataset is now updated to reflect the latest information.

Hope this helps.
-NYC Open Data

Closed

2017-06-02T00:00:00.000

2026-10-02T00:00:00.000

1347

Reported Error

Agency not assigned yet.

It presents an error - No data Set to display.

No URL Submitted.

Greetings,
The dataset is now updated with the latest geospatial information -https://nycopendata.socrata.com/Housing-Development/Projects-in-Construction-Map/dzgh-ja44

Best,
- NYC Open Data

Closed

2017-06-02T00:00:00.000

2026-10-02T00:00:00.000

1343

Data Question

Taxi and Limousine Commission (TLC)

I am receiving only top 1000 rows from this dataset, how can i get all 94100 rows?

For Hire Vehicles (FHV) - Active

https://data.cityofnewyork.us/d/8wbx-tsch

Greetings,

To query more than 1000 rows, please refer to Socrata user documentation:
https://support.socrata.com/hc/en-us/articles/202949268-How-to-query-more-than-1000-rows-of-a-dataset

Closed

2017-05-31T00:00:00.000

2026-10-02T00:00:00.000

1336

Reported Error

Agency not assigned yet.

I cant see current status

No URL Submitted.

Greetings,
Can you please provide us with more information, including the dataset you are referring to and other details.

Thank You,
-NYC Open Data Team

***Inquiry closed due to lack of response***

Closed

2017-05-30T00:00:00.000

2026-10-02T00:00:00.000