OvertureMaps / OvertureMaps/stac
[FEATURE] Embed DuckDB SQL macros in STAC catalog metadata
Open
@jjcfrancisco is already working on this.
Since May 26, 2026.
- Dominant language
- Rust
- Stars
- 39
- Forks
- 3
- Avg merge
- 4d 18m
- Merged PRs (30d)
- 7
Description
Background
Querying Overture via DuckDB requires knowing the exact S3 release path.
labs.overturemaps.org/data/latest.ddb solves this with pre-built views,
but it's a separate artifact that must be regenerated each release.
Proposal
Add a duckdb field to the STAC catalog JSON with SQL that creates one view
per type pointing at the correct S3 paths:
curl https://stac.overturemaps.org/catalog.json | jq -r .duckdb | duckdb overture.db -c -
# then: SELECT * FROM place;
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.