This document describes a spatially enabled floodplain management database created for the Huntington District of the US Army Corps of Engineers. The database was created to replace a paper call log and has been expanded over time. It integrates with GIS software and allows users to document calls, lookup locations, access FEMA and USGS resources, and coordinate response more efficiently. The database provides benefits like time savings, increased accuracy, and improved mapping capabilities to support the district's floodplain management work.
1 of 30
Download to read offline
More Related Content
FPMS Anniversary Case Study Presentation
1. Huntington District Spatially
Enabled FPMS Database
Joe Trimboli, MSc, CFM
FPMS Lead Planner
Community Planner
Huntington District
11 November 2010
US Army Corps of Engineers
BUILDING STRONG速
2. FPMS Call Log DB
Lead FMPS Planner Retired 2005
Created to replace call log form
No original development cost
Builtfrom Microsoft Access
Integrates with existing software
Functionality added over time
2 BUILDING STRONG速
3. Quick Response
Toll free number 1-866-401-3980
Created for NS Project Support
Private, Commercial, Governance
NFIP Support with 11 CFMs
Diverse Job Descriptions
Varied experience levels
Team Coordination
Response process spatially enabled
3 BUILDING STRONG速
4. FPMS DB Overview
Interface
Capabilities
Integration
User Desktop
FEMA and USGS
Web Mapping Portals
Google Earth
ArcView
4 BUILDING STRONG速
6. Admin Functions
Creates associated folder based on ID
Copies GIS seed file into folder
Creates KML file based on coordinates
Folder and Files status
Open folder
Launch ArcView with seed file
Database layer attached to ArcView
6 BUILDING STRONG速
7. Admin Functions
Link to Program Folder Reference
E-mail office POC
Print record
Create folder shortcut on desktop
7 BUILDING STRONG速
12. Contact Info
Begins the documentation process
Automatic phone dial button
Begins the spatial integration process
12 BUILDING STRONG速
13. Web Site Integration
Location LAT & LON lookup (Yahoo API)
Begins process of verifying location
Large message fields to support Request
and Answer Notes
13 BUILDING STRONG速
14. Web Site Integration
Integrates helpful websites: FEMA, USGS,
and online mapping
FEMA DFIRM access
Location verification by aerial photography
USGS seamless server download
14 BUILDING STRONG速
27. Benefits
Coordinate team activities
Integrates with folders, Outlook, and GIS
Facilitates report generation
Integrates other agency information and
resources
Case ID Numbers and Invoicing
Time savings and process development
Assists in mapping and graphical resources
Increased accuracy in correspondence
27 BUILDING STRONG速
28. Future Development
Reorganize/Add fields to better represent
work flow
Integrate BFE worksheet
Coordinate activities with State/FEMA
Silver Jackets POCs
Create web page with e-mail/form support
28 BUILDING STRONG速