topic Feature Table OBjectID in .NET Maps SDK Questions

Feature Table OBjectID

robymun — Mon, 12 Dec 2022 15:57:33 GMT

Hello i have very big tables and on them i have to do intersection operation between graphics, example i have to find relations between sections and valves, in the old version 10.x.x there was the possibility to return only objectID as the return field of the query, this saved a lot of time and a lot of memory...example now i have read it via attributes (this table has more than 40 fields )... In version 100 there is no way to have only ObjectID as a return field on a Featuretable ?

Regards Roberto

Re: Feature Table OBjectID

JoeHershman — Mon, 12 Dec 2022 16:31:53 GMT

Look at Enum QueryFeatureFields this should allow you to set to return IdsOnly

Re: Feature Table OBjectID

robymun — Mon, 12 Dec 2022 16:42:48 GMT

Unfortunately, this solution is not good for a FeatureTable but only for ArcGISFeatures , I don't understand why there is no possibility to pass this QueryFeatureFields parameter in geodatabase queries

Re: Feature Table OBjectID

dotMorten_esri — Tue, 13 Dec 2022 17:21:54 GMT

Is your FeatureTable not of type ServiceFeatureTable? (ie can you cast it to this subclass?)
If it's a local non-service table, limiting the attributes doesn't have much effect, since you're not hitting the network.

Re: Feature Table OBjectID

robymun — Thu, 29 Dec 2022 10:59:25 GMT

@dotMorten_esri wrote:
Is your FeatureTable not of type ServiceFeatureTable? (ie can you cast it to this subclass?)
If it's a local non-service table, limiting the attributes doesn't have much effect, since you're not hitting the network.

Hi, i can't cast GeodataBaseFeatureTable into a ServiceFeatureTable 😥

I did some comparisons , in the old version 10.x there was on ios the following type of query

AGSQuery* queryIds = [AGSQuery query];
queryIds.geometry = geometryToIntersec;
queryIds.returnGeometry = false;
queryIds.spatialRelationship = AGSSpatialRelationshipIntersects;
[featureTable queryObjectIDsWithParameters:queryIds completion:^(NSArray *results, NSError *error)

this type of query returned only an array of objectIds which is what I need and it was super fast (I tested and the query runs in only 0.000320 milli seconds)

while now using a similar query in the 100.x version that however returns me all the data in the featureTable row takes us from 2-3 milliseconds ...this repeatedly executed thousands of times makes the time taken to run the algorithm we are developing grow exponentially. Below is the example of the query executed now

var param = new QueryParameters() { Geometry = geometryToIntersec, ReturnGeometry = false, SpatialRelationship = SpatialRelationship.Intersects };
var results = (await featureTable.QueryFeaturesAsync(param).ConfigureAwait(false)).ToList();