I recently used the Spatial Join tool to join 2 point files of X/Y, Lat/Long values, one being Weather Stations, the other Zip Code Centroids. The files had an angular unit of Degree (decimal degree, I am guessing/hoping?) The distance field was in a decimal format.
I would like to be able to convert this 6 digit number into miles, but am in the dark as to what conversion factor do I use. I can easily draw a line between a Weather Station and a Zip Code Centroid in miles, but how to convert the value in the Distance field is mystifying.
Sorry but no dice either on that. I added the table of zip code centroids, gave it a Projection of State Plane California in feet, and reprojected the file of weather stations into the same, and I'm still getting these weird numbers in the Distance field. Ideally i'd like to have the Distance field units be in miles, and I guess I could do a Field Calculator equation which converts feet into miles (x feet * 43360), but that still doesnt' seem right. I don't think there's a projection that has miles in it for units.
I've attached a jpg of the current table for the Spatial Join file. The Data Frame's Display Units are in miles, the projected coordinate system for both Zip and Stations is NAD_1983_StatePlane_California_III_FIPS_0403_Feet.