Get Count (Data Management)

Summary

Returns the total number of rows for a table.

Usage

• If the input is a layer or table view containing a selected set of records, only the selected records will be counted.

• This tool honors the Extent environment. Only those features that are within or intersect the Extent environment setting will be counted.

• You can view the returned row count in Geoprocessing history.

• In ModelBuilder, this tool can be used to set up a precondition, as illustrated below. In this model, the Get Count tool counts the number of records returned by the Select tool. If the count is zero, the Buffer tool will not run due to the precondition.

  

Parameters

Dialog

Label	Explanation	Data Type
Input Rows	The input table view or raster layer. If a selection is defined on the input, the count of the selected rows will be returned.	Table View; Raster Layer

Derived Output

Label	Explanation	Data Type
Row Count	The total number of rows for the input.	Long

Python

arcpy.management.GetCount(in_rows)

Name	Explanation	Data Type
in_rows	The input table view or raster layer. If a selection is defined on the input, the count of the selected rows will be returned.	Table View; Raster Layer

Derived Output

Name	Explanation	Data Type
row_count	The total number of rows for the input.	Long

Code sample

GetCount example 1 (Python window)

The following Python window script demonstrates how to use the GetCount function in immediate mode.

import arcpy
arcpy.env.workspace = "C:/data/data.gdb"
result = arcpy.management.GetCount("roads")
count = int(result[0])
print(f'roads has {count} records')

GetCount example 2 (stand-alone script)

The following stand-alone script is an example of how to use the GetCount function in a scripting environment.

# Purpose: Calculate the number of features in a feature class

# Import system modules
import arcpy
 
lyrfile = r"C:\data\streets.lyr"
result = arcpy.management.GetCount(lyrfile)

count = int(result[0])

# Print the number of features using the Result object
print(f'{lyrfile} has {count} records')

Environments

Current Workspace, Extent