Skip to main content
Question

Help to Offset coordinates from excel using vertex

B
 

Hi. I am trying to offset(Y  -6170000, X -130000) and extract coordinates from an excel file. I have used a vertex creator to generate X,Y and Z. It messes the coordinates up and doesn’t seem to work as it has worked with other readers I’ve used.

 

(In the picture the offset is disconnected.)

I would also like to change the colors of the various shape file segments in the inspector, are there transformer commands to do this?

PS. Is there a place you can upload workspaces to get feedback on them?

/Burbank

 

 

4 replies

david_r
Celebrity
  • david_rCelebrity
  • October 6, 2014
Hej,

 

 

I'm not sure what the problem could be, and it's a little bit difficult to tell when you've disconnected the Offsetter ;-)

 

 

However, the VertexCreator should work as advertised. Just remember that the Offsetter goes after the VertexCreator.

 

 

For most purposes, a screen dump works great, as you did here. If you need to share files, you could consider using a service such as Dropbox: https://www.dropbox.com/help/20

 

 

David
david_r
Celebrity
  • david_rCelebrity
  • October 6, 2014
Sorry, forgot about the question re colors: Try using a FeatureColorSetter before the Inspector.

 

 

David
B
  • burbank
  • Author
  • October 6, 2014
Thank you for your help David. I think the issue is that X and Y should be flipped. Something to do with CAD standards we export to. I will try simply reversing them in the vertex creator.
david_r
Celebrity
  • david_rCelebrity
  • October 6, 2014
Hi,

 

 

yes, having to swap the x and y values is a common issue. From wikipedia (http://en.wikipedia.org/wiki/Geodesy#Coordinate_systems_in_the_plane):

 

 

It is geodetic practice—contrary to the mathematical convention—to let the x axis point to the North and the y axis to the East.

 

 

David

Reply


Helpful Members This Week

Community Stats

31,191
Posts
118,237
Replies
38,799
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.