• EN
Question

Help to Offset coordinates from excel using vertex

  • 6 October 2014
  • 4 replies
  • 3 views
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
Rank
Userlevel 4
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
Rank
Userlevel 4
Sorry, forgot about the question re colors: Try using a FeatureColorSetter before the Inspector.

 

 

David
B
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
Rank
Userlevel 4
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


Community Stats

28,700
Posts
109,460
Replies
36,550
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.