Dominik Weckmüller do-me

Email: dominik at geo dot rocks

do-me / delete.py

Created February 12, 2026 09:40

Batch delete parquet files on root level on huggingface dataset (when accidentally pushed), leave anything else intact

-from huggingface_hub import HfApi, CommitOperationDelete, RepoFile
-# Configure your repo details
-repo_id = "user/repo"
-token = "your token" # Ensure your token has 'write' permissions
-api = HfApi(token=token)
-# 1. List files in the repo (non-recursive)
-files = api.list_repo_tree(repo_id, repo_type="dataset")

do-me / query.sql

Created January 30, 2026 15:50

Query AlphaEarth Embeddings Tiles, which ones to download for your AOI? Just use https://demo.duckui.com/

	INSTALL spatial;
	LOAD spatial;

	-- query for Milan, Italy
	SELECT *
	FROM 'https://data.source.coop/tge-labs/aef/v1/annual/aef_index.parquet'
	WHERE wgs84_west <= 9.25
	AND wgs84_east >= 9.10
	AND wgs84_south <= 45.55
	AND wgs84_north >= 45.40

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)