• <small id='4joos'></small><noframes id='4joos'>

    <legend id='4joos'><style id='4joos'><dir id='4joos'><q id='4joos'></q></dir></style></legend>

  • <tfoot id='4joos'></tfoot>
      <bdo id='4joos'></bdo><ul id='4joos'></ul>

      <i id='4joos'><tr id='4joos'><dt id='4joos'><q id='4joos'><span id='4joos'><b id='4joos'><form id='4joos'><ins id='4joos'></ins><ul id='4joos'></ul><sub id='4joos'></sub></form><legend id='4joos'></legend><bdo id='4joos'><pre id='4joos'><center id='4joos'></center></pre></bdo></b><th id='4joos'></th></span></q></dt></tr></i><div id='4joos'><tfoot id='4joos'></tfoot><dl id='4joos'><fieldset id='4joos'></fieldset></dl></div>

        我应该如何准确存储纬度和经度?

        时间:2023-06-01
        • <i id='ffJAr'><tr id='ffJAr'><dt id='ffJAr'><q id='ffJAr'><span id='ffJAr'><b id='ffJAr'><form id='ffJAr'><ins id='ffJAr'></ins><ul id='ffJAr'></ul><sub id='ffJAr'></sub></form><legend id='ffJAr'></legend><bdo id='ffJAr'><pre id='ffJAr'><center id='ffJAr'></center></pre></bdo></b><th id='ffJAr'></th></span></q></dt></tr></i><div id='ffJAr'><tfoot id='ffJAr'></tfoot><dl id='ffJAr'><fieldset id='ffJAr'></fieldset></dl></div>
          <tfoot id='ffJAr'></tfoot>
              <tbody id='ffJAr'></tbody>
            <legend id='ffJAr'><style id='ffJAr'><dir id='ffJAr'><q id='ffJAr'></q></dir></style></legend>
              <bdo id='ffJAr'></bdo><ul id='ffJAr'></ul>

              <small id='ffJAr'></small><noframes id='ffJAr'>

                1. 本文介绍了我应该如何准确存储纬度和经度?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我在这里阅读了这个问题:

                  I was reading this question here:

                  什么数据类型在SQL数据库中存储经纬度数据时使用?

                  而且似乎普遍的共识是使用 Decimal(9,6) 是要走的路.我的问题是,我真的需要这个有多准确?

                  And it seems the general consensus is that using Decimal(9,6) is the way to go. The question for me is, how accurate do I really need this?

                  例如,Google 的 API 返回如下结果:

                  For instance, Google's API returns a result like:

                  "lat": 37.4219720,
                  "lng": -122.0841430
                  

                  在 -122.0841430 中,我需要多少位数字?我已经阅读了几本指南,但我无法从它们中获得足够的意义来解决这个问题.

                  Out of -122.0841430, how many digits do I need? I've read several guides but I can't make enough sense out of them to figure this out.

                  在我的问题中更准确地说:如果我想在准确位置的 50 英尺内保持准确,我需要存储多少个小数点?

                  To be more precise in my question: If I want to be accurate within 50 feet of the exact location, how many decimal points do I need to store?

                  也许一个更好的问题实际上是一个非编程问题,但它会是:每个小数点给你多少准确度?

                  Perhaps a better question would actually be a non-programming question, but it would be: how much more accurate does each decimal point give you?

                  有这么简单吗?

                  1. 列表项
                  2. x00 = 6000 英里
                  3. xx0 = 600 英里
                  4. xxx = 60 英里
                  5. xxx.x = 6 英里
                  6. xxx.xx = .6 英里
                  7. 等等?

                  推荐答案

                  赤道上的精度与小数位数

                  Accuracy versus decimal places at the equator

                  decimal  degrees    distance
                  places
                  -------------------------------  
                  0        1.0        111 km
                  1        0.1        11.1 km
                  2        0.01       1.11 km
                  3        0.001      111 m
                  4        0.0001     11.1 m
                  5        0.00001    1.11 m
                  6        0.000001   0.111 m
                  7        0.0000001  1.11 cm
                  8        0.00000001 1.11 mm
                  

                  参考:https://en.wikipedia.org/wiki/Decimal_degrees#Precision

                  这篇关于我应该如何准确存储纬度和经度?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:MySQL:根据查询结果设置用户变量 下一篇:MySql: Tinyint (2) vs tinyint(1) - 有什么区别?

                  相关文章

                  1. <i id='yc7Z8'><tr id='yc7Z8'><dt id='yc7Z8'><q id='yc7Z8'><span id='yc7Z8'><b id='yc7Z8'><form id='yc7Z8'><ins id='yc7Z8'></ins><ul id='yc7Z8'></ul><sub id='yc7Z8'></sub></form><legend id='yc7Z8'></legend><bdo id='yc7Z8'><pre id='yc7Z8'><center id='yc7Z8'></center></pre></bdo></b><th id='yc7Z8'></th></span></q></dt></tr></i><div id='yc7Z8'><tfoot id='yc7Z8'></tfoot><dl id='yc7Z8'><fieldset id='yc7Z8'></fieldset></dl></div>
                    <tfoot id='yc7Z8'></tfoot>

                        <bdo id='yc7Z8'></bdo><ul id='yc7Z8'></ul>

                      <small id='yc7Z8'></small><noframes id='yc7Z8'>

                    1. <legend id='yc7Z8'><style id='yc7Z8'><dir id='yc7Z8'><q id='yc7Z8'></q></dir></style></legend>