Skip to main content
Question

Convert Long Lat from an excel file to points and place them on a EPSG3857 map

messagemauri
Contributor
Forum|alt.badge.img+6

Hello,

 

I have an excel sheet with Lon Lat values and I'm trying to convert them to points and then place them on a map that is in EPSG3857, however, the points don't land where they should be. I write it to a shapefile. Any help would be much appreciated.

image_workbench image_workbench2 

I've also tried the AttributeReprojector but what do I select for the Source Coordinate System if it's coming from Lon Lat values? I did not find GCS_WSG_1984.

image_workbench3The LON values are displayed without the -, sample: 114.2563, how can I add a dash to makes it -114.2563?

 

6 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

You need to set the source coordinate system. It's EPSG:4326

messagemauri
Contributor
Forum|alt.badge.img+6
  • messagemauriContributor
  • Author
  • Contributor
  • July 8, 2021
nielsgerrits wrote:

You need to set the source coordinate system. It's EPSG:4326

Thanks for your reply @nielsgerrits​ 

The LON values are displayed without the -, sample: 114.2563, how can I add a dash to make it -114.2563?

 

nielsgerrits
VIP
Forum|alt.badge.img+54
messagemauri wrote:

Thanks for your reply @nielsgerrits​ 

The LON values are displayed without the -, sample: 114.2563, how can I add a dash to make it -114.2563?

 

You can do this in the VertexCreator, x = @Evaluate(LON*-1)

messagemauri
Contributor
Forum|alt.badge.img+6
  • messagemauriContributor
  • Author
  • Contributor
  • July 8, 2021
messagemauri wrote:

Thanks for your reply @nielsgerrits​ 

The LON values are displayed without the -, sample: 114.2563, how can I add a dash to make it -114.2563?

 

 

I tried the following but the results are Null values for the new LON field

sampleImageFME

messagemauri
Contributor
Forum|alt.badge.img+6
  • messagemauriContributor
  • Author
  • Contributor
  • July 8, 2021
messagemauri wrote:

Thanks for your reply @nielsgerrits​ 

The LON values are displayed without the -, sample: 114.2563, how can I add a dash to make it -114.2563?

 

 x = @Evaluate(Lon*-1)

 

This gives me errors when I run the workbench

nielsgerrits
VIP
Forum|alt.badge.img+54
messagemauri wrote:

Thanks for your reply @nielsgerrits​ 

The LON values are displayed without the -, sample: 114.2563, how can I add a dash to make it -114.2563?

 

Oops, my bad, needs to be @Evaluate(@Value(LON)*-1)

Reply


Helpful Members This Week

Community Stats

31,340
Posts
118,876
Replies
38,959
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.