transportation information mapping system: enterprise...
TRANSCRIPT
ENTERPRISE GIS FRAMEWORK
Ian Kidner, GISPGIS Systems Administrator
Office of Technical Services
Agenda
• Why TIMS• What is TIMS• Agency Processes• Benefits• Questions
2
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
3
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
4
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 VisionProvide Easy & Reliable Access to Information
Data Consistency Enables Decision Making Transparency
5
TIMS Customers
ODOT Local Governments
Business Partners
Research Partners
General Public
Private Economic Interests
6
• RFI/RFP/Dev 8/11 – 3/13• Released Spring ‘13• Flex, ArcServer 10.0• Decommissioned April ‘15
TIMS Program HistoryPhase 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)
• Difficulty updating system
7
• Released 2/15• HTML5/Javascript/Leaflet• ArcServer 10.2, SOE• Mobile Access
TIMS Program HistoryPhase 2: 2014 - Present
Pros:• Expanded Site• Improved User Experience• Better Site Management
Areas for Improvement• Increased workflow
alignment• Difficult balancing range of
user needs
8
TIMS Site AreasSearch 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.
Search for and view dataset and field descriptions.
9
Project Search
10
Project Information
11
Interactive MapMap Tool Menus
Configure Map Tools
View data records in table
12
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
13
Filter Data in the Map
14
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
• Leaflet API
15
Phone App
16
Phone App
17
Current DatasetsAviation 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
National Wetland Inventory Snow and Ice Priority RoutesAvailable as WMS & WFS
http://odotgis.dot.state.oh.us/arcgis/rest
18
Big IP Load Balancer
ArchitectureESRI Basemaps OIT Geocoder Service
Imagery Basemaps
ETL ServerArcServer 10.2
Oracle
SQL Server
Sybase
AccessSQL Server 2012
SDESDE
Application Web ServersIIS7; VmWare Vsphere 5.1; 1 Intel Xeon CPU
E5540 @ 2.53 GHz ; 2GB RAMArcGIS Web Adaptor
Map Services ArcServer 10.2Windows Server 2008 R2 SP1
VmWare Vsphere 5.1; 2 Intel Xeon CPU E5540 @ 2.53 GHz; 16 GB RAM
DMZ
External
Internal
19
Total Hits
System Performance
Site Traffic Analysis: 2/1/15 – 6/12/15
328,554
Average Page Views Per Day1,963
Average Length of Visit24 min
Visitor Repeat Rate59% Average RAM utilization(ArcServer Map Services)42%
Average RAM utilization(Application Server)25%
Average response time< 1 s
Average CPU utilization20%
May 2015 Server Performance Reports
20
TIMS Staffing
These figures represent commitmentduring system development; figuresfor system operation & maintenanceare lower
Position FTEProject Manager 0.1Technical Lead 0.8Software Developer 0.8Analyst 0.3QA 0.1
Total 2.1
Application Vendor Staff
Area Position FTEPlanning ODOT System Admin 0.6Planning GIS DB Admin 0.5Planning GIS Technicians 0.1Planning Project Manager 0.3Planning Business Analyst 0.2
IT IT GIS Admin 0.5IT IT Server Admin 0.25IT QA 0.5IT Data Analyst 1IT DBA (ETL Dev) 0.4IT DBA (admin) 0.1
Planning/IT Project Sponsors 0.05Total 4.5
ODOT Staff
21
Agency Processes & TIMS
Asset Management Leadership Team
TAM Audit Group
Technology Council
Standardized Data
TIMS
Iterative Processes
22
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
23
TIMS Data Access
Easy Data Access Errors in Data!
Pressure Data Owners to Clean
Up Source
Leverage TIMS to refine business
processes
TIMS helps ODOT as an agency better understand how information is used
24
Ian Kidner, GISPGIMS Systems AdministratorOffice of Technical Services
http://gis.dot.state.oh.us/[email protected]
614-752-5743