casaGeoToolbox

casaGeoToolbox

Tools that facilitated and thus usually accelerated our work on numerous customer- and analysis-projects are gathered tools in the casaGeoToolbox. In part, the applications have been developed at the suggestion of customers.

The individual tools are briefly described in the following overview.

Tools

Class Limits
ClassLimits

In Alteryx, data is classified via the tile tool. The class boundaries are generated by aggregation across the classes and the minimum and maximum values of the class-building variable. This can lead to gaps between classes (especially when working with decimal values), which can be unfavourably.

This is where the Class Limits Tool comes in: It synchronizes the class boundaries either based on upper or lower bounds.

In addition, the tool offers the possibility of freely defining the smallest value of the first and the highest value of the last class. The two values can be shown as zero values if no smallest and largest value are to be specified.

The Class Limits tool also prepares the data for the Easy Legend tool and the Easy Line Header tool.

INPUT

  • Tile_num
  • class forming variable

OUTPUT

  • Tile_num
  • Floor (lower bound)
  • Ceiling (upper bound)
  • Count (number of records per class)
  • Percent (number of records per class in percent)

 

Easy Legend

The Easy Legend tool automatically creates the legend of a thematic map. This is done as follows:

  1. The data is classified (e.g. With the tile tool)
  2. The classified data is passed to the map tool. Select “unique value“ as theme.
  3. The legend is output in “separate field
  4. The classified data is transmitted to the Class Limits tool and prepared accordingly. If null values are selected, the legend will show “greater than“ or “less than
  5. The legend from the Map tool is linked via INPUT L and the output from the Class Limits tool via INPUT T with Easy Legend
EasyLegend

INPUT

  • Headline
  • Above – only active, if highest upper bound is a zero value
  • Below – only active, if lowest lower bound is a zero value
  • To
  • Add Count – number of records (absolute or as a percentage) can be added in brackets
  • Prefix / Suffix – units of measure can be added before or after a value or a row
  • Separator – inserts thousands separator and can convert the decimal separator to comma (applies to class boundaries and number of records)
Legend generated with Easy Legend

OUTPUT

  • Legend

 

 

                                              

                                                                                                           

Easy Line Header
EasyLineHeader

The Easy Line Header Tool helps creating header lines. Similar to the Easy Legend Tool, it offers different options to design the header lines. Input is the output of class limits.

INPUT

  • Above – only active, if highest upper bound is a zero value
  • Below – only active, if lowest lower bound is a zero value
  • To
  • Prefix / Suffix – units of measure can be added before or after a value or a row
  • Separator – inserts thousands separator and can convert the decimal separator to comma (only applies to class boundaries)

 

GroupRecordID

The GroupRecordID tool creates a unique ID for each record in a group. For each group the numbering starts again with the value 1.

Specific Factor
Specific Factor

The Specific Factor tool enables the combination of a multiline table of variables with a single-line table of factors. One column is linked with one factor. The assignment of the variables to the factors takes place either via the position (first variable with first factor etc.) or via the suffixes (v1 to f1, v2 to f2,…). In the second case, the order does not matter.

Alternatively, the factor file can only consist of one column. The number of lines must then correspond to the number of columns to be linked in the variable file. In this case, the link is made exclusively via the position. 

INPUT I

ID of variable data

INPUT V

Variables from variable data that should be linked

INPUF F

Factors from factor data

Interface

  • ID
  • Select variables
  • Select factors
  • Assigning factor via position (suffix is default)
  • Operation (addition, division, multiplication, subtraction)
  • Output name without suffix (name of resulting variable)

OUTPUT P

  • ID
  • Output name with suffix

OUTPUT C

  • ID
  • variable (name)
  • factor (name)
  • Operation

 

Stratified Random Sample
Stratified Random Sample

The Stratified Random Sample tool enables the draw of a stratified random sample. Either the same number or the same percentage per group is drawn from each group / shift.

INPUT

  • Random N Records
  • Random N% of Records
  • Deterministic Output
  • Group (group variable)

OUTPUT returns the sample according to the parameters.