Sql Query of coordinates populate in map

App Building
1

I have a sql query that returns latitude and longitude. I need to populate the points on the map with this data.

2

Hey @nroeder!

The map component has a "Points" field that you can pass latitude/longitude data to:

Since you're running this from a SQL query you might want to do something like using _.pick to grab just the latitude and longitude columns and then formatting the data as an array:

{{formatDataAsArray(_.pick(get_environment.data, ['latitude', 'longitude']))}}

Let me know if that works!

The map component also supports GeoJSON which can be useful for more advanced styling.

3

4 posts were split to a new topic: Formatting data from a SQL query to pass into the Mapbox Map compenent's Points field

4