Using SQL query with ArcPy?

Question

I'm creating a tool that when you type in the city name it will select the city, zoom in and label it. I have the zoom and label working but can't figure out the SQL Query needed to select the city I type in the tool in ArcMap. My code in below.

I'm still new at this

import arcpy as ARCPY

def citySelect():

    mxd = ARCPY.mapping.MapDocument("CURRENT")
    df = ARCPY.mapping.ListDataFrames(mxd)[0]
    city = ARCPY.GetParameter(0)
    cities = ("N:/Lab13/Lab13/cities.lyr")
    ARCPY.SelectLayerByAttribute_management("cities", "NEW_SELECTION",''' "CITY_NAME" = ' city ' ''')
    print city[0]
    layers = arcpy.mapping.ListLayers(mxd, "", df)
    citiesLayer = layers[0]
    df.zoomToSelectedFeatures()
    citiesLayer.showLabels =True
    ARCPY.RefreshActiveView()

citySelect()

You have a different potential issue too. You have a variable cities which is pointing to a layer file, but SelectLayerByAttribute_management uses a quoted string "cities" which implies you're have access to a layer straight from the map table of contents--which may not be available depending on the context of how you are running this. — DWynne
– DWynne, Commented May 2, 2015 at 0:14
This is an aside to your issue, but I think import arcpy as ARCPY makes your code awkward to read when everyone here seems to use the simpler import arcpy. — PolyGeo
– PolyGeo ♦, Commented May 2, 2015 at 3:20

DWynne · Accepted Answer · 2015-05-02 00:12:11Z

3

The call to SelectLayerByAttribute could be handled like this: ARCPY.SelectLayerByAttribute_management('cities', "NEW_SELECTION", "CITY_NAME = '{}'".format(city))

answered May 2, 2015 at 0:12

DWynne

2,40412 silver badges22 bronze badges

Ok thanks for the response! I'm going to try to get to the lab to try it tomorrow

Dale
– Dale

2015-05-02 01:25:07 +00:00
Commented May 2, 2015 at 1:25

Add a comment |

PolyGeo · Accepted Answer · 2015-05-02 03:26:49Z

0

I think you should use arcpy.GetParameterAsText(0) to pull in the city name and guarantee that it is a string.

You can then print it to confirm its name before using it in SelectLayerByAttribute.

Changing:

ARCPY.SelectLayerByAttribute_management("cities", "NEW_SELECTION",''' "CITY_NAME" = ' city ' ''')

to:

ARCPY.SelectLayerByAttribute_management("cities", "NEW_SELECTION",'"CITY_NAME" = ' + "'" + city + "'")

should then work.

answered May 2, 2015 at 3:26

PolyGeo♦

65.5k29 gold badges115 silver badges353 bronze badges

Add a comment |

Stack Exchange Network

Using SQL query with ArcPy?

2 Answers 2

Your Answer

Linked

Hot Network Questions

Using SQL query with ArcPy?

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Linked

Related

Hot Network Questions