• Home
  • Forums
  • FME Form
  • Data
  • What is the best way to add a whereclause query to an ArcSDE layer and extract to ESRI shapefile?
Question

What is the best way to add a whereclause query to an ArcSDE layer and extract to ESRI shapefile?

  • 4 February 2022
  • 1 reply
  • 1 view
M

I have tried reading out to a file geodatabase and then reading that out with the where clause to shapefile but would like to try something more direct

1 reply

hkingsbury
Rank
Userlevel 5
Badge +29

In the reader you can specify a WHERE clause (SDE/GDB) The GDB API reader doesn't have a WHERE statement.

Alternately you can read in all the data and use a Tester with your WHERE clause in it

Check out the Abley FME Firesides on Youtube: https://www.youtube.com/@ableyltd

Reply


Community Stats

28,729
Posts
109,527
Replies
36,565
Members
Terms & ConditionsCookie 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.