Data Utilities Module

Essential tools for wave data management

The Utilities Module provides a variety of database manipulation tools for user wave data.  These utility functions allow the user to add or remove data records, apply cross-record smoothing or sub-sampling, and change the angular resolution of wave spectrum records.

 

Launching the Utilities Module

Once data has been loaded (see Loading Data), the Utility Module can be launched by selecting the Data Utilities command in the Module pull-down menu.  Since the data utilities will make changes to the data in memory, a Save Data window appears and provides the opportunity to save user data before proceeding. If the user has already run Wave Systems on this data, the Save Data window will warn the user that wave system information will be lost. This is because the data utilities only operate on the wave spectrum records, not processed wave system data.  However if only using the Rename utility then no data will be lost.  When finished with the Data Utilities, the user can re-run Wave Systems on the data to generate new wave system information.

 

When the Utilities Module is launched an interactive Data Utilities window appears. Record listing boxes show the years, months, days, and records represented in the user data. All utility functions are activated from this window.  A list of the available commands, and instructions for their operation, appear below.

 

Utility Commands

Smooth Records

The Smooth Records utility performs a weighted running average over the wave spectra. This utility is activated by clicking on the Smooth Records button in the Data Utilities Window.  A message box will request the user to type in the desired wave spectrum smoothing interval in hours.  Over this specified duration, the Utilities Module will perform a weighted running average of the input directional wave spectra.  For example, a 4-h smoothing window will smooth all spectra occurring up to 2-h prior and 2-h after each observation time.  This feature is helpful for noisy spectra, usually obtained from short time series records, and will help reduce Wave Systems processing time by eliminating spurious peaks.

 

SubSample File

The SubSample utility reduces user data file sizes by saving only those records that occur at a specified time interval. This utility is activated by clicking on the SubSample File button in the Data Utilities Window.  A message box will request the user to type in the desired interval in hours for record sub-sampling.  The Utility Module will remove records that fall in-between this interval.  For example, if a 3-h data subsample interval is selected for data that is provided hourly, every third record will be saved.  This feature is helpful for decreasing the size of large files, and will reduce Wave Systems processing time by providing fewer records to process.

 

Spectral Resolution

The Spectral Resolution utility is used to change the frequency range, frequency resolution, and directional resolution of the directional wave spectra.  This utility is activated by clicking on the Spectral Resolution button in the Data Utilities Window.  A Spectral Resolution GUI will open that allows the user to specify the frequency and angle bins in the output directional spectra.  Input spectra are linearly interpolated to the requested resolution.

 

The use of this feature can greatly reduce output file sizes and save on Wave Systems processing times for large data sets.  Measured data are often set at a directional resolution that is much greater than the instrument can actually resolve.  Try setting your angular resolution at 10 or 15 degrees, corresponding to 36 or 24 angle bins.

 

Append File

The Append File utility is used to add another data set to the current loaded data.  This utility is activated by clicking on the Append File button in the Data Utilities Window.  A browser window will open to allow the user to select a data file to append.  Selected files must have observation times that either precede or follow the observation times of the user data in memory.  Once a file to append is selected, click on Open to execute the utility.  Once the utility is complete, the window display of available data records is updated.

 

Subset File

The Subset File utility allows the user to create a new data file from a subset of the user data in memory.  The user should first interactively select the range of data to be subset.  Data can be selected by year, month, day, or record attributes by clicking and dragging the cursor over the desired range, shift-clicking a range, or double-clicking on a particular attribute.  Control-clicks can be used to select different data segments to subset.  Once the desired range is selected, clicking on the Subset File button activates the utility.  Once the utility is complete, the window display of available data records is updated.

 

Remove Records

The Remove Records utility allows the user to extract and discard records from the user data in memory.  The user should first interactively select the range of data to be removed.  Data can be selected by year, month, day, or record attributes by clicking and dragging the cursor over the desired range, shift-clicking a range, or double-clicking on a particular attribute.  Control-clicks can be used to select different data segments to subset.  Once the desired range is selected, clicking on the Remove Records button activates the utility.  Once the utility is complete, the window display of available data records is updated.

 

Rename

The Rename utility allows the user to change the name of the user data in memory.  Clicking on Rename opens up an input dialog box with the current name.  The user can either change the name and click OK to save or click Cancel to keep the existing name.  Selecting rename will not cause any processed data to be lost.

 

Additional Information:

Data Manipulation