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 Layer by Attribute issues

ShelbyHines

Hi all,

I am trying to 1) Select by Attribute and 2) overwrite a feature class with selected features. Below is the script that I'm trying as a start.. and am getting an error related to Select by Attribute. Ultimately, need to select last 365 days of data (not Baker neighborhood) and overwrite a feature class.. on a daily basis. Thank you in advance for any assistance! Shelby

# Description: Extract features to a new feature class based on an attribute query
# Import system modules
import arcpy

# Make a layer from the feature class
arcpy.MakeFeatureLayer_management ("D:/pd/crimeD.gdb/dencrime", "crimelayer")

# Select all crimes that happened in Baker
arcpy.SelectLayerByAttribute_management ("crimelayer", "NEW_SELECTION", ' "NEIGHBORHOOD_ID" = baker ')
# Write the selected features to a new featureclass
arcpy.CopyFeatures_management("crimelayer", "Bakercrime")

Vind meer berichten getagd met

Accepted answers

XanderBakker

It is likely the query you are using. the value Baker should be between quotes and the field name (if FC is stored in fgdb) would be without quotes. Something like this:

arcpy.SelectLayerByAttribute_management ("crimelayer", "NEW_SELECTION", "NEIGHBORHOOD_ID = 'baker'")

Sorry no access to my computer at this time to verify a little more.

All comments

ShelbyHines

Thank you for this, will be testing this! Was able to make it work with the help of a colleague:

arcpy.SelectLayerByAttribute_management("crimelayer", "NEW_SELECTION", "REPORTED_DATE > timestamp '{0}'".format(str(year_ago)), None)

DanPatterson_Retired

<SPAN class="keyword token">import</SPAN> datetime

n <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>datetime<SPAN class="punctuation token">.</SPAN>now<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="comment token"># ---- now </SPAN>

t <SPAN class="operator token">=</SPAN> datetime<SPAN class="punctuation token">.</SPAN>timedelta<SPAN class="punctuation token">(</SPAN>days<SPAN class="operator token">=</SPAN><SPAN class="number token">365</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="comment token"># ---- used timedelta options </SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Now&nbsp; {} \nThen {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>n<SPAN class="punctuation token">,</SPAN> n<SPAN class="operator token">-</SPAN>t<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

Now&nbsp; <SPAN class="number token">2017</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">10</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">24</SPAN> <SPAN class="number token">15</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">05</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">40.710201</SPAN> 
Then <SPAN class="number token">2016</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">10</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">24</SPAN> <SPAN class="number token">15</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">05</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">40.710201</SPAN>

<SPAN class="comment token"># ---- see the help for working with arcpy time objects</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Shelby.... To give you some ideas

ShelbyHines

Hi Dan_Patterson, I wonder if you know how to query for data from the last 365 days using a date field? Thank you! -Shelby

ShelbyHines

Thank you Xander, this worked!

XanderBakker

It is likely the query you are using. the value Baker should be between quotes and the field name (if FC is stored in fgdb) would be without quotes. Something like this:

arcpy.SelectLayerByAttribute_management ("crimelayer", "NEW_SELECTION", "NEIGHBORHOOD_ID = 'baker'")

Sorry no access to my computer at this time to verify a little more.

ShelbyHines

Thank you Dan!

This is the error that I'm getting:

Traceback (most recent call last):
File "<string>", line 7, in <module>
File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 6569, in SelectLayerByAttribute
raise e
File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 6566, in SelectLayerByAttribute
retval = convertArcObjectToPythonObject(gp.SelectLayerByAttribute_management(*gp_fixargs((in_layer_or_view, selection_type, where_clause, invert_where_clause), True)))
File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\geoprocessing\_base.py", line 506, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 000358: Invalid expression
Failed to execute (SelectLayerByAttribute).

Regarding your other questions, the date is in a field and is "date" data type. Yes, they are sequential dates from 2010 through today. Hundreds per day.

Much appreciated, Shelby

DanPatterson_Retired

With the shell script what is the error just in case

there is an error in the script and more importantly
it wouldn't work in the first place because what you are querying doesn't exist

Secondly...

how is the time data stored?
is it in a field?
sequential values?
is it a date field or a string field?

More questions pending the answers to the above.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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