Skip to main content
Solved

Latitude and Longitude DMS 2D Point Replacer

S
Hi,

 

 

I'm a beginner to FME and I apologise if this seems like a basic or an obvious query.

 

I have an excel spread sheet and one of the columns contains the coordinates in a DMS format e.g. N51.48.27 W03.22.24. How would I create a point from this coordinate?

 

I’m familiar with 2DPointReplacer and I have used it before; so as a hunch, my next step was to split the coordinates into latitude (51.48.27) and longitude (-03.22.24) columns. However, these are still not recognised as an easting and northing format when using 2DPointReplacer.

 

 

 

Please can someone point me in the right direction? My ultimate goal is to create a .shp file in a British National Grid coordinate system.

 

 

 

Thanks

 

 

 

Shaun

 

Best answer by david_r

Hi,

 

 

I think you will have to split each part of the values into three separate attributes ("51.48.27" -> "51", "48" and "27"), then use the DecimalDegreesCalculator transformer to get the lat/lon values for the 2DPointReplacer.

 

 

Look at the help for the DecimalDegreesCalculator for some hints on how to split the DMS string.

 

 

David
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

2 replies

david_r
Evangelist
  • david_rEvangelist
  • Best Answer
  • August 21, 2013
Hi,

 

 

I think you will have to split each part of the values into three separate attributes ("51.48.27" -> "51", "48" and "27"), then use the DecimalDegreesCalculator transformer to get the lat/lon values for the 2DPointReplacer.

 

 

Look at the help for the DecimalDegreesCalculator for some hints on how to split the DMS string.

 

 

David
S
  • shaun
  • Author
  • August 21, 2013
Thank you David! Spot on! That did the trick.

 

 

Shaun

Helpful Members This Week

Community Stats

30,909
Posts
117,111
Replies
38,708
Members

Latest FME

Terms & ConditionsCookie settings

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
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.