Sort (Data Management)


This tool reorders, in ascending or descending order, records in a feature class or table based on field values. The reordered result is copied to a new dataset.



Sort_management (in_dataset, out_dataset, sort_field, {spatial_sort_method})
ParameterExplanationData Type

The input dataset whose records will be reordered based on the field values in the sort field(s).

Table View

The output feature class or table.

Feature Class;Table
[[Sort Field, Direction],...]

Specifies the field(s) whose values will be used to reorder the input records, and the direction the records will be sorted.

  • ASCENDINGRecords are sorted from low value to high value.
  • DESCENDINGRecords are sorted from high value to low value.
Value Table

Specifies how features are spatially sorted. Sort method is only enabled when 'Shape' is selected as one of the sort fields.

  • URSorting starts at upper right corner. This is the default.
  • ULSorting starts at upper left corner.
  • LRSorting starts at lower right corner.
  • LLSorting starts at lower left corner.
  • PEANOSorting uses a space filling curve algorithm, also known as a peano curve.

Code Sample

Sort Example 1 (Python Window)

The following Python window script demonstrates how to use Sort to order features by the values of a field.

import arcpy
from arcpy import env
env.workspace = "C:/data/input/sort.gdb"

arcpy.Sort_management("crime", "crime_Sort", [["DATE_OCCURRED", "ASCENDING"]])
Sort Example 2 (stand-alone Python Script)

The following Python script demonstrates how to use the Sort in a stand-alone script.

# Name:
# Description: Sorts wells by location and well yield.
# Author: ESRI

# Import system modules
import arcpy
from arcpy import env

    # Set workspace environment
    env.workspace = "C:/data/newfoundland.gdb"

    # set local variables
    inDataset = "wells"
    outDataset = "wells_Sort"

    # Order features first by location (Shape) and then by WELL_YIELD
    sort_fields = [["Shape", "ASCENDING"], ["WELL_YIELD", "DESCENDING"]]

    # Use Peano algorithm
    sort_method = "PEANO"

    # execute the function
    arcpy.Sort_management(inDataset, outDataset, sort_fields, sort_method)

    # Print error messages


Related Topics

Licensing Information

ArcView: Yes
ArcEditor: Yes
ArcInfo: Yes