Skip to main content
Question

Select records from fileGDB?

  • September 23, 2025
  • 2 replies
  • 34 views

nicholas
Contributor
Forum|alt.badge.img+14

I have a fileGDB with many records, of which I only want to read a Selection.

I know how to use the Search Envelope to select records in a bounding box

Is there also a way of Selecting records where an Attribute equals a value? (actually one of three values)

Or is the only way with a Transformer after the Reader?

Just trying to optimise

2 replies

ctredinnick
Supporter
Forum|alt.badge.img+19
  • Supporter
  • September 23, 2025

Yes, read the data with a FeatureReader. Although note the WHERE Clause is only available with the licensed format “Esri Geodatabase (File Geodb)”, not with the “Esri Geodatabase (File Geodb Open API)”

Then, the where clause you make is just simple SQL, eg:     GDBAttribute in (‘value1’,’value2’,’value3’)


redgeographics
Celebrity
Forum|alt.badge.img+61

Actually, there’s a Where clause option in the OpenAPI version of the reader too, in the feature type parameters.