1 / 22

North Carolina Floodplain Mapping Program: Geodatabase Design/Process Enhancements

North Carolina Floodplain Mapping Program: Geodatabase Design/Process Enhancements. Kristen MacDougall Watershed Concepts Geospatial 2007 Conference May 08, 2007. Hurricane Floyd, 1999. Hurricanes Frances/Ivan, 2004. Overview / History. Original DB Design Completed in 2001

vine
Télécharger la présentation

North Carolina Floodplain Mapping Program: Geodatabase Design/Process Enhancements

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. North Carolina Floodplain Mapping Program:Geodatabase Design/ProcessEnhancements Kristen MacDougall Watershed Concepts Geospatial 2007 Conference May 08, 2007

  2. Hurricane Floyd, 1999

  3. Hurricanes Frances/Ivan, 2004

  4. Overview / History • Original DB Design Completed in 2001 • Based on ESRI Shapefile, MS Access • GIS Technology Advancements: • Geodatabase • ArcSDE Advancements • 8x – 9x Versions • NC Database Remained Unchanged • Graphic Specs based on “FEMA 37” • NCFMP Prototypes

  5. Project Purpose Improve processes associated with the production, review, delivery and distribution of Digital Flood Insurance Rate Maps (DFIRMs) for the North Carolina Floodplain Mapping Program. • Transform data into an Enterprise Geodatabase Format • Revise & Update Geodatabase Design &Dictionary • Revise & Update Geodatabase Domains & Dictionary • Create New ArcSDE/SQL Server 2000 Geodatabase • Organize and Translate Existing Data into New Design • Create Graphical Specifications Document • Develop Data Export Routine for FEMA Submissions

  6. Products of Migration Process • ArcSDE statewide DFIRM database • Database Dictionary • Domain Dictionary • Graphic Specifications document • Conversion models • NCFMP to FEMA data conversion tool • Statewide Raster Catalog • Statewide DEM dataset

  7. Source Access MDB Data Type SQL Server Data Type ArcGIS Data Type Data Transformation Migration required modifications to the existing database design: • Original database design: • completed before Geodatabase was prevalent • utilized Shapefiles & MS Access based object classes • Incompatibilities between old design & SQL Server 2000/ArcSDE • Shapefiles, Access MDB data types were made compatible with SQL Server 2000 & ArcGIS 9.1

  8. Previous Field Type Geodatabase Field Type varchar Text int Long Integer bit Short Integer Smalldatetime Date Database Dictionary Update • Field parameters were updated to reflect current ESRI Geodatabase field definitions. • Data types documented in the dictionary are based on the ArcGIS classifications.

  9. NCFMP Geodatabase Domains All text-based domain values were converted to integer-based values: • Promotes efficiency in Contractor Production Processes • Increases Data Standardization/Normalization • Facilitates Interoperability with FEMA Enhanced Database Design • Promotes Database Efficiency

  10. NCFMP Domain Dictionary Domain values and descriptions were documented in the NCFMP Geodatabase Domain Dictionary: • Feature class/domain references can also be found in the NCFMP Geodatabase Dictionary

  11. NCFMP Geodatabase Creation Utilizing SQL Server 2000 and ArcSDE 9.1: • Dataset • Precision: 1/16th of an inch for the entire state • Extents: entire state + 20 miles • Projection: NC State Plane • NAD83 • US Survey Feet • FIPSZone 3200 • Enterprise Functionality • Topology • Relationship Classes

  12. Existing Data Translation The delivered Geodatabase contains all translated NCFMP data, revised according to the new Database Design, and stored as ArcSDE feature classes inside an ArcSDE Feature Dataset.

  13. RDBMS Maintenance All converted NCFMP data was topologically cleaned, then tuned and configured for maximum performance: • RDBMS Tuning & Configuration • Filegroups • Configuration Keywords • Data Tuning • Spatial Grid Indexes

  14. XML Creation Allows for distribution of the NCFMP Geodatabase schema in an Extensible Markup Language (XML) format that can be viewed and edited by third-party applications, or easily exchanged among users.

  15. NCFMP to FEMA Export Tool Preparation of FEMA submissions: • NCFMP submittals made to FEMA and (HDM) • Automated NC to FEMA data conversion tool developed • Seamlessly converts between NCFMP and FEMA Standard format • Previous conversions were tedious, time consuming

  16. NCFMP Scoping Geodatabase The delivered Geodatabase contains translated NCFMP Scoping data stored as ArcSDE feature classes inside an ArcSDE Feature Dataset.

  17. NCFMP Raster Geodatabase The delivered NCFMP Raster Geodatabase and Embedded Raster Catalog store statewide raster data:

  18. NCFMP Graphical Specifications To promote standardization, a North Carolina graphical specification document was developed: • A corresponding ESRI style file supports FIRM panel feature specifications • The style file contains fonts, line styles, line weights, hatching, patterns • Similar to FEMA’s Guidelines and Specifications for Flood Hazard Mapping Partners Appendix K

  19. Additional Tasks • Statewide DEM • Actual conversion process • Countywide Mr. SID tiles • FEMA risk calculations: intersecting flooding polygons with census block group data • Data population “guidelines” • maptransportation • Mapwtrln

  20. Special Issues • Basin-wide data vs. county-wide data • MXD processing • domain codes vs. text; preserving symbology • imagery for submittals: to load or not load? • multiple contractor annotation formats • post-preliminary edits • data storage

  21. The Public Data-User

More Related