I have a basic pin map generated from a SQL query. I have double-checked that it is set up correctly, and have verified the latitude and longitude of addresses that are in the query compared to google maps. We have users with lat and long from Colorado that are showing up in Oregon and Washington. For example, a user has lat and long of [38.88,-104.72] that is showing up in Oregon.
Please post "Diagnostic Info" from Admin > Troubleshooting.
And can you reproduce by doing something like this (adjust with your examples), if you cannot provide more exact example or screenshots:
select 38.88 as lat, -104.72 as long, 1 as test union all select 36, -115, 2
Here are screenshots of what I'm seeing, along with an example.http://nextstep-metabase.herokuapp.com/public/question/48ede563-a3e0-40cd-9268-223cf022a9cd