arcgis python获得字段唯一值
# Import native arcgisscripting module
import arcgisscripting, sys
# Create the geoprocessor object
gp = arcgisscripting.create(9.3)
# Table and field name inputs
inTable = sys.argv[1]
inField = sys.argv[2]
rows = gp.SearchCursor(inTable)
row = rows.Next()
# Create an empty list
uniqueList = []
while row:
# If the value is not already in the list, append it
if row.GetValue(inField) not in uniqueList:
uniqueList.append(row.GetValue(inField))
row = rows.Next()
# Sort the list alphanumerically
uniqueList.sort()
print uniqueList
========================================
# -*- coding: cp936 -*- import arcpy import os import sys inTable = arcpy.GetParameterAsText(0) inField = arcpy.GetParameterAsText(1) rows = arcpy.SearchCursor(inTable) # Create an empty list gisoracle uniqueList = [] for row in rows: # If the value is not already in the list, append it if row.getValue(inField) not in uniqueList: uniqueList.append(row.getValue(inField)) # Sort the list alphanumerically #uniqueList.sort() arcpy.AddMessage("个数: " + str(len(uniqueList)))
# -*- coding: cp936 -*- import arcpy import os import sys def getuniqueValue(inTable,inField): rows = arcpy.SearchCursor(inTable) # Create an empty list uniqueList = [] for row in rows: # If the value is not already in the list, append it by gisoracle if row.getValue(inField) not in uniqueList: uniqueList.append(row.getValue(inField)) return uniqueList inTable = arcpy.GetParameterAsText(0) inField = arcpy.GetParameterAsText(1) uniqueList=getuniqueValue(inTable,inField) arcpy.AddMessage("个数: " + str(len(uniqueList)))
分类: Python