About this Dataset

Statewide Transportation Improvement Plan

The dataset lists all projects in New York State for which Federal funding is proposed to be used that are scheduled to begin within a designated time frame of four federal fiscal years and will be updated every two years. It includes region and location information, responsible agency, project description, funding and costs (in millions) information, and project phase/status.
Organization: State of New York
Last updated: 2020-11-12T04:00:40.483636
Tags: capital-program, mpo, projects, stip

Tables

Table 1

@usgov.state_of_new_york_statewide_transportation_improvement_plan.table_1

536.83 kB
10,615 rows
13 columns

CREATE TABLE table_1 (
  "region" DOUBLE,
  "metropolitan_planning_organization" VARCHAR,
  "project_id_pin" VARCHAR  -- Project ID (PIN),
  "county" VARCHAR,
  "responsible_agency" VARCHAR,
  "project_description" VARCHAR,
  "short_description" VARCHAR,
  "phase_type" VARCHAR,
  "federal_fiscal_year" BIGINT,
  "federal_aid_fa_fund_type" VARCHAR  -- Federal Aid (FA) Fund Type,
  "fa_cost_in_millions" DOUBLE  -- FA Cost (in Millions),
  "n__non_federal_aid_rollup_in_millions" DOUBLE  -- Non-Federal-Aid Rollup (in Millions),
  "phase_status" VARCHAR
);