IH 35 at Blanco River May 2015

Presentation Objectives

• Background of historical damage assessment processes

• Introduction to Collector App ( Mat Peck)

• Collector App and Flood Damage Assessment (Katie Steele)

• Examples of data analysis to assist City Officials with the decision making process

San Marcos, Texas

• Located 30 Miles South of Austin

• Population 58,292 (January 2016 projection)

• Named the fastest growing City over 50,000 3 years in a row by the U.S. Census Bureau

• Home to Texas State University. Fall 2016 enrollment – 37,979

• City 600 employees, 9 GIS professionals

• Location and unique Geography makes us very susceptible to flooding

Texas Weather George Bomar University of Texas Press Illustration by Ed Lindlof

Tornadoes Sandstorms Earthquakes Hurricanes Droughts Floods Flash Floods Ice Storms Blizzards

Tornadoes Earthquakes Sandstorms Hurricanes Droughts Heat Waves Floods Flash Floods Ice Storms Blizzards

San Marcos Flood Events o September

1952 o February 1955 o October 1959 o June 1961 o May 1970 o October 1976 o May 1977 o October 1978 o July 1979 o June 1981 o November

1985

o October 1998 o November

2001 o July 2002 o November

2004 o March 2007 o October 2013 o May 2015 o October 2015

1998

Sessom Dr at Aquarena Springs

Memorial Day 2015

Post Road at Blanco River

All Saints Day 2015

San Marcos River at University Dr

Teams of 2-3 City staff were sent out to identified areas with paper forms; Brought into EOC for data entry.

Damage Assessment and Zoning

GIS Feature Collection with ESRI’s ArcGIS Online

Collector App • Quick and efficient GIS Feature Inspections

• Replaces Paper Forms

Why should we use GIS? • Database structure for reliable record keeping

• Applications that will assist in the collection, reporting, and maintenance of data

ArcGIS Online + Collector App Adopted in early 2014 at the City of San Marcos, ArcGIS Online is a robust platform to serve GIS data to field users without requiring a

direct connection to the city’s network.

The Collector App is a tool that makes field collection quick and efficient. A major benefit is that it fully integrates current GIS data, and

all of the collected information can be brought back into the GIS environment with little to no modifications.

ArcGIS Online (AGOL) requires a username and password that is set up by an AGOL account administrator, so the data is secure.

AGOL is accessible from any browser, and has many tools/GIS

operations that can be performed. In some cases, this can replace the need for a full ESRI license.

GIS Feature Inspection The Stormwater feature inspection map is a web and mobile based map that allows collection

of features and attributes that do not require a high accuracy position. It is also useful in updating feature attributes that have been collected by a high accuracy survey-grade GPS

device.

GIS Feature Inspection Features from the city’s GIS system are uploaded to a webmap using the ArcGIS online platform. The features are interactive - they can be clicked on to see attributes such as pipe length, pipe depth, diameter,

and other attributes that are entered in GIS.

GIS Feature Inspection

The field crews that will inspect the GIS features will use the map to confirm that the GIS is correct, and then open

up the Inspection form to complete the inspection. If necessary, the crew will document the condition with a

picture.

The Inspection will be created as a new point, and to connect the inspection to the GIS feature, the field crew will

copy the ‘name’ of the feature and insert it into the inspection form.

GIS Feature Inspection

Some inspection items include:

• The Unique ID of each feature • The Structural Condition (Good, Fair,

Poor) • If Repair or Cleaning is required

• The date the inspection was performed • Misc. comments

• If errors exist in the stormwater features in the GIS data • Pictures

GIS Feature Inspection After the inspection is complete, the pictures will show as

an attachment at the bottom of the form. The picture can be opened in the app on the ipad or in a browser.

GIS Feature Inspection An example of a fully inspected neighborhood

GIS Feature Inspection Back in the office, the data can be filtered to make only the

desired records visible. Here we see only features that require maintenance.

GIS Feature Inspection Alternatively, you can change the symbols to represent the

different attributes. Here, we include all of the inspections, but make the features that require cleaning red.

Replacing Paper Forms with Collector

• With traditional data collection, paper inspection forms would be sent out with the field crew. These forms are normally bulky (8.5x11

or larger) and would be accompanied by a clipboard, pens, and other supporting tools.

• Once the data was recorded, it might be days or weeks before the

data could be digitized. Weather, penmanship, and other factors can affect legibility of the data.

• With a GIS-based collection method, the data is already in a digital

format, and can be made available immediately to GIS staff and Management through internet connectivity. Further data entry errors

can be mitigated with the use of drop-down lists (domains) and range values.

Example: Outfall Reconnaissance Inventory The collection form was based off of the MS4 Outfall Reconnaissance Inventory (ORI) sheet. A

digital version can be found here:

http://www.wastormwatercenter.org/files/library/outfall-reconnaissance-inventory-collection-field-sheet.pdf

ArcGIS Online: Mobile (tablets, phones) Web Maps from the browser can be published in many formats to enhance the end user’s experience.

The Collector app (available through the Apple app store or Google Play [Android]) allows field crews to record attribute data, location, and pictures of physical assets.

ArcGIS Online / Collector: Devices ArcGIS Maps can be used in the field on mobile devices for enhanced access to

data

The Collector app is also set up for “Offline” data (no need for internet access) so field crews can see infrastructure data, even if there is an internet outage or if they

are in an area of poor cellular coverage.

The GIS team has purchased well equipped yet reasonably priced Android devices (Samsung Galaxy Tab 4s, Lenovo Tab 2 A8s) for field collection through the

Collector app. Android devices are well built and are normally much cheaper than an Apple device, which has allowed the department to purchase more devices.

Performance:

The Drainage crew has collected 2172 inspection points since August of 2014, and the Traffic team has collected 2250 traffic signs to aid in the detailed inventory of the city’s signs. IT GIS has created a Hydrant Inspection app for the Fire Department, and the Firefighters have completed nearly 1400 inspections. These apps will help to improve the quality of our GIS data, as well as bring the departments the data

they need in a reliable, instantly-available format.

ArcGIS Online / Collector: Devices

GNSS/GPS + GLONASS internal receiver

All Saint’s Day Flood October 30, 2015

Drone Footage

• https://www.youtube.com/watch?v=OJESnETn8DU

Sync the data from the device to our GIS database

Preparing for the next event…

Goals for the Future: Common Operating Picture

What do we do with all this data?

• Plan for CIP projects

• Update FEMA map

• Update ordinances

• Guide new development

• Use for the CDBG-DR Action Plan - $25 million HUD funds

Federal Register Requirements

• 70% Rule: 70% of funds MUST serve Low, Moderate Income (LMI) populations

• BFE Rule: ANY Substantially or Severely Damaged unit receiving CDBG-DR funds MUST be elevated to 2 Feet OVER the Base Flood Elevation when all construction is complete

• Disaster Rule: Use of funds for any project MUST be attributable to both 2015 floods

Affected = 1 Minor = 2 Major = 3 Destroyed = 4 X Number of events. Color Coded by Subdivision

Lessons Learned

• There will be another flood

• Be prepared

• Turn around time is everything

• Learn from others

Joan Hickey, GISP - GIS Enterprise Manager

jhickey@sanmarcostx.gov 512.393.8127

Katie Steele GIS Analyst

ksteele@sanmarcostx.gov 512.393.8489

Mat Peck PS/GIS Technology Manager

mpeck@sanmarcostx.gov 512.393.8001

Questions?