Tools

This is table toolkit

Tabulate Area

Calculates cross-tabulated areas between two datasets and outputs a table. Output table that will contain the summary of the area of each class in each zone. Each record will store the area of each class (in raster) within each zone (vector).

../../_images/tabulate_area.png ../../_images/tabulate_area_properties.png
  1. Type Name

  2. Select destination folder to store result

  3. Select image

  4. Select mask image

  5. Select mask value: fill some values of image. If select all value, skip this field.

  6. Select vector

  7. Property selection: Field that holds the values that define each zone.

Join

Join tool is used to combine data or rows from two or more tables based on a common field between them.

../../_images/join.png

Inner Join: creates a new table by combining column values of two tables based upon the join-predicate. When the join-predicate is satisfied, column values for each matched pair of two rows are combined into a result row.

Left Join: returns all rows from the left table, even if there are no matches in the right table. This means that a left join returns all the values from the left table, plus matched values from the right table or NULL in case of no matching join predicate.

Rigth Join: returns all rows from the right table, even if there are no matches in the left table. This means that a right join returns all the values from the right table, plus matched values from the left table or NULL in case of no matching join predicate.

Full Join: combines the results of both left and right outer joins. The joined table will contain all records from both the tables and fill in NULLs for missing matches on either side.

../../_images/join_column_selection_1.png

Column selection: add (1), delete selected item (2), change sequence field (3, 4), delete all item (5) and edit item (6).

Zonal Statistics as Table

Summarizes the values of a raster within the zones of another dataset and reports the results as a table.

../../_images/zonal_statistics_as_table.png ../../_images/zonal_as_table_properties.png
  1. Type Name

  2. Select destination folder to store result

  3. Select image

  4. Select vector

  5. Property selection: The field that contains the values that define each zone.

Accuracy Report

../../_images/accuracy_report.png
  1. Type Name

  2. Select destination folder to store result

  3. Select image

  4. Select reference image

Unpivot Columns

Flattening the data, to put it in a matrix format so that all similar values are in one column.

../../_images/unpivot_columns_example.png ../../_images/unpivot_columns.png
  1. Type Name

  2. Select destination folder to store result

  3. Select table

  4. Type Attributes column name: which are unpivoted into a new column and mapped to the new Values column.

  5. Type Value column name

  6. Columns Setting:

Column selection: add (1), delete selected item (2), change sequence field (3, 4), delete all item (5) and edit item (6) to switch on/off the unpivot.

../../_images/unpivot_columns_setting.png

Union

Combines the results of two or more tables into a single table that includes all the rows that belong to all tables

../../_images/union_example.png ../../_images/union_table.png
  1. Type Name

  2. Select destination folder to store result

  3. Select tables: select two or more tables

  4. Choose option Union all: when keeping all rows of each table.