Abstract
 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 |
|||||
