Mark Litwintschik is a Big Data, AI, GIS, and networking consultant with international experience, helping clients across the UK, USA, Europe, and beyond. He specializes in large-scale data analysis, geospatial insights, and technology consulting for major corporations and organizations.
97 articles from this blog
A technical review of the Clickgis extension, which adds WKB and GeoJSON geospatial support to the ClickHouse database.
A technical guide on using an LLM (Platypus2) with LangChain and pgvector to analyze YouTube's Procella database paper.
A tutorial on using Uber's H3 geospatial indexing system for clustering and visualization within DuckDB and QGIS.
A technical walkthrough of scraping and visualizing global airline passenger route data using Python, DuckDB, and QGIS.
A tutorial on creating a Python script to serve and stream videos with animated thumbnails from a local network using Python's http.server and other tools.
Overview of IPinfo's free IP geolocation database, its market context, and how it serves developers and businesses.
A technical overview of DuckDB's new Spatial extension, detailing its geospatial file format support, core dependencies, and setup process.
Exploring DuckDB's geospatial extensions and features for optimizing a large-scale fiber-optic network data pipeline.
A technical guide on importing and visualizing FlixBus's European GTFS transit data in PostgreSQL using pgRouting for route planning.
A technical guide on using ClickHouse to export PostgreSQL data to Parquet format for faster loading into Google BigQuery.
A technical tutorial on setting up the Valhalla routing engine to generate isochrone maps using OpenStreetMap data and QGIS.
A guide to using the Python wrapper for Apache ECharts to create and render interactive charts as static images.
A guide to using Python's Altair library for data visualization, comparing it to tools like Tableau, and showing setup and examples.
A tutorial on generating stylized maps in Python using the prettymaps library, OpenStreetMap data, and vsketch for rendering.
A technical tutorial on creating geographic heatmaps using Python, ClickHouse, QGIS, and Uber's H3 library with OpenCelliD cell tower data.
An overview and technical exploration of Poem, a feature-rich, Rust-based web framework, covering its setup, features, and examples.
A guide exploring the Axum web framework for Rust, covering its features, setup, and examples like a chat app.
A technical guide on setting up a secure, cost-effective file sharing system using Caddy Server and MinIO, including installation and configuration steps.
A technical guide on using geospatial data and cloud computing to optimize 5G network deployment, considering environmental factors like trees.
A technical guide on extracting Monaco's road network from OpenStreetMap, importing it into PostgreSQL/PostGIS, and rendering it with a tile server.
