SearchCursor

摘要

从要素类或表中返回属性值行。

SearchCursor 函数遍历 Row 对象并提取字段值。

旧版本:

此函数在 ArcGIS 10.1 中已被 arcpy.da.SearchCursor 取代,保留此函数仅供旧版脚本使用。 要改进性能、功能和支持更新的字段类型和令牌,请使用 arcpy.da.SearchCursor

说明

可用于迭代搜索游标的方式有两种:for 循环或者 while 循环(通过游标的 next 方法返回下一行)。 如果要使用游标的 next 方法来检索行数为 N 的表中的所有行,则脚本必须调用 next N 次。 在检索到结果集中的最后一行后调用 next 将返回一个 None 类型,在此处用作占位符。

for 循环中遍历 SearchCursor 函数返回的行。

import arcpy

fc = "c:/data/base.gdb/roads"
field = "StreetName"
cursor = arcpy.SearchCursor(fc)
for row in cursor:
    print(row.getValue(field))

while 循环中遍历 SearchCursor 函数返回的行。

import arcpy

fc = "c:/data/base.gdb/roads"
field = "StreetName"
cursor = arcpy.SearchCursor(fc)
row = cursor.next()
while row:
    print(row.getValue(field))
    row = cursor.next()

语法

SearchCursor (dataset, {where_clause}, {spatial_reference}, {fields}, {sort_fields})
参数说明数据类型
dataset

The feature class or table containing the rows to be searched.

String
where_clause

An expression that limits the rows returned in the cursor. For more information about where clauses and SQL statements, see Introduction to query expressions.

String
spatial_reference

Coordinates are returned in the spatial reference provided.

SpatialReference
fields

A semicolon-delimited string of fields to be included in the cursor. By default, all fields are included.

String
sort_fields

The fields to sort the rows in the cursor.

Ascending and descending order for each field is denoted by A for ascending and D for descending, using the form "field1 A;field2 D".

String
返回值
数据类型说明
Cursor

返回 Row 对象的 Cursor 对象。

代码示例

SearchCursor 示例

列出要素类的字段内容。 游标按州名称和人口进行排序。

import arcpy

# Create a search cursor for a feature class
rows = arcpy.SearchCursor("c:/data/counties.shp",
                          fields="NAME; STATE_NAME; POP2000",
                          sort_fields="STATE_NAME A; POP2000 D")

# Iterate through the rows in the cursor and print out the
# state name, county and population of each.
for row in rows:
    print("State: {0}, County: {1}, Population: {2}".format(
        row.getValue("STATE_NAME"),
        row.getValue("NAME"),
        row.getValue("POP2000")))

相关主题