﻿{"id":1391,"date":"2026-10-19T19:42:08","date_gmt":"2026-10-19T11:42:08","guid":{"rendered":"https:\/\/www.tansoo.cn\/?p=1391"},"modified":"2026-10-19T19:42:08","modified_gmt":"2026-10-19T11:42:08","slug":"phpbb-123","status":"publish","type":"post","link":"https:\/\/www.tansoo.cn\/?p=1391","title":{"rendered":"traccar6.11.1\u5750\u6807\u6570\u636e\u5e93BUG"},"content":{"rendered":"<p>\u6211\u4eceamap6.6\u5347\u7ea7\u8fc7\u6765\uff0c\u53d1\u73b0\u67e5\u8be2\u539f\u6765\u5386\u53f2\u8f68\u8ff9\u7684\u5750\u6807\u53d8\u6210\u4e86\u4e00\u6761\u76f4\u7ebf\uff0c\u6253\u5f00\u6570\u636e\u5e93\u53d1\u73b0\uff0ctraccar6.11.1\u589e\u52a0\u4e86latitudewgs84\u548clongitudewgs84\u4e24\u5217\u3002<br \/>\n\u7ecf\u6d4b\u8bd5\u53d1\u73b0\uff0c\u628a\u539flatitude\u5217\u7684\u6570\u636e\u590d\u5236\u5230latitudewgs84\u5217\uff0c\u5728traccar6.11.1\u67e5\u8be2\u5386\u53f2\u8f68\u8ff9\u6b63\u5e38\u3002<br \/>\n\u8bf7\u575b\u4e3b\u770b\u4e0b\u662f\u4e0d\u662ftraccar6.11.1\u7248\u4fee\u6539\u6709\u8bef\uff1f<\/p>\n<p>\u7248\u672c\u5982\u4e0b\uff1a<\/p>\n<div class=\"codebox\">\n<p>\u4ee3\u7801\uff1a <a href=\"#\" onclick=\"selectCode(this); return false;\">\u5168\u9009<\/a><\/p>\n<pre><code>root@mike-docker-ubuntu24:\/project\/cvs\/loc_init# docker ps -a |grep traccar_cn_t\n33e937b34590   bg6rsh\/traccar-amap:ubuntu                  \"java -Xms128m -Xmx1?\"   41 hours ago   Up 14 hours                 0.0.0.0:60008-&gt;8082\/tcp, [::]:60008-&gt;8082\/tcp                                                                                                                                                                                                                                                                                                                   traccar_cn_t\n\nroot@mike-docker-ubuntu24:\/project\/cvs\/loc_init# docker images |grep traccar\nbg6rsh\/traccar-amap                  ubuntu    d389fd96cd9c   4 months ago    520MB\n<\/code><\/pre>\n<\/div>\n<p>\u65b0\u7ed3\u6784\u591a\u4e86\u4e24\u5217\uff1a<\/p>\n<div class=\"codebox\">\n<p>\u4ee3\u7801\uff1a <a href=\"#\" onclick=\"selectCode(this); return false;\">\u5168\u9009<\/a><\/p>\n<pre><code>MariaDB [traccar_amap610t_sync]&gt; DESCRIBE tc_positions;\n+----------------+---------------+------+-----+---------------------+----------------+\n| Field          | Type          | Null | Key | Default             | Extra          |\n+----------------+---------------+------+-----+---------------------+----------------+\n| id             | int(11)       | NO   | PRI | NULL                | auto_increment |\n| protocol       | varchar(128)  | YES  |     | NULL                |                |\n| deviceid       | int(11)       | NO   | MUL | NULL                |                |\n| servertime     | timestamp     | NO   |     | current_timestamp() |                |\n| devicetime     | timestamp     | NO   |     | NULL                |                |\n| fixtime        | timestamp     | NO   |     | NULL                |                |\n| valid          | bit(1)        | NO   |     | NULL                |                |\n| latitude       | double        | NO   |     | NULL                |                |\n| longitude      | double        | NO   |     | NULL                |                |\n| altitude       | float         | NO   |     | NULL                |                |\n| speed          | float         | NO   |     | NULL                |                |\n| course         | float         | NO   |     | NULL                |                |\n| address        | varchar(512)  | YES  |     | NULL                |                |\n| attributes     | varchar(4000) | YES  |     | NULL                |                |\n| accuracy       | double        | NO   |     | 0                   |                |\n| network        | varchar(4000) | YES  |     | NULL                |                |\n| geofenceids    | varchar(128)  | YES  |     | NULL                |                |\n| latitudewgs84  | double        | YES  |     | NULL                |                |\n| longitudewgs84 | double        | YES  |     | NULL                |                |\n+----------------+---------------+------+-----+---------------------+----------------+<\/code><\/pre>\n<\/div>\n<p>\u5c06latitude   \u8d4b\u503c\u7ed9latitudewgs84 \u53ef\u6b63\u5e38\u663e\u793a\u7684<span style=\"color:#FF0000\">\u6b63\u786e<\/span>\u7684\u7ed3\u679c\uff1a<\/p>\n<div class=\"codebox\">\n<p>\u4ee3\u7801\uff1a <a href=\"#\" onclick=\"selectCode(this); return false;\">\u5168\u9009<\/a><\/p>\n<pre><code>MariaDB [traccar_amap610t_sync]&gt; SELECT * FROM tc_positions  ORDER BY id DESC   LIMIT 2;\n+--------+----------+----------+---------------------+---------------------+---------------------+-------+--------------------+--------------------+----------+---------+--------+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+-------------+--------------------+----------------+\n| id     | protocol | deviceid | servertime          | devicetime          | fixtime             | valid | latitude           | longitude          | altitude | speed   | course | address | attributes                                                                                                                                                                                                             | accuracy | network | geofenceids | latitudewgs84      | longitudewgs84 |\n+--------+----------+----------+---------------------+---------------------+---------------------+-------+--------------------+--------------------+----------+---------+--------+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+-------------+--------------------+----------------+\n| 942993 | huabao   |        7 | 2026-04-27 10:41:11 | 2026-04-27 10:41:09 | 2026-04-27 10:41:09 |      |  30.25623116321045 | 120.12434323011745 |       11 | 15.2808 |    174 | NULL    | {\"ignition\":true,\"blocked\":false,\"charge\":false,\"odometer\":4323300,\"rssi\":31,\"sat\":35,\"iccid\":\"898608340124c0428927\",\"distance\":108.6679047877219,\"totalDistance\":3797403.5884900284,\"motion\":true,\"hours\":1318318000} |        0 | null    | null        |  30.25623116321045 |           NULL |\n| 942989 | huabao   |        7 | 2026-04-27 10:40:50 | 2026-04-27 10:40:49 | 2026-04-27 10:40:49 |      | 30.257207232490412 | 120.12436028143401 |        8 | 9.44925 |    188 | NULL    | {\"ignition\":true,\"blocked\":false,\"charge\":false,\"odometer\":4323200,\"rssi\":5,\"sat\":34,\"iccid\":\"898608340124c0428927\",\"distance\":121.00132321316921,\"totalDistance\":3797294.9205852407,\"motion\":true,\"hours\":1318298000} |        0 | null    | null        | 30.257207232490412 |           NULL |\n+--------+----------+----------+---------------------+---------------------+---------------------+-------+--------------------+--------------------+----------+---------+--------+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+-------------+--------------------+----------------+\n2 rows in set (0.002 sec)\n\n<\/code><\/pre>\n<\/div>\n<p>\u5982\u679c\u6ca1\u6709\u5c06latitude   \u8d4b\u503c\u7ed9latitudewgs84 \uff0c\u76f4\u63a5\u4f7f\u7528amap6.6\u7684\u6570\u636e\u5e93\u5c31\u4f1a<span style=\"color:#FF0000\">\u51fa\u9519<\/span>\uff0c\u53ea\u663e\u793a\u4e00\u6761\u7ad6\u7ebf\uff1a<\/p>\n<div class=\"codebox\">\n<p>\u4ee3\u7801\uff1a <a href=\"#\" onclick=\"selectCode(this); return false;\">\u5168\u9009<\/a><\/p>\n<pre><code>MariaDB [traccar_amap610t_sync]&gt; SELECT * FROM tc_positions  ORDER BY id DESC   LIMIT 2;\n+--------+----------+----------+---------------------+---------------------+---------------------+-------+--------------------+--------------------+----------+---------+--------+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+-------------+--------------------+----------------+\n| id     | protocol | deviceid | servertime          | devicetime          | fixtime             | valid | latitude           | longitude          | altitude | speed   | course | address | attributes                                                                                                                                                                                                             | accuracy | network | geofenceids | latitudewgs84      | longitudewgs84 |\n+--------+----------+----------+---------------------+---------------------+---------------------+-------+--------------------+--------------------+----------+---------+--------+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+-------------+--------------------+----------------+\n| 942993 | huabao   |        7 | 2026-04-27 10:41:11 | 2026-04-27 10:41:09 | 2026-04-27 10:41:09 |      |  30.25623116321045 | 120.12434323011745 |       11 | 15.2808 |    174 | NULL    | {\"ignition\":true,\"blocked\":false,\"charge\":false,\"odometer\":4323300,\"rssi\":31,\"sat\":35,\"iccid\":\"898608340124c0428927\",\"distance\":108.6679047877219,\"totalDistance\":3797403.5884900284,\"motion\":true,\"hours\":1318318000} |        0 | null    | null        |             NULL |           NULL |\n| 942989 | huabao   |        7 | 2026-04-27 10:40:50 | 2026-04-27 10:40:49 | 2026-04-27 10:40:49 |      | 30.257207232490412 | 120.12436028143401 |        8 | 9.44925 |    188 | NULL    | {\"ignition\":true,\"blocked\":false,\"charge\":false,\"odometer\":4323200,\"rssi\":5,\"sat\":34,\"iccid\":\"898608340124c0428927\",\"distance\":121.00132321316921,\"totalDistance\":3797294.9205852407,\"motion\":true,\"hours\":1318298000} |        0 | null    | null        |            NULL |           NULL |\n+--------+----------+----------+---------------------+---------------------+---------------------+-------+--------------------+--------------------+----------+---------+--------+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+---------+-------------+--------------------+----------------+\n2 rows in set (0.002 sec)\n\n<\/code><\/pre>\n<\/div>\n<p>\u5efa\u8bae\u575b\u4e3b\u662f\u4e0d\u662f\u4fdd\u7559\u539f<span style=\"color:#FF0000\">latitude\/longitude\u4e3awgs84\u539f\u7248\u672c\u6570\u636e<\/span>\uff0c\u589e\u52a0atitude<span style=\"color:#FF0000\">gcj<\/span>\/longitude<span style=\"color:#FF0000\">gcj<\/span>\u4e24\u5217\u7ed3\u6784\uff0c\u8fd9\u6837\u5373\u80fd\u517c\u5bb9\u539f\u7248traccar\u7ed3\u6784\uff0c\u4e5f\u6709\u56fd\u5185\u5750\u6807\u7684\u652f\u6301\uff1f<\/p>\n<p>\u6211\u76ee\u524d\u6b63\u5e38\u4f7f\u7528\u7684\u8fd8\u505c\u7559\u539famap6.6\uff0c \u5f85\u8001\u5927\u66f4\u65b0\u540e\u518d\u6765\u5347\u7ea7~~~<\/p>\n<p><small>\u539f\u6587\u4f5c\u8005: mygod200 | <a href=\"https:\/\/bbs.tansoo.cn\/viewtopic.php?t=123\" target=\"_blank\" rel=\"noopener\">\u67e5\u770b\u539f\u5e16<\/a><\/small><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6211\u4eceamap6.6\u5347\u7ea7\u8fc7\u6765\uff0c\u53d1\u73b0\u67e5\u8be2\u539f\u6765\u5386\u53f2\u8f68\u8ff9\u7684\u5750\u6807\u53d8\u6210\u4e86\u4e00\u6761\u76f4\u7ebf\uff0c\u6253\u5f00\u6570\u636e\u5e93 &hellip; <a href=\"https:\/\/www.tansoo.cn\/?p=1391\">\u7ee7\u7eed\u9605\u8bfb <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[104],"tags":[],"class_list":["post-1391","post","type-post","status-publish","format-standard","hentry","category-104"],"_links":{"self":[{"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=\/wp\/v2\/posts\/1391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1391"}],"version-history":[{"count":0,"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=\/wp\/v2\/posts\/1391\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tansoo.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}