Skip to main content

Hi,

I am trying to put query where clause in feature reader. the reader data is from esri Portal Feature Serice. I would like to put bounding envelop into where clause. I am not sure what is the clause should be. I would not like to query them all then do intersect. i would only like to query everything in the box I defined.

the clause i am using somehting like:geometryType=esriGeometryEnvelope&geometry=1.6407885025300004E7,-4272238.302200001,1.6703666006300002E7,-4088621.626699999. it didn't work

image.pngI would like to know:

  1. where clause support extent clasue
  2. if so what is the correct the clause structure.

 

Thank you very much.

The WHERE clause is basically a simple SQL attribute WHERE statement e.g.

name="Hamish" and ID=1234

What you want to use is the Spatial Filter. This works by have a geometry on your initiator feature then setting the Spatial Filter attribute in the feature reader. You'd use your bounding box to create a geometry before the FeatureReader and then the set the FeatureReader to have the Spatial Filter you're after


Reply