Skip to main content
AvgeekJoe
Participating Frequently
June 9, 2018
Answered

Problems Transferring FlightRadar24 KML & CSV to GPX & Lightroom Classic

  • June 9, 2018
  • 3 replies
  • 2448 views

Hey Adobe;

I'm a monthly subscribing user to your wonderful Lightroom Classic.  Attempting to load FlightRadar24 tracks from last October to Lightroom so I can track where I took pictures on my flights.  I get those tracks in CSV and KML - and have uploaded for both flights, both versions to Google Drive at KML files from 14 October 2017 to convert - Google Drive  .

Wonder why I can't get a good GPX conversion or such out of them. 

For instance, when I open up the CSV for one of my flights in Excel, I get:

     

TimestampUTCCallsignPositionAltitudeSpeedDirection
15079895612017-10-14T13:59:21ZQXE233447.424725,-122.3062441410140174
15079895702017-10-14T13:59:30ZQXE233447.416065,-122.3009641650150157
15079895762017-10-14T13:59:36ZQXE233447.414074,-122.2992941679150157
15079895872017-10-14T13:59:47ZQXE233447.408005,-122.2947621843158154
15079895942017-10-14T13:59:54ZQXE233447.399033,-122.287882115175151
15079896002017-10-14T14:00:00ZQXE233447.396004,-122.2854082232175151
15079896092017-10-14T14:00:09ZQXE233447.390358,-122.2797162467181148
15079896152017-10-14T14:00:15ZQXE233447.384438,-122.272722757184144
15079896222017-10-14T14:00:22ZQXE233447.382023,-122.2688062871190138
15079896302017-10-14T14:00:30ZQXE233447.377502,-122.2597963100194129
15079896362017-10-14T14:00:36ZQXE233447.373615,-122.2491993364200120
15079896472017-10-14T14:00:47ZQXE233447.369434,-122.2325973662208112
15079896532017-10-14T14:00:53ZQXE233447.368515,-122.2266693747216107
15079896592017-10-14T14:00:59ZQXE233447.36684,-122.2150123931221102
15079896662017-10-14T14:01:06ZQXE233447.365711,-122.2083054039221102
15079896752017-10-14T14:01:15ZQXE233447.363117,-122.1883624308236100
15079896812017-10-14T14:01:21ZQXE233447.362244,-122.181614390236100
15079896872017-10-14T14:01:27ZQXE233447.360229,-122.1672294617241100
15079896932017-10-14T14:01:33ZQXE233447.359451,-122.1608664707248100
15079896992017-10-14T14:01:39ZQXE233447.357723,-122.147274907256100
15079897052017-10-14T14:01:45ZQXE233447.356514,-122.1387255037256100
15079897212017-10-14T14:02:01ZQXE233447.3526,-122.1088185450272100
15079897372017-10-14T14:02:17ZQXE233447.349522,-122.079369585427798
15079897502017-10-14T14:02:30ZQXE233447.347221,-122.058052617527498
15079897622017-10-14T14:02:42ZQXE233447.343838,-122.0341346537280101
15079897772017-10-14T14:02:57ZQXE233447.340298,-122.0092246949251100
15079897902017-10-14T14:03:10ZQXE233447.336742,-121.9871147264273103
15079898062017-10-14T14:03:26ZQXE233447.334007,-121.9699487461295103
15079898172017-10-14T14:03:37ZQXE233447.3298,-121.9398357900295103
15079898332017-10-14T14:03:53ZQXE233447.323978,-121.9023518424295103
15079898522017-10-14T14:04:12ZQXE233447.321587,-121.8901528600277105
15079898632017-10-14T14:04:23ZQXE233447.314964,-121.8495189225274102
15079898762017-10-14T14:04:36ZQXE233447.311508,-121.8275769500274102
15079898942017-10-14T14:04:54ZQXE233447.307636,-121.8006829800300101
15079899062017-10-14T14:05:06ZQXE233447.301506,-121.76338210200324102
15079899212017-10-14T14:05:21ZQXE233447.296265,-121.72878310589326101
15079899362017-10-14T14:05:36ZQXE233447.292809,-121.70376610875323101
15079899482017-10-14T14:05:48ZQXE233447.287483,-121.67078411275321102
15079899602017-10-14T14:06:00ZQXE233447.283524,-121.64620211574316102
15079899712017-10-14T14:06:11ZQXE233447.280376,-121.62782311800313102
15079899842017-10-14T14:06:24ZQXE233447.275936,-121.60257712075318103
15079900202017-10-14T14:07:00ZQXE233447.263851,-121.52848813000311102
15079900352017-10-14T14:07:15ZQXE233447.256279,-121.48905913400309105
15079900962017-10-14T14:08:16ZQXE233447.212509,-121.39817814699313108
15079901202017-10-14T14:08:40ZQXE233447.178577,-121.35118115425323135
15079901262017-10-14T14:08:46ZQXE233447.172405,-121.3459415550323135
15079901582017-10-14T14:09:18ZQXE233447.136829,-121.29976716249323135
15079901792017-10-14T14:09:39ZQXE233447.131306,-121.29472416350337147
15079902122017-10-14T14:10:12ZQXE233447.075649,-121.21678917345330141
15079902282017-10-14T14:10:28ZQXE233447.069469,-121.20423917500310129
15079902382017-10-14T14:10:38ZQXE233447.052143,-121.18231217775310129
15079902702017-10-14T14:11:10ZQXE233447.016922,-121.13315618300322138
15079903422017-10-14T14:12:22ZQXE233446.94762,-121.03557619450322135
15079904022017-10-14T14:13:22ZQXE233446.875259,-120.927220334328133
15079904442017-10-14T14:14:04ZQXE233446.837002,-120.86964420850328133
15079905302017-10-14T14:15:30ZQXE233446.745972,-120.73493222025328133
15079905912017-10-14T14:16:31ZQXE233446.67577,-120.63119522850337134
15079906602017-10-14T14:17:40ZQXE233446.596966,-120.51702923000345134
15079907242017-10-14T14:18:44ZQXE233446.518116,-120.40166523000377132
15079907892017-10-14T14:19:49ZQXE233446.432701,-120.27864123000387134
15079908602017-10-14T14:21:00ZQXE233446.361809,-120.17563623000395134
15079909302017-10-14T14:22:10ZQXE233446.262798,-120.03446223000397135
15079909942017-10-14T14:23:14ZQXE233446.171078,-119.90238223000398135
15079910552017-10-14T14:24:15ZQXE233446.107956,-119.8130822999398135
15079911162017-10-14T14:25:16ZQXE233446.006165,-119.67044822999401135
15079911892017-10-14T14:26:29ZQXE233445.929031,-119.56137823000400135
15079912522017-10-14T14:27:32ZQXE233445.83231,-119.42620822999408136
15079913142017-10-14T14:28:34ZQXE233445.748222,-119.30771623000400135
15079913772017-10-14T14:29:37ZQXE233445.664257,-119.19064323000398135
15079914402017-10-14T14:30:40ZQXE233445.579239,-119.07320423000400135
15079914532017-10-14T14:30:53ZQXE233445.562782,-119.05052223000400135
15079915492017-10-14T14:32:29ZQXE233445.462013,-118.91248323000404135
15079916042017-10-14T14:33:24ZQXE233445.366821,-118.77996123000397135
15079916562017-10-14T14:34:16ZQXE233445.308468,-118.70024923000398135
15079916872017-10-14T14:34:47ZQXE233445.286072,-118.67006723000398135
15079917282017-10-14T14:35:28ZQXE233445.202297,-118.55757123000398135
15079918142017-10-14T14:36:54ZQXE233445.09375,-118.41137723000398138
15079918672017-10-14T14:37:47ZQXE233445.027576,-118.32620223000398138
15079919152017-10-14T14:38:35ZQXE233444.95549,-118.22623423000394135
15079919462017-10-14T14:39:06ZQXE233444.938263,-118.20476523000394135
15079920402017-10-14T14:40:40ZQXE233444.794289,-118.01125323000394135
15079920912017-10-14T14:41:31ZQXE233444.714447,-117.90345822999394135
15079921802017-10-14T14:43:00ZQXE233444.596088,-117.74295823000413130
15079922412017-10-14T14:44:01ZQXE233444.512218,-117.63861823000400137
15079923042017-10-14T14:45:04ZQXE233444.416836,-117.5066622999432138
15079923292017-10-14T14:45:29ZQXE233444.384506,-117.46366922981377143
15079923412017-10-14T14:45:41ZQXE233444.369766,-117.4473522799377143
15079923602017-10-14T14:46:00ZQXE233444.339378,-117.39823922249458130
15079923672017-10-14T14:46:07ZQXE233444.329262,-117.38848922124450133
15079923732017-10-14T14:46:13ZQXE233444.32671,-117.38103522052410130
15079924292017-10-14T14:47:09ZQXE233444.257145,-117.29750820499360143
15079924532017-10-14T14:47:33ZQXE233444.224293,-117.25163319414422131
15079925222017-10-14T14:48:42ZQXE233444.135788,-117.13688717430373137
15079925572017-10-14T14:49:17ZQXE233444.091419,-117.08321416497343141
15079925932017-10-14T14:49:53ZQXE233444.050076,-117.03065515587343134
15079926242017-10-14T14:50:24ZQXE233444.016933,-116.98959414925334137
15079926582017-10-14T14:50:58ZQXE233443.977947,-116.94284114075322138
15079926932017-10-14T14:51:33ZQXE233443.943092,-116.89290613200330130
15079927252017-10-14T14:52:05ZQXE233443.911594,-116.83100912133330121
15079927312017-10-14T14:52:11ZQXE233443.9053,-116.81565111970334118
15079927472017-10-14T14:52:27ZQXE233443.902325,-116.80839511775332119
15079927622017-10-14T14:52:42ZQXE233443.882889,-116.76605211100332119
15079927732017-10-14T14:52:53ZQXE233443.879681,-116.75796510975332119
15079927852017-10-14T14:53:05ZQXE233443.864216,-116.72325910400327119
15079927972017-10-14T14:53:17ZQXE233443.854977,-116.70075210050324119
15079928132017-10-14T14:53:33ZQXE233443.84705,-116.6820989750314120
15079928282017-10-14T14:53:48ZQXE233443.838154,-116.6619879425312120
15079928402017-10-14T14:54:00ZQXE233443.822208,-116.6286248878303123
15079928542017-10-14T14:54:14ZQXE233443.81889,-116.6230938775303123
15079928632017-10-14T14:54:23ZQXE233443.801338,-116.5983818297289136
15079928702017-10-14T14:54:30ZQXE233443.797451,-116.5943988191289136
15079928762017-10-14T14:54:36ZQXE233443.789265,-116.5861217982281140
15079928852017-10-14T14:54:45ZQXE233443.781181,-116.5782627776276143
15079929002017-10-14T14:55:00ZQXE233443.764114,-116.5619057381271145
15079929132017-10-14T14:55:13ZQXE233443.751926,-116.5511557088266145
15079929252017-10-14T14:55:25ZQXE233443.739567,-116.5403296797263146
15079929372017-10-14T14:55:37ZQXE233443.727951,-116.5304496521260147
15079929532017-10-14T14:55:53ZQXE233443.712307,-116.5168616156253147
15079929682017-10-14T14:56:08ZQXE233443.697311,-116.5032355795246146
15079929802017-10-14T14:56:20ZQXE233443.685516,-116.4919595534243145
15079929922017-10-14T14:56:32ZQXE233443.675804,-116.4828575263236145
15079930042017-10-14T14:56:44ZQXE233443.664883,-116.473744997233147
15079930132017-10-14T14:56:53ZQXE233443.657791,-116.4684524791231149
15079930192017-10-14T14:56:59ZQXE233443.650246,-116.4629674558226150
15079930292017-10-14T14:57:09ZQXE233443.643242,-116.4576114357223151
15079930362017-10-14T14:57:16ZQXE233443.637108,-116.4523324250217149
15079930432017-10-14T14:57:23ZQXE233443.630577,-116.4453814200214146
15079930492017-10-14T14:57:29ZQXE233443.628704,-116.4427114157208139
15079930552017-10-14T14:57:35ZQXE233443.623672,-116.4347384235204133
15079930612017-10-14T14:57:41ZQXE233443.621521,-116.430454250204133
15079930672017-10-14T14:57:47ZQXE233443.618259,-116.4219134225198124
15079930732017-10-14T14:57:53ZQXE233443.61705,-116.4176864232194117
15079930792017-10-14T14:57:59ZQXE233443.614594,-116.408344208192111
15079930852017-10-14T14:58:05ZQXE233443.613491,-116.4036184125192111
15079930912017-10-14T14:58:11ZQXE233443.611214,-116.3934784024191107
15079930972017-10-14T14:58:17ZQXE233443.610561,-116.3891753992190105
15079931052017-10-14T14:58:25ZQXE233443.609013,-116.3802873961190103
15079932272017-10-14T15:00:27ZQXE233443.55798,-116.2554933300146114
15079932922017-10-14T15:01:32ZQXE233443.543476,-116.2053993200144124

So is the solution me deleting a column or more?  I'd like to know before my next flight in a few weeks please as I rather like geo-tagging my photography when I can.  Please note these rows have a date & time plus GPS coordinates plus an altitude & heading.

Many thanks.

This topic has been closed for replies.
Correct answer johnrellis

Oh, sorry, I got horribly confused. Of course the photo doesn't have GPS coordinates -- that's why you want to add them from the GPX tracklog!  I'll dig into the data soon.


The FlightRadar24 KML files aren't tracklogs containing trackpoints, such as produced by GPS receivers, which is what LR and other geotagging applcations expect. Rather, they contain timestamped "waypoints". Seems a little strange that FlightRadar24 does this, but maybe they have some legitimate reason.

It took a bit to find the proper GPSBabel magic incantation to convert the waypoints to trackpoints: Flightradar 24 FR24 klm to gpx files - Garmin Forums .

So to convert the KML waypoints to GPX tracklogs, use these GPSBabel settings and then click on Filters:

Use these settings in Filters:

When you click OK, you should see this command line at the bottom of the GPSBabel window (but with different filenames, of course):

Then load the GPX file into LR with Map > Tracklog > Load Tracklog.  If your computer is running in time zone PDT (UTC - 7), then you don't need to fiddle with the Map > Tracklog > Set Time Zone Offset Command. Just select the photo(s) in the filmstrip and do Map > Tracklog > Auto Tag Photos.

Here's your example photo so tagged:

If you want to use tracks recorded in time zones other than the current time zone of your computer, and you can't figure out the Set Time Zone Offset command, post back here.

3 replies

johnrellis
Legend
June 10, 2018

Can you upload the sample photo to Google drive? The photo in your post doesn't have any GPS coordinates, and I don't know if the forum software may have stripped them. (You can verify in the LR if the photo has GPS coordinates by looking at the Default preset of the Metadata panel.)

AvgeekJoe
AvgeekJoeAuthor
Participating Frequently
June 10, 2018

Sure John.  Here is the sample photo I am attempting to geotag from the log: 2MP_of_Looking Past the Q400 Engine at Dawn over Mt. Rainier.jpg - Google Drive

AS 2334 Flight Data - 20180610141510-69245-data.gpx - Google Drive is the data I need to use to tag the photo above.

Thank you for your help!

johnrellis
Legend
June 10, 2018

Oh, sorry, I got horribly confused. Of course the photo doesn't have GPS coordinates -- that's why you want to add them from the GPX tracklog!  I'll dig into the data soon.

AvgeekJoe
AvgeekJoeAuthor
Participating Frequently
June 10, 2018

OK, I put one of my KML files into GPS Visualizer  only to get the below mess from the resulting GPX:

The original KML is up at KML of AS2334-f349b1c.kml - Google Drive .  Obviously, Adobe Lightroom can't "Auto Tag photos using tracklog".

@johnrellis I see your reply as I finish posting this info.  Will get back to you promptly after hitting "Add Reply".

I just wish there was a MS Excel template for a GPX file.  Or Adobe could let folks use KML files...

johnrellis
Legend
June 10, 2018

You'll need to convert the KML files to GPX format. I use the free GPSBabel program to do that, but there are also online converters (I haven't used any of them):

https://www.google.com/search?q=convert+google+kml+to+gpx&oq=convert+google+kml+to+gpx&aqs=chrome..69i57j0l2.4454j0j2&so…

AvgeekJoe
AvgeekJoeAuthor
Participating Frequently
June 10, 2018

I tried GPS babel and none of my photos were able to be geotagged.

johnrellis
Legend
June 10, 2018

The most efficient way to troubleshoot this sort of problem is to upload a sample GPX file and corresponding photo containing GPS coordinates that should on that track.  Upload them to Dropbox or similar and post the sharing link here.