NYC Open Data Help Desk: Data Questions and Reported Errors

8458

Reported Error

Department of Buildings (DOB)

Hello there,

I've noticed that the "DOB NOW: Build - Job Application Filings" hasn't been updated in over a week.

Is there a new dataset that is being updated that I missed or is something wrong with this dataset and is being addressed?

I appreciate your help with this.

Thank you,
-- *****

DOB NOW: Build – Job Application Filings

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

Thank you for bringing this issue to our attention. The dataset has now been updated with the latest available information.

Thank you,
- NYC Open Data Team

Closed

2022-02-14T00:00:00.000

2026-10-02T00:00:00.000

8455

Data Question

311

In particular, we would like to know if the "Incident Address" tab is automatically recorded each call or does the agency ask the caller to get the information?

In a particular case, is it safe to suggest that the "Incident Address" is the exact address of the incident or just where the call was made?

For instance, there are calls about air quality with an incident address at ***** Avenue, would it be safe to say that the air quality complaint pertains to that address?

311 Service Requests from 2020 to Present

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

The incident address is identified by the customer and geo-validated by our system. The incident address is the location of the incident as reported by the customer. There is no relationship to where the customer is located at the time of the report, except in the case of mobile app SRs - the app will show the users location on a map if the user has location services enabled. The user in that case would have to confirm the location as the incident location. You can see the source channel in the ‘Open Data Channel Type’ column.

You can assume the incident address is the location of the incident or condition, as in your air quality example.

Thank you,
- NYC 311 Open Data

Closed

2022-02-11T00:00:00.000

2026-10-02T00:00:00.000

8453

Reported Error

Department of Buildings (DOB)

Hi there, I noticed this dataset has not been updated this week, usually it's updated daily.

Can you check on this? Appreciate your help

DOB NOW: Build – Job Application Filings

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

Thank you for bringing this issue to our attention. The dataset has now been updated with the latest available information.

Thank you,
- NYC Open Data Team

Closed

2022-02-10T00:00:00.000

2026-10-02T00:00:00.000

8450

Data Question

311

Are the lat/lon coordinates that of the caller or that of the location of the issue?
Thank you!

311 Service Requests from 2020 to Present

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

The incident address is identified by the customer and geo-validated by our system. The incident address is the location of the incident as reported by the customer. There is no relationship to where the customer is located at the time of the report, except in the case of mobile app SRs - the app will show the users location on a map if the user has location services enabled. The user in that case would have to confirm the location as the incident location. You can see the source channel in the ‘Open Data Channel Type’ column.

Thank you,
- NYC 311 Open Data

Pending

2022-02-08T00:00:00.000

2026-10-02T00:00:00.000

8448

Data Question

Department of Finance (DOF)

Hello,

*****, LLC annually acquires the Real Estate Assessment Property Data via the NYC open data portal. At this time, we would like to inquire about why this file is provided with street or house number ranges. Can you confirm if specific street numbers are available to be acquired?

Below is an example.

HOUSENUM_LO = 200, HOUSENUM_HI = 214 and STREET_NAME = MADISON AVENUE

Thank you,
*****

Property Valuation and Assessment Data Tax Classes 1,2,3,4

https://data.cityofnewyork.us/d/8y4t-faws

There are datsets with specific addresses, but they are not available on the public portal because of data privacy. You may be able to request the information through FOIL. If you plan to do so, please provide a clear description of the data elements you are looking for in the FOIL request.





Thank you,
- NYC DOF

Closed

2022-02-07T00:00:00.000

2026-10-02T00:00:00.000

8447

Reported Error

Agency not assigned yet.

My family and I were victims of stalking and a violent attack in 2014. We have erased all our new address information from the internet however you have an expired license in my name with my address and phone number. Please remove it or let us know what steps are necessary to have this information removed. Thank you.

No URL Submitted.

Response not sent yet.

Pending

2022-02-07T00:00:00.000

2026-10-02T00:00:00.000

8446

Data Question

Agency not assigned yet.

Good afternoon, I am a student at SUNY Potsdam looking at the shooting incident in NYC in 2020 datasets from your website.I'm writing today about some confusion .The problem i am having is that the GPS points in the map didn't correspond with the information in the attribute table. For example a GPS point appears in Queens but the feature describes it at being in a precinct in the Bronx. Is there anything I am misunderstanding about whats the points on the map are representing? Any advice or further information would be helpful. This is for class research for GIS.

No URL Submitted.

Unfortunately, the issue you describe can be replicated. Can you edit your response to include additional details?

Thank you,
- NYC Open Data Team

Pending

2022-02-07T00:00:00.000

2026-10-02T00:00:00.000

8439

Reported Error

Department of Buildings (DOB)

Hi. I have written before and someone said they would look into issue. Then I was told the problem was fixed. But it isn’t.

The problem: The list of permits issued is very very old. There is hardly a listing that isn’t 10 years old or older. Yet it says the list is updated daily.

How can I find a recent list of permits. Thanks.

DOB Permit Issuance

Response not sent yet.

Pending

2022-02-04T00:00:00.000

2026-10-02T00:00:00.000

8438

Reported Error

Department of Buildings (DOB)

Hello, the `Job Description` field is getting cut off and or truncated.

DOB NOW: Build – Approved Permits

https://data.cityofnewyork.us/d/rbx6-tga4

Thank you for bringing this issue to our attention. The dataset has now been updated with the latest available information.

Thank you,
- NYC Open Data Team

Closed

2022-02-04T00:00:00.000

2026-10-02T00:00:00.000

8428

Data Question

Agency not assigned yet.

I have been using this data set for a while. Yesterday my code stopped working. Was an update made to this dataset that rendered it unable to search on lat and lng? I searched to see if there was a newer dataset and did not find one. Thanks for your help.

No URL Submitted.

Response not sent yet.

Pending

2022-02-01T00:00:00.000

2026-10-02T00:00:00.000

8426

Data Question

Agency not assigned yet.

Hi, I am looking at Open Streets Data and have an error to report + a question:

1) The map of Open Streets is not being displayed correctly. Is there a georeferenced geopackage or shape file with the data that I can download and map it myself?

2) The Open Streets data seems to be updated to reflect only streets currently in the program (last update was Dec. 6). That is, some rows are deleted with every update. Is there a version of the dataset in its entirety, with all the rows that were ever made public? That is, I am interested in data on streets that were a part of Open Streets in the past, but may not currently be.

Thank you so much, and hope you have a nice week.

No URL Submitted.

Original:
Thank you for your request for Open Streets Locations shapefile dataset. The New York City Department of Transportation (NYC DOT) is currently working on releasing all Open Streets Locations in shapefile format. It is projected to be completed by 2/28/2022. Sign up for the Open Data mailing list to get the latest updates. NYC DOT will also send out an email when the dataset is live.

Thank you,
- NYC DOT Open Data Team

Follow-up Response:
The Open Streets dataset was updated, it is now available in Excel/CSV and Shapefile. It contains all locations, active locations have open and close times.
Open Street Locations: https://data.cityofnewyork.us/Health/Open-Streets-Locations/uiay-nctu

Thank you,
- NYC DOT Open Data Team

Closed

2022-02-01T00:00:00.000

2026-10-02T00:00:00.000

8421

Reported Error

Agency not assigned yet.

my vehicle TLC License Plate ***** is no in the List for working. why?

No URL Submitted.

Your TLC license is currently listed as active.

In the future, you can reach out to the Licensing Division at licensingi@tlc.nyc.gov.
Best,
Ted
TLC + NYC OpenData

Closed

2022-01-30T00:00:00.000

2026-10-02T00:00:00.000

8414

Reported Error

Agency not assigned yet.

Columns for Special Inspection Agency Number and Progress Inspection Requirement are seemingly mismatched.

No URL Submitted.

This email has come directly to someone at the Dept. of Buildings. Your concern was reviewed and the issue was brought to the attention of DOITT. It is in they who must resolve it.

Thank you,
NYC Open Data Team

Pending

2022-01-26T00:00:00.000

2026-10-02T00:00:00.000

8413

Data Question

Department of Transportation (DOT)

Does the data specify when the improvements on sidewalks will take place? I see issue start and issue end dates. But am not sure if this indicates that the works have started or ended. Thanks!

Street Construction Permits (2022 - Present)

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

Thank you for your question on the Street Construction Permits dataset.
Sidewalk improvement projects begins on the date listed in the "IssuedWorkStartDate" column and the work must end by "IssuedWorkEndDate".
The "PermitIssueDate" may be different from the "IssuedWorkStartDate".
Thank you,
- NYC DOT Open Data Team

Closed

2022-01-26T00:00:00.000

2026-10-02T00:00:00.000

8412

Data Question

Department of Buildings (DOB)

None of these permits were issued recently at all - not even within the past few years.

I am interested in data showing recent permits being issued.

Also almost the entire list shows the permits as being for one-family home, no three-family at all and no ‘other.’

I am looking for data that will give me a sense of how many new multi-unit buildings are being built. Thanks.

DOB Permit Issuance

Response not sent yet.

Pending

2022-01-25T00:00:00.000

2026-10-02T00:00:00.000

8410

Data Question

Agency not assigned yet.

Can the NYCDOE School Survey Data for 2017-2018 for Student responses be disagregated for students for MS Grades 6, 7 and 8 by gender and ethnicity by schools in the borough of Queens? specifically I am looking how black girls in middle school responded on each question by school compared to boys.

No URL Submitted.

You can find the list of datasets maintained by the Department of Education here:
https://data.cityofnewyork.us/browse?Dataset-Infor...

While The NYC DOE Open Data team is committed to making City data available for anyone to access online, we however, cannot accommodate requests to perform individual lookups or queries for single data points or records available in a Open Data dataset.
For more help with your request please use the following resource: https://infohub.nyced.org/working-with-the-doe/res...

Thank you,
- NYCDOE Open Data Team

Closed

2022-01-25T00:00:00.000

2026-10-02T00:00:00.000

8408

Data Question

Agency not assigned yet.

HI

i am unable to change my preference in profil to stop receiving notification

No URL Submitted.

Response not sent yet.

Closed

2022-01-24T00:00:00.000

2026-10-02T00:00:00.000

8405

Data Question

Department of Buildings (DOB)

Job filing #Q00637482 appears in the DOB's Public Portal (https://a810-dobnow.nyc.gov/publish/Index.html#!/search) with the Work Type 'PL,' however, in the NYC Open Data set for DOB NOW Job Applications the value for 'Plumbiing' is 'False.' How is this difference or disparity in data explained?

DOB NOW: Build – Job Application Filings

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

Response not sent yet.

Pending

2022-01-21T00:00:00.000

2026-10-02T00:00:00.000

8398

Data Question

Agency not assigned yet.

This dataset doesn't appear to have been updated this month. It appears that it is normally updated on the 15th of each month. Perhaps wires got crossed because of the holiday weekend? Please advise.

No URL Submitted.

Thank you for bringing this issue to our attention. This dataset is now updated with the latest available information.

Thank you,
- NYC Open Data Team

Closed

2022-01-19T00:00:00.000

2026-10-02T00:00:00.000

8397

Reported Error

Department of Buildings (DOB)

this dataset has not been updated in 11 days as of today

DOB NOW: Build – Approved Permits

https://data.cityofnewyork.us/d/rbx6-tga4

Thank you for bringing this issue to our attention. The dataset has now been updated with the latest available information.

Thank you,
- NYC Open Data Team

Closed

2022-01-19T00:00:00.000

2026-10-02T00:00:00.000

8396

Data Question

Agency not assigned yet.

Greetings,

Is there a way to upload an excel file to find districts by address? We're trying to organize our reporting to show our constituents by district and being able to batch this would be a major time savor for us.

Thank you so much for your help!

Best,

*****

No URL Submitted.

Unfortunately, what you are inquiring about is not something we are able to help you troubleshoot. We have added the support team for Socrata, the vendor for the NYC Open Data Platform, to this email thread in order to help address this issue.

Thank you,
- NYC Open Data Team

Closed

2022-01-18T00:00:00.000

2026-10-02T00:00:00.000

8395

Data Question

Department of Finance (DOF)

Kindly update this dataset with the FY2023 Tentative Property Assessment Data. Thanks!

Property Valuation and Assessment Data Tax Classes 1,2,3,4

https://data.cityofnewyork.us/d/8y4t-faws

The dataset is now updated with the 2023 Tax Year tentative assessment data.


Thank you,
- NYC DOF

Closed

2022-01-18T00:00:00.000

2026-10-02T00:00:00.000

8388

Data Question

Department of Finance (DOF)

hi.
is there a guide avalable to what does each data column represent?

I am looking for last sold date on a property.

i.e. 123 main st sold on 01/01/2000.

Is this data point available in this data set?

Property Valuation and Assessment Data Tax Classes 1,2,3,4

https://data.cityofnewyork.us/d/8y4t-faws

The last date a property was sold will not be on the dataset,
https://data.cityofnewyork.us/City-Government/Property-Valuation-and-Assessment-Data-Tax-Classes/8y4t-faws/data

That information can be found on the DOF Automated City Register Information System (ACRIS).
If you go to nyc.gov/acris and click Begin Using ACRIS, you will see the ACRIS Main Menu:
From there you can Click on Search Property Records to see the Document Search menu and follow the path that is available for your search.

For an ownership changing document, the Doc Date shown on the ACRIS Document Search Screen is the sales date.


Thank you,
- NYC DOF

Closed

2022-01-17T00:00:00.000

2026-10-02T00:00:00.000

8387

Reported Error

Department of Finance (DOF)

We have identified several issues, which suggest an overall problem with data typing or transposed columns:
PARID is now a datetime
Higher than expected values in new rows of SUM_BAL

DOF: Property Charges Balance

https://data.cityofnewyork.us/d/scjx-j6np

Response not sent yet.

Pending

2022-01-17T00:00:00.000

2026-10-02T00:00:00.000

8383

Data Question

Agency not assigned yet.

Hello,

I have also noticed that 2015 and 2016 are only providing data from the year's January to June (as it says). May you help me locating datasets for these whole years or find datasets from June to December so I would have whole year data in one place, please?

No URL Submitted.

Response not sent yet.

Pending

2022-01-14T00:00:00.000

2026-10-02T00:00:00.000

8382

Data Question

Agency not assigned yet.

Hello,

O have noticed that 2010 Yellow Taxi Trip data is missing. May you help me locating it?

No URL Submitted.

Thank you for your interest in TLC Open Data. Below is a link to our complete trip records that you can find on our agency website.
https://www1.nyc.gov/site/tlc/about/tlc-trip-recor...
Best,
Ted
TLC Open Data

Closed

2022-01-14T00:00:00.000

2026-10-02T00:00:00.000

8379

Data Question

Agency not assigned yet.

I created a login to d/l data, GIS shapefile but still getting an error access denied. Please advise what are the rules.. thanks in advance

No URL Submitted.

Response not sent yet.

Closed

2022-01-12T00:00:00.000

2026-10-02T00:00:00.000

8377

Data Question

Agency not assigned yet.

Hello, I am writing to ask if there is a way to view emergency responder travel time by neighborhood? I am doing a paper on how street width impacts response so if there is a way to filter to a neighborhood or precinct average, that would be good.

No URL Submitted.

Response not sent yet.

Pending

2022-01-12T00:00:00.000

2026-10-02T00:00:00.000

8376

Reported Error

Mayor's Office of Management and Budget (OMB)

There are recorded with a publication date on 20200401 that I believe are actually 20210401 because the records include expenditures through 3/3/2021.

Also, data is supposed to be updated quarterly but has not been updated since May 2021. When will updated data be released.

COVID-19 Expenditures Report (Historical)

https://data.cityofnewyork.us/d/thut-5mdg

Thank you for pointing out these issues! Our update procedure is not working properly and we’re working to fix it now. We’ll correct the publication date error you identified, and we’ll post a new dataset update soon. After this initial update we’ll resume our quarterly updates with the next update published in April 2022.

Thank you,
NYC OMB Data Team

Closed

2022-01-12T00:00:00.000

2026-10-02T00:00:00.000

8374

Reported Error

Agency not assigned yet.

It seems like this dataset is supposed to provide disaggregated test score by ethnicity, SWD, etc, but it does not. The same is true for the corresponding file for ELA test scores. The attached documents also do not contain this information.

No URL Submitted.

Response not sent yet.

Pending

2022-01-11T00:00:00.000

2026-10-02T00:00:00.000

8373

Data Question

New York City Police Department (NYPD)

Hello,

I am an academic researcher inquiring about obtaining 2010-2019 NYC incident level crime data.

Is the complaint dataset the appropriate dataset to measure crime in the city? for example, i want to measure the crime rate in a neighborhood. is this the dataset to use as opposed to the arrest (or other) NYPD datasets that are offered on the open portal?

Also, the footnotes state: "Many other offenses that were not able to be geo-coded (for example, due to an invalid address) have been located as occurring at the police station house within the precinct of occurrence." Is there a column in the dataset that allows me to identify these cases?

thank you
*****

NYPD Complaint Data Current (Year To Date)

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

Thank you for your inquiry regarding the NYPD Complaint datset.
Yes, this would be an appropriate dataset for measuring crime. Each record is an incident of a crime that is reported to the NYPD. This is the same way NYPD measures and reports crime.
As for locations geocoded to a precinct, there is no field that identifies these records.

Thank you,
- NYC Open Data Team

Closed

2022-01-11T00:00:00.000

2026-10-02T00:00:00.000

8370

Data Question

New York City Police Department (NYPD)

Edit:
Hi there,

Below find my previous question. I got the helpful response that murders are tracked differently than other complaint data, and that they're anonymized within the block that they occur so that you can't directly geocode them. I have two follow up questions on this.

I see that murders that occur in parks are geocoded to a nearby street. Is there any system to this, like the closest street, or could it be any street? I notice that the upper west side, for example, tends to have a much higher homicide count than the upper east side. Is there a way to know if the west side of the park is absorbing more central park murders than the east?

I'm also wondering if there's any way to tell whether a homicide happens on transit.

Thank you for all your assistance here!

-------
Original:
Good afternoon,

I hope you're doing well! I see in the footnotes for the NYPD Complaint Historic dataset that complaints that occur in parks are geocoded to the nearest street intersection (rather than in the park itself). It appears that for most crimes, the field "PREM_TYP_DESC" indicates where the complaint happened (in a residence, on the street, in a park, etc.). This field is blank for every "murder & non-negligent manslaughter" charge however. I have two questions:

1. Is there a reason that no location is given for murder?
2. Is there a way to determine whether a murder happened in a park or not?

Thank you for your assistance!

Best,
*****

NYPD Complaint Data Historic

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

Original:
Thank you for your interest in the NYPD Complaint dataset.
The records for murder/homicide are maintained separately from other complaints. As such, not all the same fields are tracked. As you noted, one of these fields is the prem_typ_desc, which s why it is null for these rows.
Furthermore, since each complaint is anonymized geographically by moving the incident to the closest mid-block point, there is no way to determine exactly where an incident occurred.

Thank you,
- NYC Open Data Team

Edit/Follow-up Response:
Thank you for your inquiry on the NYPD’s Complaint Historic Dataset, with a focus on the “murder & non-negligent manslaughter” charges occurring in and around Central Park. As previously inquired, the murders are tracked and recorded differently than other complaints make the some of the data fields such as “PREM_TYP_DESC” have null values.

In regards to murders occurring in or around Central Park, a dataset was pulled for the calendar years of 2020 and 2021 to review the actual locations of the murders. During those years, no murders were in Central Park. A way to verify this with open data dataset is to look at the field “ADDR_PCT_CD” which indicates the precinct of occurrence. In this case, the number 22 is used for the Central Park Precinct, which there are no murders for those years.

When it comes to see if a crime happened in a transit jurisdiction, the field “JURIS_DESC” with the value “N.Y. TRANSIT POLICE” would be used.

Thank you again for your inquiry.

Closed

2022-01-11T00:00:00.000

2026-10-02T00:00:00.000

8365

Reported Error

Department of Citywide Administrative Services (DCAS)

I am having trouble accessing this dataset. It seems to not be accessible through any means, such as API or export.

Current Solicitations

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

Thank you for drawing our attention to the error in the Current Soliciations dataset. The error has been resolved and the data are again available on Open Data at: https://data.cityofnewyork.us/City-Government/Current-Solicitations/3khw-qi8f.

Thank you,
- NYC DCAS Open Data

Closed

2022-01-08T00:00:00.000

2026-10-02T00:00:00.000

8360

Data Question

School Construction Authority (SCA)

Data seems to be missing for 2016, as well as years prior to 2015 (2014, at the very least, is available in PDF format: http://www.nycsca.org/community/capital-plan-reports-data#Enrollment-Capacity-Utilization-69). Would be great if it could be updated to include the missing year(s)! Thank you for all you do, NYC Open Data is a great resource.

Enrollment Capacity And Utilization Reports - Target by Organization

Response not sent yet.

Pending

2022-01-07T00:00:00.000

2026-10-02T00:00:00.000

8357

Data Question

Department of Finance (DOF)

When I look at a property for example Borough *****, Block *****, Lot ***** - how can I determine which year is year 1 in the 25 year ICIP term.

Property Exemption Detail

https://data.cityofnewyork.us/d/muvi-b6kx

The column BENFTSTART is the year the benefit started.


Thank you,
- NYC DOF

Closed

2022-01-06T00:00:00.000

2026-10-02T00:00:00.000

8349

Data Question

Department of Education (DOE)

I'm looking for NYC high school SAT scores for 2013 - 2019. I can only find data for up to 2012. Could you direct me?

https://data.cityofnewyork.us/Education/2012-SAT-Results/f9bf-2cp4

This is not something that we really have. I would suggest that you go to CUNY’s website that has this data: http://www2.cuny.edu/about/administration/offices/oira/institutional/data/
Thank you,
- NYC Open Data Team

Closed

2022-01-04T00:00:00.000

2026-10-02T00:00:00.000

8346

Data Question

Agency not assigned yet.

Hi
My question is regarding your PLUTO dataset. I'm trying to understand how your downloads work. I download, open and extract Pluto with 7 Zip. The file is shown as an Excel file 7 Zip. If I open this in Excel, I can only see 64,000 rows (I'm using an old version of Excel) so I lose everything beyond my 64,000 row max. I tried using Libre Calc and changed every WIN 10 file association setting possible to LibreCalc so it should open as and is the default spreadsheet on my PC. But for some reason, when the PLUTO file is presented in 7 Zip after download, it always shows the Excel logo and automatically opens in my 64000 row Excel program and I lose data every time. 2 questions 1/ Is there anything that can be done with the downloads on your side that could help here? 2/ If not, could you give me some idea about the file associations, etc to be switched on or off in WIN 10 that will help me get PLUTO loaded completely in LibreCalc as my default spreadsheet? Would really appreciate some assistance. I simply cannot get PLUTO to open in LibreCalc. Thanks in advance for your help.

No URL Submitted.

The standard PLUTO file is available as a CSV which is a widely accepted format. We are sorry you are having issues opening it. Unfortunately we are not too familiar with Libre Calc. While we have no intentions in making changes to the files we publish, we can only recommend the following suggestions:
Upgrade to newer version of excel, if possible.

If not possible, try the following:
1) Right-click on file > select ‘open with’ > select desired software (if Libre Calc is not an option, click on ‘choose another app’ - if still not there click ‘more apps’ ).
There should be an optional checkbox that says “Always use this app to open .csv extension” – check that on to establish as default. Note: all CSV files will open with Libre Calc from now on so if you want to use Excel you would have to open it using the 'open with' from now on.

2) Open Libre Calc software > look for a ‘load’ option to load the PLUTO file into Libre Calc
You can also look for Libre Calc help options or google them for more info on troubleshooting that application.

Thank you,
- DCP Open Data Team

Closed

2022-01-03T00:00:00.000

2026-10-02T00:00:00.000

8345

Reported Error

Department of Finance (DOF)

Why is PARID designated a time and date field? I am only interested in Manhattan balances and this is the most pertinent column in my search. Can this be fixed immediately?

DOF: Property Charges Balance

https://data.cityofnewyork.us/d/scjx-j6np

Response not sent yet.

Pending

2022-01-03T00:00:00.000

2026-10-02T00:00:00.000

8342

Reported Error

Department of Finance (DOF)

in this Open data the PARID FIELD SHOULD BE ( Boro, Block and Lot and not a Date )
at the moment there is a date which is an Error. it was ok before.

DOF: Property Charges Balance

https://data.cityofnewyork.us/d/scjx-j6np

Response not sent yet.

Pending

2021-12-29T00:00:00.000

2026-10-02T00:00:00.000

8340

Data Question

Department of Finance (DOF)

Edit:
Why does this dataset differ from the Storefronts Reported Vacant or Not (Filing Year 2020 - 2021) and Storefronts Reported Vacant or Not (Filing Year 2019 - 2020) datasets? When you sum the total number of Class one, two, and four properties in each filing year from the aggregated datasets (Class One dataset and class two and four dataset) and from the non-aggregated datasets (Storefronts reported vacant or not) the totals do not match. For 2019, I get 70,202 class one, two, and four properties from the aggregated dataset and 75,250 from the non-aggregated dataset. Similarly, for 2020, I get 72,325 vs. 75,540. Any help answering why the numbers differ would be greatly appreciated!

Thanks!
*****
--------------------------
Original:
From what dataset is this data aggregated? Is it the Storefronts Reported Vacant or Not dataset?

Thanks!
*****

Storefront Registration Class 2 and 4 Statistics

https://data.cityofnewyork.us/d/dxru-eun8

Statistical reporting uses only the main registrations filed for each calendar year. Due to the variations in data collected, class one statistics are reported separately from Classes 2 and 4 statistics for each calendar year.

For Storefronts Reported Vacant or Not, the main registration filings are the primary source of information for parcel-level status, with supplemental registry updates providing additional information for Classes 2 and 4. Some owners who did not file main registrations or who filed main registrations with missing information provided information on both the 12/31 and 6/30 vacancy status of storefronts in their properties in the supplemental filing. For Class 1, only the main registration is used as the source of information for parcel-level status. By law, most class 1 properties (i.e., properties with leased class 1 storefronts) are not required to register during the calendar year. Properties that are required to register are not required to provide supplemental information.




Thank you,
- NYC DOF

Closed

2021-12-29T00:00:00.000

2026-10-02T00:00:00.000

8338

Reported Error

Department of Finance (DOF)

in this Open data the PARID FIELD SHOULD BE ( Boro, Block and Lot and not a Date )
at the moment there is a date which is an Error. it was ok before.

DOF: Property Charges Balance

https://data.cityofnewyork.us/d/scjx-j6np

Response not sent yet.

Pending

2021-12-29T00:00:00.000

2026-10-02T00:00:00.000

8337

Data Question

Agency not assigned yet.

Where is the data from the Office of Court Administration?

No URL Submitted.

Response not sent yet.

Closed

2021-12-28T00:00:00.000

2026-10-02T00:00:00.000

8336

Data Question

Department of Finance (DOF)

Hi, I am an analyst at the ***** and I have a couple of questions about the Vacant Storefronts dataset.

1. If a property is "not reported" for "Vacant 6/30 or date sold if earlier," what does that mean? Does that mean the property is occupied, or can I conclude nothing from that?
2. How come certain storefronts are listed under primary business activity as "No Business Activity Identified" when they seem to fit into another primary business activity? For example, Dig Inn, which is located at 80 Broad St., is listed as "No Business Activity Identified" when it should be listed under "Food Services".

Thanks!
*****

Storefronts Reported Vacant or Not

https://data.cityofnewyork.us/d/92iy-9c3n

1. If a property is "not reported" for "Vacant 6/30 or date sold if earlier," what does that mean? Does that mean the property is occupied, or can I conclude nothing from that?
Ans: For classes 2 and 4, if no information was reported for 6/30, then there is no information available from which a valid assumption or conclusion may be drawn for analysis. Additionally, class 1 properties that are required to register are not required to provide this information.

2. How come certain storefronts are listed under primary business activity as "No Business Activity Identified" when they seem to fit into another primary business activity? For example, Dig Inn, which is located at 80 Broad St., is listed as "No Business Activity Identified" when it should be listed under "Food Services".
Ans: All data reported uses the information a filer registered with the department. “NO BUSINESS ACTIVITY IDENTIFIED” means no business activity was reported on the registration.





Thank you,
- NYC DOF

Closed

2021-12-28T00:00:00.000

2026-10-02T00:00:00.000

8334

Data Question

Agency not assigned yet.

Hello,

I would like to know if there is a corresponding NYC Open Dataset for this NYC gov website that allows you to enter individual summons numbers: http://a820-ecbticketfinder.nyc.gov/getViolationbyID.action

Looking forward to your reply

Thanks
*****

No URL Submitted.

Response not sent yet.

Closed

2021-12-27T00:00:00.000

2026-10-02T00:00:00.000

8331

Data Question

Agency not assigned yet.

It looks rather than providing monthly data over the course of several years, this dataset provides monthly data for 4 months in 2016, a full years worth of monthly data for 2017, and then for 2018 shows several consecutive days of data for each month (i.e. 1/7/2018 - 1/16/2018, 2/7/2018 - 2/16/2018, 3/7/2018 - 3/16/2018, etc). I am wondering if this is an error and whether the team can update this dataset with current monthly information for 2019, 2020, and 2021.

No URL Submitted.

Thank you for bringing this issue to our attention. The dates in this dataset are formatted incorrectly and we are currently working on fixing that. However, this dataset is labeled as "Historical Data" meaning it no longer gets updated (it does not contain data more recent than 2018). To view our current cash assistance case information, we recommend using this dataset instead: HRA Facts Case Counts | NYC Open Data (cityofnewyork.us). Hope this helps!

Thank you,
- NYC HRA Open Data

Closed

2021-12-22T00:00:00.000

2026-10-02T00:00:00.000

8329

Data Question

Department of Finance (DOF)

Hello,

Is there a set day of the week when the site is updated with new tickets?

Dataset category
City Government

Open Parking and Camera Violations

Open Parking and Camera Violations

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

There are two separate datasets that are published to Open Data; the Fiscal Year Issuance file and the Open Parking and Camera Violations dataset.

The Fiscal Year issuance dataset is updated once a month on the sixteenth with the prior month's new issuance.
Use the FY2020 issuance dataset and search for speed camera violations in each month.
Parking Violations Issue Fiscal Year 2020: https://data.cityofnewyork.us/City-Government/Parking-Violations-Issued-Fiscal-Year-2020/pvqr-7yc4


The Open Parking and Camera Violations dataset is updated daily with status updates to existing violations in the dataset, new violations are added to the dataset on Sundays. A data set uploaded on Sunday will have data for up to the Thursday of that week which just ended.
To search for issuance in a specific month, use the referenced data set because the Open Parking and Camera dataset doesn’t support date range searches.
Open Parking and Camera Violation: https://data.cityofnewyork.us/City-Government/Open-Parking-and-Camera-Violations/nc67-uf89











Thank you,
- NYC DOF

Closed

2021-12-20T00:00:00.000

2026-10-02T00:00:00.000

8328

Data Question

New York City Police Department (NYPD)

How is a complaint defined? Is it roughly equivalent to a 911 call?

NYPD Complaint Data Historic

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

Thank you for your interest in the NYPD Complaint dataset.
This is a breakdown of every criminal complaint report filed in NYC by the NYPD. Each record represents a criminal complaint in NYC and includes information about the type of crime, the location and time of enforcement.
In addition, information related to victim and suspect demographics is also included. This data can be used by the public to explore the nature of criminal activity.


Thank you,
- NYC Open Data Team

Closed

2021-12-20T00:00:00.000

2026-10-02T00:00:00.000

8327

Reported Error

Metropolitan Transportation Authority (MTA)

To Whom It May Concern:

I'm writing to report errors in the "Subway Entrances" data (https://data.cityofnewyork.us/Transportation/Subway-Entrances/drex-xx56).

In the area proximate to the Arthur Kill station on the Staten Island Railway, there appear to be numerous entrances to pedestrian bridges that are indicated as station entrances, although not located at a station. These include one at Nassau Place (northeast of Arthur Kill Station), as well as another at Tracy Avenue (southwest of Arthur Kill station). Meanwhile, the actual entrances to the Arthur Kill station are not indicated as such.

Subway Entrances

Response not sent yet.

Pending

2021-12-20T00:00:00.000

2026-10-02T00:00:00.000

8325

Data Question

New York City Police Department (NYPD)

The download options are not working for this dataset- it comes out blank. Could you please send it or fix the glitch? Thank you

NYPD Complaint Data Historic

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

This seems to be a common issue with larger datasets, depending on what application you are using to view them. Microsoft Excel, for example, will not open a file with more than 1 million rows. Using another application that can handle larger files (Sublime Text, for example) could help. Also, filtering the dataset to make it smaller and more manageable before downloading should help. If these fixes don't work, please reach back out to us so we can find out what the issue with the data might be. Hope this helps!

Thank you,
- NYC Open Data Team

Closed

2021-12-17T00:00:00.000

2026-10-02T00:00:00.000

8324

Data Question

Office of Technology and Innovation (OTI)

Hello,
We need access to point of interest SODA API and Dataset, for our web application which is currently under development but will be deployed on *****
We will use points of interest SODA API data to display schools near selected apartments.

CommonPlace

https://data.cityofnewyork.us/d/rxuy-2muj

Our vendor gave us a workaround, and the API should be working… Please confirm it works for you. https://data.cityofnewyork.us/resource/t95h-5fsr.json

Closed

2021-12-16T00:00:00.000

2026-10-02T00:00:00.000