pinmeto overture pmtiles

extract.sh

set -e
set -u

duckdb -c "
LOAD spatial;

SET s3_region='us-west-2';

COPY (
    SELECT
        'Feature' AS type,
        json_object(
            'type', 'Point',
            'coordinates', [ST_X(geometry), ST_Y(geometry)]
        ) as geometry,
        json_object(
            'id', id,
            'name', names.primary,
            'confidence', confidence,
            'socials', CAST(socials AS JSON)
        ) AS properties
    FROM read_parquet('s3://overturemaps-us-west-2/release/2025-05-21.0/theme=places/type=place/*', filename=true, hive_partitioning=1)
    WHERE list_has(list_transform(sources, x -> x.dataset), 'PinMeTo')
      AND geometry IS NOT NULL
) TO STDOUT (FORMAT json);
" | tippecanoe -o pinmeto-places-2025-05-21.pmtiles --force -l place -rg --drop-densest-as-needed --extend-zooms-if-still-dropping --maximum-tile-bytes=2500000 --progress-interval=10