Statewide Transportation Improvement Plan

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.ny.gov
Id ygg4-74a7
Name Statewide Transportation Improvement Plan
Attribution New York State Department of Transportation (DOT)
Category Transportation
Tags stip, projects, capital program, mpo
Created 2015-07-29T18:58:50Z
Publication Date 2015-09-08T16:39:02Z

Description

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.

Columns

| Included | Schema Type    | Field Name          | Name                                 | Data Type | Render Type |
| ======== | ============== | =================== | ==================================== | ========= | =========== |
| No       | time           | :updated_at         | updated_at                           | meta_data | meta_data   |
| Yes      | series tag     | region              | Region                               | text      | number      |
| Yes      | series tag     | mpo                 | Metropolitan Planning Organization   | text      | text        |
| Yes      | series tag     | pin                 | Project ID (PIN)                     | text      | text        |
| Yes      | series tag     | county              | County                               | text      | text        |
| Yes      | series tag     | resp_agency         | Responsible Agency                   | text      | text        |
| Yes      | series tag     | project_description | Project Description                  | text      | text        |
| Yes      | series tag     | short_description   | Short Description                    | text      | text        |
| Yes      | series tag     | phase_type          | Phase Type                           | text      | text        |
| Yes      | numeric metric | ffy                 | Federal Fiscal Year                  | number    | number      |
| Yes      | series tag     | fa_fund_type        | Federal Aid (FA) Fund Type           | text      | text        |
| Yes      | numeric metric | fa_cost             | FA Cost (in millions)                | money     | money       |
| Yes      | numeric metric | nfa_rollup          | Non-Federal-Aid Rollup (in millions) | money     | money       |
| Yes      | series tag     | phase_status        | Phase Status                         | text      | text        |

Time Field

Value = updated_at
Format & Zone = seconds

Data Commands

series e:ygg4-74a7 d:2015-09-02T05:04:20.000Z t:region=1 t:resp_agency=NYSDOT t:short_description="RT.196 OVER GLENS FALLS FEEDER" t:pin=102407 t:county=WASHINGTON t:phase_status=Programmed t:mpo=AGFTC t:fa_fund_type="STP FLEX" t:project_description="BRIDGE REPAIR OR REPLACEMENT TO ADDRESS CONDITION RATING:, RT.196 OVER GLENS FALLS FEEDER CANAL, BIN 4039800,  VILLAGE OF HUDSON FALLS, WASHINGTON COUNTY .    WAS128" t:phase_type=CONINSP m:fa_cost=0.11 m:ffy=2015 m:nfa_rollup=0.03

series e:ygg4-74a7 d:2015-09-02T05:04:20.000Z t:region=1 t:resp_agency=NYSDOT t:short_description="RT.196 OVER GLENS FALLS FEEDER" t:pin=102407 t:county=WASHINGTON t:phase_status=Programmed t:mpo=AGFTC t:fa_fund_type="STP FLEX" t:project_description="BRIDGE REPAIR OR REPLACEMENT TO ADDRESS CONDITION RATING:, RT.196 OVER GLENS FALLS FEEDER CANAL, BIN 4039800,  VILLAGE OF HUDSON FALLS, WASHINGTON COUNTY .    WAS128" t:phase_type=CONST m:fa_cost=1.9 m:ffy=2015 m:nfa_rollup=0.47

series e:ygg4-74a7 d:2015-09-02T05:04:20.000Z t:region=1 t:resp_agency=NYSDOT t:short_description="RT.196 OVER GLENS FALLS FEEDER" t:pin=102407 t:county=WASHINGTON t:phase_status=Programmed t:mpo=AGFTC t:fa_fund_type="STP FLEX" t:project_description="BRIDGE REPAIR OR REPLACEMENT TO ADDRESS CONDITION RATING:, RT.196 OVER GLENS FALLS FEEDER CANAL, BIN 4039800,  VILLAGE OF HUDSON FALLS, WASHINGTON COUNTY .    WAS128" t:phase_type=ROWACQU m:fa_cost=0.01 m:ffy=2014 m:nfa_rollup=0

Meta Commands

metric m:ffy p:integer l:"Federal Fiscal Year" d:"Federal fiscal year (FFY) in which funding for each phase is to be obligated. The Federal Fiscal Year runs from 10/1 of a calendar year until 9/30 of the next. Each STIP consists of a five-year plan for five consecutuve FFYs." t:dataTypeName=number

metric m:fa_cost p:double l:"FA Cost (in millions)" d:"Federal-Aid Funds (in $ millions) for each project based on its Project Identification Number (PIN), by phase, federal cost and year (record)." t:dataTypeName=money

metric m:nfa_rollup p:double l:"Non-Federal-Aid Rollup (in millions)" d:"Total amount of Non-Federal-Aid Funds (in $ millions) for that record." t:dataTypeName=money

entity e:ygg4-74a7 l:"Statewide Transportation Improvement Plan" t:attribution="New York State Department of Transportation (DOT)" t:url=https://data.ny.gov/api/views/ygg4-74a7

property e:ygg4-74a7 t:meta.view v:id=ygg4-74a7 v:category=Transportation v:attributionLink=https://www.dot.ny.gov/programs/stip/stip-project-rpt v:averageRating=0 v:name="Statewide Transportation Improvement Plan" v:attribution="New York State Department of Transportation (DOT)"

property e:ygg4-74a7 t:meta.view.owner v:id=xzik-pf59 v:profileImageUrlMedium=/api/users/xzik-pf59/profile_images/THUMB v:profileImageUrlLarge=/api/users/xzik-pf59/profile_images/LARGE v:screenName="NY Open Data" v:profileImageUrlSmall=/api/users/xzik-pf59/profile_images/TINY v:displayName="NY Open Data"

property e:ygg4-74a7 t:meta.view.tableauthor v:id=xzik-pf59 v:profileImageUrlMedium=/api/users/xzik-pf59/profile_images/THUMB v:profileImageUrlLarge=/api/users/xzik-pf59/profile_images/LARGE v:screenName="NY Open Data" v:profileImageUrlSmall=/api/users/xzik-pf59/profile_images/TINY v:roleName=publisher v:displayName="NY Open Data"

property e:ygg4-74a7 t:meta.view.metadata.custom_fields.common_core v:Publisher="State of New York" v:Contact_Email=opendata@its.ny.gov v:Contact_Name="Open Data NY"

Top Records

| :updated_at | region | mpo   | pin    | county     | resp_agency | project_description                                                                                                                                               | short_description                                            | phase_type | ffy  | fa_fund_type | fa_cost | nfa_rollup | phase_status | 
| =========== | ====== | ===== | ====== | ========== | =========== | ================================================================================================================================================================= | ============================================================ | ========== | ==== | ============ | ======= | ========== | ============ | 
| 1441170260  | 1      | AGFTC | 102407 | WASHINGTON | NYSDOT      | BRIDGE REPAIR OR REPLACEMENT TO ADDRESS CONDITION RATING:, RT.196 OVER GLENS FALLS FEEDER CANAL, BIN 4039800, VILLAGE OF HUDSON FALLS, WASHINGTON COUNTY . WAS128 | RT.196 OVER GLENS FALLS FEEDER                               | CONINSP    | 2015 | STP FLEX     | 0.11    | 0.03       | Programmed   | 
| 1441170260  | 1      | AGFTC | 102407 | WASHINGTON | NYSDOT      | BRIDGE REPAIR OR REPLACEMENT TO ADDRESS CONDITION RATING:, RT.196 OVER GLENS FALLS FEEDER CANAL, BIN 4039800, VILLAGE OF HUDSON FALLS, WASHINGTON COUNTY . WAS128 | RT.196 OVER GLENS FALLS FEEDER                               | CONST      | 2015 | STP FLEX     | 1.90    | 0.47       | Programmed   | 
| 1441170260  | 1      | AGFTC | 102407 | WASHINGTON | NYSDOT      | BRIDGE REPAIR OR REPLACEMENT TO ADDRESS CONDITION RATING:, RT.196 OVER GLENS FALLS FEEDER CANAL, BIN 4039800, VILLAGE OF HUDSON FALLS, WASHINGTON COUNTY . WAS128 | RT.196 OVER GLENS FALLS FEEDER                               | ROWACQU    | 2014 | STP FLEX     | 0.01    | 0.00       | Programmed   | 
| 1441170260  | 1      | AGFTC | 102407 | WASHINGTON | NYSDOT      | BRIDGE REPAIR OR REPLACEMENT TO ADDRESS CONDITION RATING:, RT.196 OVER GLENS FALLS FEEDER CANAL, BIN 4039800, VILLAGE OF HUDSON FALLS, WASHINGTON COUNTY . WAS128 | RT.196 OVER GLENS FALLS FEEDER                               | ROWINCD    | 2014 | STP FLEX     | 0.01    | 0.00       | Programmed   | 
| 1441170260  | 1      | AGFTC | 104342 | SARATOGA   | NYSDOT      | RT. 9 OVER I-87 @ EXIT 17 , BRIDGE REPAIR; TOWN OF MOREAU , SARATOGA COUNTY SAR 115                                                                               | RT. 9 OVER I-87 @ EXIT 17                                    | CONINSP    | 2017 | NHPP         | 0.32    | 0.08       | Programmed   | 
| 1441170260  | 1      | AGFTC | 104342 | SARATOGA   | NYSDOT      | RT. 9 OVER I-87 @ EXIT 17 , BRIDGE REPAIR; TOWN OF MOREAU , SARATOGA COUNTY SAR 115                                                                               | RT. 9 OVER I-87 @ EXIT 17                                    | CONST      | 2017 | NHPP         | 3.15    | 0.79       | Programmed   | 
| 1441170260  | 1      | AGFTC | 104342 | SARATOGA   | NYSDOT      | RT. 9 OVER I-87 @ EXIT 17 , BRIDGE REPAIR; TOWN OF MOREAU , SARATOGA COUNTY SAR 115                                                                               | RT. 9 OVER I-87 @ EXIT 17                                    | DETLDES    | 2016 | NHPP         | 0.13    | 0.03       | Programmed   | 
| 1441170260  | 1      | AGFTC | 104342 | SARATOGA   | NYSDOT      | RT. 9 OVER I-87 @ EXIT 17 , BRIDGE REPAIR; TOWN OF MOREAU , SARATOGA COUNTY SAR 115                                                                               | RT. 9 OVER I-87 @ EXIT 17                                    | PRELDES    | 2015 | NHPP         | 0.17    | 0.04       | Programmed   | 
| 1441170260  | 1      | AGFTC | 175514 | WASHINGTON | LOCAL       | BRIDGE REPAIR OR REPLACEMENT TO ADDRESS CONDITION RATING: CR16 OVER HALFWAY BROOK, BIN 3306240, TOWN OF FORT ANN, WASHINGTON COUNTY WAS106                        | BIN 3306240, CR16 OVER HALFWAY BRK, BR REPL, FT ANN, WASH CO | CONINSP    | 2014 | STP FLEX     | 0.19    | 0.05       | Obligated    | 
| 1441170260  | 1      | AGFTC | 175514 | WASHINGTON | LOCAL       | BRIDGE REPAIR OR REPLACEMENT TO ADDRESS CONDITION RATING: CR16 OVER HALFWAY BROOK, BIN 3306240, TOWN OF FORT ANN, WASHINGTON COUNTY WAS106                        | BIN 3306240, CR16 OVER HALFWAY BRK, BR REPL, FT ANN, WASH CO | CONST      | 2014 | STP FLEX     | 1.59    | 0.40       | Obligated    |