north carolina floodplain mapping program geodatabase design process enhancements l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
North Carolina Floodplain Mapping Program: Geodatabase Design/Process Enhancements PowerPoint Presentation
Download Presentation
North Carolina Floodplain Mapping Program: Geodatabase Design/Process Enhancements

Loading in 2 Seconds...

play fullscreen
1 / 22

North Carolina Floodplain Mapping Program: Geodatabase Design/Process Enhancements - PowerPoint PPT Presentation


  • 318 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'North Carolina Floodplain Mapping Program: Geodatabase Design/Process Enhancements' - vine


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
north carolina floodplain mapping program geodatabase design process enhancements

North Carolina Floodplain Mapping Program:Geodatabase Design/ProcessEnhancements

Kristen MacDougall

Watershed Concepts

Geospatial 2007 Conference

May 08, 2007

overview history
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
project purpose
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
products of migration process
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
data transformation

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
database dictionary update

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.
ncfmp geodatabase domains
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
ncfmp domain dictionary
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
ncfmp geodatabase creation
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
slide12

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.

rdbms maintenance
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
slide14

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.

ncfmp to fema export tool
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
slide16

NCFMP Scoping Geodatabase

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

slide17

NCFMP Raster Geodatabase

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

slide18

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
additional tasks
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
special issues
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