ndgisuc2017 - choosing the right solution for flood infrastructure inspection in the field
TRANSCRIPT
![Page 1: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/1.jpg)
Houston Engineering & City of Moorhead
Choosing the Right Solution for FloodInfrastructure Inspection in the field
Compare and contrast Esri's Survey123 and Collector
Dave Kirkpatrick
Houston Engineering Inc
Brad Anderson, GISP
City of Moorhead GIS
North Dakota GIS Users Conference
Wednesday, September 20th 2017
![Page 2: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/2.jpg)
• History of annual spring floods in the Red River valley
• The need for mitigation projects to protect property and infrastructure
• Flood mitigation projects that provide city-wide protection require maintenance and inspection
• Two solutions (well, three actually) were available
1. Esri Survey1232. Esri’s Collector App3. Clipboards, paper, spreadsheets, and cellphone camera
![Page 3: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/3.jpg)
The Red River Basin
• 45,000 Square Miles
• Flows north to Lake Winnipeg
• Average slope of 1-2 feet per mile
• The confluence of the Wild Rice River & the Red River is just south of Fargo Moorhead
![Page 4: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/4.jpg)
16
18
20
22
24
26
28
30
32
34
36
38
40
42
2009 1997 1897 2011 1969 2006 2010 2001 1989 1979
Riv
er S
tage
(ft)
Fargo – Moorhead Top 10 Floods
![Page 5: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/5.jpg)
Flood of 2009
Temporaryprotectionmeasuresthat werein place for the 2nd crest
![Page 6: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/6.jpg)
![Page 7: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/7.jpg)
![Page 8: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/8.jpg)
Six FEMA Accredited LOMR Areas in Moorhead
Four are complete
Two are pending
As a result;356 properties165 structures
DO NOT require mandatory flood insurance for federally insured mortgages
$330,000 in annual flood insurance premiums remain in the local economy
![Page 9: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/9.jpg)
$137,281,014
70 City of Moorhead Engineering flood mitigation projects have been completed since the flood of 2009
This includes $57,000,000 for property acquisition, demolition, and remediation (i.e. Buyouts)
![Page 10: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/10.jpg)
![Page 11: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/11.jpg)
Reduction in Sandbags(42.5 foot crest)
0
1,000,000
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
Pre-20092011
Goal
# of
San
dbag
s
![Page 12: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/12.jpg)
![Page 13: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/13.jpg)
![Page 14: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/14.jpg)
Tom JimAndrea Mark
Engineering DeptLevee or Floodwall
Steve Randy
Public Works DeptClosure Structure
Tom Jay
Storm Water DivInterior Drainage
Three City Departments will utilize themobile application:
AquafenceRemovable Closure
Other Features
Earthen LeveeConcrete FloodwallSheetpile Floodwall
Pump Station (PTO)Pump Station (Electric)
Gate WellOutfall
![Page 15: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/15.jpg)
The mobile application is great. We can identify and record the problems, and many things we can fix right there on the spot during the inspection.(Storm Water Supervisor)
Inspecting and maintaining the City’s investment of more than $100M in flood mitigation improvements is critical to ensuring performance during a flood event. With limited resources, we needed a system that was not a staff or paper burden. This new application enhances efficiency and provides confidence in our ability to fight future floods.(Bob Zimmerman, City Engineer PHD)
![Page 16: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/16.jpg)
Engineering DepartmentLevee / floodwall Inspection- spatial data- 1 to one relationship- 1 and done data
Wastewater DepartmentPumps/ Gatewells and Outfalls- Stationary data- Inspection checklist- 1 to many sub components- Continuous Life Cycle
Public Works DepartmentTemp closures / general conditions- spatial data- 1 to one relationship- 1 and done data
Collection Requirements
![Page 17: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/17.jpg)
Seemed like a slick form based collection method.I was unsure of the GIS component and how to visualize the data.
Templates were easy, fast to get something up and running.Really clean, could use radio buttons or pick lists.
Investigated the feature service and there was little to no Domain structure.Summary was good in the dashboard, but the schema limits the ability to query and do reports.
Survey123 Application
![Page 18: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/18.jpg)
![Page 19: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/19.jpg)
RESULTING FEATURE DATASET
Contains no real structure, criteria in the initial setup is not maintained as a Schema
![Page 20: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/20.jpg)
History using this for Levee inspection for the past 3 years in Minot and Moorhead.
Schema was well established.(COE SWIF Reports)
Related Tables many to works nice for inspection
Records and photo attachments unlimited
Limited to 3 levels of relationships
Longer Life Cycle
DEMO AGOL Map
Collector Application
![Page 21: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/21.jpg)
LEVEE INSPECTIONS
![Page 22: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/22.jpg)
LEVEE INSPECTIONS
![Page 23: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/23.jpg)
INFRASTRUCTURE INSPECTION
![Page 24: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/24.jpg)
INFRASTRUCTURE INSPECTION
![Page 25: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/25.jpg)
Survey123Quick simple collectionShort timelineNo structure for reporting outside the existing interfaceDoes not support Domain SubtypesDoes not look like GIS
CollectorKnown commodityMore time needed to create the databaseCan be intimidating for new usersLonger Life Cycle
Revisit the discussion after fall inspection
Compare and Contrast
![Page 26: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/26.jpg)
�Provides the ability to quickly create list of defiencies so they can be ranked and repaired by each City group.
�Reporting by each LOMR Group
�USACE System Wide Improvement Framework Standard Reporting
�MS4 Reporting (TBA)
Reports and Template Standards
![Page 27: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/27.jpg)
�Visualize progress in addressing defiencies
�Reporting by each Department
�Establish timelines (short term)
�Capital Improvement Plan (long term)
High Level Dashboard
![Page 28: NDGISUC2017 - Choosing the Right Solution for Flood Infrastructure Inspection in the Field](https://reader033.vdocuments.us/reader033/viewer/2022052706/5a64bbd97f8b9a4d0b8b46ff/html5/thumbnails/28.jpg)
Choosing the Right Solution for FloodInfrastructure Inspection in the field
Dave KirkpatrickHouston Engineering Inc
[email protected] 701-237-5065
Brad Anderson, GISPCity of Moorhead GIS
[email protected] 218-299-5125
North Dakota GIS Users ConferenceWednesday, September 20th 2017
? Questions ?