TSTool_UserManual_10-21-00 - Laserfiche WebLink

TSTool Documentation Getting Started Getting Started - 5 3.3.1 Input/Query Options and Time Series List Area The upper part of the main window contains the Input/Query Options and Time Series List area. The Input/Query Options choices help select time series information from datastores (databases and web services) and input types (typically files and some databases). The interactive query interface is useful when selecting a time series from a file , database, or web service (internet). An alternative to the following interactive approach is to use read commands from the Commands menu (see the Commands chapter). To select time series, perform the following steps : 1. Select the source of the data . Select a Datastore or Input t ype . • A data store is a repository that generally contains multiple time series (e.g., a database, web service, or file). The details about the datastore are included in a simple configuration file (see dat astore appendices). • Input types define the storage format (e.g., databas e or file) for time series data, and may require an input name. Selecting some input types may prompt for a file, which is then listed in the Input name choices immediately below Inpu t type . The datastore design is being phased in because it provides more flexibility in defining data connections. In the future, all database connections will be transferred to datastores and remaining input types may be referred to as “file datastores ”, which will use a filename. The DateValue input type is the default. More specific input types (e.g., HydroBase) may be the default if enabled. See the appropriate data store or input type appendix for more information . Depending on the input type, s ome of the remaining selection choices described below may be disabled or limited. 2. Select the time series data type . Select the Data t ype (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 data . 3. Select the time series time step (interval). Select the Time s tep (if appropriate for the input type). The time s tep, also referred to as the data interval, generally will 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 input types where the time step is determined as data are read. 4. Specify filter criteria for the time series list . 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. The filters are highly dependent on the original data. 5. Generate the time series list . Press the Get Time Series List button in the Input/Query Options area, and TSTool will display a list of matching ti me 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, typically including location and time series properties . 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 col umn headings and select Sort Ascending to sort by that column. The sorts are alphabetical so some numeric fields may not sort as expected due to spaces, etc . 31