Skip to content

Instantly share code, notes, and snippets.

@do-me

do-me/extract.sql

Created November 10, 2025 13:02
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save do-me/7f50f4c3b8640e3fcb2a7aca765afbd1 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save do-me/7f50f4c3b8640e3fcb2a7aca765afbd1 to your computer and use it in GitHub Desktop.
Download ZIP
Extract regional boundaries from osm us layercake with duckdb -ui
Raw
extract.sql
COPY (
SELECT *
FROM 'https://data.openstreetmap.us/layercake/boundaries.parquet'
WHERE list_contains("tags"['name'], 'Sicilia')
OR list_contains("tags"['names']['en'], 'Sicily')
) TO 'sicily_boundaries.parquet' (FORMAT 'PARQUET');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment