A tale of Two Cities Shoreh Elhami Citywide GIS Manager City of Columbus Ohio Erick Lobao GIS Manager PRIME3SG Brandon Brown GIS Administrator City of Dublin Ohio A Tale of Two Cities Resources ID: 719815
Download Presentation The PPT/PDF document "Snow Plow Tracking and GIS" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Snow Plow Tracking and GIS
A tale of Two Cities
Shoreh ElhamiCitywide GIS ManagerCity of Columbus Ohio
Erick LobaoGIS ManagerPRIME3SG
Brandon BrownGIS AdministratorCity of Dublin OhioSlide2
A Tale of Two Cities
Resources
Columbus
DublinVehicles
8725
Staff
14050
Square Miles
229
25Centerline Miles8,976~300Centerline Segments86,8971,124*
*Simplified CenterlinesSlide3
Challenge
Gather User Requirements
What is this thing supposed to do?How should it work?Application DesignWeb-Application
User InterfaceData DevelopmentESRI Geoevent
Extension for ArcGISSystem ArchitectureGeoprocessingImplementation, Testing, Deployment
Happy Users!!Happy Servers!!
1 2 3 4Slide4
DublinSlide5
Dublin
Megan’s Dream (Public Works Director)All Snow Vehicles – AVL, plow & salt sensors
Easy way for staff to see:Which roads have we not treated?Vehicle historySnow event status updatesPublic view of our progressSlide6
Dublin
Requirements
RealityAgile(ish) project management styleTechnical JibberishSlide7
Columbus
Internal Application
- 2013
(Support Dispatchers, Supervisors & Decision Makers)
Display “Real-Time” Truck InformationSearch Truck ActivityGenerate Standard Reports
External Application - 2014
(Answer common questions from the public)What has been treated?What priority is my street?Slide8
DublinSlide9
DublinSlide10
DublinSlide11
DublinSlide12
DublinSlide13
Columbus
Beta
Software
IT InfrastructureInternal ApplicationPublic ApplicationSlide14
ColumbusSlide15
Columbus
Internal WarriorWatchSlide16
Columbus
Internal Warrior WatchSlide17
Columbus
Public WarriorWatch (Activity Cache)Slide18
Columbus
Public WarriorWatch (Priority Cache)Slide19
DublinSlide20
Dublin
Geoevent
workflowsFilter trucks, detect sensor status, populate data table, update street table if activitySaving DataOnly save what we really needSimplified Centerlines
SQL ViewsLet the database do some heavy lifting for statsServicesStream servicesJSON
websocketsWeb MapsSlide21
Columbus
Geoevent
workflows
Enterprise DataPerformance
Warrior
Watch
Enterprise
Geoevent
Python
Python
Internal
Public
fGDBSlide22
Dublin
Leaf Removal – trucks were out doing work
Showed areas for improvement in
GeoEvent ProcessesSequencingData storage vs pass throughSingle large process or separate processes
Backup environment to turn on if neededUser feedback during an eventSlide23
Columbus
Hired a company to perform
load testing
Applied various tests from 500, 1000, to 2000 users (ramped up @ 0.07 seconds or on impulse). As a result, made several changes including:
Additional Cores Additional MemoryModifying GeoProcessing FunctionsSlide24
ColumbusSlide25
Conclusion and Steps Ahead (Snow Plow AVL / GIS is AWESOME!!!!)
Decouple Event start/stop control & status updates
Show trucks (last reported position) on public mapTest integration with WazeManagement ConsoleDashboard MetricsSimplify Data ProcessingSlide26