Geoprocessing Error Python

Question

I am working on a project for school and I am trying to create new layers from an existing shp based on attributes. The problem I am having now is that the select by attributes is not actually selecting the appropriate items and exports a layer with the same amount of points as the first layer. I have double and triple checked I have the correct spelling of the data field and attributes. I have also used numerous other methods of creating the expression which return an invalid expression error.

The first screenshot is the error I get with an improper syntax for the SQL query. The second screenshot is the result of the code with a "working" syntax but it creates a new layer with a new name but is otherwise the exact same. Finally, the third screenshot is the csv used as the input.

1.png

2.png

3.png

ForrestLin_3-1723144552389.png

SubLayer.png

Clip_735.jpg

RhettZufelt · Accepted Answer

Instead of the select by attribute, try using a make feature layer with where clause, then copy the feature layer to a new fc.

Might also try adding something like int(arcpy.GetCount_management(out_lyr).getOutput(0)) right after the select by atts and see how many are actually being selected.

R_

JacobSpear1 · Accepted Answer

This worked! I completely ignored the select line of code and used feature class to feature class with the above suggestion for the SQL expression and got the intended result!

Below is the line of code that worked. I simply changed the variables for each item as necessary

arcpy.conversion.FeatureClassToFeatureClass(out_lyr, "", lived, "DES = 'lived'")