My boss asked me to look into the possibility of using an excel spreadsheet with x,y,z in mine grid and updating the sheet from ArcView 10.0 , in NewBrunswick Double Strereo NAD83. Preferably with one click... need to know is it possible??
I looked at this discussion and thought I could perhaps use this approach, although I do not use GPS.Importing GPS Coordinates from Excel into ArcMap
gchedore@veng.ca if you can help. Thanks
Hi Gary, while it's not "one click", you can certainly do this in ArcMap, by importing the xyz coordinates to features in the mine grid coordinate system, as described in the link, then reprojecting your data to the new projection, adding fields for your new xyz values, and then calculating these using the Calculate Geometry tool. You can then export the table back in to Excel if you wish.
But do you have the correct description / parameters for your mine grid projection?
If so, then this is very easy as Sephe said.
Thanks for the rapid reply Neil and Sephe:
currently to look at and load into GIS from CAD we are using a world projection file
with the following info:
13460.909,23260.347 2547042.49,7608137.67
12203.844,24402.850 2545777.15,7609270.91
as far as I understand the grid assumed was just that a grid, elevations +2436.5 m
when I load a CAD Drawing I export it from the layer to create a shapefile in the proper location in the world. This works but we do virtually all our work using excel. That is why the original question about updating the excel table... Any and all suggestions welcome
That just looks like FromCoord ToCoord for 2 control points.
If we just look at the differences in X & Y for both points :
For X :
13460.909 - 12203.844 = 1257.07
2547042.49 - 2545777.15 = 1265.34
For Y :
24402.85 - 23260.347 = 1142.50
7609270.91 - 7608137.67 = 1133.24
So only 8 or 9m difference on either axis. So we might assume that there is no swing (angular difference),
between the 2 coordinate systems.
So if you are prepared to accept that slight error, you could just do this is your spreadsheet.
TargetX = (X - LocalOrigX) + ProjOrigX and similarly for Y.
You have 2 control points, so just make an average of the 2.