Export Attribute Table

Function Description

Supports quickly exporting the selected records (rows) from the current attribute table as a new dataset or various common file formats. After you filter or select partial records in the attribute table, you can directly perform data extraction and distribution via the context menu without switching tools, significantly improving the efficiency of data export, exchange, and backup based on attribute search results.

Core supported capabilities include:

  • Save as dataset: Create a new dataset or pure attribute table within the workspace.
  • Export to external files: Supports exporting to five common formats: Excel, Shapefile, GeoJSON, SimpleJSON, and WKT.

Function Limitations:

  • The attribute table of a route dataset does not support export to Shapefile, GeoJSON, SimpleJSON, and WKT file formats.
  • The attribute table of 3D point, line, or region datasets does not support export as SimpleJSON.
  • The attribute table of a Model Dataset only supports export to the Excel format among external files.
  • The attribute table of a network dataset does not support output as a network dataset.
  • Arm environments do not support exporting selected records as SimpleJSON.

Function Entrance

  • In the opened attribute table, select the record rows to be exported; right-click in the attribute table area -> select Save as in the pop-up menu.
  • Or via the functional panel: Attribute Table Tab -> Output Group -> Click Save as Dataset, Save as Excel.

Operation Instructions

The Save as option in the context menu includes the following sub-options:

Dataset

Saving as a dataset involves outputting the geometry or attribute information stored in a vector dataset's attribute table as a new dataset or tabular dataset, or outputting the attribute information of the attribute table as a new tabular dataset.

  1. In the current window, select the objects to be exported using any method, right-click the mouse, and choose Save As -> Dataset from the context menu. The Save as Dataset dialog box will pop up.
  2. Parameter Description:
  • Select Fields: Save the values of the selected fields in the output dataset.
  • Datasource: The datasource where the resulting dataset will be saved.
  • Dataset: The name of the resulting dataset.
  • Result Dataset Type: Select the data type when outputting as a new dataset.

    • If it is a vector dataset, it can be output as the same type of vector dataset or a tabular dataset;

    • If it is a tabular dataset, only output as a tabular dataset is supported;

    • If it is a network dataset, it can be output as a line dataset or a tabular dataset; output as a network dataset is not supported.

  • Encode Type: When outputting the attribute table of a vector dataset as a new dataset, you can reset the dataset's encode type.

    When outputting the attribute table of a vector dataset (except point datasets) as a new dataset, the system provides four vector data compression encode types for users to choose from: Single Byte, Double Byte, Three Byte, and Four Byte, which refer to using 1, 2, 3, or 4 bytes to store a single coordinate value, respectively. Users can select a vector data compression method according to their actual needs. After setting the parameters, the resulting dataset will be displayed under the node of its saved datasource in the workspace manager.

Notes:
  • If the name entered by the user for the resulting dataset in the Save as Dataset dialog box is invalid, the system will prompt the user to modify the resulting dataset name.
  • Users can open attribute tables or tabular datasets of several datasets simultaneously, but can only perform output operations on the attribute table or tabular dataset currently displayed in the active window.

Excel / Shapefile / GeoJSON / SimpleJSON / WKT

Export selected records to the specified common file format. These five formats share a unified operation logic.

  1. After selecting records in the attribute table, right-click and choose Save as -> Select one of Excel, Shapefile, GeoJSON, SimpleJSON, or WKT.
  2. Parameter Description
  • Dialog Title: Dynamically displays as "Export to [file type]", e.g., "Export to Excel".
  • Field List: Check the fields to be exported in the field list. You can use the toolbar functions for Select All, Invert Selection, Select System Fields, and Select Non-system Fields. Non-system fields are checked by default.
  • Export Path: Set the save path for the exported file.
  • File Name: Enter the file name. The default value is export_[file type], e.g., export_excel.xlsx.

  • Keep only selected object: Checked by default. Controls whether to export only the currently selected records or all records from the source data.

  • Hide System Fields: Only appears when exporting to Excel format. When checked, only non-system fields are exported.

  • Charset: Only appears when exporting to Excel or Shapefile format. Used to set the text encoding format for the exported file. Other formats (GeoJSON, SimpleJSON, WKT) use a fixed encoding (e.g., UTF-8) and do not have this option.

Notes:
  • Arm environments do not support exporting selected records as SimpleJSON.
  • Users can open attribute tables or tabular datasets of several datasets simultaneously, but can only perform the "Save as Excel" operation on the attribute table or tabular dataset currently displayed in the active window.