310 likes | 330 Views
Learn about the NCDOT's strategic transportation investments and their GIS-based project prioritization process using the SPOT Online solution.
E N D
John Farley, GISP, CPM GIS Manager Project Prioritization with GIS NCDOT SPOT On!ine Solution February 27, 2015
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!ineUx • Web-based (HTML5/JavaScript ... Support for IE and Firefox) • Wizard / map-centric approach. • First step in a multi-step process 7 Steps Authentication
Concept of Operation SPOT On!ine NCDOT Scoring Geoprocessing SQL Server Project Entry NCDOT Costing Project Export (offline analysis) Project Prioritization
GIS • 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 … Geoprocessing
Workflow Create a Project Mapping Step Edit Project Export Delete Project Save Project Cost & Score Draft Submit to NCDOT Prioritize Submitted
User Interface Grid Map
User Roles • Create • Edit • Submit • Delete • Export • Create projects anywhere • Unsubmit • Override • Create/Edit/Delete Users • Create • Edit • Submit • Delete • Export • Create projects anywhere • Their mode only • Edit • Delete • Export
Area of Interest Partners are automatically associated to their geographical region SPOTandModeusers can “impersonate” partners
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… Prioritization O&M P1 Project P2 Project Px Project P3 Project P4 Project
Who won the last Cactus Bowl? Questions? Contact John Farley, GISP, CPM GIS Manager at NCDOT jcfarley@ncdot.gov 919.707.2151