Abstract

back
   Back


Paper
Geodatabase Design Enhancements for the North Carolina Floodplain Mapping Program
Track: Database Design, Automation, and Management
Author(s): Sarah Wray, Kristen MacDougall, Shuqin Jin, Richard Fogleman

As the nation's first Cooperating Technical State, North Carolina has assumed primary responsibility of the state's DFIRMs. Because the North Carolina Floodplain Mapping Program's (NCFMP) original DFIRM database design was completed before the geodatabase became prevalent in the industry, and given that each mapping contractor has since adopted the geodatabase model, the NCFMP database was updated for compatibility with the geodatabase, and data was migrated to an SDE geodatabase/SQL Server environment to eliminate the costly conversion process required for submittal. This data migration involved modernizing original field definitions and redefining domain table values. To facilitate NCFMP's obligation to prepare the DFIRM geodatabase in a FEMA standard submission format, a Submission Standards Interoperability Tool was also developed. The increased efficiency for NCFMP and its contractors has simplified data maintenance and distribution, making critical data highly available to the general public, as North Carolina's DFIRM studies transition more quickly from preliminary to effective status.

Sarah Wray
North Carolina Emergency Management
GIS
1812 Tillery Place
Raleigh , NC 27604
US
Phone: 919-715-5711
E-mail: swray@ncem.org

Kristen MacDougall
Watershed Concepts
GIS
3333 Regency Pkwy
Suite 120
Cary , NC 27511
US
Phone: 919-460-6895
E-mail: kmacdougall@watershedconcepts.com

Shuqin Jin
North Carolina Emergency Management
1812 Tillery Place
Raleigh, NC , NC 27604
US
Phone: 919-715-5711
E-mail: sjin@ncem.org

Richard Fogleman
Watershed Concepts
GIS
3333 Regency Pkwy
Suite 120
Cary , NC 27511
US
Phone: 919-460-6895
E-mail: rfogleman@watershedconcepts.com