Latest Contributions by ChuckBenton

Richard, Thanks for the insights.  This is coming from a shapefile that was used to create the feature layer I'm working with. I have escalated this to an ESRI support request, still getting things sorted out. Chuck ... View more

I've escalated this to a formal ESRI support request.  I'll post the results!  ... View more

It has worked on smaller datasets in the past.  However, I just tried it with this dataset and it did not work.  I was able to limit the search to a previous selection that was bounded by a rectangle, giving a fast processing time.  However, I also change the test to "STATE"="MA", which should return all the parcels in the previous selection, and I get nothing.  So I suspect its a more fundamental issue.   This content is coming in from AGOL, whereas before it came from a standalone ArcGIS Server.  I'm starting to wonder if that's part of the issue here. I'm thinking I need to focus on the "STATE"="MA" issue first, before chasing the text vs. int issue. All that said... I do see everything I should when I do an identify... ... View more

In the other thread it was suggested I use "Select from Current Selection", which makes sense.  In this case, I've substituted "SUBSET_SELECTION" for "NEW_SELECTION", and made a rectangular selection of a small area before running the script.  Same sort of delay, but I didn't see the Code 504 error. ... View more

Thanks again.  I have a new error now, see below:  arcpy.SelectLayerByAttribute_management("PAAG_-_Feature_Layer\PAAG_-_Feature_Layer", "NEW_SELECTION", "WHERE CAST (TOT_VALUE as INTEGER) > 500000") Runtime error Traceback (most recent call last): File "<string>", line 1, in <module> File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 6314, in SelectLayerByAttribute raise e File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 6311, 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 ERROR: code:504, Your request has timed out., Proxy server got bad address from remote server (verify the server is running). Failed to execute (SelectLayerByAttribute). While I still have an "Invalid Expression" error, I also now have a time out.  I think this may be because I'm querying a huge (100+M records) layer.  I'm also trying to figure out how to limit my query to only the visible extent of the map.  I started another request here: https://community.esri.com/message/790143-arcgis-pro-how-to-limit-select-by-attribute-to-the-visible-extent  Thoughts? ... View more

Its a text field, as are all the user defined fields in this layer.  Thats how the content provider has formatted this data for years. ... View more