NYC Open Data Help Desk: Data Questions and Reported Errors

4759

Data Question

Department of Buildings (DOB)

Are there any changes made to applications in your dataset after they have initially been added? I.e., if the NYC DOB amends the status of an application to show that it has been fully permitted, is that change reflected in your data? If so, how could I track these changes and mirror them myself?

DOB Job Application Filings

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

Hi,

Yes, changes in status are reflected in this dataset. Please check our Data Dictionary on the dataset home page in the Attachments section for more information.

The simplest way to track it is to just check the dataset every day for a change to a specific job number. If you want to do some form of more systematic data tracking, check out the Open Data portal's "How To" information. And if you still have questions, please submit a new question requesting further assistance on how to use the portal itself.

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

Closed

2019-02-26T00:00:00.000

2026-10-02T00:00:00.000

4755

Data Question

New York City Police Department (NYPD)

I would like to know what is the difference between the dataset that is in "https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Historic/qgea-i56i and the dataset" that is in "https://data.cityofnewyork.us/Public-Safety/NYPD-Arrests-Data-Historic-/8h9b-rp9u"

Thank you very much and greetings

NYPD Complaint Data Historic

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

​Thank you for contacting NYC Open Data Help Desk. Complaints are reports of crimes, either generated by residents of if observed directly, by the officers themselves. Arrests are an enforcement action. These records document the actual arrest of individuals for a given crime by an officer.​
​
Thank you,
- NYPD

Closed

2019-02-25T00:00:00.000

2026-10-02T00:00:00.000

4752

Data Question

Department of Finance (DOF)

Hello! I have some questions regarding deed records in the "real property master" dataset. For context, I am grouping these records by bbl using "real property legals" and also joining party information using "real property parties":

- Why are there sometimes multiple deeds filed on one day for a given tax lot?
- When the last deed transaction date shows multiple deeds filed on the same day, how can we determine the current property owner of the tax lot?
- What does a 'docamount' value of 0 on a deed signify, specifically when the deed is filed the same day as other deeds with non-zero 'docamount' values?
- How are 'documentid' values ordered, if at all?

ACRIS - Real Property Master

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

The answers are as follows:


Why are there sometimes multiple deeds filed on one day for a give tax lot?
This is the nature of property sales and is controlled by the buyers and sellers and not the Department of Finance so we would not be able to list all reasons. Note that there is no requirement to record a deed when the property sells although transfer taxes returns must still be filed. With that said two common occurrences are:
Flips where party A sells the property to party B who then sells the property to party C. By looking at the document dates on the two deeds you can tell how long B help the property and often that will imply what B did with the property.
Settlement of an estate. In this case party A passes away and leaves the property to party B. Party B then only records the deed associated with this transfer then he sells to party C immediately prior to the recording for the deed from B to C.

When the last deed transaction date shows multiple deeds file on the same day, how can we determine the current property owner of the tax lot?
Generally speaking one should order by the document date from newest to oldest, next by CRFN from highest to lowest and finally by document id from highest to lowest. Note that the document id ordering is only useful for documents without CRFN which are those documents recorded prior to 1/1/2003 and brought into ACRIS from systems pre-dating ACRIS.

What does a ‘docamount’ value of 0 on a deed signify, specifically when the deed is filed the same day as other deeds with non-zero ‘docamount’ value?
As noted in the Data Dictionary for the Real Property Master dataset, the Document Amount field is the “Total Consideration for Transfers and Principal debt or obligation for Mortgages”. For deeds you can think of the Document Amount as the sales price. With this in mind, a Document Amount of 0 means the property was transferred with any money changing hands. There can be many reason for a $0 consider, but normally it means the transfer is not an “arms-length” transaction among unrelated parties. The reason most commonly associated with multiple deeds recorded the same day, some of which have non-zero consideration, is the settlement of an estate as mentioned earlier. When party B inherits the property from party A, no money changes hand; however when B sells to C, it is for a non-zero amount.


How are ‘documentid’ values ordered, if at all?
There are three formats of Document ID in ACRIS. These are:

YYYYMMDDsssssttt = the format of documents record since 1/1/2003 where YYYY is the 4 digit year, MM is the 2 digit month, DD is the 2 digit day, sssss is a 5 digit sequence number within a day and ttt is a 3 digit sequence number within an ACRIS transaction. Document IDs in this format are assigned when the document submitter prepares the documents for recording. Documents with common ACRIS cover page transaction number, YYYYMMDDsssss, are submitted together and recorded in the order specified by sss. There is no significance to the ordering of the ACRIS cover page transaction numbers. Two submitters could prepare the documents for recording on the same day so share the YYYYMMDD portion of the document id, but could actually submit and have their documents recorded weeks or even months apart.
FT_Bssssssssssss = the format of documents whose index data was converted to ACRIS from the system immediately pre-dating ACRIS. In this format FT_ prefix is fixed, B is the property borough and ssssssssssss is a sequence number that increases with recording date.
BK_Btttttttttttt = the format of older documents whose microfilm images where indexed and imported into ACRIS. In this format the BK_ prefix is fixed, B is the property borough and tttttttttttt is a sequence number that increases with recording date. Note that BK_ documents are older than FT_ documents.
With this in mind, ordering FT_ and BK_ Document IDs has significance, but ordering Document IDs staring with 20 does not. For documents with Document ID starting with 20, use the CRFN which is a number with format YYYYrrrrrrrrr where YYYY is the year and rrrrrrrrr is a 9 digit padded sequence number which is reset each year and is monotonically increasing with recording date and time.


Regards,
DOF

Closed

2019-02-25T00:00:00.000

2026-10-02T00:00:00.000

4751

Data Question

Agency not assigned yet.

I have a question about your data on the park zones. Is this data accurate? and do the NYC Parks and Recreation have Jurisdiction over the grey areas?

No URL Submitted.

Thank you for contacting NYC Parks about the Park Zones dataset. Larger NYC parks (generally >20 acres) are subdivided into smaller sections that make inspecting these parks feasible and efficient. These sections are called "zones", and are administrative boundaries not physical boundaries. All of the zones in the dataset are within parks properties. For a more comprehensive view of park properties please view the Parks Properties dataset.

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

Closed

2019-02-25T00:00:00.000

2026-10-02T00:00:00.000

4746

Data Question

Department of Finance (DOF)

Hello. How often is this list updated? When is the next update? Thank you.

Tax Lien Sale Lists

https://data.cityofnewyork.us/d/9rz4-mjek

The Tax Lien Sales List is update at least 4 times per year. You can take a look at the dataset which was posted to Open Data last week to see the most current information. As you will see it has gone through the 90, 60, and 30 day notice cycles and the first sale will be in August and there may be another sale after that.


Thank you,
- NYC Open Data Team

Closed

2019-02-24T00:00:00.000

2026-10-02T00:00:00.000

4743

Data Question

Department of Buildings (DOB)

I'm trying to get aggregate information on construction expenditures in NYC. I've specifically been looking at the Hudson yards area. Using a program I developed, I'm seeing roughly $700M of construction expenditure using the "Initial Cost" field. This is substantially below the widely reported $25B. Any idea what's up? See image here: https://drive.google.com/file/d/1GXxFYY4gnlfHHl5V6CRf_cdtLagGb_K1/view?usp=sharing

DOB Job Application Filings

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

Hi,

This information is not currently available as data. You can see scanned copies of the forms in our Building Information System if you look up the individual jobs. The Virtual Job Folder link at the top of the Application Details page will include a link to the PW3 Cost Affidavit, if one was submitted with that job.

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

Closed

2019-02-22T00:00:00.000

2026-10-02T00:00:00.000

4741

Data Question

Department of Buildings (DOB)

We're trying to join this dataset with the DOB Job Application Filings dataset (https://data.cityofnewyork.us/browse?q=DOB%20Job%20Application%20Filings&sortBy=relevance) to create a field called "C/O Issue Date." Unfortunately, there doesn't seem to be a good field to join the datasets together as it looks like the C/O Dataset has a different Job # than the Job Filings dataset. Any tips for how to join these two together? Using geometry could be problematic because there may be multiple job filings at the same location over time.

DOB Certificate Of Occupancy

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

Hi,

Job Number is the key that joins these two datasets together. I suspect that you are expecting the 2 datasets to match up neatly and not have any records left out on either side, which won't be the case.

The Job Applications dataset only includes job applications with a "Latest Action Date" since January 1, 2000. In addition to that, these applications are in every phase of the process from first submission to final Sign Off.

The Certificates of Occupancy (CO) dataset contains all COs issued since 7/12/12. Final COs are only issued after a job is signed off. A Temporary Certificate of Occupancy (TCO) may be issued earlier, but not every job will get a TCO. A CO can also be issued for older jobs that may not be in the other dataset.

Please review the Data Dictionaries for these datasets on their home pages in the Attachments section. If you want to get more information about a specific record, use our Building Information System (BIS). And if you still have specific questions about the data, feel free to come back here and ask me.

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

Closed

2019-02-22T00:00:00.000

2026-10-02T00:00:00.000

4736

Reported Error

Agency not assigned yet.

All OMO charges for building ID *** were transferred to DOF and paid 8/2/12 please remove from open data and send me of confirmation notice of their removal
thank you

No URL Submitted.

If you check our Invoices for Open Market Orders (OMO) Charges dataset, you'll see that that the invoices show that the OMO charges for this building were transferred to DOF on the dates specified for each record. Note that this report does not show changes to individual charges as a result of protests or payments. The Department of Finance system should be checked for the current status of any charge listed on this report once that charge has been transferred to DOF.

Thank you,
- NYC Open Data Team + HPD

Closed

2019-02-21T00:00:00.000

2026-10-02T00:00:00.000

4733

Reported Error

Department of Transportation (DOT)

On average 30% of the records do not return intersection (On street , FromStreet, ToStreet) geo information (long lat) when API is used to retrieve the geo information.
Can it be fixed?
Or can you add the intersections geo info as new columns in existing data?

Street Construction Permits (2022 - Present)

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

Thanks for your inquiry! These are not errors. Records without a location are not actually for street work. They reflect payments, receipts, waivers, and other special cases. They are in this dataset because they are tracked in the same database that issues permits.


Example 1: Requests to do work during an embargo period require payment of a "MISCELLANEOUS - EMBARGO WAIVER REQUEST" fee before DOT will consider the request. This record reflects a payment rather than a location; associated permits issued after payment of the fee can be found by joining on the FullApplicationNo column.


Example 2: Some Oversized Vehicle permits are in the dataset. They used to be tracked in the same computer system as street work permits to allow trucks larger than the usual limit to travel on City streets.

Please let us know if you have further questions.


Thank you,
- NYC Open Data Team

Closed

2019-02-21T00:00:00.000

2026-10-02T00:00:00.000

4732

Data Question

Agency not assigned yet.

When I view or export this data (facades compliance filings) to a CSV, I seem to get only a subset of the records. The subset of records I get is different on different days. They seem to correspond to only certain buildings and certain cycles. Is it possible to access the entire dataset?

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please be advised that we could not recreate the issue you have reported. For example on 2/26/2019, we have downloaded this data in csv format and all 6,770 were successfully downloaded and opened in a spreadsheet. Can you kindly provide us with more details regarding the discrepancy you are experiencing?

Thank you,
- NYC Open Data Team

Closed

2019-02-21T00:00:00.000

2026-10-02T00:00:00.000

4728

Reported Error

Agency not assigned yet.

I am unable to save nor upload the Brooklyn Public Library's json file into Excel. Is there a spreadsheet of this information?

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please be advised that the spreadsheet file is now available for download (please refer to the Attachments section of this dataset's metadata).

Thank you,
- NYC Open Data Team

Closed

2019-02-20T00:00:00.000

2026-10-02T00:00:00.000

4719

Data Question

Agency not assigned yet.

how i can access jobs fillings of dob dataset of 2019 February with boroughs
thanks

No URL Submitted.

Hi,

We have a lot of data here on the open data portal. You can access information about major construction jobs in our DOB Job Application Filings dataset. Before you look at the data, check out our Data Dictionary in the Attachments section which explains what you'll find in the dataset. Then click on the blue View Data button. Use the Filter feature to narrow down Latest Action Date to February 2019 and narrow Borough to the one that you're interested in.

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

Closed

2019-02-18T00:00:00.000

2026-10-02T00:00:00.000

4716

Data Question

Agency not assigned yet.

Did Boston Properties @399 Park Ave NY NY get a permit to grind and have trucks removing materials from building this Federal holiday 2/18/19, driving the entire 54th street nervous making noise from early this morning.
Boston Properties are doing constructions 7 days a week from morning to late night , through their loading dock on 54th Street causing great noise, grinding,dust, dirt, without end. Did you give them permit to cause this for 7 days a week? on week ends also?

No URL Submitted.

Hi,

I do not see any After Hours Variance permits for this address. I am unable to process complaints through open data. I will forward your report internally this time. In future, please submit a Construction Noise Complaint through 311. These complaints go directly to our inspectors. Please submit your complaint through 311 at https://www1.nyc.gov/nyc-resources/service/2090/noise-from-construction so that we can make sure this gets investigated properly.

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

Closed

2019-02-18T00:00:00.000

2026-10-02T00:00:00.000

4706

Data Question

Department of Health and Mental Hygiene (DOHMH)

Has there been a change in the way you update your datasets? The above linked dataset has been consistently updated daily up until February 6th. There hasnt been an update since. Is the person doing the updates on vacation or something? If you have any information on when the updates will continue, please let me know. Thank you and have a great day!

DOHMH New York City Restaurant Inspection Results

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that this dataset was updated with the latest available information.

Thank you,
- NYC Open Data Team

Closed

2019-02-14T00:00:00.000

2026-10-02T00:00:00.000

4702

Reported Error

Department of Citywide Administrative Services (DCAS)

Hello, I sent an earlier e-mail stating that I did not find my name in the data set containing list of eligible candidates for exam #7001. Please disregard that e-mail as on second look I see my name on the list. I TAB'ed forward instead of scrolling down page. I apologize for any unnecessary work my inquiry may have caused. Have a great day.

Civil Service List (Active)

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

User withdrew this inquiry.

Closed

2019-02-13T00:00:00.000

2026-10-02T00:00:00.000

4701

Reported Error

Department of Citywide Administrative Services (DCAS)

The Fire Fighter Exam list# 7001 does not contain my name in the list of eligible candidates. I have received by mail and verified via automated system my 'Notice of Results' score and eligible list score. *** and *** respectively, but yet my information is not in this Data set. How on earth would I be called? Please call or e-mail me to resolve this issue.

Civil Service List (Active)

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

User withdrew this inquiry.

Closed

2019-02-13T00:00:00.000

2026-10-02T00:00:00.000

4690

Data Question

Department of Finance (DOF)

Hey,

Firstly, thanks for this amazing product offering. Go NYC!

Does the ACRIS data only publish at the end of each month? It looks like there is nothing after 1/30/2019

ACRIS - Real Property Master

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

The data is updated monthly and the new data is usually available by the 8th of the month.

Closed

2019-02-11T00:00:00.000

2026-10-02T00:00:00.000

4689

Data Question

Citi Bike

I want to download this dataset, but the access the dataset opens the file, but i need to know how to download it.
Thanks.

Citi Bike Live Station Feed (JSON)

​​Thank you for contacting NYC Open Data Help Desk. For technical questions/issues, you are encouraged to contact Citi Bile directly at https://help.citibikenyc.com/hc/en-us
​
​Thank you,
​-NYC Open Data Team

Closed

2019-02-11T00:00:00.000

2026-10-02T00:00:00.000

4685

Reported Error

Department of Citywide Administrative Services (DCAS)

I am writing to inform that my residency credit was not applied for the FDNY open competitive exam 7001. I’d like to be advise on how to proceed with this matter.

Civil Service List (Active)

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

Agency representative directly contacted this user

Closed

2019-02-10T00:00:00.000

2026-10-02T00:00:00.000

4684

Data Question

Agency not assigned yet.

Hi, do you know how can i make the data shows on the map? Now i can't use the map.
Thanks

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please be advised that we have added Location1 column to this dataset that you can use to create maps. For more information on how to create maps please refer to https://support.socrata.com/hc/en-us/sections/360000042208-Maps
Also, please note that the Location1 column only provides data for those records that have Latitude and Longitude values. ​ ​

Thank you,
- NYC TLC Open Data Team

Closed

2019-02-10T00:00:00.000

2026-10-02T00:00:00.000

4680

Data Question

Department of Finance (DOF)

I can't seem to access the JSON file for the "ACRIS - Real Property Master" dataset. I am trying the URL below.

https://data.cityofnewyork.us/resource/bnx9-e6tj.json

ACRIS - Real Property Master

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

Thank you for contacting NYC Open Data Help Desk. Please be advised that API call has a built-in limit of 1,000 records. In order to increase the number of records generated by your JSON query, ​please use the $limit parameter. For more information, please visit this link:
​https://dev.socrata.com/docs/queries/limit.html
​
Thank you,
- NYC Open Data Team

Closed

2019-02-08T00:00:00.000

2026-10-02T00:00:00.000

4679

Data Question

311

Why isn't the following service request included in this data set?

311 Service Request *** which was created on 12/27/2018 3:32:27 PM to report to DEP a hydrant running/leaking at ***.

311 Service Requests from 2020 to Present

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

The Service Request you have provided is an "Agency Issue/Complaint", which is a category of Service Request not currently published as an open data set. Because there were several calls made about the same underlying fire hydrant issue, the 311 Customer Service Representative categorized Service Request *** as an Agency Issue

Thank you,
- NYC Open Data Team

Closed

2019-02-08T00:00:00.000

2026-10-02T00:00:00.000

4677

Data Question

Department of Buildings (DOB)

The description says "A list of permits issued for a particular day and associated data. Prior weekly and monthly reports are archived at DOB and are not available on NYC Open Data." I'm confused as to the specifics of this- does that means records from a week ago aren't included? There are significant gaps in the data and we're trying to figure out how the data is gathered/logged in this set to better understand if we can use it.

DOB Permit Issuance

Hi,

I've been meaning to replace that confusing description for a while. I just updated it with something that I hope is more helpful. Please also check out the Data Dictionary for more information about this dataset. (On the dataset info page under Attachments.)

If you are finding significant gaps in the data, please provide more detail and I will have my team investigate.

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

Closed

2019-02-08T00:00:00.000

2026-10-02T00:00:00.000

4674

Data Question

Agency not assigned yet.

Is it possible to obtain a list of Buildings in NY City; ranging from mid-size to large skyscraper structures? I would like to find out who owns a building or what company manages the building.

The problem I’m facing is if I search for property management companies their SIC codes ranges from Real Estate Agents & Managers to Developers.
Example: The Durst Organization is classified as a Real Estate Agents & Managers and NOT a Property Management classification.

NYC Open Data does give some insight into a few structures such as “Managed Public Buildings” but I cannot seem to locate a dataset that seems well encompassing.
Researching sources such as Wikipedia will only give you a handful of the obvious landmarks.

My interest in researching NYC Buildings is to seek a business relationship with the management or ownership company.

My direct contact number:

Thank you,

No URL Submitted.

Hi,

Department of Buildings data can help you partway. In our DOB Job Application Filings dataset, the Building Type field has values of 1-2-3 Family or Others. You want to look at Others. This field is required for every single record, so it's the most reliable way to get you partway there.

If you want to limit the list some more, you might want to use some of the other filters as well, like Owner Type or Proposed Occupancy. These are not required fields for every record, so many records will be blank. Just note that if you restrict to a certain value, you'll be excluding blanks that might help you.

Please read our Data Dictionary for additional assistance. (On the dataset info page under Attachments.)

For ownership information, you might try Department of Finance. For management company, I don't think the city deals with them because that's a business relationship with the building owner directly.

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

Closed

2019-02-07T00:00:00.000

2026-10-02T00:00:00.000

4672

Data Question

Agency not assigned yet.

Where can I find a description of the fields in all of the different ACRIS datasets? Thanks.

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. For column descriptions, please refer to the ACRIS_Public_OpenData_Guide.doc found in the Attachments section of this dataset.
​
Thank you,
- NYC Open Data Team

Closed

2019-02-07T00:00:00.000

2026-10-02T00:00:00.000

4667

Data Question

Agency not assigned yet.

Hi, I was looking at the NYCHA resident data book summary and was wondering if the development-level data exist. The data dictionary attached to the file seems to suggest that this dataset would be at the development-level, as is the case with the NYCHA Development Data Book dataset. Thanks!

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please kindly direct this request to the FOIL unit via the following link:
​https://www1.nyc.gov/assets/nycha/downloads/pdf/nycha-foil-request-form.pdf

Thank you,
​- New York City Housing Authority

Closed

2019-02-06T00:00:00.000

2026-10-02T00:00:00.000

4660

Data Question

Department of Finance (DOF)

What years does this dataset cover? I only see 2010/2011 when I view the dataset so I was just curious.
Thank you!!

Property Valuation and Assessment Data

https://data.cityofnewyork.us/d/yjxr-fw8i

The dataset covers property tax assessment data for the fiscal year 2010/2011.


Regards,
DOF

Closed

2019-02-05T00:00:00.000

2026-10-02T00:00:00.000

4652

Reported Error

Agency not assigned yet.

Our Open Data stopped updating on 1/24/2019. It is supposed to update daily.

No URL Submitted.

issue was resolved internally by the agency

Closed

2019-02-05T00:00:00.000

2026-10-02T00:00:00.000

4650

Data Question

Department of Finance (DOF)

Socrata Support referred me to this help desk. Question is, " can DOF, the "dataset owner" update the OPEN Data Parking Violations Dataset daily? For example, NYCServe is updated in real time, but is not user friendly. It would be
very useful to have daily updates. Thank you.

Open Parking and Camera Violations

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

​Thank you for contacting NYC Open Data Help Desk.​ Summons that are satisfied are updated daily; new issuance is updated weekly.

Thank you,
- NYC Department of Finance

Closed

2019-02-04T00:00:00.000

2026-10-02T00:00:00.000

4649

Data Question

311

Hi, I am using above URL to download 311 open data on daily basis. i am receiving error now:
{"message":"Invalid SoQL query","errorCode":"query.soql.invalid","data":{}}
is there any issue with URL or anything updated let me know

311 Service Requests from 2020 to Present

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

​​​Thank you for contacting NYC Open Data Help Desk. For technical issues, you are encouraged to contact Socrata support at
https://support.socrata.com/hc/en-us
​
​​Thank you,
​- NYC Open Data Team

Closed

2019-02-04T00:00:00.000

2026-10-02T00:00:00.000

4646

Data Question

Department of Environmental Protection (DEP)

1. Some of the entries have no # of boilers - does that mean it has a furnace rather than a boiler? What is being registered or certified? Example: Reuqest ***/Application ***.
2) Some list the quantity but do not list the fuel - example Request ***/Application ***, issued 9/22/2017. Does that mean the agency doesn't know or didn't record it?
3) Many list "none" for the fuel. If they are not using fuel, why do they need a certificate to operate? Does it mean they are electric? Example Request ***/Application ***.
Thank you!

Clean Air Tracking System (CATS) Permits

https://data.cityofnewyork.us/d/f4rp-2kvy

Please find the responses to your questions about the CATS Permit dataset below:

Note - the CATS Permit dataset includes boilers and industrial process sources applications. Application IDs that begins with “C” are boilers and “P” are industrial sources.

Q1 - Some of the entries have no # of boilers - does that mean it has a furnace rather than a boiler? What is being registered or certified? Example:

A1 - This not a boiler it is an auto body spray booth

Q2 - Some list the quantity but do not list the fuel - issued 9/22/2017. Does that mean the agency doesn't know or didn't record it?

A2 - This is not a boiler, it is a permit for woodworking operations and dust collectors.

Q3 - Many list "none" for the fuel. If they are not using fuel, why do they need a certificate to operate? Does it mean they are electric?

A3 - This is not a boiler it is a permit for printing equipment.

Thank you!


Thank you,
- NYC DEP Open Data Team

Closed

2019-02-04T00:00:00.000

2026-10-02T00:00:00.000

4643

Reported Error

Department of Housing Preservation and Development (HPD)

The column "CensusTract" is formatted in such a way that makes it difficult (impossible?) to use. The documentation describes the format of the field as being "in the format of up to four-digit integers, followed by an optional two-digit suffix; e.g., “15.02” or “319”)" However the "." is missing from the field and so needs zero-padding on both the left and right and it's not easy/possible to determine where the padding should go. For example, "102" could either be "102.00" or "1.02", and with padding they would be "010200" or "000102", respectively. It would be helpful if the field could either be a 6-character string with the proper zero-padding already (preferred) or include the decimal so users can do it themselves. Thanks for your consideration.

Housing Maintenance Code Violations

https://data.cityofnewyork.us/d/wvxf-dwi5

Thank you for contacting NYC Open Data Help Desk and reporting this issue. ​This information will be taken into consideration for the Geosupport software future releases.
​
Thank you,
- NYC Open Data Team

Closed

2019-02-01T00:00:00.000

2026-10-02T00:00:00.000

4641

Reported Error

Department of Buildings (DOB)

About a month ago this dataset had not updated for a while and I inquired and then it had an update and they told me. I think somebody had to kick it or something. Now a month later this data is still not updating. Its supposed to update weekly but says it has not updated since January 9th. Can you please see what is going on with this, this data is very important to us.

DOB Violations

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

Hi,

We were able to fix this dataset on February 4, and I've been closely monitoring it since. It seems to be running with no problems now and I will keep an eye on it. I have instituted a monitoring process for all of our datasets to ensure we catch downtime like this more quickly. Thank you for your report, and let us know if you encounter any other issues.

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

Closed

2019-02-01T00:00:00.000

2026-10-02T00:00:00.000

4630

Data Question

Office of Technology and Innovation (OTI)

For the elevation data set what is the vertical datum that is used? I see NAD83 for planimetric data but I cannot find a vertical datum on the site. I was hoping to convert to NAVD88 if it is not done so already. I am looking at spot elevations for Leonard Street in NYC, on the corner of Leonard and Varick.

NYC Planimetric Database: Elevation Points

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

​Thank you for contacting NYC Open Data Help Desk. The vertical datum for planimetric data is NAVD88; however, this datum only applies to the Elevation point features. None of the rest of the planimetric features have elevation values or other vertical reference information. DoITT is reviewing this to be sure and will update the metadata as necessary, noting the use of the NAVD88 vertical datum where appropriate.

Thank you,
- NYC Open Data Team

Closed

2019-01-31T00:00:00.000

2026-10-02T00:00:00.000

4627

Data Question

Agency not assigned yet.

We have a client who was injured at 1250 Broadway on 6-19-18. I'm looking to find out who the Project Manager for the entire job is. I've tried the public portal but it only lists the individual trade contractor company names. I need the boss of the entire project...PLEASE :)

No URL Submitted.

Hi,

We publish the names on the PW-1 application for the job. We do not have the names for other people working at the company.

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

Closed

2019-01-31T00:00:00.000

2026-10-02T00:00:00.000

4618

Data Question

Agency not assigned yet.

I don't understand how you determine the Poverty figures (# and %) for individual schools as it doesn't reflect our schools' Free & Reduced Lunch numbers. Can you tell me more about the source of the Poverty data?

No URL Submitted.

The dataset is created by the Report and Policy Research Group. Please feel free to contact them at RPSGresearch@schools.nyc.gov.

NYC DOE “Poverty” counts are based on the number of students with families who have qualified for free or reduced price lunch, or are eligible for Human Resources Administration (HRA) benefits. In previous years, the poverty indicator also included students enrolled in a Universal Meal School (USM), where all students automatically qualified, with the exception of middle schools, D75 schools and Pre-K centers.

In 2017-18, all students in NYC schools became eligible for free lunch. In order to better reflect free and reduced price lunch status, the poverty indicator does not include student USM status, and retroactively applies this rule to previous years. Please note that this is different from previous years of the demographic snapshot, and so poverty data will not match earlier demographic snapshots.
Thank you,
- NYC Open Data Team

Closed

2019-01-28T00:00:00.000

2026-10-02T00:00:00.000

4610

Reported Error

City Council (NYCC)

This dataset is out of date! It doesn't reflect the 2017 City Council elections.

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

2019-01-25T00:00:00.000

2026-10-02T00:00:00.000

4603

Data Question

Agency not assigned yet.

The title seems to say it covers from 2010 to June 2018 but the table of data does not provide data year by year and does not say what year the data is for.

No URL Submitted.

Thank you for contacting NYC Open Data Help Desk. Please be advised that the following three columns in this dataset contain the date-related information:
​
​Revenue Month (Year and month of bill)
Service Start Date (Bill start date)
Service End Date (Bill end date)

​For example, filtering this dataset for Revenue Month is between 2014/01 and 2014/12 will generate a list of over 18K records for the 2014.
​
​For more information on how to use the filtering feature, please refer to https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View

​Thank you,
- NYC Open Data Team

Closed

2019-01-23T00:00:00.000

2026-10-02T00:00:00.000

4600

Data Question

Agency not assigned yet.

I am looking for this data set showing all currently registered .NYC domains that also includes registrant data so i can identify who the top holders of .NYC domains are. Is this available?

A list of just the registrants who have 50+ .nyc domain in their portfolio would also be a helpful alternative.

Thank you.

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please be advised that this inquiry falls under FOIL request. Please submit this request to the Open Records FOIL portal at
​https://a860-openrecords.nyc.gov/

Thank you,
- NYC Open Data Team

Closed

2019-01-23T00:00:00.000

2026-10-02T00:00:00.000

4597

Data Question

Agency not assigned yet.

Directory of NYCHA Community Facilities - Current Iteration. Having difficulties downloading the data set.

Seeking space for a program to benefit the community. Looking to see which space is available and to see how our program compares to existing ones.

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. For technical related issue, you are encouraged to ​Socrata support at https://support.socrata.com/hc/en-us

Thank you,
- NYC Open Data Team

Closed

2019-01-23T00:00:00.000

2026-10-02T00:00:00.000

4593

Data Question

New York City Police Department (NYPD)

I am looking for 2018 crime data but this data set only goes through June 30th. I see that it was last updated in October 2018. I was wondering when I could expect the complete record of 2018 complaint data. Thanks.

NYPD Complaint Data Current (Year To Date)

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

Yes, we are aware of the lag in the 2018 data. We are actively working on updating this dataset as well as the other posted on the site. We expect to have them ready in the next few weeks.
We appreciate your feedback and your patience.
Thanks.

Closed

2019-01-22T00:00:00.000

2026-10-02T00:00:00.000

4590

Data Question

Agency not assigned yet.

Lookin to see if Permit 120697683-01-EW-OT has been closed and a C of O issued.
BIN 1086514

No URL Submitted.

Hi,

When you're looking at a specific case like this, I recommend that you look at our BIS database instead of Open Data. The permit you reference is part of the overall Job #120697683. The status of this job is that all permits have been issued. When the work is complete, the applicant must come back to DOB to get final paperwork.

You ask about a Certificate of Occupancy. This particular job is an Alteration Type 2 with no change in use, egress, or occupancy. So there will be no need to issue a new C of O when the work is complete.

Thank you,
- , DOB Open Data Coordinator

Sign up for our Open Data mailing list here.

Closed

2019-01-22T00:00:00.000

2026-10-02T00:00:00.000

4588

Reported Error

Agency not assigned yet.

Hello,

It appears not all of the boroughs are shown in the Food Scrap Drop Off Sites API. I checked this endpoint about two weeks ago and it included The Bronx. I have been coming back for the past 5 days and the Bronx is missing. It returns an empty array.

Is there a reason for this?

Thank you,

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please be advised that the dataset mentioned above contains outdated (historical) ​data from 2012 and does not reflect current information. To access the latest available data, please refer to DSNY Food Scrap Dropoff Locations Official dataset at https://data.cityofnewyork.us/City-Government/DSNY-Food-Scrap-Dropoff-Locations-Official/rq4r-at5j
​
Thank you,
- NYC Open Data Team

Closed

2019-01-22T00:00:00.000

2026-10-02T00:00:00.000

4585

Reported Error

Department of Transportation (DOT)

This endpoint for parking regulation signs returns the following error:

{
"error" : true,
"message" : "no row or column access to non-tabular tables"
}

Is this endpoint undergoing maintenance?

What I would like to access is latitude and longitude data for these signs. The metadata for this endpoint doesn't seem to include latitude and longitude. Instead, it has street, cross streets, and distance from respective intersections. However, I saw on https://nycdotsigns.net/ that I can download sign info complete with coordinates. Is the endpoint I included above the right endpoint for retrieving this data? Will this endpoint include coordinate data when it is operational again? Is there another endpoint I should be using?

Parking Regulation Locations and Signs

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

​Thank you for contacting NYC Open Data Help Desk. Please be advised that Parking Regulation Locations and Signs dataset is not available on the portal as a tabular data and cannot be accessed through JSON. You can access this data by downloading shapefile directly from this dataset's landing page at this URL: https://data.cityofnewyork.us/Transportation/Parking-Regulation-Locations-and-Signs/xswq-wnv9. The lat/long information is contained within this shapefile once opened in an appropriate application.

Thank you,
- NYC Open Data Team

Closed

2019-01-20T00:00:00.000

2026-10-02T00:00:00.000

4582

Data Question

311

Hello,
My name is *** and I am currently a senior at ***. I am from NYC and am working on a thesis that is looking at the relationship between gentrification and 311 calls in NYC. I have located 311 Service Request data on Open Data from 2004 - 2009. The additional URLs are as follows: https://data.cityofnewyork.us/Social-Services/311-Service-Requests-for-2004/sqcr-6mww, https://data.cityofnewyork.us/Social-Services/311-Service-Requests-for-2005/sxmw-f24h, https://data.cityofnewyork.us/Social-Services/311-Service-Requests-for-2006/hy4q-igkk, https://data.cityofnewyork.us/Social-Services/311-Service-Requests-for-2007/aiww-p3af, https://data.cityofnewyork.us/Social-Services/311-Service-Requests-for-2008/uzcy-9puk, and https://data.cityofnewyork.us/Social-Services/311-Service-Requests-for-2009/3rfa-3xsf. I had an inquiry in regard to the categorizations used in the datasets. I noticed that "Noise-Residential" was a new category that appeared only in the "2010-Present" dataset but not in the respective datasets from 2004-2009. I am wondering if this is because the city saw a spike in the number of 311 calls made in regard to residential complaints that this new category came about or if 311 just decided to re-categorize their data differently starting from 2010 onwards. In other words, I want to make sure the datasets from 2004 - present are comparable on an annual basis. Information in regard to how categorizations were made would be extremely helpful. Furthermore, I was wondering how the accessibility/platforms of 311 has changed from 2004 - Present (e.g. apps, text, etc). If possible, can we also see what the breakdown of how requests are made is like for years 2004 to 2016. In other words, what proportion of the 311 requests are made via phone calls versus texts versus the 311 app? Thank you in advance for your help!

311 Service Requests from 2020 to Present

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

Agency representative directly contacted this user

Closed

2019-01-18T00:00:00.000

2026-10-02T00:00:00.000

4580

Data Question

New York City Fire Department (FDNY)

Hello, can FDNY update this data set more often, daily is preferred, or when their internal books are updated, which I believe is weekly.

Bureau of Fire Prevention - Active Violation Orders (Historical)

https://data.cityofnewyork.us/d/bi53-yph3

Thank you for your dataset request. We will forward it along to the appropriate unit and you should have a response within the next two weeks.

Closed

2019-01-18T00:00:00.000

2026-10-02T00:00:00.000

4578

Reported Error

New York City Police Department (NYPD)

data has not been updated since 11/16/2018. Usually it is updated weekly or more often .

Motor Vehicle Collisions - Crashes

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

Thank you for contacting NYC Open Data Help Desk. Yes, we are aware of the lag in the 2018 data. We are actively working on updating this dataset as well as the other datasets posted on the site. We expect to have them ready in the next few weeks.
We appreciate your feedback and your patience.

Thank you,
- New York City Police Department

Closed

2019-01-17T00:00:00.000

2026-10-02T00:00:00.000

4576

Data Question

Agency not assigned yet.

Requesting dataI have made numerous unanswered
inquiries about purchasing the following data:

All property permits filed since 2013

The data I require is as follows:

Address of property
Borough
Building size
Building type
Owner and its mailing address

I hope that finally you will provide
me with an answer.

No URL Submitted.

Hi,

As we discussed on the phone, you can get the information you need from the open data portal. If you need help with it, please feel free to contact me. My phone number is 212-393-2772 and my email address is cnicklin@buildings.nyc.gov.

Thank you,
- , DOB Open Data Coordinator

Closed

2019-01-17T00:00:00.000

2026-10-02T00:00:00.000

4574

Reported Error

New York City Police Department (NYPD)

I've downloaded the CSV version and there are several issuses (I found only three of them) and i found them while i was splitting the CSV among the coloumns in Excel; there are some "," in wrong places so the splitting process fails in some points.

Motor Vehicle Collisions - Crashes

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

Thank you for contacting NYC Open Data and reporting this issue. Please kindly provide us with specific records where this issue was observed so we can review and determine whether it is a data error or expected behavior.

Thank you,
- NYC Open Data Team

Closed

2019-01-17T00:00:00.000

2026-10-02T00:00:00.000

4573

Reported Error

Department of Finance (DOF)

is it possible to increase the length of the "streetname" field? There are many records that are at the max field size (20 characters) yet the data in the field is incomplete.
I can provide and extract of all the truncated records.
Here is a sample:
summons_number, issue_date, streetname, intersecting_street
*** 12/26/2018 Frederick Douglass B

Parking Violations Issued - Fiscal Year 2027

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

​Thank you for contacting NYC Open Data Help Desk. Your suggestion will be reviewed for a future enhancement.

​Thank you,
- NYC Department of Finance

Closed

2019-01-17T00:00:00.000

2026-10-02T00:00:00.000