topic Re: Creating a Custom Toolbar Button in Python Questions

Creating a Custom Toolbar Button

KimBeckwell — Wed, 07 Sep 2011 16:14:44 GMT

Hi,
I'm not sure if this is where I should post this but if someone could point me in the right direction of learning how to do this, I'd be forever grateful.....I would like to create a custom toolbar button that I can add to my ArcMap.mxd that will run a select and prompt me for a parcel number, and after keying the number in it will zoom to the selected parcel.

I would appreciate any help! Thanks!

Kim

Re: Creating a Custom Toolbar Button

KimBeckwell — Wed, 07 Sep 2011 18:54:27 GMT

Should I use a VBA macro?

Re: Creating a Custom Toolbar Button

MathewCoyle — Sun, 12 Dec 2021 05:43:05 GMT

If you just need to enter a value and zoom to that feature you can make a simple script tool, something along these lines. Add it to a toolbox and then make it a button.

import arcpy
arcpy.AddMessage("Starting")
city = arcpy.GetParameterAsText(0)
arcpy.AddMessage(city)
mxd = arcpy.mapping.MapDocument("CURRENT")
df = arcpy.mapping.ListDataFrames(mxd, "Main Map")[0]
lyr = arcpy.mapping.ListLayers(mxd, "Cities, Towns and Urban Service Areas", df)[0]
arcpy.AddMessage(lyr.name)
expression = "NAME = '"+city+"'"
arcpy.AddMessage(expression)
arcpy.SelectLayerByAttribute_management(lyr,"NEW_SELECTION",expression)
df.extent = lyr.getSelectedExtent()
df.scale = df.scale*1.2
arcpy.RefreshActiveView()

Re: Creating a Custom Toolbar Button

KimBeckwell — Thu, 08 Sep 2011 15:46:07 GMT

Matthew, You are awesome! Thank You!

Re: Creating a Custom Toolbar Button

JacobDrvar — Wed, 17 Jul 2013 13:24:10 GMT

All,

I am new to Python scripting. I am attempting to modify the code provided. I have a Parcels Feature Class and want to search based on a RENUM attribute field. I am running into a SyntaxError on line 5 . Any ideas why? Thanks.

Re: Creating a Custom Toolbar Button

JacobDrvar — Sun, 12 Dec 2021 05:43:08 GMT

I am modifying the script to Search the field RENUM from a Parcels Feature Class. When, I run the script I receive the following error:
Executing: SelectLayerByAttribute GPL0 NEW_SELECTION 2205529
Start Time: Thu Jul 18 07:56:47 2013
ERROR 000358: Invalid expression
An invalid SQL statement was used.
An invalid SQL statement was used. [Parcels]
An invalid SQL statement was used. [SELECT OBJECTID FROM Parcels WHERE 2205529]
Failed to execute (SelectLayerByAttribute).

2205529 is a valid record within the RENUM field that I enter into the Script. The tool runs, but the record is not selected. What am I overlooking?

My script is shown below:

#Import modules
import arcpy
arcpy.AddMessage("Start")

#Variables
Parcels = arcpy.GetParameterAsText(0)
arcpy.AddMessage(Parcels)

mxd = arcpy.mapping.MapDocument("CURRENT")
df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]
lyr = arcpy.mapping.ListLayers(mxd, "Parcels", df)[0]
arcpy.AddMessage(lyr.name)

#Logic
try:
 whereClause = "RENUM = '"+Parcels+"'"
 arcpy.AddMessage("whereClause")

 arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", whereClause)
 arcpy.AddMessage("Selection")

except:
 exit()