pima county’s building inspector routing apps gis-t_automating inspections using the...• itd...
TRANSCRIPT
![Page 1: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/1.jpg)
Pima County’s Building Inspector
Routing Apps
![Page 2: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/2.jpg)
What is the vehicle routing problem (VRP)?
• Organizations service orders with a fleet of vehicles.
• Need to determine which orders should be serviced
by each vehicle or inspector.
• Default behavior is a least-cost solution.
![Page 3: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/3.jpg)
Orders
![Page 4: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/4.jpg)
Inspectors
![Page 5: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/5.jpg)
RoutesDefault solution is
least cost
![Page 6: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/6.jpg)
RoutesWe want a more equal solution
![Page 7: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/7.jpg)
Our Model
Inspections Table
Point Layer
Analyze Output
Error check and output Directions
Geocode Addresses
Solve VRPSolve VRP
Again
![Page 8: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/8.jpg)
Automating the Process
• Python script run on a daily basis
• Routes displayed on MapGuide
![Page 9: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/9.jpg)
What Does This Mean?
• DSD inspectors travel 34% fewer miles
• DSD is saving $197,000 per year on mileage and
inspectors’ time
•
• Our Street Network is improved by continuous
feedback from non-geocoded inspections and
addition of turn restrictions
• This model can be used by other departments
![Page 10: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/10.jpg)
Using Esri Navigator
• Navigator 2.0 for iPad
• Navigator for Android (Beta) is available now
![Page 11: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/11.jpg)
On the iPad or Android
![Page 12: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/12.jpg)
Demo 1
Take a look at Navigator for Android
![Page 13: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/13.jpg)
Mobile Map Package
• Create Mobile Map Package (MMP) in Arcgis Pro 1.3
• Symbology important if using your own data
• Create Separate Locator saved with the MMP
• Share the MMP with Navigator Users
• Ability to define Travel Modes (e.g. Walking Time,
Trucking Time)
• Need separate ND without Global Turn delays
![Page 14: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/14.jpg)
Create The Package
![Page 15: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/15.jpg)
Share The Package
![Page 16: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/16.jpg)
Download the MMPK
![Page 17: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/17.jpg)
Select the Map Package
![Page 18: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/18.jpg)
Download the Package
![Page 19: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/19.jpg)
The Map is now on the device
![Page 20: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/20.jpg)
Demo 2
Take a look at some Actual Routes
![Page 21: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/21.jpg)
Inspector Routing Webpage
![Page 22: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/22.jpg)
App Links
• Launch Navigator using App Link
<a href="arcgis-navigator://?stops=16755 N SAN PEDRO RIVER RD,32.512519,-110.499983,1605 E RIVER RD,32.290268,-110.947871,12641 N AJO AV,32.439579,-110.755793,12900 E ORGANIZATION RIDGE RD,32.408749,-110.719175,11761 E CALLE DEL VALLE,32.266937,-110.740895,2988 N SPIRIT DANCER TR,32.262052,-110.726185,Stacey,32.227415,-110.846551&travelMode=Driving Time&start=Stacey,32.227415,-110.846551&navigate=false">Routes for Stacey for Date: 2016-04-07</a>
• Built using Lat/Lon values from VRP
• Webpage created daily for Inspectors
![Page 23: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/23.jpg)
Individual Route in Navigator
![Page 24: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/24.jpg)
Future
• Use Inspectors Vacation schedule
• Creation of webpage for Customers to see the status of
their inspection
• Analyze routes periodically using Fleetistics to compare
actual vs VRP-generated
![Page 25: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/25.jpg)
Acknowledgements
• Felipe Morales who began the work
• Steve Whitney overall support
• Cody Cohn concept/scripting
• Jack Lloyd (web page)
• Esri analysts (Scott Sandusky, Weeliang Heng, Mark
Bockenhauer)
• DSD – Yves Khawam, Rich Franz-Under, Robert
Chandler, Dan Ice
• ITD – Doyle Johnson, Jon Schmidt, Kristina Brooks
![Page 26: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/26.jpg)
Thank You!
Ray Brice, Senior GIS Analyst
Pima County Information Technology Department
Questions?
![Page 27: Pima County’s Building Inspector Routing Apps GIS-T_Automating Inspections using the...• ITD –Doyle Johnson, Jon Schmidt, Kristina Brooks. Thank You! Ray Brice, Senior GIS Analyst](https://reader034.vdocuments.us/reader034/viewer/2022051508/5a9f98327f8b9a8e178ce9aa/html5/thumbnails/27.jpg)
Building the Network Dataset
• Builds a speed table first using: subdiv (20mph), stnetall, mt_lemmon poly
(30mph), ajo table, stspeed table
• Build ND next, inputs are: Connectors (5mph), Cochise (5mph), Pinal
(5mph), stnetall, stmisc (5mph), stfclass, Arizona Streets, speed table, urban
polygon (35mph), pinal polygon (45mph), stnoturn