I have locus points for proposed trees and a worksheet displaying information about the trees: ID, Latin Name, Common Name. I want to add the Longitude and Latitude of each tree to the worksheet but I cannot find what function to use in the cell to display that.
I have a georeferenced file.
I'm waiting for an email reply from tech support but this is urgent and I have no idea how long it'll take to hear back. Does anyone know how to display Latitude and Longitude?
I've attached a screenshot of my file showing the Data tab of one of the objects that needs Longitude, Latitude displayed. It also shows the worksheet I have set up for displaying the tree info. What function goes in those dang cells?
By the way, Xcenter, Ycenter, XCoordiante, YCoordinate do NOT work - they display the location based on x,y of the file not taking the georeferenced location into account.
Having said all that, I'm a bit worried the trees are not in the correct location. The location of the highlighted tree locus in the file is 2882818'9", 2315428'6.156" while the coordinates of this location (Gary, Indiana) are 41 North and 87 West. Also, to help you understand what you're looking at, the tree loci are a shapefile I exported from my project file and imported into this file for the purpose of checking on what I produced. This shapefile is a deliverable to the client who will put the tree location shapefile into an app so that people can locate the trees as part of a national science project.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
yasin2ray
I have locus points for proposed trees and a worksheet displaying information about the trees: ID, Latin Name, Common Name. I want to add the Longitude and Latitude of each tree to the worksheet but I cannot find what function to use in the cell to display that.
I have a georeferenced file.
I'm waiting for an email reply from tech support but this is urgent and I have no idea how long it'll take to hear back. Does anyone know how to display Latitude and Longitude?
I've attached a screenshot of my file showing the Data tab of one of the objects that needs Longitude, Latitude displayed. It also shows the worksheet I have set up for displaying the tree info. What function goes in those dang cells?
By the way, Xcenter, Ycenter, XCoordiante, YCoordinate do NOT work - they display the location based on x,y of the file not taking the georeferenced location into account.
Having said all that, I'm a bit worried the trees are not in the correct location. The location of the highlighted tree locus in the file is 2882818'9", 2315428'6.156" while the coordinates of this location (Gary, Indiana) are 41 North and 87 West. Also, to help you understand what you're looking at, the tree loci are a shapefile I exported from my project file and imported into this file for the purpose of checking on what I produced. This shapefile is a deliverable to the client who will put the tree location shapefile into an app so that people can locate the trees as part of a national science project.
Thank you!
Anna
Link to comment
6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.