Skip to main content
Solved

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


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.

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

3 replies

erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • 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
  • January 15, 2020

Thanks! I I am about to try. Appreciate!


judy_fme
Forum|alt.badge.img+1
  • Author
  • January 15, 2020
erik_jan wrote:

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! : )


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