Hi ThinkGeo,
I am using InMemoryFeatureLayer to denote point features.
Is there any method in QueryTools to satisfy multiple conditions (AND.. OR) for column values ?
Currently I have to use GetFeaturesByColumnValue() couple of times to combine result.
Regards,
Anil
Hi Anil,
For InMemoryFeatureLayer I think we don’t have other function for implement your requirement.
You can GetAllFeatures and implement your own search logic for that, but I think that should more copmlex than call GetFeaturesByColumnValue() twice.
If you want to use ShapeFileFeatureLayer, you can try this function: QueryTools.ExecuteQuery
Here we have a post discuss that:
gis.thinkgeo.com/Support/DiscussionForums/tabid/143/afv/topic/aff/21/aft/6946/afpg/2/Default.aspx
Regards,
Don
Anil,
I am having the same problem, I have to use GetFeatureByColumnValue multiple times to get all the features I want into the same layer. It is really slow to run the query multiple times. I'll let you know if I figure anything out, and I would love to hear about any solutions you have found, please post!!
Thanks,
Eric
Eric,
One solution to this conundrum is to put all properties in a separate SQL table linked to the shp file via an ID field. Then you do two queries, one to retrieve the ID(s) using GetFeatureByColumnValue, the other to the SQL table to retrieve the properties of interest for the selected IDs.
Al Vigil
I was just heading in that direction, thanks!
Thank you very much Al, Eric, if you still meet problem, feel free to tell us.
Regards,
Gary
Can’t you use a simple sql to fetch the Ids using odbc visual fox pro drivers?
Hello Rui,
Sorry I’m not sure visual fox pro supports spatial index, we didn’t test that.
Regards,
Gary