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.
100 articles from this blog
An overview of the VVC (H.266) video encoding standard, its improvements over H.265, and a technical guide for encoding and analyzing VVC files with FFmpeg and Python.
A technical guide on using Meta AI's Segment Anything model to perform object segmentation on satellite imagery from Maxar.
A review of Esri's Spatial Data Science MOOC, covering the history of GIS, ArcGIS Pro's features, and the author's training experience.
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.
