append featuresets into one featureset
I need to loop through a list of attributes, use each item in a where clause, then append all the resultant featuresets into a single featueset. Is there a way to do this in a workflow?
-
Do you need to create different feature sets, or could you build the where clause to select all the records you need into a single feature set?
0 -
I need to create a single feature set from multiple queries based on a list of attributes in a field. right now i can loop through my selection list and create the graphics for that selection, then append them all into a single graphics collection the select features one at a time. the problem is that is the selection list of features is very long, my server chokes on all the requests (i think, the workflow completes in the simulator) and its too slow. i would like to be able to select featues via list in a query, so i would not have to hit the server many many times in a row, but submit a list of items to inumerate through. Or be able to run a subquery such as select items from my mapserver where keyfield1 in (select keyfield2 from mydatatable)
another solution might be to create and confiture a searchtable on the fly, or modify an existing search tables parameters. Is that possible.
but i would need to change the name of the table for each session becuase is a multi-user at a time website.
So i need some advice here. on the best way to select features via a long selection list or table.
Jeff
0 -
I generally try to avoid appending large feature sets because of how long it takes. Instead, I use the ParallelForEach activity to loop through the feature set and build a where clause (string). Then I just combine all of the where clauses and use them in a Query Task to select and create a new feature set (e.g. whereclause1 & "AND" & whereclause2 & ... whereclausen).
I'm still underwhelemed by the speed at which the query executes, but it's a vast improvement from appending feature sets.
0 -
can you put up a sample workflow of that?
0
Please sign in to leave a comment.
Comments
4 comments