Skip to main content
Question

How to use the sqlexecutor to obtain the GEOM column from an MSSQL 2012 Database?

  • April 9, 2018
  • 1 reply
  • 16 views
R
Forum|alt.badge.img

The GEOM column in not read by the FME MSSQL Reader, and therefore it has been recommended to use the SQLExecutor to obtain the geometry. The transformer executes the SQL Statement for every row in the table, meaning that in my case with 1400 rows, the result is 1400*1400 in size.

What is the easyest way to just get the GEOM column from an mssql databse?

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
  • david_rCelebrity
  • April 9, 2018

You can probably replace the SQLExecutor with a SQLCreator, that way you only end up with 1400 rows.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.