topic Using Variable for Where Clause in search cursor in Python Questions

Using Variable for Where Clause in search cursor

RyanTucker1 — Tue, 31 Mar 2015 01:31:19 GMT

How do I go about using a variable from a raw_input for the where clause in da.SearchCursor?

I can't seem to get the syntax correct

Code:

import arcpy
from arcpy import env
env.workspace=r"F:\GEOG_488\Final_Project_Data\FinalProject488.gdb"
fc="PARCELS" #Create variable for feature class
tc="ADDRESS_TEST_20" #Create variable for table

HouseNumber = int(raw_input("Enter Address Number: ")) #User input House Number
print "Situs Addresses with "+ str(HouseNumber)+" for the Situs Number:"

cursor = arcpy.da.SearchCursor(tc,["ADDR"],'"SA_House_Number"= HouseNumber') #Create search cursor where records = HouseNumber
for row in cursor:
print "Situs Address with House Number"+str(HouseNumber)":",row[0]

del row, cursor

Thanks for any help.

Re: Using Variable for Where Clause in search cursor

DarrenWiens2 — Tue, 31 Mar 2015 04:20:53 GMT

Escape HouseNumber from the where clause string.

Re: Using Variable for Where Clause in search cursor

ModyBuchbinder — Tue, 31 Mar 2015 04:57:41 GMT

'"SA_House_Number" = ' + str(HouseNumber)

When the HouseNumber is inside the quotes it is not recognized as variable

I am not sure you have to put the attribute name (SA_House_Number) in quotes in the new versions.

Re: Using Variable for Where Clause in search cursor

JoshuaBixby — Tue, 31 Mar 2015 13:17:38 GMT

I encourage you to learn about Python string formatting (Format String Syntax). It is extremely robust.

cursor = arcpy.da.SearchCursor(tc,["ADDR"],"SA_House_Number = {}".format(HouseNumber))

Re: Using Variable for Where Clause in search cursor

RyanTucker1 — Tue, 31 Mar 2015 15:06:42 GMT

Thank you all for your help. It now works using both the suggestion from Mody and Joshua.

I'm now reading up on string formatting.

Thanks again!

Ryan

Re: Using Variable for Where Clause in search cursor

danashney — Mon, 15 Jun 2015 21:11:33 GMT

Joshua Bixby deserves a beer or milk shake if a teetotaler.

+1 for string formatting.