ncdot spot on!ine solution february 27, 2015 john farley, gisp, cpm gis manager project...

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

jcfarley@ncdot.gov919.707.2151