https://community.esri.com/t5/python-questions/multiple-definition-query-for-multiple-layers/m-p/1397036#M70072 <P>I need to write python code to apply definition query for all layers at once, i already tried some code which i insert it below but it makes a new layers&nbsp;</P><LI-CODE lang="python"># Set the workspace (change to your desired geodatabase or folder) arcpy.env.workspace = r"D:\abo-ammar\geoParcel.gdb" # List of feature classes (change to your desired feature class names) feature_classes = ["parcels_corner", "parcels_dimension", "LINE_AMLAK", "Parcels"] # Define the common query expression (change to your desired query) query_expression = "parcel_no = 2" # Loop through each feature class and apply the definition query for feature_class in feature_classes: # Get the existing layer layer = arcpy.management.MakeFeatureLayer(feature_class, f"{feature_class}_Layer", query_expression) print(f"Definition query applied to {feature_class}.") # Print a success message print("Definition queries applied to all specified feature classes.")</LI-CODE><P>&nbsp;</P><P>i want to know how to apply the same code but over the current layers not with generation of a copy of each layer</P> Sun, 17 Mar 2024 11:47:55 GMT marklee1869 2024-03-17T11:47:55Z https://community.esri.com/t5/python-questions/multiple-definition-query-for-multiple-layers/m-p/1397036#M70072 <P>I need to write python code to apply definition query for all layers at once, i already tried some code which i insert it below but it makes a new layers&nbsp;</P><LI-CODE lang="python"># Set the workspace (change to your desired geodatabase or folder) arcpy.env.workspace = r"D:\abo-ammar\geoParcel.gdb" # List of feature classes (change to your desired feature class names) feature_classes = ["parcels_corner", "parcels_dimension", "LINE_AMLAK", "Parcels"] # Define the common query expression (change to your desired query) query_expression = "parcel_no = 2" # Loop through each feature class and apply the definition query for feature_class in feature_classes: # Get the existing layer layer = arcpy.management.MakeFeatureLayer(feature_class, f"{feature_class}_Layer", query_expression) print(f"Definition query applied to {feature_class}.") # Print a success message print("Definition queries applied to all specified feature classes.")</LI-CODE><P>&nbsp;</P><P>i want to know how to apply the same code but over the current layers not with generation of a copy of each layer</P> Sun, 17 Mar 2024 11:47:55 GMT https://community.esri.com/t5/python-questions/multiple-definition-query-for-multiple-layers/m-p/1397036#M70072 marklee1869 2024-03-17T11:47:55Z https://community.esri.com/t5/python-questions/multiple-definition-query-for-multiple-layers/m-p/1397162#M70074 <P>Dear marklee,</P><P>I hope you are doing well,</P><P>&nbsp;</P><P>you just need to delete the "_layer" from your second element in the arcpy.management.MakeFeatureLayer function.</P><P># Set the workspace (change to your desired geodatabase or folder)<BR />arcpy.env.workspace = r"D:\abo-ammar\geoParcel.gdb"</P><P><BR /># List of feature classes (change to your desired feature class names)<BR />feature_classes = ["parcels_corner", "parcels_dimension", "LINE_AMLAK", "Parcels"]</P><P><BR /># Define the common query expression (change to your desired query)<BR />query_expression = "parcel_no = 2"</P><P><BR /># Loop through each feature class and apply the definition query<BR />for feature_class in feature_classes:<BR /># Get the existing layer<BR />layer = arcpy.management.MakeFeatureLayer(feature_class, f"{feature_class}", query_expression)<BR />print(f"Definition query applied to {feature_class}.")</P><P><BR /># Print a success message<BR />print("Definition queries applied to all specified feature classes.")<BR /><BR />Good luck</P> Mon, 18 Mar 2024 11:04:19 GMT https://community.esri.com/t5/python-questions/multiple-definition-query-for-multiple-layers/m-p/1397162#M70074 Amir-Sarrafzadeh-Arasi 2024-03-18T11:04:19Z