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; } } }

parameter in arcpy

jayasudha

I am trying to create python script tool which takes parameter.

x = arcpy.GetParameterAsText(0)

arcpy.MakeFeatureLayer_management("C:/test.gdb/cities","cities_lyr", """ "STATE_NAME" = 'Idaho' """)

How to pass value of x variable for STATE_NAME instead of constant value 'Idaho' ?

Trouver plus de publications taguées avec

Accepted answers

AndrewKeith3

arcpy.MakeFeatureLayer_management("C:/test.gdb/cities","cities_lyr", """ "STATE_NAME" = '{0}' """.format(x))

All comments

jayasudha

Thanks to all for your suggestions.

DavidWasserman

I would also consider using the "Add Field Delimiters" function. It makes sure you have appropriate delimiters for your SQL queries.

AddFieldDelimiters—ArcPy Functions | ArcGIS for Desktop
Example:
GeodesignToolkit-GIS-CityEngine-Integration-Tools/SplitFeaturebyAttribute.py at master · Holisticnature/GeodesignToolkit…

def constructSQLEqualityQuery(fieldName, value, dataSource):
    # Creates a workspace sensitive equality query to be used in arcpy.
    return "{0} = '{1}'".format(arcpy.AddFieldDelimiters(dataSource, fieldName), str(value))

AndrewKeith3

arcpy.MakeFeatureLayer_management("C:/test.gdb/cities","cities_lyr", """ "STATE_NAME" = '{0}' """.format(x))

DanPatterson_Retired

state_name = arcpy.GetParameterAsText(1) # just get the sql query formulated correctly or define this parameter as an SQL in the tool in the parameter type

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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