Skip to main content
Question

SQL definiton conversion from ArcPro to FME

  • May 29, 2026
  • 0 replies
  • 9 views

marta.podsiad
Supporter
Forum|alt.badge.img+10

Hi,

I have a file geodatabase (.gdb) containing feature classes, along with an Excel file that includes ArcGIS Pro SQL definition queries intended for specific feature classes.

Example:

 

gdb with feature classes

 

ArcPro definition query

Schema = '1' And Rodzaj NOT LIKE '%B%'

 

I’d like to understand how I can automatically convert these ArcGIS Pro SQL queries into FME SQL syntax. The queries will vary each time and are tailored to individual feature classes.

 

This SQL works in FeatureReader but it requires a lot of manual work