Overture Maps Divisions

Product Details

Visibility: Public
Owner: Carl Boettiger
Created: 17 Jun 2026
Last Updated: 17 Jun 2026

Product Contents

root

README

Overture Maps Divisions

Global administrative boundaries (countries, regions/states, counties/districts) from the Overture Maps Foundation Divisions theme. Processed into cloud-native formats with an English-language name column added.

Current release: 2026-02-18.0

Datasets

Dataset	Features	PMTiles	Parquet
Countries	219	countries.pmtiles	countries.parquet
Regions	3,908	regions.pmtiles	regions.parquet
Counties	38,833	counties.pmtiles (~150MB)	counties.parquet

Key Column: `name_en`

The name_en column provides English-language names for all features:

This falls back to the primary (native-language) name when no English translation is available. Use name_en for English-language queries; use names.primary for local-language display.

License

CDLA Permissive 2.0 — free to use with attribution to Overture Maps Foundation.

DuckDB Examples

MapLibre GL JS Example

PMTiles source-layer names: countries, regions, counties (matches the dataset name).

H3 Hex Parquet

Hex-partitioned parquet for spatial aggregation and joins, hive-partitioned by h0 cell:

H3 resolution 10 with parent resolutions 9, 8, 0. Hex columns: h10, h9, h8, h0 (UBIGINT).

Update Pipeline

To update to a new Overture Maps release:

Check for new releases:
Find the correct parquet file URL for the new release by listing the divisions directory at the new release URL. The filename (UUID) changes with each release.
Edit the preprocessing job (catalog/overturemaps/k8s/preprocess-<VERSION>.yaml):
- Update RELEASE variable
- Update SOURCE URL with new filename
Run preprocessing to extract countries/regions/counties from the raw release:
Generate workflow YAMLs (with version prefix in dataset name):
Note: Replace dots in version string with dashes in job names (e.g., 2026-02-18.0 → om-2026-XX-YY-Z) because Kubernetes pod names cannot contain dots.
Apply sequentially (one at a time due to 200-pod namespace quota):

README

Overture Maps Divisions

Current release: 2026-02-18.0

Datasets

Dataset	Features	PMTiles	Parquet
Countries	219	countries.pmtiles	countries.parquet
Regions	3,908	regions.pmtiles	regions.parquet
Counties	38,833	counties.pmtiles (~150MB)	counties.parquet

Key Column: `name_en`

The name_en column provides English-language names for all features:

This falls back to the primary (native-language) name when no English translation is available. Use name_en for English-language queries; use names.primary for local-language display.

License

CDLA Permissive 2.0 — free to use with attribution to Overture Maps Foundation.

DuckDB Examples

MapLibre GL JS Example

PMTiles source-layer names: countries, regions, counties (matches the dataset name).

H3 Hex Parquet

Hex-partitioned parquet for spatial aggregation and joins, hive-partitioned by h0 cell:

H3 resolution 10 with parent resolutions 9, 8, 0. Hex columns: h10, h9, h8, h0 (UBIGINT).

Update Pipeline

To update to a new Overture Maps release:

Check for new releases:
Find the correct parquet file URL for the new release by listing the divisions directory at the new release URL. The filename (UUID) changes with each release.
Edit the preprocessing job (catalog/overturemaps/k8s/preprocess-<VERSION>.yaml):
- Update RELEASE variable
- Update SOURCE URL with new filename
Run preprocessing to extract countries/regions/counties from the raw release:
Generate workflow YAMLs (with version prefix in dataset name):
Note: Replace dots in version string with dashes in job names (e.g., 2026-02-18.0 → om-2026-XX-YY-Z) because Kubernetes pod names cannot contain dots.
Apply sequentially (one at a time due to 200-pod namespace quota):

1s3://public-overturemaps/2026-02-18.0/countries/hex/h0={cell}/data_0.parquet
2s3://public-overturemaps/2026-02-18.0/regions/hex/h0={cell}/data_0.parquet
3s3://public-overturemaps/2026-02-18.0/counties/hex/h0={cell}/data_0.parquet

1s3://public-overturemaps/2026-02-18.0/countries/hex/h0={cell}/data_0.parquet
2s3://public-overturemaps/2026-02-18.0/regions/hex/h0={cell}/data_0.parquet
3s3://public-overturemaps/2026-02-18.0/counties/hex/h0={cell}/data_0.parquet

1name_en = COALESCE(names.common['en'], names.primary)

1name_en = COALESCE(names.common['en'], names.primary)

1-- Install spatial extension (once)
2INSTALL httpfs; INSTALL spatial;
3LOAD httpfs; LOAD spatial;
4
5-- Query countries by English name
6SELECT id, name_en, country, population
7FROM read_parquet('https://s3-west.nrp-nautilus.io/public-overturemaps/2026-02-18.0/countries.parquet')
8WHERE name_en = 'Brazil'
9LIMIT 5;
10
11-- Find all US states/regions
12SELECT id, name_en, region, population
13FROM read_parquet('https://s3-west.nrp-nautilus.io/public-overturemaps/2026-02-18.0/regions.parquet')
14WHERE country = 'US'
15ORDER BY name_en;
16
17-- Find counties in California
18SELECT id, name_en, region, population
19FROM read_parquet('https://s3-west.nrp-nautilus.io/public-overturemaps/2026-02-18.0/counties.parquet')
20WHERE region = 'US-CA'
21ORDER BY population DESC;
22
23-- Spatial join: which county is a point in?
24SELECT c.name_en AS county, c.region
25FROM read_parquet('https://s3-west.nrp-nautilus.io/public-overturemaps/2026-02-18.0/counties.parquet') c
26WHERE ST_Contains(c.geometry, ST_Point(-122.4194, 37.7749));  -- San Francisco

1-- Install spatial extension (once)
2INSTALL httpfs; INSTALL spatial;
3LOAD httpfs; LOAD spatial;
4
5-- Query countries by English name
6SELECT id, name_en, country, population
7FROM read_parquet('https://s3-west.nrp-nautilus.io/public-overturemaps/2026-02-18.0/countries.parquet')
8WHERE name_en = 'Brazil'
9LIMIT 5;
10
11-- Find all US states/regions
12SELECT id, name_en, region, population
13FROM read_parquet('https://s3-west.nrp-nautilus.io/public-overturemaps/2026-02-18.0/regions.parquet')
14WHERE country = 'US'
15ORDER BY name_en;
16
17-- Find counties in California
18SELECT id, name_en, region, population
19FROM read_parquet('https://s3-west.nrp-nautilus.io/public-overturemaps/2026-02-18.0/counties.parquet')
20WHERE region = 'US-CA'
21ORDER BY population DESC;
22
23-- Spatial join: which county is a point in?
24SELECT c.name_en AS county, c.region
25FROM read_parquet('https://s3-west.nrp-nautilus.io/public-overturemaps/2026-02-18.0/counties.parquet') c
26WHERE ST_Contains(c.geometry, ST_Point(-122.4194, 37.7749));  -- San Francisco

1const map = new maplibregl.Map({ /* ... */ });
2
3map.on('load', () => {
4  // Countries layer
5  map.addSource('overture-countries', {
6    type: 'vector',
7    url: 'pmtiles://https://s3-west.nrp-nautilus.io/public-overturemaps/2026-02-18.0/countries.pmtiles'
8  });
9  map.addLayer({
10    id: 'countries-fill',
11    type: 'fill',
12    source: 'overture-countries',
13    'source-layer': 'countries',   // <-- always "countries" for this dataset
14    paint: {
15      'fill-color': '#4CAF50',
16      'fill-opacity': 0.3
17    }
18  });
19
20  // Counties layer
21  map.addSource('overture-counties', {
22    type: 'vector',
23    url: 'pmtiles://https://s3-west.nrp-nautilus.io/public-overturemaps/2026-02-18.0/counties.pmtiles'
24  });
25  map.addLayer({
26    id: 'counties-line',
27    type: 'line',
28    source: 'overture-counties',
29    'source-layer': 'counties',    // <-- always "counties" for this dataset
30    paint: {
31      'line-color': '#333',
32      'line-width': 0.5
33    }
34  });
35});

1const map = new maplibregl.Map({ /* ... */ });
2
3map.on('load', () => {
4  // Countries layer
5  map.addSource('overture-countries', {
6    type: 'vector',
7    url: 'pmtiles://https://s3-west.nrp-nautilus.io/public-overturemaps/2026-02-18.0/countries.pmtiles'
8  });
9  map.addLayer({
10    id: 'countries-fill',
11    type: 'fill',
12    source: 'overture-countries',
13    'source-layer': 'countries',   // <-- always "countries" for this dataset
14    paint: {
15      'fill-color': '#4CAF50',
16      'fill-opacity': 0.3
17    }
18  });
19
20  // Counties layer
21  map.addSource('overture-counties', {
22    type: 'vector',
23    url: 'pmtiles://https://s3-west.nrp-nautilus.io/public-overturemaps/2026-02-18.0/counties.pmtiles'
24  });
25  map.addLayer({
26    id: 'counties-line',
27    type: 'line',
28    source: 'overture-counties',
29    'source-layer': 'counties',    // <-- always "counties" for this dataset
30    paint: {
31      'line-color': '#333',
32      'line-width': 0.5
33    }
34  });
35});

1aws s3 ls s3://overturemaps-us-west-2/release/ --no-sign-request

1aws s3 ls s3://overturemaps-us-west-2/release/ --no-sign-request

1kubectl apply -f catalog/overturemaps/k8s/preprocess-<VERSION>.yaml

1kubectl apply -f catalog/overturemaps/k8s/preprocess-<VERSION>.yaml

1for subtype in countries regions counties; do
2  cng-datasets workflow \
3    --dataset <VERSION>/$subtype \
4    --source-url s3://public-overturemaps/<VERSION>/$subtype.parquet \
5    --bucket public-overturemaps \
6    --h3-resolution 10 --parent-resolutions "9,8,0" \
7    --hex-memory 32Gi --max-completions 200 --max-parallelism 50 \
8    --output-dir catalog/overturemaps/k8s/<VERSION>/$subtype
9done

1for subtype in countries regions counties; do
2  cng-datasets workflow \
3    --dataset <VERSION>/$subtype \
4    --source-url s3://public-overturemaps/<VERSION>/$subtype.parquet \
5    --bucket public-overturemaps \
6    --h3-resolution 10 --parent-resolutions "9,8,0" \
7    --hex-memory 32Gi --max-completions 200 --max-parallelism 50 \
8    --output-dir catalog/overturemaps/k8s/<VERSION>/$subtype
9done

1kubectl apply -f catalog/overturemaps/k8s/<VERSION>/countries/configmap.yaml \
2              -f catalog/overturemaps/k8s/<VERSION>/countries/workflow.yaml
3kubectl wait job/om-<VERSION>-countries-workflow --for=condition=complete --timeout=7200s -n biodiversity
4# repeat for regions, counties

1kubectl apply -f catalog/overturemaps/k8s/<VERSION>/countries/configmap.yaml \
2              -f catalog/overturemaps/k8s/<VERSION>/countries/workflow.yaml
3kubectl wait job/om-<VERSION>-countries-workflow --for=condition=complete --timeout=7200s -n biodiversity
4# repeat for regions, counties

Overture Maps Divisions

Overture Maps Divisions

Overture Maps Divisions

Datasets

Key Column: name_en

License

DuckDB Examples

MapLibre GL JS Example

H3 Hex Parquet

Update Pipeline

Overture Maps Divisions

Datasets

Key Column: name_en

License

DuckDB Examples

MapLibre GL JS Example

H3 Hex Parquet

Update Pipeline

Key Column: `name_en`

Key Column: `name_en`