Skip to main content
Question

How to read Esri FileGDB without Feature Class "names" / schema-prefix


reservoirdog
Supporter
Forum|alt.badge.img+10

I have several Feature Classes in a FileGDB and would like to convert these into a Geopackage. Therefore I would like to remove/not read the different schema-names / Schema-prefixes.

A Feature Class "WAS_LABEL/WAST_TEXT" would be read as "WAST_TEXT" without the schema-name/prefix.

Is there an easy way to achieve that?

The FeautureClass-Names in the geopackage need to be "flat" without schemanames...

image.png

3 replies

david_r
Evangelist
  • March 16, 2023

One solution could be to use a StringReplacer with the following regular expression, replacing it with an empty string:

^.+/

 


reservoirdog
Supporter
Forum|alt.badge.img+10
  • Author
  • Supporter
  • March 16, 2023

Thanks David,

preferable would be a checkbox at the Reader like at the "SQLite" Reader "remove table qualifier", but I guess there's not such an option. Using your method, I would need to manually change each feature type one by another, or can it be done using a feauture reader and then the Stringreplacer on the featuretypename attirbute?

image


Forum|alt.badge.img+2
reservoirdog wrote:

Thanks David,

preferable would be a checkbox at the Reader like at the "SQLite" Reader "remove table qualifier", but I guess there's not such an option. Using your method, I would need to manually change each feature type one by another, or can it be done using a feauture reader and then the Stringreplacer on the featuretypename attirbute?

image

@reservoirdog​ FME doesn't really treat the feature dataset as a table qualifier. If you can use the File Geodatabase (ArcObjects) reader then the feature dataset is handled slightly differently.


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