I'm trying to create a space-time cube with the aggregation shape type set to "defined location" (census tract boundaries). To do this, a unique Location ID is required which I have, but not in the correct format (required format: String, Numeric). I've tried creating a new field and changing the setting to the proper numeric format but I'm still unable to preserve the location ID values and preventing rounding.
Ex. location ID such as '5350007.01' either rounds to 5350007.00 or 5350007
How can I preserve the original formatting?
the space-time cube only recognizes string values for the 'Location ID'. the decimals get lost when stored in a long/short format and therefore lose their uniqueness. However, when I store the data as a double (numeric) the tool doesn't recognize the field.