Skip to main content
Question

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

  • March 16, 2023
  • 3 replies
  • 20 views

reservoirdog
Supporter
Forum|alt.badge.img+12

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
Celebrity
  • 8391 replies
  • 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+12
  • Author
  • Supporter
  • 37 replies
  • 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
  • 1891 replies
  • March 22, 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

@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.