Skip to main content
Solved

how to convert a sql table with Lat/Long to Feature class in SQL Server?

  • January 15, 2020
  • 3 replies
  • 102 views

judy_fme
Forum|alt.badge.img+1

I am new to FME. I think this is a simple quetion for you guys. I have a SQL table with two fields Longitude and Latitude and other attributes in SQL Server database. I need to it to Feature class into same database. how to do that? how to setup Longitude and Latitude fields as geometry fields in the reader?

Best answer by erik_jan

The transformer you will need after the reader is the VertexCreator.

This converts attributes to point geometry.

Hope this helps.

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.

3 replies

erik_jan
Contributor
Forum|alt.badge.img+22
  • Contributor
  • 2179 replies
  • Best Answer
  • January 15, 2020

The transformer you will need after the reader is the VertexCreator.

This converts attributes to point geometry.

Hope this helps.


judy_fme
Forum|alt.badge.img+1
  • Author
  • 8 replies
  • January 15, 2020

Thanks! I I am about to try. Appreciate!


judy_fme
Forum|alt.badge.img+1
  • Author
  • 8 replies
  • January 15, 2020

The transformer you will need after the reader is the VertexCreator.

This converts attributes to point geometry.

Hope this helps.

I tried, it works! Thanks you so much! it is a great help! Appreciate! : )