Bug
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.
| Bug-ID-Nummer | BUG-000143171 |
|---|---|
| Eingereicht | September 23, 2021 |
| Zuletzt geändert | September 2, 2025 |
| Gilt für | ArcGIS Online |
| Gefunden in Version | 9.2 |
| Betriebssystem | Windows OS |
| Betriebssystemversion | 10.0 |
| Status | As Designed |
Zusätzliche Informationen
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.Workaround
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.
Schritte zur Reproduzierung
Bug-ID: BUG-000143171
Software:
- ArcGIS Online
Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert
Weitere Informationen zu diesem Thema erkunden
Nach zugehörigen Informationen suchen
Nach Schulungen zu diesem Thema suchen
Ideen erkunden und Feedback geben
Unterstützung durch ArcGIS-Experten anfordern
Esri Support App herunterladen