GPX Scheme Format

[willco]

I have extracted some geotagged metadata and want to import this into Esri's ArcMap, however it says the schema doesn't conform to the GPX 1.0/1.1 schema, any ideas as to what to change when writing the commands to get this to work? or do I have to alter the GPX.fmt template?

What would be even better for me is if the tool wrote it out into a table format similar to excel as this would help me for data management purposes.

[Phil Harvey]

The GPX format is completely defined by the gpx.fmt file.  You can adjust this as necessary to set the format to anything you want.  Let me know if you figure out what was causing the problem.

See FAQ 12 for help exporting to Excel.

- Phil

[willco]

Thanks for the swift reply Phil, obviously need to read the FAQ's in a bit more depth!

Been playing around with the format of the GPX schema but can't quite get it to work, will get back to you if I can work it out.

As for the CSV output this is very helpful for me and will speed up my workflow for sure, have run it a few times and again can't quite seem to get the full data that I would expect.

this is the line that I am running exiftool.exe -csv -ee -GPSLatitude -GPSLongitude -GPSDateStamp -GPSTimeStamp -GPSSpeed Movie3.MOV > TestCSV.txt

the output is just the Lat, long and speed. I can see that the fields are left blank if there is no metadata but as this is a video id expect a list of coordinates instead of just one line. Any ideas?

[Phil Harvey]

Ah.  You want to extract GPS for multiple documents.

Sorry, I pointed you in the wrong direction.  The -csv option isn't suited for this purpose.

The -p option is the only one that (currently) has the ability to treat sub-documents as separate files.  So your command could be something like this:

exiftool -ee -n -p "$gpslatitude,$gpslongitude,$gpsdatestamp,$gpstimestamp,$gpsspeed" FILE > out.csv

- Phil

[willco]

Morning Phil, I've tried this line without a result. However, I changed it and have got the result I'm looking for, this is what I did.

-ee -n -p "-$gpslatitude" -p "-$gpslongitude" -p "-$gpsdatetime" -p "$gpsspeed" -p "," Movie3.MOV > out.csv

this has printed all the results and then split them based on the frame into a csv, so they show up like this

Lat
Long
Date/Time
Speed

Is there any way I can get these variables into a column format instead of a line?

Also, have you got the background script to this function in a python format? Thanks for the help sorry for the many questions!

[Phil Harvey]

If my command didn't work it is because one or more of the tags isn't available.  Edit the command to use the tags that exist in the file or add -f to set the value of missing tags to "-".

- Phil