Skip to main content
Question

Query ArcGIS feature service by using bounding box in where clause

  • July 17, 2023
  • 1 reply
  • 108 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+64
  • 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

Community Stats

32,129
Posts
121,967
Replies
39,779
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.