Latest Contributions by ChuckBenton

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

So simple!  Thanks!! ... 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

Progress: I needed to refer to TOT_VALUE inside quotes.  But now it says the expression is invalid. 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 Failed to execute (SelectLayerByAttribute). I thought that maybe the "WHERE" was not needed, tried it without that, same result. ... View more

Josh,  Thanks.  I've tried: arcpy.SelectLayerByAttribute_management("PAAG_-_Feature_Layer\PAAG_-_Feature_Layer", "NEW_SELECTION", "WHERE CAST (TOT_VALUE as INTEGER) > 500000"") but get Parsing error SyntaxError: EOL while scanning string literal (<string>, line 1). I started with the layer not in quotes (which is how I think it should be)... same error. Suggestion as to what I'm doing wrong? Chuck ... View more

Yep, but it needs to be viable in the ArcGIS Pro Select by Attribute SQL Expression Window. ... View more

One would think so but I still get an error Curiously, if I drop the WHERE, I get a different error. In both cases the fact that 500000 is in red is a flag.  I've tried smaller numbers, decimal points, etc. without success. ... View more

Yep... just gets an syntax error.... ... View more

I'm seeing similar issues with timeouts when appending or deleting content from a feature layer that's hosted on ArcGIS Online.  While not 100% consistent, it only happens with large files.  The feature layer I'm working with is quite large, over 40M parcels, so the work being performed takes a while, which is to be expected and acceptable.  I've looked for a timeout value that I can set to accommodate this without luck. Any suggestions are most welcome! ... View more

Thanks!  That certainly resolved the mystery!   Of course it opens a new question... I see that I need to have the layer shared publicly.  I would like to limit to a specific group, any suggestions? ... View more