MiTIP, the Metropolitan Indianapolis Transportation Program: Beyond - - PowerPoint PPT Presentation
MiTIP, the Metropolitan Indianapolis Transportation Program: Beyond the Spreadsheets in the 21 st Century October 26, 2016 Kristyn Campbell Senior Transportation Finance Analyst Indianapolis MPO kristyn.campbell@indympo.org (317)
Beyond the Spreadsheets in the 21st Century
October 26, 2016 Kristyn Campbell
Senior Transportation Finance Analyst Indianapolis MPO
kristyn.campbell@indympo.org (317) 327-5137
to assist the MPO with the development of MiTIP utilizing the firm’s Project Tracker Software as a Service (SaaS) to be a web-based database that stores and manages project data.
involved in the federal aid process.
– LPAs can easily view and amend their projects. – LPAs can run reports to get detailed information
– LPAs can submit quarterly reports and track the changes in their project development schedule. – LPAs can apply for Federal funds through the IMPO’s calls for projects.
2
close-out and provides an ease of data sharing with and accessibility to information for the public.
searched for using defined criteria (LPA, funding type, project type, etc.) or an interactive Google map.
3
via email to be approved on a quarterly basis.
– The IMPO receives amendments from 35 LPAs, INDOT, IndyGo, and CIRTA. – On average, the IMPO processes 45 amendments and 70 modifications each quarter.
via email into an excel spreadsheet for review and approval by the Indianapolis Regional Transportation Council (IRTC) each quarter.
update the IRTIP posted online for the public to view.
– The IRTIP document was also updated many times between quarterly amendments since modifications can be approved administratively by IMPO staff.
4
multiple spreadsheets allowing for the potential for data discrepancies.
consuming for a staff of only two and created a struggle to keep information up-to-date for the public to view on the MPO’s website.
5
When MiTIP was created, EcoInteractive imported all IRTIP project information from the IMPO’s excel spreadsheets. The secure MiTIP site can be accessed with a username and password and allows LPAs to:
– Historic and current
By requiring all LPAs to use MiTIP, the IMPO is able to gather and track consistent project information across the region. All project amendment versions, applications, and quarterly reports are saved in MiTIP as historic data for record keeping.
6
7
Every project record in MiTIP has seven tabs located across the top of its page. 1. TIP Programming – shows what is currently programmed in the IRTIP and is available for LPAs to edit in order to submit amendment requests to the IMPO.
8
9
Information System) obligations.
10
drawn from the state’s project management system (SPMS).
11
quarter with contracts and RW information, updated estimates, and their project schedule.
12
13
14
15
and link to an interactive map of all projects in the Indianapolis MPA located
16
to the project (i.e. environmental documents, RW clear letters, projects maps, etc.) and saves them for users to view on any project version.
17
projects’ funding history for viewing.
18
shows all projects in their current and proposed form for comparison.
shows all projects for a single LPA.
all programmed projects and cost, sorted by funding type and LPA.
project development timetable and progress for each LPA from project award to PO closeout.
Users can run multiple reports on data and MPO staff has the ability to work with EcoInteractive to create new reports, as needed.
MiTIP allows for more efficient productivity through its timeliness; saving both staff and LPA time. The secure MiTIP site allows IMPO Staff to:
– Historic (2009 – 2012 IRTIP) and current
– TIP amendments – Change orders – Quarterly reports – Applications for federal funds
NOTE: All changes to project data are tracked by usernames and are visible on all versions of project information in MiTIP. 19
20
all projects that currently require a quarterly report and their progress in preparing the report to submit to the IMPO each quarter.
the IMPO’s annual allocation currently stands against the POs that have been issued to date.
ranks CMAQ project applications based
information.
IMPO staff has access to run additional reports to better help staff manage the Indianapolis Transportation Improvement Program.
The public MiTIP website represents the most up-to-date version of the IRTIP.
– The site is automatically populated with updated information whenever a change is made on the secure MiTIP website.
Six tabs include:
– About the IRTIP/MiTIP – Federally approved 2016-2019 IRTIP – IRTIP Amendments – Advanced Search – Projects by County – Map
Our public website module is now being used by other MPOs nationwide.
21
MPO is the first of our national clients to implement the public interface allowing residents to see IRTIP information.”
The Federally Approved 2016-2019 IRTIP shows all projects currently programmed in the TIP. Search options include: Des #, LPA, Project Category (i.e. Bike/Ped, Bridge), Road System, and Route. Users can sort the projects by clicking
headers or export the table to an Excel spreadsheet.
22
The IRTIP Amendments tab shows a list of all amendments, and the projects contained within them, in the current 2016-2019 TIP.
highways/interstates and require an amendment rather than a modification.
years, minor funding changes, and transferring funding between phases (PE to ROW, etc.)).
rather than a modification.
23
Clicking on a [Project List] will open the specific list of amendments at the bottom of the page.
24
From the [Project List], users can click
see project overview information.
25
Additional tabs on the public website include project’s funding and amendment histories.
26
27 1.
2. Title or Description (Keywords) 3. Status – Before Obligation, Funding Obligated, In Construction, Construction Complete, Deleted, etc. 4. Location – System (i.e. Highway, Local, Transit), Street/Road Name, County 5. Lead Agency 6. Project Category – Bike/Ped, Intersection, Signal, etc. 7. Federal Funding – STP Group 1 (Urban), HSIP, SRTS, etc. 8. Year Programmed
28
Select the county/counties to view project information by
also click within the counties on the map to highlight the area’s projects.
Note: All new project applications are now required to map their project locations in MiTIP’s online database.
29
projects within Hamilton Co. and Marion Co.
highlighted on the map.
selected counties are shown at the bottom
30
you to search for a specific location or to zoom in and out to see what projects are located in certain neighborhoods.
various layers on or off to display different projects.
towards the bottom of the map are updated as users zoom in and out.
31
Users can click on the links and/or nodes to display project titles and des. numbers. For further information, users can click on the des. number to open project specific data.
32
MiTIP’s web-based project database and public website have improved the MPO’s TIP management process by providing:
users of requests or approvals upon submission in MiTIP
staff
requests
with internet access which allows for better sharing and collaboration
information
33
Five years after work with EcoInteractive was initiated, the IMPO continues to work with EcoInteractive to create new components and features to meet our needs as they arise. Features that will be available soon include:
upcoming 2045 LRTP Adoption Call for Projects to track performance measure goals.
process for a complete Pavement Management System.
34
The Public MiTIP Website can be explored at https://mitip.indympo.org/. There is also a Public Access Portal located on the MPO Homepage.
Please feel free to contact me with any questions or suggestions. Kristyn Campbell, Senior Transportation Finance Analyst kristyn.campbell@indympo.org (317) 327-5137