NYC Open Data Plan: FOIL Datasets

2022

Department of Transportation (DOT)

Meter-Maintenance Detail by Space

Contains meter collection and maintenance work information.

2

Not on Open Data Plan

Not Public Data- Internal Administration; Security and public safety concerns.

2022

Department of Transportation (DOT)

Meter-Parking Meter Order

Contains meter collection and maintenance work information.

3

Not on Open Data Plan

Not Public Data- Internal Administration; Security and public safety concerns.

2022

Department of Transportation (DOT)

Meter-Parking Meter Pay Stations Working Condition

Contains meter collection and maintenance work information.

1

Not on Open Data Plan

Not Public Data- Internal Administration; Security and public safety concerns.

2022

Department of Transportation (DOT)

Open Parking and Camera Violations

Contains automated camera violations issued for bus lane camera, red light cameras and school speed zone cameras. It also integrates with DOF functions for adjudication, payment, etc.

28

Not on Open Data Plan

Available through DOF Data- Open Parking and Camera Violation

2022

Department of Transportation (DOT)

Pedestrian Ramp Database (PRISM)

Contains street corners and pedestrian ramp inspections for feasibility to build ADA-compliant pedestrian ramps.

125

Scheduled for Future Publication

2022

Department of Transportation (DOT)

Revocable Consent Invoice

Contains project status and compensations to the City for the private use of the public right of way.

1

Not on Open Data Plan

Not Public Data- Internal Administration; Image File

2022

Department of Transportation (DOT)

Sidewalk Database

Contains sidewalk defect inspections and violations information.

78

Scheduled for Future Publication

2022

Department of Transportation (DOT)

Signal Operation Orders

Contains traffic signal repair work orders.

18

Not on Open Data Plan

Not Public Data- Internal Administration; Security and public safety concerns.

2022

Department of Transportation (DOT)

Signal Timing

Contains list of traffic signal timing treatments deployed at the signalized locations.

27

Not on Open Data Plan

Not Public Data- Internal Administration; Security and public safety concerns.

2022

Department of Transportation (DOT)

Speed Reducers Tracking System (SRTS)

Contains speed humps and speed cushions studies, project status and locations.

1

Already on Open Data

2022

Department of Transportation (DOT)

Street Accident Report

NYPD data containing motor vehicle collisions in New York City including location and injury details.

2

Not on Open Data Plan

Available through NYPD Data- Motor Collisions Data- Crashes

2022

Department of Transportation (DOT)

Street and Highway Capital Reconstruction Projects

Contains spatial representation of major street construction capital projects in order to keep the City's infrastructure in a state of good repair.

95

Already on Open Data

2022

Department of Transportation (DOT)

Street Construction Inspections and Corrective Action Requests

Contains inspections and corrective action requests information for a construction site.

1402

Already on Open Data

2022

Department of Transportation (DOT)

Street Construction Permit

Contains sidewalk and roadway construction permit details, such as permittee, type of permit, date issued, location, etc. Sidewalk and roadway construction permits issued to utility companies, contractors, government agencies and homeowners.

1852

Already on Open Data

2022

Department of Transportation (DOT)

Street Light Schedule

The daily on and off times of the street lights.

16

Not on Open Data Plan

Not Public Data- Internal Administration; Image File

2022

Department of Transportation (DOT)

Street Pothole Work Orders- Closed

List of street potholes inspected and repaired.

355

Already on Open Data

2022

Department of Transportation (DOT)

Street Sign Work Orders

Contains sign work orders for over one million current and historical traffic and regulatory signs in New York City.

136

Already on Open Data

2022

Department of Transportation (DOT)

Weekly Milling and Resurfacing Schedule-Roadway

RSS Feed displaying the weekly resurfacing schedule

3

Already on Open Data

2022

Department of Youth and Community Development (DYCD)

DYCD contract data

Data on DYCD contracts including providers, contract amounts, and program areas

2

Scheduled for Future Publication

2022

Department of Youth and Community Development (DYCD)

DYCD program site data

Data on DYCD program sites including provider, contract number, location, and number of participants

1

Already on Open Data

2022

Department of Youth and Community Development (DYCD)

RHY participant data

Data from DYCD's Participant Tracking System related to participant demographics, services, discharges, and bed utilization

2

Scheduled for Future Publication

2022

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

Citywide Payroll Data (Fiscal Year)

City Employee Base and Overtime Salary by Fiscal Year

6

Already on Open Data

2022

Law Department (LAW)

Case-Related Information About Civil Litigation

Case-related information

4

Already on Open Data

2022

Law Department (LAW)

NYC Law Department FOIL log

log of FOIL requests; log includes attorney notes

1

Not on Open Data Plan

Largely duplicative with Open Data portal; plus attorney work product and inter-agency notes

2022

Mayor's Office of Climate and Environmental Justice (MOCEJ)

Carbon Trading for NYC Building Sector

Report on Local Law 97

1

Not on Open Data Plan

This information does not meet qualifications for a “public data set” as defined by the Local Law 11 of 2012

2022

Mayor's Office of Climate and Environmental Justice (MOCEJ)

Number of employees at various climate offices

Number of employees at various climate offices

1

Not on Open Data Plan

This information does not meet qualifications for a “public data set” as defined by the Local Law 11 of 2012

2022

Mayor's Office of Contract Services (MOCS)

Civil Service Titles & Salaries

This list includes civil service titles and salaries of MOCS employees

1

Already on Open Data

2022

Mayor's Office of Contract Services (MOCS)

Complete Caution List

This list includes certain integrity information regarding certain vendors in the PASSPort database to be utilized by agencies in the procurement process.

6

Not on Open Data Plan

Complete Entity reports will not be made public at this time. As of FY 2022, Complete Entity reports are being conducted in PASSPort, and the previous source of record (VENDEX) has been deprecated. Matters of governance including the structure of public-facing data, the presentation of current (PASSPort) vs legacy (MOCS) data and retention policies are all under development. It is expected that the publication of this data will fall outside the 2022 Fiscal Year.

2022

Mayor's Office of Management and Budget (OMB)

Agency Spending by Budget Function

This dataset contains information, for a select number of agencies, detailing the costs of providing services within an agency. Amounts are in dollars.

1

Already on Open Data

2022

Mayor's Office of Management and Budget (OMB)

Asset Management Executive Summary - Agency Assets by Project Type and Class

This dataset contains information for a select number of agencies, showing the number of assets owned by each Agency which are included in the Asset Management inventory. The assets are sorted by project type and class. The dataset is updated once a year.

1

Already on Open Data

2022

Mayor's Office of Management and Budget (OMB)

Asset Management Executive Summary - State of Good Repair Need (Expense)

This dataset contains information for a select number of agencies. It shows the estimated spending necessary to preserve the structural integrity for each of their fixed assets which meet the criteria for expense eligibility. The numbers can be summarized by Agency to match the Asset Management Executive Summary publication. Amounts are rounded to the nearest thousand. The dataset is updated once a year.

1

Already on Open Data

2022

Mayor's Office of Management and Budget (OMB)

Asset Management Executive Summary - State of Good Repair Needs (Capital Eligible)

This dataset contains information for a select number of agencies. It shows the estimated spending necessary to preserve the structural integrity for each of their fixed assets which meet the criteria for capital eligibility. The numbers can be summarized by Agency to match the Asset Management Executive Summary publication. Amounts are rounded to the nearest thousand. The dataset is updated once a year.

1

Already on Open Data

2022

Mayor's Office of Management and Budget (OMB)

Capital Budget

This dataset contains capital appropriation data by project type, budget line and source of funds. Amounts are in whole dollars. Data is created three times per year for the Preliminary Budget, Executive Budget and Adopted Budget to match appropriation numbers in the Capital Budget publication.

3

Already on Open Data

2022

Mayor's Office of Management and Budget (OMB)

Capital Commitment Plan

This dataset contains capital commitment plan data by project type, budget line and source of funds. The dollar values are in thousands. The dataset is updated three times per year in Preliminary, Executive and Adopted Budget to match commitment numbers in the Capital Commitment Plan publication.

1

Already on Open Data

2022

Mayor's Office of Management and Budget (OMB)

Citywide Payroll Data (Fiscal Year)

Data is collected because of public interest in how the City’s budget is being spent on salary and overtime pay for all municipal employees. Data is input into the City's Personnel Management System (“PMS”) by the respective user Agencies. Each record represents the following statistics for every city employee: Agency, Last Name, First Name, Middle Initial, Agency Start Date, Work Location Borough, Job Title Description, Leave Status as of the close of the FY (June 30th), Base Salary, Pay Basis, Regular Hours Paid, Regular Gross Paid, Overtime Hours worked, Total Overtime Paid, and Total Other Compensation (i.e. lump sum and/or retro payments). This data can be used to analyze how the City's financial resources are allocated and how much of the City's budget is being devoted to overtime. The reader of this data should be aware that increments of salary increases received over the course of any one fiscal year will not be reflected. All that is captured, is the employee's final base and gross salary at the end of the fiscal year.

1

Already on Open Data

2022

Mayor's Office of Management and Budget (OMB)

Expense Budget

This dataset contains expense agency data by unit of appropriation for the Adopted, Financial Plan and Modified conditions by object code. The numbers within can be summarized to be consistent with data from either the Supporting Schedule, Departmental Estimate or the Expense, Revenue, Contact Budget.

1

Already on Open Data

2022

Mayor's Office of Management and Budget (OMB)

Expense Financial Plan

This dataset contains agency summary level data for PS, OTPS and Total by type of funds. The dollar amount fields are rounded to the thousands. The Adopted and Preliminary reports, published by July 1 and January or February respectively, contain the current fiscal year plus four out years of data which coincide with the release of the published financial plan.

2

Already on Open Data

2022

Mayor's Office of Management and Budget (OMB)

Participatory Budgeting Projects

Participatory Budgeting is a democratic process in which community members directly decide how to spend part of a public budget. Council Members choose to join Participatory Budgeting New York City (PBNYC), giving at least $1 million from their budget for the whole community to participate in decision-making. It’s a yearlong process of public meetings, to ensure that people have the time and resources to make informed decisions. Community members discuss local needs and develop proposals to meet these needs. Through a public vote, residents then decide which proposals to fund.

1

Already on Open Data

2022

Mayor's Office of Management and Budget (OMB)

Revenue Budget & Financial Plan

This dataset contains agency revenue data for Adopted, Modified and five years of Financial Plan by Revenue Class, Revenue Category and Revenue Source (Revenue Structure) or FPS Group name. The numbers within can be summarized to match pages from either the Supporting Schedule, Departmental Estimate or the Expense, Revenue, Contact Budget.

1

Already on Open Data

2022

Mayor's Office of Media and Entertainment (MOME)

Film Permits

Film permits for production activity (e.g., motion pictures and television) are generally required when asserting the exclusive use of city property, like a sidewalk, a street, or a park. See http://www1.nyc.gov/site/mome/permits/when-permit-required.page

4

Already on Open Data

2022

Mayors' Office of the Chief Counsel to the Mayor and City Hall

Agency expenditures on mental and physical health programs

ThriveNYC Programmatic Budget

3

Not on Open Data Plan

Does not meet qualifications for a “public data set” as defined by the Local Law 11 of 2012.

2022

Mayors' Office of the Chief Counsel to the Mayor and City Hall

Donation dollar amounts, number of donations, donations uses

Mayor’s Fund allocations to victims and families of Bronx fire on January 9, 2022

1

Not on Open Data Plan

The underlying data is owned and maintained by another city agency or organization.

2022

Mayors' Office of the Chief Counsel to the Mayor and City Hall

IDNYC Program Dashboard on 5/15/2015

Data showing appointments, applications processed, cards submitted for printing, printed and mailed for IDNYC through 5/15/2015

1

Not on Open Data Plan

This data was a one time survey conducted by the agency and to release the data will be an administrative burden to the agency.

2022

Mayors' Office of the Chief Counsel to the Mayor and City Hall

Key to NYC vaccine passport program warnings issued to businesses.

Spreadsheet with 10,646 rows with business names/addresses, type of violation, outcomes, status of written plan, and whether certain customers were asked for identification

1

Not on Open Data Plan

The underlying data is owned and maintained by another city agency or organization.

2022

Mayors' Office of the Chief Counsel to the Mayor and City Hall

NYC municipal archies archival review board report

Services report made by DORIS containing the amount of records archived, conserved, preserved, and time spent on data cleanup and inventory

1

Not on Open Data Plan

This is a strategic policy document and currently does not qualify as a public dataset as defined by Local Law 11 of 2012.

2022

Mayors' Office of the Chief Counsel to the Mayor and City Hall

Various COVID-related data shared with the Mayor's Office daily

These records were shared in a massive FOIL request for COVID emails. The data, which came originally from the CDC and DOHMH, included City Dashboards for staff absenteeism across various agencies, FDNY response time, 311 wait time, student absenteeism, hotel occupancy, hospital bed and staffing data, life-cycle of COVID on various surfaces, COVID testing and case data, PPE availability/need, and COVID 8 week projections.

7

Not on Open Data Plan

The underlying data is owned and maintained by another city agency or organization.

2022

Office of Administrative Tax Appeals (OATA)

Open Article 7 Petitions

The information in the City's computer records with respect to open petitions challenging real property tax assessments pursuant to Article 7 of the Real Property Tax Law. Contains the borough, block and lot numbers for the property, the index number and year the petition was commenced, the name of the petitioner, the name of the attorney for the petitioner and various note of issue codes.

1

Already on Open Data

2022

Office of Administrative Trials and Hearings (OATH)

Annual Report for NYC Admin. Code 24-163

This yearly report contains the number of engine idling summonses received each month and the monthly total penalty amount for the year 2021.

1

Already on Open Data

2022

Office of Administrative Trials and Hearings (OATH)

Bounty Payments For Idling Summonses Made to Individual

The spreadsheet contains Summons Numbers, Issuance Date of Payment/Payment amounts/Legal Name of Complainant and Description of Payment.

1

Not on Open Data Plan

The dataset contains the name of the Citizen Complainant/Non-respondent who received payments. OATH does not maintain this dataset in the ordinary course.

2022

Office of Administrative Trials and Hearings (OATH)

Bounty Payments Submitted to Comptroller's Office

The spreadsheet contains Dept Code/HDR Doc Id/HDR Record Date/Current Amount/Fiscal Year/Actg-Period. These are records of bounty payments that were sent to the Comptroller's Office for processing.

1

Not on Open Data Plan

This dataset contains Bounty Payments that were entered from 9/1/2021 - 11/16/2021. OATH does not maintain this dataset in the ordinary course.