Astrato Map
Piers Batchelor avatar
Written by Piers Batchelor
Updated over a week ago

Contents:


Preparing geo data

Our map supports multiple input formats for geo data. See the table below to learn what is supported.

Type

Example

Format

SQL (tested in Snowflake)

Geocode

[48.5701099999999997 , 34.7904899999999984]

[longitude, latitude]

SELECT
CONCAT('[', longitude, ',', latitude, ']') as GEOCODE
FROM MY_TABLE;

Longitude & Latitude

48.5701099999999997

34.7904899999999984

ℹ 1 field for each

SELECT
longitude, latitude
FROM MY_TABLE;

9q9j8ue2v71y5zzy0s4q

Hash

SELECT ST_GEOHASH( TO_GEOGRAPHY('POINT(-122.306100 37.554162)')) AS geohash_of_point_a;

Configuring the map

Property

Function / Purpose

Dimension

(tooltip value)

Presented in the tooltip, this is what we use to group by when querying your data.

Location type

This is the location we use. This is an aggregation, for example with latitude/longiutude we can use min/max/average, which helps when working with different grains of location data.

Size

Pixels

Point size can be fixed, where the point size remains the same regardless of screen size. This can be variable based on using a measure.

Distance

Dynamic sizing, which will adjust as you zoom in and out of the map. For example, a point can be 5 km wide. This can be variable based on using a measure. This mode is responsive to zoom level.

Layers

Our map supports multiple layers to helpm you visualise your data in multiple ways at once.

Point Layer

Heatmap

The HeatMap layer visually represents data intensity and distribution, essential for spatial data analysis.

  • Visuals adjust dynamically with zoom levels and data point densities.

  • Cutomize color gradients and intensity, based on data values.

Filtering is not possible in this layer. Plese refer to point layer for use with filtering.

Cluster

The Cluster Marker plugin in Leaflet offers a customizable approach to group markers visually. It's designed for performance and flexibility, allowing for a diverse range of applications.

Map

This layer controls the map settings such as opacity.

Image

A custom image can be used to layer your own maps or even own markers on to the map, such as roads, paths, map updates, topography etc.


Known limitations

  • Global filtering is not yet supported in the map

  • Fixed point size can produce varying point size based on map projection

Did this answer your question?