TSTool - Time Series Tool
|
Example Projects
That Use TSTool
|
TSTool was initially developed by Riverside Technology, inc. (RTi)
to format and fill monthly time
series data for water resource planning models. Over time, TSTool
has become a powerful tool for general time series analysis and
manipulation, not only in water resources but for other types of
time series data. TSTool reads time series from a variety of input
types. The visualization components used in TSTool are also used
in other RTi products and TSTool can be used with the RiverTrak® and
NWSRFS systems. One advantage of using TSTool is that it natively
understands time series data and related issues (e.g., missing
data, different time intervals) and has no hard limit on data size.
Specific TSTool features are highlighted below.
Input Types and Data Conversion
TSTool can read time series data from a variety of input types,
and new types can easily be added.
Time series
from these input types, once read, can be converted to other input
types. Consequently, TSTool can streamline data conversion. The
following input types are currently supported:
- DateValue format (header with delimited data)
- HydroBase (State of Colorado water resources database)
- MODSIM (Colorado State University)
- NWS Card (National Weather Service)
- NWS Trace Ensemble (National Weather Service)
- NWSRFS (National Weather Service database)
- RiversideDB (RTi's database used with the RiverTrak® system)
- RiverWare® files (University of Colorado)
- StateMod and StateCU (State of Colorado Water Resources Planning
Model and Consumptive Use Model)
- USGS National Water Information system
|
TSTool Application Displaying Input Type Interface
|
Data Viewing
Time series can be viewed in a variety of formats including
graphs, tables, and reports. The following list illustrates some of
the available output options:
- Line graph
- Bar graph
- Duration graph
- Period of record
- XY Scatter graph
- Data coverage report
- Data limits report
Time series products can be configured with product description
files, which allow a product to be recreated at a later time.
Graphs allow zooming and scrolling, and many properties can be
configured.
|
TSTool Stream Flow Graph
|
Data Filling
Missing data in time series can be filled using a number of
techniques, which can be applied sequentially. Examples of filling
techniques include:
- Constant
- Interpolate
- Historical averages
- MOVE2
- Prorate
- Regression
- Repeat (forward or backward)
|
TSTool Graph Illustrating Filled Data
|
Data Manipulation
In addition to filling missing data, a number of techniques are
available to manipulate time series, including:
- Add
- Add Constant
- ARMA
- Blend
- Cumulate
- Divide
- Multiply
- Running Average
- Scale
- Shift
- Subtract
|
TSTool Cumulative Graph
|
Command Language
Because time series analysis and manipulation can be tedious and
repetitive, TSTool includes a command language to facilitate data
processing. For example command files can be created for the
following tasks:
- Processing many time series from a database to create a model
data file.
- Processing many time series to identify data gaps.
- Processing many time series to convert from one format to
another.
- Automatically generate data products for a web site.
|
TSTool Precipitation and Stream Flow Time Series Product
|
Integration with other Applications
TSTool can be run as a stand-alone application and can be called
in a restricted manner by other applications. This allows TSTool to
supplement the features of other tools (e.g., adding time series
displays to a Geographic Information System).
|
TSTool Used in Conjunction with ArcExplorer
|
|
printable page
