Map visualisation

Get Help
1

Hi,

I have a SQL query returning GeoJSON points e.g.
{"type":"Point","coordinates":[-0.127607557822028,51.5101907537879]}

I can't seem to use the map visualisation on this.

Reading https://www.metabase.com/learn/visualization/maps#make-your-data-compatible-with-mapping it seems I need to "edit metadata"? I think this can only be done with static data, not with an ad-hoc query? Is this correct?
Please don't say "just create a database view".
Surely it should be possible to use any visualisation with any ad-hoc query? Why can't I just tell the visualisation "this is the latitude, this is the longitude"?

Many thanks

2

Hi @mausch
Metabase does not support the point column type:
https://github.com/metabase/metabase/issues/2327 - upvote by clicking :+1: on the first post
On newer versions of Metabase you can use the Map visualization even on SQL questions.