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.

tip

Overture's S3 bucket is located in the us-west-2 AWS region, so use us-west-2 for best performance.

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​

Now 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_07_22_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_07_22_0
WHERE theme='places'
    AND type='place'
    AND bbox.xmin > -122.44
        AND bbox.xmax < -122.25
        AND bbox.ymin > 47.56
        AND bbox.ymax < 47.71

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

Last updated on