I am using Longitude and Latitude to create spatial points to match up with US census shapefiles. I have done this in a different workflow and I was able to get this to work when I converted the Lon and Lat to the double data type. However, when I do this for this data set, which is the exact same type of file just much bigger, this doesn't work. The conversion error reported is "Lon is not a valid number" and "Lat is not a valid number."
My first thought was to try some other data types. So I tried using int64, float, and fixed decimal. But all of these also return errors. Fixed decimal returns that it has truncated some of the data as the value was too large. Float returns the same as double. Finally, int64 returns a bunch of different individual Lon and Lat saying that information was lost in translation and then finally that the field conversion error limit reached.
So what other data types should I try? Is there one that makes more sense for a Lon and Lat? Is there something I could change about how things are inputted that would work correctly? I have checked with the other flow that I have worked with and I can't find anything that would distinguish that one from this new one.
