Skip to main content
Question

Query ArcGIS feature service by using bounding box in where clause

  • July 17, 2023
  • 1 reply
  • 86 views
lhcamm
Contributor
Forum|alt.badge.img+2

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.

1 reply

hkingsbury
Celebrity
Forum|alt.badge.img+54
  • hkingsburyCelebrity
  • Celebrity
  • July 17, 2023

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


Helpful Members This Week

Community Stats

31,341
Posts
118,856
Replies
38,930
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.