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 by Attributes and append

2Quiker

I am trying to update a feature class with points that have "Active" in the "Status" field.

I have tried "Status LIKE 'Active%'" & "\"Status\" LIKE 'Active%'" for the query but no matter what it appends all of the points.

fc2 = "sde\\blah\\UpdatePoints"
arcpy.DeleteFeatures_management(fc2)

#Output = "UpdatePoints1"
CCAP = "sde\\points\\Points1"

arcpy.MakeFeatureLayer_management(CCAP, "CCAP1_lyr")
arcpy.SelectLayerByAttribute_management("CCAP1_lyr", "NEW_SELECTION", "Status LIKE 'Active%'") #"\"Status\" LIKE 'Active%'"

arcpy.Append_management("CCAP1_lyr", "sde\\blah\\UpdatePoints", "NO_TEST")

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

jskinner

You could remove the selection all together and apply the query when creating the Feature Layer. Ex:

fc2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"sde\\blah\\UpdatePoints"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>DeleteFeatures_management<SPAN class="punctuation token">(</SPAN>fc2<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Output = "UpdatePoints1"</SPAN>
CCAP <SPAN class="operator token">=</SPAN> <SPAN class="string token">"sde\\points\\Points1"</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>CCAP<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CCAP1_lyr"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Status LIKE 'Active%'"</SPAN><SPAN class="punctuation token">)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>Append_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"CCAP1_lyr"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"sde\\blah\\UpdatePoints"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_TEST"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Also, you make want to execute the Make Feature Layer in ArcGIS Pro to make sure the query is correct. You can then copy the python command from the History tab.

All comments

2Quiker

that worked thanks.

bixb0012

I am surprised you aren't getting an error because your SQL syntax is not valid, i.e., text expressions with wildcards are not supported with the IN operator. Given your level of SQL knowledge, the best approach is chaining together some LIKE statements:

where_clause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Status LIKE 'Active%' OR Status LIKE 'Existing%'"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>CCAP<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CCAP1_lyr"</SPAN><SPAN class="punctuation token">,</SPAN> where_clause<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

 

2Quiker

I wanted to do select multiple values and tried the following but it seems like it just selects "Active" ones.

I need to select "Active" & "Existing",

fc2 = "sde\\blah\\UpdatePoints"
arcpy.DeleteFeatures_management(fc2)

#Output = "UpdatePoints1"
CCAP = "sde\\points\\Points1"

where_clause = "Status IN ('Active%','Existing%')"
arcpy.MakeFeatureLayer_management(CCAP, "CCAP1_lyr", where_clause)

arcpy.Append_management("CCAP1_lyr", "sde\\blah\\UpdatePoints", "NO_TEST")<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

jskinner

You could remove the selection all together and apply the query when creating the Feature Layer. Ex:

fc2 <SPAN class="operator token">=</SPAN> <SPAN class="string token">"sde\\blah\\UpdatePoints"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>DeleteFeatures_management<SPAN class="punctuation token">(</SPAN>fc2<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Output = "UpdatePoints1"</SPAN>
CCAP <SPAN class="operator token">=</SPAN> <SPAN class="string token">"sde\\points\\Points1"</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>CCAP<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CCAP1_lyr"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Status LIKE 'Active%'"</SPAN><SPAN class="punctuation token">)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>Append_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"CCAP1_lyr"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"sde\\blah\\UpdatePoints"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NO_TEST"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Also, you make want to execute the Make Feature Layer in ArcGIS Pro to make sure the query is correct. You can then copy the python command from the History tab.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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