Question

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

M
Badge +1

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
Rank
Userlevel 6
Badge +32

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

M
Badge +1

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
Rank
Userlevel 6
Badge +32

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)

M
Badge +1

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

M
Badge +1

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
Rank
Userlevel 6
Badge +32

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


Community Stats

28,670
Posts
109,368
Replies
36,531
Members
Terms & ConditionsCookie 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.