getting the best roi from your gis -...
TRANSCRIPT
![Page 1: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/1.jpg)
Maximizing your use of GIS
products
Presenters:
Kevin Fowler, GIS Specialist,
Hubbell, Roth, & Clark, Inc
Erv Suida, DPS Director,
City of Howell
Getting the Best ROI
from Your GIS
![Page 2: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/2.jpg)
May 29, 2019 2
Background
City of Howell
≡Est. 1863
≡Pop. 9,489 (2010 Census)
≡5.12 sq. miles
![Page 3: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/3.jpg)
May 29, 2019 3
Background
≡Historical Downtown
≡Including many restaurants
and retail shop
≡Eight different parks
≡Public beach & lake access
2018 GREAT AMERICAN
MAIN STREET AWARD WINNER!
![Page 4: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/4.jpg)
May 29, 2019 4
Public Services
≡Department of Public Works
≡Water Treatment Plant
≡Wastewater Treatment Plant
![Page 5: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/5.jpg)
May 29, 2019 5
Howell SAW Grant
≡City received SAW grant for
$1,657,244 in November of 2016
≡Grant was for design, sanitary
and storm asset management
planning
≡High priority of the City was to
develop robust GIS to better
manage systems
![Page 6: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/6.jpg)
May 29, 2019 6
GIS Goals
Under SAW Grant
≡Inventory of sanitary sewer
and storm sewer
≡Develop geodatabase
≡Condition assessment
≡Criticality & Risk assessment
≡Develop CIP
≡Hardware/software
improvements and training.
![Page 7: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/7.jpg)
May 29, 2019 7
Biggest GIS Goal??
EFFICIENCY
![Page 8: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/8.jpg)
8May 29, 2019
WHERE DO WE START?
![Page 9: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/9.jpg)
9May 29, 2019
EXPECATIONS
![Page 10: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/10.jpg)
10May 29, 2019
REALITY
![Page 11: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/11.jpg)
11May 29, 2019
NEW & IMPROVED
![Page 12: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/12.jpg)
12May 29, 2019
![Page 13: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/13.jpg)
13May 29, 2019
What to collect
• Attributes?
• Spatial?
How to collect
• App?
• GPS?
Collection
![Page 14: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/14.jpg)
14May 29, 2019
![Page 15: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/15.jpg)
15May 29, 2019
Types of features and how should
they be grouped?
• PRV & GVW?
• CB & MH?
• Forcemain & Gravitymain?
How should the data be stored?
• Shapefiles?
• GeoDatabase?
• Enterprise system?
Organize
![Page 16: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/16.jpg)
16May 29, 2019
![Page 17: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/17.jpg)
17May 29, 2019
How to get data to work together
• Datasets
• Geometric Networks
• Related Tables
• Hyperlinks
Proper up keep & maintenance
Manage
![Page 18: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/18.jpg)
18May 29, 2019
![Page 19: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/19.jpg)
19May 29, 2019
The fun stuff!
Geoprocessing/Analysis
• Identify patterns
• Make predications
• Develop plans
Back into the field!
• Apps
• Field workflows
Utilize
![Page 20: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/20.jpg)
20May 29, 2019
What about my ROI?
![Page 21: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/21.jpg)
21May 29, 2019
Return on Investment
Measure the gain or loss of an
investment relative to the cost.
A metric used for hard numbers
ROI
GAIN - COST
COSTROI =
![Page 22: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/22.jpg)
22May 29, 2019
![Page 23: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/23.jpg)
24May 29, 2019
ESRI Products
• ArcMap
• ArcPro
• ArcGIS Online
• Web Maps
• Operations Dashboard
• Collector
• Survey 123
• Workforce
Desktop/Laptop
Online
Mobile
![Page 24: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/24.jpg)
25May 29, 2019
ArcGIS Online (AGO)Cloud-based mapping and analysis
• Load layers
• Create maps
• Share
• Analyze
• Mobile
AGO
Office/Master Data
![Page 25: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/25.jpg)
26May 29, 2019
ArcGIS Online (AGO)
![Page 26: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/26.jpg)
27May 29, 2019
ArcGIS Online (AGO)
![Page 27: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/27.jpg)
28May 29, 2019
Collector for ArcGISMobile data collection
• Collect asset locations
• Collect asset information
• Conduct surveys
• Real time maps in field
• Improve efficiency
Collector
AGO
Office/Master Data
![Page 28: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/28.jpg)
29May 29, 2019
Survey123 for ArcGISCreate, share, and analyze your surveys
• Form-centric data
collection
• Create Smart surveys
• Immediate access of real
time data
• Collect data via web or
mobile devices
![Page 29: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/29.jpg)
30May 29, 2019
Survey123 for ArcGIS
![Page 30: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/30.jpg)
31May 29, 2019
Side by side comparison
Survey123 Collector
Data collection style Form centric Map centric
Capture new data Yes (points only) Yes
Edit existing data Yes Yes
Smart forms Yes No
External GNSS receiver No (for now) Yes
Collector
AGO
Office/Master Data
Survey123
![Page 31: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/31.jpg)
32May 29, 2019
Operations Dashboard for ArcGISVisualization and analytics in an operational view
• Web Application
• Easy to build
• Interactive for users
• Add elements that break
down data
![Page 32: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/32.jpg)
33May 29, 2019
Operations Dashboard for ArcGISLook at all those elements
Elements can…
1. Monitor real time
2. Identify trends
3. Show what’s important
![Page 33: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/33.jpg)
34May 29, 2019
Operations Dashboard for ArcGIS
Daily Totals
How many
structures have
been added
Overview of
daily totals
Percent Complete
Structures of interest
Photos of structures
of interest
Field Crew Location
![Page 34: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/34.jpg)
35May 29, 2019
Collector
Dashboard
AGO
Office/Master Data
Survey123
![Page 35: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/35.jpg)
36May 29, 2019
New Work Order System
• City wanted to purchase and implement a new CMMS system
• Limited budget made purchasing software difficult
• At a minimum, looking to for a way to better manage daily
workorders
![Page 36: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/36.jpg)
37May 29, 2019
Workforce for ArcGISField coordination driven by GIS
• Improve field-to-office
workflow
• Create and manage
assignments
• Quickly send updates to
field staff
• Prioritize tasks
• Track and analyze daily
field work
![Page 37: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/37.jpg)
38May 29, 2019
Workforce for ArcGISField coordination driven by GIS
Two Major Roles
1. Dispatcher
2. Mobile Worker
Use web app to create assignments and
send to mobile workers while tracking
location and progress in real time
Use app to complete To Do lists and
receive assignments on their mobile
devices
![Page 38: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/38.jpg)
39May 29, 2019
Workforce for ArcGIS
![Page 39: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/39.jpg)
40May 29, 2019
Workforce for ArcGIS
![Page 40: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/40.jpg)
41May 29, 2019
Workforce for ArcGIS
![Page 41: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/41.jpg)
Collector
Dashboard
AGO
WorkforceDispatcher
Mobile Worker
Office/Master Data
Survey123
42May 29, 2019
![Page 42: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/42.jpg)
44May 29, 2019
ModelBuilder
![Page 43: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/43.jpg)
45May 29, 2019
Using CCTV Data to
Map Leads
![Page 44: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/44.jpg)
46May 29, 2019
CONCLUDERS
![Page 45: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/45.jpg)
47May 29, 2019
CONCLUDERS
This is a GIS
revolution!
![Page 46: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/46.jpg)
48May 29, 2019
CONCLUDERS
What you put in, is
what your going to
get out
Set yourself up for
success
![Page 47: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/47.jpg)
Collector
Dashboard
AGO
WorkforceDispatcher
Mobile Worker
Office/Master Data
Survey123
49May 29, 2019
![Page 48: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/48.jpg)
50May 29, 2019
CONCLUDERS
Push your data
further
Utilize ESRI’s tools,
software, and Apps
![Page 49: Getting the Best ROI from Your GIS - APWAmichigan.apwa.net/Content/Chapters/michigan.apwa.net/Documents… · Getting the Best ROI from Your GIS. May 29, 2019 2 Background City of](https://reader034.vdocuments.us/reader034/viewer/2022042919/5f62b8b7aef983389f0b171c/html5/thumbnails/49.jpg)