Pin Map in Metabase not Showing pins

I am trying to make Pin Map visualization based by Longitude and Latitude in Metabase, I use custom query to do so that run with this:

SELECT
    transaction_loc_latitude,
    transaction_loc_longitude,
    CAST(transaction_loc_latitude AS DECIMAL(17, 15)) AS latitude,
    CAST(transaction_loc_longitude AS DECIMAL(56, 15)) AS longitude
FROM
    mrg_merchant_transaction_2020_10
WHERE
    transaction_loc_longitude IS NOT NULL
    AND transaction_loc_latitude IS NOT NULL
    AND transaction_loc_longitude NOT IN ('0', '0.0', '0.00000000', '00')
    AND transaction_loc_latitude NOT IN ('0', '0.0', '0.00000000')

And here is query results with the screenshot:

7HCIx

After this, I am sure that the longitude and latitude is already decimal, and then I set it in the corresponding fields

p4uYr

But the map didn't show any pins:

How to make the pin appear? am I still miss something in the query? Thanks in Advance

1 Like

Hi @vangz
There’s currently an issue, when using Native query and returning more than 1000 pins:
https://github.com/metabase/metabase/issues/4394 - upvote by clicking :+1: on the first post

1 Like

I See :slight_smile: thankyou for the confirmation, upvoted it