TSTool_User_09-09-00 - Laserfiche WebLink

Getting Started TSTool Documentation 3.3.1 Input /Query Options and Time Series List Area The upper part of the main window contains the InputlQuery Options and Time Series List area. The Input/Query Options choices help select time series information from input types. The interactive interface is useful when searching a database or selecting a time series from a file that includes multiple time series. An alternative to the following interactive approach is to use read commands from the Commands menu (see the Commands chapter), which is appropriate for more complicated analysis. To select time series, execute the following steps: Select the Input Type. Input types define the storage format (e.g., database or file) for time series data. The DateValue input type is the default. More specific input types (e.g., the HydroBase database) may be the default if enabled. See the appropriate appendix for a description about supported input types. Depending on the input type, some of the remaining selection choices may be disabled or limited. In most cases, TSTool will assume that you are correctly associating an input type with the actual input that is selected (i.e., that you will select a file that matches the input type when Get Time Series List is pressed — see below). Selecting some input types may prompt for a file, which is then listed in the Input Name choices. 2. Select the Data Type (if appropriate for the input type). For example, select Streamflow or Diversion if using a HydroBase input type. For some input types, the data type will be listed as Auto, indicating that the data type automatically will be determined from the input itself. 3. Select the Time Step (if appropriate for the input type). The time step, also referred to as the data interval, will generally be limited by the input type. For example, if reading from the HydroBase database, the Streamflow data type will result in Day, Month, and Irregular (real -time) time steps being listed. The time step will be shown as Auto for some input and data types and will be determined as data are read. 4. Specify the Where and Is clause(s) for the query (if appropriate for the input type). This information will limit the number of time series that are returned. For some input types, choices will be displayed as choices, whereas for other input types, all time series for the input type will be listed. Press the Get Time Series List button in the Input/Query Options area, and TSTool will display a list of matching time series in the Time Series List. If the input type is a file, you may first be prompted to select the file containing the time series. The Time Series List shows a list of matching time series, including standard time series information. As much as possible, the column headings are consistent between different input types. The results are typically sorted by name or identifier if from a database, or if read from a file are listed according to the order in the file. Right -click on the column headings and select Sort Ascending to sort by that column (the other columns will adjust accordingly). The sorts are alphabetical so some numeric fields may not sort as expected due to spaces, etc. 6. Move time series to the Commands list in the center of the main interface selecting rows in the Time Series list (must click in column two or greater) and then pressing the Copy Selected to Commands button. Or, if appropriate, press the Copy All to Commands button. The Commands and Time Series Results areas are discussed in the following section and can contain mixed data types and time steps. Analysis commands may require that the units are compatible, but general viewing tools do not require the same units. To mix data types, make multiple queries using the Input/Query Options and Time Series List areas and select from the lists as necessary, accumulating time series identifiers in the Commands list. Getting Started - 4 36