ENTERPRISE GIS FRAMEWORK
Ian Kidner, GISP
GIS Systems Administrator
Office of Technical Services
Agenda
•
Why TIMS
•
What is TIMS
•
Agency Processes
•
Benefits
•
Questions
Why TIMS
ODOT Mission
To provide easy movement of people and goods from place to place, we will:
• Take care of what we have • Make our system better • Improve safety
• Enhance capacity
ODOT Vision
A long-term, reliable, professional, and highly productive organization
Enterprise GIS Strategy
GIS Program Objectives
• Provide geospatial solutions to streamline workflow processes • Provide leadership for organizing and accessing data
• Provide solutions which are responsive to changing needs • Provide standards for uniform database structures
• Departmental policy for implementing GIS program objectives
Centralized Data
• Roads & Highways
• Data governance
Asset Management
• Collector
• Cross-agency processes
Customer Service
• Align with business • User-friendly solutions
Enterprise GIS Strategy
GIS Program Objectives
• Provide geospatial solutions to streamline workflow processes • Provide leadership for organizing and accessing data
• Provide solutions which are responsive to changing needs • Provide standards for uniform database structures
• Departmental policy for implementing GIS program objectives
Centralized Data
• Roads & Highways
• Data governance
Asset Management
• Collector
• Cross-agency processes
Customer Service
• Align with business • User-friendly solutions
TIMS Vision
Provide Easy & Reliable Access to Information
TIMS Customers
ODOT
Governments
Local
Business
Partners
Research
Partners
General
Public
Private
Economic
• RFI/RFP/Dev 8/11 – 3/13 • Released Spring ‘13
• Flex, ArcServer 10.0
• Decommissioned April ‘15
TIMS Program History
Phase I: 2011 - 2015
Pros:
• Provided data access • Provided analysis tools • Provided LRS tools Areas for Improvement
• User experience could be better (partly technology limitations at time)
• Released 2/15
• HTML5/Javascript/Leaflet • ArcServer 10.2, SOE
• Mobile Access
TIMS Program History
Phase 2: 2014 - Present
Pros:
• Expanded Site
• Improved User Experience
• Better Site Management
Areas for Improvement • Increased workflow
alignment
• Difficult balancing range of user needs
TIMS Site Areas
Search for transportation project information. View and search ODOT transportation data and create custom maps.
Download geodata by country, district or state. Generate maps with specific layouts and formats. Access interactive maps by content focus.
Interactive Map
Map Tool Menus
Configure Map Tools
Map Tool Menus
Map Layers
Find
Location
Identify
Tools
(Measure, Pathweb)Filter Data
Add Data
To Map
Basemaps
Print Map
Share Map
Resize
Map
Window
Phone App
•
Does not require app download
•
Navigate to same web address using
smartphone web-browser
•
Site automatically directs to
appropriate application based on
device type
Current Datasets
Aviation Facilities Noisewall Inventory State Mileposts BMP Inventory NRCS HUC 10 STS Active Rail Lines Bridge Inventory NRCS HUC 11 STS Airports
Bridge Maintenance Restrictions NRCS HUC 12 STS AMTRAK out of State Rail Lines Cities NRCS HUC 14 STS Amtrak Passenger Terminals Coastal Management Areas NRCS HUC 8 STS AOSTS Regions
Counties ODOT Districts STS Bike Routes County Mileposts ODOT Facilities STS Freeway Systems Culvert Inventory OFS Outfalls STS Go Bus Stop Ellis Lines Ohio State House Districts STS Highway Ellis Points Ohio State Senate Districts STS National Transit EPA Ecological Regions Patrol Outposts STS Rail Corridors Facilities Improvements Pavement Condition Ratings STS Railroad
FEMA Floodplains Pile Driving Restrictions STS Water State Corridors Fill Restrictions Places STS Waterports
Herbicide Restrictions Railroad Inventory STS Waterways Historic Bridge Inventory Regional Supplemental Boundaries Townships Intermodal Connectors Road Inventory Traffic AADT
Intermodal Facilities Road Inventory Rail Crossing Points Traffic Count Stations Maintenance Restrictions Rural Islands Tree Clearing Restrictions Metropolitan Planning Organizations Rural Planning Organizations Urban Areas
Mowing Restrictions Safety Barrier Inventory US House Districts National Landcover Database Scenic Rivers
Big IP Load Balancer
Architecture
ESRI Basemaps OIT Geocoder Service Imagery Basemaps ETL Server ArcServer 10.2 Oracle SQL Server Sybase Access SQL Server 2012 SDE SDE
Application Web Servers
IIS7; VmWare Vsphere 5.1; 1 Intel Xeon CPU E5540 @ 2.53 GHz ; 2GB RAM
ArcGIS Web Adaptor Map Services ArcServer 10.2 Windows Server 2008 R2 SP1 VmWare Vsphere 5.1; 2 Intel Xeon CPU
E5540 @ 2.53 GHz; 16 GB RAM
DMZ External
Total Hits
System Performance
Site Traffic Analysis: 2/1/15 – 6/12/15
328,554
Average Page Views Per Day
1,963
Average Length of Visit
24 min
Visitor Repeat Rate
59%
42%
(ArcServer Map Services)Average RAM utilizationAverage RAM utilization (Application Server)
25%
Average response time
< 1 s
Average CPU utilization
20%
TIMS Staffing
These figures represent commitment during system development; figures for system operation & maintenance are lower Position FTE Project Manager 0.1 Technical Lead 0.8 Software Developer 0.8 Analyst 0.3 QA 0.1 Total 2.1 Application Vendor Staff Area Position FTE
Planning ODOT System Admin 0.6
Planning GIS DB Admin 0.5
Planning GIS Technicians 0.1 Planning Project Manager 0.3 Planning Business Analyst 0.2
IT IT GIS Admin 0.5
IT IT Server Admin 0.25
IT QA 0.5
IT Data Analyst 1
IT DBA (ETL Dev) 0.4
IT DBA (admin) 0.1
Planning/IT Project Sponsors 0.05
Total 4.5 ODOT Staff
Agency Processes & TIMS
Asset Management Leadership Team
TAM Audit Group
Technology Council
Standardized Data
TIMS
TIMS Functionality
Simple Analytical Functions Customers Want More Customer Self-Service Better Decision Making/Planning Manage Expectations Workflow Focused Apps?How many apps is that? AGO/other COTS? Looking at integrating where appropriate Lack of transportation specific tools
TIMS Data Access
Easy Data Access Errors in Data!
Pressure Data Owners to Clean Up Source Leverage TIMS to refine business processes
