NYC Open Data Help Desk: Data Questions and Reported Errors

3180

Data Question

Agency not assigned yet.

Thank you for th eNYC OpenData portal. However, the DHS data for Family Shelter intake shows that is was updated in Nov. of 2017, but the actual data seems to come from 2013. Additionally, I do not see a large quantity of numbers. Thank you for your help.

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. Daily Report Of Single Adult And Family Intake dataset was not updated since 2013 and constitutes a historical one-time report. The metadata for this dataset is still being updated from time to time, but not the actual data. Currently, Department of Homeless Services (DHS) maintains DHS Daily Report dataset on the portal that can be found at this URL: https://data.cityofnewyork.us/Social-Services/DHS-Daily-Report/k46n-sa2m

Thank you,
-NYC Open Data

Closed

2018-03-08T00:00:00.000

2026-10-02T00:00:00.000

3174

Reported Error

Agency not assigned yet.

There is an internal error that is generated when attempting to create an application to generate a token. Please advise.

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk.
If you are experiencing issues with the Socrata platform, you are encouraged to contact their customer service at https://support.socrata.com/hc/en-us

Thank you,
-NYC Open Data

Closed

2018-03-07T00:00:00.000

2026-10-02T00:00:00.000

3171

Data Question

Agency not assigned yet.

Hello DOB!

I am looking for the definition for four Professional License Type codes I found in the data but not in the glossary. The codes are: NW, OW, HI, and DM.

Thank you!

No URL Submitted.

Hi,

I actually just updated the Data Dictionary today to acknowledge that these 4 codes exist. Unfortunately, I don't yet have definitions for them and it will take a little while to research them. (I am about to go on maternity leave and we have restricted resources while I'm gone.)

Please subscribe to our email distribution list for updates on DOB Open Data. If this particular item has not been addressed while I'm out, I will definitely work on it when I return in the summer.

Thank you,
- , DOB Open Data Coordinator

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

Closed

2018-03-07T00:00:00.000

2026-10-02T00:00:00.000

3166

Reported Error

Department of Buildings (DOB)

Problem 1:
The codebook for the dataset list the following as valid Permittee's License Type values:
FS = Fire Suppression Contractor
GC = General Contractor
MP = Master Plumber
NW =
OB = Oil Burner Installer
OW =
PE = Professional Engineer
RA = Registered Architect
SI = Sign Hanger

However, these values do not correspond with the DOB values listed here: https://www1.nyc.gov/site/buildings/industry/permit-type-and-job-status-codes.page

nor the values correspond with the sample of values if found in the dataset:
DM
FS
GC
HI
MP
NW
OB
OW
PE
RA
SI
Problem 2:
the open data site refers to a dead link http://www.nyc.gov/html/dob/html/codes_and_reference_materials/foilmonthly.shtml#permit

Feature request:
In order to draw insights from the permit data, the "Job Description" field from the permit would be needed. Without this, it is difficult to understand the nature of the work.

DOB Permit Issuance

Thank you for your feedback! The data dictionary is definitely a work in progress, and feedback from users like you helps me to improve it. I'll respond to each of your questions below:

The Permittee's License Type field contains acronyms for license type, where the link that you refer to contains acronyms for permit and job type. It is confusing because there is some overlap (ex: DM) but the data dictionary is still providing the most accurate information for this particular field's values.
I missed two expected values for the Permittee's License Type field, DM and HI. Thanks for pointing that out. I'll update it. At a glance I do not know what they mean, so along with NW and OW, it will take a little while for me to research that. I suspect that "DM" is not really a license type and is just a placeholder to indicate that the permittee is authorized to perform demolitions. But I'll have to confirm that.
You say that "the open data site refers to a dead link". I didn't see that link anywhere. Please let me know on what page you found the link so that I can investigate.
You request the addition of Job Description to this dataset. The Job Description is already available in DOB Job Application Filings, which you can cross reference with the Job Number provided in the permit dataset. I understand that this creates an extra step for you. Adding the field to the dataset will create an extra step for us that could take months to implement. I'll bring your request back to my team for review, but please understand that we have higher priority requests to attend to first.

Closed

2018-03-06T00:00:00.000

2026-10-02T00:00:00.000

3162

Reported Error

Office of Technology and Innovation (OTI)

Need the Building Footprints map with the building height data included. seems with most recent update a glitch has occurred in displaying the information. Will need a fixed version or the most recent previous version

Building Footprints (Deprecated)

https://data.cityofnewyork.us/d/nqwf-w8eh

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that the Building Footprints dataset was updated with the latest information - https://data.cityofnewyork.us/Housing-Development/Building-Footprints/nqwf-w8eh

Thank you,
-NYC Open Data

Closed

2018-03-05T00:00:00.000

2026-10-02T00:00:00.000

3161

Reported Error

Office of Technology and Innovation (OTI)

selecting any building displays "0" for all height information

Building Footprints (Deprecated)

https://data.cityofnewyork.us/d/nqwf-w8eh

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that the Building Footprints dataset was updated with the latest information - https://data.cityofnewyork.us/Housing-Development/Building-Footprints/nqwf-w8eh

Thank you,
-NYC Open Data

Closed

2018-03-05T00:00:00.000

2026-10-02T00:00:00.000

3160

Data Question

Office of Technology and Innovation (OTI)

I am not able to find the building height data in any of the files under export at https://data.cityofnewyork.us/Housing-Development/Building-Footprints/nqwf-w8eh/data
Is there anything that I am doing wrong? Thank you in advance

Building Footprints (Deprecated)

https://data.cityofnewyork.us/d/nqwf-w8eh

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that the Building Footprints dataset was updated with the latest information - https://data.cityofnewyork.us/Housing-Development/Building-Footprints/nqwf-w8eh

Thank you,
-NYC Open Data

Closed

2018-03-05T00:00:00.000

2026-10-02T00:00:00.000

3158

Data Question

Department of Citywide Administrative Services (DCAS)

Hi, this dataset contains only 2014 and 2015 information. When will 2016 be added? Thanks.

Civil List

https://data.cityofnewyork.us/d/ye3c-m4ga

Thank you for contacting NYC Open Data Help Desk. Please be advised that Civil List dataset was updated with data for 2016 and 2017 - https://data.cityofnewyork.us/City-Government/Civil-List/ye3c-m4ga

Thank you,
-NYC Open Data

Closed

2018-03-05T00:00:00.000

2026-10-02T00:00:00.000

3157

Reported Error

Department of Buildings (DOB)

Hi,
The Open Data does not seem to contain permits issued for Feb 21, 26, and 27th. Were permits issued for these days, or are they missing from this data set? Could you please check and upload them?
Thanks so much

DOB Permit Issuance

Thank you for the report. We'll look into this issue.

Closed

2018-03-05T00:00:00.000

2026-10-02T00:00:00.000

3155

Reported Error

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

The filter function is not working correctly when filtering for Work Location Borough, it leaves out all records for 2017.

Citywide Payroll Data (Fiscal Year)

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

Greetings,

Thank you for contacting NYC Open Data Help Desk. You are advised to utilize Socrata Filter feature using the following query: Work Location Borough contains <<text string>>. For example Work Locations Borough contains bronx query returned 32,000+ records for the 2017 Fiscal Year.

Thank you,
-NYC Open Data

Closed

2018-03-04T00:00:00.000

2026-10-02T00:00:00.000

3152

Data Question

Agency not assigned yet.

The location in this dataset is not adapt the $where=whithin_circle..., is there any other way I can query the data base on a given coordinates and return back all data are within 100 miles? Thank you

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that the within_circle function only works on columns with the Location datatype and will return errors if applied to a column with the Text datatype, as in the case of this dataset's Location column. All the functions that are geographical in nature will require the Location datatype column. For more information, you are encouraged to contact Socrata Customer Center at https://support.socrata.com/hc/en-us

Closed

2018-03-02T00:00:00.000

2026-10-02T00:00:00.000

3149

Data Question

Mayor's Office of Contract Services (MOCS)

Do you plan to update the project Pipeline? This file is from 2016. Thanks, appreciate your help.

Construction Pipeline (Historical)

https://data.cityofnewyork.us/d/iwdd-99mu

Greetings,

The agency is planning to update this dataset by the end of April.

Thank you,
-NYC Open Data

Closed

2018-03-02T00:00:00.000

2026-10-02T00:00:00.000

3148

Reported Error

Agency not assigned yet.

we are not suppose too be in this system and it is causing us great delay wit hour jobs that we have in process.

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. We have forwarded your request to the Department of Housing Preservation and Development (HPD).
Thank you,
-NYC Open Data

Closed

2018-03-02T00:00:00.000

2026-10-02T00:00:00.000

3145

Reported Error

Office of Technology and Innovation (OTI)

After update on Feb 26th, all records are set to

cnstrct_yr:0
feat_code:0
groundelev:0
heightroof:0
lstmoddate:1899-11-30T00:00:00.000Z
shape_area:0
shape_len:0

Building Footprints (Deprecated)

https://data.cityofnewyork.us/d/nqwf-w8eh

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that the Building Footprints dataset was updated with the latest information - https://data.cityofnewyork.us/Housing-Development/Building-Footprints/nqwf-w8eh
Thank you,
-NYC Open Data

Closed

2018-03-01T00:00:00.000

2026-10-02T00:00:00.000

3144

Data Question

Agency not assigned yet.

Hello, I am trying to download the NYC OpenData - Crime Locations Map but when I click on it, I receive a message saying I don't have access to this dataset. Could you please show me where I can get a dataset (preferrably a shapefile) of crime locations in NYC? If I can have yearly crime locations maps since 2015 that would be great. Thank you! I am trying to find a correlation between crime rate and park/playground use in several neighborhoods in the five boroughs for my PhD research in public spaces

No URL Submitted.

​Thank you for contacting NYC Open Data Help Desk. Please refer to the NYPD shapefile at this URL: https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Historic/qgea-i56i

Thank you,
-NYC Open Data

Closed

2018-03-01T00:00:00.000

2026-10-02T00:00:00.000

3141

Reported Error

Department of Buildings (DOB)

This dataset hasn't updated for a couple of days, the last date that is available to view is FEb 25th. Please update to include Feb 26-28th. 

DOB Permit Issuance

Greetings,

Please be advised that this dataset was updated with the latest information on 3/21/18.

Thank you,
-NYC Open Data

Closed

2018-02-28T00:00:00.000

2026-10-02T00:00:00.000

3136

Reported Error

Office of Technology and Innovation (OTI)

Missing building height data as of yesterday night (02/27/18)

Building Footprints (Deprecated)

https://data.cityofnewyork.us/d/nqwf-w8eh

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that the Building Footprints dataset was updated with the latest information - https://data.cityofnewyork.us/Housing-Development/Building-Footprints/nqwf-w8eh
Thank you,
-NYC Open Data

Closed

2018-02-28T00:00:00.000

2026-10-02T00:00:00.000

3134

Data Question

Agency not assigned yet.

I am trying to find the history of permits issued for my building? Can some one help me? Thank you Lindy Friedman

No URL Submitted.

Hi,

Since you're asking about a single address, I would recommend that you instead look it up in our Buildings Information System (BIS) to see a more holistic view. From there, I don't see any historical permits or approved job applications for this address. That's why you're not finding it in open data.

From the complaints for this building, it looks like there may be a history of construction work being done without a permit. If you witness this activity, please report it to 311 immediately.

Thank you,
- , DOB Open Data Coordinator

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

Closed

2018-02-28T00:00:00.000

2026-10-02T00:00:00.000

3133

Data Question

Agency not assigned yet.

I'm looking for the burial record of my grandmother who died December ***.

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that the information you are looking for is not currently maintained by a New York City agency. You are encouraged to explore this online search database at
https://www.nypl.org/collections/articles-databases/death-indexes-and-records-online
or contact NYC Department of Health and Mental Hygiene at
http://www1.nyc.gov/assets/home/mail/html/maildoh.html

Thank you,
-NYC Open Data

Closed

2018-02-27T00:00:00.000

2026-10-02T00:00:00.000

3131

Data Question

Agency not assigned yet.

Will the Cooling Tower Hearings dataset be re-uploaded or has it been removed permanently?

No URL Submitted.

Greetings,

The above mentioned Cooling Tower Hearings dataset was not an official dataset but a filtered view created by another Open Data user. The underlying dataset for this view was OATH Hearings Division Case Status - https://data.cityofnewyork.us/City-Government/OATH-Hearings-Division-Case-Status/jz4z-kudi
You are encouraged to filter this dataset using the following criteria:
Issuing Agency is COOLING TOWERS - DOHMH

For more information on filtering datasets, please refer to https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View

Thank you,
-NYC Open Data

Closed

2018-02-27T00:00:00.000

2026-10-02T00:00:00.000

3128

Data Question

Department of Citywide Administrative Services (DCAS)

Is the PIN number for a particular solicitation the same as the RFQ number? I am looking to evaluate specific RFQs that have been submitted over time, and I want to ensure that I am requesting the correct information. Thank you!

City Record Online

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

Greetings,

Thank you for contacting NYC Open Data Help Desk. The PIN numbers that are included in City Record notices are supplied by the individual agency engaged in the procurement activity. They are not assigned by the City Record or by any other centralized system. Individual agencies may choose to use the initials “RFQ” in their PIN number for their own reference, but there is no specific requirement to have an “RFQ number”.

Thank you,
-NYC Department of Citywide Administrative Services

Closed

2018-02-27T00:00:00.000

2026-10-02T00:00:00.000

3119

Data Question

Agency not assigned yet.

I was able to gather the average response times for prior years. I am now looking for average knockdown times for those fires. Can you please provide or point me towards the best resource for such information? Thanks for any and all help with this. 

No URL Submitted.

We do not currently record knockdown times. For information about fire incidents you can refer to the Fire Incident Dispatch Data, which includes information collected by the Starfire Computer Aided Dispatch system, or Incidents Responded to by Fire Companies, which includes information as recorded in the New York Fire Incident Recording System (NYFIRS).

Closed

2018-02-25T00:00:00.000

2026-10-02T00:00:00.000

3111

Data Question

New York City Police Department (NYPD)

We are interested in getting the crash data with a field showing the type of vehicle, by license plate (standard, commercial, t & lc, truck, etc.) Is that possible to obtain? If so, what would the process be?
Thanks very much,

Motor Vehicle Collisions - Crashes

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

There are no plans at this time to release additional fields. However we are reviewing this internally with our Legal Bureau for possible release in the future.

Closed

2018-02-23T00:00:00.000

2026-10-02T00:00:00.000

3110

Reported Error

Agency not assigned yet.

The source link that currently says https://app.enigma.io/api should be corrected to say https://docs.enigma.com/public/public_v20_api_about.html

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. The source link information was updated on the portal.

Thank you,
- NYC Open Data

Closed

2018-02-23T00:00:00.000

2026-10-02T00:00:00.000

3108

Data Question

Agency not assigned yet.

I am a graduate student performing a literature review to inform a meta-analysis of tree canopy study classification techniques with the ***. In doing so, I came across this Tree Canopy Assessment Metrics dataset from 2010.

I am primarily interested in the resolution of the imagery datasets used in these types of analyses. The associated landcover datasets available on NYC OpenData are 3 feet and 6 inch resolution, and I was hoping you would be able to tell me which dataset was used to obtain the 21.8% tree canopy cover figure described in the Assessment Metrics layer.

No URL Submitted.

Thank you for your question regarding the Tree Canopy Assessment Metrics dataset. The listed percentages were calculated using the 6" resolution landcover raster. Please let us know if you have additional questions.

Closed

2018-02-23T00:00:00.000

2026-10-02T00:00:00.000

3105

Data Question

Department of Citywide Administrative Services (DCAS)

if your name shows up under the "civil service list certification" what does that mean? what the certification Expiration Date mean if we did not receive a notice and what will happen to your name on this list?

Civil Service List Certification

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

A List Certification includes the names of a group of eligible candidates on an established, active Civil Service Eligible List, and it is provided to an appointing agency by DCAS to fill available positions. The number of names on a List Certification depends on the number of available positions being filled and the number of candidates on an eligible list with identical scores.

An agency may use a given List Certification for filling positions between the date that the Certification is created and the Certification Expiration Date. If a candidate has not received a notice it means that the agency did not use the Certification or that the candidate was not reached for consideration of appointment. If a candidate does not receive a notice in connection with a specific List Certification, the candidate’s name remains on the underlying Eligible List and would remain available for future certifications.

Closed

2018-02-22T00:00:00.000

2026-10-02T00:00:00.000

3103

Data Question

Agency not assigned yet.

In this Fire Inspection dataset, the second field is called ALPHA and the description is "Hazardous Level". It contains codes such as P, RR, C, F, G. I would like to know what those codes mean. Thanks!

No URL Submitted.

The type of information you are requesting is not available to the public at the moment. We will forward it along to the appropriate unit and you should have a response within the next two weeks

Closed

2018-02-22T00:00:00.000

2026-10-02T00:00:00.000

3102

Data Question

Agency not assigned yet.

Your web site is not accepting my username & password

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. For the questions related to the user account management, please contact Socrata Customer Service at https://support.socrata.com/hc/en-us/sections/360000042227-Accounts-and-Access

Thank you,
- NYC Open Data

Closed

2018-02-22T00:00:00.000

2026-10-02T00:00:00.000

3099

Data Question

Agency not assigned yet.

Requesting heat complaints (called via 311) for a specific building in the Bronx *** from 2007 till 2011.

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that the Department of Housing Preservation and Development does not maintain this data on the NYC Open Data portal. You are encourage to contact the agency at http://www1.nyc.gov/site/hpd/about/email-the-commissioner.page
You can also refer tohttps://hpdonline.hpdnyc.org/HPDonline/provide_address.aspx for more information related to your request.

Thank you,
-NYC Open Data

Closed

2018-02-21T00:00:00.000

2026-10-02T00:00:00.000

3093

Data Question

Agency not assigned yet.

I need to dig deeper and locate actual permit application listing company names and relevant information. Can you please help me search for this? I was using the event ID to search but that does not work.

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. Your request was forwarded to the Office of Citywide Event Coordination and Management.

Best,
- NYC Open Data

Closed

2018-02-19T00:00:00.000

2026-10-02T00:00:00.000

3091

Data Question

Agency not assigned yet.

Thank you for responding to my previous email.

I need to calculate Net new construction using NYC Open Data, and I’d like to know if this can be done simply by subtracting Demolition of an existing Building from New Building? (i.e. Net new construction = NB-DM).

Also, would you consider Added units due to Alterations of existing buildings, which is another variable I’m working with comparable to A1, which in the NYC Open Data represents A major alteration that changes the use of occupancy of the building?

Thanks again for your assistance


Thank you for responding to my previous email.

I need to calculate Net new construction using NYC Open Data, and I’d like to know if this can be done simply by subtracting Demolition of an existing Building from New Building? (i.e. Net new construction = NB-DM).

Also, would you consider Added units due to Alterations of existing buildings, which is another variable I’m working with comparable to A1, which in the NYC Open Data represents A major alteration that changes the use of occupancy of the building?

Thanks again for your assistance

No URL Submitted.

Hi,

Net new construction isn't really something that we measure, so it's difficult to answer your question. It depends on what you're trying to measure.

If you are measuring new building structures, NB - DM could give you the net increase, so it sounds like your formula would work. I would not include A1 because it's not a change in the number of building structures. But be aware that submitting a job application or even getting a permit does not necessarily mean that the work will be completed. We are planning to add the "Sign Off" date which indicates completion of the job, but that isn't currently available in open data.

If you are instead measuring an increase or decrease in housing, you should also look at dwelling units. For this measurement, I would include A1 because that can have an increase or decrease in dwelling units. This measurement contains the same caution as above that permitting does not mean the job will be completed. It also contains a caution that the number of existing and proposed dwelling units is self-reported on the original application in our Job Application data. As the job progresses, it is possible that the plans will change and the number of units will change, but this does not get reported back to open data.

I hope that helps.

Thank you,
- , DOB Open Data Coordinator

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

Closed

2018-02-19T00:00:00.000

2026-10-02T00:00:00.000

3090

Data Question

Agency not assigned yet.

How do i export to PDF or print the "Public Pay Telephone Locations"
https://data.cityofnewyork.us/Social-Services/Public-Pay-Telephone-Locations/t7sx-id53/data

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. To convert this data to PDF or another printable file, please choose Export--->Download As--->CSV to generate a CSV file. There are various tools available online that would be helpful in converting a CSV file to PDF. https://www.google.com/search?q=how+to+convert+csv+to+pdf&rlz=1C1CHBF_enUS768US768&oq=how+to+convert+csv+to+pdf&aqs=chrome..69i57j0l5.4967j0j8&sourceid=chrome&ie=UTF-8

Please be advised that there is another dataset available on the Open Data portal that contains updated information - https://data.cityofnewyork.us/Social-Services/Public-Pay-Telephone-Locations/5qrc-eb74
Please use the Export function to download this data in CSV format as well.

Thank you,
- NYC Open Data

Closed

2018-02-17T00:00:00.000

2026-10-02T00:00:00.000

3088

Reported Error

Department of Citywide Administrative Services (DCAS)

UPDATED 2/18: Hi, thank you for adding more rows. It looks like there are a lot of duplicates (see Job ID column). Can the dataset be updated to remove duplicates? Also, it looks like there are open postings originally posted in 2011-2015 (see Posting Date column)-- is this correct? Thanks.Hi, it looks like there are only 60 rows in this dataset-- it is only showing OMB jobs instead of all city jobs.

Jobs NYC Postings

https://data.cityofnewyork.us/d/kpav-sd4t

Thank you for contacting NYC Open Data Help Desk. For the duplicate records - in many cases we will list both an internal and an external posting for the same job. This is a common situation.
For the old postings - in some cases agencies will specify that a job should remain posted “until filled”. We send out reminders to agencies but we can’t remove an agency posting on our own volition.

Thank you,
​- NYC Department of Citywide Administrative Services
- NYC Open Data Team

Closed

2018-02-16T00:00:00.000

2026-10-02T00:00:00.000

3084

Reported Error

Department of Environmental Protection (DEP)

I am using the NYC Open Data portal (https://data.cityofnewyork.us/Environment/CATS-Permits/f4rp-2kvy) to review data on boiler fuel types. The online CATS system contains information that doesn’t match the CATS Permit data posted on the portal. For example application number *** shows on the CATS system as Natural Gas fuel source 1. But the dataset downloaded shows the fuel type as null. Is there someone I can talk about the CATS data being published?

Clean Air Tracking System (CATS) Permits

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

Greetings,

Thank you for contacting NYC Open Data. New York City Department of Environmental Protection are in the process of correcting this discrepancy.

- NYC Open Data

Closed

2018-02-15T00:00:00.000

2026-10-02T00:00:00.000

3079

Data Question

Agency not assigned yet.

How do I tie the x and y coordinates to geo coordinates?

No URL Submitted.

How do I tie the x and y coordinates to geo coordinates?

-----
Greetings,

Thank you for contacting NYC Open Data Help Desk. There are a number of various utilities that can assist you in converting X/Y coordinates to Latitude and Longitude. You are encouraged to use the following utility - http://www.earthpoint.us/StatePlane.aspx
For the NYC area, please select 3104 - New York Long Island zone and the US Survey Feet as your input configuration. Then enter values for X (US Survey Feet) and Y (US Survey Feet) to generate the values for Latitude and Longitude.

Thank you,
- NYC Open Data

Closed

2018-02-14T00:00:00.000

2026-10-02T00:00:00.000

3078

Data Question

Agency not assigned yet.

There is a parking ticket dataset that shows all fields including ticket location. I am searching 12/31/16 to 12/31/17. The data stops at 9/2017. Can I get all fields for FY 2017?

No URL Submitted.

Hello,

The data you've requested can be found here: https://data.cityofnewyork.us/City-Government/Open-Parking-and-Camera-Violations/nc67-uf89/data.

- NYC Open Data

Closed

2018-02-14T00:00:00.000

2026-10-02T00:00:00.000

3075

Data Question

Agency not assigned yet.

How can I find lease data for the offices of New York City Employees' Retirement System (NYCERS) in Brooklyn at 335 Adams Street.

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. The information you are looking for can be found here: https://comptroller.nyc.gov/wp-content/uploads/documents/NYCERS-6-30-2017.pdf

Thank you,
- NYC Open Data

Closed

2018-02-14T00:00:00.000

2026-10-02T00:00:00.000

3074

Reported Error

Mayor's Office of Operations (OPS)

Street and sidewalk cleanliness ratings Dataset says updated monthly but the info in the data is from 2014.

Scorecard Ratings

https://data.cityofnewyork.us/d/rqhp-hivt

Greetings,

Thank you for contacting NYC Open Data Help Desk. The Scorecard Ratings dataset hosted on the Open Data portal is a historical data. The latest information for the Street and Sidewalk Cleanliness Ratings can be found here:https://www1.nyc.gov/site/operations/performance/scorecard-street-sidewalk-cleanliness-ratings.page
We will reach out to the Mayor's Office of Operations with a request to update the Scorecard Ratings dataset on the portal.

Thank you,
- NYC Open Data

Closed

2018-02-13T00:00:00.000

2026-10-02T00:00:00.000

3073

Data Question

Department of Buildings (DOB)

Since I can't get the PDF via the API and I can't get the identifier used in the URL for retrieving the printable version of the permit is there at least a way that I can use one of the identifiers from the API to link users to the permit? At a minimum I need to be able to get users to the page where they can print the permit but the real goal is to be able to programmatically retrieve the permit as a PDF and save it within Salesforce associated to the project data. We can implement a screen scraping approach if necessary but would need some guidance to do it properly. Can you please assist us in accomplishing this?

DOB Permit Issuance

Hi ,

Our open data is not connected to the PDF files for the permits, and there isn't any dataset that contains the identifier in the URL scheme. The only way for you to consistently retrieve those PDFs would be to scrape our BIS site, as many companies do, though I'm hesitant to suggest that as the prevalence of this has led to performance issues with BIS. No, we do not currently plan to provide an API-based method to obtain the PDFs. We do not provide assistance with scraping Department of Buildings websites. Let us know if you need assistance with the data that we have provided through the open data portal.

Closed

2018-02-13T00:00:00.000

2026-10-02T00:00:00.000

3070

Data Question

Department of Buildings (DOB)

How many certificates were issued per record? Is that variable available? Is it the same as 'proposed' or 'existing' units? On the DCP github for the housing database, the following comment is made:
https://github.com/NYCPlanning/db-housingdev#data-dictionary
"DOB Certificates of Occupancy (CofOs) Data
This data is also requested from DOB. It cannot yet be obtained via NYC Open data, because the open data is critically missing the number of dwelling units that each CofO certifies."

DOB Certificate Of Occupancy

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

I suspect the comment on the DCP website is out of date - We released this dataset fairly recently.

The Existing and Proposed Dwelling Units are the numbers that were given to us by the person who filed the job application with us. Existing should reflect the number of units before the work is done and Proposed should reflect the number of dwelling units after.

Thank you,

Closed

2018-02-13T00:00:00.000

2026-10-02T00:00:00.000

3069

Data Question

New York City Police Department (NYPD)

Is there a reason these two data-sets are kept separate?

https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Historic/qgea-i56i

https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Current-YTD/5uac-w243

They seem to have the same info and I'm confused why it was separated out.

I'd love to do a query on all of the data but aren't too keen on the fact that I have to query two data-sets and THEN combine results.

NYPD Complaint Data Historic

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

Greetings,

Thank you for contacting NYC Open Data Help Desk. Please be advised that NYPD Complaint Data Current YTD dataset is dynamic, while the NYPD Complaint Data Historic dataset is static. Since the data for 2018 is not yet released, the current dataset still contains 2017 data. As soon as the data for the first quarter for 2018 will be released, we will update the current dataset and append 2017 data to the historic dataset.

Thank you,
- New York City Police Department

Closed

2018-02-12T00:00:00.000

2026-10-02T00:00:00.000

3066

Data Question

Department of Consumer and Worker Protection (DCWP)

Looking for dataset like this that contains email addresses. Do any such exist? I see that you have phone number, but email address would be preferable.

Issued Licenses

https://data.cityofnewyork.us/d/w7w3-xahh

The Legally Operating Businesses dataset on the NYC Open Data Portal does not provide email addresses, and there is no existing dataset maintained by DCA that includes contact email addresses for DCA-issued licenses.

Closed

2018-02-12T00:00:00.000

2026-10-02T00:00:00.000

3065

Reported Error

Agency not assigned yet.

there is a HUGE pothole on *** west at the I95 South entrance ramp. It is not on your map but I know it had been reported as a NYS employee on site said it was and had been there for at least 2 weeks. 7 cars on 12/11/18 hit the pothole at approximately 4:14 pm. Retired trooper also on scene and owner of Crown Towing nearby said they have been there regularly.

No URL Submitted.

Greetings,

Thank you for contacting NYC Open Data Help Desk. The best and fastest way to get a response is to call 3-1-1, or to submit a request through the 311 online portal: http://www1.nyc.gov/311/index.page

Thank you,
-NYC Open Data

Closed

2018-02-12T00:00:00.000

2026-10-02T00:00:00.000

3064

Reported Error

Agency not assigned yet.

When using ZOLA there is an apparent error in data related to zoning district boundaries that incorrectly moves the zoning district lines to align with the tax lot line for properties located on corners. Both ZOLA sites have the same issues. https://zola.planning.nyc.gov/about#9.72/40.7125/-73.733

No URL Submitted.

We do not see the error you are reporting. The zoning district boundary is not flush with either lot. Please see the two links below, 1-the BBL you provided, 2-the lot adjacent on 2nd Ave, that demonstrate this:

1) https://zola.planning.nyc.gov/lot/1/1417/22?commercial-overlays=false#19.79/40.76285/-73.96292
2) https://zola.planning.nyc.gov/lot/1/1417/28?commercial-overlays=false#18.21/40.7631/-73.96236

Also, the Zoning District GIS files are not meant to be at survey grade accuracy. They are reference guides for the public to use. Please see our Notes to Users:
2. These features are not intended for determining zoning at the individual tax lot level.

For official zoning determination please consult the Zoning Tax Maps: http://www1.nyc.gov/site/planning/zoning/index-map.page


Thank you,
- NYC Open Data

Closed

2018-02-12T00:00:00.000

2026-10-02T00:00:00.000

3062

Data Question

Agency not assigned yet.

Do you have the travel time of the routes for which the traffic volume are available

No URL Submitted.

No currently we do not have that information. The information collected in this historic dataset was done by sensors placed on or along the street segment, not by calculating travel times of routes.

Hope this answers your questions.

-DOT Open Data Team

Closed

2018-02-11T00:00:00.000

2026-10-02T00:00:00.000

3052

Reported Error

Department of Citywide Administrative Services (DCAS)

First, please allow me to thank you for your service. It's very helpful.
However, I'm writing because the List Agency Description is blank.

Civil Service List Certification

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

Greetings,

Thank you for contacting NYC Open Data Help Desk. Civil Service List Certification dataset was updated with the latest information. Currently, all the records that were assigned an appointing agency have a corresponding agency description.

Best,
- NYC Open Data

Closed

2018-02-08T00:00:00.000

2026-10-02T00:00:00.000

3043

Reported Error

Agency not assigned yet.

It appears that agency data, complaint type, descriptions, and location type are not accurate.

No URL Submitted.

Greettings,

Thank you for contacting NYC Open Data Help Desk. 311 Service Requests from 2010 to Present dataset was updated. Please let us know if this discrepancy persists.

https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9/

Closed

2018-02-07T00:00:00.000

2026-10-02T00:00:00.000

3037

Data Question

Agency not assigned yet.

Querying the Job Applications dataset gave me a result that doesn't match with BIS, so I wanted to submit the issue in case you can tell me the reason for the discrepancy. This is so I can explain it to users of my data tool. I queried job app filings in Jan 2017 and only saw one, job # 321509266 for BBL 3033060024, though 321416687 also appears in BIS with a filing date of 1/12/2017 for that month. However, when I look up job 321416687 in the Job Applications dataset I don't see the date 1/12/17 anywhere. Additionally, I see three job apps for BBL 3033260065 in the dataset for that month but only one appearing in BIS. I would appreciate any explanation you can provide. Thanks.

No URL Submitted.

Hi,

Thank you for your inquiry. After reviewing the matter with regard to job #321416687 and the "pre-filing date" and "paid" date in OpenData, we are able to inform you that this job was actually filed in July of 2016. The January date in BIS for this job is associated with a Post Approval Amendment (PAA) that we do not release as a part of OpenData.

Regarding BBL 3033260065, there are multiple BINs (Building Identification Numbers) associated with this BBL. Please use the BIN you need to for for the level of data you seek, as that is more of a unique identifier.

Thank you,
- Mark, NYC Open Data Coordinator
----------

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

Closed

2018-02-06T00:00:00.000

2026-10-02T00:00:00.000

3034

Data Question

311

I'm curious if I can filter the 311 data set prior to downloading a csv. Otherwise, the file is obscenely large

311 Service Requests from 2020 to Present

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

Greetings,
Thank you for contacting NYC Open Data Help Desk. You can certainly filter the dataset to generate a downloadable output only for the selected criteria. Once you have created a filtered view, you can utilize Export feature that will download only those records that were selected by this filter. You can also refer to About--->Row Count statistics to check the number of filtered rows, and only these will be downloaded by the Export.

If you need help on how to use Socrata Filter feature, please refer to the Socrata Customer Center at
https://support.socrata.com/hc/en-us/articles/202950808-Creating-a-Filtered-View

Thank you,
-NYC Open Data

Closed

2018-02-06T00:00:00.000

2026-10-02T00:00:00.000

3027

Reported Error

Agency not assigned yet.

Violation *** states we owe $1400 but the penalty was paid in full. Check the Ticketfinder online and you can see balance is paid.

No URL Submitted.

Greetings,


Thank you for contacting NYC Open Data Help Desk. Please be advised that the agency is planning to undertake a project which will update about 4 million records on the Open Data Portal over the next couple of weeks. It is expected that it would resolve any potential issues such as these. The agency will also continue to monitor the dataset and data-feed to Open Data going forward.

Thank you,
-NYC Open Data

Closed

2018-02-05T00:00:00.000

2026-10-02T00:00:00.000