Latest Contributions by ColinZwicker

I have been told that making a list unique is relatively painless in python ids = [1, 2, 3, 4, 1, 5, 6, 1, 2, 3] >>> sorted(set(ids)) [1, 2, 3, 4, 5, 6] ... View more

Fengchao, Instead of building a large OR list for your linkID's  where += ' OR "LINK_ID" = {0}'.format(int(linkid)) Can you try making the whereclause in the form of an in list?, e.g., IN (ID1, ID2, ID3, N)?  Ideally this IN clause would contain no duplicated ID's (so perhaps collect them in a list and then only add the unique values). re: "I have tried to increase the size of virtual memory to 100GB. But unfortunately, I still get the same crash error. So it seems that because of the script itself. " As the thread has somewhat devised this issue isnt about heap memory but about stack memory and the usage of that stack while attempting to parse a whereclause with a growing number of logical operators. Thanks, Colin ... View more

Good timing With the release of 2.2 check out: ProConcepts Geodatabase · Esri/arcgis-pro-sdk Wiki · GitHub  Edit: totally missed your unique value statement, let me check with the team. Thanks, Colin ... View more

Brian, ArcGIS Pro Core.Data has not exposed this functionality yet. We will look to do so in a future release. Do you utilize the simple stats (count, min\max etc) or standard deviation? Thanks, Colin ... View more

Fabian, This is a current limitation of the api, and will be addressed in the next release. The result will be a pattern to generate a DatabaseConnectionProperties directly from a DatabaseConnecitonFile without requiring that the Geodatabase is opened. Thank you for your question! Colin ... View more

Tyler, I have logged your request with the team, who hope to provide this in an up coming release of ArcGIS Pro. Thanks, Colin ... View more

Tyler, Would you be able to expand on your use case for requiring the ObjectClassID? Thanks, Colin ... View more

Max max, Grouping client side, of via a table sort pattern is not currently in our backlog for a future release. However that is not to say it couldn't be added and prioritized accordingly. Would you be able to email me your thoughts on a pattern? Thanks, Colin ... View more

Max Max, We will be working on adding the ability to request a sorted rowCursor from a table in a future release of ArcGIS Pro. (similar to the functionality supported by ITableSort2) Thanks, Colin ... View more

Andres, The QueryFilter can be created on a non-MCT thread, its the call to Search that needs to be on the MCT thread. The issue we will investigate internally is why you did not receive the expected “CalledOnWrongThreadException” but instead received an null row cursor. Colin ... View more

Andres, What happens if you execute the two cursors from the same function? *pseudo code* await QueuedTask.Run(() =>                 { SelectedLayer = MapView.Active.Map.FindLayers(layerFileName, true).FirstOrDefault() as FeatureLayer;                           var queryFilter = new QueryFilter();                         queryFilter.PostfixClause = "ORDER BY " + layerField;                        //Query 1                         var rc = SelectedLayer.Search(queryFilter);                       //yeah we have fields!                       queryFilter = new QueryFilter();                       queryFilter.WhereClause = layerField + " LIKE '%" + NamePart + "%'"; }                      queryFilter.PostfixClause = "ORDER BY " + layerField;                      //Query 2                     RowCursor rc2 = SelectedLayer.Search(queryFilter); // <- returns ?                      ... I noticed you were missing a QueuedTask.Run in your second function, if that was true I would have expected to have returned an error (not a null RowCursor), I therefore assumed this was a typo in posting the example. Colin ... View more

Andres, Would you be able to provide a snippet of your code (including initial search, and secondary filter attempt)? Also against which datastore are you executing the search (if it is an enterprise geodatabase, which dbms?) Thanks, Colin ... View more