laptop and a wrench

漏洞

When using an SQL expression in ArcGIS Online, text fields calculated from double fields round or convert the numbers to scientific notation when there are more than seven digits in the double record.

ArcGIS Online
漏洞 ID 编号 BUG-000143171
已提交September 23, 2021
上次修改时间September 2, 2025
适用范围ArcGIS Online
找到的版本9.2
操作系统Windows OS
操作系统版本10.0
状态As Designed

附加信息

In ArcGIS Online, esriFieldTypeDouble maps to SQL Server float. Float provides up to 15–16 digits of precision. Values beyond this limit will either render in scientific notation (for large integers) or truncate extra fractional digits. This aligns with documented SQL Server behavior in Microsoft Docs for float and real (Transact-SQL) in https://learn.microsoft.com/en-us/sql/t-sql/data-types/float-and-real-transact-sql?view=sql-server-ver16.

解决办法

Use Arcade expressions when calculating text fields from doubles to preserve the full literal value. For SQL calculations, the str (length, decimals) function can control formatting, though precision remains limited by float. If exact preservation of all digits is required, consider using text or decimal/numeric fields instead of double.

重现步骤

漏洞 ID: BUG-000143171

软件:

  • ArcGIS Online

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项