Solved

Geometry Replacer - missing attribute after output

  • 13 February 2023
  • 4 replies
  • 13 views
R
Badge +1

Hi;

I have FME Desktop 2023.0 BETA (FME(R) 2023.0.0.0 (20230130 - Build 23226 - WIN64))

The FME workbench consists of Sql reader, Geometry Replacer, and Dwg Writer.

Sql reader reads a simple view from the database. Among others, the field 'autocad_entity' with the value 'autocad_insert' and the field 'autocad_block_name' with the value 'kc'. (I use those fields or fme attributes to create blocks through dwg writer). Reader reads everything correctly. After the reader comes the Geometry Replacer, which works correctly. However, after the Geometry Replacer, the 'autocad_entity' attribute has the value 'missing'. All other attributes are ok. Attributes are read from the database as varchar datatype.

Thanks;

sqlReaderOutputgeometryReplacerOutput

icon

Best answer by markatsafe 14 February 2023, 21:33

View original

4 replies

egge
Rank
Userlevel 1
Badge +11

I don't think the fact that you are using 2023.0 BETA is very relevant here. It should work the same in the current version of FME...

See the Usage Notes of the GeometryReplacer:

"If a feature with existing geometry has that geometry replaced using this transformer, and the new geometry is a different type (replacing an area with a point, for example), the feature's existing geometry-related format-specific attributes (such as geodb_type, autocad_entity, or shapefile_type) will be removed."

 

HTH,

 

Egge-Jan

R
Badge +1

I don't think the fact that you are using 2023.0 BETA is very relevant here. It should work the same in the current version of FME...

See the Usage Notes of the GeometryReplacer:

"If a feature with existing geometry has that geometry replaced using this transformer, and the new geometry is a different type (replacing an area with a point, for example), the feature's existing geometry-related format-specific attributes (such as geodb_type, autocad_entity, or shapefile_type) will be removed."

 

HTH,

 

Egge-Jan

Thanks for quick answer and posted link. I'm confused with removing 'autocad_insert' attribute, because this is not geometry type(just varchar). 'geom' is SQL server geometry type attribute which is correct replaced and removed. So if I understand correctly, here is problem in my 'ambiguous' naming of attribute?!

M
Badge +2

Thanks for quick answer and posted link. I'm confused with removing 'autocad_insert' attribute, because this is not geometry type(just varchar). 'geom' is SQL server geometry type attribute which is correct replaced and removed. So if I understand correctly, here is problem in my 'ambiguous' naming of attribute?!

@rzrnc​ the autocad_entity describes the type of geometry that the autocad writer can expect. It is linked to the fme_geometry/fme_type attribute which also describes the type of geometry. So if the geometry changes (as in the GeometryRpelacer), then fme_geometry/fme_type will be reset and you now have a conflict - so FME drops the autocd_entity since it now reflects the wrong geometry structure. If you need to preserve teh original entity name, rename the attribute before GeometryReplacer

R
Badge +1

Thanks for quick answer and posted link. I'm confused with removing 'autocad_insert' attribute, because this is not geometry type(just varchar). 'geom' is SQL server geometry type attribute which is correct replaced and removed. So if I understand correctly, here is problem in my 'ambiguous' naming of attribute?!

Thank you very much for the detailed explanation. I understand now.

Reply


Community Stats

28,669
Posts
109,357
Replies
36,531
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.