Levels

Levels

In DataSight, information is stored in nodes that help locate data to the exact second it was recorded. These nodes are called Levels.

Levels in DataSight are maintained in a hierarchical manner. Several lower levels combine to form a higher level. Before importing or entering data into DataSight database, it is important to decide on your Level 1, 2 and 3 node hierarchy. Level nodes are accessed and defined in the Levels Panel.

DataSight databases are configured in nodes consisting of:

 

Level 1

An appropriate Level 1 may be a geographic area, project name, client, catchment area, etc.

Answering questions such as "what, how or why are you monitoring"

Level 2

In the case of Level 2, a region within the geographic area, or type of data collected such as water quality data, weather station data, or a specific project under the Level 1 hierarchy.

Answering questions such as "what, how or why are you monitoring"

Level 3

The name or identification code relating to a particular monitoring site or location. For example, the monitoring station name. This Level is locked to the x,y,z properties or site locality in 3D.

Answering questions such as "where your data set comes from"

Date Levels

Level 4 is automatically created by DataSight and is the year of a sample event. A sample event is an occurrence of sampling on a particular day, hence there is also a

Level 5, which is the month of a sample event and is also automatically created; and a

Level 6, for the exact date of the sample event and is also automatically created. Each sample event consists of a timestamp and data relating to each variable measured.

Automatically created. See Time Dependent Levels.

 

The DataSight Levels allow you to pre-filter your data according to broad groupings. This is helpful because:

  • You can click in the Levels Panel on a level 1, 2 or 3 or date and time,
  • You can quickly filter your data without having to go into the filter window to manually set this up each time.

 

This ability to quickly jump from one constructed filter to another is useful when visually comparing data, and when you perform relatively quick checks.

The decision on how to structure or group your data into Level 1 and 2 groupings often relates to an organisation's workflow. You may wish to interrogate these grouped data sets often during your daily work routine by simply clicking on them. However the list must also broadly communicate the relationships between your data set to anyone new to your database.

Whatever broad groupings you make for Level 1 and 2, you can still make Saved Views that allow finer groupings that are easily retrieved. You can use Saved Views to group and show data based on the type of variable monitored or specific methodology used.

While it is possible to identify a Level 3 as that other than a site locality, if you wish to undertake any spatial analysis of your data, then it is recommended that you choose to define the position of measurement of your field or sample data as a Level 3. Remember 3D = Level 3!

Most importantly, during your database setup, involve as many  database stakeholders as possible, as you are then more likely to design a database structure that will survive the test of time.

 

See also:

  • DataSight User Interface
  • Levels Panel
    • Related Articles

    • Set Levels

      Levels are easily created in the Levels Panel and each level can be named using alpha numeric text. Select or highlight a Level Select a Level in the Levels Panel by clicking on the Level name. The Level will be highlighted in a box. Note If you ...
    • Time Dependent Levels

      Levels 4 to 6 are called Time Dependent Levels and cannot be manually set in the Levels Panel. These time dependent levels are automatically created by DataSight when a sample event or record is entered in your database. The list is constructed in ...
    • Different Levels, Same Variable

      DataSight charts can be constructed to compare data for the same variable across multiple locations. Click Chart in the View group on the DataSight Ribbon to open a blank chart template in the Main Panel. Identify the monitoring locations that you ...
    • Video: Report Designer Quick Charts for Multiple Variables or Levels

    • Datasheets

      The Datasheet panel displays data from the database in a tabular normalised format. Every row of data is a unique record in the database defined by its Level 3 name Datetime stamp Variable, and Value Metadata consisting of Person Name, Equipment ...