NYC Open Data Help Desk: Data Questions and Reported Errors

6027

Data Question

Agency not assigned yet.

How often did you update the dataset on Yellow Taxi Trip 2019? When dataset on Yellow Taxi Trip 2020 will be available? In particular when data for January, February and March 2020 will be available?

No URL Submitted.

Hi,

Thanks for reaching out about the TLC's Yellow Taxi trip data. We release trip records in six month increments, Jan - Jun and Jul - Dec, usually in the month after the six months end. We always release Yellow Taxi trip records at the same time as Green Taxi and the For-Hire Vehicle records, so delayed FHV record submissions can impact the release of the other records. Assuming there are no delays, you can expect Yellow Taxi trip records for Jan - March 2020 in July 2020.

Thanks,

NYC Open Data + Taxi and Limousine Commission

Closed

2019-11-07T00:00:00.000

2026-10-02T00:00:00.000

6021

Data Question

311

I am looking at the data for the 2011 School Survey...do you know where I can view the corresponding questionnaire, so I can make sense of the data? Aare the survey questions the same as the one used in more recent survey years...2018-2019, etc.?

311 Service Requests from 2020 to Present

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

Hi,

You can find the list of datasets maintained by the Department of Education here:
https://data.cityofnewyork.us/browse?Dataset-Information_Agency=Department+of+Citywide+Administrative+Services+%28DCAS%29&provenance=official

There is are attached dictionaries to each file that should help answer your question
Thank you,
- NYC Open Data Team

Closed

2019-11-06T00:00:00.000

2026-10-02T00:00:00.000

6005

Data Question

Business Integrity Commission (BIC)

Which of these businesses collect compost from businesses in lower Manhattan? It does not specify which businesses collect compost.

Trade Waste Hauler Licensees

https://data.cityofnewyork.us/d/867j-5pgi

Response not sent yet.

Pending

2019-11-01T00:00:00.000

2026-10-02T00:00:00.000

6003

Reported Error

Department of Buildings (DOB)

Hi,

we are doing some open-source research on the Violations Data. And we have noticed very large spikes during certain months in certain years. We are looking for some advices on whether these are erroneous? We did not see an attachment fold here - please see below for the date in questions. In the event that this data is mis-formatted when the form is submitted, we are happy to provide a csv via email.

Thank you,

data_labels, num_of_violations
1994-3,11466
1994-6,32406
1995-8,46796
1997-2,33175
1997-9,36458
1998-5,36269
1999-3,33580
2000-2,33904
2001-2,34193
2002-3,34724
2003-3,35986
2004-2,31794
2005-1,30441
2006-1,29530
2007-1,31684
2007-11,10118
2008-1,32875
2008-3,11259
2009-1,31115
2009-12,29628
2010-10,10466
2011-12,33756
2013-3,22017
2014-3,13457
2014-5,39455
2014-10,10634
2015-3,22765
2015-6,10186
2015-10,18761
2016-6,11081
2016-11,18940
2017-2,22100
2017-9,10928
2018-1,17800
2018-4,23647
2019-5,13596
2019-9,17054

DOB Violations

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

Please send the csv to cnicklin@buildings.nyc.gov along with any other details for your question.

Thank you,
- DOB Open Data Coordinator- NYC Open Data Team

Closed

2019-11-06T00:00:00.000

2026-10-02T00:00:00.000

6001

Data Question

Department of Buildings (DOB)

I noticed that the DoB Open data set sometimes does not match what DoB have on their BIS system.

Take this property for example:
http://a810-bisweb.nyc.gov/bisweb/PropertyProfileOverviewServlet?boro=1&block=778&lot=48

Why are there three extra violations showing up on your database and they dont show up on the BIS website... Which one is correct and up to date?

DOB Violations

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

Response not sent yet.

Pending

2019-11-01T00:00:00.000

2026-10-02T00:00:00.000

6000

Reported Error

Agency not assigned yet.

The link for the archived NYC School Survey (2007) does not work. I am trying to locate survey results from years 2007-2014. The years following 2014 are available on the DOE website...but the archived reports are supposed to be on opendata (according the DOE website). Can you please help me, locate this data set? I am on a time limitation, so if you get back to me quickly that would be a tremendous help!
What is your question?
The link for the archived NYC School Survey (2007) does not work. I am trying to locate survey results from years 2007-2014. The years following 2014 are available on the DOE website...but the archived reports are supposed to be on opendata (according the DOE website). Can you please help me, locate this data set? I am on a time limitation, so if you get back to me quickly that would be a tremendous help!

No URL Submitted.

Hi,

If you click on show more in the lower right hand corner you will see the data set as an attachment

Thank you,
- NYC DOE Open Data Team

Closed

2019-11-01T00:00:00.000

2026-10-02T00:00:00.000

5994

Reported Error

Agency not assigned yet.

Hi! I noticed that some Financial Empowerment Centers that are listed in the Open Data dataset don't match with those on NYC Consumer Affairs website (https://www1.nyc.gov/site/dca/consumers/get-free-financial-counseling.page). Myassmbption is that new sites open and some close and would like to know if and when the Open Data will be updated?

No URL Submitted.

Response not sent yet.

Pending

2019-10-31T00:00:00.000

2026-10-02T00:00:00.000

5993

Data Question

New York City Fire Department (FDNY)

There is a grammatical error on a parameter.
"opeartion_day" it should be "operation_day".

EMS Incident Dispatch Data

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

Great catch! The misspelling has been corrected.

Closed

2019-10-30T00:00:00.000

2026-10-02T00:00:00.000

5990

Data Question

Agency not assigned yet.

I am getting the following error: "The current user doesn't have access to this view".

I previously requested access to this dataset and have been using it.

Could you tell me what the problem is?

No URL Submitted.

Hi ,

At this time, we believe that your requested dataset is not maintained by a New York City agency.
You are welcome to submit a new dataset request with additional detail and specifically named agencies for referral.

Thank you,
- NYC Open Data Team

Closed

2019-10-30T00:00:00.000

2026-10-02T00:00:00.000

5982

Data Question

New York City Fire Department (FDNY)

My question pertains to the variable called "FINAL_SEVERITY_LEVEL_CODE"...….Is a value of 1 the least or most serious?

EMS Incident Dispatch Data

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

Response not sent yet.

Pending

2019-10-29T00:00:00.000

2026-10-02T00:00:00.000

5979

Reported Error

Department of Citywide Administrative Services (DCAS)

The current excel sheet no longer reflects 2019 data. It doesn't contain any current information.
What is your question?

Civil Service List Certification

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

We haven't heard back from you in over two months, so we will close this ticket due to inactivity. If you still have a question for us, feel free to update this ticket or send us a new one.

Thank you,
- NYC Open Data Team

Closed

2019-10-29T00:00:00.000

2026-10-02T00:00:00.000

5977

Data Question

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

I am unable to locate payroll data for New York City Health + Hospitals. Is this under a different name is this dataset or is it not publicly reported?

Citywide Payroll Data (Fiscal Year)

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

Response not sent yet.

Pending

2019-10-29T00:00:00.000

2026-10-02T00:00:00.000

5975

Data Question

New York City Police Department (NYPD)

For crimes involving stolen property, is it possible to get the dollar value of the stolen property?

NYPD Complaint Data Current (Year To Date)

https://data.cityofnewyork.us/d/5uac-w243

Hi,

Per the NYPD Data Coordinator: "There is no plan to release this information at this time."

Thank you,
- NYC Open Data Team

Closed

2019-10-28T00:00:00.000

2026-10-02T00:00:00.000

5974

Data Question

Metropolitan Transportation Authority (MTA)

It is stated that the data was created August 30, 2011. What I need to know is what years of data are included in the dataset. I am looking for earlier years, from the 20th century.

Subway Entrances

Response not sent yet.

Pending

2019-10-28T00:00:00.000

2026-10-02T00:00:00.000

5968

Data Question

New York City Police Department (NYPD)

I'm wondering what certain penal codes/associated crimes mean. I can't find concrete answers for the ones I've listed below online, and was hoping to know if they are misdemeanors, felonies, or something else. And perhaps an explanation of the law itself...I'm most interested in the last one on traffic infractions. Are you able to explain to me how someone can be arrested for an infraction? Just a little fuzzy on the laws and trying to familiarize myself with them as I work on my beat at a freelance journalist. Thank you!
AC010125B- Adm.code, unclassified violation
PL250453A - obscene material - under 17 years of age
PL 2601001Child endangering welfare (sex crimes)
PL 2213000- Marijuana possession 1,2,3
VTL 11920U2 Intoxicated driving, alcohol
ABC0064B00- ALCOHOLIC BEVERAGE CONTROL LAW
PL 2154002 - Bribery, public administration
VTL0375012; lights, improper
VTL051101A- traffic, unclassified infraction

NYPD Arrest Data (Year to Date)

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

Hi *****,

The PD Code - Penal Law crosswalk can be found here:
https://data.cityofnewyork.us/api/views/qgea-i56i/files/65f25845-1551-4d21-91dc-869c977cd93d?download=true&filename=PDCode_PenalLaw.xlsx

Thank you,
- New York Police Department

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

Closed

2019-10-28T00:00:00.000

2026-10-02T00:00:00.000

5957

Data Question

Department of Citywide Administrative Services (DCAS)

Hello,

In reviewing the Certification list I wanted clarity on the definitions of Request Date, Cert Date and List Agency.

Thank you!

Civil Service List Certification

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

Hi,

The data dictionary for the Civil Service List Certification dataset can be found at https://data.cityofnewyork.us/City-Government/Civil-Service-List-Certification/a9md-ynri.

DCAS Senior Counsel

Closed

2019-10-25T00:00:00.000

2026-10-02T00:00:00.000

5955

Data Question

New York City Police Department (NYPD)

Some columns don't have a description. Where is the description of those columns? Or where do I access the data dictionary?

NYPD Complaint Data Historic

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

Hi,

​On the primer page or landing page of every data set you can look in the Attachments section of that dataset to find an accompanying data dictionary.
​
​Here is a downloadable link for the historical NYPD data you are inquiring about.
​https://data.cityofnewyork.us/api/views/qgea-i56i/files/ee823139-888e-4ad0-badf-e18e2674a9cb?download=true&filename=NYPD_Complaint_Historic_DataDictionary.xlsx

Closed

2019-10-25T00:00:00.000

2026-10-02T00:00:00.000

5950

Data Question

Agency not assigned yet.

Hello,

I have a quick question about the data. In the parking violation dataset, where does 'Street code 2' come from? I figured out 'Street code 1' corresponds to the street code in LION street data, but I had no idea about 'Street code 2' and 'Street code 3'.

I would appreciate your help.

No URL Submitted.

Hi,

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


Thank you,
- NYC Open Data Team

Closed

2019-10-23T00:00:00.000

2026-10-02T00:00:00.000

5948

Data Question

311

Are all 311 calls reported here even if they are from the same apartment or person?

311 Service Requests from 2020 to Present

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

Hi {{respondent_name}},

Not all 311 Service Requests are published in the Service Requests data set. Certain categories of requests are withheld as required by law.

Thank you,
- NYC Open Data Team

Closed

2019-10-23T00:00:00.000

2026-10-02T00:00:00.000

5941

Data Question

Taxi and Limousine Commission (TLC)

When will this data set be updated for Q3?

FHV Base Aggregate Report

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

Hi,

Thanks for reaching out about the FHV Base Aggregate Report. To a certain extent, updates to this report will never be completely automated because the TLC does not publish the report until we have received trip records from all bases, including small bases, and those records are processed without error. In the event that a base does not submit records (or submits records in an unreadable format), this process can get tied up as our Prosecution Unit pursues legal action against the non-compliant base. We have been delayed in publishing August updates for this reason. In general, when all records are received and processed according to the schedule laid out by TLC rules, you can expect a monthly update to the list on a two month delay, i.e. September updates in early November, October in early December, and so on.

Best,

NYC Open Data + Taxi and Limousine Commission

Closed

2019-10-22T00:00:00.000

2026-10-02T00:00:00.000

5930

Data Question

Department of Buildings (DOB)

New Question:
Does that mean that historic Data will be brought into the DoB Now data set? This information is heavily used for city benefits analysis, to anticipate the possibility of a physical and also for filing TC 200 information. Having only current applications will leave a huge gap in functionality for years to come for both of these data sets.
Is there currently a plan or can there be to import the historic Data?

Thank you for your time

Old Submission:
The one key piece of information missing from this Data set is the floors being worked on (the same way it's reflected on the DoB permit pages and it's also shown on DoB NOW), is there any plan on including this in the future?

DOB Job Application Filings

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

Hi,

The DOB Job Application Filings dataset is based on our old BIS system, and we are no longer making any enhancements. By end of next year, we should have almost all of our job filings in DOB NOW, and we will be focusing on those datasets.
We've been slowly phasing Work Types into DOB NOW. In some cases, we have migrated a limited amount of historical data. In other cases, none. In no case are we migrating the entire history of data over to DOB NOW.
The BIS datasets will remain available, and can always be a reference for historical records. We just won't be adding any new fields to enhance the dataset.

Thank you,
- DOB Open Data Coordinator

Closed

2019-10-28T00:00:00.000

2026-10-02T00:00:00.000

5924

Reported Error

311

It appears that Socrata is having issues with filters. When I filter NYC 311 data on Borough

311 Service Requests from 2020 to Present

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

Thanks for flagging this out. A support ticket was sent to Socrata by MODA and as of today, 311 filtering functionality on a derived view is working as it should be. Can you please confirm on your end?

Thank you,
- NYC Open Data Team

Closed

2019-10-18T00:00:00.000

2026-10-02T00:00:00.000

5918

Reported Error

Agency not assigned yet.

How can I know longtitude and latitiude of each station?

No URL Submitted.

Hi,

Thank you for your request. Latitude and longitude were not captured during the bike share inspections therefore this data is not available. You may use Department of City Planning (NYCDCP) Geographic Online Address Translator (GOAT) system to find the latitude and longitude of the locations.

NYCDCP GOAT: http://a030-goat.nyc.gov/goat/

Closed

2019-10-17T00:00:00.000

2026-10-02T00:00:00.000

5917

Reported Error

Metropolitan Transportation Authority (MTA)

A subway entrance for the F at East Broadway is mislabeled. It is at Rutgers and Madison St, not Rutgers and Madison *Ave*.

Subway Entrances

Response not sent yet.

Pending

2019-10-17T00:00:00.000

2026-10-02T00:00:00.000

5908

Reported Error

Agency not assigned yet.

Most of the time, regardless of the location to which I save the downloaded data, I can't sort it in the attribute table. I have only successfully downloaded it once where I got ArcGIS to sort everything alphabetically. In every subsequent attempt half the data sorts alphabetically, and interspersed throughout the sorted data are entries with "0s" in front of some columns' text data.

No URL Submitted.

Hi,
Thank you for contacting NYC Parks regarding the 2015 Tree Census data. I am unsure from your message which field you are trying to sort alphabetically. Feel free to send me an email at tessa.leverone@parks.nyc.gov to clarify your process, and I can check the dataset for errors.

Best,
NYC Parks and the NYC Open Data Team

Closed

2019-10-16T00:00:00.000

2026-10-02T00:00:00.000

5904

Reported Error

Metropolitan Transportation Authority (MTA)

The json download for bis jobs and permits doesn't download a file, rather it renders the entire dataset on a web browser page. Is this purposeful?

Subway Entrances

Hi,

Thanks you for you inquiry. Upon further review, it appears that the occurrence of JSON displaying within your browser is a actually browser behavior and is not related to an unintended behavior of the Open Data Portal.

For instance, Google Chrome does not have a default setting to automatically download JSON to a file, whereas internet explorer does. If you are experiencing JSON displaying within your browser, we recommend you right-click and save JSON to a file. Or experiment with a different default browser.

Thank you,
- NYC Open Data Team

Closed

2019-10-15T00:00:00.000

2026-10-02T00:00:00.000

5897

Reported Error

Agency not assigned yet.

Last week my docket number showed up as LPC-20-02407. With the new data set update as of 10/12 I no longer can find my docket number LPC-20-02047. What happened?

No URL Submitted.

Hi,

thanks for your patience on this. We are not sure if this was a bug or data cache in your browser. But with the latest update, you Docket number is now present. We apologize for the inconvenience.

Thank you,
- NYC Open Data Team

Closed

2019-10-13T00:00:00.000

2026-10-02T00:00:00.000

5895

Data Question

New York City Police Department (NYPD)

Regarding the Jurisdiction_Code variable. Defined as "Jurisdiction responsible for arrest. Jurisdiction codes 0(Patrol), 1(Transit) and 2(Housing) represent NYPD whilst codes 3 and more represent non NYPD jurisdictions."

Is it possible to get additional information as to what "3, non-NYPD jurisdictions" means? Further, what other categorizations for this variable means? Arrests in the dataset have some of the following numbers under Jurisdiction_Code: 97, 72, 4, 69, 73, 6, 7, 11.

NYPD Complaint Data Historic

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

Thank you for your inquiry.
Law codes can be searched online:
https://codes.findlaw.com/ny/vehicle-and-traffic-law/vat-sect-511.html


Best,
NYC – Open Data Team

Closed

2019-10-12T00:00:00.000

2026-10-02T00:00:00.000

5893

Data Question

Agency not assigned yet.

Good Afternoon, Do you have a record of a job application filing for a roof or facade repair around year 2017 or earlier, at Queens Borough Block 10299 Lot #9?

No URL Submitted.

Hi,

I don't see any records for a job application for roof repair for this building. In fact, I do see violations and an active Vacate Order for roof collapse in 2017. There is no indication that the building owner has tried to repair it.

When there are no records on Open Data and you're looking at a single address, I recommend that you also check our Buildings Information System. On the property profile for this address, you can see the whole picture.

Thank you,
- DOB Open Data Coordinator

Closed

2019-10-10T00:00:00.000

2026-10-02T00:00:00.000

5886

Data Question

Department of Buildings (DOB)

Hello, I noticed this data set is missing the "job description" and or job details". Is there a plan to add those fields?

DOB ECB Violations

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

Hi,

We will take your request into consideration for a future update to our DOB NOW: Build – Job Application Filings dataset, which will be enhanced after we release the General Construction work type in DOB NOW sometime next year.

Thank you,
- DOB Open Data Coordinator

Closed

2019-10-10T00:00:00.000

2026-10-02T00:00:00.000

5882

Data Question

Department of Finance (DOF)

The link to "Page" leads to a dead page, https://www1.nyc.gov/site/planning/planning-level/nyc-population/american-community-survey.page.page

Open Parking and Camera Violations

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

Hi ,

Sorry for the dead link. The Department City Planning (DCP) recently went through a reorganization the content on our website which broke some of the data linked from the Open Data portal. NYC Open Data team and City Planning will be working together to identify and clean up any other dead links the reorganization may have caused.

In the meantime, the data you've requested can be found on City Planning's website here:
https://www1.nyc.gov/site/planning/planning-level/nyc-population/american-community-survey.page

You can select different types of American Community Survey (ACS) profiles; Demographic, Social, Economic and Housing at different scales; Citywide/Borough, PUMA (Community District) and Neighborhood Tabulation Area. We have these estimates up to 2017 and you can use the drop down to view older versions of the ACS estimates.

You can also use the Population Fact Finder app to access demographic data from Decennial Census or ACS at many scales.

Thank you,
- DCP Open Data Team

Closed

2019-10-06T00:00:00.000

2026-10-02T00:00:00.000

5879

Data Question

Agency not assigned yet.

is it possible to use the borough block lot (BBL) number to identify individual buildings?

No URL Submitted.

Hi,

No, BBL does not identify individual buildings. In many cases, there is only one building on a lot, but there are also many cases where there are 2, 3, or even hundreds of buildings on a single lot. If you are interested in learning more about NYC's spatial data, I recommend you check out Department of City Planning's PLUTO Data Dictionary. It was created specifically for that dataset, but it gives a very good background on a lot of data elements including block, lot, and number of buildings on the lot.

Thank you,
- DOB Open Data Coordinator

Closed

2019-10-09T00:00:00.000

2026-10-02T00:00:00.000

5877

Data Question

Department of Buildings (DOB)

Hi, I wanted to clarify how License Numbers work for contractors (e.g. plumbers, etc.). Are these numbers unique across all types of licenses, or only within a license type?

For example I see this plumbing license (http://a810-bisweb.nyc.gov/bisweb/LicenseQueryServlet?licno=001327&licensetype=P&go3=+GO+&requestid=0) and this Site Safety Manager (http://a810-bisweb.nyc.gov/bisweb/LicenseQueryServlet?licensetype=M&licno=001327&requestid=99) who both have the same license number.

DOB NOW: Build – Job Application Filings

https://data.cityofnewyork.us/d/w9ak-ipjd

Hi,

You found a perfect example. As you can see these two licenses have the same exact number. That happens throughout our data - this is not an anomaly. In our system, we always have a prefix or we couple the license number with another field that indicates the license type. For example, if this were a General Contractor, the license # in our system might be GC001327. The syntax depends on which system or user interface you are looking at. Within a specific license type, all of the license numbers should be unique.

Thank you,
- DOB Open Data Coordinator

Closed

2019-10-09T00:00:00.000

2026-10-02T00:00:00.000

5864

Data Question

New York City Police Department (NYPD)

My students at the University of Vermont have in the past used the vehicle and person data tables that go with the crash data tables. Can these still be provided? Thank you.

Motor Vehicle Collisions - Crashes

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

Hi,

the data you've requested is being developed and has not yet been released. vehicle and person data tables Will be released by the end of 2019.

Thank you,
- NYC Open Data Team

Closed

2019-09-27T00:00:00.000

2026-10-02T00:00:00.000

5862

Data Question

Department of Buildings (DOB)

Will the dataset be updated to include additional information already available on BIS, such as the Stipulated Compliance Due Date and (in the case of elevators) Device Number?

DOB ECB Violations

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

Hi,

We are planning several new releases for DOB open data over the next few years. We do have the ECB Violations dataset flagged for a possible update if we have time in between those new datasets. Stipulated Compliance Due Date is not in the plan. Device Number is a possibility.

Thank you,
- DOB Open Data Coordinator

Closed

2019-10-07T00:00:00.000

2026-10-02T00:00:00.000

5857

Data Question

Department of Finance (DOF)

I just need to know if this dataset have an open license so it can be published.

Open Parking and Camera Violations

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

Hi {{respondent_name}},

​This data is not subject to any copyright or license restrictions at all. You are free to use all the data on the NYC Open Data Portal in whatever way you wish.

Thank you,
- NYC Open Data Team

Closed

2019-10-06T00:00:00.000

2026-10-02T00:00:00.000

5853

Data Question

Agency not assigned yet.

"Milbank Center Go!Healthy Farm Stand" has a Latitude somewhere in Antartica

No URL Submitted.

Good Afternoon,

Dataset “Milbank Center Go! Healthy Farm Stand” has been updated. If you would like to view this dataset please use the following link https://data.cityofnewyork.us/dataset/DOHMH-Farmers-Markets/8vwk-6iz2

Thank you,
- NYC Open Data Team

Closed

2019-10-02T00:00:00.000

2026-10-02T00:00:00.000

5851

Data Question

Department of Transportation (DOT)

Good afternoon,

I would like to know how frequently this dataset is updated. I understand that it says "As Needed" on the dataset but historically is it weekly, monthly?

Thank you

Street Construction Permits (2022 - Present)

https://data.cityofnewyork.us/d/tqtj-sjs8

Hi,

The Street Construction Permits are updated once a month at the beginning of the month.

Thank you,
- NYC Open Data Team

Closed

2019-10-03T00:00:00.000

2026-10-02T00:00:00.000

5847

Data Question

Department of Buildings (DOB)

What is the difference between work type and permit type? Section 3 of the PW2 is simply labeled "permit type", and the term "work type" doesn't appear anywhere. So from where does the work type field draw its data?

DOB NOW: Build – Job Application Filings

https://data.cityofnewyork.us/d/w9ak-ipjd

Hi,

In DOB Permit Issuance, Work Type and Permit Type both come from Section 3 of the PW2. You should see a pattern if you analyze the data. For example, I'm looking at a record right now that is Permit Type EW and Work Type BL. That's a Boiler permit on the PW2. I think BL will always get a EW permit type, but I don't know that for sure - that's why the data dictionary doesn't explicitly say that.

Thank you,
- DOB Open Data Coordinator

Closed

2019-10-03T00:00:00.000

2026-10-02T00:00:00.000

5845

Data Question

Department of Buildings (DOB)

Why is the name of the first job status "prefiling"? Doesn't the very existence of that document indicate that the job application has been filed? I have a feeling this may have something to do with the supporting documents (cost affidavit, certificate of occupancy if required, etc.), but if this were the case shouldn't there be a job status corresponding to a complete application? Additionally, the work types, permit types, and permit sub types described in the excel document found on the permit issuance page don't align with those posted on the DOB permit acronym glossary page, can I safely assume the ones provided by open data are correct and that the DOB website is outdated?

DOB NOW: Build – Job Application Filings

https://data.cityofnewyork.us/d/w9ak-ipjd

Hi,

In DOB Permit Issuance, Work Type and Permit Type both come from Section 3 of the PW2. You should see a pattern if you analyze the data. For example, I'm looking at a record right now that is Permit Type EW and Work Type BL. That's a Boiler permit on the PW2. I think BL will always get a EW permit type, but I don't know that for sure - that's why the data dictionary doesn't explicitly say that.

Thank you,
- DOB Open Data Coordinator

Closed

2019-10-03T00:00:00.000

2026-10-02T00:00:00.000

5844

Data Question

Agency not assigned yet.

Why are the values in the "Deaths" column inputted in a text field? Why aren't they in a numeric field?

No URL Submitted.

Good Afternoon,

This data was submitted through an excel file, if uploaded from the open data website, you may change to numerical field.

Thank You,

Department of Health

Closed

2019-10-02T00:00:00.000

2026-10-02T00:00:00.000

5831

Data Question

Office of Administrative Trials and Hearings (OATH)

Ticket #050054253N is missing balance due ($2,400.00), violation location details, BBL and issuing agency.

There are many other violations/tickets with similar issues, below are a couple;
050054226H
050053990Z

OATH Hearings Division Case Status

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

Hello thank you for flagging this issue. Fortunately the team here is well aware of this ongoing issue and rectifying the accuracy OATH dataset is an ongoing priority.
For now we recommend you use the ECB ticket finder online to verify the most accurate status of your ticket till this issue is resolved.

http://a820-ecbticketfinder.nyc.gov/searchHome.action?

Closed

2019-10-01T00:00:00.000

2026-10-02T00:00:00.000

5830

Data Question

Department of Finance (DOF)

HOW DO I ACCESS INFORMATION IN THE DATA SET "OPEN PARKING AND CAMERA VIOLATIONS." AFTER I ENTER INFORMATION, I GET THE FOLLOWING MESSAGE: "WE'RE HAVING TROUBLE DISPLAYING THIS TABLE. CHECK TO MAKE SURE THE UNDRLYING DATASET HASN'T BEEN DELETED OR UNPUBLISHED."

Open Parking and Camera Violations

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

Hello,we have replacated the error you are experiencing and we have forwarded this issue to socrata support.
As this data is a very large dataset, we would recommend using the platfrom filters which is a much more stable way of producing results.
Please follow our video guides on how to use the Open Data Portal here: https://opendata.socrata.com/videos#basic-filtering

Closed

2019-10-01T00:00:00.000

2026-10-02T00:00:00.000

5826

Data Question

Department of Transportation (DOT)

What is the unit for 'speed' data in this dataset? Is it mile per hour or km per hour or something else? Thanks

Real-Time Traffic Speed Data

Hi,

Thank you for your request. The Real Time Traffic Speed units are as follows:

Speed: Miles Per Hour (MPH)
Travel_Time: Seconds.

Thank you,
- NYC Open Data Team

Closed

2019-09-30T00:00:00.000

2026-10-02T00:00:00.000

5823

Data Question

Department of Buildings (DOB)

Hi, I was wondering if there is a way to find out the valuation of the work that a permit was for, and/or the fee for obtaining the permit? (E.g. a contractor might pay $500 to obtain a permit for a job with a value of $40,000).

I see that websites such as Buildzoom show permit information for contractors and this information includes the Valuation and Fee prices I described above. (https://www.buildzoom.com/contractor/purewal-contractors-inc)

I would have to assume Buildzoom is getting this information from public DOB data, but I can't seem to find where that data lives.

Thanks so much,

DOB Permit Issuance

Hi,

In our DOB Job Application Filings dataset, there are 2 columns that will help you: Initial Cost and Total Est. Fee. Read the data dictionary on that dataset homepage under "Attachments" for more information about this dataset.

Thank you,
- DOB Open Data Coordinator

Closed

2019-09-30T00:00:00.000

2026-10-02T00:00:00.000

5820

Data Question

New York City Police Department (NYPD)

Is there any way to reduce the data for the last 3 years only?

Motor Vehicle Collisions - Crashes

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

Hello,

Thank you for your inquiry. We are happy to report that there is a way to isolate only three years of Collision data. For reference please be advised that the data only goes back to 2012.
To isolate 3 years of data you can simply use the filter function on the Socrata website. Chose the [DATE] columnn and configure the filter for [is between] and in put the desired start date and end date for your filter.
If you've created your Socrata account, you will be able to save your created filter.

We have video guides on how to use the Open Data Portal here: https://opendata.socrata.com/videos#basic-filtering

Closed

2019-09-27T00:00:00.000

2026-10-02T00:00:00.000

5818

Data Question

Department of Buildings (DOB)

Besides being migrated to a new platform, are the applications for various job types undergoing any other changes? Essentially, is the paper application for a specific job type the best way to anticipate what information will be released in the corresponding open data collection?

DOB NOW: Build – Job Application Filings

https://data.cityofnewyork.us/d/w9ak-ipjd

Hi,

The paper form is a great way to get a general idea, and I use it myself all the time. That said, there are some differences in DOB NOW. New questions added, information combined, etc. The best way to anticipate the data would be if you could look over someone's shoulder who has a DOB NOW account.

Thank you,
DOB Open Data Coordinator

Closed

2019-09-27T00:00:00.000

2026-10-02T00:00:00.000

5815

Data Question

New York City Police Department (NYPD)

I'm working on a capstone data science project, and am wondering why there are 3,222,422 missing values for suspect race (49.5% of total), and 3,355,736 missing values for suspect sex (51.6% of total). Is this an error or just a problem with police reporting?

Also, I was wondering about the SUSP_AGE_GROUP and VIC_AGE_GROUP variables. The SUSP_AGE_GROUP variable only has 1,515,401 meaningful values, and the VIC_AGE_GROUP variable has 4,403,146 meaningful values.

If these missing values exist in another repository, I would greatly appreciate receiving them. If not, an explanation for so many missing values would be appreciated as well.

Thanks!

NYPD Complaint Data Historic

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

Hi ,
As you indicated, this an general issue related to reporting. The fields you indicated are not required fields and are subject to officer interpretation.

Thank you,
- NYPD Open Data Team

Closed

2019-09-27T00:00:00.000

2026-10-02T00:00:00.000

5812

Data Question

Department of Buildings (DOB)

Will general construction filed on DOB NOW be published under the current DOB NOW Job Applications? Or is that immediately considered a different collection

DOB NOW: Build – Job Application Filings

https://data.cityofnewyork.us/d/w9ak-ipjd

Hi,

We expect the General Construction release to be part of the DOB NOW: Build – Job Application Filings dataset. We will make some major changes to the dataset, including the addition of dates, so expect schema changes.

Thank you,
- DOB Open Data Coordinator

Closed

2019-09-26T00:00:00.000

2026-10-02T00:00:00.000

5810

Data Question

Department of Citywide Administrative Services (DCAS)

When is the Civil Service List (Active) going to be updated? It is usually updated daily but has not be updated since 9/24/19 and today is 9/26/19.

Civil Service List (Active)

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

Hi,

The data you've requested can be found here:
https://data.cityofnewyork.us/City-Government/Civil-Service-List-Active-/vx8i-nprf
​
Thank you,
- NYC Open Data Team

Closed

2019-09-26T00:00:00.000

2026-10-02T00:00:00.000