Extracting data from GPX files

[snowtracks]

This isn't drectly related to RC so hope there's no issues me posting this here.

I have many GPX files built up over the years and I'd like to analyse them and extract data from them.

What I would like is to have some utility or program that will parse all the GPX files in a directory (Windows) and write data about each file to an output file (just a CSV text file or similar). The output file would therefore be a list with a line for each GPX file in the directory, each line containing information about that file.

The minimum data would be lat & long of the start point - i.e. first data point in the file; date and filename.
Other data derived from the files such as elapsed time and mileage would also be useful as would being able to convert that starting lat/long into a place name (guessing that would need a Google API call).

Can anyone advise me if there's anything available anywhere that does this? 

If not any tips on how to start creating such a thing? I'm an IT person but my development days were many decades ago, so am looking for quickest and easiest solution, maybe building on existing open source code if any exists anywhere.  I'm assuming there are libraries for handling GPX files available for languages like Java or Python.

Thanks in advance

[nordlicht]

This isn't drectly related to RC so hope there's no issues me posting this here.

I have many GPX files built up over the years and I'd like to analyse them and extract data from them.
....

So RC isn't exactly for you. You could have a look at analysis software like MyTourbook or similiar stuff. MyTourbook is Open Source, you can get at least some ideas out of it if you go for your own solution.

[routeconverter]

What I would like is to have some utility or program that will parse all the GPX files in a directory (Windows) and write data about each file to an output file (just a CSV text file or similar). The output file would therefore be a list with a line for each GPX file in the directory, each line containing information about that file.

You might want to try the command line edition of RouteConverter and convert all gpx files in command line batch. The try to load them with some magic into Excel or parse the CSV with Python and transform it.

[snowtracks]

Thank you both for your suggestions, much appreciated.

So RC isn't exactly for you.

It's my go to program for editing and viewing single GPX files, but it isn't aimed at this type of analysis of multiple files so not in this case.

have a look at analysis software like MyTourbook

I've had a quick look and it seems like quite a piece of software. I'm going to install it and have a good play with with it and see what it can do. Even if it doesn't do what I want for this particular requirement it may well be very useful for other things I'd like to do. Thanks for the recommendation, good shout!

try the command line edition of RouteConverter and convert all gpx files in command line batch. The try to load them with some magic into Excel or parse the CSV with Python

Interesting suggestion, that hadn't occured to me! I will see what I can do with this. I only have LibreOffice these days rather than Excel, where I had the ability to add some magic via VB macros, but still it might work!


Thanks again

[IlmariKrebs]

R and provided libraries has also quite alot support for manipulating gpx files. It should be fairly straight forward to load gpx files in directory and extract the properties of interest.