Skip to main content
Question

How can I extract the attributes from gdb file

  • November 29, 2022
  • 5 replies
  • 193 views

Forum|alt.badge.img

Hello Sir / Madam,

 

I have a gdb file that have several layers. I am just wondering how can I extract all attributes from the layers?

 

I tried "Schema" reader and list exploder to explode the data. However, I only able to get one table attributes. May I ask how can I extract all attributes from all layers? I have attached a sample data in here.

 

Hope someone can give me a hand. Thank you!

 

Thank you in advance.

5 replies

redgeographics
Celebrity
Forum|alt.badge.img+59
  • Celebrity
  • 3699 replies
  • November 29, 2022

The Schema reader should create one feature per table, can you check whether that's the case?


Forum|alt.badge.img
  • Author
  • 53 replies
  • November 30, 2022

The Schema reader should create one feature per table, can you check whether that's the case?

Hi, I am not sure what's wrong with my settings. I have attached the capture screen here. Could you please take a look at my setting, if possible.

The arrow pointed in ArcMap is the only table attributes that I can extract from. However, I would like to extract the other four attributes name as well (WallSurface_surface, Building_surface, etc).

 

Thank you very much.


redgeographics
Celebrity
Forum|alt.badge.img+59
  • Celebrity
  • 3699 replies
  • November 30, 2022

It looks like the other tables are an unsupported geometry type and therefore FME skips them:

FileGDB Reader: Feature class 'Building_surface' has shape type 'esriGeometryMultiPatch' which is unknown to FME. Skipping feature class

 

 


Forum|alt.badge.img
  • Author
  • 53 replies
  • December 15, 2022

It looks like the other tables are an unsupported geometry type and therefore FME skips them:

FileGDB Reader: Feature class 'Building_surface' has shape type 'esriGeometryMultiPatch' which is unknown to FME. Skipping feature class

 

 

Got it! thank you very much!


dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • 627 replies
  • December 15, 2022

@zacharylee1204​ You can use a FeatureReader for reading the schema features, followed by a ListExploder to get those values as an attribute. Workspace is attached.image