Summary

Feature Description

Summary calculates statistical data for fields in attribute tables. The summary results will output a new attribute table containing statistical operation fields and frequency counts for each unique value in summary groups.

Multiple summary types can be set simultaneously for comprehensive statistical analysis. The output remains in tabular format for convenient export to Excel or other applications. For example, when summarizing land use data requiring statistics on slope, land quality classification, cultivated land, and construction land areas, this feature eliminates repetitive setup and delivers results efficiently.

Feature Entry

  • Table tab->Statistics group->Summary button

Parameter Description

  • Source Dataset: Configure data participation through filter expressions and group fields.
    • Filter Expression: Filter irrelevant data using SQL syntax. For SQL usage, refer to SQL Query.
    • Group Field: Supports hierarchical grouping. Undefined groups produce single-record outputs. Single-group fields generate per-value records. Multiple groups enable secondary grouping within primary groups.
  • Summary: Select fields and configure statistical types.
    • Select Statistic Field: Checkbox selection determines field participation.
    • Statistics Type: Available operations: Maximum, Minimum, Sum, Average, Standard Deviation, Variance (multiple selections allowed). Example settings: Maximum, Minimum, Sum.
    • Result fields follow naming conventions: Max_‘field’, Min_‘field’, Sum_‘field’, Average_‘field’, StdDeviation_‘field’, Variance_‘field’ (where ‘field’ represents input field name).
  • Target Dataset: Configure output datasource and dataset for summary results.

Application Example

Case Description

Land use classification data contains fields: Administrative Division (XZQHMC), Land Type (DLMC), Plot Area (TBDLMJ). Requirement: Summarize plot areas by administrative division and land type. Demonstration uses sample data: SampleData\ExerciseData\LandUse\LandUse.udbx.

Main Steps

  1. Open LandUse.udbx, right-click vector dataset JSTB and select Browse Attribute Table.
  2. Click Table tab->Statistics group->Summary button; or right-click Summary Field... to open dialog.
  3. Set group fields: XZQHMC (primary grouping), DLMC (secondary grouping within primary groups).
  4. Check TBDLMJ (Plot Area) field and set statistics types to Max, Min, Sum.
  5. Specify output datasource and dataset.
  6. Click OK to execute. Results display in output window. New tabular dataset is generated.

Show Result

XZQHMC and DLMC are group fields. Statistic_Count shows frequency per group. Max_TBDLMJ, Min_TBDLMJ, Sum_TBDLMJ display statistical results.

Related Topics

Attribute Table Statistics