Skip to main content
Solved

How to read one geometry from multi-geometry table ?

  • August 28, 2020
  • 1 reply
  • 39 views

lifalin2016
Contributor
Forum|alt.badge.img+29

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

View original
Did this help you find an answer to your question?

1 reply

david_r
Evangelist
  • 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


Reply


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