Quantcast

GPX -> CSV used to get far more fields

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

GPX -> CSV used to get far more fields

James Tappin
Long ago, when I converted GPX track files from my GPS unit (Garmin 62s) to a CSV format I used to get a large number of derived fields:

For example:
<trkpt lat="32.831116" lon="-105.737534"><ele>2462.07</ele><time>2011-09-25T14:43:10Z</time></trkpt>
Gave:
Index    Lat            Lon            Icon    Name    Description    Notes    URL    Link Text    Altitude (m)    Distance (km)    Speed (m/s)    Course (°)    Time    HDOP    VDOP    PDOP    Satellites    Fix
0    32.831116    N    32° 49.866960' N    -105.737534    W    105° 44.252040' W                    ""        2463.040000    0.000000    0.000000    0.000000    40811.613113    0.000000    0.000000    0.000000    -1    pps

Unfortunately I don't remember what options I used to produce that output -- but it must have been something fairly generic as there are plenty of fields that I don't know what they are.
Now the best I seem to be able to get (using the GUI or otherwise) is the universal CSV from the GUI with default options which converts

<trkpt lat="51.587101" lon="-1.414030"><ele>53.97</ele><time>2015-12-23T12:07:02Z</time></trkpt>

To:
No,Latitude,Longitude,Altitude,Speed,Course,FIX,Date,Time
1,51.586952,-1.414025,54.0,0.00,0.0,"3d",2015/12/23,12:05:46

While some of the fields in the older output are not very useful -- but I would like to be able to get the distance column (which is an integrated distance rather than a distance between fixes. Is there still an option to add that?

Thanks

James Tappin


------------------------------------------------------------------------------

_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
[hidden email]
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: GPX -> CSV used to get far more fields

tsteven4-2
James,

That looks like the openoffice format.
% ./gpsbabel -i gpx -f reference/navilink_waypoints.gpx -o openoffice -F -
Index    Lat            Lon            Icon    Name    Description    Notes    URL    Link Text    Altitude (m)    Distance (km)    Speed (m/s)    Course (°)    Time    HDOP    VDOP    PDOP    Satellites    Fix
0    51.768668    N    51° 46.120098' N    0.003845    E    0° 0.230700' E    Star    M000    M000    M000    ""        67.970400    0.000000    0.000000    0.000000    39352.567801    0.000000    0.000000    0.000000    -1    Unknown
1    51.768668    N    51° 46.120098' N    0.003845    E    0° 0.230700' E    Star    M000    M000    M000    ""        67.970400    0.000000    0.000000    0.000000    39358.711725    0.000000    0.000000    0.000000    -1    Unknown
2    51.775567    N    51° 46.533996' N    0.004690    E    0° 0.281400' E    Star    M001    M001    M001    ""        0.000000    0.770118    0.000000    0.000000    39354.614606    0.000000    0.000000    0.000000    -1    Unknown


On 12/27/2015 5:53 AM, James Tappin wrote:
Long ago, when I converted GPX track files from my GPS unit (Garmin 62s) to a CSV format I used to get a large number of derived fields:

For example:
<trkpt lat="32.831116" lon="-105.737534"><ele>2462.07</ele><time>2011-09-25T14:43:10Z</time></trkpt>
Gave:
Index    Lat            Lon            Icon    Name    Description    Notes    URL    Link Text    Altitude (m)    Distance (km)    Speed (m/s)    Course (°)    Time    HDOP    VDOP    PDOP    Satellites    Fix
0    32.831116    N    32° 49.866960' N    -105.737534    W    105° 44.252040' W                    ""        2463.040000    0.000000    0.000000    0.000000    40811.613113    0.000000    0.000000    0.000000    -1    pps

Unfortunately I don't remember what options I used to produce that output -- but it must have been something fairly generic as there are plenty of fields that I don't know what they are.
Now the best I seem to be able to get (using the GUI or otherwise) is the universal CSV from the GUI with default options which converts

<trkpt lat="51.587101" lon="-1.414030"><ele>53.97</ele><time>2015-12-23T12:07:02Z</time></trkpt>

To:
No,Latitude,Longitude,Altitude,Speed,Course,FIX,Date,Time
1,51.586952,-1.414025,54.0,0.00,0.0,"3d",2015/12/23,12:05:46

While some of the fields in the older output are not very useful -- but I would like to be able to get the distance column (which is an integrated distance rather than a distance between fixes. Is there still an option to add that?

Thanks

James Tappin



------------------------------------------------------------------------------


_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
[hidden email]
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc


------------------------------------------------------------------------------

_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
[hidden email]
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: GPX -> CSV used to get far more fields

James Tappin
Yes that's the one, thanks.

On 27 December 2015 at 14:31, tsteven4 <[hidden email]> wrote:
James,

That looks like the openoffice format.
% ./gpsbabel -i gpx -f reference/navilink_waypoints.gpx -o openoffice -F -
Index    Lat            Lon            Icon    Name    Description    Notes    URL    Link Text    Altitude (m)    Distance (km)    Speed (m/s)    Course (°)    Time    HDOP    VDOP    PDOP    Satellites    Fix
0    51.768668    N    51° 46.120098' N    0.003845    E    0° 0.230700' E    Star    M000    M000    M000    ""        67.970400    0.000000    0.000000    0.000000    39352.567801    0.000000    0.000000    0.000000    -1    Unknown
1    51.768668    N    51° 46.120098' N    0.003845    E    0° 0.230700' E    Star    M000    M000    M000    ""        67.970400    0.000000    0.000000    0.000000    39358.711725    0.000000    0.000000    0.000000    -1    Unknown
2    51.775567    N    51° 46.533996' N    0.004690    E    0° 0.281400' E    Star    M001    M001    M001    ""        0.000000    0.770118    0.000000    0.000000    39354.614606    0.000000    0.000000    0.000000    -1    Unknown


On 12/27/2015 5:53 AM, James Tappin wrote:
Long ago, when I converted GPX track files from my GPS unit (Garmin 62s) to a CSV format I used to get a large number of derived fields:

For example:
<trkpt lat="32.831116" lon="-105.737534"><ele>2462.07</ele><time>2011-09-25T14:43:10Z</time></trkpt>
Gave:
Index    Lat            Lon            Icon    Name    Description    Notes    URL    Link Text    Altitude (m)    Distance (km)    Speed (m/s)    Course (°)    Time    HDOP    VDOP    PDOP    Satellites    Fix
0    32.831116    N    32° 49.866960' N    -105.737534    W    105° 44.252040' W                    ""        2463.040000    0.000000    0.000000    0.000000    40811.613113    0.000000    0.000000    0.000000    -1    pps

Unfortunately I don't remember what options I used to produce that output -- but it must have been something fairly generic as there are plenty of fields that I don't know what they are.
Now the best I seem to be able to get (using the GUI or otherwise) is the universal CSV from the GUI with default options which converts

<trkpt lat="51.587101" lon="-1.414030"><ele>53.97</ele><time>2015-12-23T12:07:02Z</time></trkpt>

To:
No,Latitude,Longitude,Altitude,Speed,Course,FIX,Date,Time
1,51.586952,-1.414025,54.0,0.00,0.0,"3d",2015/12/23,12:05:46

While some of the fields in the older output are not very useful -- but I would like to be able to get the distance column (which is an integrated distance rather than a distance between fixes. Is there still an option to add that?

Thanks

James Tappin



------------------------------------------------------------------------------


_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
[hidden email]
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc



------------------------------------------------------------------------------

_______________________________________________
Gpsbabel-misc mailing list http://www.gpsbabel.org
[hidden email]
To unsubscribe, change list options, or see archives, visit:
https://lists.sourceforge.net/lists/listinfo/gpsbabel-misc
Loading...