I have a symbol that we use to identify specific locations and we need to display the latitude and longitude coordinates of each location. We have been using a Stake as a callout and have it set to display the lat and long coordinates in decimal degrees. I am now trying to show this coordinate information in a worksheet.
I do not know what function to use to get the latitude and longitude into the cells. (or it's not possible.) I tried using =ycoordinate, =xcoordinate, but this returns the x/y location in design space and not GIS coordinates. Since we set our files to be georeferenced and use an Adjusted Origin, the location will not be the distance from 0, 0. The function needs to understand the latitude and longitude coordinates.
Do you know what function I need to use?
Thanks!
Anna
(attachment is a screenshot of a worksheet I was messing around with to try to get this to work. It could have separate columns for latitude and longitude, or one column with both and with a comma between. It is showing the x/y distance from 0,0, not coordinates).
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 a symbol that we use to identify specific locations and we need to display the latitude and longitude coordinates of each location. We have been using a Stake as a callout and have it set to display the lat and long coordinates in decimal degrees. I am now trying to show this coordinate information in a worksheet.
I do not know what function to use to get the latitude and longitude into the cells. (or it's not possible.) I tried using =ycoordinate, =xcoordinate, but this returns the x/y location in design space and not GIS coordinates. Since we set our files to be georeferenced and use an Adjusted Origin, the location will not be the distance from 0, 0. The function needs to understand the latitude and longitude coordinates.
Do you know what function I need to use?
Thanks!
Anna
(attachment is a screenshot of a worksheet I was messing around with to try to get this to work. It could have separate columns for latitude and longitude, or one column with both and with a comma between. It is showing the x/y distance from 0,0, not coordinates).
Link to comment
3 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.