Recent Comments
Category Archives: Howto
The blog is back
Well, that was scary. Just before I went on holiday I switched providers for my marcel-jan.eu domain. And while I had some time build in before going on vacation, there were problems with the transfer code not working. Because apparently … Continue reading
Adding the track of my bike ride on a Folium map
Having markers of videos and photos taken during my bike ride is cool and all, but how about having a track of the bike ride itself? All my bike rides are registered on Strava, the cycling and running app. Strava … Continue reading
Photo locations, marker icons and displaying photos on my map
When I was finished last week with creating my video location map in Python, I thought “shame I can’t plot photo locations”. That’s because my Fuji X-T30 camera doesn’t store GPS info. When I bought the camera I assumed every … Continue reading
Posted in Data engineering, Howto, Python
Tagged exif, Folium, glyphicon, jpg, media_gpsplot, object oriented, Python, video location map
Leave a comment
Making my video location map even better with Folium
Yesterday I shared how I plotted locations of videos shot with my Sony FDR-X3000 camera on a map. I was already pretty happy. Then I got a tip from Twitter user Bob Haffner (@bobhaffner): why not use Folium to create … Continue reading
Posted in Data engineering, Howto, Python
Tagged Folium, pandas, Sony FDR-X3000, zoomable map
Leave a comment
Plotting video locations from my Sony camera in Python
Two years ago I bought a Sony FDR-X3000 actioncam to record video on my bike rides. And I’m really happy about it. It’s just great reliving my rides in 4K, going downhill for kilometers from some col I climbed. I … Continue reading
Posted in Data engineering, Howto, Python
Tagged geodata, matplotlib, pandas, Sidecar, Sony FDR-X3000, XML, xmldom
Leave a comment
Gaining insights on my workout data with Apache Superset
For a few years I’ve been gathering data on my workouts. In Excel. It’s not exactly state of the art data architecture, but it was fine for a while. But data alone doesn’t do much. I wanted some questions answered. … Continue reading
Posted in Apache Products for Outsiders, Howto
Tagged Apache Superset, DATETIME, Docker, docker-compose, health data, PostgreSQL
Leave a comment
I built a working Hadoop-Spark-Hive cluster on Docker. Here is how.
TL;DR: I made a Docker compose that runs Hadoop, Spark and Hive in a multi-container environment. You can find the necessary files for it here: https://github.com/Marcel-Jan/docker-hadoop-spark [Update 2021-11-09: Since Docker Desktop turned “Expose daemon on tcp://localhost:2375 without TLS” off by … Continue reading
Posted in Howto, Spark
Tagged Apache Spark, Big Data Europe, DIKW, Docker, docker-compose, Hadoop, Hive
19 Comments
A humidity sensor network on a Raspberry Pi with Zigbee2MQTT
I was looking for a way to detect leakage in my appartement with some kind of IoT solution. Someone on the Dutch technology forum Tweakers.net told me Xiaomi Humidity sensors, combined with a Zigbee2MQTT might be a good fit. The … Continue reading
Posted in Howto
Tagged Domoticz, humidity sensors, Internet of Things, IoT, Raspberry Pi, Xiaomi Aqara, Zigbee2MQTT
Leave a comment
Neo4J: Loading rocket data in a graph database
When I first learned about graph databases, like Neo4J, I didn’t get it. That’s how I always start with new technology: not getting at all why people getting so enthusiastic about them. Then I read “Seven Databases in Seven Weeks, … Continue reading
Posted in Active Learning, Howto, NoSQL
Tagged Cypher, graph database, Jonathan's Space Page, Neo4J, Seven Databases in Seven Weeks
Leave a comment