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.
111 articles from this blog
A technical analysis of aircraft flight routes using ADS-B telemetry data, Python, and GIS tools, focusing on a specific AirBaltic Airbus A220-300.
Benchmarking ClickHouse's performance on a high-end Intel i9-14900K workstation using a 1.1 billion row NYC taxi trip dataset.
A benchmark analysis of DuckDB's performance on a massive 1.1 billion row NYC taxi dataset, comparing it to other database technologies.
A technical guide on creating a custom Tokyo walking tour map using GIS tools, QGIS, Python, and OpenStreetMap data.
A technical guide on extracting and analyzing OpenStreetMap (OSM) features using PBF files, DuckDB, and QGIS for data filtering.
A technical guide on analyzing global flight tracking data from ADS-B receivers using Python, DuckDB, and QGIS.
A technical guide on accessing, processing, and visualizing free LiDAR data, using Estonia's national scans as a practical example.
A technical guide to downloading, processing, and visualizing global geospatial datasets from the public domain Natural Earth project using tools like AWS S3, DuckDB, and QGIS.
A technical guide on accessing, downloading, and analyzing Maxar's freely available satellite imagery from their Open Data Programme using tools like GDAL, Python, and DuckDB.
An analysis of Overture Maps Foundation's open geospatial datasets, their creation process, and a technical guide for working with the data using Python and DuckDB.
A review of Esri's 'Imagery in Action' MOOC, covering satellite imagery analysis, drone mapping, and predictive modeling with ArcGIS tools.
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.
