Skip to main content

Athena (AWS)

You can follow the steps belows to access and query Overture data directly in AWS. Note: you will need to create an account to use Athena and other AWS services.

info

Overture's S3 bucket is located in the us-west-2 AWS region, so you will need to set your region to us-west-2.

1. Add Overture as a data source

Add Overture as a cross-account data source using these instructions. The Catalog ID is 913550007193.

AWS Glue Data Catalog

AWS Glue Catalog

Depending on the permissions attached to your AWS user account/role, you may need to explicitly enable access to the Overture catalog. You can do that by adding a new IAM policy — we suggest calling it OvertureGlueCatalogAccess — with the following permissions:

IAM policy for Overture Glue Data Catalog access
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"glue:GetTable*",
"glue:GetDatabase*",
"glue:GetPartition*"
],
"Resource": [
"arn:aws:glue:us-west-2:913550007193:catalog",
"arn:aws:glue:us-west-2:913550007193:database/release",
"arn:aws:glue:us-west-2:913550007193:table/*"
]
}
]
}

2. Inspect release tables

Each release is available as a table under the release database in the overture data source (note the v at the beginning of the table name). The overture data catalog will be updated with a new table for each new release.

Overture Maps release tables

Release Tables

3. Access data from a release table

You can access Overture data in a particular release like this:

SELECT *
FROM overture.release.v2024_09_18_0
LIMIT 10

Here's an example query to get ~25k places in Seattle:

SELECT
id,
names,
addresses,
categories,
confidence,
sources,
ST_GEOMFROMBINARY(geometry) AS geometry
FROM
overture.release.v2024_09_18_0
WHERE type='place'
AND bbox.xmin BETWEEN -122.44 AND -122.25
AND bbox.ymin BETWEEN 47.56 AND 47.71

More information on using Athena is available in the Amazon Athena User Guide.