ncdot spot on!ine solution february 27, 2015 john farley, gisp, cpm gis manager project...
TRANSCRIPT
NCDOT SPOT On!ine Solution
February 27, 2015
John Farley, GISP, CPMGIS Manager
Project Prioritization with GIS
Introduction
• NCDOT Background
• Strategic Transportation Investments (STI) Bill
• NCDOT Planning and Prioritization Process- P1.0, P2.0, and P3.0…and beyond…
• SPOT On!ine Solution Overview
• Next Steps
Some Background Information about NCDOT
• NCDOT is responsible for 6 modes of transportation:- Aviation (74 publicly-owned airports)
- Bicycle and Pedestrian
- Ferries – 2nd largest system in US (behind Washington)
- Highways – Maintains 80,000 miles of highways (2nd only to Texas)
- Public Transportation
- Rail
• We have an Annual Budget of approx. $4.1 B (federal dollars account for 25% of total budget)
• And our Key Partners include:- 19 Metropolitan Planning Organizations (MPOs)
- 19 Rural Planning Organizations (RPOs)
- 14 Field Offices (Divisions)
Strategic Transportation Investments (STI)
• The NCDOT is responsible for implementing and managing a systematic, data driven prioritization process for all modes of transportation that drives NCDOT’s 10 Year Work Program. - This Prioritization process was initiated by Executive Order in 2009 and
became law in 2012.
• This represented a major departure from the past way of doing business- The new process is collaborative, requiring input from both internal
and external partners
- Increases the use of technology to display project information
- Solicits input on needs and rankings
- The Prioritization process occurs every 2
Strategic Transportation Investments (STI) History
• The first Prioritization process (“P1.0”), completed in February 2010
• P2.0, completed in January 2012, continued to mature the process through the development and implementation of a persistent database to store and source project information in SAP.
• Enter P3.0 (2014)- Improved on current automated processes for efficiency and ease of access
- Implemented a map based approach for the submittal, analysis, and publication of the State’s transportation priorities
Enter P3.0 and SPOT On!ine
• Reduced manual processes for scoring, ranking, and cost estimates.
• Improved visibility of project data to partners and taxpayers.
• Improved ease of use of creating, modifying, scoring, ranking, and viewing projects for SPOT and partners.
• Enhanced automation and flexibility for creating and modifying scoring criteria without requiring IT assistance.
• Provided a map-based, spatial view of project data.
• Provided a “framework” and foundation to facilitate future access of project data by DOT field personnel via mobile technology.
SPOT On!ine
• SPOT On!ine is the software implementation of the NCDOT STI- Map the projects and perform geo-processing- View projects with geospatial information- Score projects based on quantitative data determined by the
legislation. - Scored projects are then submitted to Transportation
Improvement Program for funding determination.
SPOT On!ine Ux
• Web-based (HTML5/JavaScript ... Support for IE and Firefox)
• Wizard / map-centric approach.
• First step in a multi-step process
Authentication
7 Steps
Concept of Operation
SPOT On!ine
NCDOT Scoring
NCDOT CostingSQL Server
Geoprocessing
Project Entry
Project Export (offline analysis)
Project Prioritization
GIS
Geoprocessing
• Approximately 15 GP calls
• Scoring
• Percent of Trucks, Truck Volume, Percent of Autos, Auto Volume, Average Commute Time, many more …
• Costing
• Parcel Id, County Number, Area Classification, Acreage Needed, Appraised Value, Percent Area Within Buffer, many more …
Mapping Step
Workflow
Submit to NCDOT
Edit Project
Delete Project
ExportSave ProjectDraft
Submitted
Cost & Score
Create a Project
Prioritize
User Interface
Grid Map
User Roles
• Create
• Edit
• Submit
• Delete
• Export
• Create projects anywhere
• Unsubmit
• Override
• Create/Edit/Delete Users
• Create projects anywhere- Their mode only
• Edit
• Delete
• Export
• Create
• Edit
• Submit
• Delete
• Export
Area of Interest
Partners are automatically associated to their geographical region
SPOT and Mode users can “impersonate” partners
15
16
17
18
19
20
21
22
23
24
25
26
27
Prioritization Improvement
• Much of the process continues to be manual and cumbersome, with the following business problems: - Amount of manual effort required during a short timeframe was
significant resulting in a limited number of projects that could be accessed.
- Lack of ability for Partners to evaluate projects before submittal.
- Prioritized project data was not visible to the Public in an understandable format.
- Timely data availability.
- Field personnel did not have the latest data and project information.
Next Steps…
P1 Project
P4 Project
P3 Project
P2 ProjectPx Project
PrioritizationO&M
Questions?
Who won the last Cactus Bowl?
ContactJohn Farley, GISP, CPM GIS Manager at NCDOT