Points on map are not showing correct location

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.

Hi @nextstepjae
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.


@nextstepjae Okay, so you're seeing this issue:
https://github.com/metabase/metabase/issues/18063 - upvote by clicking :+1: on the first post
You can get the right tooltips by filtering out all your null latitude/longitude positions.