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
An overview of Little Navmap, an open-source flight planner for simulators, with setup instructions and technical details.
Exploring Vantor's open S3 bucket for satellite imagery, including setup, tools, and constellation details.
Analyzing an optimization solver for Airbus A380 seating arrangements to maximize airline revenue using Python and OR-Tools.
Analysis of open source aviation maps using FAA data, QGIS, and Python ETL tools.
Analysis of a 1.75B-record airport weather dataset using DuckDB and QGIS on a high-end workstation.
Analyzing 12,217 JPEGs from NASA's Artemis II mission using Python, DuckDB, and metadata tools on a high-end workstation.
Analysis of e-bike fleet data from Bird, Lime, and Neuron APIs using DuckDB and QGIS.
Analysis of 10K+ satellites using GCAT dataset, DuckDB, and QGIS on a high-end workstation.
Building a reverse geocoder using Overture Maps datasets to fetch country codes, addresses, and polygon data without API fees.
Review of the updated GM-SEUS dataset v2 with 3.4M solar panels and new rooftop arrays, including technical setup and analysis tools.
Converting French mobile network datasets into Parquet format using DuckDB and GDAL on a high-end workstation.
A technical walkthrough of converting Canada's wind turbine database to Parquet format and analyzing it using DuckDB, QGIS, and command-line tools.
A technical analysis of Overture Maps' latest Places dataset, covering over 72 million global points of interest, including setup and tools used.
Analysis of Microsoft's 2026 Global ML Building Footprints dataset, including technical setup and data exploration using DuckDB and QGIS.
Analyzing All The Places' open-source location data project, detailing the technical setup and process for downloading and examining millions of brand locations.
A technical analysis and comparison of various administrative boundary datasets, including OpenStreetMap, using Python, DuckDB, and QGIS.
Analyzing Business Insider's dataset on US data center locations, ownership, and resource consumption using Python, DuckDB, and QGIS.
A technical walkthrough of converting the US Wind Turbine Database to Parquet format and analyzing it using tools like GDAL, DuckDB, and QGIS.
A technical walkthrough of converting the massive OpenBuildingMap dataset (2.7B buildings) into a columnar Parquet format for efficient cloud analysis.
Analyzing Australia's coastal imagery using satellite data, Python, GDAL, DuckDB, and QGIS on a high-performance workstation.
