ny-gov/metropolitan-transportation-authority-mta-capital-ehz8-ag3n
Icon for Socrata external plugin
 
Preview
  • metropolitan_transportation_authority_mta_capital
     
 
Readme
Updated 2 days ago
Indexed 4 hours ago

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

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

NameSocrata field nameColumn name in sgr mountData typeDescription
Location Indicatorlocation_indicatorlocation_indicatorTextThis indicates whether a project has a single or multiple locations, or a system wide project, or related to rolling stock such as buses or train cars, and funding for other projects. Example: • Base: A project has one location and must include a Latitude and Longitude value. • Multilocation: A project has multiple locations relatively close to one another. There will be multiple lines for the project, each having a unique set of Latitude and Longitude values. • Systemwide: Projects that span large areas such as track work or variety of system projects. • Car: Projects that deal with Rolling Stock for railroad or subway cars. • Bus: A project that deals with Rolling Stock for buses. • Dollar: Projects that are set up to hold funding for other projects.
Percentage Completepercentage_completepercentage_completeNumberThis field shows the percentage based on the total project budget expended.
Construction Completion Yearconstruction_completion_yearconstruction_completion_yearTextThis field shows the Construction Completion Date Year for each project.
Construction Completion Monthconstruction_completion_monthconstruction_completion_monthTextThis field shows the Construction Completion Date Month for each project.
Construction Start Yearconstruction_start_yearconstruction_start_yearTextThis field shows the Construction Start Date Year for each project.
Construction Start Monthconstruction_start_monthconstruction_start_monthTextThis field shows the Construction Start Date Month for each project.
Design Completion Yeardesign_completion_yeardesign_completion_yearTextThis field shows the Design Completion Date Year for each project.
Design Completion Monthdesign_completion_monthdesign_completion_monthTextThis field shows the Design Completion Date Month for each project.
Design Start Yeardesign_start_yeardesign_start_yearTextThis field shows the Design Start Date Year for each project.
Design Start Monthdesign_start_monthdesign_start_monthTextThis field shows the Design Start Date Month for each project.
Current Completion Yearcurrent_completion_yearcurrent_completion_yearTextThis field shows the Current Project Completion Date Year for each project.
Original Completion Yearorigional_completion_yearorigional_completion_yearTextThis field shows the Original Project Completion Date Year for each project.
Original Completion Monthorigional_completion_monthorigional_completion_monthTextThis field shows the Original Project Completion Date Month for each project.
Current Start Monthcurrent_start_monthcurrent_start_monthTextThis field shows the Current Project Start Date Month for each project.
Original Budget vs Current Budgetorigional_budget_vs_current_budgetorigional_budget_vs_current_budgetNumberThis 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
Current Budgetcurrent_budgetcurrent_budgetNumberThis field shows the latest available value for the project budget as recorded in the MTA Capital Program Management System.
Element Descriptionelement_descriptionelement_descriptionTextThis field shows the descriptive category title.
CategorycategorycategoryTextThis field shows the capital investment category.
Project Numberproject_numberproject_numberTextA capital project that invests funds over one or more phases of work (i.e., planning, design, purchase and installation, construction) to deliver a defined benefit (e.g., rehabilitating existing assets, improving or expanding the system). The field is a unique project identification code created by concatenating the AGENCY_CODE, CATEGORY, ELEMENT, and PROJECT.
Current Completion Monthcurrent_completion_monthcurrent_completion_monthTextThis field shows the Current Project Completion Date Month for each project.
Current Start Yearcurrent_start_yearcurrent_start_yearTextThis field shows the Current Project Start Date Year for each project.
Scope Objectivescope_objectivescope_objectiveTextThis narrative provides a summary level description of the project.
ProjectprojectprojectTextThis field shows a unique code that identifies each project within an element.
Original Start Yearorigional_start_yearorigional_start_yearTextThis field shows the Original Construction Start Date or the start date of major activity for each project.
Overall Scope Changeoverall_scope_changeoverall_scope_changeTextThis field indicates a change in overall project scope. I = Increase / D = Decrease / blank = 'No Change'
Original Budgetorigional_budgetorigional_budgetNumberThis field shows the original MTA Board (or Capital Program Review Board) approved budget amount for each project.
Project Descriptionproject_descriptionproject_descriptionTextThis field shows the descriptive project title.
Category Descriptioncategory_descriptioncategory_descriptionTextThis field shows the descriptive category title.
Plan Revision Keysplan_revision_keysplan_revision_keysTextThese 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)
Capital Plancapital_plancapital_planTextAn investment plan of the MTA Capital Program that links specific funding sources to planned investment projects over a particular period of time, typically 5-years.
Original Start Monthorigional_start_monthorigional_start_monthTextThis field shows the Original Construction Start Date or the start date of major activity for each project.
Current Quarter Flagcurrent_quarter_flagcurrent_quarter_flagTextCQ indicates the Load Date Records that are the most current quarter data published to the MTA CapitalDashboard
ElementelementelementTextThis field shows the element, a subset of a category.
PhasephasephaseTextThis field shows the Current phase for each project. Projects begin in Planning, progress to Design, then Construction and finally Completion.
Agency Nameagency_nameagency_nameTextThis field shows the descriptive MTA operating agency title.
Agency Codeagency_codeagency_codeTextMTA Operating Agency (D)Bridges_and_Tunnels (G)Capital_Construction (L)Long_Island_Railroad (M)Metro_North_Railroad (N)MTA_Interagency (S)SIRTOA (T)New_York_City_Transit (U)MTA_Bus_Company
Plan Revision Display Keysplan_revision_display_keysplan_revision_display_keysTextThese are the Plan Admendment Keys that are displayed on the detail page for each project. These can also be used to link to the BUDGET_SUBMISSION_DATE field in the Capital Dashboard Detail data.
Load Dateload_dateload_dateNumberThe Capital Program Dashboard is published on a quarterly basis. The LOADDATE field represents the quarter assoctaed with the data.
Upstream Metadata