nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Select from user input variable

NoahHuntington

Please help. Unable to make selection.

Here is what I have....

# Model selects parcel from user input import arcpy  # Assign variable to the feature class featureClass = "G:\\PRAD\\PRAD_v10.1.gdb\\tax_acct"  # Assign variable to users input input = arcpy.GetParameterAsText(0)  # Make a feature layer from feature class arcpy.MakeFeatureLayer_management(featureClass, "layer")       # Apply a selection to the feature layer  arcpy.SelectLayerByAttribute_management("layer", "NEW_SELECTION", '"'+str(input)+'"')

Najděte více příspěvků označených jako

Accepted answers

NoahHuntington

Well first of all you don't have feature classes in your TOC, you have layers pointing to your feature classes on disk. These are the objects you make selections on, you cannot make selections on feature classes.

Try running this as your script. You could also add another input parameter to select the layer manually.

import arcpy  def main():     arcpy.AddMessage("Starting")      # Get and set variables     job_num = arcpy.GetParameterAsText(0)     layer_name = "tax_acct"     df_name = "Layers"      arcpy.AddMessage(job_num)      # Define mxd, df and lyr objects     mxd = arcpy.mapping.MapDocument("CURRENT")     df = arcpy.mapping.ListDataFrames(mxd, df_name)[0]     lyr = arcpy.mapping.ListLayers(mxd, layer_name, df)[0]      arcpy.AddMessage(lyr.name)      # Create where clause for selection     query = "Job_Num = '%s'" % (job_num)      arcpy.AddMessage(query)      arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", query)      # Get number of selected features     selection = int(arcpy.GetCount_management(layer_name).getOutput(0))      arcpy.AddMessage("%s features selected" % (selection))      # Set df extent to layer selection     df.extent = lyr.getSelectedExtent()     arcpy.RefreshActiveView()      arcpy.AddMessage("Completed")  main()

That was perfect!!! Your fast too! Just a couple questions? What was going on with the addmessages methods? Also some of these features have 1, 2, or 3 possible job numbers associated with them, as in fields Job_Num2, Job_Num3, so on.... Would there be a way add multiple fields to the query? Job_Num, or Job_Num2, or Job_Num3..

All comments

NoahHuntington

I'm not sure what you are doing since you will never be able to select one row with any query unless you reference a unique ID, which it seems neither job_num nor job_num2 are. If there are values that are the same between the two columns but do not match the same row this would be even more challenging to implement in a single parameter.

If there are no numbers that match between the columns and you just want a number inputted to return any result from those three columns that match, try this as your query.
query = "{1} = '{0}' or {2} = '{0}' or {3} = '{0}'".format(job_num, "Job_Num", "Job_Num2", "Job_Num3")

I am probably adding to the confusion here. In the picture above I would like to be able to use either '976488' or '98770' in query parameter to select that top record.

MathewCoyle

[ATTACH=CONFIG]17604[/ATTACH]

I would like to be able to get same selection of first row by using either job_num or job_num2 using single input box.

I'm not sure what you are doing since you will never be able to select one row with any query unless you reference a unique ID, which it seems neither job_num nor job_num2 are. If there are values that are the same between the two columns but do not match the same row this would be even more challenging to implement in a single parameter.

If there are no numbers that match between the columns and you just want a number inputted to return any result from those three columns that match, try this as your query.

query = "{1} = '{0}' or {2} = '{0}' or {3} = '{0}'".format(job_num, "Job_Num", "Job_Num2", "Job_Num3")

NoahHuntington

Possibly, you would need to describe your schema and values more though or post examples of your data.

[ATTACH=CONFIG]17604[/ATTACH]

I would like to be able to get same selection of first row by using either job_num or job_num2 using single input box.

2012-09-11_1128.png

MathewCoyle

Is there a way of doing something similar and searching three fields with one input box?

Possibly, you would need to describe your schema and values more though or post examples of your data.

NoahHuntington

I made a slight addition to the loop to add the if/else to get the proper and statements added.

Is there a way of doing something similar and searching three fields with one input box?

MathewCoyle

Ok. I will see what I can do with that. Thanks for all your help!

I made a slight addition to the loop to add the if/else to get the proper and statements added.

NoahHuntington

For each field you will need a new parameter added to your tool. There are a couple ways to go about it, and it gets a little more complicated if you want it to be dynamic (eg a user can select any number of fields to put in the query).
    job_num = arcpy.GetParameterAsText(0)
    job_num2 = arcpy.GetParameterAsText(1)
    job_num3 = arcpy.GetParameterAsText(2)
    ...
    # Create where clause for selection
    query = ""
    query_list = [("Job_Num", job_num), ("Job_Num2", job_num2), ("Job_Num3", job_num3)]
    for field_name, variable in query_list:
        query = query + "%s = '%s' " % (field_name, variable)
Something like that should get you on track. May require some tinkering to make it work for you.

Ok. I will see what I can do with that. Thanks for all your help!

MathewCoyle

For each field you will need a new parameter added to your tool. There are a couple ways to go about it, and it gets a little more complicated if you want it to be dynamic (eg a user can select any number of fields to put in the query).

    job_num = arcpy.GetParameterAsText(0)
    job_num2 = arcpy.GetParameterAsText(1)
    job_num3 = arcpy.GetParameterAsText(2)
    ...
    # Create where clause for selection
    query = ""
    query_list = [("Job_Num", job_num), ("Job_Num2", job_num2), ("Job_Num3", job_num3)]
    for field_name, variable in query_list:
        if query == "":                                              
            query = "%s = '%s'" % (field_name, variable)            
        else:                                                        
            query = query + " and %s = '%s'" % (field_name, variable)

Something like that should get you on track. May require some tinkering to make it work for you.

NoahHuntington

The addmessages are there just to check your variables to make sure they are what you are expecting. They are unnecessary for the script itself and more for trouble shooting.

If you are selecting from multiple fields, are they all the same value from these fields? Or do you want unique values from each field?
Eg
Job_Num = "first" and Job_Num2 = "first"
# or
Job_Num = "first" and Job_Num2 = "second"

They exist b/c we have revisited parcels sometimes multiple times each with a new job number. Added field to table to handle new job number. I am not sure the following is correct, where should this query take place.


    # Get and set variables
    Job_Num = "first" and Job_Num2 = "second" = arcpy.GetParameterAsText(0)
    layer_name = "tax_acct"
    df_name = "Layers"

MathewCoyle

That was perfect!!! Your fast too! Just a couple questions? What was going on with the addmessages methods? Also some of these features have 1, 2, or 3 possible job numbers associated with them, as in fields Job_Num2, Job_Num3, so on.... Would there be a way add multiple fields to the query? Job_Num, or Job_Num2, or Job_Num3..

The addmessages are there just to check your variables to make sure they are what you are expecting. They are unnecessary for the script itself and more for trouble shooting.

If you are selecting from multiple fields, are they all the same value from these fields? Or do you want unique values from each field?
Eg

Job_Num = "first" and Job_Num2 = "first"
# or
Job_Num = "first" and Job_Num2 = "second"

NoahHuntington

import arcpy  def main():     arcpy.AddMessage("Starting")      # Get and set variables     job_num = arcpy.GetParameterAsText(0)     layer_name = "tax_acct"     df_name = "Layers"      arcpy.AddMessage(job_num)      # Define mxd, df and lyr objects     mxd = arcpy.mapping.MapDocument("CURRENT")     df = arcpy.mapping.ListDataFrames(mxd, df_name)[0]     lyr = arcpy.mapping.ListLayers(mxd, layer_name, df)[0]      arcpy.AddMessage(lyr.name)      # Create where clause for selection     query = "Job_Num = '%s'" % (job_num)      arcpy.AddMessage(query)      arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", query)      # Get number of selected features     selection = int(arcpy.GetCount_management(layer_name).getOutput(0))      arcpy.AddMessage("%s features selected" % (selection))      # Set df extent to layer selection     df.extent = lyr.getSelectedExtent()     arcpy.RefreshActiveView()      arcpy.AddMessage("Completed")  main()

MathewCoyle

I am trying to create a simple tool to collect user input and zoom to selected feature. ideally would like to select from fc in toc. Any suggestions?

import arcpy

def main():
    arcpy.AddMessage("Starting")

    # Get and set variables
    job_num = arcpy.GetParameterAsText(0)
    layer_name = "tax_acct"
    df_name = "Layers"

    arcpy.AddMessage(job_num)

    # Define mxd, df and lyr objects
    mxd = arcpy.mapping.MapDocument("CURRENT")
    df = arcpy.mapping.ListDataFrames(mxd, df_name)[0]
    lyr = arcpy.mapping.ListLayers(mxd, layer_name, df)[0]

    arcpy.AddMessage(lyr.name)

    # Create where clause for selection
    query = "Job_Num = '%s'" % (job_num)

    arcpy.AddMessage(query)

    arcpy.SelectLayerByAttribute_management(lyr, "NEW_SELECTION", query)

    # Get number of selected features
    selection = int(arcpy.GetCount_management(layer_name).getOutput(0))

    arcpy.AddMessage("%s features selected" % (selection))

    # Set df extent to layer selection
    df.extent = lyr.getSelectedExtent()
    arcpy.RefreshActiveView()

    arcpy.AddMessage("Completed")

main()

NoahHuntington

That is because you create a temporary layer called "layer" that you are basing your selections on. I don't see that layer in your TOC.

Maybe you should describe what you want to accomplish since it looks like you are going about this the wrong way.

I am trying to create a simple tool to collect user input and zoom to selected feature. ideally would like to select from fc in toc. Any suggestions?

...maybe a search cursor?

MathewCoyle

[ATTACH=CONFIG]17579[/ATTACH]

I can see 1 selected in results window but still no effect on dataframe? See attached...

That is because you create a temporary layer called "layer" that you are basing your selections on. I don't see that layer in your TOC.

Maybe you should describe what you want to accomplish since it looks like you are going about this the wrong way.

NoahHuntington

[ATTACH=CONFIG]17579[/ATTACH]

Try adding these lines at the end of your script. This will print how many features are selected, and then refresh the view to make those selections visible.
selection = int(arcpy.GetCount_management("layer").getOutput(0))
arcpy.AddMessage("%s features selected" % (selection))
arcpy.RefreshActiveView()

I can see 1 selected in results window but still no effect on dataframe? See attached...

Script_Results.JPG

NoahHuntington

Try adding these lines at the end of your script. This will print how many features are selected, and then refresh the view to make those selections visible.
selection = int(arcpy.GetCount_management("layer").getOutput(0))
arcpy.AddMessage("%s features selected" % (selection))
arcpy.RefreshActiveView()

I can see 1 selected in results window but still no effect on dataframe? See attached...

MathewCoyle

Try adding these lines at the end of your script. This will print how many features are selected, and then refresh the view to make those selections visible.

selection = int(arcpy.GetCount_management("layer").getOutput(0))
arcpy.AddMessage("%s features selected" % (selection))
arcpy.RefreshActiveView()

NoahHuntington

This should work. You may need to add quotes around your field name, or use the add field delimiters tool to create them for dynamic data sources.

# Model selects parcel from user input
import arcpy

# Assign variable to the feature class
featureClass = "G:\\PRAD\\PRAD_v10.1.gdb\\tax_acct"

# Assign variable to users input
input = arcpy.GetParameterAsText(0)

# Make a feature layer from feature class
arcpy.MakeFeatureLayer_management(featureClass, "layer")

# Build selection query
query = "Job_Num = '%s'" % (input)  # May need change to "\"Job_Num\" = '%s'"

# Apply a selection to the feature layer
arcpy.SelectLayerByAttribute_management("layer", "NEW_SELECTION", query)

This runs without error but nothing gets selected? I have tested with attributes in the Job_Num field that I have checked to exist. What do you think? Thanks again.

MathewCoyle

This should work. You may need to add quotes around your field name, or use the add field delimiters tool to create them for dynamic data sources.

# Model selects parcel from user input
import arcpy

# Assign variable to the feature class
featureClass = "G:\\PRAD\\PRAD_v10.1.gdb\\tax_acct"

# Assign variable to users input
input = arcpy.GetParameterAsText(0)

# Make a feature layer from feature class
arcpy.MakeFeatureLayer_management(featureClass, "layer")

# Build selection query
query = "Job_Num = '%s'" % (input)  # May need change to "\"Job_Num\" = '%s'"

# Apply a selection to the feature layer
arcpy.SelectLayerByAttribute_management("layer", "NEW_SELECTION", query)

NoahHuntington

Depending on your data type it could look something like this.
input = "\"CITY_NAME\" = 'Chicago'"
You can see more examples here.
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001700000071000000

Right. I can see now that something is missing. What does the syntax look like for whereclause when field name is Job_Num and variable is input. Similar to...

..."Job_Num = " + str(input))

MathewCoyle

Depending on your data type it could look something like this.

input = "\"CITY_NAME\" = 'Chicago'"

You can see more examples here.
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001700000071000000

NoahHuntington

You need to print out the actual value of the variable the tool is reading to make sure it is a valid query.

Sorry I must be slow. I am not sure I am following you. Can I see an example?

MathewCoyle

You need to print out the actual value of the variable the tool is reading to make sure it is a valid query.

NoahHuntington

The last line shouldn't be indented. Are you getting a syntax error or some other error? Also, what is the value of your input variable? Try using AddMessage to see if it is passing how you would expect it to.

The input is a 6 or 7 digit text field found in the feature class. The script is run as a tool where the input parameter is set to string. Here is what I currently have...

# Selects from user input in tool dialog.  

import arcpy

# Get the layer.
featureClass = "G:\\PRAD\\PRAD_v10.1.gdb\\tax_acct"
input = arcpy.GetParameterAsText(0)

try:
    # Make a feature layer from feature class
    arcpy.MakeFeatureLayer_management(featureClass, "layer")
    
    # Apply a selection to the feature layer
    arcpy.SelectLayerByAttribute_management("layer", "NEW_SELECTION", '"'+str(input)+'"')

except:
    print arcpy.GetMessages()

MathewCoyle

The last line shouldn't be indented. Are you getting a syntax error or some other error? Also, what is the value of your input variable? Try using AddMessage to see if it is passing how you would expect it to.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.