Main Content

Comprehensive Data Management System

This page describes the Comprehensive Data Management System (CDMS) tool for use with Hazus. The page details the four CDMS modules: aggregate, site-specific, backward compatibility and import modules. It is intended to inform Hazus users of the capabilities, requirements for use, and limitations of the CDMS.

The CDMS is a complimentary tool to Hazus that provides users with the capability to update and manage statewide datasets, which are currently used to support analysis in Hazus. The CDMS will function for a single user or shared desktop application. 

Currently, Hazus users are required to undertake a large amount of manual effort to incorporate new data into the statewide datasets according to their pre-defined formats. To reduce this effort, the CDMS will streamline and automate raw data processing, the conversion of external data sources into Hazus-compliant data and the transfer of data into and out of the statewide datasets. Processing site-specific level and aggregate information at the census block and tract levels will be supported.

Once data are imported into the statewide datasets, the CDMS will allow users to query, sort, export, and print information. A backwards compatibility utility will be in place for upgrading previous versions of Hazus databases. The CDMS is automatically downloaded when users download the Hazus software on the FEMA Flood Map Service Center (MSC).

CDMS Modules

The CDMS is comprised of four modules: the aggregate, site-specific, backward compatibility, and import modules. The aggregate, site-specific, and backward compatibility modules work together. Raw data can be used to generate aggregated data and, if the raw data has location information, then site specific data can also be generated at the same time. Similarly, aggregated data can be generated when generating site-specific data. The backward compatibility component will apply the data conversion and use the aggregate data and site-specific data components to generate the data in Hazus format. The updated data in a study region can also be applied to the state data Structured Query Language (SQL) tables.

Aggregate Module

Screen shot of the CDMS categorization screenThe aggregate module allows the user to:

  • Capture demographic data and,

  • Update the aggregated data (square footage, building count, building and content exposure and demographics) and Occupancy to Building Type Mapping Schemes to state SQL tables.

Site-Specific Module

The site-specific module has the following capabilities:

  • Allows the user to update earthquake, tsunami,  and flood parameters for essential facilities or add these facilities
  • Capture bridge and tunnel data
  • Capture various transportation and utility facilities data
  • Input User-Defined Facilities (UDF) and Advanced Engineering Building Module (AEBM) inventory
  • Update Hazus state data SQL tables with the data captured.

Site-Specific Features and Census Tracts

For site-specific features, the CDMS requires that users provide a latitude/longitude coordinate in one of the following systems: Geographic Projection, Decimal Degree Coordinate System or North American Datum 1983 (NAD83). A Census Tract ID is required for some site-specific features. Site-specific features can consist of the following: user-defined, AEBM, high potential loss, essential, transportation and utility facilities.

Null Values

When importing data into Hazus via CDMS, required fields for features in Hazus should be populated before the data are uploaded and mapped in CDMS. Fields not populated prior to loading into Hazus via CDMS will result in null values being transferred to Hazus and Hazus will not be able to count these features in its analysis. Consult the Hazus Data Dictionary for required fields and expected values/formats in the data preparation phase.  Fields identified in red during the import process are required by the user while fields identified in green require an input but if one is not provided, will default to a CDMS-provided value..

System Requirements for CDMS

 

HardwarePentium® IV with 800 MHz system bus and 2.6 GHz (or better) core speed
1 GB RAM

Note: Allows for fast import, export, and query for large areas.
Computer Storage:
Free Hard Disk Space
80 MB Moderate
Allows for base Statewide data and temporary storage for file imports.
Hardware AccessoriesCD-ROM reader with 12x minimum read speed for software installation
Graphics Card with 1024 x 768 minimum resolution
Mouse, Keyboard, and 19" Monitor
Software RequirementsThe CDMS application requires that the following programs be loaded:
  • Microsoft Visual FoxPro Driver 9.0*
  • Microsoft .NET 4.5 Framework*
  • MS SQL Server 2014 Express Edition*
  • Microsoft Data Access Components 2.8 Service Pack 1*
  • Microsoft J# Distributable File*
  • ESRI ArcGIS 10.4 Service Pack 1 (Engine, ArcView, ArcEditor, or ArcMap)
  • ESRI ArcGIS, ArcView 10.4 Service Pack 1, NET Runtime
Those programs highlighted by an asterisk (*) in the above list will be installed by CDMS. Please consult the CDMS instructions document for full details concerning CDMS installation.

 

CDMS Help and Technical Support

CDMS help is accessible from the pull-down Help Menu. If additional help is required, Technical Support can be contacted via the Hazus Help Desk at hazus-support@riskmapcds.com. Please be sure to provide as much relevant information about your issue as possible including your operating environment, data formats, error messages, screenshots of errors, and data samples.

SQL Server 2014 Express Limitations

CDMS operates on a free version of Microsoft® SQL Server 2014 Express relational database software that enables Hazus users to run the CDMS without requiring a software purchase. However, SQL Server 2014 Express has the following limitations:

• Supports only 1 CPU but can be installed on any server
• 1 GB addressable RAM
• 10 GB maximum database size

Last Updated: 
02/26/2018 - 09:12