Visualize location and IP data

Visualize IP addresses, airports, cities, and countries on a map using our built-in location mapping.

Create your first map chart

1. Create a new chart and select Chart -> Map in right sidebar.

2. Pick a numeric column to visualize on the map and drag it to Value.

3. Drag an IP address or other location column to Location.

You should see your IP addresses rendered on a map below.

Create a map chart using SQL

Here's an SQL example visualizing CloudFlare request rate by location:

SELECT
  avgMerge(rate_avg) AS value,
  location(label('colo')) AS location
FROM {{source}}
WHERE
  name = 'cloudflare_zone_colocation_requests_total'
  AND dt BETWEEN {{start_time}} AND {{end_time}}
GROUP BY location

Want to show IPs on the map?

Open the right sidebar on your chart and select Data -> Location label -> Original value. Now, the tooltips will show your data directly instead of the closest city.

Derive the ASN from an IP address

Use the IPToAsn function to look up the autonomous system that owns an IP address. It returns a tuple of the ASN number and the organization name.

SELECT IPToAsn('8.8.8.8') AS asn

This returns (15169,'Google LLC'). Use asn.1 for the number and asn.2 for the name to work with them as separate columns.

Need help?

Please let us know at hello@betterstack.com.
We're happy to help! 🙏