After joining the datasets, the latitude-longitude value changes.
Before joining, the datasets have normal latitude values, but after joining the
table after joining the datasets, the latitude value is divided by 1000.
The value used in the join is not the latitude, is this a bug?
Below is an example of the values in the table before the JOIN.
@daverboy After joining, check if the latitude and longitude cols have data type as latitude and longitude instead of something else(like float). In my case, after joining the data type changed to float but when I changed it back to lat and long, it worked fine.
I was able to add a non /1000 latitude field in a similar way to the one you attached, but it’s not a fundamental solution, so I’m opening a case with AWS Support Center to look into the issue.
