topic Re: saving latitude & longitude data in excel sheet in Data Management Questions

saving latitude & longitude data in excel sheet

MONIKAKARANJKAR — Tue, 03 Mar 2015 10:27:38 GMT

Hi,

I need to save the latitude and longitude data in excel sheet. The GPS device will be in moving car. So, in excel sheet, the position needs to be saved along with time.

Thanks in advance

Re: saving latitude & longitude data in excel sheet

XanderBakker — Tue, 03 Mar 2015 11:48:53 GMT

The GeoNet Help space is meant for Help on using GeoNet, not for help on ArcGIS. You can better move your question to Managing Data to get more responses. To move content, you can read: Moving Content

Please be more specific and provide more details:

How are the GPS positions stored (what format)?
What type of device do you have (and what type of OS)?
Should the position be stored directly as it is captured buy the GPS device?
Are you looking for a conversion of the captured locations and time to Excel or are you looking for an application that reads the GPS position and stores it in a Excel file?

Re: saving latitude & longitude data in excel sheet

MONIKAKARANJKAR — Wed, 04 Mar 2015 06:02:47 GMT

GPS positions are stored in DD format.

We are using SxBlue II GNSS unit and we are using ARCPAD ARCGIS 10.2 on

windows 7 platform.

The GPS unit will be kept in moving car. We want to store latitude and

longitude values directly in excel sheet or text file with the time stamp.

It can take time from computer. So that we can track location later.

We are just looking for application that reads the GPS position and stores

it in excel file.

Re: saving latitude & longitude data in excel sheet

XanderBakker — Wed, 04 Mar 2015 11:56:59 GMT

Thanks for the additional explanation. I do wonder what you want to do with the Excel of Text file where the current location and time is being appended. I suppose you want to process it afterwards, not in the car when the file is being written, right? (Otherwise you would probably have to avoid locks on the file). If so, what do you want to do with the information?. It has been years that I have used ArcPad, but I believe it has the possibility to track the users location to a line or point featureclass.

Please move you content to a different place. The GeoNet Help space is meant for Help on using GeoNet, not for help on ArcGIS. You can better move your question to Managing Data to get more responses. To move content, you can read:Moving Content

Re: saving latitude & longitude data in excel sheet

MONIKAKARANJKAR — Thu, 05 Mar 2015 05:02:50 GMT

Thank you for prompt reply. GPS tracking is just a part of big project.

That is why, we want to save data somewhere. And time needs to be appended

so as to synchronize this GPS data with other programs output. It will be

very easy to process data if saved in tabular format. In some thread, I

read ArcPad Studio can be used for customization. Can I use it to store

data in excel sheet ?

Re: saving latitude & longitude data in excel sheet

XanderBakker — Thu, 05 Mar 2015 12:11:50 GMT

If I look at this very, very, very old Help page of ArcPad 8, ArcPad User Guide it shows that the tracklog stores the location and data time and a ZM Point shapefile. You can convert using ArcGIS for Desktop to for instance an Excel worksheet.