Dominik Weckmüller do-me

Email: dominik at geo dot rocks

do-me / load_data.sql

Created January 28, 2026 13:35

Simple DuckUI query with duckdb wasm to HF with filters

	SELECT
	*
	FROM 'hf://datasets/do-me/EUR-LEX/*/.parquet'
	WHERE
	-- 1. Date filter (highly efficient for narrowing down files/rows)
	CAST(date AS DATE) >= '2026-01-21'

	-- 2. Your specific keywords (case-insensitive)
	--AND regexp_matches(text, '(?i)copernicus\|earth observation')
	ORDER BY date DESC

do-me / clone.sh

Created January 27, 2026 16:14

Clone repo from Huggingface with hf cli via uvx, excluding one directory

	rm -rf ~/.cache/huggingface/.gitignore.lock;

	HF_HUB_READ_TIMEOUT=300 HF_HUB_HTTP_TIMEOUT=300 uvx hf download \
	EuropeanParliament/Eurovoc_2025 \
	--repo-type dataset \
	--exclude "files/*" \
	--local-dir .

do-me / main.py

Created January 21, 2026 11:50

simple uv template for inline deps for running scripts with uv run main.py

do-me / init.sh

Last active January 21, 2026 10:02

Initialize new github repo locally from git repo

gh repo create new_project_name --public --source=. --remote=origin --push

do-me / switched.md

Created January 17, 2026 14:44

Switched lat lon for Germany

What does it look like if you switch lat lon for Germany?

do-me / index.html

Created January 4, 2026 17:29

supabase guest form

	<!doctype html>
	<html lang="en" class="bg-slate-50">
	<head>
	<meta charset="UTF-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0" />
	<title>Guest List Manager</title>
	<!-- 1. Tailwind CSS via CDN -->
	<script src="https://cdn.tailwindcss.com"></script>
	<!-- 2. Supabase Client via CDN -->
	<script src="https://cdn.jsdelivr.net/npm/@supabase/supabase-js@2"></script>

do-me / convert.py

Created December 30, 2025 16:58

DuckDB spatial convert normal geoparquet to lat lon

	import duckdb

	con = duckdb.connect()
	con.execute("INSTALL spatial; LOAD spatial;")

	input_path = '30M_sample_index.parquet'
	output_path = '30M_sample_index_with_lat_lon.parquet'

	# Use ST_X and ST_Y directly on the 'geometry' column
	con.execute(f"""

do-me / duckdb_boundary.sh

Last active November 11, 2025 15:20

Filter OSM US Layercake boundary.parquet remotely over DuckDB and export e.g. a region to e.g. a parquet or json file.

	#!/usr/bin/env bash
	#
	# duckdb_boundary.sh — run DuckDB spatial queries by region
	#
	# Usage:
	# ./duckdb_boundary.sh --query "Sicilia" [--format PARQUET\|CSV\|JSON]
	#
	# Description:
	# - Ensures DuckDB 'spatial' extension is installed and loaded
	# - Reads OpenStreetMap boundary data (remote parquet)

do-me / extract.sql

Created November 10, 2025 13:02

Extract regional boundaries from osm us layercake with duckdb -ui

	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');

do-me / script.sh

Created November 10, 2025 09:44

OSM: From .osm.pbf to parquet file with all streets for a region

	osmium extract -b 12.2,36.5,15.8,38.8 italy.osm.pbf -o sicily.osm.pbf --overwrite;

	osmium tags-filter sicily.osm.pbf w/highway -o sicily_streets.osm.pbf --overwrite;

	ogr2ogr -f Parquet -oo PRELUDE_STATEMENTS="INSTALL spatial; LOAD spatial;" \
	sicily_streets.parquet sicily_streets.osm.pbf lines;