Bug
A DBF file with numeric fields with a fixed length of five and no decimals are interpreted by ArcMap as a short integer. This causes all values greater than 32717 to have 65536 subtracted, resulting in an incorrect (and negative) value within the attribute table. However, the correct values are still visible in the DBF file.
| Bug ID Number | BUG-000087438 |
|---|---|
| Submitted | May 5, 2015 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS for Desktop |
| Version found | 10.3 |
| Operating System | Windows OS |
| Operating System Version | 7 |
| Status | Will Not Be Addressed |
Additional Information
We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.Workaround
1. Add a field of type long integer. 2. Sort desired original column in an ascending order. 3. Select all negative values. 4. Calculate the value of the paired new column to be equal to “[original column value] + 65536”. 5. Repeat for all three affected columns. 6. View the DBF portion of the shapefile in Excel to verify the matching of the data between the original and the new columns.Steps to Reproduce
Bug ID: BUG-000087438
Software:
- ArcGIS for Desktop
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App