Sort
Feature Description
Sorts the dataset based on field values and saves the sorted result as a new dataset.
Special Notes:
- This tool is only applicable to: UDB/UDBX and database-type data sources.
- Different databases may have varying sorting results for certain data type fields due to inherent database behaviors. Examples: (1) UDBX sorts Chinese characters based on Unicode encoding, while PostGIS relies on the database's locale settings (e.g., when using Chinese UTF-8 locale "zh_CN.UTF8", Chinese characters are sorted by pinyin initials), leading to inconsistent sorting results between UDBX and PostGIS. (2) Similarly, UDBX and PostGIS may produce different sorting results for special characters (~!@#$%^&*()-_=+|[{}];:,<.>/?) due to differing sorting rules.
Parameter Description
| Parameter | Description | Type |
|---|---|---|
| Datasource | Specifies the datasource containing the dataset to be sorted. | Datasource |
| Dataset | Specifies the source vector dataset to be sorted. | DatasetVector |
| Sort field | Specifies the field to sort by. | OrderByField[] |
| Sort order | Specifies the sorting method (ascending/descending) for each field. | OrderByField[] |
| Spatial Field Sorting Method | Specifies the spatial sorting method, supporting Upper Right, Upper Left, Lower Right, and Lower Left (default: Upper Right). If no sort field is specified, this parameter is invalid. Currently supports UDBX and PostGIS data sources. |
GeoFieldSortMethodEnum |
| Target Datasource | Specifies the datasource to store the result dataset. | Datasource |
| Result Dataset Name | The name of the sorted result dataset. | String |
| Overwrite Existing Dataset (Optional) | Determines whether to overwrite existing datasets with the same name. Check to overwrite; uncheck to fail when duplicates exist (default: unchecked). | boolean |
Output
| Parameter | Description | Type |
|---|---|---|
| Target Dataset | The resulting vector dataset. | DatasetVector |