topic Optimum/best way to extract column data into a list? in ArcGIS Pro SDK Questions

Optimum/best way to extract column data into a list?

GyanendraGurung — Wed, 05 Feb 2020 20:33:29 GMT

Hi everyone,

I want to extract all the rows of a specific field in a given table. This is how I am doing it.

List<UInt32> outputList= new List<UInt32>();
// Query table
await QueuedTask.Run(() => {
using (Geodatabase curGDB = new Geodatabase(new FileGeodatabaseConnectionPath(new Uri(selectedGDB))))
using (Table table = curGDB.OpenDataset<Table>(selectedTable))
{
QueryFilter qF = new QueryFilter
{
WhereClause = "OBJECTID > 0"
};
using (RowCursor rc = table.Search(qF, false))
{
while (rc.MoveNext())
{
using (Row row = rc.Current)
{
outputList.Add(Convert.ToUInt32(row[selectedField]));
}
}
}
}
});

My questions is: Is this a good way? Do I have to use "QueryFilter" and move through each row? Is there a better/optimum way?

Many thanks in advance.

Re: Optimum/best way to extract column data into a list?

RichRuh — Wed, 05 Feb 2020 20:43:28 GMT

Yes, this is the best way. I would recommend the following small changes.

Remove the WhereClause (which isn't really doing anything, since ObjectIDs should always be greater than zero)
Use the Subfields property to reduce the amount of data being read from the database
On the call to Table.Search, set the useRecyclingCursor property to True

--Rich

Re: Optimum/best way to extract column data into a list?

GyanendraGurung — Thu, 06 Feb 2020 16:01:53 GMT

Hi Rich,

Thank you very much for your kind and prompt reply. I will try to use the Subfields property and optimize my code. I shall post it as soon as I get time to code it.

- Kenny