BUG-000118946 for ArcGIS Business Analyst Pro

Numéro d’ID de bogue	BUG-000118946
Envoi	December 19, 2018
Dernière modification	April 2, 2025
S’applique à	ArcGIS Business Analyst Pro
Version trouvée	2.2
Système d’exploitation	Windows OS
Version du système d’exploitation	10.0 64 Bit
Statut	Will Not Be Addressed

Informations supplémentaires

Closing "as designed". IDs in the US dataset are numeric but are stored as strings and have leading zeroes. For example, the zip code 08701 is stored as ‘08701' in the data, but it becomes 8701 in a numeric field and does not match the real standard geography unit. So the error is expected when using non-text IDs.

Solution de contournement

To convert a long integer data to a text, import the table to a file geodatabase, add a new text field, and calculate the geography key values from the original numeric field to the newly added text field.

Converting Geography Key Values to Text

Close the attribute table, right-click the attribute table in the Contents pane, select Data, and Export Table.
This opens the Copy Rows geoprocessing tool. By default, the Output Table location is the project’s home file geodatabase.
Accept this default and click Run.
The new file geodatabase table is added to the Contents pane.
Right-click the new table and select Open.
With the table open, click Add to add a new file.
Name the new field and set the data type to Text.
Click the Save button on the ribbon to save the changes and then close the fields view to return to the attribute table.
Right-click the header of the newly created field and click Calculate Field.
Under Expressions, double-click the field originally used as the geography key field to add the values to the new field as text.
Once the field is populated, re-run the tool with the newly added text field selected as the geography key.