It is me again asking (Hopefully) an easy question.
I had 5 points from which I constructed a line. I deleted all of the initial points besides the first and last and constructed 46 points on this line.
I need the GPS data from these 48 points (which are one shapefile) preferaply in a format so that I can copy and paste it into an excel sheet.
I thought it might easily be possible by copy or save the attribute table, but this only shows 0 for the lat and long value for the constructed points (see attachment).
Is there an easy way around this?
All those points that are valued 0 cross the board are in your feature class/shape file, right? If so right click on the field heading/name and select Calculate Geometry. Choose the appropriate units and you'll be good to go.
If you open the ArcToolbox, and go to Conversion Tools >> Excel, you can use the tool "Table to Excel".
For adding xy, there is also a tool - Data Management Tools >> Features >> Add XY Coordinates
also, if you make a copy of the dbf file from your shapefile on your harddisk, excel should be able to open your attribute table as a table. If that doesn't work, you can always change the extension of the copy dbf you made to a .xls(old excel file format) and excel should be able to open it that way.
Try the calculate geometry trick as mentioned earlier to get your lat/long's then to export the table >> open up the attribute table click on "table options" (the first one on the left at the top) >> go down to "Export" >>click on the folder symbol >> find a place to save it (I usually just do desktop or any folder really) >> click on the drop down box next to 'Save as Type' and pick Text file >> name the file >> Save >> Ok
Go to your desktop >> open up the text file and it should default opening it up to Excel. Or open excel and open the text file within Excel.