Don't like the adverts?  Click here to remove them

GPS Seconds

G

Guest

Guest
Hi Folks
I have been struggling for while with a small problem that perhaps some of
you
have come across before.
My MemoryMap software, like many other GPS software?s give the Waypoints a
Time Stamp in seconds counted from 1st Jan 1970, so it is hard work to use.
This Time Stamp, in my case can be extracted if I export the Track or Route
as a
.csv file and then open it in Excel.
I need to decipher these Time Stamps, so I can correlate the position in the
terrain,
to that of the pictures taken along the route, using the Camera Time Stamp.
I have found a website that will convert the GPS seconds to a, Date & Time
for
any timezone, but the site is Internet dependent and can only handle single
entries
and not a whole file.
http://www.mapshots.com/tools/gps_time.asp
Does anybody know of a routine that can handle the conversion of these
seconds into
something more useful like a proper date and time?
Regards Jorgen
KDJ120 (UK)
 
Hi Jorgen
There are multiple ways - but I know of no standard solution. I would import
the file into a database, and via SQL make a calculation to get a proper
datetime - a DateAdd function could be used to add some seconds to a fixed
date and get what you want. Excel sharks may be able to do similar...
If you are not comfortable with it yourself, throw me the file off list
(henrik.christensen AT dk2net.dk) and I'll give it a try - please be a
little patient, as I'm pushed heavily by my professional work for the time
being....
"Does anybody know of a routine that can handle the conversion of these
seconds into something more useful like a proper date and time?
Regards Jorgen
KDJ120 (UK)
"
 
On 5/2/07, Jorgen Gronberg <[Email address removed]> wrote:
Jorgen,
Does MM allow you to batch import pictures and show them along the
track as trackpoint attachments? If it does, perhaps it's one reason
to worth the bother with recalculating the time stamps. If not, I
suggest you switch to TTQV, which does allow that and has more useful
functions than MM, which is a pretty basic piece of software.
I am also looking for a picture processing function - although TTQV
allows exporting tracks as Google Earth KMZ files, it will not export
pictures as links at the same time. Would anyone have an idea how to
batch process picture attachments in Google Earth?
--
Rgds,
Roman (London, UK)
'92 HDJ80
 
Henrik Christensen wrote:
There are many.. the date-functions in both perl, java and javascript
handles timestamps calculated from epoc quite well. (epoc is on most
systems 00:00:00 Jan. 1. 1970 UTC. but not all)
To use perl just do: (if you have perl on you machine)
$ perl -e 'print localtime(1178174655)."
"'
Thu May 3 08:44:15 2007
(the above result will be in you local timezone)
--
Michael Thorsager, Denmark, http://gallery.vx80.dk
1997 VX80, 2.5" OME (and some other stuff)
 
Henrik
This is standard "C" time and date programming, with seconds since the
"epoch" 1/1/1970 being used. Very crude, as you say.
Michael's solution is a good one if you have perl on your system, but if
you haven't I've knocked up a teeny-weeny Windows executable that will
do it for you.
Go to http://www.christopherbell.freeola.com/date.exe
Your anti-virus stuff / firewall may kick up a fuss because this is an
executable, but I promise that there are no nasties lurking in there.
Incidentally there is a potential "Year 2038" bug buried in all this: if
one uses a conventional signed 32 bit integer to handle this number,
which most programmes do, it has a max value of 2,147,483,649. Counting
forwards from 1/1/1970 that gives a date sometime in 2038 at which it
will fall over!
Before I get jumped on I know that later versions of the standard make
that number a 64 bit integer, which defers the problem until we are all
dust, but I still bet that the "Y2038 bug" will be far more traumatic
than the "Y2K" one ever was!
Christopher Bell
| Henrik Christensen wrote:
|
| > "Does anybody know of a routine that can handle the conversion of
these
| > seconds into something more useful like a proper date and time?
| There are many.. the date-functions in both perl, java and javascript
| handles timestamps calculated from epoc quite well. (epoc is on most
| systems 00:00:00 Jan. 1. 1970 UTC. but not all)
|
| To use perl just do: (if you have perl on you machine)
|
| $ perl -e 'print localtime(1178174655)."
"'
| Thu May 3 08:44:15 2007
| (the above result will be in you local timezone)
|
| --
| Michael Thorsager, Denmark, http://gallery.vx80.dk
| 1997 VX80, 2.5" OME (and some other stuff)
____________________________________________________________
Electronic mail messages entering and leaving Arup business
systems are scanned for acceptability of content and viruses
 
Hi,
Try his website:
http://www.blindhog.net/convert-epoch-time-in-excel/
Just use excel to convert them.
Regards
Martin.
-----Original Message-----
From: [Email address removed] [mailto:[Email address removed]] On
Behalf Of Henrik Christensen
Sent: 03 May 2007 05:15
To: [Email address removed]
Subject: RE: [ELCO] GPS Seconds
Hi Jorgen
There are multiple ways - but I know of no standard solution. I would import
the file into a database, and via SQL make a calculation to get a proper
datetime - a DateAdd function could be used to add some seconds to a fixed
date and get what you want. Excel sharks may be able to do similar...
If you are not comfortable with it yourself, throw me the file off list
(henrik.christensen AT dk2net.dk) and I'll give it a try - please be a
little patient, as I'm pushed heavily by my professional work for the time
being....
"Does anybody know of a routine that can handle the conversion of these
seconds into something more useful like a proper date and time?
Regards Jorgen
KDJ120 (UK)
"
 
Don't like the adverts?  Click here to remove them
------=_NextPart_001_0007_01C78DD3.3F197F80
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Thank You to everybody that put forward ideas, hints or small routines to
solve my problem.
In the end, I ended up using an excel routine to do the job.
I can now put Hotspots' on the track, and that in turn will point to the associated
picture file.
Perhaps Roman is right that the time is up for some new Software, as I can not just
import the pictures as a batch file and let them automatically distribute along the track
according to their TimeStamps.
Regards Jorgen
KDJ120 (UK)
------=_NextPart_001_0007_01C78DD3.3F197F80
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dwindows-1252"><BASE
href=3D"file://C:program FilesCommon FilesMicrosoft SharedStationery">
<STYLE>BODY {
BACKGROUND-POSITION: left top; MARGIN-TOP: 25px; FONT-SIZE: 12pt; MARGIN-LEFT: 25px; COLOR: #000000; BACKGROUND-REPEAT: no-repeat; FONT-FAMILY: Times New Roman
}
</STYLE>
<META content=3D"MSHTML 6.00.2900.3059" name=3DGENERATOR></HEAD>
<BODY bgColor=3D#ffffff background=3Dcid:000501c78dca$dd4d7660$897ba8c0@winxp>
<DIV>Thank You to everybody that put forward ideas, hints or small
routines to</DIV>
<DIV>solve my problem.</DIV>
<DIV> </DIV>
<DIV>In the end, I ended up using an excel routine to do the job.</DIV>
<DIV> </DIV>
<DIV>I can now put Hotspots' on the track, and that in turn
will point to the associated</DIV>
<DIV>picture file.</DIV>
<DIV> </DIV>
<DIV>Perhaps Roman is right that the time is up for some new Software,
as I can not just</DIV>
<DIV>import the pictures as a batch file and let
them automatically distribute along the track</DIV>
<DIV>according to their TimeStamps.</DIV>
<DIV> </DIV>
<DIV>Regards Jorgen</DIV>
<DIV> </DIV>
<DIV>KDJ120 (UK)</DIV></BODY></HTML>
------=_NextPart_001_0007_01C78DD3.3F197F80--
 
Back
Top