Kamil Raczycki RaczeQ

🌍

Crafting new Open Source tools 🔮

Geospatial 🌍 Data Wizard 🧙‍♂️ & Scientist 🔬

RaczeQ / Snowflake_OvertureMaps_Pubs.sql

Last active January 19, 2026 10:29

Which three places in the UK have the highest density of pubs?

	-- Select all pubs in the Great Britain and calculate how many pubs are in a 5 km radius around each pub.

	WITH pubs AS (
	-- irish_pub....................................eat_and_drink > bar > irish_pub
	-- pub..........................................eat_and_drink > bar > pub
	SELECT
	id,
	JSON_EXTRACT_PATH_TEXT(names, 'primary') as name,
	JSON_EXTRACT_PATH_TEXT(categories, 'primary') as category,
	confidence,

RaczeQ / Snowflake_OvertureMaps_Buildings.sql

Created January 13, 2026 07:56

Count number of buildings near green areas (600 meters) for Berlin, London and Paris

	WITH division_ids AS (
	SELECT
	id,
	CASE
	WHEN country = 'DE' THEN 'Berlin'
	WHEN country = 'FR' THEN 'Paris'
	ELSE 'London'
	END as city_name
	FROM
	OVERTURE_MAPS__DIVISIONS.CARTO.DIVISION

RaczeQ / london_traces_deckgl_animation.html

Last active November 25, 2025 05:46


	<!doctype html>
	<html lang="en">
	<head>
	<meta charset="utf-8" />
	<title>Trip animation – sequences (deck.gl + MapLibre)</title>
	<meta name="viewport" content="width=device-width,initial-scale=1" />
	<link href="https://unpkg.com/[email protected]/dist/maplibre-gl.css" rel="stylesheet" />
	<!-- <link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons" /> -->
	<script src="https://unpkg.com/[email protected]/dist/maplibre-gl.js"></script>

RaczeQ / pyarrow_multiprocessing_streaming.py

Last active May 19, 2024 19:41

Pyarrow Multiprocessing with streaming the result