Metropolitan Transportation Authority (MTA) Capital Dashboard Agencies Summary - All Load Dates

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.ny.gov
Id ehz8-ag3n
Name Metropolitan Transportation Authority (MTA) Capital Dashboard Agencies Summary - All Load Dates
Attribution MTA Headquarters, New York City Transit, Long Island Rail Road, Metro-North Railroad, MTA Bus and MTA Bridges and Tunnels
Category Transportation
Tags capital program, mta capital plan, capital projects
Created 2013-04-25T17:00:29Z
Publication Date 2017-01-06T23:26:48Z

Description

The Capital Dashboard data provides information about the projects in the MTA?s 2010 to 2014 and 2005 ? 2009 Capital Programs. The data describes the planned projects and provide information about the status of Project Budgets, Scopes and Schedules.

Columns

| Included | Schema Type    | Field Name                         | Name                              | Data Type | Render Type |
| ======== | ============== | ================================== | ================================= | ========= | =========== |
| Yes      | series tag     | project_number                     | Project Number                    | text      | text        |
| Yes      | series tag     | capital_plan                       | Capital Plan                      | text      | text        |
| Yes      | time           | load_date                          | Load Date                         | text      | number      |
| Yes      | numeric metric | plan_revision_keys                 | Plan Revision Keys                | number    | text        |
| Yes      | series tag     | plan_revision_display_keys         | Plan Revision Display Keys        | text      | text        |
| Yes      | series tag     | agency_code                        | Agency Code                       | text      | text        |
| Yes      | series tag     | category                           | Category                          | text      | text        |
| Yes      | series tag     | element                            | Element                           | text      | text        |
| Yes      | series tag     | project                            | Project                           | text      | text        |
| Yes      | series tag     | agency_name                        | Agency Name                       | text      | text        |
| Yes      | series tag     | category_description               | Category Description              | text      | text        |
| Yes      | series tag     | element_description                | Element Description               | text      | text        |
| Yes      | series tag     | project_description                | Project Description               | text      | text        |
| Yes      | series tag     | scope_objective                    | Scope Objective                   | text      | text        |
| Yes      | series tag     | phase                              | Phase                             | text      | text        |
| Yes      | numeric metric | origional_budget                   | Original Budget                   | money     | money       |
| Yes      | numeric metric | current_budget                     | Current Budget                    | money     | money       |
| Yes      | numeric metric | origional_budget_vs_current_budget | Original Budget vs Current Budget | percent   | percent     |
| Yes      | series tag     | overall_scope_change               | Overall Scope Change              | text      | text        |
| Yes      | numeric metric | origional_start_month              | Original Start Month              | number    | text        |
| Yes      | numeric metric | origional_start_year               | Original Start Year               | number    | text        |
| Yes      | series tag     | current_start_year                 | Current Start Year                | text      | text        |
| Yes      | series tag     | current_start_month                | Current Start Month               | text      | text        |
| Yes      | series tag     | origional_completion_month         | Original Completion Month         | text      | text        |
| Yes      | series tag     | origional_completion_year          | Original Completion Year          | text      | text        |
| Yes      | series tag     | current_completion_month           | Current Completion Month          | text      | text        |
| Yes      | series tag     | current_completion_year            | Current Completion Year           | text      | text        |
| Yes      | series tag     | design_start_month                 | Design Start Month                | text      | text        |
| Yes      | series tag     | design_start_year                  | Design Start Year                 | text      | text        |
| Yes      | series tag     | design_completion_month            | Design Completion Month           | text      | text        |
| Yes      | series tag     | design_completion_year             | Design Completion Year            | text      | text        |
| Yes      | series tag     | construction_start_month           | Construction Start Month          | text      | text        |
| Yes      | series tag     | construction_start_year            | Construction Start Year           | text      | text        |
| Yes      | series tag     | construction_completion_month      | Construction Completion Month     | text      | text        |
| Yes      | series tag     | construction_completion_year       | Construction Completion Year      | text      | text        |
| Yes      | numeric metric | percentage_complete                | Percentage Complete               | percent   | percent     |
| Yes      | series tag     | current_quarter_flag               | Current Quarter Flag              | text      | text        |
| Yes      | series tag     | location_indicator                 | Location Indicator                | text      | text        |

Time Field

Value = load_date
Format & Zone = yyyyMMdd

Data Commands

series e:ehz8-ag3n d:2010-04-26T00:00:00.000Z t:construction_start_month=5 t:design_start_month=10 t:design_start_year=2003 t:element_description="Cross-Bay Bridge" t:location_indicator=base t:current_completion_year=2010 t:design_completion_year=2006 t:agency_code=D t:current_start_year=2007 t:element=CB t:current_start_month=5 t:construction_completion_month=5 t:project_number=D501CB08 t:design_completion_month=5 t:construction_start_year=2007 t:category_description=Structures t:scope_objective="This project rehabilitates the concrete deck and replaces the bridge drainage system at the Cross Bay Bridge.  Also as part of this project, CCTV, fiber-optic cable, and Variable Speed Limit Signs will be installed." t:agency_name="Bridges and Tunnels" t:project_description="Deck And Structural Rehabilitation - Cross Bay Bri" t:project=08 t:origional_completion_month=5 t:category=501 t:origional_completion_year=2008 t:plan_revision_display_keys="2005 Apr.,2005 Dec.,2006 Dec.,2008 Jul.,2009 Jul.,Current" t:capital_plan="Capital Plan 2005 - 2009" t:current_completion_month=5 t:phase=Support t:construction_completion_year=2010 m:current_budget=69342412 m:origional_budget_vs_current_budget=42 m:percentage_complete=93 m:origional_budget=48844604 m:plan_revision_keys=200504200512200600000000000000000000

series e:ehz8-ag3n d:2010-10-21T00:00:00.000Z t:construction_start_month=5 t:design_start_month=10 t:design_start_year=2003 t:element_description="Cross-Bay Bridge" t:location_indicator=base t:current_completion_year=2010 t:design_completion_year=2006 t:agency_code=D t:current_start_year=2007 t:element=CB t:current_start_month=5 t:construction_completion_month=5 t:project_number=D501CB08 t:design_completion_month=5 t:construction_start_year=2007 t:category_description=Structures t:scope_objective="This project rehabilitates the concrete deck and replaces the bridge drainage system at the Cross Bay Bridge.  Also as part of this project, CCTV, fiber-optic cable, and Variable Speed Limit Signs will be installed." t:agency_name="Bridges and Tunnels" t:project_description="Deck And Structural Rehabilitation - Cross Bay Bri" t:project=08 t:origional_completion_month=5 t:category=501 t:origional_completion_year=2008 t:plan_revision_display_keys="2005 Apr.,2005 Dec.,2006 Dec.,2008 Jul.,2009 Jul.,Current" t:capital_plan="Capital Plan 2005 - 2009" t:current_completion_month=5 t:phase=Support t:construction_completion_year=2010 m:current_budget=66557550 m:origional_budget_vs_current_budget=36 m:percentage_complete=93 m:origional_budget=48844604 m:plan_revision_keys=200504200512200600000000000000000000

series e:ehz8-ag3n d:2010-12-31T00:00:00.000Z t:construction_start_month=5 t:design_start_month=10 t:design_start_year=2003 t:element_description="Cross-Bay Bridge" t:location_indicator=base t:current_completion_year=2010 t:design_completion_year=2006 t:agency_code=D t:current_start_year=2007 t:element=CB t:current_start_month=5 t:construction_completion_month=5 t:project_number=D501CB08 t:design_completion_month=5 t:construction_start_year=2007 t:category_description=Structures t:scope_objective="This project rehabilitates the concrete deck and replaces the bridge drainage system at the Cross Bay Bridge. Also as part of this project, CCTV, fiber-optic cable, and Variable Speed Limit Signs will be installed." t:agency_name="Bridges and Tunnels" t:project_description="Deck And Structural Rehabilitation - Cross Bay Bri" t:project=08 t:origional_completion_month=5 t:category=501 t:origional_completion_year=2008 t:plan_revision_display_keys="2005 Apr.,2005 Dec.,2006 Dec.,2008 Jul.,2009 Jul.,Current" t:capital_plan="Capital Plan 2005 - 2009" t:current_completion_month=5 t:phase=Support t:construction_completion_year=2010 m:current_budget=66557550 m:origional_budget_vs_current_budget=36 m:percentage_complete=100 m:origional_budget=48844604 m:plan_revision_keys=200504200512200600000000000000000000

Meta Commands

metric m:plan_revision_keys p:long l:"Plan Revision Keys" d:"These are the Plan Admendment Keys that will be needed to link to the PLAN_REV field in the Capital Dashboard Detail data. The keys are all in one field because the number of keys can vary for each PROj_NUM. (Format: YYYYMM)" t:dataTypeName=number

metric m:origional_budget p:long l:"Original Budget" d:"This field shows the original MTA Board (or Capital Program Review Board) approved budget amount for each project." t:dataTypeName=money

metric m:current_budget p:double l:"Current Budget" d:"This field shows the latest available value for the project budget as recorded in the MTA Capital Program Management System." t:dataTypeName=money

metric m:origional_budget_vs_current_budget p:integer l:"Original Budget vs Current Budget" d:"This calculated field shows the difference between the Original Budget and the Current Budget as a percentage of the Original Budget. A budget decrease exceeding 10% is indicated by green text, a budget increase exceeding 10% is indicated by red text on t" t:dataTypeName=percent

metric m:origional_start_month p:long l:"Original Start Month" d:"This field shows the Original Construction Start Date or the start date of major activity for each project." t:dataTypeName=number

metric m:origional_start_year p:long l:"Original Start Year" d:"This field shows the Original Construction Start Date or the start date of major activity for each project." t:dataTypeName=number

metric m:percentage_complete p:integer l:"Percentage Complete" d:"This field shows the percentage based on the total project budget expended." t:dataTypeName=percent

entity e:ehz8-ag3n l:"Metropolitan Transportation Authority (MTA) Capital Dashboard Agencies Summary - All Load Dates" t:attribution="MTA Headquarters, New York City Transit, Long Island Rail Road, Metro-North Railroad, MTA Bus and MTA Bridges and Tunnels" t:url=https://data.ny.gov/api/views/ehz8-ag3n

property e:ehz8-ag3n t:meta.view v:id=ehz8-ag3n v:category=Transportation v:attributionLink=http://www.mta.info/developers/download.html v:averageRating=0 v:name="Metropolitan Transportation Authority (MTA) Capital Dashboard Agencies Summary - All Load Dates" v:attribution="MTA Headquarters, New York City Transit, Long Island Rail Road, Metro-North Railroad, MTA Bus and MTA Bridges and Tunnels"

property e:ehz8-ag3n 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:ehz8-ag3n 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"

Top Records

| project_number | capital_plan             | load_date | plan_revision_keys                        | plan_revision_display_keys                                | agency_code | category | element | project | agency_name         | category_description | element_description | project_description                                | scope_objective                                                                                                                                                                                                                            | phase   | origional_budget | current_budget | origional_budget_vs_current_budget | overall_scope_change | origional_start_month | origional_start_year | current_start_year | current_start_month | origional_completion_month | origional_completion_year | current_completion_month | current_completion_year | design_start_month | design_start_year | design_completion_month | design_completion_year | construction_start_month | construction_start_year | construction_completion_month | construction_completion_year | percentage_complete | current_quarter_flag | location_indicator | 
| ============== | ======================== | ========= | ========================================= | ========================================================= | =========== | ======== | ======= | ======= | =================== | ==================== | =================== | ================================================== | ========================================================================================================================================================================================================================================== | ======= | ================ | ============== | ================================== | ==================== | ===================== | ==================== | ================== | =================== | ========================== | ========================= | ======================== | ======================= | ================== | ================= | ======================= | ====================== | ======================== | ======================= | ============================= | ============================ | =================== | ==================== | ================== | 
| D501CB08       | Capital Plan 2005 - 2009 | 20100426  | 200504,200512,200612,200807,200907,999999 | 2005 Apr.,2005 Dec.,2006 Dec.,2008 Jul.,2009 Jul.,Current | D           | 501      | CB      | 08      | Bridges and Tunnels | Structures           | Cross-Bay Bridge    | Deck And Structural Rehabilitation - Cross Bay Bri | This project rehabilitates the concrete deck and replaces the bridge drainage system at the Cross Bay Bridge. Also as part of this project, CCTV, fiber-optic cable, and Variable Speed Limit Signs will be installed.                     | Support | 48844604         | 69342412.00    | 42                                 |                      |                       |                      | 2007               | 5                   | 5                          | 2008                      | 5                        | 2010                    | 10                 | 2003              | 5                       | 2006                   | 5                        | 2007                    | 5                             | 2010                         | 93                  |                      | base               | 
| D501CB08       | Capital Plan 2005 - 2009 | 20101021  | 200504,200512,200612,200807,200907,999999 | 2005 Apr.,2005 Dec.,2006 Dec.,2008 Jul.,2009 Jul.,Current | D           | 501      | CB      | 08      | Bridges and Tunnels | Structures           | Cross-Bay Bridge    | Deck And Structural Rehabilitation - Cross Bay Bri | This project rehabilitates the concrete deck and replaces the bridge drainage system at the Cross Bay Bridge. Also as part of this project, CCTV, fiber-optic cable, and Variable Speed Limit Signs will be installed.                     | Support | 48844604         | 66557550.00    | 36                                 |                      |                       |                      | 2007               | 5                   | 5                          | 2008                      | 5                        | 2010                    | 10                 | 2003              | 5                       | 2006                   | 5                        | 2007                    | 5                             | 2010                         | 93                  |                      | base               | 
| D501CB08       | Capital Plan 2005 - 2009 | 20101231  | 200504,200512,200612,200807,200907,999999 | 2005 Apr.,2005 Dec.,2006 Dec.,2008 Jul.,2009 Jul.,Current | D           | 501      | CB      | 08      | Bridges and Tunnels | Structures           | Cross-Bay Bridge    | Deck And Structural Rehabilitation - Cross Bay Bri | This project rehabilitates the concrete deck and replaces the bridge drainage system at the Cross Bay Bridge. Also as part of this project, CCTV, fiber-optic cable, and Variable Speed Limit Signs will be installed.                     | Support | 48844604         | 66557550.00    | 36                                 |                      |                       |                      | 2007               | 5                   | 5                          | 2008                      | 5                        | 2010                    | 10                 | 2003              | 5                       | 2006                   | 5                        | 2007                    | 5                             | 2010                         | 100                 |                      | base               | 
| D501CB08       | Capital Plan 2005 - 2009 | 20110331  | 200504,200512,200612,200807,200907,999999 | 2005 Apr.,2005 Dec.,2006 Dec.,2008 Jul.,2009 Jul.,Current | D           | 501      | CB      | 08      | Bridges and Tunnels | Structures           | Cross-Bay Bridge    | Deck And Structural Rehabilitation - Cross Bay Bri | This project rehabilitates the concrete deck and replaces the bridge drainage system at the Cross Bay Bridge. Also as part of this project, CCTV, fiber-optic cable, and Variable Speed Limit Signs will be installed.                     | Support | 48844604         | 63199770.13    | 29                                 |                      |                       |                      | 2007               | 5                   | 5                          | 2008                      | 5                        | 2010                    | 10                 | 2003              | 5                       | 2006                   | 5                        | 2007                    | 5                             | 2010                         | 100                 |                      | base               | 
| D501CB08       | Capital Plan 2005 - 2009 | 20110630  | 200504,200512,200612,200807,200907,999999 | 2005 Apr.,2005 Dec.,2006 Dec.,2008 Jul.,2009 Jul.,Current | D           | 501      | CB      | 08      | Bridges and Tunnels | Structures           | Cross-Bay Bridge    | Deck And Structural Rehabilitation - Cross Bay Bri | This project rehabilitates the concrete deck and replaces the bridge drainage system at the Cross Bay Bridge. Also as part of this project, closed circuit TV (CCTV), fiber-optic cable, and Variable Speed Limit Signs will be installed. | Support | 48844604         | 63199770.13    | 29                                 |                      |                       |                      | 2007               | 5                   | 5                          | 2008                      | 5                        | 2010                    | 10                 | 2003              | 5                       | 2006                   | 5                        | 2007                    | 5                             | 2010                         | 100                 |                      | base               | 
| D501CB08       | Capital Plan 2005 - 2009 | 20110930  | 200504,200512,200612,200807,200907,999999 | 2005 Apr.,2005 Dec.,2006 Dec.,2008 Jul.,2009 Jul.,Current | D           | 501      | CB      | 08      | Bridges and Tunnels | Structures           | Cross-Bay Bridge    | Deck And Structural Rehabilitation - Cross Bay Bri | This project rehabilitates the concrete deck and replaces the bridge drainage system at the Cross Bay Bridge. Also as part of this project, closed circuit TV (CCTV), fiber-optic cable, and Variable Speed Limit Signs will be installed. | Support | 48844604         | 63199770.13    | 29                                 |                      |                       |                      | 2007               | 5                   | 5                          | 2008                      | 5                        | 2010                    | 10                 | 2003              | 5                       | 2006                   | 5                        | 2007                    | 5                             | 2010                         | 100                 |                      | base               | 
| D501CB08       | Capital Plan 2005 - 2009 | 20111231  | 200504,200512,200612,200807,200907,999999 | 2005 Apr.,2005 Dec.,2006 Dec.,2008 Jul.,2009 Jul.,Current | D           | 501      | CB      | 08      | Bridges and Tunnels | Structures           | Cross-Bay Bridge    | Deck And Structural Rehabilitation - Cross Bay Bri | This project rehabilitates the concrete deck and replaces the bridge drainage system at the Cross Bay Bridge. Also as part of this project, closed circuit TV (CCTV), fiber-optic cable, and Variable Speed Limit Signs will be installed. | Support | 48844604         | 63199770.13    | 29                                 |                      |                       |                      | 2007               | 5                   | 5                          | 2008                      | 5                        | 2010                    | 10                 | 2003              | 5                       | 2006                   | 5                        | 2007                    | 5                             | 2010                         | 100                 |                      | base               | 
| D501CB08       | Capital Plan 2005 - 2009 | 20120330  | 200504,200512,200612,200807,200907,999999 | 2005 Apr.,2005 Dec.,2006 Dec.,2008 Jul.,2009 Jul.,Current | D           | 501      | CB      | 08      | Bridges and Tunnels | Structures           | Cross-Bay Bridge    | Deck And Structural Rehabilitation - Cross Bay Bri | This project rehabilitates the concrete deck and replaces the bridge drainage system at the Cross Bay Bridge. Also as part of this project, closed circuit TV (CCTV), fiber-optic cable, and Variable Speed Limit Signs will be installed. | Support | 48844604         | 63199770.13    | 29                                 |                      |                       |                      | 2007               | 5                   | 5                          | 2008                      | 5                        | 2010                    | 10                 | 2003              | 5                       | 2006                   | 5                        | 2007                    | 5                             | 2010                         | 100                 |                      | base               | 
| D501CB08       | Capital Plan 2005 - 2009 | 20120630  | 200504,200512,200612,200807,200907,999999 | 2005 Apr.,2005 Dec.,2006 Dec.,2008 Jul.,2009 Jul.,Current | D           | 501      | CB      | 08      | Bridges and Tunnels | Structures           | Cross-Bay Bridge    | Deck And Structural Rehabilitation - Cross Bay Bri | This project rehabilitates the concrete deck and replaces the bridge drainage system at the Cross Bay Bridge. Also as part of this project, closed circuit TV (CCTV), fiber-optic cable, and Variable Speed Limit Signs will be installed. | Support | 48844604         | 63199770.13    | 29                                 |                      |                       |                      | 2007               | 5                   | 5                          | 2008                      | 5                        | 2010                    | 10                 | 2003              | 5                       | 2006                   | 5                        | 2007                    | 5                             | 2010                         | 100                 |                      | base               | 
| D501CB08       | Capital Plan 2005 - 2009 | 20120930  | 200504,200512,200612,200807,200907,999999 | 2005 Apr.,2005 Dec.,2006 Dec.,2008 Jul.,2009 Jul.,Current | D           | 501      | CB      | 08      | Bridges and Tunnels | Structures           | Cross-Bay Bridge    | Deck And Structural Rehabilitation - Cross Bay Bri | This project rehabilitates the concrete deck and replaces the bridge drainage system at the Cross Bay Bridge. Also as part of this project, closed circuit TV (CCTV), fiber-optic cable, and Variable Speed Limit Signs will be installed. | Support | 48844604         | 63199770.13    | 29                                 |                      |                       |                      | 2007               | 5                   | 5                          | 2008                      | 5                        | 2010                    | 10                 | 2003              | 5                       | 2006                   | 5                        | 2007                    | 5                             | 2010                         | 100                 |                      | base               |