Skip to main content
Best Answer

How to read one geometry from multi-geometry table ?

  • August 28, 2020
  • 1 reply
  • 81 views

lifalin2016
Supporter
Forum|alt.badge.img+40

In MS/SQL I have a table with multiple geometry fields. When using a FeatureReader, how can I designate which geometry column to read ?

Best answer by david_r

I believe you'll have to check the option "Handle multiple spatial columns" on the reader. You can then select the geometry column by filtering on the traits in the resulting aggregate, see also the documentation:

http://docs.safe.com/fme/2020.1/html/FME_Desktop_Documentation/FME_ReadersWriters/mssql_spatial/MSSQL_Spatial_reader.htm

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

david_r
Celebrity
  • Best Answer
  • August 28, 2020

I believe you'll have to check the option "Handle multiple spatial columns" on the reader. You can then select the geometry column by filtering on the traits in the resulting aggregate, see also the documentation:

http://docs.safe.com/fme/2020.1/html/FME_Desktop_Documentation/FME_ReadersWriters/mssql_spatial/MSSQL_Spatial_reader.htm