Exporting KML file in GCJ-02 date (for using google maps in China)

150 views

Skip to first unread message

Tino Drohula

unread,

Sep 28, 2021, 7:23:04 AM9/28/21

to GPS Essentials

Hi,

today i programmed a small Excel macro to convert the coordinates of an exported KML file to GCJ-02 date using this algorithm:

https://web.archive.org/web/20130815184254/http://blog.snapdragon.cc/china-gps-offset-problem/

(or here: https://chowdera.com/2021/09/20210925140701344l.html)

because otherwise the track will be shifted on the google map (in map view only; in satellite view it will be correct).

would it be possible to add an option in GPS Essentials to select that a track was recorded in China and do the conversation in the app before the file is saved in the phone? which would be way more convenient :)

attached my macro (works only with exports for google maps, not for google earth)